Re: [sqlalchemy] Filtering on Postgresql BigInteger array

2013-04-16 Thread Michael Bayer
You need to use the cast() function here to do an explicit cast on the SQL side. array([cast(node.id, BigInteger)]). The type_ argument in most other cases only describes the type on the Python side. Sent from my iPhone On Apr 16, 2013, at 12:42 PM, Alexander Bachmeier

Re: [sqlalchemy] Filtering on Postgresql BigInteger array

2013-04-16 Thread Alexander Bachmeier
On Tuesday, April 16, 2013 6:58:15 PM UTC+2, Michael Bayer wrote: You need to use the cast() function here to do an explicit cast on the SQL side. array([cast(node.id, BigInteger)]). The type_ argument in most other cases only describes the type on the Python side. Thanks a lot, that

[sqlalchemy] Session.add doesn't work on Python 3.3.0?

2013-04-16 Thread Tim Cooijmans
I have a strange error using Python 3.3.0 and SQLAlchemy 0.8.0: from sqlalchemy import create_engine, Integer, String, Text, Column, Sequence, DateTime, ForeignKeyfrom sqlalchemy.orm import sessionmaker, relationship, backreffrom sqlalchemy.ext.declarative import declarative_base engine =

Re: [sqlalchemy] Session.add doesn't work on Python 3.3.0?

2013-04-16 Thread Mauricio de Abreu Antunes
I think you need to commit your session data. Em terça-feira, 16 de abril de 2013, Tim Cooijmans escreveu: I have a strange error using Python 3.3.0 and SQLAlchemy 0.8.0: from sqlalchemy import create_engine, Integer, String, Text, Column, Sequence, DateTime, ForeignKeyfrom sqlalchemy.orm

Re: [sqlalchemy] Session.add doesn't work on Python 3.3.0?

2013-04-16 Thread Michael Bayer
cant reproduce, running with Python 3.3.0 here against 0.8.0 I get the INSERT: PRAGMA table_info(products) 2013-04-16 16:14:41,019 INFO sqlalchemy.engine.base.Engine () 2013-04-16 16:14:41,019 INFO sqlalchemy.engine.base.Engine CREATE TABLE products ( id INTEGER NOT NULL, name

Re: [sqlalchemy] Session.add doesn't work on Python 3.3.0?

2013-04-16 Thread Mauricio de Abreu Antunes
I tried your same code here I got True. Em terça-feira, 16 de abril de 2013, Michael Bayer escreveu: cant reproduce, running with Python 3.3.0 here against 0.8.0 I get the INSERT: PRAGMA table_info(products) 2013-04-16 16:14:41,019 INFO sqlalchemy.engine.base.Engine () 2013-04-16

[sqlalchemy] Querying using objects

2013-04-16 Thread Richard Gerd Kuesters
Hello all! Ok, maybe people asks this a lot, but I wonder if it's possible to perform a query using an object as a filter - and I searched for it, didn't found anything close to my idea. Simple dumb example code: *class User(Base):** ** ** user_id = Column(Integer, Sequence(...),

[sqlalchemy] SQLAlchemy introspection of relationships

2013-04-16 Thread ken
This has also been posted here: http://stackoverflow.com/questions/15950375/sqlalchemy-introspection-of-relationships, shoulda asked here first. I have a use case for modelling data in a SQL schema rather than through defining SQLAlchemy objects. However, i require a way to construct the

Re: [sqlalchemy] SQLAlchemy introspection of relationships

2013-04-16 Thread Michael Bayer
same answer: sqlalchemy has no built in facility for generating relationship() structures automatically. there's a library called sqlautocode that does this but I don't know its status. On Apr 12, 2013, at 11:03 AM, ken cmor...@reddeer.gb.com wrote: This has also been posted here:

Re: [sqlalchemy] Querying using objects

2013-04-16 Thread Michael Bayer
On Apr 16, 2013, at 9:30 AM, Richard Gerd Kuesters rich...@humantech.com.br wrote: Hello all! Ok, maybe people asks this a lot, but I wonder if it's possible to perform a query using an object as a filter - and I searched for it, didn't found anything close to my idea. Simple dumb

[sqlalchemy] How to map a oracle table with long table name

2013-04-16 Thread Evan Jon
Hello all, I want to map a table whose name is BAND_ORDER_OF_LOCAL_TESTING. class BandOrderOfLocalTesting(Base): __TABLENAME__ = 'BAND_ORDER_OF_LOCAL_TESTING' order_id = Column(order_id, Number(18), primary_key=True) ... Each time I got the following message: 013-04-17 09:26:55,857