omymodels.errors.NoTablesError: No tables was found in DDL input.

[KrunchMuffin]

Describe the bug
No tables was found in DDL input

To Reproduce
Steps to reproduce the behavior:
Generate my DDL from SSMS and import to OMM

Expected behavior
find tables to parse

Desktop (please complete the following information):

• OS: [e.g. iOS] Win10

script.sql.txt

[xnuinside]

@KrunchMuffin hi, thanks for the report. Thanks for the sample) it will take a some time to support all things a huge ddl) by the way, I see [] near column names for the first time. What is DB that generate this?

[KrunchMuffin]

That is MS sql server. If it encounters words that are reserved or columns and tables with hyphens, it will wrap them in square brackets so it doesn't interfere. If you made a column named desc it would do [desc] since that is a reserved word .

[xnuinside]

@KrunchMuffin got it, thanks :)

[xnuinside]

I started to add some statements in v0.20.0 version that I found in your script. Really thanks for the sample. But still a lot of work. I will report when will be the version, that support all of MSSQL things from your script.

[KrunchMuffin]

How long before you add it to omymodels?

[xnuinside]

@KrunchMuffin I plan to add full support to queries from your sql file in 0.21.0 version, release it and update omymodels after that. I need few days more for that.

[xnuinside]

@KrunchMuffin I released 0.21.0. This this version your full script is parsed well. Tomorrow I will work on Omymodels updates. Will ping you here after release new version in OMyModels

[xnuinside]

@KrunchMuffin sorry for taken a long time, I thought release it with 0.11.0 version, but updates that I planned taken much more time.So just released version 0.10.1 https://pypi.org/project/omymodels/ with updated dependency to new simple-ddl-parser 0.21.1. But need also made in OMyModels changes - to remove [] from names before generate code.. it will takes more time. I created issue for this: xnuinside/omymodels#28. I will close this issue and let's continue in omymodels.