.
On Wed, Oct 1, 2008 at 2:59 PM, Oleg Broytmann <[EMAIL PROTECTED]> wrote:
> On Wed, Oct 01, 2008 at 02:34:16PM -0300, Leandro Sales wrote:
>> On Tue, Sep 30, 2008 at 7:19 PM, Leandro Sales <[EMAIL PROTECTED]> wrote:
>> > but instead, I'd check which domain name is in
On Wed, Oct 1, 2008 at 4:11 PM, Oleg Broytmann <[EMAIL PROTECTED]> wrote:
> On Wed, Oct 01, 2008 at 03:41:09PM -0300, Leandro Sales wrote:
>> qname = "www.domain1.com"
>> domain = Domain.select("""'""" + qname + ""&
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:
IDname
--
1 domai
On Wed, Oct 1, 2008 at 5:56 PM, Leandro Sales <[EMAIL PROTECTED]> wrote:
> How can I add more than 2 ands in a query?
>
> Something like:
> MySQLObject.select(AND(X,Y,Z))
>
> Thank you,
> Leandro.
>
I tested in this way and
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 app
On Wed, Oct 1, 2008 at 4:32 PM, Oleg Broytmann <[EMAIL PROTECTED]> wrote:
> On Wed, Oct 01, 2008 at 04:16:53PM -0300, Leandro Sales wrote:
>> x = ObjectParent.select(some_query)
>>
>> ... aparrently sqlobject loads also x.objects, selecting all related
>> object
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):
n
On Wed, Oct 1, 2008 at 3:29 PM, Oleg Broytmann <[EMAIL PROTECTED]> wrote:
> On Wed, Oct 01, 2008 at 03:19:14PM -0300, Leandro Sales wrote:
>> SELECT * FROM domain WHERE LOCATE(name, hostname);
>
> Try:
>
> from sqlobject.sqlbuilder import func
> Domain.select(func.
On Wed, Oct 1, 2008 at 3:19 PM, Leandro Sales <[EMAIL PROTECTED]> wrote:
> I'd like a sqlobject query that does:
>
> Domain table:
> id name
> 1domain1.com
> 2domain2.com
> 3domain3.com
>
> hostname = 'www.domain1.com&#x
On Tue, Sep 30, 2008 at 7:19 PM, Leandro Sales <[EMAIL PROTECTED]> wrote:
>
> 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,
In fact, this is another way to do what you want.
On 1/19/08, Petr Jakeš <[EMAIL PROTECTED]> wrote:
> Problem solved,
>
> p = MyTable.select(MyTable.q.name == "pets")
> works instead of:
> p = MyTable.selectBy(name == "pets")
>
> Sorry for bothering your weekend time :-)
>
> Petr
>
> On Jan 19, 20
The correct is:
MyTable.selectBy(name = "pets")
You're using == instead of =
Leandro.
On 1/19/08, Petr Jakeš <[EMAIL PROTECTED]> wrote:
> Hi, I have following problem:
>
> following code throw this error:
> unhandled NameError, global name 'name' is not defined
> and I really do not know what
2007/12/13, Oleg Broytmann <[EMAIL PROTECTED]>:
>
> On Thu, Dec 13, 2007 at 02:16:15PM -0300, Leandro Sales wrote:
> > class DBObject(InheritableSQLObject):
> > title = UnicodeCol(length=100, default="")
> >
> > class DBItem(DBObject, Inherita
hank you so much,
Leandro.
2007/12/13, Oleg Broytmann <[EMAIL PROTECTED]>:
>
> On Wed, Dec 12, 2007 at 07:11:56PM -0300, Leandro Sales wrote:
> > DELETE FROM db_item WHERE db_item.local_path LIKE ' " + local_path + "%'
> "
>
> from sq
Hi,
I need to perform a query like this:
DELETE FROM db_item WHERE db_item.local_path LIKE ' " + local_path + "%' "
How to do this using sqlobject?
My class is named DBItem.
Thanks,
Leandro.
-
SF.Net email is sponsored b
Well,
I just have one thread writing and the others reading, is still it
not possible?
Leandro.
2007/11/29, Simon Cross <[EMAIL PROTECTED]>:
> On 2007/11/29, Leandro Sales <[EMAIL PROTECTED]> wrote:
> > I had a single thread application that access one sqlite datab
ERRATA:
in subject I meant "SQLite database via SQLObject"
Thanks,
Leandro.
2007/11/29, Leandro Sales <[EMAIL PROTECTED]>:
> Hi,
> I had a single thread application that access one sqlite database
> via SQLObject. Recently I change it and now I need to have multiples
Hi,
I had a single thread application that access one sqlite database
via SQLObject. Recently I change it and now I need to have multiples
threads accessing this database. I'm experimenting my new approach and
in some cases I get an exception from SQLObject, like this:
"OperationalError: database
2007/11/23, Oleg Broytmann <[EMAIL PROTECTED]>:
> On Fri, Nov 23, 2007 at 10:53:48AM -0300, Leandro Sales wrote:
> > SELECT db_container.id, db_container.container_id,
> > db_container.child_name FROM db_container, db_object WHERE
> > (((db_object.title) = ('Heathe
2007/11/23, Leandro Sales <[EMAIL PROTECTED]>:
> 2007/11/23, Leandro Sales <[EMAIL PROTECTED]>:
> > 2007/11/23, Oleg Broytmann <[EMAIL PROTECTED]>:
> > > On Fri, Nov 23, 2007 at 08:58:22AM -0300, ?eandro Sales wrote:
> > > > OK. Any comment about th
2007/11/23, Leandro Sales <[EMAIL PROTECTED]>:
> 2007/11/23, Oleg Broytmann <[EMAIL PROTECTED]>:
> > On Fri, Nov 23, 2007 at 08:58:22AM -0300, ?eandro Sales wrote:
> > > OK. Any comment about the error?
> >
> >I cannot run the program - I don't h
Hi,
I use the 'id' attribute of a sqlobject object in my program to
uniquely identify a object. But now I need to use something like
namespace:id as an identifier. What is the best way to produce this
output since id is integer?
I want something like that:
select concat(namespace, ":", id) a
22 matches
Mail list logo
