gmane.comp.python.sqlobject

Re: Firebird linux client => windows SQL server problem

Oleg Broytmann — 2008-10-06T12:22:35

Thank you. I will try to find a place in the docs for the example. Oleg.

Re: Firebird linux client => windows SQL server problem

Petr Jakeš — 2008-10-06T12:19:18

------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/_______________________________________________ sqlobject-discuss mailing list sqlobject-discuss< at >lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Re: Firebird linux client => windows SQL server problem

Oleg Broytmann — 2008-10-06T09:18:55

Vertical bar is replaces by a semicolon only on a w32 - it was done specifically for SQLite. I have never considered a possibility for a linux client to connect to a w32 server using w32 filenames. In POSIX OS a vertical bar is a pretty normal character and must not be processed. See: $ echo 'test' >'d|x' $ cat 'd|x' test The most correct way to fix your problem is to connect to the DB using a database name, not a file name. Is it possible in Firebird? db_name = 'sysdat01.gdb' connection_string = 'firebird://winsrv.xxx.xx:3050/' + db_name Oleg.

Firebird linux client => windows SQL server problem

Petr Jakeš — 2008-10-06T08:25:01

Re: Query using ends with

Oleg Broytmann — 2008-10-01T19:33:17

SQLConstant passes its parameter to SQL untouched. Oleg.

Re: Query using ends with

Leandro Sales — 2008-10-01T18:19:14

I'd like a sqlobject query that does: Domain table: id name 1 domain1.com 2 domain2.com 3 domain3.com hostname = 'www.domain1.com' SELECT * FROM domain WHERE hostname LIKE CONCAT('%', name); or in a similar way: SELECT * FROM domain WHERE LOCATE(name, hostname); The problem in the second approach (though I think it is more efficient and the first one), is if the variable hostname is "www.domain1.com.br", the query is still valid, but it shouldn't be. So, what is the best way to do what I need? Thank you, Leandro. On Wed, Oct 1, 2008 at 2:59 PM, Oleg Broytmann phd.pp.ru> wrote:

Re: Query using ends with

Leandro Sales — 2008-10-01T19:27:41

Hello Oleg, it worked, but just as following: from sqlobject.sqlbuilder import SQLConstant domain = Domain.select(SQLConstant("'www.domain1.com'").endswith(Domain.q.name)) Note the single quote between www.domain1.com Thank you, Leandro. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Query using ends with

Leandro Sales — 2008-09-30T22:19:23

Hello. Please consider the following: I have a sqlobject object named Domain that stores the list of available domains: class Domain(SQLObject): name = StringCol(alternateID=True, length=255, default=None) In the database I have domains like: ID name -------------------------- 1 domain1.com 2 domain2.com I'd like to query the domain into the database that contains in a given hostname, lets say "www.domain1.com". I now that I can do something like: domain = Domain.select(Domain.q.name.endswith("www.domain1.com")) but instead, I'd check which domain name is in the hostname. Somethink like: domain = Domain.select("www.domain1.com".endswith(Domain.q.name.endswith())) .. but sqlobject doesn't allow me to do this. Any clue? Thank you, Leandro. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a tri

Re: UnicodeEncodeError

Oleg Broytmann — 2008-09-28T20:33:50

What is Solicitud? An SQLObject table? Then how 'lugar_nacimiento' is declared? Oleg.

Re: Query using sqlobject.sqlbuilder.AND

Oleg Broytmann — 2008-10-01T21:01:19

.select(AND(AND(X,Y,Z), AND(A,B,C))) or just .select(X & Y & Z & A & B & C)) Oleg.

Re: Query using sqlobject.sqlbuilder.AND

Leandro Sales — 2008-10-01T20:57:34

I tested in this way and it worked. Thank you, Leandro. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Query using sqlobject.sqlbuilder.AND

Leandro Sales — 2008-10-01T20:56:31

How can I add more than 2 ands in a query? Something like: MySQLObject.select(AND(X,Y,Z)) Thank you, Leandro. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Re: Lazy query

Leandro Sales — 2008-10-01T19:40:34

In fact, I run one example using debug=1 and the SQL queries mixed between two different calls. That's ok! Thank you once again. Regards, Leandro. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Re: Lazy query

Oleg Broytmann — 2008-10-01T19:32:09

Why do you think SO does that? print ObjectParent.select() => SELECT object_parent.id, object_parent.name FROM object_parent WHERE 1 = 1 Oleg.

Lazy query

Leandro Sales — 2008-10-01T19:16:53

Hi, I have an sqloject object (ObjectParent) that contains others sqlobject objects (OtherObject): class ObjectParent(SQLObject): name = StringCol(alternateID=True, length=255, default=None) objects = MultipleJoin("OtherObject", joinColumn="objectId") class OtherObject(SQLObject): name = StringCol(alternateID=True, length=255, default=None) object = ForeignKey('ObjectParent', dbName='objectId', cascade=True) Then if I do x = ObjectParent.select(some_query) ... aparrently sqlobject loads also x.objects, selecting all related objects. Is it possible to tell to sqlobject to query the records only when I read x.objects for the first time? Thank you, Leandro. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/red

Re: Query using ends with

Oleg Broytmann — 2008-10-01T19:11:22

from sqlobject.sqlbuilder import SQLConstant domain = Domain.select(SQLConstant('www.domain1.com').endswith(Domain.q.name)) Oleg.

Re: Query using ends with

Leandro Sales — 2008-10-01T18:41:09

I don't want to use LOCATE due to what I comment (in some cases it matches a wrong record for my case). I want the record of the Domain table that the field domain.name matches with the end of the variable 'hostname'. This works: qname = "www.domain1.com" domain = Domain.select("""'""" + qname + """' LIKE CONCAT('%', domain.name)""") The question is, is there a better way (more efficient) to do this using sqlobject? Thank you, Leandro. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Re: Query using ends with

Leandro Sales — 2008-10-01T18:30:30

Hello, I did: qname = "www.domain1.com" domain = Domain.select("""'""" + qname + """' LIKE CONCAT('%', domain.name)""") Is there a better way to do this? Thank you, Leandro. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/

Re: Query using ends with

Oleg Broytmann — 2008-10-01T18:29:24

Try: from sqlobject.sqlbuilder import func Domain.select(func.LOCATE(Domain.q.name, hostname)) Oleg.

Re: Query using ends with

Oleg Broytmann — 2008-10-01T17:59:10

I don't understand what query you are going to build. Can you elaborate? Oleg.

Re: Query using ends with

Leandro Sales — 2008-10-01T17:34:16

Hello folks, I already tried many ways to solve this problem, with no success. Can anyone help me? Thank you, Leandro. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/