Re: [sqlalchemy] Re: Elixir question

2012-02-05 Thread Gaëtan de Menten
On 02/03/2012 12:08 PM, lars van gemerden wrote: I should probably make the pair method: def pair(name1, name2): p1, p2 = Pairs(name1), Pairs(name2) p1.other = p2 p2.other = p1 On Feb 3, 11:57 am, lars van gemerdenl...@rational-it.com wrote: Hi, I am trying to sote pairs in a

[sqlalchemy] Re: Elixir question

2012-02-05 Thread lars van gemerden
OK, thank you, I went back to SQLA and came up with this for now (simplified): class Pairs(Base): __tablename__ = 'Pairs' name = Column(String(20), primary_key=True) other_name = Column(String(20), ForeignKey('Pairs.name'),

[sqlalchemy] Re: Elixir question

2012-02-05 Thread lars van gemerden
Sorry, scrap the remark about primaryjoin ... inheritance. INheritance wasn't the problem. On Feb 5, 1:27 pm, lars van gemerden l...@rational-it.com wrote: OK, thank you, I went back to SQLA and came up with this for now (simplified):

[sqlalchemy] Re: Elixir question

2012-02-03 Thread lars van gemerden
I should probably make the pair method: def pair(name1, name2): p1, p2 = Pairs(name1), Pairs(name2) p1.other = p2 p2.other = p1 On Feb 3, 11:57 am, lars van gemerden l...@rational-it.com wrote: Hi, I am trying to sote pairs in a table as follows:

[sqlalchemy] Re: Elixir: Enum and accented characters (non-ASCII character)

2012-01-17 Thread Pierre Bossé
Thank you Michael for your answers, but This does not work even with the UFT-8 encoding. I changed my program with utf-8: = # -*- coding: utf-8 -*- from elixir import * from sqlalchemy import create_engine class TestEnum(Entity):

Re: [sqlalchemy] Re: Elixir: Enum and accented characters (non-ASCII character)

2012-01-17 Thread Michael Bayer
On Jan 17, 2012, at 7:46 AM, Pierre Bossé wrote: Thank you Michael for your answers, but This does not work even with the UFT-8 encoding. 2012-01-17 07:10:03,405 INFO sqlalchemy.engine.base.Engine CREATE TABLE TEST_ENUM ( id INTEGER NOT NULL, MY_ENUM NVARCHAR2(100),

Re: [sqlalchemy] Re: Elixir: Enum and accented characters (non-ASCII character)

2012-01-17 Thread Michael Bayer
On Jan 17, 2012, at 12:29 PM, Michael Bayer wrote: OK but very significantly, the behavior has changed. SQLAlchemy is now sending in the correct DDL to Oracle.What remains is whether or not it gets to cx_oracle in the best way possible as well as if cx_oracle does the right thing

[sqlalchemy] Re: [elixir] problem with cascade deletes

2010-09-14 Thread alex bodnaru
hey yacine, friends, indeed the problem came partly because i haven't followed the traces of elixir close enough: i've used backref instead of inverse for manytoone relations. the only drawback of using inverse, is that it requires the inverse relation to really exist, hence it can't be

[sqlalchemy] Re: Elixir 0.6.1 released!

2008-08-19 Thread Jorge Vargas
On Mon, Aug 18, 2008 at 11:37 PM, Jose Galvez [EMAIL PROTECTED] wrote: I'm not trying to be an ass, but what are the advantages to using Elixer well you did sound like one :) the first thing is that declarative is very new to SA (0.4.something, and only mainstream in 0.5), while elixir has

[sqlalchemy] Re: Elixir 0.6.1 released!

2008-08-19 Thread Jose Galvez
Thanks for the info, I guess I didn't realize declarative was added so recently, its been a while since I actually looked at the SA docs (which is where I found it). But you do make some good points about Elixer, I'll have to give it another look, because I do find the way that SA defines

[sqlalchemy] Re: Elixir 0.6.1 released!

2008-08-18 Thread Jose Galvez
I'm not trying to be an ass, but what are the advantages to using Elixer over using the declarative syntax such as: from sqlalchemy import * from sqlalchemy.orm import relation, scoped_session, sessionmaker from sqlalchemy.ext.declarative import declarative_base dbe =

[sqlalchemy] Re: Elixir

2007-09-21 Thread Gaetan de Menten
On 9/20/07, Christine [EMAIL PROTECTED] wrote: Any elixir fans? Any idea on when it will finally be made an extension? Let me know. Not sure. I'd like to answer: When it's ready. But ven when it'll be ready, this might not happen. There would be some positive points to that, but also some

[sqlalchemy] Re: Elixir performance

2007-09-06 Thread Gaetan de Menten
On 9/5/07, Paul Johnston [EMAIL PROTECTED] wrote: data. I did some benchmarks a while back to see how everything stacked up as I was wondering if I was doing everything the hard way (in C++) instead of using SqlAlchemy, etc. TurboEntity is the same as Great work Eric. I am quite

[sqlalchemy] Re: Elixir performance

2007-09-06 Thread Michael Bayer
since performance is the hot topic these days, I thought Id note that I've made some ORM improvements in the current SQLAlchemy trunk. We have a profiling test that loads 10 objects each with 50 child objects, eagerly loaded across 500 rows. Version 0.3.10 uses 70040 function calls,

[sqlalchemy] Re: Elixir performance

2007-09-06 Thread EricHolmberg
I am quite surprised at the results. I would have thought ActiveMapper/TurboEntity would only be marginally slower than plain SQLAlchemy. And again, I'm surprised that SA is faster than MySQLdb. How does that work out? I though SA used MySQLdb??? Your use of query cache and best of three

[sqlalchemy] Re: Elixir performance

2007-09-05 Thread Paul Johnston
Hi, data. I did some benchmarks a while back to see how everything stacked up as I was wondering if I was doing everything the hard way (in C++) instead of using SqlAlchemy, etc. TurboEntity is the same as Great work Eric. I am quite surprised at the results. I would have thought

[sqlalchemy] Re: Elixir performance

2007-09-04 Thread Gaetan de Menten
On 9/4/07, Acm [EMAIL PROTECTED] wrote: I am trying out Elixir 0.3.0 over SQLAlchemy 0.3.10 in a Python 2.5 environment. Are there any known performance issues with Elixir for CRUD (Create Select Update Delete) commands? Not that I know of. There shouldn't be any overhead (over raw

[sqlalchemy] Re: elixir, sqlalchemy myqldb: Error connectiong to local socket

2007-05-09 Thread King Simon-NFHD78
Pirkka wrote: I started migrating from ActiveMapper to Elixir, and have been wrestling with this for hours: DBAPIError: (Connection failed) (OperationalError) (2005, Unknown MySQL server host '/Applications/MAMP/tmp/mysql/mysql.sock' (1)) Here are the command parameters that sqlalchemy