I have a tester that controls 30 independent variables. Each variable can
have about 40 different values.
Periodically, I run a test. I choose 2 of the 30 independent variables, and
over the next few minutes, fully iterate those 2 variables relative to each
other, visiting each point in a
I posted this
questionhttp://stackoverflow.com/questions/16410888/sqlalchemy-aliases-not-aliasingto
StackOverflow, but thought this may be a better place to ask.
I have the following sqlalchemy code:
x = bbc.alias().c
w = bbc.alias().cselect([func.distinct(x.region)]).where(
update the SO question too for me...in this case it needs a clue to interpret
the select as a scalar:
subq = select([func.sum(w.population)]).where((w.region == x.region))
print select([func.distinct(x.region)]).where(subq.as_scalar() 1)
the WHERE 1 you're getting is because
Thanks, that worked!
A follow up question to make sure i'm understanding this right: I'm looking
at the effect of .as_scalar() on the query, and it seems that any query I
call .as_scalar() on simply gets wrapped in parenthesis. I tested it out
and it seems that it works even in cases where I
it's a Python thing, it turns the FromClause into a ColumnElement which then
has operators like __eq__(), __lt__(), etc.
On May 7, 2013, at 2:29 PM, Haoyi Li haoyi...@gmail.com wrote:
Thanks, that worked!
A follow up question to make sure i'm understanding this right: I'm looking
at the
On Wed, Jul 27, 2011 at 2:48 PM, Michael Bayer mike...@zzzcomputing.com wrote:
On Jul 27, 2011, at 3:21 PM, Kent Tenney wrote:
Howdy,
I'm aggregating data from several Sqlite files into a Postgres db.
The sqlite files are storage for several apps I use: Shotwell,
Firefox, Zotero, Banshee
On Jul 28, 2011, at 11:47 AM, Kent Tenney wrote:
It offers choices in that you can A. use core only or B. the ORM, as well
as choices in that it works with whatever kind of schema you'd like,
I'll be studying doc for a better idea of the A/B distinction, as
well as what kinds of schemas
Howdy,
I'm aggregating data from several Sqlite files into a Postgres db.
The sqlite files are storage for several apps I use: Shotwell,
Firefox, Zotero, Banshee ... I just watch and pull from them.
I've been using import sqlite3 so far, dumping sql from sqlite,
using it to create the Postgres
On Jul 27, 2011, at 3:21 PM, Kent Tenney wrote:
Howdy,
I'm aggregating data from several Sqlite files into a Postgres db.
The sqlite files are storage for several apps I use: Shotwell,
Firefox, Zotero, Banshee ... I just watch and pull from them.
I've been using import sqlite3 so far,
Hi,
Does SqlAlchemy query call __init__ on the mapped object?
i.e. Say I have mapped the object to table as follows:
mapper(Obj, Table)
Now, table contains:
index integer
x integer
y integer
And Obj is defined as
Class Obj:
def __init__(self, x, y):
I have just started using Python and TurboGears with SQLAlchemy and I
think its great so far. I am working with an already-created database
and am wondering what the best way is to represent the relationships
between the recurring_task and employee_status table:
employee_statuses =
'm just getting started with SA, and I'll want to be using it in a
back-end server with an existing mssql database. I'm considering
using Twisted as the basis for the server, and I've looked a bit into
using sAsync. I've had trouble getting the Twisted XML-RPC Server
Example to run, and that
Hi,
I keep getting The error: DBAPIError: (Connection failed)
(OperationalError) (1040, 'Too many connections').
At no time do I really need more than a few connections so I am doing
something basically wrong.
From reading the doc I concluded that pooling in the simple cases is
automatic. I must
In the following code, I intended that nothing will be inserted into
the table because the transaction fails and is rolled back. What
actually happens is that the first insert is not rolled back because
it s committed by itself.
What is the correct way to achieve my goal?
TIA
from sqlalchemy
I everyone. I'm pretty new to SQLAlchemy and never done much sql-related
work in the past as well so this could possibly be a silly question.
Suppose I've a table with a huge number of records. Now, I'd like to
access this table randomly through a list-like interface of a Python
class instance,
15 matches
Mail list logo