I am new on web2py and i trying accesing a database existing:
In my db.py i have:
db=SQLDB('postgres://foo:[email protected]:5432/registros')
db.define_table('calls',
SQLField('account_id','integer'),
SQLField('uuid','string'),
SQLField('caller_id_number','string'),
SQLField('destination_number','string'),
SQLField('chan_name','string'),
SQLField('answered_time','datetime'),
SQLField('hangup_time','datetime'),
SQLField('cdr_xml','string'),
migrate=False)
In my Controller default.py:
def llamadas():
rows=db().select(db.calls.ALL)
return dict(form=form,rows=rows)
But i have the following error of accesing:
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
ProgrammingError: no existe la relación «calls»
I hope your comments,
Regards,
Fernando
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" 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
-~----------~----~----~----~------~----~------~--~---
