On Wednesday, April 12, 2017 at 11:24:31 AM UTC-4, Anthony wrote: > > On Wednesday, April 12, 2017 at 10:56:20 AM UTC-4, ArtDijk wrote: >> >> Thanks Anthony. I'm surprised there is no working solution for this. >> I try to prevent the need to define all 250+fileds by hand... >> In DB Browser for SQLite I have the SQL statement to create this db. >> Is it possible to create the DAL database definitions with a SQL >> statement ? >> > > Shouldn't be hard to do it using Python -- you'll have to parse the SQL > and then generate the Python code. Take a look at the code in > extract_sqlite_model.py. Maybe you can figure out what's wrong with the > current code and fix it (and submit a pull request with the change). >
It might work if you replace: hit = re.search(r'\[(\S+)\]\s+(\w+(\(\S+\))?),?( .*)?', line) with: hit = re.search(r'\s+(\w+) (\w+)(\(\S+\))?,?( .*)?', line) Anthony -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
