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.
