Hi Terrence, Your db.py script has not run and this is why you get the no such table error. I believe that it should work if you run the following command:
python web2py.py -S <APPNAME> You will then get an interactive shell with the web2py environment and application loaded. Regards, Edwin On Monday, February 13, 2017 at 10:34:52 PM UTC+4, Terrence Brannon wrote: > > Hello, I created the following RDBMS schema in the file db.py > > from pydal import DAL, Field > from datetime import datetime > > db = DAL('sqlite://gridtrader.db') > > grid = db.define_table( > 'grid', > Field('market'), > Field('pickle', type='text'), > Field('timestamp', type='datetime', default=datetime.now) > ) > > # db.executesql('CREATE INDEX IF NOT EXISTS grid_market_idx ON grid > (market);') > > db.commit() > > And then I attempted to insert a record but got this error: > > $ python -i > Python 2.7.12 |Anaconda 4.2.0 (64-bit)| (default, Jun 29 2016, 11:07:13) > [MSC v.1500 64 bit (AMD64)] on win32 > Type "help", "copyright", "credits" or "license" for more information. > Anaconda is brought to you by Continuum Analytics. > Please check out: http://continuum.io/thanks and https://anaconda.org > >>> import db > >>> db.grid.insert(market='asdfasdf', pickle='asdfasfd') > Traceback (most recent call last): > File "<stdin>", line 1, in <module> > File > "C:\Users\supreme\install\Anaconda2\lib\site-packages\pydal\objects.py", > line 741, in insert > ret = self._db._adapter.insert(self, self._listify(fields)) > File > "C:\Users\supreme\install\Anaconda2\lib\site-packages\pydal\adapters\base.py", > > line 492, in insert > raise e > sqlite3.OperationalError: no such table: grid > >>> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.