I've got several questions about dealing with concurrency issues in
SQLAlchemy. To try and help with the asking, I'll use a small example
similar to a situation I've got in an SQLAlchemy application. In this
application, there is a table that tracks objects and their order/
position, something li
> While the above code uses some patterns that are unnecessary, there's nothing
> about it which would cause that error to occur. To my knowledge, the only
> way that particular condition arises is if a flush occurs at an inappropriate
> time, namely within an object load, which does not seem
Hi guys,
An update: Mike is right! The connector doesn't get along with child
processes... For a quick setup and since I'm using uWSGI and Nginx, I
just created a cluster o uwsgi connections and ran 3 independent
process of my application. All my tests passed nicely.
@Warwick I'm using mysql-pyth
On 11/9/2010 3:55 PM, Gunnlaugur Briem wrote:
select([
func.ARRAY(
select([t.c.value])
.where(t.c.id<3)
.as_scalar()
)
.label('array_col')
])
Thank you! That works swimmingly.
I now know why my search didn't turn up anything as it is evidently one of
those "If the func
Shoot!! It works!! :D :D
-- Parent.py (extract) --
# . . .
child1 = relationship(
"Child",
uselist=True,
primaryjoin=lambda: and_((Parent.id == Child.parent_id),
(Child.type
== "VR")),
On Nov 8, 2010, at 6:36 PM, Hector Blanco wrote:
> methods that I have implemented and that need to be there. That would
> be the "ZepConnector" (and, for purposes of the example, it's method
> foo() it's the one I need to use). As you can see in the following
> lines, I randomly test its availab
Hi Alan
We're also doing battle with this one.. One thing I did find was if I had
large(ish) BLOB values, MySQL would go away. I found that I had to tweak some
settings on MySQL to allow for larger sizes. (The default settings appear to
be ridiculously small). Let me know what else you fi
On Nov 9, 2010, at 4:56 PM, Alan Castro wrote:
> Hello,
>
> Latelly I've been running into this issue:
>
> OperationalError: (OperationalError) (2013, 'Lost connection to MySQL
> server during query') SELECT...
>
> To contextualize, I developed a Pylons application using
> scoped_session (defa
Hello,
Latelly I've been running into this issue:
OperationalError: (OperationalError) (2013, 'Lost connection to MySQL
server during query') SELECT...
To contextualize, I developed a Pylons application using
scoped_session (default in pylons). And it was working until I created
some extra proce
This works:
select([
func.ARRAY(
select([t.c.value])
.where(t.c.id<3)
.as_scalar()
)
.label('array_col')
])
- Gulli
On Nov 9, 3:43 pm, Michael Hipp wrote:
> Can someone show me the gist of how to construct an SA query that
> produces SQL* of the form
>
> SELECT ARRAY(SELECT
On Tue, Nov 9, 2010 at 4:10 PM, Domingo Aguilera
wrote:
> Werner,
>
> I am using kinterbasdb downloaded just few days ago. Also I am using
> sqla 0.6.5 .
>
> I worked with firebird rdbms engine several years ago but not from
> python. This is the first time I am using firebird from python and
>
Can someone show me the gist of how to construct an SA query that
produces SQL* of the form
SELECT ARRAY(SELECT ... FROM ... WHERE ...) as array_col
Thanks,
Michael
*
http://www.postgresql.org/docs/8.4/interactive/sql-expressions.html#SQL-SYNTAX-ARRAY-CONSTRUCTORS
--
You received this mess
On Nov 9, 2010, at 8:47 AM, yannick wrote:
> The following simple code does not seem to produce the ALTER statement
> expected for the Contact.ownername column.
> When I look at the DB, there is no ForeignKeyConstraint on
> Contact.ownername.
SQLite doesn't support ALTER on an existing Column c
On Nov 9, 2010, at 3:44 AM, Torsten Engelbrecht wrote:
> Hi,
>
> I need to use dynamic table names in a project (though for the same
> object). Now I got the following problem:
> - I fetch data from an RSS feed to fill my database. Its an RSS feed
> with many pages, each page has around 100 item
this is usually called a "read slave" and you do it by either switching the
"bind" used in your Session, or by using two different sessions.In a web
application I'll typically build a decorator for controllers that performs this
switch transparently:
@uses_master
def my_controller_method(se
The following simple code does not seem to produce the ALTER statement
expected for the Contact.ownername column.
When I look at the DB, there is no ForeignKeyConstraint on
Contact.ownername.
I think this results in problems later on: when I activate the
relationships, I cannot do
v=User(username=
Werner,
I am using kinterbasdb downloaded just few days ago. Also I am using
sqla 0.6.5 .
I worked with firebird rdbms engine several years ago but not from
python. This is the first time I am using firebird from python and
from sqlalchemy ( been using python since 2004 ).
I have an app in w
Sorry for the double thread. I was waiting for it to show up for
hours. Please remove one of them. Thanks
On Nov 9, 4:44 pm, Torsten Engelbrecht
wrote:
> Hi,
>
> I need to use dynamic table names in a project (though for the same
> object). Now I got the following problem:
> - I fetch data from a
Hi,
I need to use dynamic table names in a project (though for the same
object). Now I got the following problem:
- I fetch data from an RSS feed to fill my database. Its an RSS feed
with many pages, each page has around 100 items
- I fetch the first page and create a table + mapper for a dynamic
Hi,
I need to use dynamic table names in a project (though for the same
object). Now I got the following problem:
- I fetch data from an RSS feed to fill my database. Its an RSS feed
with many pages, each page has around 100 items
- I fetch the first page and create a table + mapper for a dynamic
Hi, Michael
Thanks so much for your feedback. You were right on the button (second
scenario): I was pretty sure I was passing a scalar to the list's
append() method but was, in fact, passing it another list.
Help greatly appreciated, really.
Regards
On Nov 6, 2:58 pm, Michael Bayer wrote:
> On
On 09/11/2010 01:34, Michael Bayer wrote:
not sure if anyone knows. I have 2.1 running here for my own tests.
On Nov 8, 2010, at 5:05 PM, Domingo Aguilera wrote:
Is firebird 2.5 working with sqla. ?
I am in the midst of moving to FB 2.5 and SA 0.6.5 and have not
encountered any problems y
22 matches
Mail list logo