I think I fixed some of this in trunk. Could you print form me the
line offending hit? If i see it I can fix the regular expression too.
Thanks.
On Sep 8, 3:03 am, ron_m <ron.mco...@gmail.com> wrote:
> On Sep 7, 5:10 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > If you have a mysql database running locally, please help me test it.
>
> First problem I ran into
> Last line parameters are out of order on mysql() call
> so it outputs incorrect database URL string
> $ python scripts/extract_mysql_models.py user:p...@db_name
> user
> pass
> db_name
> legacy_db = DAL('mysql://pass:db_n...@localhost/user')
>
> Changed last line
> print mysql(m.group(1),m.group(2),m.group(3))
> to be
> print mysql(m.group(3),m.group(1),m.group(2))
>
> Next run I get a key error on the data_type_map
> $ python scripts/extract_mysql_models.py user:p...@db_name
> user
> pass
> db_name
> Traceback (most recent call last):
> File "scripts/extract_mysql_models.py", line 100, in <module>
> print mysql(m.group(3),m.group(1),m.group(2))
> File "scripts/extract_mysql_models.py", line 82, in mysql
> web2py_table_code += "\n Field('%s','%s'),"%
> (name,data_type_map[d_type])
> KeyError: 'datetime'
>
> Thinking I could fix this I added a line to the data_type_map last 2
> lines so you get a reference point are
> timestamp = 'datetime',
> datetime = 'datetime',
> )
>
> Next run produces
> $ python scripts/extract_mysql_models.py user:p...@db_name
> user
> pass
> db_name
> Traceback (most recent call last):
> File "scripts/extract_mysql_models.py", line 101, in <module>
> print mysql(m.group(3),m.group(1),m.group(2))
> File "scripts/extract_mysql_models.py", line 80, in mysql
> name, d_type = hit.group(1), hit.group(2)
> AttributeError: 'NoneType' object has no attribute 'group'
>
> Added a print line statement just above line 80 and it stops on the
> mysqldump of the auth_event table at line
> `description` longtext,
>
> So it looks like hit is empty because there is no match on this line
> (print line and flush commented out
> hit = re.search('(\S+) (\S+) .*', line)
> # print line
> # if hit != None:
> # print hit.group(1), hit.group(2)
> # sys.stdout.flush()
> name, d_type = hit.group(1), hit.group(2)
> Added a test for hit != None and see what hit.group(1) and
> hit.group(2) are they are the name and type except for this line.
> Looks like longtext needs to be added to the type dictionary but not
> getting there because of this failure.
>
> Added a test for hit == None with continue to skip around this code
>
> Next failure is in the CODE() call, global name CODE is not defined.
> Looks like a missing import - I am just running from the bash shell.
>
> I don't really understand why the regular expression filling hit fails
> but then I am weak in that area with Python.
>
> Here is the complete mysqldump CREATE TABLE stanza for auth_event
> I am using mysql 5.1.41 on Ubuntu 10.04 with all patches.
>
> CREATE TABLE `auth_event` (
> `id` int(11) NOT NULL AUTO_INCREMENT,
> `time_stamp` datetime DEFAULT NULL,
> `client_ip` varchar(512) DEFAULT NULL,
> `user_id` int(11) DEFAULT NULL,
> `origin` varchar(512) DEFAULT NULL,
> `description` longtext,
> PRIMARY KEY (`id`),
> KEY `user_id__idx` (`user_id`),
> CONSTRAINT `auth_event_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES
> `auth_user` (`id`) ON DELETE CASCADE
> ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
>
> Time to catch some ZZZs it is 1 am
>
> Ron
