Just a quick update ... Mac OS X is case preserving but case
insensitive so a query directly within mysql for table USER using
user will result correctly. So this just deepens the mystery more -
on UNIX either MySQLdb or SQLAlchemy is preserving the case of the
table name as USER but on Mac OS X
-Original Message-
From: sqlalchemy@googlegroups.com
[mailto:sqlalch...@googlegroups.com] On Behalf Of kkapron
Sent: 01 October 2009 21:27
To: sqlalchemy
Subject: [sqlalchemy] Select from multiple databases
Hello, I'm a beginner in sqlalchemy and I've got a problem with select
*Hello M. Bayer
Ok i understand now what it is strange
My configuration
I m on windows xp pro sp3
Python is 2.5.2
SqlAlchemy is 0.5.6
Dell optiplex 755
Intel core 2 duo e8300
2go ram
**
I dont pass any paremeters in create_engine, is it wrong?*
chaine =
I does a mistake in my last, that is the results (error in parameters of
mysqldb connection)
Local database
Update 1000 MySQLdb 0.0319998264313
Update 1000 SqlAlchemy 0.265999794006
France-Tunisia
Update 1000 MySQLdb 10.391324
Update 1000 SqlAlchemy 42.157924
Sorry
2009/10/2 Christian
Hi everyone!
I have a class Document with attributes Number and Date, is
there a way to set a UniqueConstraint on Number + year(Date)?
(SQLAlchemy 0.5.5, PostgreSQL 8.3.4)
Thanks in advance!
--~--~-~--~~~---~--~~
You received this message because you are
Hi,
I need to get a single event at an extension in case of such operation:
obj.colAttr = [x, y, z]
right now I will receive:
extension.remove(...) for each value currently in colAttr
extension.append(...) for x, y and z.
what I need is something like:
extension.replace(oldvalues, values)
I want to list the all 'Groups' that 'Users' belong to as indicated by
the User2Group link table - as well as the Groups the user does not
belong to. This returns the desired data set except it is not filtered
for a particular user,
# output not filtered for user
s.query(Group,
rootsmith wrote:
Just a quick update ... Mac OS X is case preserving but case
insensitive so a query directly within mysql for table USER using
user will result correctly. So this just deepens the mystery more -
on UNIX either MySQLdb or SQLAlchemy is preserving the case of the
table name
On 2 Ott, 10:42, Joril jor...@gmail.com wrote:
I have a class Document with attributes Number and Date, is
there a way to set a UniqueConstraint on Number + year(Date)?
Self-followup: should I use a unique Index instead? But how do you
create a functional index in SQLAlchemy?
My module is called sandbox.py
After importing it to ipython and letting it run, here's what I get
for the test you suggested:
In [47]: (sandbox.price_sources.c.desciption=='EJV').right.type
Out[47]: OracleChar(length=100, convert_unicode=False,
assert_unicode=None)
The trouble that for some
Hi,
I'm struggling trying to merge two patterns which separately are no-
brainers in sqa: joined tabled inheritance and (an arbitrary number
of) graph relationships, here represented as connections and
dependencies. I've run into quite a few different errors from the
following code using version
Thomas Drake wrote:
primary = dep_groups.join(dep_group_components,
dep_groups.c.group_id==dep_group_components.c.group_id).join
(dependencies_table,
dep_group_components.c.group_id==dependencies_table.c.parent_id)
secondary = dep_groups.join(dep_group_components,
On Oct 2, 3:41 pm, Michael Bayer mike...@zzzcomputing.com wrote:
Thomas Drake wrote:
primary = dep_groups.join(dep_group_components,
dep_groups.c.group_id==dep_group_components.c.group_id).join
(dependencies_table,
dep_group_components.c.group_id==dependencies_table.c.parent_id)
tavol wrote:
I want to list the all 'Groups' that 'Users' belong to as indicated by
the User2Group link table - as well as the Groups the user does not
belong to. This returns the desired data set except it is not filtered
for a particular user,
# output not filtered for user
14 matches
Mail list logo