sqlobject-discuss — All things SQLObject-related

Re: [SQLObject] SQLObject / Interbase, generated SQL defective

[Frank W. <fra...@no...>]

quick and precise as always :)
thanks a lot oleg!






Am 15.04.2010 um 16:20 schrieb Oleg Broytman:

> On Thu, Apr 15, 2010 at 03:56:08PM +0200, Frank Wagner wrote:
>> (Gebucht.q.OPTIONSDATUM is None)
> 
>   (Gebucht.q.OPTIONSDATUM == None)
> 
>   Python allow to override == operator (__eq__ magic method) but not 'is'.
> Hence SQLObject can do symbolic manipulation with '== None' but cannot
> catch 'is None' - Python already passed False and SQLObject happily
> converts it to 0.
> 
> Oleg.
> -- 
>     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
>           Programmers don't die, they just GOSUB without RETURN.
> 
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Re: [SQLObject] SQLObject / Interbase, generated SQL defective

[Oleg B. <ph...@ph...>]

On Thu, Apr 15, 2010 at 03:56:08PM +0200, Frank Wagner wrote:
> (Gebucht.q.OPTIONSDATUM is None)

   (Gebucht.q.OPTIONSDATUM == None)

   Python allow to override == operator (__eq__ magic method) but not 'is'.
Hence SQLObject can do symbolic manipulation with '== None' but cannot
catch 'is None' - Python already passed False and SQLObject happily
converts it to 0.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

[SQLObject] SQLObject / Interbase, generated SQL defective

[Frank W. <fra...@no...>]

hi everyone!

it´s been a while but i hope you will answer me.

in a script i have a sqlobject query like this:
r.BUCHUNGEN.filter((Gebucht.q.PERSONEN >= 4) & (Gebucht.q.OPTIONSDATUM is None))


this generates sql like this:
SELECT gebucht.NR, [...] FROM gebucht WHERE ((((gebucht.REISENR) =
('10CAL/1604')) AND (((gebucht.STORNIERT) = ('NEIN')) OR
((gebucht.STORNIERT) IS NULL))) AND (((gebucht.PERSONEN) >= (4)) AND
(0)))

this won´t be executed by the interbase server, it doesn´t accept the
last part "AND (0)" and dismisses the query.
if i remove this last part it will execute just fine.

is this a sqlobject-issue? or is it rather kinterbasdb related?

thanks!

frank

Re: [SQLObject] Reply to list

[Oleg B. <ph...@ph...>]

On Wed, Apr 14, 2010 at 11:46:29PM -0300, Juan Manuel Santos wrote:
> I have to admit that I was a bit annoyed that my zombie "reply to" on this 
> mailing list always ended up in the last poster's mailbox. But after reading 
> the article posted here about munging considered harmful, I'm definitely on 
> that side now.
> It can be seen more clearly when you think about it in these terms: which one 
> is worse? To send a private message to an entire list, or to send a list 
> message to a private mailbox? The second can be amended (the recipient was 
> going to receive the message anyway). The first one can't.

   I think the same way.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Reply to list

[Oleg B. <ph...@ph...>]

On Wed, Apr 14, 2010 at 07:22:03PM -0700, Bill Campbell wrote:
> I'm in the reply munging harmful camp, and use mutt which makes
> it very simple with it's ``L'' to respond to the list.
> 
> I have seen too many cases were somebody thought they were making
> a private reply to the sender that went to a list causing much
> embarassment.

   That's my experience, too. I have saw too many passwords and private
conversations in mailing lists.

> IMHO, it should require a tiny bit of effort before sending a
> message to hundreds of recipients.

   Well said!

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Reply to list (was: Search for Full Name)

[Juan M. S. <vic...@gm...>]

From: Bill Campbell <sql...@ce...>
To: sql...@li...
Date: Wednesday 14 April 2010
> On Wed, Apr 14, 2010, ji...@ql... wrote:
> >FWIW, the other 3 Python-related lists I'm on all default to reply to the
> >list.  I use a mixture of Outlook and Thunderbird.  Thunderbird has the
> >'Reply to List' option, but sadly, Outlook doesn't offer that.
> 
> I'm in the reply munging harmful camp, and use mutt which makes
> it very simple with it's ``L'' to respond to the list.
> 
> I have seen too many cases were somebody thought they were making
> a private reply to the sender that went to a list causing much
> embarassment.
> 
> IMHO, it should require a tiny bit of effort before sending a
> message to hundreds of recipients.
> 
> Bill

I have to admit that I was a bit annoyed that my zombie "reply to" on this 
mailing list always ended up in the last poster's mailbox. But after reading 
the article posted here about munging considered harmful, I'm definitely on 
that side now.
It can be seen more clearly when you think about it in these terms: which one 
is worse? To send a private message to an entire list, or to send a list 
message to a private mailbox? The second can be amended (the recipient was 
going to receive the message anyway). The first one can't.

Just my 0.02

Cheers
Juan Manuel

Re: [SQLObject] Reply to list (was: Search for Full Name)

[Bill C. <sql...@ce...>]

On Wed, Apr 14, 2010, ji...@ql... wrote:

>FWIW, the other 3 Python-related lists I'm on all default to reply to the
>list.  I use a mixture of Outlook and Thunderbird.  Thunderbird has the
>'Reply to List' option, but sadly, Outlook doesn't offer that.

I'm in the reply munging harmful camp, and use mutt which makes
it very simple with it's ``L'' to respond to the list.

I have seen too many cases were somebody thought they were making
a private reply to the sender that went to a list causing much
embarassment.

IMHO, it should require a tiny bit of effort before sending a
message to hundreds of recipients.

Bill
-- 
INTERNET:   bi...@ce...  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
Voice:          (206) 236-1676  Mercer Island, WA 98040-0820
Fax:            (206) 232-9186  Skype: jwccsllc (206) 855-5792

DOS: n., A small annoying boot virus that causes random spontaneous system
     crashes, usually just before saving a massive project.  Easily cured by
     UNIX.  See also MS-DOS, IBM-DOS, DR-DOS.

Re: [SQLObject] Reply to list (was: Search for Full Name)

[<ji...@ql...>]

FWIW, the other 3 Python-related lists I'm on all default to reply to the list.  I use a mixture of Outlook and Thunderbird.  Thunderbird has the 'Reply to List' option, but sadly, Outlook doesn't offer that.

	-Jim

-----Original Message-----
From: Oleg Broytman [mailto:ph...@ph...] 
Sent: Wednesday, April 14, 2010 2:57 PM
To: ji...@ql...
Cc: SQLObject discussion
Subject: Re: [SQLObject] Reply to list (was: Search for Full Name)

On Wed, Apr 14, 2010 at 02:18:47PM -0500, ji...@ql... wrote:
> Can the list be setup so that the default reply goes to the list instead of your personal address?

   It is possible but I am not sure it is desirable. There are two opposite
ways of thinking about it:

   http://www.unicom.com/pw/reply-to-harmful.html
   http://www.metasystema.net/essays/reply-to.html

   Most Python-related lists I know are setup without Reply-To.

   I personally on the "Reply-To Munging Considered Harmful" side, but I
must say I use a mail user agent (mutt) that has all 3 commands - reply,
reply to all, reply to the list. Also mutt allows to ignore Reply-To from
mailing lists, so I don't care too much.

   What do people think? If most people say they want Reply-To I can
change the list options.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Reply to list (was: Search for Full Name)

[Oleg B. <ph...@ph...>]

On Wed, Apr 14, 2010 at 02:18:47PM -0500, ji...@ql... wrote:
> Can the list be setup so that the default reply goes to the list instead of your personal address?

   It is possible but I am not sure it is desirable. There are two opposite
ways of thinking about it:

   http://www.unicom.com/pw/reply-to-harmful.html
   http://www.metasystema.net/essays/reply-to.html

   Most Python-related lists I know are setup without Reply-To.

   I personally on the "Reply-To Munging Considered Harmful" side, but I
must say I use a mail user agent (mutt) that has all 3 commands - reply,
reply to all, reply to the list. Also mutt allows to ignore Reply-To from
mailing lists, so I don't care too much.

   What do people think? If most people say they want Reply-To I can
change the list options.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Search for Full Name

[Oleg B. <ph...@ph...>]

Please reply to the list, not to personal address.

On Wed, Apr 14, 2010 at 01:43:22PM -0500, ji...@ql... wrote:
> Thanks for the response.  Unfortunately, I'm using MySQL

   With MySQL, use function CONCAT:

from sqlobject.sqlbuilder import func
Contact.select(func.CONCAT(Contact.q.name, ' ', Contact.q.surname) == 'Test1 One')

SELECT id, name, surname FROM contact WHERE ((CONCAT(name, ' ', surname)) = ('Test1 One'))

   I replaced CONTAINSSTRING with an equality test, just for example.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Search for Full Name

[Oleg B. <ph...@ph...>]

On Wed, Apr 14, 2010 at 01:09:41PM -0500, ji...@ql... wrote:
> I've got a model with a Contact object.  It has separate attributes for firstName and lastName.  In various parts of my app I'd like to be able to provide a search function where a user could type in part of a person's name that included the first name and part of the last and then display a list of those matching.
> 
> I know I can search on just the firstName using:
> 
> contacts = Contact.select(Contact.q.firstName.contains(searchText.encode('utf8')))
> 
> But, if someone types 'Jim Steil' in the search box, this filter would exclude the record for me because of the last name being there.  I'm wondering if there is some magic in SQLObject that will allow me to apply this search string against the combination of the firstName and lastName attributes of the Contact object.

   SQLObject doesn't abstract away string concatenation, and that's bad
because most databases except MySQL use '||' operator, not a function.

   You want something like

from sqlobject.sqlbuilder import SQLOp, CONTAINSSTRING
Contact.select(CONTAINSSTRING(SQLOp('||', SQLOp('||', Contact.q.name, ' '), Contact.q.surname), 'Test1 One'))

   SQL query is

SELECT id, name, surname FROM contact WHERE ((((name) || (' ')) || (surname)) LIKE ('%Test1 One%'))

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

[SQLObject] Search for Full Name

[<ji...@ql...>]

Hi

 

I've got a model with a Contact object.  It has separate attributes for firstName and lastName.  In various parts of my app I'd like to be able to provide a search function where a user could type in part of a person's name that included the first name and part of the last and then display a list of those matching.

 

I know I can search on just the firstName using:

 

contacts = Contact.select(Contact.q.firstName.contains(searchText.encode('utf8')))

 

But, if someone types 'Jim Steil' in the search box, this filter would exclude the record for me because of the last name being there.  I'm wondering if there is some magic in SQLObject that will allow me to apply this search string against the combination of the firstName and lastName attributes of the Contact object.

 

Anyone?

 

                -Jim

 

Re: [SQLObject] More connections for more tables

[Petr J. <pet...@tp...>]

>
> By the way: How are you solving problem with new creating new database? I
> mean do you check if the table exist? Because I am using this code:
>
> try:
>     alreadyUsed.createTable()
>     Pathject.createTable()
>     print "I couldn´t find any table so I h´ve created one!"
>
> except dberrors.OperationalError:
>     pass
>
> But I think it´s a dirty...  And one more thing: it would be nice if there
> was some direct link to http://wiki.sqlobject.org/ from
> http://www.sqlobject.org/ because on wiki are really useful information...
>
>
>
>
   1. do not top post, please

   2. try to reply/send to sql...@li... instead
   of the direct mail

   3. maybe you are looking for this:

   Pathject.dropTable(ifExists=True), Pathject.createTable(ifNotExists=True)



HTH

Petr

Re: [SQLObject] More connections for more tables

[Petr J. <pet...@tp...>]

On 14 April 2010 12:11, Oleg Broytman <ph...@ph...> wrote:

> On Tue, Apr 13, 2010 at 11:49:47PM +0200, Visgean Skeloru wrote:
> > Hello is it possible to set a specific connections database for each
> class?
>
>   Yes. Every SQLObject class has a classmethod setConnection. Call it
> MyTable.setConnection(connection); connection can be a string or an open
> connection (SQLObject's DBConnection, not a Python DB API connection).
>   Every method has a connection parameter.
>
> Or you can define your connection directly in the Class as an attribute,
for example:

_connection = connectionRAMdisk

I do not know, if this is the cleanest way, but works great.

Petr

Re: [SQLObject] More connections for more tables

[Oleg B. <ph...@ph...>]

On Tue, Apr 13, 2010 at 11:49:47PM +0200, Visgean Skeloru wrote:
> Hello is it possible to set a specific connections database for each class?

   Yes. Every SQLObject class has a classmethod setConnection. Call it
MyTable.setConnection(connection); connection can be a string or an open
connection (SQLObject's DBConnection, not a Python DB API connection).
   Every method has a connection parameter.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] More connections for more tables

[Juan M. S. <vic...@gm...>]

From: Visgean Skeloru <vi...@gm...>
To: sql...@li...
Date: Tuesday 13 April 2010
> Hello is it possible to set a specific connections database for each class?
> 
> because i have 2 class and one of them is temporary so i would like to use
> sqlite in memory.

Yes, it's possible. One way is to pass a connection parameter at class 
creation (that's at least the way I do it). This may look like:

from sqlobject import SQLObject, connectionForURI

class AnObject(SQLObject):
	one_attr = StringCol()

con = connectionForURI("sqlite:/:memory:")
obj = AnObject(one_attr="one attr", connection=con)

 The other way is defining the _connection attribute on the class definition. I 
have never tried it but from reading the doc I think I remember it quite like 
this:

con = connectionForURI("sqlite:/:memory:")

class AnObject(SQLObject)
	one_attr = StringCol()
	_connection = con

With the first one you have to keep in mind to pass the connection parameters 
in later operations, such as select (again, that's at least the way I do it). 
I have never fiddled with the second one, so I can't provide some experience on 
the matter.

Please do post your results :)

Cheers
Juan Manuel Santos

[SQLObject] More connections for more tables

[Visgean S. <vi...@gm...>]

Hello is it possible to set a specific connections database for each class?

because i have 2 class and one of them is temporary so i would like to use
sqlite in memory.

Re: [SQLObject] SQLObject 0.12.3

[Daniel F. <fet...@go...>]

> I'm pleased to announce version 0.12.3, a minor bugfix release of branch
> 0.12
> of SQLObject.

Thanks a lot, again, Oleg!

Cheers,
Daniel


-- 
Psss, psss, put it down! - http://www.cafepress.com/putitdown

[SQLObject] SQLObject 0.12.3

[Oleg B. <ph...@ph...>]

Hello!

I'm pleased to announce version 0.12.3, a minor bugfix release of branch 0.12
of SQLObject.


What is SQLObject
=================

SQLObject is an object-relational mapper.  Your database tables are described
as classes, and rows are instances of those classes.  SQLObject is meant to be
easy to use and quick to get started with.

SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite,
Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB).


Where is SQLObject
==================

Site:
http://sqlobject.org

Development:
http://sqlobject.org/devel/

Mailing list:
https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss

Archives:
http://news.gmane.org/gmane.comp.python.sqlobject

Download:
http://cheeseshop.python.org/pypi/SQLObject/0.12.3

News and changes:
http://sqlobject.org/News.html


What's New
==========

News since 0.12.2
-----------------

* Fixed a bug in replacing _connection in a case when no previous
  _connection has been set.

For a more complete list, please see the news:
http://sqlobject.org/News.html

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

[SQLObject] SQLObject 0.11.5

[Oleg B. <ph...@ph...>]

Hello!

I'm pleased to announce version 0.11.5, a minor bugfix release of 0.11 branch
of SQLObject.


What is SQLObject
=================

SQLObject is an object-relational mapper.  Your database tables are described
as classes, and rows are instances of those classes.  SQLObject is meant to be
easy to use and quick to get started with.

SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite,
Firebird, Sybase, MSSQL and MaxDB (also known as SAPDB).


Where is SQLObject
==================

Site:
http://sqlobject.org

Development:
http://sqlobject.org/devel/

Mailing list:
https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss

Archives:
http://news.gmane.org/gmane.comp.python.sqlobject

Download:
http://cheeseshop.python.org/pypi/SQLObject/0.11.5

News and changes:
http://sqlobject.org/News.html


What's New
==========

News since 0.11.4
-----------------

* Fixed a bug in replacing _connection in a case when no previous
  _connection has been set.

For a more complete list, please see the news:
http://sqlobject.org/News.html

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] rdbhost

[Oleg B. <ph...@ph...>]

On Fri, Apr 09, 2010 at 06:37:27PM -0300, Juan Manuel Santos wrote:
> On Fri, Apr 9, 2010 at 6:05 PM, Oleg Broytman <ph...@ph...> wrote:
> > On Fri, Apr 09, 2010 at 05:51:46PM -0300, Juan Manuel Santos wrote:
> > > > > http://svn.colorstudy.com/SQLObject/trunk/sqlobject/
> > > >
> > > >    Aha, I see - I have forgotten to add it to setup.py. Will be fixed.
> > >
> > > No probs, just post when it's ready and I'll test
> >
> >    Must be ready now.
> 
> Works fine Oleg, thanks :)

   Thank you for testing!

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] rdbhost

[Juan M. S. <vic...@gm...>]

On Fri, Apr 9, 2010 at 6:05 PM, Oleg Broytman <ph...@ph...> wrote:

> On Fri, Apr 09, 2010 at 05:51:46PM -0300, Juan Manuel Santos wrote:
> > > > http://svn.colorstudy.com/SQLObject/trunk/sqlobject/
> > >
> > >    Aha, I see - I have forgotten to add it to setup.py. Will be fixed.
> >
> > No probs, just post when it's ready and I'll test
>
>    Must be ready now.
>
> Oleg.
> --
>     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
>           Programmers don't die, they just GOSUB without RETURN.
>

Works fine Oleg, thanks :)

Juan Manuel

Re: [SQLObject] rdbhost

[Oleg B. <ph...@ph...>]

On Fri, Apr 09, 2010 at 05:51:46PM -0300, Juan Manuel Santos wrote:
> > > http://svn.colorstudy.com/SQLObject/trunk/sqlobject/
> >
> >    Aha, I see - I have forgotten to add it to setup.py. Will be fixed.
> 
> No probs, just post when it's ready and I'll test

   Must be ready now.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] rdbhost

[Juan M. S. <vic...@gm...>]

On Fri, Apr 9, 2010 at 5:34 PM, Oleg Broytman <ph...@ph...> wrote:

> On Sat, Apr 10, 2010 at 12:32:02AM +0400, Oleg Broytman wrote:
> > >     import rdbhost
> > > ImportError: No module named rdbhost
> >
> >    That's strange. I see the directory in SVN:
> > http://svn.colorstudy.com/SQLObject/trunk/sqlobject/
> >    and I can import it.
>
>    Aha, I see - I have forgotten to add it to setup.py. Will be fixed.
>
> Oleg.
> --
>     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
>           Programmers don't die, they just GOSUB without RETURN.
>
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>

No probs, just post when it's ready and I'll test

Cheers

Juan Manuel

Re: [SQLObject] rdbhost

[Oleg B. <ph...@ph...>]

On Sat, Apr 10, 2010 at 12:32:02AM +0400, Oleg Broytman wrote:
> >     import rdbhost
> > ImportError: No module named rdbhost
> 
>    That's strange. I see the directory in SVN:
> http://svn.colorstudy.com/SQLObject/trunk/sqlobject/
>    and I can import it.

   Aha, I see - I have forgotten to add it to setup.py. Will be fixed.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.