sqlite

const (
	InsertTenantSQL = `
INSERT INTO tenants(id, name, created_at)
VALUES (?, ?, ?)
`

	TenantExistsSQL = `
SELECT EXISTS(SELECT 1 FROM tenants WHERE id = ?)
`

	CountTenantsSQL = `
SELECT COUNT(1) FROM tenants
`

	CountTenantMemoriesSQL = `
SELECT COUNT(1) FROM memories WHERE tenant_id = ?
`

	ListTenantMemoryCountsSQL = `
SELECT tenant_id, COUNT(1) AS memory_count
FROM memories
WHERE tenant_id IN (%s)
GROUP BY tenant_id
`

	ListTenantsSQL = `
SELECT id, name, created_at
FROM tenants
ORDER BY created_at DESC
LIMIT ?
`

	CountMemoriesSQL = `
SELECT COUNT(1) FROM memories
`

	InsertMemorySQL = `` /* 366-byte string literal not displayed */

	DeleteMemorySQL = `
DELETE FROM memories
WHERE tenant_id = ? AND id = ?
`

	SearchMemoriesSQL = `` /* 510-byte string literal not displayed */

	ListMemoriesRecentSQL = `` /* 347-byte string literal not displayed */

	InsertMemoryFTSSQL = `
INSERT INTO memory_fts(content, tenant_id, memory_id)
VALUES (?, ?, ?)
`

	DeleteMemoryFTSSQL = `
DELETE FROM memory_fts
WHERE tenant_id = ? AND memory_id = ?
`

	GetMemoriesByIDsBaseSQL = `` /* 314-byte string literal not displayed */

	FindMemoryByCanonicalKeySQL = `` /* 346-byte string literal not displayed */

	ListMemoriesBySourceTurnHashSQL = `` /* 487-byte string literal not displayed */

	InsertEntityFactSQL = `` /* 900-byte string literal not displayed */

	ListEntityFactsByEntityRelationSQL = `` /* 250-byte string literal not displayed */

	InvalidateEntityFactsByRelationSQL = `` /* 222-byte string literal not displayed */

	UpsertMemoryIndexJobSQL = `` /* 487-byte string literal not displayed */

	UpdateMemoryIndexJobStateSQL = `` /* 204-byte string literal not displayed */

	UpsertMemoryPostprocessJobSQL = `` /* 538-byte string literal not displayed */

	GetMemoryPostprocessJobIDSQL = `
SELECT id
FROM memory_postprocess_jobs
WHERE tenant_id = ?
  AND memory_id = ?
  AND job_type = ?
LIMIT 1
`

	GetMemoryPostprocessJobByIDSQL = `` /* 213-byte string literal not displayed */

	ListMemoryPostprocessJobsBaseSQL = `` /* 192-byte string literal not displayed */

	ListMemoryPostprocessJobIDsForClaimSQL = `` /* 198-byte string literal not displayed */

	MarkMemoryPostprocessJobClaimedSQL = `
UPDATE memory_postprocess_jobs
SET status = 'running',
	lease_owner = ?,
	leased_until = ?,
	updated_at = ?
WHERE id = ?
`

	MarkMemoryPostprocessJobSucceededSQL = `` /* 144-byte string literal not displayed */

	MarkMemoryPostprocessJobFailedSQL = `` /* 167-byte string literal not displayed */

)