Could it be because I'm defining it as a column to hold the
'itemsCount' value and so it generates to queries to get the value?
mapper( User, users_table, properties = {
'itemsCount': column_property(
select(
[func.count( items_table.c.id )],
Hi List,
I'm inexperienced with DBs so please bear with me.
I would like to return a list of all invoices that are assigned to a
specific client. However the relationships are built so that an
invoice has a foreign key to a project, which in turn has a foreign
key to a client:
Invoice.project
sorry, hit the send button a little too soon.
Any help on the above much appreciated,
Jules
--
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
Hi,
I'm getting a strange error in sqlalchemy/engine/base.py when I try to
use a mysql table with more than 6 columns and serve a page using
mod_wsgi.
Here's a simple dispatch.wsgi file that demonstrates the problem:
# Currently I have to do this:
from sqlalchemy import Table, Column, Text, Integer
Base = sqlahelper.get_base()
sometable = Table('sometable', Base.metadata,
Column('id', Integer, primary_key=True),
Column('discriminator', Text),
Column('data', Text))
class
Hi everyone!
Is it possible to have a many-to-one declarative relation between two
classes and a _filtered_ backref?
I'm trying to build a tagging system for my bloglike application, and
to allow a user to apply private tags to posts of other people. My
classes are:
Owner
Post
TagAssociation
Tag
On Jun 8, 2011, at 5:19 PM, Eric Ongerth wrote:
# Meanwhile, the following way of doing it doesn't work.
# But it seems like it would make sense and might be worth enabling.
class SomeClass(Base):
__table__ = Table('sometable', Base.metadata,
Column('id', Integer,
Hi,
I reviewed a couple of messages on the list concerning caching. While:
http://www.sqlalchemy.org/trac/browser/examples/beaker_caching
is quite comprehensive, it does not include any information about
performance gains or wether this example works for more complicated
queries, joining couple
Seems like it is an Apache problem. This error occurred on Apache
2.2.13 but not on a system with 2.2.19.
On Jun 8, 1:57 pm, doug holt doug.h...@gmail.com wrote:
Hi,
I'm getting a strange error in sqlalchemy/engine/base.py when I try to
use a mysql table with more than 6 columns and serve a
Hi,
I use Beaker in production to help speed up the delivery of game
content.
We've seen enormous (seconds to milliseconds) speed ups for caching
large queries that don't change.
We don't use it at the query level but as a way to cache whole results
from sqlalchemy.
As long as you remember to
10 matches
Mail list logo