orm - django: no such table when not run with manage.py -
i'm trying create script use django orm tools. i'll have lightweight web interface well.
right now, when run:
python manage.py runserver i can go localhost , browse apps, add data, modify, etc. no problems. however, when create script following:
import sys import os sys.path.append('c:\\hg\eclipse_workspace\dj_mnh') os.environ["django_settings_module"] = "dj_mnh.settings" sen.models import deliveries table def process(): """ quick test """ d = table.objects.get(nve_filename='test') print d.nve_filetime print table.objects.all() if __name__ == "__main__": process() i following traceback below. have configured django project , works in same way no problems! can open sqlite database , see there data in there well... ideas on / how debug?
in [2]: run simple_nvd.py --------------------------------------------------------------------------- databaseerror traceback (most recent call last) c:\python27\lib\site-packages\ipython\utils\py3compat.pyc in execfile(fname, glo b, loc) 169 else: 170 filename = fname --> 171 exec compile(scripttext, filename, 'exec') in glob, loc 172 else: 173 def execfile(fname, *where): c:\voltest\test\simple_nvd.py in <module>() 28 29 if __name__ == "__main__": ---> 30 process() c:\voltest\test\simple_nvd.py in process(today) 19 # print table.objects.all() 20 ---> 21 d = table.objects.get(nve_filename='test') 22 print d.nve_filetime 23 print table.objects.all() c:\python27\lib\site-packages\django\db\models\manager.pyc in get(self, *args, * *kwargs) 129 130 def get(self, *args, **kwargs): --> 131 return self.get_query_set().get(*args, **kwargs) 132 133 def get_or_create(self, **kwargs): c:\python27\lib\site-packages\django\db\models\query.pyc in get(self, *args, **k wargs) 359 if self.query.can_filter(): 360 clone = clone.order_by() --> 361 num = len(clone) 362 if num == 1: 363 return clone._result_cache[0] c:\python27\lib\site-packages\django\db\models\query.pyc in __len__(self) 83 self._result_cache = list(self._iter) 84 else: ---> 85 self._result_cache = list(self.iterator()) 86 elif self._iter: 87 self._result_cache.extend(self._iter) c:\python27\lib\site-packages\django\db\models\query.pyc in iterator(self) 289 klass_info = get_klass_info(model, max_depth=max_depth, 290 requested=requested, only_load=o nly_load) --> 291 row in compiler.results_iter(): 292 if fill_cache: 293 obj, _ = get_cached_row(row, index_start, db, klass_info , c:\python27\lib\site-packages\django\db\models\sql\compiler.pyc in results_iter( self) 761 if self.query.select_for_update , transaction.is_managed(self. using): 762 transaction.set_dirty(self.using) --> 763 rows in self.execute_sql(multi): 764 row in rows: 765 if resolve_columns: c:\python27\lib\site-packages\django\db\models\sql\compiler.pyc in execute_sql(s elf, result_type) 816 817 cursor = self.connection.cursor() --> 818 cursor.execute(sql, params) 819 820 if not result_type: c:\python27\lib\site-packages\django\db\backends\util.pyc in execute(self, sql, params) 38 start = time() 39 try: ---> 40 return self.cursor.execute(sql, params) 41 finally: 42 stop = time() c:\python27\lib\site-packages\django\db\backends\sqlite3\base.pyc in execute(sel f, query, params) 342 query = self.convert_query(query) 343 try: --> 344 return database.cursor.execute(self, query, params) 345 except database.integrityerror, e: 346 raise utils.integrityerror, utils.integrityerror(*tuple(e)), sys.exc_info()[2] databaseerror: no such table: sen_deliveries
Comments
Post a Comment