I want to find someone who knows Web2py to assist with a project.
I have a Firebird database schema which I wish to convert into Web2py format. To give you an idea, this is is the kind of thing I want. The full schema is attached.
CREATE TABLE accounts(
accounts_id INTEGER NOT NULL,
acdate DATE,
acs_id INTEGER,
descr CHAR(256),
t1 DECIMAL(9,2),
created_by INTEGER,
created_date TIMESTAMP
);
Note: Try to identify main foreign keys. e.g. acs_id. Convert primary keys to id.
db.define_table("accounts",
Field("acdate", "date", default=None),
Field("acs_id", [login to view URL]),
Field("descr", "string", length=256, default=None),
Field("t1", "decimal(9,2)", default=0),
Field("created_by", db.auth_user, readable=False, writable=False),
Field("created_date", "datetime", default=[login to view URL],readable=False, writable=False),
)