Re: [sqlalchemy] Re: Can't upgrade SQLAlchemy any more

2015-03-29 Thread Werner
with Python 3.4.3, so that should be the latest. I'll try first to update some other packages on that machine with pip. Had similar issue with wxPython-Phoenix and pip with 3.4.0 was very far behind, don't know about 3.4.3. pip 6.0.8 and setuptools 12.2 fixed it for me Werner -- You received

[sqlalchemy] Duplicate constraint name

2015-01-30 Thread Werner
? Is this a recent change as I don't seem to get this on 0.9.3, below is with Python 3.4 and 0.9.7. Werner class Currency(DeclarativeBase, mix.StandardColumnMixin): __tablename__ = u'currency' name = sa.Column(sa.Unicode(length=50), nullable=False, index=True) code = sa.Column(sa.Unicode

Re: [sqlalchemy] Duplicate constraint name

2015-01-30 Thread Werner
Hi Michael, Yes, I am using the old naming recipe, adjusted it to check for _unnamed_ as a temp fix until I can move to the new way of doing it. Thanks for the fast answer Werner On 1/30/2015 18:27, Michael Bayer wrote: Werner werner...@gmx.ch wrote: I am getting the following exception

Re: [sqlalchemy] Firebird SQL 'rdb$get_context eq' equivalent in PostGreSQL

2015-01-23 Thread Werner
Hi, Just for the archive. Got an answer on stackoverflow: http://stackoverflow.com/questions/28047911/how-to-set-some-context-variable-for-a-user-connection/28061244#28061244 On 1/19/2015 16:59, Werner wrote: Hi, I like to move to eventually support PGSQL 9.3+ as an alternative engine

[sqlalchemy] Firebird SQL 'rdb$get_context eq' equivalent in PostGreSQL

2015-01-19 Thread Werner
googling and looking at the PG documentation I can't find something similar, probably just using the wrong terminology:-( . Anyone can give me a tip of where to look? Thanks Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from

Re: [sqlalchemy] Setting column properties

2014-12-19 Thread Werner
there? sqlalchemy.readthedocs.org/en/rel_0_9/core/defaults.html Is more documentation available for the class Column? http://sqlalchemy.readthedocs.org/en/rel_0_9/core/metadata.html#sqlalchemy.schema.Column Werner -- You received this message because you are subscribed to the Google Groups

Re: [sqlalchemy] vacation...

2014-07-31 Thread Werner
the laptop;-) . Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy

Re: [sqlalchemy] Specifying a Row Check Constraint and Compound Primary Keys

2014-07-30 Thread Werner
/sqlalchemy/wiki/UsageRecipes/NamingConventions Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send

Re: [sqlalchemy] Specifying a Row Check Constraint and Compound Primary Keys

2014-07-30 Thread Werner
Hi Rich, On 7/30/2014 15:04, Rich Shepard wrote: On Wed, 30 Jul 2014, Werner wrote: I don't like using 'name' columns as primary keys I would instead use an 'id' column and would set 'index=True' on the name column. Werner, The use of natural keys (such as a vehicle VIN, the US's SSN

[sqlalchemy] Inspect column

2014-05-18 Thread Werner
at the column length 2. when would 'property.columns' contain more then one element Thanks Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr

Re: [sqlalchemy] just a picture

2013-11-21 Thread Werner
On 21/11/2013 15:02, Stefane Fermigier wrote: Hi Lars, Are you working on the tool, or on the application whose schema is depicted on the tool ? Assuming it is a tool this would be very nice. Can it read an existing SA model? Werner -- You received this message because you are subscribed

Re: [sqlalchemy] A record is dropped on add

2013-10-04 Thread Werner
Michael, On 03/10/2013 23:05, Michael Bayer wrote: On Oct 3, 2013, at 5:42 AM, Werner werner.bru...@sfr.fr wrote: ... The relation setup for the classes involved, and I suspect Vintage.drinkinfo/Cellarbook.drinkinfo ones: Vintage.vintadd = sao.relationship('Vintadd', uselist=False

[sqlalchemy] A record is dropped on add

2013-10-03 Thread Werner
guess/think that I have a relation setup incorrectly which creates this effect, but I can not put my finger on it. Appreciate any hint. Werner The relation setup for the classes involved, and I suspect Vintage.drinkinfo/Cellarbook.drinkinfo ones: Vintage.vintadd = sao.relationship('Vintadd

Re: [sqlalchemy] A record is dropped on add

2013-10-03 Thread Werner
On 03/10/2013 11:42, Werner wrote: Hi, I have a problem that when I add a record to 'cellarbook' using the following code the 'old' cellarbook entry is dropped from the db. oldCB = session.query(db.Cellarbook).get(7) newCB = db.Cellarbook() # set some data from existing dbitem newCB.cellar

Re: [sqlalchemy] Strange bug when adding

2013-09-20 Thread Werner
are having. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy

Re: [sqlalchemy] How to use classes derived from declarative_base for default columns

2013-08-15 Thread Werner
/trac/wiki/UsageRecipes/NamingConventions Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send

Re: [sqlalchemy] Mapping views as Table/ORM

2013-08-09 Thread Werner
them as a new table when you issue metadata.create_all(), is there a convenient way around this, without having to pass a list of tables to create_all? Maybe this recipe will help. http://www.sqlalchemy.org/trac/wiki/UsageRecipes/Views Werner -- You received this message because you

[sqlalchemy] SchemaDisplay

2013-08-07 Thread Werner
Thanks this is really neat. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email

Re: [sqlalchemy] SQLAlchemy 0.8.2 released

2013-07-11 Thread Werner
contributors who helped with this release. SQLAlchemy 0.8.2 is available on the Download Page: http://www.sqlalchemy.org/download.html Thanks for adding the retaining flag for Firebird - you are way to fast for me:) Werner -- You received this message because you are subscribed to the Google Groups

Re: [sqlalchemy] The problem with Oldest transaction (Firebird)

2013-06-22 Thread Werner
it at the time as it is good fit for small desktop application due to its embedded engine and years ago PG didn't have a Windows build. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from

Re: [sqlalchemy] The problem with Oldest transaction (Firebird)

2013-06-21 Thread Werner
released. Are you doing commit retaining in some way - not even sure you can do this via SQLalchemy. If you haven't already seen this it might help you find the real cause. http://www.ibphoenix.com/resources/documents/general/doc_67 Werner -- You received this message because you are subscribed

Re: [sqlalchemy] Dabo ReportDesigner/Writer

2013-06-12 Thread Werner
Hi, On 04/06/2013 08:26, Werner wrote: Hi, I am looking at Dabo's ReportDesigner/Writer to do reporting (looked at others like PythonReports and Geraldo) but both have problems with large text blobs. It wants the data as: Dabo's reportwriter wants dataset-like structures, which

Re: [sqlalchemy] Dabo ReportDesigner/Writer

2013-06-12 Thread Werner
individual labels: s.query(A.id, B.name, C.name.label(c_name), ...) Great, thanks for the quick reply Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy

[sqlalchemy] Dabo ReportDesigner/Writer

2013-06-04 Thread Werner
(): print row.__dict__['name'] Is using row.__dict__ the correct way or are there other ways? Best regards Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email

[sqlalchemy] SA and Firebird RDB$SET/GET_CONTEXT

2013-04-29 Thread Werner
of my code Anyone has a hint on where I am going wrong with all this? Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com

Re: [sqlalchemy] SA and Firebird RDB$SET/GET_CONTEXT

2013-04-29 Thread Werner
On 29/04/2013 13:29, Werner wrote: Hi, I am using the above to set the user language and I am sure this worked for me, but it doesn't any more, in the mean time I upgraded to 0.8.1 (was on 0.7.8) and I wonder where things changed. In a simple test like this it still works: session.execute

Re: [sqlalchemy] SA and Firebird RDB$SET/GET_CONTEXT

2013-04-29 Thread Werner
the default, which is English. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy

Re: [sqlalchemy] SA and Firebird RDB$SET/GET_CONTEXT

2013-04-29 Thread Werner
. Can someone please explain why the above commit would someone cause the context not to stick. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy

Re: [sqlalchemy] SA and Firebird RDB$SET/GET_CONTEXT

2013-04-29 Thread Werner
connection, but will check this again tomorrow. As always thanks for your time and explanation. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr

Re: [sqlalchemy] Are sqlalchemy queries a generator?

2013-04-26 Thread Werner
the doc for querying, e.g. the following if you use the ORM. http://sqlalchemy.readthedocs.org/en/rel_0_8/orm/tutorial.html#querying Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from

Re: [sqlalchemy] Are sqlalchemy queries a generator?

2013-04-26 Thread Werner
On 26/04/2013 17:07, Claudio Freire wrote: On Fri, Apr 26, 2013 at 12:06 PM, Werner werner.bru...@sfr.fr wrote: On 26/04/2013 16:41, alonn wrote: so not to load too much into memory I should do something like: for i in session.query(someobject).filter(idsomething) print i I'm guessing

Re: [sqlalchemy] ColanderAlchemy 0.2a1 released!

2013-04-11 Thread Werner
/CHANGELOG.txt You can find new doc here: https://colanderalchemy.readthedocs.org/en/latest/ BTW, the colander link on the following page does not work. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving

Re: [sqlalchemy] Relationship setup problem

2013-04-09 Thread Werner
On 09/04/2013 14:29, Werner wrote: ... Wineracku.combrack = sao.relationship('Wineracku', remote_side=[Wineracku.id], cascade=all, delete, delete-orphan, single_parent=True) Wineracku.combrack = sao.relationship

Re: [sqlalchemy] Relationship setup problem

2013-04-09 Thread Werner
deletion of w2 or w3 Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy

[sqlalchemy] Relationship setup problem

2013-03-01 Thread Werner
==Wineracku.id')) What am I doing wrong? Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send

Re: [sqlalchemy] Relationship setup problem

2013-03-01 Thread Werner
Hi, Found it in the doc, the Adjacency List Relationship is what I wanted. http://docs.sqlalchemy.org/en/latest/orm/relationships.html#adjacency-list-relationships Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from

Re: [sqlalchemy] Storing and Retrieving BLOB in SqlAlchemy

2013-02-26 Thread Werner
, but there are obviously reasons to put it in a db. You might want to read some of the other posts on stackoverflow, e.g.: http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group

Re: [sqlalchemy] Docs in PDF are not being generated

2013-01-30 Thread Werner
. What about rst2pdf instead of going via LaTex? http://techtonik.rainforce.org/2010/05/sphinx-pdf-with-rst2pdf.html I used on smallish docs, so don't know how it will do with SQLAlchemy. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group

Re: [sqlalchemy] Couple of questions about filtering...

2013-01-23 Thread Werner
(self, self.type) as you can see I am on 0.7.9. I am not an expert on these things but shouldn't you maybe use the following instead of hybrid_property: http://docs.sqlalchemy.org/en/latest/orm/inheritance.html Werner -- You received this message because you are subscribed to the Google Groups

Re: [sqlalchemy] sanitizing sql with sqlalchemy

2013-01-01 Thread Werner
). Can you give more detail on how a . (point/full stop) in user data corrupted your database. A point is valid data in lots of situations, so should not cause you problems. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

Re: [sqlalchemy] sanitizing sql with sqlalchemy

2013-01-01 Thread Werner
in a varchar column? I am pretty sure that the . is not your problem. Provide more details and hopefully someone can help you identify your real problem. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email

Re: [sqlalchemy] alembic handles no primary key table

2012-12-01 Thread Werner
. Not an expert, but above is using the SA orm which requires a primary key, you need to define the table using: http://sqlalchemy.readthedocs.org/en/rel_0_8/core/schema.html#metadata-describing Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group

[sqlalchemy] relationship problem

2012-11-09 Thread Werner
i.fk_authuser_id print i.authuser.name The output is: Main Cellar 1 default Special Reserve 1 --- attribute error NoneType object has no attribute 'name' I am still on 0.7.9. What am I doing wrong? Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy

[sqlalchemy] C Extension on Windows 7

2012-10-20 Thread Werner
:-) . Werner -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group

Re: [sqlalchemy] C Extension on Windows 7

2012-10-20 Thread Werner
Michael, Thanks for the quick reply. I am just about only using the ORM (and I like it a lot), so I won't bother with all this. Sorry for having wasted your time Werner On 20/10/2012 22:26, Michael Bayer wrote: You can google around for better info on this, as I've not done Windows C

[sqlalchemy] startswith column operator - db specific

2012-04-20 Thread Werner
I use Firebird SQL, and like has a pretty bad performance compared to starting with, as the later uses an index if one is available. When using someklass.somecolumn.startswith('value') SA uses like, what would have to be done to use starting with instead for the Firebird dialect? Werner

Re: [sqlalchemy] startswith column operator - db specific

2012-04-20 Thread Werner
On 20/04/2012 10:36, Werner wrote: I use Firebird SQL, and like has a pretty bad performance compared to starting with, as the later uses an index if one is available. When using someklass.somecolumn.startswith('value') SA uses like, what would have to be done to use starting with instead

Re: [sqlalchemy] startswith column operator - db specific

2012-04-20 Thread Werner
Michael, On 20/04/2012 12:21, Michael Bayer wrote: On Apr 20, 2012, at 4:51 AM, Werner wrote: On 20/04/2012 10:36, Werner wrote: I use Firebird SQL, and like has a pretty bad performance compared to starting with, as the later uses an index if one is available. When using

[sqlalchemy] OT - SQL report design

2012-04-16 Thread Werner
within Python. reportlab/platypus looks promising, except that I can't find any GUI with which to generate the layout of a listing. Ideally it should be something a 'semi' technical end user could use too. Is there such a thing? Werner -- You received this message because you are subscribed

[sqlalchemy] Computed by columns

2012-04-09 Thread Werner
BY ((SELECT COUNT(BOTTAG.TAGNO) FROM BOTTAG WHERE BOTTAG.FK_WINERACKIT_ID = WINERACKIT.ID)), AVAILCAPACITY COMPUTED BY (CAPACITY-USEDCAPACITY) Thanks in advance for some pointers on how to do this. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy

Re: [sqlalchemy] Computed by columns

2012-04-09 Thread Werner
). Or why not do it at the type level ? Can you just make a UserDefinedType here ? Will look into these. 2463 might be nicer. and will keep watching this one in case it does make it into 0.8. Thanks Werner On Apr 9, 2012, at 1:36 PM, Werner wrote: Is there a way in SA 0.7.6

[sqlalchemy] expire_on_commit and rollback

2012-03-29 Thread werner
)? Werner P.S. Python 2.7.2 and SA 0.7.2 on Win 7 -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/WZ0HHOqitBQJ. To post to this group, send email to sqlalchemy

[sqlalchemy] expire_on_commit and rollback

2012-03-29 Thread werner
but it doesn't seem to affect rollback. Is there way to suppress the reloading of all the items and only load the one affected by the changes by using expire(instance) or refresh(instance)? Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group

Re: [sqlalchemy] Google Summer of Code 2012

2012-03-23 Thread werner
? https://github.com/pmakowski/fdb Copied Philip and Pavel as I am not sure that they read this list and they are would be much better qualified and responding to any technical questions. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

Re: [sqlalchemy] Google Summer of Code 2012

2012-03-23 Thread werner
On 23/03/2012 18:59, Philip Jenvey wrote: On Mar 23, 2012, at 1:13 AM, werner wrote: On 23/03/2012 05:53, Philip Jenvey wrote: Hey all, SQLAlchemy is looking to get involved in this year's Google Summer of Code[1]. We'd like to encourage students to visit our GSoC page on the wiki[2

Re: [sqlalchemy] user defined type

2012-02-11 Thread werner
#mapper-sql-expressions Werner -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options

[sqlalchemy] user defined type

2012-02-08 Thread werner
samples using UserDefinedType and TypeDecorator, looked at the UsageRecipes and the documentation but obviously can't quit put it together for my use. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email

[sqlalchemy] column_property and Firebird

2012-01-16 Thread werner
in dialect 3. Is there an alternative which would work for both FB and Postgresql? Werner P.S. The above query generates the following: 2012-01-16 17:41:56,696 INFO sqlalchemy.engine.base.Engine SELECT cellarbook.id AS cellarbook_id, cellarbook.maturityfirst AS cellarbook_maturityfirst

Re: [sqlalchemy] column_property and Firebird

2012-01-16 Thread werner
Michael, On 01/16/2012 05:53 PM, Michael Bayer wrote: On Jan 16, 2012, at 11:46 AM, werner wrote: I would like to do this type of thing: namesandvar = column_property(names + + variety) and use it e.g. like: query(db.Cellarbook).filter(db.Drinkinfo.namesandvar.contains(u'menu

Re: [sqlalchemy] Tea Rota

2012-01-13 Thread werner
=fore, surn=surn) Hope this helps Werner -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more

[sqlalchemy] joinedload/subqueryload and friends

2011-11-16 Thread werner
hints on this, even further pointers on what else to read in the doc. Werner -- 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 sqlalchemy

Re: [sqlalchemy] joinedload/subqueryload and friends

2011-11-16 Thread werner
have to sit down and benchmark different combinations. Thanks a lot Werner -- 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 sqlalchemy

Re: [sqlalchemy] select count(*)

2011-11-04 Thread werner
On 11/04/2011 03:11 AM, Mark Erbaugh wrote: On Nov 3, 2011, at 3:31 PM, werner wrote: Mark, On 11/03/2011 07:18 PM, Mark Erbaugh wrote: Using the query object count() method generates a sub-query (as per the docs). The docs say to use func.count to avoid the subquery. func.count seems

Re: [sqlalchemy] select count(*)

2011-11-03 Thread werner
of words, maybe there is a solution which doesn't need count() at all:-) . Werner -- 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

Re: [sqlalchemy] Enh. request: more details on Unicode type warning

2011-09-10 Thread werner
On 09/09/2011 05:07 PM, Michael Bayer wrote: On Sep 9, 2011, at 11:01 AM, werner wrote: Tracking down where one forgot to use u'' e.g.: somemodelinstance.somecol = 'somevalue' instead of: somemodelinstance.somecol = u'somevalue' is sometimes not that easy to track down as the warning

[sqlalchemy] Enh. request: more details on Unicode type warning

2011-09-09 Thread werner
? Werner -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http

[sqlalchemy] relationship trouble when using UsageRecipes/Views

2011-09-07 Thread werner
import table. I'd appreciate any tips on how to get this to work. Werner -- 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 sqlalchemy+unsubscr

Re: [sqlalchemy] relationship trouble when using UsageRecipes/Views

2011-09-07 Thread werner
Michael, On 09/07/2011 05:10 PM, Michael Bayer wrote: On Sep 7, 2011, at 4:40 AM, werner wrote: or: Region_LV.language = sao.relationship('Language', primaryjoin=Country_LV.fk_language_id==Language.id, foreign_keys=[Country_LV.__table__.c.fk_language_id

Re: [sqlalchemy] relationship trouble when using UsageRecipes/Views

2011-09-07 Thread werner
On 09/07/2011 05:58 PM, Michael Bayer wrote: On Sep 7, 2011, at 11:53 AM, werner wrote: Michael, On 09/07/2011 05:10 PM, Michael Bayer wrote: On Sep 7, 2011, at 4:40 AM, werner wrote: or: Region_LV.language = sao.relationship('Language', primaryjoin

Re: [sqlalchemy] Instance is not persistent within this Session

2011-08-15 Thread werner
think it is, same with objects being dealt with.You're looking to reveal the problem much farther up the chain of events basically. Thanks Michael Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email

[sqlalchemy] Instance is not persistent within this Session

2011-08-14 Thread werner
) self.Getds().flush() Anyone can give me some pointers of what I could possibly do wrong which would cause the instance not being persistent. Many thanks in advance as I am hitting my head on trying to recreate this problem for some time now. Werner -- You received this message because

Re: [sqlalchemy] Instance is not persistent within this Session

2011-08-14 Thread werner
. On Aug 14, 2011, at 3:54 AM, werner wrote: A few of my user run into this exception when they use a dialog to create a new wine purchase. Fri Aug 05 10:24:56 2011 Version: 3.2.182.9 wxV: 2.8.11.0 (msw-unicode) * Traceback (most recent call last): File dialognewwine.pyo

[sqlalchemy] Can pk_col function be adapted for Firebird?

2011-08-12 Thread werner
it out either how to do it in on_table_attach. Would appreciate any tips on this. Werner -- 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

Re: [sqlalchemy] Can pk_col function be adapted for Firebird?

2011-08-12 Thread werner
On 08/12/2011 02:18 PM, werner wrote: I can't figure out how I could adapt the pk_col function on this page http://www.sqlalchemy.org/trac/wiki/UsageRecipes/NamingConventions to handle the Sequence definition needed for e.g. Firebird. At the point when Column is instantiated I don't have

Re: [sqlalchemy] Can pk_col function be adapted for Firebird?

2011-08-12 Thread werner
On 08/12/2011 04:46 PM, Michael Bayer wrote: On Aug 12, 2011, at 9:04 AM, werner wrote: On 08/12/2011 02:18 PM, werner wrote: I can't figure out how I could adapt the pk_col function on this page http://www.sqlalchemy.org/trac/wiki/UsageRecipes/NamingConventions to handle the Sequence

Re: [sqlalchemy] storedprocedure with input parameter

2011-07-28 Thread werner
Conor, On 07/27/2011 05:54 PM, Conor wrote: On 07/27/2011 10:42 AM, werner wrote: I like to use a stored procure which needs a input parameter in something like this: seltest = db.sa.select([id, name]).select_from(db.sa.func.someStoredProc(2)).alias() seltestm = db.sao.mapper(ATest

[sqlalchemy] storedprocedure with input parameter

2011-07-27 Thread werner
= session.query(seltestm).get(73) tried using functools.partial but I get a InterfaceError exception. Werner -- 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

Re: [sqlalchemy] Ubuntu install

2011-05-08 Thread werner
On 05/07/2011 07:27 PM, Michael Trier wrote: On Sat, May 7, 2011 at 11:11 AM, werner wbru...@free.fr mailto:wbru...@free.fr wrote: Just FYI, I am installing things on Ubuntu 10.10 (Maverick) and when I do this: easy_install.main(['-Zmad', sitePKG, sqlalchemy==0.6.8]) Maybe I'm

Re: [sqlalchemy] Ubuntu install

2011-05-08 Thread werner
Just FYI, On 05/08/2011 09:46 AM, werner wrote: ... easy_install.main(['-Zmad', sitePKG, sqlalchemy]) But this gets me 0.6.6. Gets 0.6.6 if I do the above on Ubuntu 10.10 Maverick, just did the same in a VirtualBox/Win 7 machine and I get 0.6.7. Werner -- You received this message

[sqlalchemy] Ubuntu install

2011-05-07 Thread werner
sqlalchemy==0.6, I get 0.6.3 With sqlalchemy==0.6.6 I did get 0.6.6 which is fine for what I am doing at the moment. Werner -- 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

Re: [sqlalchemy] Re: Side by side versions on one machine.

2011-04-26 Thread werner
On 04/26/2011 03:24 PM, Mike Conley wrote: If you only want to change the SQLAlchemy version and use easy install tools, I have done it by altering the sqlalchemy path in site_packages/easy-install.pth Or do this before you import SQLAlchemy: I find that easier than setting up virtual

Re: [sqlalchemy] Re: Side by side versions on one machine.

2011-04-26 Thread werner
pkg_resources.require(sqlalchemy) # get latest version ##pkg_resources.require(sqlalchemy==0.5.8) # get specific version Werner -- 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

Re: [sqlalchemy] Sqlalchemy+Kinterbasdb installation error

2011-02-28 Thread werner
bit - so don't know if it would work. Anyhow you should better ask kinterbasdb questions on the FB driver list. Werner -- 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

Re: [sqlalchemy] Multilingual Model

2011-02-04 Thread werner
TEXT NOT NULL, lookup_text TEXT NOT NULL ); You might want to look at these threads. i10n of data internationalization of content A few different approaches to this problem were discussed in them. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy

[sqlalchemy] does one always have to call session.add ?

2010-12-06 Thread werner
? Werner P.S. Using SA 0.6.5 -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit

Re: [sqlalchemy] sqla and firebird

2010-11-09 Thread werner
yet. You are on kinterbasdb 3.3.0? If not you can get it from here: http://www.firebirdsql.org/index.php?op=develsub=python Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com

[sqlalchemy] Link problem on : http://www.sqlalchemy.org/features.html

2010-10-27 Thread werner
the View Current DBAPI Support link on the above page gives a page not found error. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send

[sqlalchemy] Suggestion - Firebird engine to default type_conv=300

2010-09-24 Thread werner
the blob’s character set ID available. Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com

Re: [sqlalchemy] get to dialect specific column type

2010-09-22 Thread werner
: 'FBDialect_kinterbasdb' object has no attribute 'DATETIME' What am I doing wrong here? And is there a cleaner way of doing this, i.e. get the dialect currently used instead of using a hard coded dialect. On 20/09/2010 23:52, werner wrote: I am trying to automatically generate the stored

Re: [sqlalchemy] get to dialect specific column type

2010-09-22 Thread werner
/same code I assume meta.create_all(engine) is using to generate create table (can't yet figure out where/how this is all done) and ideally this should work not only for Firebird engine. Hope this is clearer. Thanks for looking at all this. Werner -- You received this message because you

[sqlalchemy] get to dialect specific column type

2010-09-20 Thread werner
way to get at dbapi from e.g. an instance? Isn't there some more elegant way then doing connection.engine.dialect.dbapi? Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com

Re: [sqlalchemy] Re: internationalization of content

2010-09-19 Thread werner
/UsageRecipes. If there is interest to further enhance this and get it to SQLAlchemy standard of code I would very much like to help but I am not good enough a coder to actually do the work or I would definitely need a lot of hand holding and coaching. Werner -- You received this message because you

[sqlalchemy] possible doc error in UsageRecipe/NamingConventions

2010-09-18 Thread werner
, reference_column, Base i.e. change ref_column to reference_column Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr

[sqlalchemy] Views recipe - is it usable with a stored procedure as a select

2010-09-17 Thread werner
recipe from/with a stored procedure? The view definition in Firebird SQL is: CREATE OR ALTER VIEW COUNTRIES_LV( ID, NAME, ISO2, ISO3, TELCODE, CREATED_AT, UPDATED_AT) AS select * from countries_lp; countries_lp being the stored procedure. Werner -- You received

Re: [sqlalchemy] Re: internationalization of content

2010-09-15 Thread werner
Hi Nil, On 14/09/2010 21:58, NiL wrote: Hi Werner, many thanks for your rich reply. I'm going to try an elixir implementation for now. If you want follow the thread of the same title in the elixir mailing list. Thanks for letting me know. One of the things which disturb me about SA

Re: [sqlalchemy] internationalization of content

2010-09-14 Thread werner
for me at the moment. - http://rwec.co.uk/blog/2009/11/atomic-translations-part-1/ - http://rwec.co.uk/blog/2009/12/atomic-translations-part-2/ Hope some of this is useful to you Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

Re: [sqlalchemy] meta.sorted_tables exception with 0.6.3

2010-09-07 Thread werner
Michael, On 06/09/2010 19:42, Michael Bayer wrote: On Sep 6, 2010, at 1:23 PM, werner wrote: Michael, Thanks for the fast reply. On 06/09/2010 15:53, Michael Bayer wrote: engine = create_engine(...) m = MetaData() t = Table('foo', m, autoload=True, autoload_with=engine) #--- boom

Re: [sqlalchemy] meta.sorted_tables exception with 0.6.3

2010-09-06 Thread werner
MINWITH and MAXWIDTH which have default -1. FYI, when I change this to '0' and then back to '-1' it becomes DEFAULT -1 and doesn't cause the exception anymore. Werner /**/ /* Generated by IBExpert 06/09

Re: [sqlalchemy] begginers query question

2010-08-24 Thread werner
/ormtutorial.html http://www.sqlalchemy.org/docs/ormtutorial.html#creating-table-class-and-mapper-all-at-once-declaratively Hope this helps Werner -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch

Re: [sqlalchemy] begginers query question

2010-08-24 Thread werner
On 24/08/2010 15:53, werner wrote: Hi, On 24/08/2010 10:14, Dobrysmak wrote: Hi guys. I've got a little problem with the sqlalchemy syntax. I've got two tables with relations: Table_Goups id int(4) PrimaryKey not null, name varchar(50) not null; and Table_User id int(4) Primary Key

  1   2   3   >