Re: [SQLObject] variable number of fields

[Oleg B. <ph...@ph...>]

On Sat, Dec 27, 2008 at 11:16:43AM -0800, Daniel Fetchinson wrote:
> I have a table with lots of fields, around 40-50, all the same type,
> integer, and since I'm experimenting with the right number (maybe 40
> is enough, maybe 60 is needed) I'm looking for a way to define these
> fields programmatically as opposed to hard wiring it into the
> SQLObject subclass. Storing the 40-60 integers as a python list and
> storing it as a single field in the table is not really an option
> because I need to search these integers.
> 
> What would be the best way of going about this?

   I have a very wide table with a hundred of similar named columns. The
number of columns is fixed, the names are hardwired, but still I don't want
to list all these columns manually. Well, I just add them at runtime, at
the first import of my model.py:

class Plate(SQLObject):
   # regular columns...

# Layout
for row in CELL_IDXS:
    for column in STRIP_IDXS:
        Plate.sqlmeta.addColumn(StringCol(name="Layout" + '%s%s' % (row, column),
            length=255, default=None))

# Samples (IDs)
for row in CELL_IDXS:
    for column in STRIP_IDXS:
        Plate.sqlmeta.addColumn(IntCol(name="Sample" + '%s%s' % (row, column),
            default=None))

   Does it help?

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