Hi,
I have a weird problem.
(Mysql)
When I do a create_all(), i get the error :
File
"/Library/Python/2.6/site-packages/SQLAlchemy-0.5.8-py2.6.egg/sqlalchemy/engine/base.py",
line 931, in _handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
sqlalchemy.exc.OperationalError: (OperationalError) (1050, "Table
'calendarevents' already exists") '\nCREATE TABLE `CalendarEvents` (\n\t`Id`
INTEGER NOT NULL AUTO_INCREMENT, \n\t`CalendarId` INTEGER, \n\t`Allday` BOOL,
\n\t`DtStart` DATETIME, \n\t`DtEnd` DATETIME, \n\t`DTStamp` DATETIME,
\n\t`Class` VARCHAR(20), \n\t`Created` DATETIME, \n\t`Description` TEXT,
\n\t`Duration` DATETIME, \n\t`LastModified` DATETIME, \n\t`Location` TEXT,
\n\t`Priority` VARCHAR(10), \n\t`RecurId` DATETIME, \n\t`Sequence` INTEGER,
\n\t`Status` TEXT, \n\t`Summary` TEXT, \n\t`Transparent` VARCHAR(15), \n\tuid
TEXT, \n\turl TEXT, \n\t`Organizer` VARCHAR(100), \n\t`OrganizerCN`
VARCHAR(100), \n\t`OrganizerDIR` VARCHAR(50), \n\t`OrganizerSendBy`
VARCHAR(50), \n\t`OrganizerLanguage` VARCHAR(50), \n\tPRIMARY KEY (`Id`), \n\t
FOREIGN KEY(`CalendarId`) REFERENCES `Calendars` (`Id`)\n)\n\n' ()
even though the table is not there!, Only the Calendars table is created
Any suggestions?
Martijn
--
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.
