Hello.
> perhaps. Maybe the connection doesn't have correct access to the information
schema tables, as SQLSoup relies upon table reflection. you'd need to run with
echo='debug' on your engine to see exactly what queries are being emitted and
the rows being returned, and determine why an information schema row for
"mlm_spol" isn't being returned.
I did it and it seems that there is a str/unicode problem when dealing with the
information shema (see below, it's rather long).
I tried it with charset=UTF8 to pyodbc.connect string. I also tried various
combinations of create_engine options supports_unicode_binds and convert_unicode
but none of them worked.
Ladislav Lenart
CODE:
import pyodbc
from sqlalchemy.engine import create_engine
from sqlalchemy.ext.sqlsoup import SqlSoup
def connect():
return
pyodbc.connect('DRIVER={FreeTDS};SERVER=10.230.128.140;PORT=1433;DATABASE=ZFP_CRM;UID=efractal;PWD=efR@cZFP13;TDS_VERSION=8.0;')
engine = create_engine('mssql+pyodbc://', creator=connect, echo='debug')
db = SqlSoup(engine)
x = db.execute("select * from mlm_spol").fetchone()
print x
ITS DEBUG OUTPUT:
pydev debugger: starting
2012-10-08 17:19:53,239 INFO sqlalchemy.engine.base.Engine SELECT user_name() as
user_name;
2012-10-08 17:19:53,240 INFO sqlalchemy.engine.base.Engine ()
2012-10-08 17:19:53,246 DEBUG sqlalchemy.engine.base.Engine Col ('user_name',)
2012-10-08 17:19:53,247 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U00660065\U00610072\U00740063\U006c0061', )
2012-10-08 17:19:53,253 INFO sqlalchemy.engine.base.Engine
SELECT default_schema_name FROM
sys.database_principals
WHERE name = ?
AND type = 'S'
2012-10-08 17:19:53,253 INFO sqlalchemy.engine.base.Engine
(u'\U00660065\U00610072\U00740063\U006c0061',)
2012-10-08 17:19:53,259 DEBUG sqlalchemy.engine.base.Engine Col
('default_schema_name',)
2012-10-08 17:19:53,286 INFO sqlalchemy.engine.base.Engine BEGIN (implicit)
2012-10-08 17:19:53,288 INFO sqlalchemy.engine.base.Engine select * from
mlm_spol
2012-10-08 17:19:53,289 INFO sqlalchemy.engine.base.Engine ()
2012-10-08 17:19:53,304 DEBUG sqlalchemy.engine.base.Engine Col ('id_mlm_spol',
'id_mlm_spol_master', 'id_mlm_spol_ridici', 'id_mlm_spol_reditel',
'id_mlm_spol_predstav', 'id_mlm_spol_ppz', 'id_mlm_spol_psedm',
'id_mlm_spol_gar_cz', 'id_mlm_spol_gar_sk', 'id_mlm_spol_reditel_cz',
'id_mlm_spol_reditel_sk', 'id_mlm_spol_predstav_cz', 'id_mlm_spol_predstav_sk',
'id_mlm_spol_ridici_cz', 'id_mlm_spol_ridici_sk', 'id_mlm_spol_psedm_cz',
'id_mlm_spol_psedm_sk', 'id_mlm_firma_subjekt', 'pocet_primi', 'pocet_celkem',
'typ_spol', 'info', 'info_extended', 'os_cislo', 'os_cislo_sk', 'alt_cislo_1',
'alt_cislo_2', 'alt_cislo_3', 'pozice', 'dosahnuti_pozice', 'stav',
'dosahnuti_stavu', 'datum_dosahnuti_stavu', 'smlouva', 'prvni_aplikace_smlouvy',
'vznik_vykonu', 'rfp', 'body_vlastni', 'body_vlastni_alt',
'body_vlastni_alt_trans', 'body_skup', 'body_skup_alt', 'body_skup_alt_trans',
'body_top_struktury', 'kod_banky', 'cislo_uctu', 'spec_symbol', 'eu_banka',
'rod_cis', 'ico', 'pozice_puv', 'postup', 'os_cislo_reditel', 'os_cislo_ridici',
'os_cislo_sponzor', 'os_cislo_predstav', 'typoval', 'zmena', 'poznamka',
'pokus', 'os_cislo_sponzor_new', 'body_celkem', 'blokovany_postup',
'evidencni_cislo', 'body_celkem_200501', 'cislo_slev_karty', 'reg_cislo_mf',
'reg_cislo_uft', 'datum_prid_slev_karty', 'obdobi_prid_slev_karty',
'id_mlm_spol_gar_orig_cz', 'id_mlm_spol_gar_orig_sk', 'zmena_gar_cz',
'zmena_gar_sk', 'duvod_zmeny_gar_cz', 'duvod_zmeny_gar_sk', 'datum_last_cz',
'datum_last_sk', 'id_mlm_smlouva_last_cz', 'id_mlm_smlouva_last_sk',
'id_mlm_strukt_man_cz', 'id_mlm_strukt_man_sk', 'id_mlm_spol_ros_cz',
'id_mlm_spol_ros_sk', 'tisk_ps_1', 'tisk_ps_2', 'tisk_ps_3', 'tisk_ps_4',
'tisk_ps_1_rucni', 'tisk_ps_3_rucni', 'tisk_ps_5', 'tisk_ps_5_rucni',
'id_mlm_spol_psedm_akt_cz', 'id_mlm_spol_psedm_akt_sk', 'id_mlm_spol_hrk_cz',
'id_mlm_spol_hrk_sk', 'provizni_stav', 'menit_automaticky_pstav',
'zda_uplatnovat_kredit', 'perioda_dosahnuti_pozice', 'firma')
2012-10-08 17:19:53,306 DEBUG sqlalchemy.engine.base.Engine Row (277581, 268893,
37494, 37494, 20198, None, 37494, 119835, 18954, 37494, 18954, 20198, 18954,
37494, 18996, 37494, 18996, None, 0, 0, 'O', None, None, '414712', None, None,
None, None, '1', None, 1, '201208', datetime.datetime(2012, 8, 25, 0, 0), None,
None, None, None, Decimal('0.000000'), Decimal('0.000000'), Decimal('0.000000'),
Decimal('0.000000'), Decimal('0.000000'), Decimal('0.000000'),
Decimal('0.000000'), None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, Decimal('0.000000'), None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, 37494, 18954, 18996, 19009, 'A', None, None, None, 'N', None, None,
None, 37494, 20198, 20198, 18954, False, True, True, 0, None)
CODE:
import pyodbc
from sqlalchemy.engine import create_engine
from sqlalchemy.ext.sqlsoup import SqlSoup
def connect():
return
pyodbc.connect('DRIVER={FreeTDS};SERVER=10.230.128.140;PORT=1433;DATABASE=ZFP_CRM;UID=efractal;PWD=efR@cZFP13;TDS_VERSION=8.0;')
engine = create_engine('mssql+pyodbc://', creator=connect, echo='debug')
db = SqlSoup(engine)
x = db.mlm_spol.fetchone()
print x
ITS DEBUG OUTPUT:
pydev debugger: starting
2012-10-08 17:33:07,175 INFO sqlalchemy.engine.base.Engine SELECT user_name() as
user_name;
2012-10-08 17:33:07,176 INFO sqlalchemy.engine.base.Engine ()
2012-10-08 17:33:07,181 DEBUG sqlalchemy.engine.base.Engine Col ('user_name',)
2012-10-08 17:33:07,182 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U00660065\U00610072\U00740063\U006c0061', )
2012-10-08 17:33:07,188 INFO sqlalchemy.engine.base.Engine
SELECT default_schema_name FROM
sys.database_principals
WHERE name = ?
AND type = 'S'
2012-10-08 17:33:07,189 INFO sqlalchemy.engine.base.Engine
(u'\U00660065\U00610072\U00740063\U006c0061',)
2012-10-08 17:33:07,194 DEBUG sqlalchemy.engine.base.Engine Col
('default_schema_name',)
2012-10-08 17:33:07,243 INFO sqlalchemy.engine.base.Engine SELECT
[COLUMNS_1].[TABLE_SCHEMA], [COLUMNS_1].[TABLE_NAME], [COLUMNS_1].[COLUMN_NAME],
[COLUMNS_1].[IS_NULLABLE], [COLUMNS_1].[DATA_TYPE],
[COLUMNS_1].[ORDINAL_POSITION], [COLUMNS_1].[CHARACTER_MAXIMUM_LENGTH],
[COLUMNS_1].[NUMERIC_PRECISION], [COLUMNS_1].[NUMERIC_SCALE],
[COLUMNS_1].[COLUMN_DEFAULT], [COLUMNS_1].[COLLATION_NAME]
FROM [INFORMATION_SCHEMA].[COLUMNS] AS [COLUMNS_1]
WHERE [COLUMNS_1].[TABLE_NAME] = ? AND [COLUMNS_1].[TABLE_SCHEMA] = ? ORDER BY
[COLUMNS_1].[ORDINAL_POSITION]
2012-10-08 17:33:07,244 INFO sqlalchemy.engine.base.Engine (u'mlm_spol', u'dbo')
2012-10-08 17:33:07,259 DEBUG sqlalchemy.engine.base.Engine Col ('TABLE_SCHEMA',
'TABLE_NAME', 'COLUMN_NAME', 'IS_NULLABLE', 'DATA_TYPE', 'ORDINAL_POSITION',
'CHARACTER_MAXIMUM_LENGTH', 'NUMERIC_PRECISION', 'NUMERIC_SCALE',
'COLUMN_DEFAULT', 'COLLATION_NAME')
2012-10-08 17:33:07,264 INFO sqlalchemy.engine.base.Engine sp_columns
@table_name = 'mlm_spol', @table_owner = 'dbo'
2012-10-08 17:33:07,265 INFO sqlalchemy.engine.base.Engine ()
2012-10-08 17:33:07,282 DEBUG sqlalchemy.engine.base.Engine Col
('TABLE_QUALIFIER', 'TABLE_OWNER', 'TABLE_NAME', 'COLUMN_NAME', 'DATA_TYPE',
'TYPE_NAME', 'PRECISION', 'LENGTH', 'SCALE', 'RADIX', 'NULLABLE', 'REMARKS',
'COLUMN_DEF', 'SQL_DATA_TYPE', 'SQL_DATETIME_SUB', 'CHAR_OCTET_LENGTH',
'ORDINAL_POSITION', 'IS_NULLABLE', 'SS_DATA_TYPE')
2012-10-08 17:33:07,283 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070', 4,
u'\U006e0069\U00200074\U00640069\U006e0065\U00690074\U00790074', 10, 4, 0, 10,
0, None, None, 4, None, None, 1, 'NO', 56)
2012-10-08 17:33:07,285 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U0061006d\U00740073\U00720065',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 2, 'YES', 38)
2012-10-08 17:33:07,286 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00690072\U00690064\U00690063',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 3, 'YES', 38)
2012-10-08 17:33:07,287 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00650072\U00690064\U00650074',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 4, 'YES', 38)
2012-10-08 17:33:07,288 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00720070\U00640065\U00740073\U00760061',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 5, 'YES', 38)
2012-10-08 17:33:07,289 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00700070', 4,
u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 6, 'YES', 38)
2012-10-08 17:33:07,290 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00730070\U00640065',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 7, 'YES', 38)
2012-10-08 17:33:07,291 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00610067\U005f0072\U007a0063',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 8, 'YES', 38)
2012-10-08 17:33:07,292 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00610067\U005f0072\U006b0073',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 9, 'YES', 38)
2012-10-08 17:33:07,293 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00650072\U00690064\U00650074\U005f006c\U007a0063',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 10, 'YES', 38)
2012-10-08 17:33:07,294 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00650072\U00690064\U00650074\U005f006c\U006b0073',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 11, 'YES', 38)
2012-10-08 17:33:07,295 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00720070\U00640065\U00740073\U00760061\U0063005f',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 12, 'YES', 38)
2012-10-08 17:33:07,296 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00720070\U00640065\U00740073\U00760061\U0073005f',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 13, 'YES', 38)
2012-10-08 17:33:07,296 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00690072\U00690064\U00690063\U0063005f',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 14, 'YES', 38)
2012-10-08 17:33:07,297 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00690072\U00690064\U00690063\U0073005f',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 15, 'YES', 38)
2012-10-08 17:33:07,298 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00730070\U00640065\U005f006d\U007a0063',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 16, 'YES', 38)
2012-10-08 17:33:07,299 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00730070\U00640065\U005f006d\U006b0073',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 17, 'YES', 38)
2012-10-08 17:33:07,300 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0066005f\U00720069\U0061006d\U0073005f\U00620075\U0065006a\U0074006b',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 18, 'YES', 38)
2012-10-08 17:33:07,301 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0070\U00650063\U005f0074\U00720070\U006d0069', 4, u'\U006e0069', 10, 4,
0, 10, 1, None, None, 4, None, None, 19, 'YES', 38)
2012-10-08 17:33:07,302 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0070\U00650063\U005f0074\U00650063\U006b006c\U006d0065', 4,
u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 20, 'YES', 38)
2012-10-08 17:33:07,303 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00790074\U005f0070\U00700073\U006c006f', 12,
u'\U00610076\U00630072\U00610068', 1, 1, None, None, 0, None, None, 12, None, 1,
21, 'NO', 39)
2012-10-08 17:33:07,305 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f', u'\U006e0069\U006f0066', 12,
u'\U00610076\U00630072\U00610068', 250, 250, None, None, 1, None, None, 12,
None, 250, 22, 'YES', 39)
2012-10-08 17:33:07,306 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006e0069\U006f0066\U0065005f\U00740078\U006e0065\U00650064', 12,
u'\U00610076\U00630072\U00610068', 250, 250, None, None, 1, None, None, 12,
None, 250, 23, 'YES', 39)
2012-10-08 17:33:07,307 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U0073006f\U0063005f\U00730069\U006f006c', 12,
u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12, None,
20, 24, 'YES', 39)
2012-10-08 17:33:07,309 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U0073006f\U0063005f\U00730069\U006f006c\U0073005f', 12,
u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12, None,
20, 25, 'YES', 39)
2012-10-08 17:33:07,310 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006c0061\U005f0074\U00690063\U006c0073\U005f006f', 12,
u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12, None,
20, 26, 'YES', 39)
2012-10-08 17:33:07,311 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006c0061\U005f0074\U00690063\U006c0073\U005f006f', 12,
u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12, None,
20, 27, 'YES', 39)
2012-10-08 17:33:07,313 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006c0061\U005f0074\U00690063\U006c0073\U005f006f', 12,
u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12, None,
20, 28, 'YES', 39)
2012-10-08 17:33:07,314 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f', u'\U006f0070\U0069007a\U00650063',
12, u'\U00610076\U00630072\U00610068', 3, 3, None, None, 1, None, None, 12,
None, 3, 29, 'YES', 39)
2012-10-08 17:33:07,315 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0064\U00610073\U006e0068\U00740075\U005f0069\U006f0070\U0069007a\U00650063',
12, u'\U00610076\U00630072\U00610068', 6, 6, None, None, 1, None, None, 12,
None, 6, 30, 'YES', 39)
2012-10-08 17:33:07,316 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f', u'\U00740073\U00760061', 5,
u'\U006d0073\U006c0061\U0069006c\U0074006e', 5, 2, 0, 10, 1, None, None, 5,
None, None, 31, 'YES', 38)
2012-10-08 17:33:07,317 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0064\U00610073\U006e0068\U00740075\U005f0069\U00740073\U00760061', 12,
u'\U00610076\U00630072\U00610068', 6, 6, None, None, 1, None, None, 12, None, 6,
32, 'YES', 39)
2012-10-08 17:33:07,319 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00610064\U00750074\U005f006d\U006f0064\U00610073\U006e0068\U00740075\U005f0069\U00740073\U00760061',
11, u'\U00610064\U00650074\U00690074\U0065006d', 23, 16, 3, None, 1, None, None,
9, 3, None, 33, 'YES', 111)
2012-10-08 17:33:07,320 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f', u'\U006d0073\U006f006c\U00760075',
5, u'\U006d0073\U006c0061\U0069006c\U0074006e', 5, 2, 0, 10, 1, None, None, 5,
None, None, 34, 'YES', 38)
2012-10-08 17:33:07,321 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00720070\U006e0076\U005f0069\U00700061\U0069006c\U0061006b\U00650063\U0073005f\U006c006d\U0075006f\U00790076',
12, u'\U00610076\U00630072\U00610068', 6, 6, None, None, 1, None, None, 12,
None, 6, 35, 'YES', 39)
2012-10-08 17:33:07,322 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U007a0076\U0069006e\U005f006b\U00790076\U006f006b\U0075006e', 12,
u'\U00610076\U00630072\U00610068', 6, 6, None, None, 1, None, None, 12, None, 6,
36, 'YES', 39)
2012-10-08 17:33:07,324 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f', u'\U00660072', 12,
u'\U00610076\U00630072\U00610068', 6, 6, None, None, 1, None, None, 12, None, 6,
37, 'YES', 39)
2012-10-08 17:33:07,325 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0062\U00790064\U0076005f\U0061006c\U00740073\U0069006e', 3,
u'\U00650064\U00690063\U0061006d', 18, 20, 6, 10, 0, None, None, 3, None, None,
38, 'NO', 55)
2012-10-08 17:33:07,326 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0062\U00790064\U0076005f\U0061006c\U00740073\U0069006e\U0061005f\U0074006c',
3, u'\U00650064\U00690063\U0061006d', 18, 20, 6, 10, 0, None, None, 3, None,
None, 39, 'NO', 55)
2012-10-08 17:33:07,326 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0062\U00790064\U0076005f\U0061006c\U00740073\U0069006e\U0061005f\U0074006c\U0074005f\U00610072\U0073006e',
3, u'\U00650064\U00690063\U0061006d', 18, 20, 6, 10, 0, None, None, 3, None,
None, 40, 'NO', 55)
2012-10-08 17:33:07,327 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0062\U00790064\U0073005f\U0075006b', 3,
u'\U00650064\U00690063\U0061006d', 18, 20, 6, 10, 0, None, None, 3, None, None,
41, 'NO', 55)
2012-10-08 17:33:07,328 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0062\U00790064\U0073005f\U0075006b\U005f0070\U006c0061', 3,
u'\U00650064\U00690063\U0061006d', 18, 20, 6, 10, 0, None, None, 3, None, None,
42, 'NO', 55)
2012-10-08 17:33:07,329 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0062\U00790064\U0073005f\U0075006b\U005f0070\U006c0061\U005f0074\U00720074\U006e0061',
3, u'\U00650064\U00690063\U0061006d', 18, 20, 6, 10, 0, None, None, 3, None,
None, 43, 'NO', 55)
2012-10-08 17:33:07,330 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0062\U00790064\U0074005f\U0070006f\U0073005f\U00720074\U006b0075\U00750074\U00790072',
3, u'\U00650064\U00690063\U0061006d', 18, 20, 6, 10, 0, None, None, 3, None,
None, 44, 'NO', 55)
2012-10-08 17:33:07,331 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f006b\U005f0064\U00610062\U006b006e', 12,
u'\U00610076\U00630072\U00610068', 4, 4, None, None, 1, None, None, 12, None, 4,
45, 'YES', 39)
2012-10-08 17:33:07,332 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00690063\U006c0073\U005f006f\U00630075\U00750074', 12,
u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12, None,
20, 46, 'YES', 39)
2012-10-08 17:33:07,333 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00700073\U00630065\U0073005f\U006d0079\U006f0062', 12,
u'\U00610076\U00630072\U00610068', 50, 50, None, None, 1, None, None, 12, None,
50, 47, 'YES', 39)
2012-10-08 17:33:07,334 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00750065\U0062005f\U006e0061\U0061006b', 12,
u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12, None,
20, 48, 'YES', 39)
2012-10-08 17:33:07,335 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f', u'\U006f0072\U005f0064\U00690063',
12, u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12,
None, 20, 49, 'YES', 39)
2012-10-08 17:33:07,336 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f', u'\U00630069', 12,
u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12, None,
20, 50, 'YES', 39)
2012-10-08 17:33:07,337 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0070\U0069007a\U00650063\U0070005f\U00760075', 12,
u'\U00610076\U00630072\U00610068', 3, 3, None, None, 1, None, None, 12, None, 3,
51, 'YES', 39)
2012-10-08 17:33:07,338 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f', u'\U006f0070\U00740073\U00700075',
12, u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12,
None, 20, 52, 'YES', 39)
2012-10-08 17:33:07,339 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U0073006f\U0063005f\U00730069\U006f006c\U0072005f\U00640065\U00740069\U006c0065',
12, u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12,
None, 20, 53, 'YES', 39)
2012-10-08 17:33:07,339 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U0073006f\U0063005f\U00730069\U006f006c\U0072005f\U00640069\U00630069', 12,
u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12, None,
20, 54, 'YES', 39)
2012-10-08 17:33:07,340 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U0073006f\U0063005f\U00730069\U006f006c\U0073005f\U006f0070\U007a006e\U0072006f',
12, u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12,
None, 20, 55, 'YES', 39)
2012-10-08 17:33:07,341 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U0073006f\U0063005f\U00730069\U006f006c\U0070005f\U00650072\U00730064\U00610074',
12, u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12,
None, 20, 56, 'YES', 39)
2012-10-08 17:33:07,342 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f', u'\U00790074\U006f0070\U00610076',
12, u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12,
None, 20, 57, 'YES', 39)
2012-10-08 17:33:07,343 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f', u'\U006d007a\U006e0065', 12,
u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12, None,
20, 58, 'YES', 39)
2012-10-08 17:33:07,344 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0070\U006e007a\U006d0061\U0061006b', 12,
u'\U00610076\U00630072\U00610068', 2000, 2000, None, None, 1, None, None, 12,
None, 2000, 59, 'YES', 39)
2012-10-08 17:33:07,345 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f', u'\U006f0070\U0075006b', 12,
u'\U00610076\U00630072\U00610068', 50, 50, None, None, 1, None, None, 12, None,
50, 60, 'YES', 39)
2012-10-08 17:33:07,346 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U0073006f\U0063005f\U00730069\U006f006c\U0073005f\U006f0070\U007a006e\U0072006f\U006e005f\U00770065',
12, u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12,
None, 20, 61, 'YES', 39)
2012-10-08 17:33:07,347 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0062\U00790064\U0063005f\U006c0065\U0065006b', 3,
u'\U00650064\U00690063\U0061006d', 18, 20, 6, 10, 1, None, None, 3, None, None,
62, 'YES', 106)
2012-10-08 17:33:07,348 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006c0062\U006b006f\U0076006f\U006e0061\U005f0079\U006f0070\U00740073\U00700075',
5, u'\U006d0073\U006c0061\U0069006c\U0074006e', 5, 2, 0, 10, 1, None, None, 5,
None, None, 63, 'YES', 38)
2012-10-08 17:33:07,349 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00760065\U00640069\U006e0065\U006e0063\U005f0069\U00690063\U006c0073', 12,
u'\U00610076\U00630072\U00610068', 10, 10, None, None, 1, None, None, 12, None,
10, 64, 'YES', 39)
2012-10-08 17:33:07,350 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006f0062\U00790064\U0063005f\U006c0065\U0065006b\U005f006d\U00300032\U00350030\U00310030',
3, u'\U00650064\U00690063\U0061006d', 18, 20, 6, 10, 1, None, None, 3, None,
None, 65, 'YES', 106)
2012-10-08 17:33:07,351 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00690063\U006c0073\U005f006f\U006c0073\U00760065\U006b005f\U00720061\U00790074',
12, u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12,
None, 20, 66, 'YES', 39)
2012-10-08 17:33:07,352 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00650072\U005f0067\U00690063\U006c0073\U005f006f\U0066006d', 12,
u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12, None,
20, 67, 'YES', 39)
2012-10-08 17:33:07,353 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00650072\U005f0067\U00690063\U006c0073\U005f006f\U00660075', 12,
u'\U00610076\U00630072\U00610068', 20, 20, None, None, 1, None, None, 12, None,
20, 68, 'YES', 39)
2012-10-08 17:33:07,353 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00610064\U00750074\U005f006d\U00720070\U00640069\U0073005f\U0065006c\U005f0076\U0061006b\U00740072',
11, u'\U00610064\U00650074\U00690074\U0065006d', 23, 16, 3, None, 1, None, None,
9, 3, None, 69, 'YES', 111)
2012-10-08 17:33:07,354 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U0062006f\U006f0064\U00690062\U0070005f\U00690072\U005f0064\U006c0073\U00760065\U006b005f\U00720061\U00790074',
12, u'\U00610076\U00630072\U00610068', 6, 6, None, None, 1, None, None, 12,
None, 6, 70, 'YES', 39)
2012-10-08 17:33:07,355 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00610067\U005f0072\U0072006f\U00670069\U0063005f',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 71, 'YES', 38)
2012-10-08 17:33:07,356 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00610067\U005f0072\U0072006f\U00670069\U0073005f',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 72, 'YES', 38)
2012-10-08 17:33:07,357 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006d007a\U006e0065\U005f0061\U00610067\U005f0072\U007a0063', 11,
u'\U00610064\U00650074\U00690074\U0065006d', 23, 16, 3, None, 1, None, None, 9,
3, None, 73, 'YES', 111)
2012-10-08 17:33:07,358 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U006d007a\U006e0065\U005f0061\U00610067\U005f0072\U006b0073', 11,
u'\U00610064\U00650074\U00690074\U0065006d', 23, 16, 3, None, 1, None, None, 9,
3, None, 74, 'YES', 111)
2012-10-08 17:33:07,359 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00750064\U006f0076\U005f0064\U006d007a\U006e0065\U005f0079\U00610067\U005f0072\U007a0063',
5, u'\U006d0073\U006c0061\U0069006c\U0074006e', 5, 2, 0, 10, 1, None, None, 5,
None, None, 75, 'YES', 38)
2012-10-08 17:33:07,360 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00750064\U006f0076\U005f0064\U006d007a\U006e0065\U005f0079\U00610067\U005f0072\U006b0073',
5, u'\U006d0073\U006c0061\U0069006c\U0074006e', 5, 2, 0, 10, 1, None, None, 5,
None, None, 76, 'YES', 38)
2012-10-08 17:33:07,361 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00610064\U00750074\U005f006d\U0061006c\U00740073\U0063005f', 11,
u'\U00610064\U00650074\U00690074\U0065006d', 23, 16, 3, None, 1, None, None, 9,
3, None, 77, 'YES', 111)
2012-10-08 17:33:07,362 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00610064\U00750074\U005f006d\U0061006c\U00740073\U0073005f', 11,
u'\U00610064\U00650074\U00690074\U0065006d', 23, 16, 3, None, 1, None, None, 9,
3, None, 78, 'YES', 111)
2012-10-08 17:33:07,363 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006c006d\U0075006f\U00610076\U006c005f\U00730061\U005f0074\U007a0063',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 79, 'YES', 38)
2012-10-08 17:33:07,364 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006c006d\U0075006f\U00610076\U006c005f\U00730061\U005f0074\U006b0073',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 80, 'YES', 38)
2012-10-08 17:33:07,365 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U00720074\U006b0075\U005f0074\U0061006d\U005f006e\U007a0063',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 81, 'YES', 38)
2012-10-08 17:33:07,367 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U00720074\U006b0075\U005f0074\U0061006d\U005f006e\U006b0073',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 82, 'YES', 38)
2012-10-08 17:33:07,368 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U006f0072\U005f0073\U007a0063',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 83, 'YES', 38)
2012-10-08 17:33:07,369 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U006f0072\U005f0073\U006b0073',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 84, 'YES', 38)
2012-10-08 17:33:07,370 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00690074\U006b0073\U0070005f\U005f0073', 12,
u'\U00610076\U00630072\U00610068', 1, 1, None, None, 1, None, None, 12, None, 1,
85, 'YES', 39)
2012-10-08 17:33:07,371 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00690074\U006b0073\U0070005f\U005f0073', 12,
u'\U00610076\U00630072\U00610068', 1, 1, None, None, 1, None, None, 12, None, 1,
86, 'YES', 39)
2012-10-08 17:33:07,373 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00690074\U006b0073\U0070005f\U005f0073', 12,
u'\U00610076\U00630072\U00610068', 1, 1, None, None, 1, None, None, 12, None, 1,
87, 'YES', 39)
2012-10-08 17:33:07,374 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00690074\U006b0073\U0070005f\U005f0073', 12,
u'\U00610076\U00630072\U00610068', 1, 1, None, None, 1, None, None, 12, None, 1,
88, 'YES', 39)
2012-10-08 17:33:07,375 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00690074\U006b0073\U0070005f\U005f0073\U005f0031\U00750072\U006e0063', 12,
u'\U00610076\U00630072\U00610068', 1, 1, None, None, 1, None, None, 12, None, 1,
89, 'YES', 39)
2012-10-08 17:33:07,376 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00690074\U006b0073\U0070005f\U005f0073\U005f0033\U00750072\U006e0063', 12,
u'\U00610076\U00630072\U00610068', 1, 1, None, None, 1, None, None, 12, None, 1,
90, 'YES', 39)
2012-10-08 17:33:07,377 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00690074\U006b0073\U0070005f\U005f0073', 12,
u'\U00610076\U00630072\U00610068', 1, 1, None, None, 1, None, None, 12, None, 1,
91, 'YES', 39)
2012-10-08 17:33:07,378 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00690074\U006b0073\U0070005f\U005f0073\U005f0035\U00750072\U006e0063', 12,
u'\U00610076\U00630072\U00610068', 1, 1, None, None, 1, None, None, 12, None, 1,
92, 'YES', 39)
2012-10-08 17:33:07,379 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00730070\U00640065\U005f006d\U006b0061\U005f0074\U007a0063',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 93, 'YES', 38)
2012-10-08 17:33:07,381 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00730070\U00640065\U005f006d\U006b0061\U005f0074\U006b0073',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 94, 'YES', 38)
2012-10-08 17:33:07,382 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00720068\U005f006b\U007a0063',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 95, 'YES', 38)
2012-10-08 17:33:07,383 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00640069\U006d005f\U006d006c\U0073005f\U006f0070\U005f006c\U00720068\U005f006b\U006b0073',
4, u'\U006e0069', 10, 4, 0, 10, 1, None, None, 4, None, None, 96, 'YES', 38)
2012-10-08 17:33:07,384 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00720070\U0076006f\U007a0069\U0069006e\U0073005f\U00610074', -7,
u'\U00690062', 1, 1, None, None, 1, None, None, -7, None, None, 97, 'YES', 50)
2012-10-08 17:33:07,385 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U0065006d\U0069006e\U005f0074\U00750061\U006f0074\U0061006d\U00690074\U006b0063\U005f0079\U00730070\U00610074',
-7, u'\U00690062', 1, 1, None, None, 0, None, u'\U00310028', -7, None, None, 98,
'NO', 50)
2012-10-08 17:33:07,386 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U0064007a\U005f0061\U00700075\U0061006c\U006e0074\U0076006f\U00740061\U006b005f\U00650072\U00690064',
-7, u'\U00690062', 1, 1, None, None, 0, None, u'\U00310028', -7, None, None, 99,
'NO', 50)
2012-10-08 17:33:07,388 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f',
u'\U00650070\U00690072\U0064006f\U005f0061\U006f0064\U00610073\U006e0068\U00740075\U005f0069\U006f0070\U0069007a\U00650063',
5, u'\U006d0073\U006c0061\U0069006c\U0074006e', 5, 2, 0, 10, 0, None,
u'\U00300028', 5, None, None, 100, 'NO', 52)
2012-10-08 17:33:07,389 DEBUG sqlalchemy.engine.base.Engine Row
(u'\U0046005a\U005f0050\U00520043', u'\U00620064',
u'\U006c006d\U005f006d\U00700073\U006c006f', u'\U00690066\U006d0072', 12,
u'\U00610076\U00630072\U00610068', 50, 50, None, None, 1, None, None, 12, None,
50, 101, 'YES', 39)
Traceback (most recent call last):
File
"/home/lada/.eclipse/org.eclipse.platform_3.8_155965261/plugins/org.python.pydev_2.6.0.2012062818/pysrc/pydevd.py",
line 1392, in <module>
debugger.run(setup['file'], None, None)
File
"/home/lada/.eclipse/org.eclipse.platform_3.8_155965261/plugins/org.python.pydev_2.6.0.2012062818/pysrc/pydevd.py",
line 1085, in run
pydev_imports.execfile(file, globals, locals) #execute the script
File "/home/lada/mine/devel/python/ZFP/zfp_connect.py", line 16, in <module>
x = db.mlm_spol.fetchone()
File "/usr/lib/python2.7/dist-packages/sqlalchemy/ext/sqlsoup.py", line 807,
in __getattr__
return self.entity(attr)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/ext/sqlsoup.py", line 804,
in entity
return self.map_to(attr, tablename=attr, schema=schema)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/ext/sqlsoup.py", line 684,
in map_to
schema=schema or self.schema)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/schema.py", line 318, in
__new__
table._init(name, metadata, *args, **kw)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/schema.py", line 381, in
_init
self._autoload(metadata, autoload_with, include_columns)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/schema.py", line 397, in
_autoload
self, include_columns, exclude_columns
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2426,
in run_callable
return conn.run_callable(callable_, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1969,
in run_callable
return callable_(self, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
260, in reflecttable
return insp.reflecttable(table, include_columns, exclude_columns)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/reflection.py", line
412, in reflecttable
raise exc.NoSuchTableError(table.name)
sqlalchemy.exc.NoSuchTableError: mlm_spol
On 8.10.2012 17:18, Michael Bayer wrote:
>
> On Oct 8, 2012, at 11:10 AM, Ladislav Lenart wrote:
>
>> Ok, I will give it yet another try, but please note that the following works:
>>
>> import pyodbc
>> from sqlalchemy.engine import create_engine
>> from sqlalchemy.ext.sqlsoup import SqlSoup
>>
>> def connect():
>> return
>> pyodbc.connect('DRIVER={FreeTDS};SERVER=10.230.128.140;PORT=1433;DATABASE=ZFP_CRM;UID=efractal;PWD=efR@cZFP13;TDS_VERSION=8.0;')
>> engine = create_engine('mssql+pyodbc://', creator=connect)
>> db = SqlSoup(engine)
>> x = db.execute("select * from mlm_spol").fetchone()
>> print x
>>
>>
>> i.e. raw SqlSoup.execute() sees the table and returns a valid result.
>>
>>
>> I regard this as a proof that the connection was established successfully and
>> the problem lies elsewhere. Am I wrong?
>
>
> perhaps. Maybe the connection doesn't have correct access to the information
> schema tables, as SQLSoup relies upon table reflection. you'd need to run
> with echo='debug' on your engine to see exactly what queries are being
> emitted and the rows being returned, and determine why an information schema
> row for "mlm_spol" isn't being returned.
>
>
--
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
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
