https://github.com/web2py/web2py/blob/master/scripts/extract_sqlite_models.py
Have you check gluon/scripts/ before ask?
Richard
On Sun, Apr 19, 2015 at 5:07 PM, Ron Chatterjee <achatterjee...@gmail.com>
wrote:
> I have the following SQL file:
>
> BEGIN TRANSACTION;
> CREATE TABLE topic(
> id INTEGER PRIMARY KEY AUTOINCREMENT,
> title CHAR(512) NOT NULL,
> is_active CHAR(1),
> created_on TIMESTAMP,
> created_by INTEGER REFERENCES auth_user (id) ON DELETE CASCADE,
> modified_on TIMESTAMP,
> modified_by INTEGER REFERENCES auth_user (id) ON DELETE CASCADE
> );
> INSERT INTO `topic` VALUES(1,'regergerg','T','2015-04-14
> 14:32:52',1,'2015-04-14 14:32:52',1);
> INSERT INTO `topic` VALUES(2,'egergerger','T','2015-04-14
> 14:33:27',1,'2015-04-14 14:33:27',1);
>
>
> Is there a script that will convert this to db.py in other words, spit out
> the following code?
>
> db.define_table('topic',
> Field('title', label=T('Title'), notnull=True,
> requires=IS_NOT_EMPTY()),
> auth.signature,
> format='%(title)s',
> )
>
> I asked because if I have a large SQL file then creating the table by hand
> or looking at the schema may take some time. Wondering if there is a script
> in the script folder that automoatically does this conversion. I know
> "extract_mysql_models.py" in the script folder but that only take an
> existing mysql file and does the conversion. I am not sure if it does SQL
> to DAL directly. Am I correct?
>
> --
> 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.
>
--
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.
