Hello All,
I am newbie to web2py framework. I have created one database
connection string to 'Mysql' as
prankester@Altocumulus: ~ master ⚡
$ bash cmdweb2py.sh
[17:21:35]
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")
>>>*#Creating a Table*
>>> db.define_table('User_info',
... Field('username',unique=True),
... Field('password',notnull=True),
... format='%(name)s',
... migrate=False)
<Table User_info (id,username,password)>
>>> db.User_info.insert(username='facebook',password='twitter')
*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.User_info' doesn't exist")*
I don't know what happened wrong
Please help me.
And I also want to know difference between
db=DAL(("mysql://root:root@localhost/test",*migrate_enabled=True*)
and db.define_table('person',Field('name'), *migrate=True*)
--
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
