Hello all,
I have created one table called 'Programmer'. Table creation
is done successfully but whenever I tried to insert data it shows me errors
'test.Programmer' doesn't exist. I have done in following way.
prankester@Altocumulus: ~ master ⚡
$ bash cmdweb2py.sh [12:37:21]
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2013
Version 2.6.0-development+timestamp.2013.07.03.01.52.44
Database drivers available: SQLite(sqlite3), MySQL(pymysql),
MySQL(MySQLdb), PostgreSQL(pg8000), IMAP(imaplib)
WARNING:web2py:import IPython error; use default python shell
Python 2.7.3 (default, Apr 10 2013, 05:46:21)
[GCC 4.6.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> db=DAL("mysql://root:root@localhost/test")
>>> db.define_table('Programmer',
... Field('username',type='string',length=100,unique=True),
... Field('password',type='password',notnull=True),
... Field('level',notnull=True),
... format='%(username)s',
... migrate=False)
<Table Programmer (id,username,password,level)>
>>> db.Programmer.username #table created successfully
<gluon.dal.Field object at 0x8c17fac>
>>>
db.Programmer.insert(username="Prasad",password="web2py",level="Beginner")
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "/home/prankester/web2py-master/gluon/dal.py", line 8579, in insert
ret = self._db._adapter.insert(self, self._listify(fields))
File "/home/prankester/web2py-master/gluon/dal.py", line 1209, in insert
raise e
ProgrammingError: (1146, "Table 'test.Programmer' doesn't exist")
>>>#what's going on wrong
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
