search

nodejh / sequelize-automate

Automatically generate bare sequelize models from your database.
MIT License
114 stars 21 forks source link

Schema support #10

Open ajcaterino opened 4 years ago

ajcaterino commented 4 years ago

Can sequelize-automate support multiple schemas? Currently when it comes across a table that is a schema other than DBO it encounters an error stating that the table does not exist.

nodejh commented 4 years ago

Hi @DoughNutz , Could you please give me some examples of your schemas?

ajcaterino commented 4 years ago

It is a Microsoft SQL Server database with a single table and Schemas DBO and one called Test. The table belongs to the Test schema. If it is possible to upload or email a zip file (358kb) I'll send you the database.

dogcalas commented 4 years ago

Would be excellent if we can choose an schema like sequelize-auto. download

dosikru commented 4 years ago

Plus. My tables are located in different schemes and this does not work. EXEC sys.sp_helpindex @objname = N'[docs]' <- Error!!! EXEC sys.sp_helpindex @objname = N'[sh1].[docs]' <- Correct!!!

nodejh commented 4 years ago

Thanks all, I will fix these issues this month.

osmanraifgunes commented 4 years ago

https://github.com/sequelize/sequelize/issues/11948

dosikru commented 4 years ago

Any news?