diff options
Diffstat (limited to 'extension/examples/MyProject/src')
-rw-r--r-- | extension/examples/MyProject/src/data-source.ts | 13 | ||||
-rw-r--r-- | extension/examples/MyProject/src/entity/User.ts | 16 | ||||
-rw-r--r-- | extension/examples/MyProject/src/index.ts | 20 | ||||
-rw-r--r-- | extension/examples/MyProject/src/queries.ts | 10 |
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; +} |