memoria_orm_user_model_crud_operations_quickstart.ts

1import { 
2  Model, 
3  PrimaryGeneratedColumn, 
4  Column, 
5  Serializer, 
6  DB 
7} from "@memoria/model";
8
9// 1. Define your Model
10class User extends Model {
11  @PrimaryGeneratedColumn()
12  id: number;
13
14  @Column("varchar")
15  first_name: string;
16
17  @Column("varchar")
18  last_name: string;
19}
20
21// 2. Define a Serializer (Optional, but recommended)
22class UserSerializer extends Serializer {}
23
24async function runQuickstart() {
25  // 3. Initialize the Database (Memory by default)
26  await DB.resetRecords();
27
28  // 4. Create a record
29  let user = await User.insert({
30    first_name: "Izel",
31    last_name: "Nakri"
32  });
33
34  console.log("Inserted User:", user);
35
36  // 5. Find a record
37  let foundUser = await User.find(user.id);
38  console.log("Found User:", foundUser);
39
40  // 6. Update a record
41  let updatedUser = await User.update({
42    id: user.id,
43    first_name: "Izel-Updated"
44  });
45  console.log("Updated User:", updatedUser);
46
47  // 7. Delete a record
48  await User.delete(updatedUser);
49  console.log("User deleted successfully");
50}
51
52runQuickstart();