[sqlalchemy] too many SQL variables in in_

Hi to all, I wrote a method like this to reuse the code for many tables at the same time[0] But, with more than 1000 records sqlite doesn't accepts the amount of id inside .in_(id_list) How can I filter, split or can manage it? Thanks a lot and best regards, Luca [0] def

Re: [sqlalchemy] Many parents to one child table query filter. How make it properly?

Il giorno martedì 26 novembre 2013 02:52:44 UTC+1, Michael Bayer ha scritto: not totally sure what you’re going for here as I think you’re looking at the problem using a different vocabulary. From the query you have at the bottom, it appears you’d want this: for teacher in

[sqlalchemy] Many parents to one child table query filter. How make it properly?

Hi to all, I've copied ([1]) and rewrote some parts of this code [0] that is usefull for my project, where I need to reusing some tables as a child of many parents. In concrete I need something like this: Table_parent_1 Table_parent_2 Table_child_1 Table_parent_1_to_child_1

[sqlalchemy] Re: Sqlalchemy, Postgres and SSL

Now it run properlyI just needed to upgrade my SA module to 0.6 Best regards! Luca -- 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

[sqlalchemy] Sqlalchemy, Postgres and SSL

Hi, how can I set my sqlalchemy engine to connect to a postgres on remote setting the ssl mode as allow? Thanks a lot! Luca -- 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

[sqlalchemy] Re: Bad file descriptor

Hi, and thanks for reply. How can I turn off the logging?? Thanks a lot luca -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to

[sqlalchemy] Bad file descriptor

Hi to all, I'm using a software called qgis that under windows embed python, and for this sw I wrote a simple plugin that insert and read data into postgres through sqlalchemy. Under mac os x, linux, and from the ide in windows all run properly, but, If I launch a query inside qgis I recive a

[sqlalchemy] How to use session to update record (newbie)

Hi to alls, still now I use this method to update values in my table: table.update(table.c.table_name, 'id_table' == 1').execute({'field_1': 'new_value'})) But now I want to use session. I look around the web and this list but I don't understand how to do it. Session =

[sqlalchemy] Insert sqlalchemy into a plugin

Hello everyone, I'm making a plugin for the software Qgis. I want to distribute the plugin with sqlalchemy already included. Under Mac OS, once compiled under 10.5, I noticed that it also works for 10.6. This happens even under Windows? I have to compile it under windows first and then put the

[sqlalchemy] Integer e null values - how to?

Hi, I have somes integer fields on my table, but sometimes I need to leave this empty when I pass the values. So, if from a GUI I pass the values '' or , I receives error. Also if I pass null. What kind of values I need to pass to leave the field empty? Thanks a lot, and merry Xmas!! -- You

[sqlalchemy] 0.6 - unexpected keyword argument 'transactional'

Hi! I'm trying to pass from sqlalchemy 0.5 to 0.6, but I found some trouble. This code, that run correctly with 0.5: def query(self, n): class_name = n #engine = self.connection() Session = sessionmaker(bind=self.engine, autoflush=True,

[sqlalchemy] 0.5.5 version - create_all problem

Hi, I've installed on python 2.5 sqlalchmey 0.5 and I receive a strange error, that before never appear: This error block my little app and I cannot use it as before. Somes suggestions?? Thanks a lot!! mando example.py from sqlalchemy import engine, schema, sql, types metadata

[sqlalchemy] Postgis+sqlalchemy - KeyError: geometry

Hi, I'm trying to update somes values into a postgis layer through sqlalchemy, but, when I connect with the table I receive this message: Traceback (most recent call last): File /Applications/qgis0.9.0.app/Contents/MacOS/share/qgis/python/ plugins/sortpglayer_plugin/pyarchinit_dbconn.py, line

[sqlalchemy] Re: Postgis+sqlalchemy - KeyError: geometry

On 20 Gen, 18:01, Michael Bayer [EMAIL PROTECTED] wrote: On Jan 20, 2008, at 11:57 AM, Mando wrote: I'm working on mac os x 10.4, python 2.5, SQLAlchemy-0.3.3, psycopg2-2.0.6, pgsql821+postgis121-1 upgrade to at least 0.3.11, the unknown column type of geometry will   produce

[sqlalchemy] Re: Postgis+sqlalchemy - KeyError: geometry

No, the problem appears also with SQLAlchemy-0.3.11 and SQLAlchemy-0.4.2p3. /Library/Frameworks/Python.framework/Versions/2.5/lib/python2.5/site- packages/SQLAlchemy-0.4.2p3-py2.5.egg/sqlalchemy/databases/postgres.py: 509: RuntimeWarning: Did not recognize type 'geometry' of column 'the_geom'

[sqlalchemy] Re: Postgis+sqlalchemy - KeyError: geometry

': warnings.warn(RuntimeWarning(Did not recognize type '%s' of column '%s' % (attype, name))) coltype = sqltypes.NULLTYPE : ) : ) Bye bye mando --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[sqlalchemy] Re: how to display all the tables of my DB

I launched it, but I receive this error message: Traceback (most recent call last): File autocode.py, line 20, in module tbl = Table(tname, metadata, schema=schema, autoload=True); File build/bdist.macosx-10.3-fat/egg/sqlalchemy/schema.py, line 143, in __call__ File

[sqlalchemy] how to display all the tables of my DB

I need to display into a checkListBox (I'm writin a GUI with wxPython) all the tables embedded in my Database. Initially I thought that I must to do something like this: from sqlalchemy import * db = create_engine('sqlite:///tutorial.db') metadata = BoundMetaData(db) print metatada.tables {}