Hi,
here we go with full CREATE statement for the table:
CREATE TABLE `WMSWarehouses` (
`WarehouseID` int(10) unsigned NOT NULL auto_increment,
`WarehouseCode` varchar(25) collate utf8_lithuanian_ci NOT NULL
default '',
`WarehouseName` varchar(200) collate utf8_lithuanian_ci NOT NULL
default '',
`WarehouseLocation` text collate utf8_lithuanian_ci,
`WebServicesURL` varchar(200) collate utf8_lithuanian_ci NOT NULL
default '',
`WarehouseType` enum('CENTRAL','PERIPHERAL') collate
utf8_lithuanian_ci NOT NULL default 'CENTRAL',
`IsIndependentDistr` tinyint(1) NOT NULL default '0',
`InvoiceSeries` varchar(3) collate utf8_lithuanian_ci NOT NULL default '',
`PackingListSeries` varchar(3) collate utf8_lithuanian_ci NOT NULL
default '',
`PreliminaryInvoiceSeries` varchar(3) collate utf8_lithuanian_ci NOT
NULL default '',
`ExcDiscount` double(12,2) NOT NULL default '0.00',
`EcoDiscount` double(12,2) NOT NULL default '0.00',
`RecomPriceDiscount` double(12,2) NOT NULL default '0.00',
`OwnerGroup` varchar(100) collate utf8_lithuanian_ci NOT NULL default '',
`Details` text collate utf8_lithuanian_ci NOT NULL,
`PresentWarehouseID` int(10) unsigned default NULL,
PRIMARY KEY (`WarehouseID`),
UNIQUE KEY `WarehouseCode` (`WarehouseCode`),
KEY `WarehouseType` (`WarehouseType`),
KEY `InvoiceSeries` (`InvoiceSeries`),
KEY `PackingListSeries` (`PackingListSeries`),
KEY `PreliminaryInvoiceSeries` (`PreliminaryInvoiceSeries`),
KEY `IsIndependentDistr` (`IsIndependentDistr`),
KEY `PresentWarehouseID` (`PresentWarehouseID`),
CONSTRAINT `WMSWarehouses_ibfk_1` FOREIGN KEY (`PresentWarehouseID`)
REFERENCES `WMSWarehouses` (`WarehouseID`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci
Thanks,
--
Andrius
Michael Bayer wrote:
> need to show us the full CREATE statement for the table,as theres
> something about it which is not supported; autoloading with MySQL
> works in the general case.
>
> On Jul 31, 2006, at 9:09 AM, Andrius Armonas wrote:
>
>> Hi,
>>
>> autoload feature doesn't seem to work properly. Calling Table(...,
>> autoload=True) for the first time raises AttributeError error, and for
>> the second time - no errors seen.
>>
>> What I'm doing is:
>>
>> fire:~$ python2.4
>> Python 2.4.4c0 (#2, Jun 14 2006, 22:35:41)
>> [GCC 4.1.2 20060613 (prerelease) (Debian 4.1.1-4)] on linux2
>> Type "help", "copyright", "credits" or "license" for more information.
>>>>> from sqlalchemy import *
>>>>> engine = create_engine("mysql://...")
>>>>> meta = BoundMetaData(engine)
>>>>> wTable = Table('WMSWarehouses', meta, autoload=True)
>> Traceback (most recent call last):
>> File "<stdin>", line 1, in ?
>> File "build/bdist.linux-i686/egg/sqlalchemy/schema.py", line 97, in
>> __call__
>> File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line 488,
>> in reflecttable
>> File "build/bdist.linux-i686/egg/sqlalchemy/databases/mysql.py", line
>> 345, in reflecttable
>> File "build/bdist.linux-i686/egg/sqlalchemy/databases/mysql.py", line
>> 361, in moretableinfo
>> AttributeError: 'array.array' object has no attribute 'strip'
>>>>> wTable = Table('WMSWarehouses', meta, autoload=True)
>>>>> wTable.name
>> 'WMSWarehouses'
>>
>> As said, using MySQL 4.1, SA 0.2.6.
>>
>> Any help?
>>
>> Thanks,
>> --
>> Andrius
>>
>> -------------------------------------------------------------------------
>>
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to
>> share your
>> opinions on IT & business topics through brief surveys -- and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>
>> _______________________________________________
>> Sqlalchemy-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
