1 files changed, 14 insertions, 0 deletions
diff --git a/modules/sqlite/example.js b/modules/sqlite/example.js
new file mode 100755
index 0000000..adc95c7
--- /dev/null
+++ b/modules/sqlite/example.js
@@ -0,0 +1,14 @@
+#!/usr/bin/env seed
+
+sqlite = imports.sqlite;
+
+d = new sqlite.Database(Seed.argv[2]);
+
+d.exec("create table t1 (t1key INTEGER PRIMARY KEY,data TEXT,num double,timeEnter DATE);");
+d.exec("insert into t1 (data,num) values ('This is sample data',3);");
+d.exec("insert into t1 (data,num) values ('More sample data',6);");
+d.exec("insert into t1 (data,num) values ('And a little more',9);");
+
+d.exec("select * from t1", function(results){print(JSON.stringify(results))});
+
+d.close();