arkilian-orm-js/db.ts at main · arkiliandb/arkilian-orm-js · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
import { Arkilian_orm } from "./src/index.ts";

// Schema is auto-loaded from ./bruv/schema.prisma
export const db = new Arkilian_orm({
  token: "2dwef",
  // localFile: "sample.sqlite",
  logging: false,
});

// Insert
await db.from("users").insert({
  name: "John Doe",
  email: "john@example.com",
  age: 99,
  country: "sourthanton",
});
const john = await db
  .from("users")
  .select("age , id, email, country, name")
  .where("email = ?", "john@example.com")
  .getOne();
console.log({ john });

// Update
await db
  .from("users")
  .where("id = ?", john.id)
  .update({ name: "Jane Doe" })
  .then((changes) => {
    // console.log({ changes });
  });

// Search
await db
  .from("users")
  .where("id = ?", 1)
  .andWhere("name LIKE ?", `%oh%`)
  .get()
  .then((changes) => {
    console.log({ changes });
  });

// Delete
// await db
//   .from("users")
//   .where("id = ?", 1)
//   .delete()
//   .then((changes) => {
//     // console.log({ changes });
//   });

// Get all users
db.from("users")
  .get()
  .then((changes) => {
    console.log({ changes });
  });

// Get one user
await db
  .from("users")
  .where("id = ?", 1)
  .getOne()
  .then((changes) => {
    console.log({ changes });
  });

// Select specific columns
await db
  .from("users")
  .select("id", "name")
  .get()
  .then((changes) => {
    console.log({ changes });
  });

// Where conditions
await db
  .from("users")
  .where("age > ?", 18)
  .get()
  .then((changes) => {
    console.log({ changes });
  });

// AndWhere conditions
await db
  .from("users")
  .where("age > ?", 18)
  .andWhere("country = ?", "USA")
  .get()
  .then((changes) => {
    console.log({ changes });
  });

// OrWhere conditions
await db
  .from("users")
  .where("age > ?", 18)
  .orWhere("country = ?", "Canada")
  .get()
  .then((changes) => {
    console.log({ changes });
  });

// Limit and Offset
await db
  .from("users")
  .limit(10)
  .offset(5)
  .get()
  .then((changes) => {
    console.log({ changes });
  });

// OrderBy
await db
  .from("users")
  .orderBy("name", "ASC")
  .get()
  .then((changes) => {
    console.log({ changes });
  });

await db
  .from("users")
  .orderBy("name", "ASC")
  .get()
  .then((changes) => {
    console.log({ changes });
  });