Server has it either.
On Apr 18, 2011, at 4:57 PM, bukzor wrote:
SQL-92 defines a row value constructor expression like (1,2,3)
which looks and behaves exactly like a Python tuple, as far as I can
tell. These are implemented correctly in mysql at least, and I believe
PostgreSQL
SQL-92 defines a row value constructor expression like (1,2,3)
which looks and behaves exactly like a Python tuple, as far as I can
tell. These are implemented correctly in mysql at least, and I believe
PostgreSQL and Oracle as well, although I don't have access to those
systems.
What would be
On Nov 20, 7:39 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On Nov 20, 2008, at 9:05 PM, bukzor wrote:
Would it make sense to rename Insert.values to Insert.params? Or make
Insert.params call Insert.values.
It seems quite strange for an object to have functions that aren't
usable
On Nov 20, 6:20 pm, Empty [EMAIL PROTECTED] wrote:
Different, but related question: How do I print out the statement in
copy-paste-able format? More specifically, how do i get an ordered
list of bound values out of the statement?
This code does what I want, but it's really clunky and
Sorry for double posting. I pressed Send before I was ready...
Please let me know if I'm doing something wrong here:
[code]
metadata = MetaData('sqlite:///first.sqlite')
table = Table('my_table', metadata, Column('text', Unicode(16)))
stmt = table.insert()
I expect I'm doing this wrong, but it seems broken to me. Please let
me know.
Here's what I'm doing:
stmt = metadata.tables['tf_user'].insert()
parameters=dict(id=1,user_name='bgolemon',password='badpass',display_name='Buck
Golemon',created=None)
print stmt.compile().params
import search
args = search(\((.*?)\), s).group(1).split(, )
print s % tuple(repr(stmt.params[arg]) for arg in args)
On Nov 20, 5:29 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On Nov 20, 2008, at 6:16 PM, bukzor wrote:
The second crashes with:
File /tools/aticad/1.0/external/python
Why is this so hard?? In SQLObject, this problem consists entirely
of:
print queryobj
Bye all,
--Buck
On Jun 25, 11:23 am, Michael Bayer [EMAIL PROTECTED] wrote:
On Jun 25, 2008, at 2:14 PM, bukzor wrote:
Thanks.
Trying to do this in 0.5, it seems someone deleted the Query.compile
On Jun 25, 10:50 am, Michael Bayer [EMAIL PROTECTED] wrote:
On Jun 25, 2008, at 1:24 PM, bukzor wrote:
Thanks for that versioning overview.
Sorry for changing the topic (Should I make a separate post?), but is
there a way to make the joins more automatic?
I'd like to just specify
On Jun 26, 8:29 am, Michael Bayer [EMAIL PROTECTED] wrote:
On Jun 26, 2008, at 11:12 AM, bukzor wrote:
Sorry for being a pest, but I've looked at the documentation and
really can't figure this out. If a mapped class is a node of our
graph, where do I find the edges, and how do I get
?
On Jun 24, 11:52 pm, Kyle Schaffrick [EMAIL PROTECTED] wrote:
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 the query object.
On Jun 25, 7:25 am, Michael Bayer [EMAIL PROTECTED] wrote:
On Jun 24, 2008, at 9:27 PM, bukzor wrote:
Is there a way to print out the query as it would execute on the
server? I'd like to copy/paste it into the server to get the 'explain'
output, and the '%s' variables
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 class-mapped? I've set up a ForeignKey in my
Files table as well as a backref
Is there a way to print out the query as it would execute on the
server? I'd like to copy/paste it into the server to get the 'explain'
output, and the '%s' variables are very unhelpful here.
I'd also like to turn off the 'alias and backtick-escape every column'
default behavior if I can.
14 matches
Mail list logo