I'm trying to run the following sql using sqlalchemy ORM -
delete from feed_items where feed_id=27 order by published_on asc
limit 10;
I tried -
session.query(FeedItem).filter_by(feed_id=27).order_by
(FeedItem.published_on.asc()).limit(10).delete()
But this is deleting all rows instead of
Hi all,
i have a problem with attribute inheritance as seen here:
# Fails with Python-2.5.4 and SQLAlchemy-0.5.5
# There is happening something very strange, which causes
DeliveryTask.result not to cover Task.result even though
nivya wrote:
I'm trying to run the following sql using sqlalchemy ORM -
delete from feed_items where feed_id=27 order by published_on asc
limit 10;
I tried -
session.query(FeedItem).filter_by(feed_id=27).order_by
(FeedItem.published_on.asc()).limit(10).delete()
But this is deleting
Tefnet Developers wrote:
sqlalchemy.orm.column_property(sqlalchemy.Column(sqlalchemy.types.Integer),
extension = TefEx({0: 'Delivered', 1: 'Rejected', 2: 'Redirected', 3:
'Recipient dead'}))
task = DeliveryTask()
task.result = 3
AF wrote:
Hello,
Given hierarchical data similar to:
http://www.sqlalchemy.org/docs/05/mappers.html?#adjacency-list-relationships
With out resorting to brute force recursive queries in my objects:
1) Is there any way to retrieve all a node's children / sub-children?
2) Is there a way
AF wrote:
Hello,
Given hierarchical data similar to:
http://www.sqlalchemy.org/docs/05/mappers.html?#adjacency-list-relationships
With out resorting to brute force recursive queries in my objects:
1) Is there any way to retrieve all a node's children / sub-children?
2) Is there a way
Just thought I would toss in my 2-cents here, since I have lots of
hierarchical data and have
at one time or another used most of the below methods.
Choice #1 is the option that I have found that works the best.
I Use a file path-like primary key (actually I am storing data about
files), this
On 25 Jul 2009, at 03:17, mtrier wrote:
On Jul 23, 8:30 am, Ed Singleton singleto...@gmail.com wrote:
I've managed to get SA (0.6 branch) and pyodbc connecting to anMSSQL
db on Mac OS X, but I've recently been trying to get it working on
linux (Debian Lenny) and have been hitting some
On 26 Jul 2009, at 14:33, Timothy N. Tsvetkov wrote:
Please, tell me about using it in OS X? What driver do u use, versions
etc.
I've just started trying to properly document what I did. I've put up
a blog post about it:
On 26 Jul 2009, at 15:06, Michael Bayer wrote:
i have freetds 0.82, pyodbc 2.1.4. except for binary it mostly works
fine (with sqla 0.6).
Is that on Mac, Linux or both?
Did you do any particular configuration of character encodings?
Ed
Hello,
I want to implement a change log table something similar to
ticket_change table in trac.
ticket_change table structure:
Primary key (ticket, time, field)
Index (ticket, time)
ticket integer (fk to my table ticket)
time inetger
author
field
oldvalue
newvalue
How can I plugin my
Is it possible to manually set the type column of a base class when
using single table inheritance? The reason I want to do this is
because I am importing data from an external source which does not
differentiate between the subclass types.
For example:
a_table = Table('a', metadata,
On Jul 28, 2009, at 8:14 PM, NoDamage wrote:
Is it possible to manually set the type column of a base class when
using single table inheritance? The reason I want to do this is
because I am importing data from an external source which does not
differentiate between the subclass types.
On Jul 28, 2009, at 7:56 PM, Lukasz Szybalski wrote:
Hello,
I want to implement a change log table something similar to
ticket_change table in trac.
ticket_change table structure:
Primary key (ticket, time, field)
Index (ticket, time)
ticket integer (fk to my table ticket)
time
Hi
On Tue, Jul 28, 2009 at 3:14 PM, Ed Singleton singleto...@gmail.com wrote:
On 26 Jul 2009, at 15:06, Michael Bayer wrote:
i have freetds 0.82, pyodbc 2.1.4. except for binary it mostly works
fine (with sqla 0.6).
Is that on Mac, Linux or both?
Did you do any particular
15 matches
Mail list logo