def test4():
print "4) Testing objects create / load cache / delete, 3 level, no files"
t = time.time()
a=db_app.app_db()
print time.time() - t, "Creating db (contains", db_app.statdb(a), "Entries)"
t2 = time.time()
r=a.root()
print time.time() - t2, "Creating root"
t2 = time.time()
c=r
ids=[]
n=0
c.useCache = True
for i in range(0,level1):
o=db_app.createObj1(r)
o.useCache = True
ids.append(o.id)
#print o.id
n+=1
for i2 in range(0,level2):
o2=db_app.createObj1(o)
o2.useCache = True
#print o2.id,
n+=1
for i3 in range(0,level3_1):
o3 = db_app.createObj1(o2)
o3.useCache = True
#print o3.id,
n+=1
for i3 in range(0,level3_2):
o3 = db_app.createObj2(o2)
o3.useCache = True
#print o3.id,
n+=1
print time.time() - t2, "Creating", n, "objects"
t2 = time.time()
o1 = r.GetObjs()
cc = len(o1)
for o in o1:
o2 = o.GetObjs()
cc+=len(o2)
for a in o2:
o3 = a.GetObjs()
cc+=len(o3)
print time.time() - t2, "Loading", cc, "objects"
t2 = time.time()
r.Close()
print time.time() - t2, "Closing", cc, "objects"
t2 = time.time()
user = User(u"test")
for id in ids:
try:
r.Delete(id, user=user)
except Exception, e:
raise Exception, str(ids)+ " " + str(id)
def setUp(self):
self._loadApp()
r=self.app.root()
# create three levels of entries
level1 = 5
level2 = 5
level3_1 = 5
level3_2 = 5
c=r
ids=[]
n=0
user = User(u"test")
for i in range(0,level1):
o=db_app.createObj1(c)
n+=1
ids.append(o.id)
for i2 in range(0,level2):
o2=db_app.createObj1(o)
n+=1
for i3 in range(0,level3_1):
db_app.createObj1(o2)
n+=1
for i3 in range(0,level3_2):
o4 = db_app.createObj2(o2)
id = o4.id
n+=1
self.ids = ids
self.lastid = id
def test3():
print "3) Testing objects create / load / load batch / delete, 3 level, no files"
t = time.time()
a=db_app.app_db()
print time.time() - t, "Creating db (contains", db_app.statdb(a), "Entries)"
t2 = time.time()
r=a.root()
print time.time() - t2, "Creating root"
t2 = time.time()
c=r
ids=[]
n=0
for i in range(0,level1):
o=db_app.createObj1(c)
n+=1
ids.append(o.id)
for i2 in range(0,level2):
o2=db_app.createObj1(o)
n+=1
for i3 in range(0,level3_1):
db_app.createObj1(o2)
n+=1
for i3 in range(0,level3_2):
db_app.createObj2(o2)
n+=1
print time.time() - t2, "Creating", n, "objects"
t2 = time.time()
del r
del a
a=db_app.app_db()
print time.time() - t2, "Creating db (contains", db_app.statdb(a), "Entries)"
t2 = time.time()
r=a.root()
print time.time() - t2, "Creating root"
t2 = time.time()
o1 = r.GetObjs(batch=True)
cc = len(o1)
for o in o1:
o2 = o.GetObjs(batch=True)
cc+=len(o2)
for a in o2:
o3 = a.GetObjs(batch=True)
cc+=len(o3)
print time.time() - t2, "Loading batch", cc, "objects"
t2 = time.time()
user = User(u"test")
for id in ids:
r.Delete(id, user=user)
print time.time() - t2, "Deleting objects recursively"
print "------------"
print time.time() - t, "Total. Finished (contains", db_app.statdb(a), "Entries)"
a.Close()
print "--------------------------------------------------------"
def setUp(self):
self._loadApp()
self.app.Register(configuration)
root = self.app.root()
self.o = o = db_app.createObj1(root)
db_app.createObj1(o)
db_app.createObj2(o)
db_app.createObj3(o)
def setUp(self):
self._loadApp()
self.app.Register(configuration)
root = self.app.root()
self.o = o = db_app.createObj1(root)
db_app.createObj1(o)
db_app.createObj2(o)
db_app.createObj3(o)
def test_toolobj(self):
user = User(u"test")
r = self.app.root()
o = db_app.createObj1(r)
t = o.GetTool("nive.tools.example")
r1,v = t()
self.assert_(r1)
r.Delete(o.GetID(), user=user)
def test1():
print "1) Testing objects create / delete, 3 level, no files"
t = time.time()
a = db_app.app_db()
print time.time() - t, "Creating db (contains", db_app.statdb(
a), "Entries)"
t2 = time.time()
r = a.root()
print time.time() - t2, "Creating root"
t2 = time.time()
c = r
ids = []
n = 0
user = User(u"test")
for i in range(0, level1):
o = db_app.createObj1(c)
n += 1
ids.append(o.id)
for i2 in range(0, level2):
o2 = db_app.createObj1(o)
n += 1
for i3 in range(0, level3_1):
db_app.createObj1(o2)
n += 1
for i3 in range(0, level3_2):
db_app.createObj2(o2)
n += 1
print time.time() - t2, "Creating", n, "objects"
t2 = time.time()
for id in ids:
r.Delete(id, user=user)
print time.time() - t2, "Deleting objects recursively"
print "------------"
print time.time() - t, "Total. Finished (contains", db_app.statdb(
a), "Entries)"
a.Close()
print "--------------------------------------------------------"
def test1():
print "1) Testing objects create / delete, 3 level, no files"
t = time.time()
a=db_app.app_db()
print time.time() - t, "Creating db (contains", db_app.statdb(a), "Entries)"
t2 = time.time()
r=a.root()
print time.time() - t2, "Creating root"
t2 = time.time()
c=r
ids=[]
n=0
user = User(u"test")
for i in range(0,level1):
o=db_app.createObj1(c)
n+=1
ids.append(o.id)
for i2 in range(0,level2):
o2=db_app.createObj1(o)
n+=1
for i3 in range(0,level3_1):
db_app.createObj1(o2)
n+=1
for i3 in range(0,level3_2):
db_app.createObj2(o2)
n+=1
print time.time() - t2, "Creating", n, "objects"
t2 = time.time()
for id in ids:
r.Delete(id, user=user)
print time.time() - t2, "Deleting objects recursively"
print "------------"
print time.time() - t, "Total. Finished (contains", db_app.statdb(a), "Entries)"
a.Close()
print "--------------------------------------------------------"
def setUp(self):
testing.setUp()
self.request = testing.DummyRequest()
self.request._LOCALE_ = "en"
self.request.subpath = ["file1.txt"]
self.request.context = None
self.app = db_app.app_db()
#self.request = getRequest()
user = User(u"test")
r = self.app.root()
self.context = db_app.createObj1(r)
self.context2 = db_app.createObj2(r)
self.context2.StoreFile("file1", db_app.file2_1, user=user)
self.context2.StoreFile("file2", db_app.file2_2, user=user)
def setUp(self):
testing.setUp()
self.request = testing.DummyRequest()
self.request._LOCALE_ = "en"
self.request.subpath = ["file1.txt"]
self.request.context = None
self.app = db_app.app_db()
# self.request = getRequest()
user = User(u"test")
r = self.app.root()
self.context = db_app.createObj1(r)
self.context2 = db_app.createObj2(r)
self.context2.StoreFile("file1", db_app.file2_1, user=user)
self.context2.StoreFile("file2", db_app.file2_2, user=user)
def setUp(self):
self.request = testing.DummyRequest()
self.config = testing.setUp(request=self.request)
self.config.include('pyramid_chameleon')
self.request._LOCALE_ = "en"
self.request.subpath = ["file1.txt"]
self.request.context = None
self.request.content_type = None
self._loadApp(["nive.adminview.view"])
self.app.Startup(self.config)
#self.request = getRequest()
user = User(u"test")
r = self.app.root()
self.context = db_app.createObj1(r)
self.context2 = db_app.createObj2(r)
self.context2.StoreFile("file1", db_app.file2_1, user=user)
self.context2.StoreFile("file2", db_app.file2_2, user=user)
def setUp(self):
self.request = testing.DummyRequest()
self.config = testing.setUp(request=self.request)
self.config.include('pyramid_chameleon')
self.request._LOCALE_ = "en"
self.request.subpath = ["file1.txt"]
self.request.context = None
self.request.content_type = None
self._loadApp(["nive.adminview.view"])
self.app.Startup(self.config)
#self.request = getRequest()
user = User(u"test")
r = self.app.root()
self.context = db_app.createObj1(r)
self.context2 = db_app.createObj2(r)
self.context2.StoreFile("file1", db_app.file2_1, user=user)
self.context2.StoreFile("file2", db_app.file2_2, user=user)
def test_database(self):
r = self.app.root()
o = db_app.createObj1(r)
self.assert_(o)
id = o.id
del o
self.assert_(self.app.obj(id, rootname = ""))
self.assert_(self.app.obj(id, rootname = "root"))
self.assert_(self.app.db)
self.assert_(self.app.GetDB())
self.assert_(self.app.db.connection.VerifyConnection())
self.assert_(len(self.app.Query("select id from pool_meta", values = [])))
ph = self.app.db.placeholder
self.assert_(len(self.app.Query("select id from pool_meta where pool_type="+ph, values = ["type1"])))
o=self.app.obj(id, rootname = "")
self.assert_(o)
self.app.Register("nive.components.tools.example")
self.assert_(self.app.GetTool("exampletool"))
user = User(u"test")
self.app.Close()
self.assertFalse(self.app.db.usedconnection.IsConnected())
# should reopen the connection
self.assert_(self.app.LookupObj(id))
self.app.root().Delete(id, user=user)
def test3():
print "3) Testing objects create / load / load batch / delete, 3 level, no files"
t = time.time()
a = db_app.app_db()
print time.time() - t, "Creating db (contains", db_app.statdb(
a), "Entries)"
t2 = time.time()
r = a.root()
print time.time() - t2, "Creating root"
t2 = time.time()
c = r
ids = []
n = 0
for i in range(0, level1):
o = db_app.createObj1(c)
n += 1
ids.append(o.id)
for i2 in range(0, level2):
o2 = db_app.createObj1(o)
n += 1
for i3 in range(0, level3_1):
db_app.createObj1(o2)
n += 1
for i3 in range(0, level3_2):
db_app.createObj2(o2)
n += 1
print time.time() - t2, "Creating", n, "objects"
t2 = time.time()
del r
del a
a = db_app.app_db()
print time.time() - t2, "Creating db (contains", db_app.statdb(
a), "Entries)"
t2 = time.time()
r = a.root()
print time.time() - t2, "Creating root"
t2 = time.time()
o1 = r.GetObjs(batch=True)
cc = len(o1)
for o in o1:
o2 = o.GetObjs(batch=True)
cc += len(o2)
for a in o2:
o3 = a.GetObjs(batch=True)
cc += len(o3)
print time.time() - t2, "Loading batch", cc, "objects"
t2 = time.time()
user = User(u"test")
for id in ids:
r.Delete(id, user=user)
print time.time() - t2, "Deleting objects recursively"
print "------------"
print time.time() - t, "Total. Finished (contains", db_app.statdb(
a), "Entries)"
a.Close()
print "--------------------------------------------------------"
def test5():
print "5) Testing objects create / close load cache / delete, 3 level, no files"
t = time.time()
a = db_app.app_db()
print time.time() - t, "Creating db (contains", db_app.statdb(
a), "Entries)"
t2 = time.time()
r = a.root()
print time.time() - t2, "Creating root"
t2 = time.time()
c = r
ids = []
n = 0
c.useCache = True
for i in range(0, level1):
o = db_app.createObj1(r)
o.useCache = True
ids.append(o.id)
#print o.id
n += 1
for i2 in range(0, level2):
o2 = db_app.createObj1(o)
o2.useCache = True
#print o2.id,
n += 1
for i3 in range(0, level3_1):
o3 = db_app.createObj1(o2)
o3.useCache = True
#print o3.id,
n += 1
for i3 in range(0, level3_2):
o3 = db_app.createObj2(o2)
o3.useCache = True
#print o3.id,
n += 1
print time.time() - t2, "Creating", n, "objects"
t2 = time.time()
r.Close()
print time.time() - t2, "Closing", n, "objects"
t2 = time.time()
r = a.root()
r.useCache = True
o1 = r.GetObjs()
cc = len(o1)
for o in o1:
o.useCache = True
o2 = o.GetObjs()
cc += len(o2)
for a in o2:
a.useCache = True
o3 = a.GetObjs()
cc += len(o3)
print time.time() - t2, "Loading after Close", cc, "objects"
t2 = time.time()
user = User(u"test")
for id in ids:
r.Delete(id, user=user)
#try:
# r.Delete(id)
#except Exception, e:
# raise Exception, str(ids)+ " " + str(id)
print time.time() - t2, "Deleting objects recursively"
print "------------"
print time.time() - t, "Total. Finished (contains", db_app.statdb(
a), "Entries)"
a.Close()
print "--------------------------------------------------------"
def test4():
print "4) Testing objects create / load cache / delete, 3 level, no files"
t = time.time()
a = db_app.app_db([DB_CONF])
print time.time() - t, "Creating db (contains", db_app.statdb(
a), "Entries)"
t2 = time.time()
r = a.root()
print time.time() - t2, "Creating root"
t2 = time.time()
c = r
ids = []
n = 0
c.useCache = True
for i in range(0, level1):
o = db_app.createObj1(r)
o.useCache = True
ids.append(o.id)
#print o.id
n += 1
for i2 in range(0, level2):
o2 = db_app.createObj1(o)
o2.useCache = True
#print o2.id,
n += 1
for i3 in range(0, level3_1):
o3 = db_app.createObj1(o2)
o3.useCache = True
#print o3.id,
n += 1
for i3 in range(0, level3_2):
o3 = db_app.createObj2(o2)
o3.useCache = True
#print o3.id,
n += 1
print time.time() - t2, "Creating", n, "objects"
t2 = time.time()
o1 = r.GetObjs()
cc = len(o1)
for o in o1:
o2 = o.GetObjs()
cc += len(o2)
for a in o2:
o3 = a.GetObjs()
cc += len(o3)
print time.time() - t2, "Loading", cc, "objects"
t2 = time.time()
r.Close()
print time.time() - t2, "Closing", cc, "objects"
t2 = time.time()
user = User(u"test")
for id in ids:
try:
r.Delete(id, user=user)
except Exception, e:
raise Exception, str(ids) + " " + str(id)
def setUp(self):
self._loadApp([mWfObj,mToolObj])
r = self.app.root()
o = db_app.createObj1(r)
self.oid = o.id
def test5():
print "5) Testing objects create / close load cache / delete, 3 level, no files"
t = time.time()
a=db_app.app_db([DB_CONF])
print time.time() - t, "Creating db (contains", db_app.statdb(a), "Entries)"
t2 = time.time()
r=a.root()
print time.time() - t2, "Creating root"
t2 = time.time()
c=r
ids=[]
n=0
c.useCache = True
for i in range(0,level1):
o=db_app.createObj1(r)
o.useCache = True
ids.append(o.id)
#print o.id
n+=1
for i2 in range(0,level2):
o2=db_app.createObj1(o)
o2.useCache = True
#print o2.id,
n+=1
for i3 in range(0,level3_1):
o3 = db_app.createObj1(o2)
o3.useCache = True
#print o3.id,
n+=1
for i3 in range(0,level3_2):
o3 = db_app.createObj2(o2)
o3.useCache = True
#print o3.id,
n+=1
print time.time() - t2, "Creating", n, "objects"
t2 = time.time()
r.Close()
print time.time() - t2, "Closing", n, "objects"
t2 = time.time()
r=a.root()
r.useCache = True
o1 = r.GetObjs()
cc = len(o1)
for o in o1:
o.useCache = True
o2 = o.GetObjs()
cc+=len(o2)
for a in o2:
a.useCache = True
o3 = a.GetObjs()
cc+=len(o3)
print time.time() - t2, "Loading after Close", cc, "objects"
t2 = time.time()
user = User(u"test")
for id in ids:
r.Delete(id, user=user)
#try:
# r.Delete(id)
#except Exception, e:
# raise Exception, str(ids)+ " " + str(id)
print time.time() - t2, "Deleting objects recursively"
print "------------"
print time.time() - t, "Total. Finished (contains", db_app.statdb(a), "Entries)"
a.Close()
print "--------------------------------------------------------"
def setUp(self):
self._loadApp([mWfObj, mToolObj])
r = self.app.root()
o = db_app.createObj1(r)
self.oid = o.id