Re: [sqlalchemy] Postgresql multi scheme recreate mapper ?

2015-01-19 Thread M3nt0r3
-SCHEMAS-PATH M3nt0r3 m3n...@gmail.com javascript: wrote: Hi, I have a postgresql with many scheme, every schema is a company. I am trying to change the scheme to match the user is making the login or change the schema per subdomain. ( at wsgi level it already worked ) when

Re: [sqlalchemy] Postgresql multi scheme recreate mapper ?

2015-01-19 Thread M3nt0r3
the query give me always the old Class. thanks Il giorno lunedì 19 gennaio 2015 17:15:45 UTC+1, Michael Bayer ha scritto: M3nt0r3 m3n...@gmail.com javascript: wrote: Here, in the log i change the search_path to veterfarma that is the news scheme but the query is performed

[sqlalchemy] Postgresql multi scheme recreate mapper ?

2015-01-18 Thread M3nt0r3
Hi, I have a postgresql with many scheme, every schema is a company. I am trying to change the scheme to match the user is making the login or change the schema per subdomain. ( at wsgi level it already worked ) when the first user make the login is ok , meta and mappers are there mapped to

[sqlalchemy] Re: Classic to declarative join tables problem

2015-01-18 Thread M3nt0r3
Il giorno mercoledì 7 gennaio 2015 17:22:44 UTC+1, M3nt0r3 ha scritto: Hi, i am migrating from classic to declarative and i am stuck on this mapper. whit classic mapper it works well. __table__ = Table('table2', params[metadata], Column('id', Integer, primary_key=True

[sqlalchemy] Classic to declarative join tables problem

2015-01-07 Thread M3nt0r3
Hi, i am migrating from classic to declarative and i am stuck on this mapper. whit classic mapper it works well. __table__ = Table('table2', params[metadata], Column('id', Integer, primary_key=True), __table__ = Table('table1', params[metadata],

[sqlalchemy] mysql error creating Table

2013-07-23 Thread M3nt0r3
I am porting a building scheme system to mysql ( it works on postgresql and sqlite so far ) but i have some issues with datetime ( solved ) and with ( within others tables ) this table : t_listino_articolo = Table('listino_articolo', params[metadata], Column('id_listino',

[sqlalchemy] Pypi release policy

2011-02-14 Thread M3nt0r3
Yesterday my life become an hell. :) On saturday ( :O ) SA0.7.b1 is released and easy_install start to use it. The problem is that it broke some installer and doesn't work with my app. I think that i'd better if easy_install sqlalchemy continue di install the stable branches of the lib and maybe

Re: [sqlalchemy] Pypi release policy

2011-02-14 Thread M3nt0r3
My installer for windows download during the process some libs. I use easy_install sqlalchemy and it works. Now too works but 0.7.b1 is not working with the app itself now so it create a lot of problem. I thought that if 0.7.b1 is a beta and brokes API maybe it should be better to use

[sqlalchemy] Handling a connection error

2010-12-06 Thread M3nt0r3
HI, i am trying to handle the error c on connection when db is stopped or unrechable. File /usr/lib/python2.6/dist-packages/sqlalchemy/pool.py, line 213, in __init__ self.connection = self.__connect() File /usr/lib/python2.6/dist-packages/sqlalchemy/pool.py, line 279, in __connect

[sqlalchemy] Re: TypeError: an integer is required

2010-10-09 Thread M3nt0r3
I found the problem. in my sqlite test db i had a boolean field empty and the fetch failed with that error. TypeError: an integer is required i don understand why with SA installed from pypi ( both 0.6.3 and 0.6.4 ) it worked and with the 0.6.3 installed with deb no. sorry to all and thanks

[sqlalchemy] TypeError: an integer is required

2010-10-08 Thread M3nt0r3
when i try to use the 0.6.3 deb with maverick i have this error: File /home/vete/pg2_work/trunk/core/promogest/dao/Dao.py, line 115, in select return self.record.all() File /usr/lib/python2.6/dist-packages/sqlalchemy/orm/query.py, line 1453, in all return list(self) File

[sqlalchemy] Re: TypeError: an integer is required

2010-10-08 Thread M3nt0r3
this is in the maverick deb code: def create_row_processor(self, selectcontext, path, mapper, row, adapter): key, col = self.key, self.columns[0] if adapter: col = adapter.columns[col] if col is not None and col in row: def new_execute(state,

[sqlalchemy] Server / Client-gtk app

2009-11-08 Thread M3nt0r3
Hi , i am sorry for my english, i am trying ti make a Server/Client app. Until now client-gtk mapped the db and spoked directly with the db ( sqlite and postgresql atm) . I wrote a small wsgi server based on werkzeug, and it basically make the same thing of the client-gtk but in pure web style.