I have a reasonably complex schema that I attempting to manage with
SQLAlchemy. I just added some tables in code and tried re-creating
the database, and got an error that looks like this:
##################
sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1064, "You have
an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near ' \n\tisdiscrete
BOOL, \n\tminlevel INTEGER, \n\tmaxlevel INTEGER, \n\tPRIMARY KEY (id)
\n)' at line 5") '\nCREATE TABLE alertscheme (\n\tid INTEGER NOT NULL
AUTO_INCREMENT, \n\tname VARCHAR(128), \n\t`desc` VARCHAR(1024), \n
\tvaluetype VARCHAR, \n\tisdiscrete BOOL, \n\tminlevel INTEGER, \n
\tmaxlevel INTEGER, \n\tPRIMARY KEY (id)\n)\n\n' {}
##################
As far as I can tell, this is an error generated by SQLAlchemy
creating bad SQL from the Python code. How should I go about
debugging this?
Thanks,
Mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
