I can write it. But it will take some time to go through the syntax. I will
let you know.
On Tuesday, April 21, 2015 at 2:35:29 PM UTC-4, Richard wrote:
>
> I can't I remember having read that mysql script worked or have been
> used... You may consider write a dummy web2py model generate the DB
> (SQLite) export the SQLite Schema and attach here or to a ticket you open
> on github it will help to troobleshoot and fix it...
>
> Richard
>
> On Tue, Apr 21, 2015 at 2:29 PM, Ron Chatterjee <achatte...@gmail.com
> <javascript:>> wrote:
>
>> 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>
>>> 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.
>>>> 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.
