I'm seeing an error with 'autoload' on a simple table. IRC said I
should mention it here, and here it is.
I am running the latest SQLAlchemy 0.3.8 with MySQL-python-1.2.2. This
is running a MySQL database I have no version over. I fear this
version of MySQL is unsupported?
$mysql --version
mysql Ver 12.22 Distrib 4.0.27, for pc-linux-gnu (i686)
As for the error, I am trying to autoload a table and getting this
error.
FlavorCone = Table("FlavorCone", metadata, autoload=True)
File "build/bdist.linux-i686/egg/sqlalchemy/schema.py", line 166, in
__call__
File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
809, in reflecttable
File "build/bdist.linux-i686/egg/sqlalchemy/databases/mysql.py",
line 1083, in reflecttable
TypeError: unsubscriptable object
I've played with the db engine and see I can get the data. The table
is pretty simple.
CREATE TABLE FlavorCone (
letter char(1) NOT NULL default '',
name varchar(32) NOT NULL default '',
image varchar(32) NOT NULL default '',
PRIMARY KEY (letter)
) TYPE=MyISAM COMMENT='Flavors of cones';
INSERT INTO FlavorCone VALUES ('C','Cake','cone');
INSERT INTO FlavorCone VALUES ('S','Sugar','sugarcone');
My guess is that I'm out of luck on the MySQL version. But if there's
anything I should try, I can followup.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
