Menu
▾
▴
sqlobject-discuss
|
From: Ian B. <ia...@co...> - 2003-06-28 22:52:49
|
I believe I have everything together for SQLObject 0.4 A release candidate exists at: http://colorstudy.com/SQLObject-0.4rc1.tar.gz I'd appreciate it people could give it a try, to see if there's problems with the distribution or anything else. I've also restructured and rewritten a lot of the documentation, so I'd appreciate any feedback anyone has on that as well. The changes are described in News.txt Ian |
|
From: Edmund L. <el...@in...> - 2003-06-28 23:08:49
|
Ian Bicking wrote: > I believe I have everything together for SQLObject 0.4 A release > candidate exists at: > > http://colorstudy.com/SQLObject-0.4rc1.tar.gz Is it wise to check out a copy from the CVS repository? ...Edmund. |
|
From: Ian B. <ia...@co...> - 2003-06-28 23:53:46
|
On Sat, 2003-06-28 at 18:08, Edmund Lian wrote: > Ian Bicking wrote: > > > I believe I have everything together for SQLObject 0.4 A release > > candidate exists at: > > > > http://colorstudy.com/SQLObject-0.4rc1.tar.gz > > Is it wise to check out a copy from the CVS repository? Sure, CVS is currently the same as 0.4rc1. At least as long as I didn't accidentally leave any files out of the tarball. Ian |
|
From: Matt G. <ma...@po...> - 2003-06-30 14:30:25
|
Using:
python 2.2.2
sqlite 2.8.3
pysqlite 0.4.3
SQLObject 0.4rc1
SQLite support seems a bit broken ...
len(Person.select('all')) - "TypeError: an integer is required". I guess
this is because SQLite always uses strings.
Also, when a slice does not include an upper bound, i.e.
Person.select('all')[10:] or Person.select('all')[1], the generated SQL
is missing the LIMIT part of the clause. According to the SQLite docs it
should include "LIMIT 0" if there is no upper bound.
All of the above work fine with PostgreSQL.
Cheers, Matt
Ian Bicking wrote:
>I believe I have everything together for SQLObject 0.4 A release
>candidate exists at:
>
>http://colorstudy.com/SQLObject-0.4rc1.tar.gz
>
>I'd appreciate it people could give it a try, to see if there's problems
>with the distribution or anything else. I've also restructured and
>rewritten a lot of the documentation, so I'd appreciate any feedback
>anyone has on that as well.
>
>The changes are described in News.txt
>
> Ian
>
>
>
>
>-------------------------------------------------------
>This SF.Net email sponsored by: Free pre-built ASP.NET sites including
>Data Reports, E-commerce, Portals, and Forums are available now.
>Download today and enter to win an XBOX or Visual Studio .NET.
>http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
>_______________________________________________
>sqlobject-discuss mailing list
>sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>
>
--
Matt Goodall, Pollenation Internet Ltd
e: ma...@po...
t: 0113 2252500
|
|
From: Matt G. <ma...@po...> - 2003-06-30 14:47:18
|
Changing SQLiteConnection's _queryAddLimitOffset() to the following
fixes the missing upper bound problem.
def _queryAddLimitOffset(self, query, start, end):
if not start:
return "%s LIMIT %i" % (query, end)
if not end:
return "%s LIMIT 0 OFFSET %i" % (query, start)
return "%s LIMIT %i OFFSET %i" % (query, end-start, start)
Cheers, Matt
Matt Goodall wrote:
> Using:
> python 2.2.2
> sqlite 2.8.3
> pysqlite 0.4.3
> SQLObject 0.4rc1
>
> SQLite support seems a bit broken ...
>
> len(Person.select('all')) - "TypeError: an integer is required". I
> guess this is because SQLite always uses strings.
>
> Also, when a slice does not include an upper bound, i.e.
> Person.select('all')[10:] or Person.select('all')[1], the generated
> SQL is missing the LIMIT part of the clause. According to the SQLite
> docs it should include "LIMIT 0" if there is no upper bound.
>
> All of the above work fine with PostgreSQL.
>
> Cheers, Matt
>
> Ian Bicking wrote:
>
>> I believe I have everything together for SQLObject 0.4 A release
>> candidate exists at:
>>
>> http://colorstudy.com/SQLObject-0.4rc1.tar.gz
>>
>> I'd appreciate it people could give it a try, to see if there's problems
>> with the distribution or anything else. I've also restructured and
>> rewritten a lot of the documentation, so I'd appreciate any feedback
>> anyone has on that as well.
>>
>> The changes are described in News.txt
>>
>> Ian
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
>> Data Reports, E-commerce, Portals, and Forums are available now.
>> Download today and enter to win an XBOX or Visual Studio .NET.
>> http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
>> _______________________________________________
>> sqlobject-discuss mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>>
>>
>
--
Matt Goodall, Pollenation Internet Ltd
e: ma...@po...
t: 0113 2252500
|
|
From: Matt G. <ma...@po...> - 2003-06-30 14:51:39
|
and forcing queryOne()[0] to an int (as below) fixes the len() problem
for SQLite. That works fine with PostgreSQL and I can't think of a
reason why it would break anything else.
def countSelect(self, select):
q = "SELECT COUNT(*) FROM %s WHERE %s" % \
(", ".join(select.tables),
self.whereClauseForSelect(select, limit=0, order=0))
val = int(self.queryOne(q)[0])
if self.debug:
print "COUNT results:", val
return val
Cheers, Matt
Matt Goodall wrote:
> Using:
> python 2.2.2
> sqlite 2.8.3
> pysqlite 0.4.3
> SQLObject 0.4rc1
>
> SQLite support seems a bit broken ...
>
> len(Person.select('all')) - "TypeError: an integer is required". I
> guess this is because SQLite always uses strings.
>
> Also, when a slice does not include an upper bound, i.e.
> Person.select('all')[10:] or Person.select('all')[1], the generated
> SQL is missing the LIMIT part of the clause. According to the SQLite
> docs it should include "LIMIT 0" if there is no upper bound.
>
> All of the above work fine with PostgreSQL.
>
> Cheers, Matt
>
> Ian Bicking wrote:
>
>> I believe I have everything together for SQLObject 0.4 A release
>> candidate exists at:
>>
>> http://colorstudy.com/SQLObject-0.4rc1.tar.gz
>>
>> I'd appreciate it people could give it a try, to see if there's problems
>> with the distribution or anything else. I've also restructured and
>> rewritten a lot of the documentation, so I'd appreciate any feedback
>> anyone has on that as well.
>>
>> The changes are described in News.txt
>>
>> Ian
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
>> Data Reports, E-commerce, Portals, and Forums are available now.
>> Download today and enter to win an XBOX or Visual Studio .NET.
>> http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
>> _______________________________________________
>> sqlobject-discuss mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>>
>>
>
--
Matt Goodall, Pollenation Internet Ltd
e: ma...@po...
t: 0113 2252500
|
|
From: Ian B. <ia...@co...> - 2003-06-30 22:44:56
|
Thanks for noting these. I've applied your fixes to CVS, and they'll go
in 0.4final.
On Mon, 2003-06-30 at 09:33, Matt Goodall wrote:
> Using:
> python 2.2.2
> sqlite 2.8.3
> pysqlite 0.4.3
> SQLObject 0.4rc1
>
> SQLite support seems a bit broken ...
>
> len(Person.select('all')) - "TypeError: an integer is required". I guess
> this is because SQLite always uses strings.
>
> Also, when a slice does not include an upper bound, i.e.
> Person.select('all')[10:] or Person.select('all')[1], the generated SQL
> is missing the LIMIT part of the clause. According to the SQLite docs it
> should include "LIMIT 0" if there is no upper bound.
>
> All of the above work fine with PostgreSQL.
>
> Cheers, Matt
>
> Ian Bicking wrote:
>
> >I believe I have everything together for SQLObject 0.4 A release
> >candidate exists at:
> >
> >http://colorstudy.com/SQLObject-0.4rc1.tar.gz
> >
> >I'd appreciate it people could give it a try, to see if there's problems
> >with the distribution or anything else. I've also restructured and
> >rewritten a lot of the documentation, so I'd appreciate any feedback
> >anyone has on that as well.
> >
> >The changes are described in News.txt
> >
> > Ian
> >
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> >Data Reports, E-commerce, Portals, and Forums are available now.
> >Download today and enter to win an XBOX or Visual Studio .NET.
> >http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
> >_______________________________________________
> >sqlobject-discuss mailing list
> >sql...@li...
> >https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
> >
> >
|
|
From: Ian B. <ia...@co...> - 2003-06-30 22:44:56
|
Thanks for noting these. The fixes you gave are in CVS, and they'll go
in 0.4 as well.
On Mon, 2003-06-30 at 09:33, Matt Goodall wrote:
> Using:
> python 2.2.2
> sqlite 2.8.3
> pysqlite 0.4.3
> SQLObject 0.4rc1
>
> SQLite support seems a bit broken ...
>
> len(Person.select('all')) - "TypeError: an integer is required". I guess
> this is because SQLite always uses strings.
>
> Also, when a slice does not include an upper bound, i.e.
> Person.select('all')[10:] or Person.select('all')[1], the generated SQL
> is missing the LIMIT part of the clause. According to the SQLite docs it
> should include "LIMIT 0" if there is no upper bound.
>
> All of the above work fine with PostgreSQL.
>
> Cheers, Matt
>
> Ian Bicking wrote:
>
> >I believe I have everything together for SQLObject 0.4 A release
> >candidate exists at:
> >
> >http://colorstudy.com/SQLObject-0.4rc1.tar.gz
> >
> >I'd appreciate it people could give it a try, to see if there's problems
> >with the distribution or anything else. I've also restructured and
> >rewritten a lot of the documentation, so I'd appreciate any feedback
> >anyone has on that as well.
> >
> >The changes are described in News.txt
> >
> > Ian
> >
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> >Data Reports, E-commerce, Portals, and Forums are available now.
> >Download today and enter to win an XBOX or Visual Studio .NET.
> >http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
> >_______________________________________________
> >sqlobject-discuss mailing list
> >sql...@li...
> >https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
> >
> >
|
Thanks for helping keep SourceForge clean.
X