Automatically generate models

[Groxot]

Feature proposal

Automatically generate models like
https://github.com/sequelize/sequelize-auto
from existing database

something like for mssql:

Declare @TableName varchar(128)

Set @TableName = 'myTable'

  --@property({
  --  type: 'number',
  --  required: true,
  --})
  --Id: number;
  
  
select char(13)+'@property({ '+char(13)+
'	type: '''+
case DATA_TYPE 
when 'int'  then 'number' 
when 'varchar'  then 'string' 
when 'datetime' then 'date'
when 'bit' then 'boolean'
when 'smallint' then 'number'
when 'float' then 'number'
when 'text' then 'string'
else 'any' end
+''', '+char(13)+
'	required: ' +case IS_NULLABLE when 'YES' then 'false' else 'true' end +', '+char(13)+
'})'+char(13)+
''++COLUMN_NAME+case IS_NULLABLE when '' then 'false' else '?' end+':'+
case DATA_TYPE 
when 'int'  then 'number' 
when 'varchar'  then 'string' 
when 'datetime' then 'date'
when 'bit' then 'boolean'
when 'smallint' then 'number'
when 'float' then 'number'
when 'text' then 'string'
else 'any' end +';'

from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME=@TableName

[dhmlau]

@Groxot, hi again. :) There is a community PR on lb4 discover command. The idea is for users specifying the database connection info and the lb4 discover will generate the model ts files. Please take a look: #2245

If you agree, I'd like to continue discussion over there and close this issue. Thanks!