On Mon, Apr 30, 2012 at 8:52 AM, Adam Tauno Williams awill...@whitemice.org
wrote:
On Sun, 2012-04-15 at 05:32 -0700, Kyle Schaffrick wrote:
Wow, a blast from the past! :)
Yes.
Which version of SQLAlchemy does your new version work with? It's
great that you are now able to get rid
2010 06:38:32 UTC+2 schrieb Kyle Schaffrick:
Greetings,
I'm looking into using PostgreSQL's hstore type in a SQLAlchemy
project, and before I possibly reinvent the wheel I was wondering if
anyone has/knows of an implementation of an hstore custom type for SQLA?
I'm basically just interested
On Thu, 29 Jul 2010 15:18:33 + (UTC)
Faheem Mitha fah...@email.unc.edu wrote:
On Thu, 29 Jul 2010 11:36:43 +0100, King Simon-NFHD78
simon.k...@motorola.com wrote:
You can tell meta.create_all() to use the same underlying DB
connection as the session by using the session.connection()
On Fri, 7 May 2010 09:01:05 -0700
David Gardner dgard...@creatureshop.com wrote:
Thank you, I haven't started using hstore in my production environment
yet, but wanted to do some tests with it as a way for users to attach
arbitrary key/value metadata to nodes. Are you currently using a
Gin or
On Thu, 6 May 2010 10:39:28 -0400
Michael Bayer mike...@zzzcomputing.com wrote:
On May 5, 2010, at 11:46 PM, Kyle Schaffrick wrote:
1. While you can override existing operators that work on
ColumnElements without doing much funny business, if you want to
add *new* operations
On Wed, 5 May 2010 15:01:08 -0700
David Gardner dgard...@creatureshop.com wrote:
I was just considering something similar. Were you able to get far
with this?
Yes, actually I've got a pretty good start on it. The only obvious
thing missing right now is a Comparator implementation so that the
On Wed, 7 Apr 2010 10:15:14 -0400
Michael Bayer mike...@zzzcomputing.com wrote:
Kyle Schaffrick wrote:
Greetings,
I'm looking into using PostgreSQL's hstore type in a SQLAlchemy
project, and before I possibly reinvent the wheel I was wondering if
anyone has/knows of an implementation
Greetings,
I'm looking into using PostgreSQL's hstore type in a SQLAlchemy
project, and before I possibly reinvent the wheel I was wondering if
anyone has/knows of an implementation of an hstore custom type for SQLA?
I'm basically just interested in simply mapping a stand-alone attribute
On Sat, 24 Oct 2009 04:02:04 -0700 (PDT)
sector119 sector...@gmail.com wrote:
Hi All.
I've got UnicodeDecodeError: 'ascii' codec can't decode byte 0xa1 in
position 3: ordinal not in range(128)
Why it can happen? I use client_encoding=utf8 at postgresql.conf and
encoding=utf-8 at
On Mon, 12 Oct 2009 13:47:19 -0500
Conor conor.edward.da...@gmail.com wrote:
Christian Démolis wrote:
Hi,
The idea of creating another column is good but it will multiplicate
the size of my table by 2 for nothing. Is it possible to use MYSQL
regular expression search with sql
On Mon, 13 Jul 2009 19:18:39 -0400
Michael Bayer mike...@zzzcomputing.com wrote:
Brad Wells wrote:
Is it possible to perform a query.count() on a query with a labeled
column expression without count() adding the subselect? I need to
filter on the value of the expression and get a count
On Wed, 15 Jul 2009 10:35:24 -0400
Michael Bayer mike...@zzzcomputing.com wrote:
Kyle Schaffrick wrote:
On Mon, 13 Jul 2009 19:18:39 -0400
Michael Bayer mike...@zzzcomputing.com wrote:
Brad Wells wrote:
Is it possible to perform a query.count() on a query with a
labeled
On Wed, 17 Jun 2009 07:14:18 -0700 (PDT), allen.fowler
allen.fow...@yahoo.com wrote:
3) Can this relation's objects be made read-only? That is:
u.room = new_room would work, but this would not: u.room.name =
'kitchen'
To clarify the question:
Can this objects seen via this relation be
On Mon, 11 May 2009 09:01:06 -0700 (PDT)
polaar steven.vereec...@gmail.com wrote:
this would even be easier (and correcter if the terms contain %)
written as:
cond = or_(*[Fruit.name.contains(term) for term in terms])
Indeed, good catch. I was so interested in the apply or_ logic that
On Fri, 8 May 2009 12:52:09 -0700 (PDT)
Bryan bryanv...@gmail.com wrote:
I can't figure out a clean way of adding a bunch of filter terms to a
query in a loop joined by an OR clause. Successive calls to filter
join the expressions by AND. I would like to do something like the
following,
On Thu, 23 Apr 2009 12:45:44 -0400 (EDT)
Michael Bayer mike...@zzzcomputing.com wrote:
clearly you have to figure out what runs on your server or what cache
clears itself on tuesdays, and also we'd need to see the actual error
message in your stacktrace. the trace is probably a distant
On Thu, 23 Oct 2008 16:16:50 -0400
Michael Bayer [EMAIL PROTECTED] wrote:
On Oct 23, 2008, at 3:40 PM, [EMAIL PROTECTED] wrote:
hi
i've no much idea about sql views, so i want to ask something.
As i understand, views are sort-of virtual tables consisting of
whatever a query
On Tue, 14 Oct 2008 18:33:10 +0200
Werner F. Bruhin [EMAIL PROTECTED] wrote:
Please check Kyle's answer to your first post.
Perhaps Google Groups is having mail delivery issues (again), so I'll
just repeat/clarify :)
On Tue, 14 Oct 2008 08:57:14 -0700 (PDT)
victoria [EMAIL PROTECTED] wrote:
On Wed, 15 Oct 2008 15:44:02 +0100
nesrine nesrine [EMAIL PROTECTED] wrote:
I fix an ordianary user with password, but I have the same error.
I think that this problem is from file configure pg_hda.conf, but
I not find tutorial witch has instruction about change in this file.
think very
On Mon, 13 Oct 2008 01:53:13 -0700 (PDT)
nano [EMAIL PROTECTED] wrote:
hello,
I'm new to sqlalchemy and database
I just installed postgres http://doc.fedora-fr.org/wiki/
Installation_et_configuration_de_PostgreSQL,
and I have a problem connecting to my database
with a script sqlalchemy
On Mon, 6 Oct 2008 11:24:00 -0700 (PDT)
Michael Bayer [EMAIL PROTECTED] wrote:
On Oct 6, 2:19 pm, coder_gus [EMAIL PROTECTED] wrote:
Hi, I am writing an application server using twisted and sqlalchemy.
On the server - database relation I use a pool of threads each with
its own
On Fri, 12 Sep 2008 11:11:50 -0400
Michael Bayer [EMAIL PROTECTED] wrote:
On Sep 11, 2008, at 11:01 PM, sakesun wrote:
I need sqlalchemy to work on ironpython (1.2 or 2.0b)
sqlalchemy fail on ironpython even with simple use case
like create simple Table definition.
from
On Mon, 8 Sep 2008 13:22:53 +0300
[EMAIL PROTECTED] wrote:
maybe separate the objects to-be-saved from not-yet-to-save in your
app.code and dont leave that to SA?
do something, flush+commit, then do the rest...
I agree, this seems like the best way to get what you want. SQL's
On Sun, 7 Sep 2008 15:31:56 -0700 (PDT)
sandro dentella [EMAIL PROTECTED] wrote:
Hi,
I'm trying to flush deletion of single objects w/o triggering a
complete commit and even after reading the docs several time I think I
have not got it right. In a little test I manage to do it correctly:
On Thu, 4 Sep 2008 18:54:27 -0400
Michael Bayer [EMAIL PROTECTED] wrote:
as usual, since this one might turn out to be pretty controversial,
I welcome the list to comment on this one. The order_by().get()
idea does fall in the category of nonsensical as opposed to
ambiguous , perhaps
I can't figure out any good way to phrase my question without some
pipe-laying, so here I go...
I have a pattern of doing some various query activities in my app that
ultimately result in retrieving a single instance of one of my mapped
classes from the ORM. So naturally I stuck that pattern in
On Sat, 12 Jul 2008 16:02:15 -0400
Rick Morrison [EMAIL PROTECTED] wrote:
Suppose you have a list result of a simple query:
vector = S.query(MappedObj).filter(foo).all()
and assume MappedObj has a simple relation children, each of those in
turn having a simple relation
On Sun, 13 Jul 2008 00:18:35 -0400
Kyle Schaffrick [EMAIL PROTECTED] wrote:
To setup the eagerness of cs at the exact point of lazy load,
the public API that allows this is via lazy='dynamic', which would
allow:
a = sess.query(A).first()
print a.bs.option(eagerload('cs')).first
On Sat, 12 Jul 2008 22:01:50 +0300
[EMAIL PROTECTED] wrote:
after the Query is long gone?
if it is really gone/done, who should eager-load?
I assume that it would be possible to do it after the Query is gone, at
least in theory, since lazy-loaded attributes are able to trigger
eager-loads
On Tue, 24 Jun 2008 18:22:49 -0700 (PDT)
bukzor [EMAIL PROTECTED] wrote:
The Query.join() documentations says:
def join(self, prop, id=None, aliased=False, from_joinpoint=False)
'prop' may be one of:
* a class-mapped attribute, i.e. Houses.rooms
What exactly counts as
On Wed, 25 Jun 2008 00:23:41 -0700 (PDT)
bukzor [EMAIL PROTECTED] wrote:
Thanks! That works, but is the line I quoted just wrong or outdated or
what?
This is what I'm talking about, under def join()
On Sat, 7 Jun 2008 22:21:20 -0700 (PDT)
Tomer [EMAIL PROTECTED] wrote:
I have two follow-up questions:
1) From what I understand, if I read an object (eg, Student) from
the database, modify that object or other objects, and then commit, I
have no guarantee that the object didn't change
On Tue, 20 May 2008 18:10:31 -0700 (PDT)
Marcus Cavanaugh [EMAIL PROTECTED] wrote:
I've read the ShardedSession docs a few times. The shard_chooser()
callable is straightforward, and thanks to the example [1], I think I
understand how to use query_chooser(); but I need a pointer about how
to
On Sat, 3 May 2008 07:03:56 -0400
Kyle Schaffrick [EMAIL PROTECTED] wrote:
I'm in the process now of rebasing against
user_defined_state.
I just got done uploading the rebased series. That little rowtuple
change turned out to be the biggest headache to adapt to :)
In any
On Tue, 8 Apr 2008 22:40:40 -0400
Douglas Mayle [EMAIL PROTECTED] wrote:
Hi everybody, I was hoping to ask for a bit of help...
I've been trying various ways to share metadata between modules so
that one module I import can use and improve upon the models I've
created in a different
On Thu, 1 May 2008 12:20:39 -0400
Michael Bayer [EMAIL PROTECTED] wrote:
at first the second method seemed a little hacky to me, but now that
i think about it, we're in the sharded query so removing the extra
entity is not a big deal.The first method is probably not as
fragile as
I've done some more work on this little project and have managed to
produce a significantly more idiomatic version. Since it has turned into
a full blown patch series, I'll save your inboxes and direct you
to the whole queue at
http://raidi.us/edarc/sqlalchemy
This contains the iterator
On Wed, 30 Apr 2008 03:34:16 -0700 (PDT)
Olli Wang [EMAIL PROTECTED] wrote:
Hi, I'm trying to determine whether the url's database exists or not,
but didn't find any approach. I created a sqlite engine:
engine = create_engine('sqlite:///test.sqlite')
And tried to connect it:
On Sun, 27 Apr 2008 23:35:06 -0400
Kyle Schaffrick [EMAIL PROTECTED] wrote:
Since as I mentioned, this is kind of an interesting learning project
for me to learn some SA internals, I'd like my next step to be seeing
if I can write something that will make a callable/closure which, when
passed
On Mon, 28 Apr 2008 16:22:44 -0400
Michael Bayer [EMAIL PROTECTED] wrote:
so, lets name it _merge_ordering() to start so we have some future
leeway on the name.
Changes made.
Well, in fact the result.close() at the end there is not really
needed; when all result rows are exhausted,
On Thu, 27 Mar 2008 10:24:10 -0400
Michael Bayer [EMAIL PROTECTED] wrote:
On Mar 27, 2008, at 7:39 AM, crybaby wrote:
Correct me if I am wrong, as of right now, relationship between
multiple db shards, like sorting, grouping and joins have to be done
in application level.
that is
On Sun, 27 Apr 2008 20:23:24 -0400
Michael Bayer [EMAIL PROTECTED] wrote:
But yes its probably how that section should be done anyway so that
ShardedQuery so that the iterative framework provided by
iterate_instances() (this method would need to be used instead of
instances()).
I
On Sun, 27 Apr 2008 20:39:25 -0400
Kyle Schaffrick [EMAIL PROTECTED] wrote:
On Sun, 27 Apr 2008 20:23:24 -0400
Michael Bayer [EMAIL PROTECTED] wrote:
But yes its probably how that section should be done anyway so
that ShardedQuery so that the iterative framework provided
43 matches
Mail list logo