On Mar 17, 12:17 am, Alessandro Dentella san...@e-den.it wrote:
Now I want to get User class starting from Project and 'staff'.
Project.__mapper__.get_property('manager')._get_target().class_
seems to do that but the leading underscore in _get_target suggest it's
private, so I
thanks!
*:-)
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
I have the same problem, I've installed pysqlite (2.5.5) from sources,
and after I've removed it everything is ok.
I've tried to install the last one because I had a common problem:
ProgrammingError?: (ProgrammingError?) You must not use 8-bit
bytestrings unless you use a text_factory that can
Timothy N. Tsvetkov wrote:
I have the same problem, I've installed pysqlite (2.5.5) from sources,
and after I've removed it everything is ok.
I've tried to install the last one because I had a common problem:
ProgrammingError?: (ProgrammingError?) You must not use 8-bit
bytestrings unless
OK scratch that, it is in fact fetchone() raising an error on a closed
cursor that's the difference, the PRAGMA behavior, to my surprise, was
always there.
an adjustment to the sqlite dialect is made in r5846 for 0.5 and r5847 for
the 0.4 branch. A release for 0.5 should be made before
Hey guys
We're looking for a database-agnostic ORM package to build the
standard Concordance database classes on. This requires Py3 support.
http://concordance-xmpp.org/
Yes, yes, there aren't many DB packages for Py3 yet. This is exactly
why we're looking for something that's
Arc Riley wrote:
Yes, yes, there aren't many DB packages for Py3 yet. This is exactly
why we're looking for something that's database-agnostic; right now
we're limited to sqlite but preferably our classes shouldn't care what
database is being used and can just as readily be used with
Grr - you mean trunk *isn't* the head development tree in svn? Frustrating
in wasted time in duplicated effort. Can you please post this on the website
so others don't make the same mistake?
Ok. I can chalk this up to practice and a learning experience.
Yes - we're looking to use sqlalchemy in
I have a reasonably complex schema that I attempting to manage with
SQLAlchemy. I just added some tables in code and tried re-creating
the database, and got an error that looks like this:
##
sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1064, You have
an error in your SQL
Arc Riley wrote:
Grr - you mean trunk *isn't* the head development tree in svn?
Frustrating
in wasted time in duplicated effort. Can you please post this on the
website
so others don't make the same mistake?
trunk is the head dev tree in SVN, but we like to have trunk always
passing all
the String() type requires a length on MySQL, since MySQL has no
length-less VARCHAR construct.
mhearne808[insert-at-sign-here]gmail[insert-dot-here]com wrote:
I have a reasonably complex schema that I attempting to manage with
SQLAlchemy. I just added some tables in code and tried
the site is in need of updating regarding 0.6's existence but usually
people come in and chat on the list or IRC before starting major
development initiatives, but sorry, we'll add it.
Actually I've been asking on IRC for two days re: Py3. Nobody seemed to
know anything about this.
Hello list,
I need some advice on setting a one-to-many join in my particular case
(non-normalized db model)
I have the following situation:
- 2 tables with a 1..n join - note: the references table field is not
a primary key (I have to work on a non-normalized model, that's life)
- I need to
I don't see anything wrong with your model and no it shouldn't matter that
watersheds.name is not a primary key. expand upon the meaning of not
effective here.
Damien wrote:
Hello list,
I need some advice on setting a one-to-many join in my particular case
(non-normalized db model)
I have query on a view that looks like this:
query= dbSession.query(_class).filter('entry_status = 2').order_by
( _class.c.entry_authored_on.desc() ).limit(3).offset(0)
results= query.all()
print query
print - - - - - -
print results
print == == ==
this always returns no results.
however
try setting echo='debug'. it usually tells all. if any columns in
the primary key are NULL, the query won't return an object. If you
have partially null primary keys, set allow_null_pks=True on your
mapper.
On Mar 17, 2009, at 8:08 PM, Jonathan Vanasco wrote:
I have query on a
16 matches
Mail list logo