Repository files navigation

• setup a connection

  constdb=newDatabaseConfig();db.addConnection({'driver'  :'sqlite','database':':memory:'});db.bootFedaco();db.setAsGlobal();

• define a model

  @Table({tableName:'user'})classUserextendsModel{  @PrimaryColumnid;    @Column()email;  @Column()name;  @Column()age;  @CreatedAtColumn()created_at;  @UpdateAtColumn()updated_at;}

• fetch data

  constlist=awaitUser.createQuery().get();

constschemaBuilder=Model.getConnectionResolver().connection(connectionName).getSchemaBuilder();;awaitschemaBuilder().create('users',table=>{table.increments('id');table.string('email').withUnique();table.string('name');table.string('age');});

• wrapped driver. unify all driver query api
• compile query builder to sql
• decorate to define model
• soft delete
• use relationship to link model
• relation can set dynamic constrain
• sqlite and mysql support

ecma class with field declaration not in constructor is not support. es2016 is support but es2022 is not.field declaration can usedeclare keyword to declare field in constructor, then the field will not generated in class when enabled es2022like this

  @Table({tableName:'user'})classUserextendsModel{    @PrimaryColumn()declareid;}