Hi guys,
I've been trying to use legacy postgres databases that uses a custom
sequence name.
I'm able to read and write a table, by specifying the sequence_name
parameter when declaring the Table object
lets say:
table_name = 'table'
db.define_table(table_name,
Field('%s_id'%table_name,'id'),
Field('filed1','string'),
Field('field2','string'),
migrate=True,
sequence_name = '%s_pk_seq'%tablename)
It the table is created before using web2py everything goes smooth,
and I can add values and fields to the table.
However I the Table do not exist, web2py creates it without setting
the given sequence name.
Is this the supposed behavior? or am I mistaken?
If this is currently not supported, maybe I can try to implement it.
In that case which file should I work on? sql.py or dal.py?
Is still not clear to me which one is the currently developed one...