Expand description
Shared SQL document storage helpers for Valence SQL backends.
Constants§
- EDGES_
TABLE - Edge junction table shared by SQL backends.
- ID_
COLUMN - Primary key column name in SQL document tables.
Functions§
- assert_
safe_ table - create_
record_ postgres - create_
record_ sqlite - decode_
select_ rows - Parse SELECT results from generic JSON rows returned by driver layer.
- define_
unique_ index_ postgres - define_
unique_ index_ sqlite - delete_
record_ postgres - delete_
record_ sqlite - ensure_
edges_ postgres - ensure_
edges_ sqlite - ensure_
edges_ table - ensure_
table - Ensure a table exists (caller runs DDL via sqlx).
- ensure_
table_ postgres - ensure_
table_ sqlite - execute_
select_ postgres - execute_
select_ sqlite - extract_
ids - Extract id strings from SELECT id queries.
- first_
count - Extract count from first row.
- get_
edge_ targets - get_
edge_ targets_ postgres - get_
edge_ targets_ sqlite - get_
record_ postgres - get_
record_ sqlite - json_
merge - Shallow merge
patchintobase. - merge_
record_ postgres - merge_
record_ sqlite - prepare_
compiled - Normalize compiled query for SQLite execution (
?placeholders). - prepare_
compiled_ postgres - Normalize compiled query for Postgres execution (
$1,$2, … placeholders). - relate_
edge - relate_
edge_ postgres - relate_
edge_ sqlite - row_
from_ body - Build a JSON row object from stored body + id.
- row_
to_ json - Decode a SQL row
(id, body)into Valence JSON record shape. - sql_
capabilities - storage_
id - ttl_
deferred - unrelate_
edge - unrelate_
edge_ postgres - unrelate_
edge_ sqlite - update_
record_ postgres - update_
record_ sqlite - upsert_
body_ fields - Merge content fields into body map for insert/update.