Can you confirm if it was working before? I just don't know if it was. On Tuesday, April 21, 2015 at 11:56:27 AM UTC-4, Richard wrote: > > :) > > You may also consider fixing the scripts which may just need a little > tweak if it where working before... > > Richard > > On Tue, Apr 21, 2015 at 11:12 AM, Ron Chatterjee <achatte...@gmail.com > <javascript:>> wrote: > >> I need to stop being lazy I guess. lol. Thanks Richard. Will do. >> >> On Tuesday, April 21, 2015 at 12:52:31 AM UTC-4, Richard wrote: >>> >>> Does the script complete correctly... These scripts are old, and I don't >>> know many person who have use them... Anyway, 20 tables 50 tables is not >>> much... >>> >>> You can write your own which can be basic parser that convert table and >>> field only and you have to set constrains yourself... >>> >>> Richard >>> >>> On Mon, Apr 20, 2015 at 7:55 PM, Ron Chatterjee <achatte...@gmail.com> >>> wrote: >>> >>>> Yes I did. I forgot to add. The extract_sqlite_models.py didn't work as >>>> expect. And that may be because I am not doing it right. Thats why I >>>> didn't >>>> mention. >>>> >>>> >>>> >>>python extract_sqlite_models.py >>>> C:\Users\...\applications\my_application_name\databases\storage.sqlite >>>> >>>> Which generates the following output. >>>> >>>> # -*- coding: utf-8 -*- >>>> legacy_db = >>>> DAL('sqlite://C:/Users/.../applications/my_application_name/databases/storage.sqlite') >>>> >>>> legacy_db.define_table('auth_user', >>>> migrate=False) >>>> >>>> #-------- >>>> legacy_db.define_table('auth_group', >>>> migrate=False) >>>> >>>> #-------- >>>> legacy_db.define_table('auth_membership', >>>> migrate=False) >>>> >>>> #-------- >>>> legacy_db.define_table('auth_permission', >>>> migrate=False) >>>> >>>> #-------- >>>> legacy_db.define_table('auth_event', >>>> migrate=False) >>>> >>>> #-------- >>>> legacy_db.define_table('auth_cas', >>>> migrate=False) >>>> >>>> #-------- >>>> legacy_db.define_table('topic', >>>> migrate=False) >>>> >>>> #-------- >>>> legacy_db.define_table('comment', >>>> migrate=False) >>>> >>>> >>>> But these generates empty fields and may be its due to the new version >>>> (2.10.3) I am not sure. Probably have to open a ticket. Unless I am doing >>>> something wrong in calling that function. >>>> >>>> >>>> >>>> On Monday, April 20, 2015 at 10:27:17 AM UTC-4, Richard wrote: >>>>> >>>>> >>>>> 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 <achatte...@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+un...@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+un...@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+un...@googlegroups.com <javascript:>. >> 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.