you need to db.commit() after creating the table....
Il giorno mercoledì 10 luglio 2013 09:21:39 UTC+2, Prasad Muley ha scritto:
>
> 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.
