From f5c4671bfbad96bf346bd7e9a21fc4317b4959df Mon Sep 17 00:00:00 2001
From: Indrajith K L
Date: Sat, 3 Dec 2022 17:00:20 +0530
Subject: Adds most of the tools

---
 v_windows/v/old/examples/database/sqlite.v | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100644 v_windows/v/old/examples/database/sqlite.v

(limited to 'v_windows/v/old/examples/database/sqlite.v')

diff --git a/v_windows/v/old/examples/database/sqlite.v b/v_windows/v/old/examples/database/sqlite.v
new file mode 100644
index 0000000..a3c7176
--- /dev/null
+++ b/v_windows/v/old/examples/database/sqlite.v
@@ -0,0 +1,22 @@
+import sqlite
+
+fn main() {
+	db := sqlite.connect(':memory:') ?
+	db.exec("create table users (id integer primary key, name text default '');")
+
+	db.exec("insert into users (name) values ('Sam')")
+	db.exec("insert into users (name) values ('Peter')")
+	db.exec("insert into users (name) values ('Kate')")
+
+	nr_users := db.q_int('select count(*) from users')
+	println('nr users = $nr_users')
+
+	name := db.q_string('select name from users where id = 1')
+	assert name == 'Sam'
+
+	users, code := db.exec('select * from users')
+	println('SQL Result code: $code')
+	for row in users {
+		println(row.vals)
+	}
+}
-- 
cgit v1.2.3