def __init__(self, path = None, isInit = False, isReset = False): self.isInit = isInit self.isReset = isReset if path is not None: self.db = DAL(ITM_DB.CONNECTION, lazy_tables = not self.isInit, migrate = self.isInit, folder = path) else: self.db = DAL(ITM_DB.CONNECTION, lazy_tables = not self.isInit, migrate = self.isInit)
def __init__(self, path=None, isInit=False):
self.isInit = isInit
if path is not None:
self.db = DAL(BOW_DB.CONNECTION,
lazy_tables=not self.isInit,
migrate_enabled=self.isInit,
folder=path)
else:
self.db = DAL(BOW_DB.CONNECTION,
lazy_tables=not self.isInit,
migrate_enabled=self.isInit)
def __init__(self, path=None, isInit=False, isImport=False, isReset=False):
self.isInit = isInit
self.isImport = isImport
self.isReset = isReset
isInitOrImport = self.isInit or self.isImport
if path is not None:
self.db = DAL(Corpus_DB.CONNECTION,
lazy_tables=not isInitOrImport,
migrate_enabled=isInitOrImport,
folder=path)
else:
self.db = DAL(Corpus_DB.CONNECTION,
lazy_tables=not isInitOrImport,
migrate_enabled=isInitOrImport)
def setUp(self):
db_username_postgres = 'postgres'
db_password_postgres = '1234'
db_postgres_url = 'postgres://' + db_username_postgres + ':' + db_password_postgres + '@localhost/dev'
path_to_database = path.join(path.curdir, "../databases")
self.db_test = DAL(db_postgres_url, folder=path_to_database)
self.db_test.import_table_definitions(path_to_database)
def copy_db(env, db_name='db', db_link='sqlite:memory:'):
try:
from gluon.sql import DAL
except ImportError:
raise ImportError("""
No module named `gluon`, unable to find `sql.DAL`
Make sure you have the correct URI that is the main web2py directory.
This should include your `applications` and `gluon` directories.""")
test_db = DAL(db_link)
for tablename in env[db_name].tables:
table_copy = [copy(f) for f in env[db_name][tablename]]
test_db.define_table(tablename, *table_copy, migrate=True)
return test_db
http://www.nervatura.com
Copyright © 2011-2015, Csaba Kappel
License: LGPLv3
http://www.nervatura.com/nerva2py/default/licenses
"""
if 0:
from gluon.globals import Session
global session
session = Session()
global request
request = globals.Request()
import gluon.languages.translator as T
from gluon.sql import DAL
global db
db = DAL()
global response
response = globals.Response()
import pyamf
from pyamf.flex import ArrayCollection
from gluon.tools import Service
from nerva2py.nervastore import NervaStore
from nerva2py.tools import NervaTools
from nerva2py.npi import Npi
import nerva2py.models
if request.env.http_origin:
response.headers['Access-Control-Allow-Origin'] = request.env.http_origin
else:
""" This file is part of the Nervatura Framework http://www.nervatura.com Copyright © 2011-2015, Csaba Kappel License: LGPLv3 http://www.nervatura.com/nerva2py/default/licenses """ if 0: global request; request = globals.Request() from gluon.globals import Session global session; session = Session() global response; response = globals.Response() import gluon.languages.translator as T from gluon.sql import DAL global db; db = DAL() from gluon.html import URL from nerva2py.nervastore import NervaStore from gluon.html import TABLE, TR, TD from gluon.sqlhtml import SPAN, A #postgres://username:password@localhost/database #mysql://username:password@localhost/database #sqlite://database.db conStr="sqlite://demo.db" ns = NervaStore(request, session, T, None) ns.engine = "sqlite" ns.connect.setConnect(uri=conStr, pool_size=0, createdb=False) if ns.db:
from gluon.sql import DAL
from gluon.sql import Field
from gluon.sql import SQLDB
from gluon.sqlhtml import SQLFORM
from gluon.validators import *
from gluon import fileutils
from gluon.http import *
from gluon.sqlhtml import *
from gluon.tools import fetch
import datetime
from datetime import timedelta
from datetime import date #
configuration = AppConfig()
db = DAL('sqlite://storage.sqlite')
MIGRATE_SETTING = False
db.define_table("admins",
Field("administrator"),
Field("admin_key", "password"),
migrate=MIGRATE_SETTING)
db.define_table("id_refs",
Field("classroom_id_ref", default="0"),
Field("quiz_id_ref", default="0"),
Field("quiz_question_id_ref", default="0"),
Field("student_id_ref", default="0"),
Field("teacher_id_ref", default="0"),
migrate=MIGRATE_SETTING)
db.define_table("teachers",
current.cache = cache = None
current.T = T = None
def initVars():
global current, request, response, session, cache, T
current.request = request = Request()
current.response = response = Response()
current.session = session = Session()
current.cache = cache = Cache(request)
current.T = T = m__T__
initVars()
deleteDB()
db = DAL('sqlite://'+DB_PATH)
import gluon.tools as gt
from mock import Mock
gt.URL=Mock(side_effect=m__URL__)
crud = gt.Crud(db)
# # Alguns imports globais do web2py
# # Ja feitos
response.google_analytics_id = None
if not request.env.web2py_runtime_gae:
request.data_folder = None
if os.path.isdir(os.path.join('..', '..', 'data')):
request.data_folder = os.path.join('..', '..', 'data')
elif os.path.isdir(os.path.join('..', '..', 'databases')):
request.data_folder = os.path.join('..', '..', 'databases')
elif os.path.isdir(os.path.join('..', 'data')):
request.data_folder = os.path.join('..', 'data')
elif os.path.isdir(os.path.join('..', 'databases')):
request.data_folder = os.path.join('..', 'databases')
ename = "sqlite"
db = DAL('sqlite://storage.sqlite',
migrate=False,
fake_migrate=False,
folder=request.data_folder)
session_db = DAL('sqlite://session.sqlite', folder=request.data_folder)
session.connect(request, response, db=session_db)
reload(sys)
sys.setdefaultencoding("utf-8") #@UndefinedVariable
else:
ename = "google_datastore"
#db = DAL('google:datastore://storage', migrate=False, fake_migrate=False)
db = DAL('google:datastore',
adapter_args={
'ndb_settings': None,
'use_ndb': False
})
session.connect(request, response, db=db)
#from gluon.contrib.memdb import MEMDB
