Wow, I want to unlearn this.
"""
For the benefit of some ODBC applications, the following query can be
used to find a newly inserted row: ... SELECT * FROM tbl_name WHERE
auto IS NULL;
All further executions of the same statement provide the expected result
"""
Thanks, Michael!
--diana
On Tue,
yeah you'd have to search around MySQL's bugtracker for that one, I've seen it
before, the only record I can find at the moment is #4 here:
http://sql-info.de/mysql/gotchas.html#1_1
On Oct 26, 2010, at 11:16 PM, Diana Clarke wrote:
> Any ideas why I'm getting one row back with an id of 5 whe
Any ideas why I'm getting one row back with an id of 5 when I filtered
by id IS NULL?
[SQLAlchemy-0.6.4, MySQL 5, MyISAM]
sqlalchemy.engine.base.Engine.0x...eb2c: INFO: SELECT user.id AS
user_id, user.username AS user_username, user.level AS user_level
FROM user
WHERE user.level = %s AND user
http://grok.zope.org/documentation/how-to/orm-using-megrok.rdb-and-sqlalchemy
http://www.sqlalchemy.org/docs/
--
Jeffrey D Peterson
Webmaster
Crary Industries, Inc.
237 12th St NW
West Fargo, ND 58078
P: 701-499-5928
E: jeff.peter...@crary.com
> -Original Message-
> From: sqlalchemy@goog
Hi group!
I am trying to migrate my application from ZopeDB to MySql. I am using
sqlalchemy under megrok.rdb.
I have a class which inherits from list() and has a few extra methods.
Reading the chapter about custom collections in sqlalchemy
(http://www.sqlalchemy.org/docs/orm/collections.html#cust
thanks, this is a simple issue that appears to be throughout the 0.6 series
only, resolved in r26f423a667ca which you can get at
http://hg.sqlalchemy.org/sqlalchemy/archive/26f423a667ca.tar.gz .
On Oct 26, 2010, at 2:41 PM, Lenza McElrath wrote:
> Thanks for the quick response Michael.
>
> I
Thanks for the quick response Michael.
I do not know why all references to the object are lost. Adding the asserts
you suggested shows that the object is in the session and in the dirty list
as expected.
I have been able to reproduce the issue with a simple test case. I have
untangled it from m
On Tue, Oct 26, 2010 at 10:20 AM, Michael Bayer wrote:
> perhaps an old SQLAlchemy version, cannot reproduce:
>
> That's weird. I have the same version. I downloaded 30 minutes before I
faced the problem. I even checked the version
--
Eknath Venkataramani
--
You received this message because
perhaps an old SQLAlchemy version, cannot reproduce:
>>> from sqlalchemy import __version__
>>> __version__
'0.6.5'
>>> from sqlalchemy import BigInteger
>>> BigInteger
>>>
On Oct 26, 2010, at 9:15 AM, blahsphemer wrote:
> I am unable to import the type BigInteger in my code, but integer,
>
On Oct 26, 2010, at 7:21 AM, Adam Medveczky wrote:
> Hi!
>
> I have a localization table, with a string_id, locale_id which make a
> composite key (and of course the localized string)
>
> I'd like to refer to it from various tables, based on a local field
> which resembles 'string_id'.
>
> If
the result should have a rowcount, yes. we have a lot of tests for rowcount
which pass so would need something very specific to test here.
On Oct 26, 2010, at 7:15 AM, Wichert Akkerman wrote:
> On an environment using SQLAlchemy 0.6.5 and psycopg 2.2.2 I run the
> following code:
>
> sess
I am unable to import the type BigInteger in my code, but integer,
string get imported flawlessly
I tried both:
from sqlalchemy import BigInteger
(and)
from sqlalchemy.types import BigInteger
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post
Hi!
I have a localization table, with a string_id, locale_id which make a
composite key (and of course the localized string)
I'd like to refer to it from various tables, based on a local field
which resembles 'string_id'.
If I wanted to do this with only one table referring to it, it would
be a
On an environment using SQLAlchemy 0.6.5 and psycopg 2.2.2 I run the
following code:
session.execute(Article.__table__.update()
.where(Article.retailer_id==self.retailer_id)
.where(Article.publish_end>=datetime.date.today())
.values(publish
14 matches
Mail list logo