Reading Data

// Get all todos
const todos = await db.getAll('SELECT * FROM todos');

// Get a single todo
const todo = await db.get('SELECT * FROM todos WHERE id = ?', [todoId]);

// Watch for changes (reactive query)
const stream = db.watch('SELECT * FROM todos WHERE list_id = ?', [listId]);
for await (const todos of stream) {
  // Update UI when data changes
  console.log(todos);
}

// Get all todos
val todos = database.getAll("SELECT * FROM todos") { cursor ->
  Todo.fromCursor(cursor)
}

// Get a single todo
val todo = database.get("SELECT * FROM todos WHERE id = ?", listOf(todoId)) { cursor ->
  Todo.fromCursor(cursor)
}

// Watch for changes
database.watch("SELECT * FROM todos WHERE list_id = ?", listOf(listId))
  .collect { todos ->
    // Update UI when data changes
  }

// Get all todos
let todos = try await db.getAll(
  sql: "SELECT * FROM todos",
  mapper: { cursor in
    TodoContent(
      description: try cursor.getString(name: "description")!,
      completed: try cursor.getBooleanOptional(name: "completed")
    )
  }
)

// Watch for changes
for try await todos in db.watch(
  sql: "SELECT * FROM todos WHERE list_id = ?",
  parameters: [listId]
) {
  // Update UI when data changes
}

// Get all todos
final todos = await db.getAll('SELECT * FROM todos');

// Get a single todo
final todo = await db.get('SELECT * FROM todos WHERE id = ?', [todoId]);

// Watch for changes
db.watch('SELECT * FROM todos WHERE list_id = ?', [listId])
  .listen((todos) {
    // Update UI when data changes
  });

// Define a result type with properties matching the schema columns (some columns omitted here for brevity)
// public class TodoResult { public string id; public string description; public int completed; ... }

// Get all todos
var todos = await db.GetAll<TodoResult>("SELECT * FROM todos");

// Get a single todo
var todo = await db.Get<TodoResult>("SELECT * FROM todos WHERE id = ?", [todoId]);

// You can also query without specifying a type to get dynamic results:
dynamic asset = await db.Get("SELECT id, description, make FROM assets");
Console.WriteLine($"Asset ID: {asset.id}");