python - Using web2py for a user frontend crud -

i asked port access database mysql , provide simple web frontend users. db consists of 8-10 tables , stores data clients consulting (client, consultant,topic, hours, ...).

i need provide webinterface our consultants use, insert information during session predefined mask/form.

my initial thought port access-db mysql, have done , use web2py framework build user interface login, inserting data, browse/scroll through cases , pulling reports.

web2py usermanagment , few samples views & controllers , mysql-db running. added db dal in web2py, noticed, web2py mandatory define every table again in web2py being able communicate sql-server.

while struggeling succesfully run extract_mysql_models.py script export structure of existing sql db use in web2py concerns web2py accumulating.

this double/redundant way of talking db strikes me odd , web2py not support python3.

is web2py correct way fulfill task or there better way?

thank listening/helping out.

this double/redundant way of talking db strikes me odd , web2py not support python3.

any abstraction want use communicate database (whether web2py dal, django orm, sqlalchemy, etc.) have have knowledge of database schema in order construct queries.

even if programmatically generated sql statements without use of orm/dal, code still have have knowledge of database structure (i.e., somewhere have specify names of tables , fields, etc.).

for existing databases, aim automate process via introspection of database schema, purpose of extract_mysql_models.py script. if script isn't working, should report issue on github and/or open thread on web2py google group.

also, note when creating new database, web2py helps avoid redundant specification of schema handling migrations (including table creation) -- specify schema only in web2py, , dal automatically create tables in database (of course, optional).