[Sqlalchemy-users] Re: MySQL foreign key support

[Alastair Houghton]

On 5 Feb 2006, at 23:33, Wade Leftwich wrote: Wade Leftwich wrote: Michael Bayer wrote: ok, great.  if you want to look at the code, its pretty easy, its lib/ sqlalchemy/databases/mysql.py line 163, "reflecttable".  Right now  its just "describe", loop through rows, a little parsing, then  table.append_item(Column).  thanks ! - mike See if this gets us at least partway down the road. Seems to work: I had an immediate attack of staircase wit. Here's a simpler version that also works. -- Wade +        match = re.search(r'\)\s*TYPE=(?P<ttype>.+)$', desc, re.I) This needs to say (?:TYPE|ENGINE), since some versions write ENGINE rather than TYPE here. Kind regards, Alastair. -- http://www.alastairs-place.net