README.md
1
2WIP: Sample SQL Queries
3/*
4
5create table "files" (
6"id" INTEGER PRIMARY KEY,
7"path" VARCHAR,
8"sha1" VARCHAR,
9);
10
11create table symbols (
12"file_id" INTEGER REFERENCES("files", "id") ON CASCADE DELETE,
13"offset" INTEGER,
14"embedding" VECTOR,
15);
16
17insert into "files" ("path", "sha1") values ("src/main.rs", "sha1") return id;
18insert into symbols (
19"file_id",
20"start",
21"end",
22"embedding"
23) values (
24(id,),
25(id,),
26(id,),
27(id,),
28)
29
30
31*/