update index. add .gitignore and sample-cmd

zbryikt · zbryikt · commit 45781a105c77 · 2020-05-25T15:39:51.000+08:00
diff --git a/.gitignore b/.gitignore
@@ -0,0 +1 @@
+node_modules
diff --git a/package-lock.json b/package-lock.json
diff --git a/package.json b/package.json
@@ -8,7 +8,12 @@
   },
   "author": "Jeremy Apthorp <nornagon@nornagon.net>",
   "license": "MIT",
-  "keywords": ["sharedb", "sharejs", "share", "postgres"],
+  "keywords": [
+    "sharedb",
+    "sharejs",
+    "share",
+    "postgres"
+  ],
   "repository": "share/sharedb-postgres",
   "dependencies": {
     "pg": "^7.4.1",
diff --git a/sample-cmd b/sample-cmd
@@ -0,0 +1,16 @@
+/*var query = {
+  name: "sdb-commit-op-and-snap",
+  text: `
+    with snaps as (
+      insert into snapshots (collection, doc_id, doc_type, version, data)
+      values ($1, $2, $3, $4, $5)
+      on conflict (collection, doc_id, version) do update set doc_type = $3, data = $5
+    returning version
+    )
+    insert into ops ( collection, doc_id, version, operation )
+    values ($1, $2, $4, $6) on conflict (collection, doc_id, version) do update set operation = $6
+    returning version
+  `,
+  values: [collection, id, snapshot.type, snapshot.v, snapshot.data, op]
+}*/
+
diff --git a/structure.sql b/structure.sql
@@ -15,7 +15,7 @@ CREATE TABLE IF NOT EXISTS snapshots (
   PRIMARY KEY (collection, doc_id)
 );
 
-CREATE INDEX IF NOT EXISTS ops_version ON snapshots (collection, doc_id, version);
+CREATE INDEX IF NOT EXISTS snapshots_version ON snapshots (collection, doc_id);
 
 ALTER TABLE ops
   ALTER COLUMN operation
