|
From: Carlos R. <car...@gm...> - 2004-12-06 21:35:48
|
As per the documentation:
"StringCol represents CHAR, VARCHAR, and TEXT. The length keyword
argument indicates the CHAR or VARCHAR length -- if not given, then
TEXT is assumed. If you use varchar=False then CHAR will be used,
otherwise VARCHAR is the default."
But when I tried:
<-- rest of the declaration ommited -->
observacao = StringCol(notNone = False, default = '')
I've got this:
cribeiro@fiona:~/work/workflow $ python dbsidercom.py
Traceback (most recent call last):
File "dbsidercom.py", line 556, in ?
_wf = WorkflowBasico(DEFAULT_DB_FILENAME)
File "/home/cribeiro/work/workflow/dbworkflow.py", line 40, in __init__
self.defineCustomDB(db)
File "dbsidercom.py", line 60, in defineCustomDB
class dbNotaFiscal(SQLObject):
File "/usr/lib/python2.3/site-packages/sqlobject/main.py", line 177,
in __new__
newClass.addColumn(column)
File "/usr/lib/python2.3/site-packages/sqlobject/main.py", line 387,
in addColumn
column = columnDef.withClass(cls)
File "/usr/lib/python2.3/site-packages/sqlobject/col.py", line 286,
in withClass
return self.baseClass(soClass=soClass, name=self._name, **self.kw)
File "/usr/lib/python2.3/site-packages/sqlobject/col.py", line 600,
in __init__
assert self.size is not NoDefault, \
AssertionError: You must give a size argument
What's wrong here, the documentation or the StringCol constructor?
--
Carlos Ribeiro
Consultoria em Projetos
blog: http://rascunhosrotos.blogspot.com
blog: http://pythonnotes.blogspot.com
mail: car...@gm...
mail: car...@ya...
|
|
From: Oleg B. <ph...@ma...> - 2004-12-06 21:50:15
|
On Mon, Dec 06, 2004 at 07:35:44PM -0200, Carlos Ribeiro wrote:
> observacao = StringCol(notNone = False, default = '')
>
> I've got this:
>
> cribeiro@fiona:~/work/workflow $ python dbsidercom.py
> Traceback (most recent call last):
> File "dbsidercom.py", line 556, in ?
> _wf = WorkflowBasico(DEFAULT_DB_FILENAME)
> File "/home/cribeiro/work/workflow/dbworkflow.py", line 40, in __init__
> self.defineCustomDB(db)
> File "dbsidercom.py", line 60, in defineCustomDB
> class dbNotaFiscal(SQLObject):
> File "/usr/lib/python2.3/site-packages/sqlobject/main.py", line 177,
> in __new__
> newClass.addColumn(column)
> File "/usr/lib/python2.3/site-packages/sqlobject/main.py", line 387,
> in addColumn
> column = columnDef.withClass(cls)
> File "/usr/lib/python2.3/site-packages/sqlobject/col.py", line 286,
> in withClass
> return self.baseClass(soClass=soClass, name=self._name, **self.kw)
> File "/usr/lib/python2.3/site-packages/sqlobject/col.py", line 600,
> in __init__
> assert self.size is not NoDefault, \
> AssertionError: You must give a size argument
What is your version of SQLObject? I can find only one such assert in
col.py, in line 606 - in DecimalCol, not StringCol. Well, even in
DecimalCol it's probably a bug, but that's another story.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ ph...@ph...
Programmers don't die, they just GOSUB without RETURN.
|
|
From: Ian B. <ia...@co...> - 2004-12-06 21:57:32
|
Oleg Broytmann wrote: > On Mon, Dec 06, 2004 at 07:35:44PM -0200, Carlos Ribeiro wrote: > >> observacao = StringCol(notNone = False, default = '') >> >>I've got this: >> >>cribeiro@fiona:~/work/workflow $ python dbsidercom.py >>Traceback (most recent call last): >> File "dbsidercom.py", line 556, in ? >> _wf = WorkflowBasico(DEFAULT_DB_FILENAME) >> File "/home/cribeiro/work/workflow/dbworkflow.py", line 40, in __init__ >> self.defineCustomDB(db) >> File "dbsidercom.py", line 60, in defineCustomDB >> class dbNotaFiscal(SQLObject): >> File "/usr/lib/python2.3/site-packages/sqlobject/main.py", line 177, >>in __new__ >> newClass.addColumn(column) >> File "/usr/lib/python2.3/site-packages/sqlobject/main.py", line 387, >>in addColumn >> column = columnDef.withClass(cls) >> File "/usr/lib/python2.3/site-packages/sqlobject/col.py", line 286, >>in withClass >> return self.baseClass(soClass=soClass, name=self._name, **self.kw) >> File "/usr/lib/python2.3/site-packages/sqlobject/col.py", line 600, >>in __init__ >> assert self.size is not NoDefault, \ >>AssertionError: You must give a size argument > > > What is your version of SQLObject? I can find only one such assert in > col.py, in line 606 - in DecimalCol, not StringCol. Well, even in > DecimalCol it's probably a bug, but that's another story. No, it's required for DecimalCol -- databases require size and precision. At least, the ones I know of do...? There's no default for size, hence the assertion. -- Ian Bicking / ia...@co... / http://blog.ianbicking.org |
|
From: Oleg B. <ph...@ma...> - 2004-12-06 22:05:44
|
On Mon, Dec 06, 2004 at 03:53:47PM -0600, Ian Bicking wrote:
> >DecimalCol it's probably a bug, but that's another story.
>
> No, it's required for DecimalCol -- databases require size and
> precision. At least, the ones I know of do...? There's no default for
MySQL, I suppose? :)
> size, hence the assertion.
Postgres 7.2:
"Both the precision and the scale of the numeric type can be configured.
To declare a column of type numeric use the syntax
NUMERIC(precision, scale)
The precision must be positive, the scale zero or positive.
Alternatively,
NUMERIC(precision)
selects a scale of 0. Specifying
NUMERIC
without any precision or scale creates a column in which numeric
values of any precision and scale can be stored, up to the
implementation limit on precision. A column of this kind will not coerce
input values to any particular scale, whereas numeric columns with a
declared scale will coerce input values to that scale."
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ ph...@ph...
Programmers don't die, they just GOSUB without RETURN.
|
|
From: Ian B. <ia...@co...> - 2004-12-06 21:51:58
|
Carlos Ribeiro wrote: > As per the documentation: > > "StringCol represents CHAR, VARCHAR, and TEXT. The length keyword > argument indicates the CHAR or VARCHAR length -- if not given, then > TEXT is assumed. If you use varchar=False then CHAR will be used, > otherwise VARCHAR is the default." > > But when I tried: > > <-- rest of the declaration ommited --> > observacao = StringCol(notNone = False, default = '') > > I've got this: > > cribeiro@fiona:~/work/workflow $ python dbsidercom.py > Traceback (most recent call last): > File "dbsidercom.py", line 556, in ? > _wf = WorkflowBasico(DEFAULT_DB_FILENAME) > File "/home/cribeiro/work/workflow/dbworkflow.py", line 40, in __init__ > self.defineCustomDB(db) > File "dbsidercom.py", line 60, in defineCustomDB > class dbNotaFiscal(SQLObject): > File "/usr/lib/python2.3/site-packages/sqlobject/main.py", line 177, > in __new__ > newClass.addColumn(column) > File "/usr/lib/python2.3/site-packages/sqlobject/main.py", line 387, > in addColumn > column = columnDef.withClass(cls) > File "/usr/lib/python2.3/site-packages/sqlobject/col.py", line 286, > in withClass > return self.baseClass(soClass=soClass, name=self._name, **self.kw) > File "/usr/lib/python2.3/site-packages/sqlobject/col.py", line 600, > in __init__ > assert self.size is not NoDefault, \ > AssertionError: You must give a size argument The lines don't match up with the current checkout, but the only place I see that line is for DecimalCol, not StringCol. -- Ian Bicking / ia...@co... / http://blog.ianbicking.org |
|
From: Carlos R. <car...@gm...> - 2004-12-07 13:44:21
|
On Mon, 06 Dec 2004 15:48:09 -0600, Ian Bicking <ia...@co...> wrote: > Carlos Ribeiro wrote: > The lines don't match up with the current checkout, but the only place I > see that line is for DecimalCol, not StringCol. Sorry, really sorry. A messup of mine. My module referred another module, and I traced the assert failure to the wrong one. Coincidently enough, I had just removed the size for some StringCol's... and it matched exactly that location on another file. An enourmous coincidence. -- Carlos Ribeiro Consultoria em Projetos blog: http://rascunhosrotos.blogspot.com blog: http://pythonnotes.blogspot.com mail: car...@gm... mail: car...@ya... |
