first draft of sqlite wrapper HEAD main

1 files changed, 30 insertions, 2 deletions

diff --git a/src/main.rs b/src/main.rs
index 5b2e5a6..279e701 100644
--- a/src/main.rs
+++ b/src/main.rs
@@ -1,3 +1,31 @@
-fn main() {
-    println!("hello, world!");
+use wyrd_sqlite::Connection;
+
+fn main() -> anyhow::Result<()> {
+    let conn = Connection::open("")?;
+
+    conn.execute(
+        "CREATE TABLE pairs (
+            a INTEGER PRIMARY KEY,
+            b INTEGER
+        )",
+        (),
+    )?;
+
+    let (mut insert, _) = conn.prepare("INSERT INTO pairs (a, b) VALUES (?, ?)")?;
+
+    insert.execute((23, ()))?;
+    insert.execute((3, 33))?;
+    insert.execute(((), 5))?;
+
+    let (mut stmt, _) = conn.prepare("SELECT * FROM pairs")?;
+    let mut query = stmt.query(())?;
+
+    while let Some(mut row) = query.try_next_row()? {
+        let a: i32 = { row.get(0)? };
+        let b: Option<i32> = { row.get(1)? };
+
+        println!("{a}, {b:?}");
+    }
+
+    Ok(())
 }