headers
Oleg Broytmann | 6 May 14:08
X-Face
Picon
Favicon

SQLObject 0.9.10

Hello!

I'm pleased to announce version 0.9.10, a minor bugfix release of 0.9 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
(Continue reading)

Permalink | Reply | 0 comments |
headers
Oleg Broytmann | 6 May 14:19
X-Face
Picon
Favicon

SQLObject 0.10.5

Hello!

I'm pleased to announce version 0.10.5, a minor bugfix release of 0.10 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
(Continue reading)

Permalink | Reply | 0 comments |
headers
Oleg Broytmann | 11 May 08:57
X-Face
Picon
Favicon

Python 2.6

Since revision 3880 SQLObject works with Python 2.6; actually, it worked
just fine even before but it raised a DeprecationWarning on import sets;
now it doesn't and is fully tested with SQLite and Postgres. On the next
releases (0.10.6 and 0.11) there will be python eggs for 2.6.

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com
Permalink | Reply | 1 comment |
headers
Daniel Fetchinson | 11 May 19:28

Re: Python 2.6

> Since revision 3880 SQLObject works with Python 2.6; actually, it worked
> just fine even before but it raised a DeprecationWarning on import sets;
> now it doesn't and is fully tested with SQLite and Postgres. On the next
> releases (0.10.6 and 0.11) there will be python eggs for 2.6.

This is great, thanks a lot, Oleg!

Cheers,
Daniel

--

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

------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com
Permalink | Reply | 0 comments |
headers
Daniel Fetchinson | 11 May 19:30

Re: SQLObject is alive!

> Hello! I am going to do the next round of minor releases. Does anybody need
> a beta period?

Oooops, I missed this announcement. In general I don't need a beta
period at all, since if the new versions are not okay, I can simply
switch back to the older version.

The new 0.10.5 version works perfectly with my app, thanks for the hard work!

Cheers,
Danil

--

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

------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com
Permalink | Reply | 2 comments |
headers
Oleg Broytmann | 11 May 19:35
X-Face
Picon
Favicon

Re: SQLObject is alive!

On Mon, May 11, 2009 at 10:30:56AM -0700, Daniel Fetchinson wrote:
> > Hello! I am going to do the next round of minor releases. Does anybody need
> > a beta period?
> 
> Oooops, I missed this announcement. In general I don't need a beta
> period at all, since if the new versions are not okay, I can simply
> switch back to the older version.

   I usually don't make betas for minor releases but this time there were
many changes (albeit minor ones) in a long period without release.

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com
Permalink | Reply | 1 comment |
headers
Daniel Fetchinson | 12 May 03:25

Re: SQLObject is alive!

>> > Hello! I am going to do the next round of minor releases. Does anybody
>> > need
>> > a beta period?
>>
>> Oooops, I missed this announcement. In general I don't need a beta
>> period at all, since if the new versions are not okay, I can simply
>> switch back to the older version.
>
>    I usually don't make betas for minor releases but this time there were
> many changes (albeit minor ones) in a long period without release.

Makes perfect sense.
In any case it's good to see that sqlobject is alive!

Cheers,
Daniel

--

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

------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com
Permalink | Reply | 0 comments |
headers
inhahe | 12 May 09:08
Picon

help with circular foreign keys?

sorry if there was something in the documentation i should have understood, but i'm having this problem

the code:

class Pics(SQLObject):
  itemid = IntCol()
  picdata = BLOBCol()
  thumbnail = ForeignKey("Thumbs", cascade='null')
try:
  Pics.createTable()
  print "Created table Pics"
except dberrors.OperationalError: pass

class Thumbs(SQLObject):
  itemid = IntCol()
  pic = ForeignKey("Pics", cascade=True)
  picdata = BLOBCol()
try:
  Pics.createTable()
  print "Created table Pics"
except dberrors.OperationalError: pass

the error:

KeyError: 'No class Thumbs found in the registry [default] (these classes exist:
 Log, Pics, RegisterSessions, SQLObject, Sessions, Users)'

that list is a list of all the tables created before i got to that point, so i assume the error is that Thumbs must be registered before I can make a foreign key to it, but then if I put Thumbs before Pics, Pics wouldn't be registered yet when I try to make a foreign key to that.  how do i solve this?  sorry if the answer is supposed to be obvious =p


------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
Permalink | Reply | 3 comments |
headers
Oleg Broytmann | 12 May 10:00
X-Face
Picon
Favicon

Re: help with circular foreign keys?

On Tue, May 12, 2009 at 03:08:16AM -0400, inhahe wrote:
> class Pics(SQLObject):
>   itemid = IntCol()
>   picdata = BLOBCol()
>   thumbnail = ForeignKey("Thumbs", cascade='null')
> try:
>   Pics.createTable()
>   print "Created table Pics"
> except dberrors.OperationalError: pass

   Why do you need these try/except?

> class Thumbs(SQLObject):
>   itemid = IntCol()
>   pic = ForeignKey("Pics", cascade=True)
>   picdata = BLOBCol()
> try:
>   Pics.createTable()
>   print "Created table Pics"
> except dberrors.OperationalError: pass
> 
> KeyError: 'No class Thumbs found in the registry

http://sqlobject.org/FAQ.html#mutually-referencing-tables

Oleg.
--

-- 
     Oleg Broytmann            http://phd.pp.ru/            phd <at> phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com
Permalink | Reply | 2 comments |
headers
inhahe | 12 May 20:57
Picon

Re: help with circular foreign keys?



On Tue, May 12, 2009 at 4:00 AM, Oleg Broytmann <phd <at> phd.pp.ru> wrote:
On Tue, May 12, 2009 at 03:08:16AM -0400, inhahe wrote:
> class Pics(SQLObject):
>   itemid = IntCol()
>   picdata = BLOBCol()
>   thumbnail = ForeignKey("Thumbs", cascade='null')
> try:
>   Pics.createTable()
>   print "Created table Pics"
> except dberrors.OperationalError: pass

  Why do you need these try/except?

i want it to create each table but only if the table doesn't already exist
if it already exists it gives me an operationalerror. 
i had tried looking for a better way but couldn't find one!
 

http://sqlobject.org/FAQ.html#mutually-referencing-tables


ah, thanks

------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
Permalink | Reply | 1 comment |

Gmane