Hi,
I've a problem like this:
http://groups.google.be/group/sqlalchemy/browse_thread/thread/e3ff5bd168f5045a
Now, I'am using sqa 0.3.10, and a very complex mapper estructure.
orm.mapper(PrestacionGrupo, prestacion_grupo)
orm.mapper(Prestacion, prestacion, properties={
'grupo':
If you're using easy_install to install them, you should be able to
install them with the '-m' (--multiversion) switch. See:
http://peak.telecommunity.com/DevCenter/EasyInstall#command-line-options
Choosing the version you want to use in your application is then done
like this:
import
On Jan 23, 2008, at 8:01 AM, maxi wrote:
I create an instance of Convenio [ convenio = Convenio() ]
I do, convenio.prestaciones.delete(obj_instance) for delete a object
from prestaciones list.
Now, if I delete one object only, this work fine, but if I delete many
(i.e: two obj) that error
Hello,
still working intensivly with joined table inheritance. I have troubles
making a long join across many tables. I need to query players from
player_table where on the other end, slots_hot.id == 'foo':
player_table = Table('players', meta,
Column('id', Integer, primary_key=True),
Hi,
I have an existing piece of functionality but I am wondering if there
are ways to improve the code. A short summary what I have. I modelled
a person class which can have different roles, one being a student
role, another one being an employee role, an alumni role and so on.
Now I am trying
I am trying to change the default column type mapping in sqlalchemy.
Analogous to the description in the MySQLdb User's Guide (http://mysql-
python.sourceforge.net/MySQLdb.html) I tried the following.
from MySQLdb.constants import FIELD_TYPE
my_conv = { FIELD_TYPE.DECIMAL: float }
ENGINE =
On Jan 23, 2008, at 10:25 AM, Alexandre Conrad wrote:
Hello,
still working intensivly with joined table inheritance. I have
troubles
making a long join across many tables. I need to query players from
player_table where on the other end, slots_hot.id == 'foo':
player_table =
I'm trying to use types.TypeDecorator to define a set of strings
stored in the database as a csv list, where the empty set is stored as
null. process_bind_param seems to work, as values set on the bound
field seem to get entered correctly; but process_result_value never
seems to be called when
On Jan 23, 2008, at 11:09 AM, Jonathon Anderson wrote:
I'm trying to use types.TypeDecorator to define a set of strings
stored in the database as a csv list, where the empty set is stored as
null. process_bind_param seems to work, as values set on the bound
field seem to get entered
Adrian wrote:
I am trying to change the default column type mapping in sqlalchemy.
Analogous to the description in the MySQLdb User's Guide (http://mysql-
python.sourceforge.net/MySQLdb.html) I tried the following.
from MySQLdb.constants import FIELD_TYPE
my_conv = { FIELD_TYPE.DECIMAL:
the error is specifically about a many to many table where it expects
to delete two rows but only one matches the criteria. If you are
using more than one session, or removing rows from a many to many
table using SQL statements, this error can occur.
Sorry, I'am a little confuse abut it. (I
On Jan 23, 2008, at 2:15 PM, maxi wrote:
Sorry, I'am a little confuse abut it. (I have only one session)
I've the next table schema:
convenio(conv_id) --- conv_pre(conv_pre_id, conv_id, pre_id) ---
prestacion(pre_id)(convenio many to many with prestacion across
conv_pre)
On Jan 23, 2008, at 11:55 AM, Michael Bayer wrote:
On Jan 23, 2008, at 10:25 AM, Alexandre Conrad wrote:
model.Player.query.join(['site', 'playlists', 'hotlinks',
'hotslot']).filter(model.SlotHot.c.id=='foo').all()
another thing im considering, along the lines of what I mentioned in
do you have anything else mapped to the conv_pre table ? it should
*only* be mentioned in one place in your mapping setup.
I only have something like this:
class ConvPre(DBObject):
pass
mapper(ConvPre, conv_pre)
--~--~-~--~~~---~--~~
You received this
On Jan 23, 2008, at 2:34 PM, maxi wrote:
do you have anything else mapped to the conv_pre table ? it should
*only* be mentioned in one place in your mapping setup.
I only have something like this:
class ConvPre(DBObject):
pass
mapper(ConvPre, conv_pre)
OK, then you *cannot* use
What do you mean by textual strings? Do you mean strings backed by a
TEXT type, rather than a fixed-length string?
Why won't that work?
On Jan 23, 10:57 am, Michael Bayer [EMAIL PROTECTED] wrote:
On Jan 23, 2008, at 11:09 AM, Jonathon Anderson wrote:
I'm trying to use types.TypeDecorator
On Jan 23, 2008, at 3:01 PM, Jonathon Anderson wrote:
What do you mean by textual strings? Do you mean strings backed by a
TEXT type, rather than a fixed-length string?
Why won't that work?
no, i mean:
result = engine.execute(select * from table)
will not work with any TypeEngine or
Hi,
I have different outputs depending on using a select statement as
oppose to an object mapped query. This is happening when I am using
outer joins.
Here is the trace of the select that gives me something:
In 1: a = select([tblspotbandsol.c.spotbandsolid, tbllane.c.laneid],
OK, then you *cannot* use conv_pre as the secondary argument in
another relation(). You need to use an association:
If I remove ConvPre class and conv_pre mapper too. This problem is
solved ?
I don't need this class and mapper really.
BTW, I will take a look to associationproxy, this look
Thanks guys for your help I'm going to give Hermanns methods a go.
Morgan
Hermann Himmelbauer wrote:
Am Montag, 21. Januar 2008 01:16 schrieb Morgan:
Hi Guys,
I have field that I want to put a unique identifier in. This unique Id i
would like to be a composite key or simply a random
This may or may not be elixir specific...
If I have an auto-generated mapping table for a many-to-many
relationship, is there a sensible way to add another column to it that's
also has a foreign key relationship to a third table?
Like, if I had this:
Products
id int
name varchar
Oh, no. I'm not doing any raw sql.
I have (at a most basic level):
things_table = Table(things, metadata,
Column(id, types.Integer, primary_key=True),
Column(values, StringSet, nullable=True),
)
class Thing (object):
pass
Session.mapper(Thing, things_table)
But when I do
On Jan 23, 2008, at 3:28 PM, MattQc wrote:
Object query returns an empty set:
In 3: jLane = tblspotbandsol.outerjoin(tbllane,
tbllane.c.laneid==tblspotbandsol.c.laneid)
In 4: mapper(LaneClass,jLane)
Out4: sqlalchemy.orm.mapper.Mapper object at 0xb36f382c
In 5:
On Jan 23, 2008, at 4:25 PM, Jonathon Anderson wrote:
Oh, no. I'm not doing any raw sql.
I have (at a most basic level):
things_table = Table(things, metadata,
Column(id, types.Integer, primary_key=True),
Column(values, StringSet, nullable=True),
)
class Thing (object):
On Jan 23, 2008, at 4:24 PM, Monty Taylor wrote:
This may or may not be elixir specific...
If I have an auto-generated mapping table for a many-to-many
relationship, is there a sensible way to add another column to it
that's
also has a foreign key relationship to a third table?
Like,
Hello, I have not been able to figure this out from the docs.
I would like to setup and teardown test data using mapped classes.
The problem is that those same mapped classes need to be used by the
application under test and in case there is an error, the teardown
still needs to run so that
On Jan 23, 2008, at 5:00 PM, Kumar McMillan wrote:
Hello, I have not been able to figure this out from the docs.
I would like to setup and teardown test data using mapped classes.
The problem is that those same mapped classes need to be used by the
application under test and in case there
Hi
On Jan 23, 2008 4:07 PM, Michael Bayer [EMAIL PROTECTED] wrote:
your teardown code can't have any dependencies on the test code
itself. So at the very least start the teardown phase with
PrivateSession.close() so that you start fresh.
I tried adding that to the teardown code but then
Kumar McMillan wrote:
Hello, I have not been able to figure this out from the docs.
I would like to setup and teardown test data using mapped classes.
The problem is that those same mapped classes need to be used by the
application under test and in case there is an error, the teardown
On Jan 23, 2008 4:36 PM, Kumar McMillan [EMAIL PROTECTED] wrote:
...but it still fails with the same error, Deleted rowcount 0 does not
match number of objects deleted 1. What am I missing? I don't
understand how the teardown code is dependent on the app code if it is
using a different
Hi All,
I'm starting a new project that will probably be using Twisted, but I
want to use SQLAlchemy as well. I saw a couple of old posts about
Asynchronous SQLAlchemy and two different implementations, but neither
sAsync nor nadbapi seem to be maintained (or at least have new
versions posted),
So, in constructing my test case, I figured out what was going on.
(I'm sure this is often the case.)
http://pastebin.com/m612561a6
The problem is that process_result_value is only called when actually
loading values from the database, and since a session maintains an
object cache for object
On Jan 23, 2008, at 10:16 PM, Jonathon Anderson wrote:
So, in constructing my test case, I figured out what was going on.
(I'm sure this is often the case.)
http://pastebin.com/m612561a6
The problem is that process_result_value is only called when actually
loading values from the
Thanks for the info - what is the current version?
Alex
On Jan 22, 2008 2:36 PM, Michael Bayer [EMAIL PROTECTED] wrote:
One thing I can see is that you're using an older version of SA, since
that error message has been changed (either 0.4.0 or an old 0.3
version). It means that you cannot
I understand that solution. I did say without a python property.
But if that's the only real way to do it, so be it. Maybe I was just
looking for an excuse to learn how to define a custom type. ;)
~jon
On Jan 23, 9:56 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On Jan 23, 2008, at 10:16 PM,
apart of all runtime issues u've hit - session etc - on declaration
level u'll may do these:
- destroy all your refs to the mappers/tables etc
- sqlalchemy.orm.clearmappes()
- yourmetadata.drop_all()
- yourengine.dispose()
- destroy refs to yourmetadata/yourengine
36 matches
Mail list logo