your freetds datasource should be configured with CLIENT_CHARSET=utf8 as I
illustrated earlier:
[ms_2005]
host = 172.16.248.128
port = 1213
tds version = 8.0
client charset = UTF8
text size = 50000000
On Oct 8, 2012, at 11:43 AM, Ladislav Lenart wrote:
> 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.
