summaryrefslogtreecommitdiff
path: root/extension/examples/MyProject/src
diff options
context:
space:
mode:
Diffstat (limited to 'extension/examples/MyProject/src')
-rw-r--r--extension/examples/MyProject/src/data-source.ts13
-rw-r--r--extension/examples/MyProject/src/entity/User.ts16
-rw-r--r--extension/examples/MyProject/src/index.ts20
-rw-r--r--extension/examples/MyProject/src/queries.ts10
4 files changed, 59 insertions, 0 deletions
diff --git a/extension/examples/MyProject/src/data-source.ts b/extension/examples/MyProject/src/data-source.ts
new file mode 100644
index 00000000..07e13d2a
--- /dev/null
+++ b/extension/examples/MyProject/src/data-source.ts
@@ -0,0 +1,13 @@
+import "reflect-metadata";
+import { DataSource } from "typeorm";
+import { User } from "./entity/User";
+
+export const AppDataSource = new DataSource({
+ type: "sqlite",
+ database: "database.sqlite",
+ synchronize: true,
+ logging: false,
+ entities: [User],
+ migrations: [],
+ subscribers: [],
+});
diff --git a/extension/examples/MyProject/src/entity/User.ts b/extension/examples/MyProject/src/entity/User.ts
new file mode 100644
index 00000000..1e82835e
--- /dev/null
+++ b/extension/examples/MyProject/src/entity/User.ts
@@ -0,0 +1,16 @@
+import { Entity, PrimaryGeneratedColumn, Column } from "typeorm";
+
+@Entity()
+export class User {
+ @PrimaryGeneratedColumn()
+ id!: number;
+
+ @Column()
+ name!: string;
+
+ @Column()
+ email!: string;
+
+ @Column()
+ password!: string;
+}
diff --git a/extension/examples/MyProject/src/index.ts b/extension/examples/MyProject/src/index.ts
new file mode 100644
index 00000000..9ffd7282
--- /dev/null
+++ b/extension/examples/MyProject/src/index.ts
@@ -0,0 +1,20 @@
+import { AppDataSource } from "./data-source"
+import { User } from "./entity/User"
+
+AppDataSource.initialize().then(async () => {
+
+ console.log("Inserting a new user into the database...")
+ const user = new User()
+ user.firstName = "Timber"
+ user.lastName = "Saw"
+ user.age = 25
+ await AppDataSource.manager.save(user)
+ console.log("Saved a new user with id: " + user.id)
+
+ console.log("Loading users from the database...")
+ const users = await AppDataSource.manager.find(User)
+ console.log("Loaded users: ", users)
+
+ console.log("Here you can setup and run express / fastify / any other framework.")
+
+}).catch(error => console.log(error))
diff --git a/extension/examples/MyProject/src/queries.ts b/extension/examples/MyProject/src/queries.ts
new file mode 100644
index 00000000..1b773099
--- /dev/null
+++ b/extension/examples/MyProject/src/queries.ts
@@ -0,0 +1,10 @@
+import { AppDataSource } from "./data-source";
+import { Order } from "./entity/User";
+
+async function getOrdersByCustomerId(customerId: number): Promise<Order[]> {
+ const orderRepository = AppDataSource.getRepository(Order);
+ const orders = await orderRepository.find({
+ where: { customer_id: customerId },
+ });
+ return orders;
+}