Michael,
Thanks for confirming that, seems it was a strong reference to the session
which was a local function variable, if was being destroyed and
unreferencing my object.
I'll look at ways to combat that ;-)
Cheers,
Heston
From: sqlalchemy@googlegroups.com [mailto:[EMAIL
On Oct 13, 2008, at 6:41 AM, [EMAIL PROTECTED] wrote:
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_( bindparam('somename') )) fails
...
File sqlalchemy/sql/expression.py, line 1368, in _in_impl
for o in seq_or_selectable:
TypeError:
hello,
I'm new to sqlalchemy and database
I just installed postgres http://doc.fedora-fr.org/wiki/
Installation_et_configuration_de_PostgreSQL,
and I have a problem connecting to my database
with a script sqlalchemy
the error is File/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.0-
On Oct 13, 6:41 am, [EMAIL PROTECTED] wrote:
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_( bindparam('somename') )) fails
...
File sqlalchemy/sql/expression.py, line 1368, in _in_impl
for o in seq_or_selectable:
TypeError:
On Oct 13, 10:21 am, Michael Bayer [EMAIL PROTECTED] wrote:
On Oct 13, 2008, at 6:41 AM, [EMAIL PROTECTED] wrote:
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_( bindparam('somename') )) fails
...
File sqlalchemy/sql/expression.py,
nano wrote:
hello,
I'm new to sqlalchemy and database
I just installed postgres http://doc.fedora-fr.org/wiki/
Installation_et_configuration_de_PostgreSQL,
and I have a problem connecting to my database
with a script sqlalchemy
the error is
On Monday 13 October 2008 17:21:31 Michael Bayer wrote:
On Oct 13, 2008, at 6:41 AM, [EMAIL PROTECTED] wrote:
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_( bindparam('somename') )) fails
...
File sqlalchemy/sql/expression.py, line 1368,
Hi,
I'm not sure whether this is a bug in sqlalchemy or user error. I'm
having trouble passing a parameter to execute() that is a list of
values for the in operator.
E.g.:
session.execute(sql.text('SELECT * from users where x in :xs'),
params={'xs' : some_seq})
This works fine when using
I have my table Warehouse collumns like:
id, owner_id , area_total, area_office ... ,area_storage
I would like to have acces to all areas by Warehouse.area.property:
example:
Warehouse.area.storage
I did composite(), but now I can't filter like:
filter(Warehouse.area.total =100) and even
Michael Bayer wrote:
On Oct 13, 2008, at 10:58 AM, [EMAIL PROTECTED] wrote:
On Monday 13 October 2008 17:21:31 Michael Bayer wrote:
On Oct 13, 2008, at 6:41 AM, [EMAIL PROTECTED] wrote:
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_(
On Oct 13, 2008, at 11:14 AM, g00fy wrote:
I have my table Warehouse collumns like:
id, owner_id , area_total, area_office ... ,area_storage
I would like to have acces to all areas by Warehouse.area.property:
example:
Warehouse.area.storage
I did composite(), but now I can't filter
I use entity_name's for all mappers. So I dont have mappers with
entity_name = None.
With sqlalchemy 0.4 I run into errors if I try to add objects to
InstrumentedList's:
(Pdb) len( self.users )
1
(Pdb) self.users
[common.User object at 0x1d1992a8]
(Pdb) type( self.users )
class
the entity_name feature is somewhat broken in 0.4 and has been removed
entirely in 0.5 - there's too much ambiguity in its usage (namely, the
attributes/behavior of a class cannot be determined until the class is
associated with a specific mapper via the session). Its possible
that this
On Mon, 13 Oct 2008 01:53:13 -0700 (PDT)
nano [EMAIL PROTECTED] wrote:
hello,
I'm new to sqlalchemy and database
I just installed postgres http://doc.fedora-fr.org/wiki/
Installation_et_configuration_de_PostgreSQL,
and I have a problem connecting to my database
with a script sqlalchemy
On Oct 13, 2008, at 10:58 AM, [EMAIL PROTECTED] wrote:
On Monday 13 October 2008 17:21:31 Michael Bayer wrote:
On Oct 13, 2008, at 6:41 AM, [EMAIL PROTECTED] wrote:
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_( bindparam('somename') ))
why i cannot give in_() a bindparam?
q.filter( x.in_( somelistorset )) works
q.filter( x.in_( bindparam('somename') )) fails
...
File sqlalchemy/sql/expression.py, line 1368, in _in_impl
for o in seq_or_selectable:
TypeError: '_BindParamClause' object is not iterable
is this possible or
What is preventing you from simply mapping different classes ?
Different Customers uses different (her own) table spaces. So we must map a
Class to different tables.
You remove entity_name, but how you specify the 'user dependent storage' in
sqlalchem 0.5? This behavior is a typical
[EMAIL PROTECTED] wrote:
I spent some time to migrate to sqlalchemy 0.4 and it's to late to go back to
0.3. What can I do to add objects to properties (InstumentedLists) in
sqlalchemy 0.4 (with different mappers)?
I suspect that case will work if you add the user to the session under
the
On Oct 11, 1:29 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On Oct 11, 2008, at 12:49 PM, AndyDavidoffwrote:
This fixes the first part of this problem, but unfortunately the `show
create table` is performed in the connection, not the session in which
the temporary table was created. MySQL
On Oct 13, 2008, at 11:13 AM, Jonathan Marshall wrote:
Hi,
I'm not sure whether this is a bug in sqlalchemy or user error. I'm
having trouble passing a parameter to execute() that is a list of
values for the in operator.
E.g.:
session.execute(sql.text('SELECT * from users where x in
Andy Davidoff wrote:
On Oct 11, 1:29 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On Oct 11, 2008, at 12:49 PM, AndyDavidoffwrote:
This fixes the first part of this problem, but unfortunately the `show
create table` is performed in the connection, not the session in which
the temporary table
see a thread composites started by me on 21.08.2008 - i have
something named composer for such embedded structures but i have
not yet moved further into how to make that one a Comparable in terms
of query.filter(). u can try do it...
On Monday 13 October 2008 18:14:42 g00fy wrote:
I have my
On Oct 13, 2008, at 12:22 PM, [EMAIL PROTECTED] wrote:
What is preventing you from simply mapping different classes ?
Different Customers uses different (her own) table spaces. So we
must map a Class to different tables.
You remove entity_name, but how you specify the 'user dependent
On Oct 13, 2008, at 12:29 PM, Andy Davidoff wrote:
On Oct 11, 1:29 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On Oct 11, 2008, at 12:49 PM, AndyDavidoffwrote:
This fixes the first part of this problem, but unfortunately the
`show
create table` is performed in the connection, not the
How this Proxy object is going to work exacly?
Will that generate extra Sql or what?
I assume that I should just change __getattr__() to desired and return
Warehouse.key ? or warehouse_table.c.key?
On 13 Paź, 17:25, Michael Bayer [EMAIL PROTECTED] wrote:
On Oct 13, 2008, at 11:14 AM, g00fy
Hi,
I am trying to transfer some data from a sqlite database to an MS SQL
database. I need to be able to pass null values for some of the empty
columns in the row. For example, I have something like this for my
row's format:
date | id | reg | ot | hol
The first two fields are required, but any
On Oct 13, 2008, at 2:59 PM, Mike wrote:
Hi,
I am trying to transfer some data from a sqlite database to an MS SQL
database. I need to be able to pass null values for some of the empty
columns in the row. For example, I have something like this for my
row's format:
date | id | reg | ot
On Oct 13, 2008, at 2:50 PM, g00fy wrote:
How this Proxy object is going to work exacly?
Will that generate extra Sql or what?
I assume that I should just change __getattr__() to desired and return
Warehouse.key ? or warehouse_table.c.key?
the proxy, which actually should read:
class
many thanks to jason and michael!
I add the objects to the current session and ... it works.
Migration to 0.5 seems to be a big step (for us).
We don't use fancy orm tricks. The only thing are 'user dependet table spaces'.
Hence its possible your example, michael, can work for us. Thanks.
29 matches
Mail list logo