typeorm_sqlite_user_entity_crud_quickstart.ts

1import { Entity, PrimaryGeneratedColumn, Column, DataSource } from "typeorm"
2
3@Entity()
4export class User {
5    @PrimaryGeneratedColumn()
6    id: number
7
8    @Column()
9    firstName: string
10
11    @Column()
12    lastName: string
13
14    @Column()
15    age: number
16}
17
18const AppDataSource = new DataSource({
19    type: "sqlite",
20    database: "database.sqlite",
21    synchronize: true,
22    logging: false,
23    entities: [User],
24    migrations: [],
25    subscribers: [],
26})
27
28// to initialize the connection, then use the connection
29AppDataSource.initialize()
30    .then(async () => {
31        console.log("Inserting a new user into the database...")
32        const user = new User()
33        user.firstName = "Timber"
34        user.lastName = "Saw"
35        user.age = 25
36        await AppDataSource.manager.save(user)
37        console.log("Saved a new user with id: " + user.id)
38
39        console.log("Loading users from the database...")
40        const users = await AppDataSource.manager.find(User)
41        console.log("Loaded users: ", users)
42
43        console.log("Here you can setup and run express / fastify / any other framework.")
44    })
45    .catch((error) => console.log(error))