I have no idea but I will look more into it. Massimo
On Dec 17, 11:22 pm, Johann Spies <[email protected]> wrote: > 2009/12/17 mdipierro <[email protected]>: > > > In the web based shall can you try: > > > print db > > print db.instansie > > print db.instansie.naam > > > what do you get? which os? web2py version? binary or source? > > Last question first: > > This is on a Debian 64-bit system on which I unpacked web2py_src.zip. > > web2py Shell Version 1.74.3 (2009-12-16 15:11:54) > In[0]: > > print db > > Out[0]: > > <SQLDB {'auth_event': <Table {'origin': <gluon.sql.Field object at > 0x9834050>, 'client_ip': <gluon.sql.Field object at 0x98344d0>, > 'user_id': <gluon.sql.Field object at 0x9834750>, 'description': > <gluon.sql.Field object at 0x9834310>, '_referenced_by': [], 'fields': > ['id', 'time_stamp', 'client_ip', 'user_id', 'origin', 'description'], > '_db': <SQLDB {...}>, '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_auth_event.table', > 'ALL': <gluon.sql.SQLALL object at 0x9834110>, '_tablename': > 'auth_event', '_format': None, '_logfilename': > 'applications/kbase/databases/sql.log', 'time_stamp': <gluon.sql.Field > object at 0x9834510>, 'virtualfields': [], 'id': <gluon.sql.Field > object at 0x9834350>}>, 'auth_permission': <Table {'ALL': > <gluon.sql.SQLALL object at 0x9834690>, 'virtualfields': [], 'name': > <gluon.sql.Field object at 0x98348d0>, '_referenced_by': [], 'fields': > ['id', 'group_id', 'name', 'table_name', 'record_id'], '_db': <SQLDB > {...}>, '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_auth_permission.table', > '_logfilename': 'applications/kbase/databases/sql.log', 'table_name': > <gluon.sql.Field object at 0x9834890>, '_tablename': > 'auth_permission', '_format': None, 'record_id': <gluon.sql.Field > object at 0x9834610>, 'group_id': <gluon.sql.Field object at > 0x98347d0>, 'id': <gluon.sql.Field object at 0x9834650>}>, > 'auth_group': <Table {'ALL': <gluon.sql.SQLALL object at 0x9834e90>, > 'description': <gluon.sql.Field object at 0x9834ad0>, > '_referenced_by': [('auth_membership', 'group_id'), > ('auth_permission', 'group_id')], 'fields': ['id', 'role', > 'description'], '_db': <SQLDB {...}>, '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_auth_group.table', > 'role': <gluon.sql.Field object at 0x9834bd0>, '_tablename': > 'auth_group', '_format': '%(role)s (%(id)s)', '_logfilename': > 'applications/kbase/databases/sql.log', 'virtualfields': [], 'id': > <gluon.sql.Field object at 0x9834e50>}>, 'veld': <Table {'ALL': > <gluon.sql.SQLALL object at 0x9c16090>, '_referenced_by': > [('skrywer_artikel', 'veld_id')], 'fields': ['id', 'navorsingsveld'], > '_db': <SQLDB {...}>, '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_veld.table', > '_tablename': 'veld', '_format': None, '_logfilename': > 'applications/kbase/databases/sql.log', 'navorsingsveld': > <gluon.sql.Field object at 0x9c16590>, 'virtualfields': [], 'id': > <gluon.sql.Field object at 0x9c16bd0>}>, '_folder': > 'applications/kbase/databases', 'artikel': <Table {'ALL': > <gluon.sql.SQLALL object at 0x9830790>, 'publikasie_id': > <gluon.sql.Field object at 0x9830750>, '_tablename': 'artikel', > '_referenced_by': [('skrywer_artikel', 'artikel_id'), > ('sleutelwoorde', 'artikel_id')], 'fields': ['id', 'instansie_id', > 'publikasie_tipe_id', 'publikasie_id', 'datum', 'issn', 'id_nr'], > '_db': <SQLDB {...}>, 'issn': <gluon.sql.Field object at 0x98307d0>, > 'datum': <gluon.sql.Field object at 0x9830890>, '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_artikel.table', > 'id_nr': <gluon.sql.Field object at 0x9830650>, 'instansie_id': > <gluon.sql.Field object at 0x98308d0>, '_format': None, > '_logfilename': 'applications/kbase/databases/sql.log', > 'publikasie_tipe_id': <gluon.sql.Field object at 0x9830590>, > 'virtualfields': [], 'id': <gluon.sql.Field object at 0x9830850>}>, > '_cursor': <sqlite3.Cursor object at 0x9831768>, '_pool_size': 0, > '_connection': <sqlite3.Connection object at 0x964fb28>, '_lastsql': > '', '_dbname': 'sqlite', '_execute': <function <lambda> at 0x982fcf8>, > 'publikasie': <Table {'uitgewer': <gluon.sql.Field object at > 0x9830b10>, 'ALL': <gluon.sql.SQLALL object at 0x9830a50>, 'adres': > <gluon.sql.Field object at 0x98309d0>, 'publikasie': <gluon.sql.Field > object at 0x9830b90>, '_referenced_by': [('artikel', > 'publikasie_id')], 'fields': ['id', 'publikasie', 'uitgewer', > 'adres'], '_db': <SQLDB {...}>, '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_publikasie.table', > '_tablename': 'publikasie', '_format': None, '_logfilename': > 'applications/kbase/databases/sql.log', 'virtualfields': [], 'id': > <gluon.sql.Field object at 0x9830a10>}>, 'skrywer_artikel': <Table > {'ALL': <gluon.sql.SQLALL object at 0x995ec50>, 'skrywer_id': > <gluon.sql.Field object at 0x995e3d0>, '_referenced_by': [], 'fields': > ['id', 'artikel_id', 'skrywer_id', 'instansie_id', 'veld_id'], '_db': > <SQLDB {...}>, '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_skrywer_artikel.table', > 'instansie_id': <gluon.sql.Field object at 0x995eb50>, 'veld_id': > <gluon.sql.Field object at 0x995ebd0>, '_tablename': > 'skrywer_artikel', '_format': None, '_logfilename': > 'applications/kbase/databases/sql.log', 'virtualfields': [], 'id': > <gluon.sql.Field object at 0x995ec10>, 'artikel_id': <gluon.sql.Field > object at 0x9c16f10>}>, 'publikasie_tipe': <Table {'ALL': > <gluon.sql.SQLALL object at 0x9830d90>, '_referenced_by': [('artikel', > 'publikasie_tipe_id')], 'fields': ['id', 'tipe'], '_db': <SQLDB > {...}>, '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_publikasie_tipe.table', > 'tipe': <gluon.sql.Field object at 0x9830c50>, '_tablename': > 'publikasie_tipe', '_format': None, '_logfilename': > 'applications/kbase/databases/sql.log', 'virtualfields': [], 'id': > <gluon.sql.Field object at 0x9830c10>}>, 'skrywer': <Table {'ALL': > <gluon.sql.SQLALL object at 0x9830dd0>, 'e_pos': <gluon.sql.Field > object at 0x9830e10>, 'van': <gluon.sql.Field object at 0x9830e50>, > 'instansie_id': <gluon.sql.Field object at 0x9830fd0>, > '_referenced_by': [('skrywer_artikel', 'skrywer_id')], 'fields': > ['id', 'naam', 'van', 'instansie_id', 'e_pos'], '_db': <SQLDB {...}>, > '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_skrywer.table', > '_format': None, '_tablename': 'skrywer', 'naam': <gluon.sql.Field > object at 0x9830b50>, '_logfilename': > 'applications/kbase/databases/sql.log', 'virtualfields': [], 'id': > <gluon.sql.Field object at 0x9830f90>}>, '_db_codec': 'UTF-8', > '_translator': {'upper': 'UPPER(%(field)s)', 'reference': 'REFERENCES > %(foreign_key)s ON DELETE %(on_delete_action)s', 'text': 'TEXT', > 'random': 'Random()', 'datetime': 'TIMESTAMP', 'substring': > 'SUBSTR(%(field)s,%(pos)s,%(length)s)', 'boolean': 'CHAR(1)', > 'extract': "web2py_extract('%(name)s',%(field)s)", 'id': 'INTEGER > PRIMARY KEY AUTOINCREMENT', 'is null': 'IS NULL', 'primarykey': > 'PRIMARY KEY (%s)', 'is not null': 'IS NOT NULL', 'blob': 'BLOB', > 'notnull': 'NOT NULL DEFAULT %(default)s', 'string': > 'CHAR(%(length)s)', 'date': 'DATE', 'integer': 'INTEGER', 'password': > 'CHAR(%(length)s)', 'lower': 'LOWER(%(field)s)', 'left join': 'LEFT > JOIN', 'double': 'DOUBLE', 'decimal': 'DOUBLE', 'upload': > 'CHAR(%(length)s)', 'time': 'TIME'}, 'tables': ['auth_user', > 'auth_group', 'auth_membership', 'auth_permission', 'auth_event', > 'instansie', 'skrywer', 'publikasie_tipe', 'publikasie', 'artikel', > 'veld', 'skrywer_artikel', 'sleutelwoorde'], 'instansie': <Table > {'ALL': <gluon.sql.SQLALL object at 0x9830490>, 'land': > <gluon.sql.Field object at 0x9830710>, '_referenced_by': [('skrywer', > 'instansie_id'), ('artikel', 'instansie_id'), ('skrywer_artikel', > 'instansie_id')], 'fields': ['id', 'naam', 'stad', 'land'], '_db': > <SQLDB {...}>, '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_instansie.table', > 'stad': <gluon.sql.Field object at 0x9834d50>, '_format': None, > '_tablename': 'instansie', 'naam': <gluon.sql.Field object at > 0x9834d90>, '_logfilename': 'applications/kbase/databases/sql.log', > 'virtualfields': [], 'id': <gluon.sql.Field object at 0x9830550>}>, > '_uri': 'sqlite://storage.sqlite', 'auth_membership': <Table {'ALL': > <gluon.sql.SQLALL object at 0x98346d0>, 'group_id': <gluon.sql.Field > object at 0x9834c50>, 'user_id': <gluon.sql.Field object at > 0x9834ed0>, '_referenced_by': [], 'fields': ['id', 'user_id', > 'group_id'], '_db': <SQLDB {...}>, '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_auth_membership.table', > '_tablename': 'auth_membership', '_format': None, '_logfilename': > 'applications/kbase/databases/sql.log', 'virtualfields': [], 'id': > <gluon.sql.Field object at 0x9834550>}>, 'auth_user': <Table > {'first_name': <gluon.sql.Field object at 0x983d490>, 'last_name': > <gluon.sql.Field object at 0x983bf10>, '_referenced_by': > [('auth_membership', 'user_id'), ('auth_event', 'user_id')], 'fields': > ['id', 'first_name', 'last_name', 'email', 'password', > 'registration_key'], '_db': <SQLDB {...}>, '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_auth_user.table', > 'ALL': <gluon.sql.SQLALL object at 0x983b9d0>, 'email': > <gluon.sql.Field object at 0x983bf50>, 'password': <gluon.sql.Field > object at 0x983ba10>, '_tablename': 'auth_user', '_format': > '%(first_name)s %(last_name)s (%(id)s)', '_logfilename': > 'applications/kbase/databases/sql.log', 'virtualfields': [], > 'registration_key': <gluon.sql.Field object at 0x983bb50>, 'id': > <gluon.sql.Field object at 0x983b610>}>, 'sleutelwoorde': <Table > {'ALL': <gluon.sql.SQLALL object at 0x995ed90>, '_referenced_by': [], > 'fields': ['id', 'sleutelwoord', 'artikel_id'], '_db': <SQLDB {...}>, > '_dbt': > 'applications/kbase/databases/c8b669d15150d7109e5f7ab36744a5b7_sleutelwoorde.table', > 'sleutelwoord': <gluon.sql.Field object at 0x995ec90>, '_tablename': > 'sleutelwoorde', '_format': None, '_logfilename': > 'applications/kbase/databases/sql.log', 'virtualfields': [], 'id': > <gluon.sql.Field object at 0x995ed50>, 'artikel_id': <gluon.sql.Field > object at 0x995ecd0>}>}> > > In[1]: > > print db.instansie > > Out[1]: > > instansie > > In[2]: > > print db.instansie.naam > > Out[2]: > > instansie.naam > > In[3]: > > for it in... > > read more » -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
