I tried this:
db =
DAL('mysql://[email protected]:8000/my_database_name',migrate_enabled=False,
pool_size=20)
It didn't work either. I guess someone needs to look at how to connect to
legacy database.
On Tuesday, April 21, 2015 at 2:49:33 PM UTC-4, Ron Chatterjee wrote:
>
> 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 <[email protected]>
>> 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 <[email protected]>
>>>> 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 <[email protected]
>>>>>> > 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 <
>>>>>>>> [email protected]> 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 [email protected].
>>>>>>>>> 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 [email protected].
>>>>>>> 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 [email protected].
>>>>> 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 [email protected].
>>> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
