Hello, I noticed that a legacy model (with a different table definition) was imported, overriding db in my module. Everything works now.
Sorry for the noise... Raphael Le jeudi 17 janvier 2013 04:37:16 UTC+1, Massimo Di Pierro a écrit : > > What is you print print str(schedulings) instead? Any change? > > On Wednesday, 16 January 2013 07:48:18 UTC-6, [email protected] wrote: >> >> Hello, >> >> I have a table defined like this in my model: >> db.define_table('schedulings', >> Field('name'), >> Field('description'), >> Field('connectorId', db.connectors), >> Field('scenarioId', db.scenarios), >> Field('parametersSetId', db.parametersSets), >> Field('minInterval', 'integer', default=10), >> Field('maxDuration', 'integer', default=0), >> Field('scenarioInstanceId', default=''), >> Field('nextRun', 'double'), >> ) >> >> db.schedulings.name.requires = [IS_NOT_IN_DB(db, 'schedulings.name'), >> IS_NOT_EMPTY()] >> db.schedulings.connectorId.requires = IS_IN_DB(db, db.connectors.id) >> db.schedulings.scenarioId.requires = IS_IN_DB(db, db.scenarios.id) >> db.schedulings.parametersSetId.requires = IS_IN_DB(db, >> db.parametersSets.id) >> db.schedulings.minInterval.requires = IS_INT_IN_RANGE(0, 86401) >> db.schedulings.maxDuration.requires = IS_INT_IN_RANGE(0, 86400*7+1) >> >> When I use appadmin, I can verify that all the fields are populated: >> schedulings.id schedulings.name schedulings.description >> schedulings.connectorId schedulings.scenarioId >> schedulings.parametersSetId schedulings.minInterval >> schedulings.maxDuration schedulings.scenarioInstanceId >> schedulings.nextRun >> 1 test 1 1 8 10 0 None >> >> But when I do a simple select with all fields, I don't get all the >> fields. This code (launched as an homemade task queue): >> schedulings = db().select(db.schedulings.ALL) >> print schedulings.as_list() >> outputs: >> [{'minInterval': 10, 'description': '', 'scenarioId': 1, 'connectorId': >> 1, 'id': 1, 'maxDuration': 0, 'name': 'test'}] >> >> For instance, parametersSetId, set to 8 is not present in the row >> retrieved. >> >> Any idea why? >> >> Thanks in advance. >> >> Best Regards, >> Raphael >> > --
