smartdb_quickstart_schema_definition_crud_operations_json_storage.ts

1import { SmartDB, Schema } from 'smartdb';
2
3// Define the structure of your data
4interface User {
5  id: string;
6  name: string;
7  email: string;
8  age: number;
9}
10
11// Create a schema for the 'users' collection
12const userSchema: Schema<User> = {
13  id: { type: 'string', primary: true },
14  name: { type: 'string', required: true },
15  email: { type: 'string', unique: true },
16  age: { type: 'number' }
17};
18
19// Initialize SmartDB with a storage driver (defaults to memory/local file if configured)
20const db = new SmartDB({
21  name: 'my-database',
22  version: 1
23});
24
25async function quickstart() {
26  // Register the collection
27  const users = await db.collection<User>('users', userSchema);
28
29  // Insert a new record
30  await users.insert({
31    id: 'u1',
32    name: 'John Doe',
33    email: 'john@example.com',
34    age: 30
35  });
36
37  // Query data
38  const user = await users.findOne({ id: 'u1' });
39  console.log('Retrieved User:', user);
40
41  // Update data
42  await users.update({ id: 'u1' }, { age: 31 });
43
44  // List all records
45  const allUsers = await users.find();
46  console.log('All Users:', allUsers);
47}
48
49quickstart().catch(console.error);