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