Re: [SQLObject] Python 3.5

2016-09-11 Thread Lutz Steinborn
Well done. Am 11.09.2016 2:38 vorm. schrieb "Oleg Broytman" : > Hi, all! Tests are now run at CIs with python3.5. > > Oleg. > -- > Oleg Broytmanhttp://phdru.name/p...@phdru.name >Programmers don't die, they just GOSUB without RETURN. > > --

[SQLObject] postgresql json/jsonb

2016-06-28 Thread Lutz Steinborn
Hello, is where a way to use sqlobject with json/jsonb data type from postgresql? I didn't find anything in the docs about this. Creating tables isn't the issue (hello psql) but how to select/insert/update? Kindly regards and thank you for all the work. Lutz

Re: [SQLObject] Managing hierarchical data

2010-10-28 Thread Lutz Steinborn
On Thu, 28 Oct 2010 01:09:59 + (UTC) Mark wrote: > Is there a recommend way to deal with hierarchical data with SQLObject? > I think I'm going to simply keep track of my categories and their > hierarchy outside of SQLObject classes and then simply have all of my > objects contain a category

Re: [SQLObject] show/log query

2009-10-13 Thread Lutz Steinborn
On Tue, 13 Oct 2009 11:45:36 +0400 Oleg Broytman wrote: > On Tue, Oct 13, 2009 at 08:52:48AM +0200, Lutz Steinborn wrote: > > is there a way to log the query that SQLObject generates ? > >Sure. You can turn on debug flag in DB URI or connection: But this gives me all querie

[SQLObject] show/log query

2009-10-13 Thread Lutz Steinborn
Good morning, is there a way to log the query that SQLObject generates ? example (maybe stupid): result = MyTable.get(1) logging.debug('%s' % result.print_sql_query()) or without execution logging.debug('%s' % MyTable.get(1).return_only_query_as_string()) Kindly regards Lutz ---

[SQLObject] SQLObject and Pylons 0.9.7

2009-04-22 Thread Lutz Steinborn
Hi, Pylons has changed to SQLAlchemy as the preferred ORM. Can anybody tell me how to use SQLObject with pylons 0.9.7 ? I can't find any information about this issue in the pylons mailinglists. I like SQLObject and don't see any reason to change to SA. Kindly regards -- Lutz St

Re: [SQLObject] Does SQLObject have a queryAll-like method which returns the result as generator?

2008-03-17 Thread Lutz Steinborn
On Mon, 17 Mar 2008 14:18:31 +0900 "masayuki.takagi" <[EMAIL PROTECTED]> wrote: > hi all, > > Does SQLObject have a way to handle a result of select query as stream? > > My Application need to work with select queries which return 1GB~ > result at once. > > queryAll method returns a list whic

Re: [SQLObject] csv export / import; how?

2008-02-28 Thread Lutz Steinborn
On Thu, 6 Dec 2007 01:18:24 +0300 Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Wed, Dec 05, 2007 at 10:23:10PM +0100, Petr Jake?? wrote: > > Does some example, hint or snippet of the code exists which shows how to use > > > > export_csv and/or export_csv_zip functions? > >Look at te

Re: [SQLObject] Problem with list

2007-08-17 Thread Lutz Steinborn
Hello, On Fri, 17 Aug 2007 14:43:57 +0400 Oleg Broytmann <[EMAIL PROTECTED]> wrote: > Hello! > > On Fri, Aug 17, 2007 at 12:25:12PM +0200, Lutz Steinborn wrote: > > I don't get any mailings from the list since 06.08 > >Why do you think there should be an

[SQLObject] Problem with list

2007-08-17 Thread Lutz Steinborn
Hi, I don't get any mailings from the list since 06.08 but I'm allready have a subscription. Can anybody check this and drop me a mail please. thank you kindly regards Lutz Steinborn - This SF.net email is sp

Re: [SQLObject] Link to wiki mysteriously hard to find...

2007-05-03 Thread Lutz Steinborn
; Thanks > I agree, the wiki link should be on the main page. Nobody will make it > evolve if nobody know it exists... I agree too. I have found the old wiki only by try and error. Kindly regards Lutz Steinborn - This S

Re: [SQLObject] Link to wiki mysteriously hard to find...

2007-04-29 Thread Lutz Steinborn
Hi, I have fixed some issues. Maybe some more later. Regards Lutz On Sun, 29 Apr 2007 01:36:44 -0700 "Sam's Lists" <[EMAIL PROTECTED]> wrote: > Someone else was kind enough to do some! (Oleg?) > > And I just did some more. > > I've never heard of gazpacho. The homepage seems down. Is thi

[SQLObject] own intermediate tables

2007-04-27 Thread Lutz Steinborn
Hi, has anybody an example how to set the attributes of the intermediate table from the example http://www.sqlobject.org/FAQ.html#how-can-i-define-my-own-intermediate-table-in-my-many-to-many-relationship ? Kindly regards Lutz Steinborn 4c GmbH

Re: [SQLObject] EnumCol

2007-04-25 Thread Lutz Steinborn
On Wed, 25 Apr 2007 17:29:39 +0400 Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Wed, Apr 25, 2007 at 03:15:08PM +0200, Lutz Steinborn wrote: > > I like to use EnumCol but first I have a question: > > who did the check if the given value is in the list of possible > >

[SQLObject] EnumCol

2007-04-25 Thread Lutz Steinborn
#x27;no','maybe')) Thanks in advance ! Kindly regards Lutz Steinborn 4c GmbH - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML.

Re: [SQLObject] Unicode handling with sqlobject's UnicodeCol?

2007-02-21 Thread Lutz Steinborn
Hello Bernhard, I have not a real solution for you but a howto (in german) about unicode with Python: http://wiki.python.de/Von_Umlauten%2C_Unicode_und_Encodings After reading this I had the big AHA about unicode and encodings. Maybe it helps. kindly regards Lutz Steinborn 4c AG On Wed, 21

Re: [SQLObject] Performance

2007-02-13 Thread Lutz Steinborn
On Tue, 13 Feb 2007 19:33:39 +0300 Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Tue, Feb 13, 2007 at 05:15:30PM +0100, Lutz Steinborn wrote: > > every time then we are getting an object from the database > > (postgres) with myClass.select(myQuery) two queries are in the >

[SQLObject] Performance

2007-02-13 Thread Lutz Steinborn
stop this ? As far as I know you can get the row counting after the query with psycopg. Kindly regards Lutz Steinborn 4c AG - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickl

[SQLObject] Classes from the DB schema

2007-01-25 Thread Lutz Steinborn
e then 2 years an we love it. Regards Lutz Steinborn 4c AG - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & b

Re: [SQLObject] destroySelf

2006-06-28 Thread Lutz Steinborn
> object is destroyed. """ is this really true? I have to cleanup the intermediate tables by my self ? Is this a feature or a bug ? Kindly regards Lutz Steinborn Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integ

[SQLObject] SQLBuilder

2006-06-27 Thread Lutz Steinborn
x27;t' \ order by ca.name, fa.name") Not very elegant but its working. My question is now if somebody can transfer this query to a valid SQLBuilder expression so I have a working example. After my enlightenment I'll be share my knowledge in the wiki. Many thanks in advance !!

Re: [SQLObject] SQL'ish count versus len()

2006-06-27 Thread Lutz Steinborn
n the reply on the list. Kindly regards Lutz Steinborn Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us

Re: [SQLObject] create a row

2006-06-06 Thread Lutz Steinborn
Hello Ivan, as I remeber if you use a string type column as id its up to you to insert a new unique id. some thing like this: new_user=ts_user= (username="myunique_name") because SQLObect has no idea how your id logic works. have fun Regards Lutz On Tue, 6 Jun 2006 13:40:17 +0200 Ivan Horva

[SQLObject] a lot of many-to-many relationships

2006-05-27 Thread Lutz Steinborn
. So just build up only one table with multiple attributes for all the relations. Is this possible ? Kindly regards Lutz Steinborn 4c AG http://www.4c-wohnen.de --- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully

[SQLObject] updating and adding Class definitions

2006-03-23 Thread Lutz Steinborn
Hi, repost from yesterday because no on has answered. Regards Lutz Steinborn Hello, I'm using SQLObject and I really like it. I've defined some Classes for a company project ans used it for a while. No after some time things have changed and I have to alter and add some Class

[SQLObject] updating and adding Class definitions

2006-03-22 Thread Lutz Steinborn
es by hand ? What about new Classes with relations to old Classes ? Kindly regards Lutz Steinborn --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the li