You cannot pass "currval('users_user_id_seq')" as a parameter value, you
have to pass an integer value instead.
I solved this problem in this way:
"INSERT INTO employees
(employee_user_id, employee_id, employee_first_name,
employee_last_name, employee_address, employee_city, employee_state,
em
I would put the addCustomer method on something other than the customer
object, like the thing you're adding the customer to. Or bettery yet,
you'd probably be just appending the customer. I think for your
specific example, you should handle customer creation stuff (login +
password) in __in
it says to me:
Congratulations!
[Valid RSS] This is a valid RSS feed.
im not able to reproduce any issue in the straight FF reader.
On Feb 16, 2009, at 6:54 AM, Gaetan de Menten wrote:
>
> It seems like there is some bad character in one of the ticket details
> as it's been a few days s
use func.currval(literal_column('users_user_id_seq')).though I'm
not sure how SQLSoup is going to pass that in, its what *should* work.
On Feb 16, 2009, at 7:03 PM, Jeff Cook wrote:
>
> Hi all,
>
> I want to use the return value of a CURRVAL call as the value of a
> column in a row I'm in
Hi all,
I want to use the return value of a CURRVAL call as the value of a
column in a row I'm inserting, to link together related records. I'm
using Pylons with SQLAlchemy and SQLSoup. SQLAlchemy spits back at me
a DataError because I'm trying to place CURRVAL in an integer field.
How do I get t
Thank you for your replies.
With helper code I mean:
I want the architecture of my program so:
- There's a database
- Only SQLAlchemy talks to the database
- There is a function for every task that SQLAlchemy does
So, I want to do something like this in the end: addCustomer
(login='mylog
As I said in my previous mail, you really should look at the
"remote_side" keyword argument in your relation. This is what it was
done for and the paragraph "adjacency-list-relationships" from the
documentation covers all you need to know to deal with
self-referential relationships.
Here's the li
> So, does sqlalchemy support self 2 self relationship ?
> If the answer is "YES", how to do it?
You may want to look at the remote_side keyword argument.
http://www.sqlalchemy.org/docs/05/mappers.html#adjacency-list-relationships
Regards,
Alex
--~--~-~--~~~---~--~-
It seems like there is some bad character in one of the ticket details
as it's been a few days since I could access the Trac feed. My feed
reader (liferea) complains of:
XML Parsing Error: reference to invalid character number
Location: file:///
Line Number 20, Column 14:
Oh my mistake.
It works totally!
On 13 fév, 21:29, Michael Bayer wrote:
> On Feb 13, 2009, at 12:05 PM, GustaV wrote:
>
>
>
>
>
> > Hello!
>
> > In a configuration looking like this:
> > class Parent:
> > pass
>
> > class Child(Parent):
> > pass
>
> > class ChildChild(Child):
> > pass
>
>
thats diff. thing, see self-ref. relations
http://www.sqlalchemy.org/docs/05/mappers.html#adjacency-list-relationships
On Monday 16 February 2009 11:18:59 一首诗 wrote:
> Like this ?
> ---
>- class User(Base
Like this ?
class User(Base):
__tablename__ = 'users'
id = Column(Integer, primary_key=True)
name = Column(String)
fullname = Column(String)
password = Column(String)
sons = re
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This is covered by the decl. layer documentation (including examples):
- either use strings for the parameter
or
- you write outside the class scope
User.sons = relation()
- -aj
On 16.02.2009 9:57 Uhr, 一首诗 wrote:
> I tried to write :
>
> #
put it as text, it will be eval()'uated later
On Monday 16 February 2009 10:57:11 一首诗 wrote:
> I tried to write :
>
> #--
>-- class User(Base):
> __tablename__ = 'users'
>
> id = Column(Integer, primary_key=Tr
I tried to write :
#
class User(Base):
__tablename__ = 'users'
id = Column(Integer, primary_key=True)
name = Column(String)
fullname = Column(String)
password = Column(String)
sons = relat
15 matches
Mail list logo