def formats_db_load(dbname="test_ssloader"):
tblname = "formats"
hex2name = {}
for key,value in colors.attr_get_keyval(include_callable=False,include_baseattr=False):
hex2name[value] = key
formats_col_defn = [('name','text'),('fgcolor','text'), ('bgcolor','text'),
('__id','text'),('__timestamp','text')]
formats_col_names = [row[0] for row in formats_col_defn]
dbrows=[]
for name,bg in colorpalette.iteritems():
if fontpalette.has_key(name):
fg = fontpalette[name]
else:
fg = '#000000'
__id = IDGenerator().getid()
__timestamp = datetime.now().strftime("%H:%M:%S")
dbrows.append(["\""+name+"\"",
"\""+hex2name[fg]+"\"",
"\""+hex2name[bg]+"\"",
"\""+__id+"\"","\""+__timestamp+"\""])
database = Database(dbname)
with database:
if tbl_exists(database,tblname) == True:
tbl_remove(database,tblname)
tbl_create(database,tblname, formats_col_defn)
exec_str, result = tbl_rows_insert(database,tblname,formats_col_names,dbrows)
def color_db_load(dbname="test_ssloader"):
tblname = "colors"
colors_col_defn = [('name', 'text'), ('hex', 'text'), ('rgb', 'text'),
('__id', 'text'), ('__timestamp', 'text')]
colors_col_names = [row[0] for row in colors_col_defn]
dbrows = []
for key, value in colors.attr_get_keyval(include_callable=False,
include_baseattr=False):
rgb = hex2rgb(value)
rgbstr = ",".join(map(str, rgb))
__id = IDGenerator().getid()
__timestamp = datetime.now().strftime("%H:%M:%S")
dbrows.append([
"\"" + key + "\"", "\"" + value + "\"", "\"" + rgbstr + "\"",
"\"" + __id + "\"", "\"" + __timestamp + "\""
])
database = Database(dbname)
with database:
if tbl_exists(database, tblname) == True:
tbl_remove(database, tblname)
tbl_create(database, tblname, colors_col_defn)
exec_str, result = tbl_rows_insert(database, tblname, colors_col_names,
dbrows)
def color_db_load(dbname="test_ssloader"):
tblname = "colors"
colors_col_defn = [('name','text'),('hex','text'),('rgb','text'),('__id','text'),('__timestamp','text')]
colors_col_names = [row[0] for row in colors_col_defn]
dbrows=[]
for key,value in colors.attr_get_keyval(include_callable=False,include_baseattr=False):
rgb = hex2rgb(value)
rgbstr = ",".join(map(str,rgb))
__id = IDGenerator().getid()
__timestamp = datetime.now().strftime("%H:%M:%S")
dbrows.append(["\""+key+"\"","\""+value+"\"","\""+rgbstr+"\"",
"\""+__id+"\"","\""+__timestamp+"\""])
database = Database(dbname)
with database:
if tbl_exists(database,tblname) == True:
tbl_remove(database,tblname)
tbl_create(database,tblname, colors_col_defn)
exec_str, result = tbl_rows_insert(database,tblname,colors_col_names,dbrows)
def persist_ts_values(self, filename, tstype, row):
tablename = self.sourcevaluecolname + "_values"
col_defn = [("filename", "string"), ("min", "integer"),
("max", "integer"), ("avg", "integer")]
col_names = ["filename", "min", "max", "avg"]
row.insert(0, filename)
row = _quotestrs([row])
with self.database:
if tbl_exists(self.database, tablename) == False:
logmsg = "creating [" + tablename + "] in db [" + self.databasename + "]"
try:
tbl_create(self.database, tablename, col_defn)
except Exception, e:
log.log(PRIORITY.FAILURE,
msg=logmsg + " [" + e.message + "]")
else:
log.log(PRIORITY.SUCCESS, msg=logmsg)
logmsg = "inserting row [" + str(
row) + "] into table [" + tablename + "]"
try:
tbl_rows_insert(self.database, tablename, col_names, row)
except Exception, e:
log.log(PRIORITY.FAILURE, msg=logmsg + " [" + e.message + "]")
def _write_to_db(self, row, dname, tname, cdefn, cnames):
database = Database(dname)
with database:
if tbl_exists(database, tname) == False:
tbl_create(database, tname, cdefn)
tbl_rows_insert(database, tname, cnames, row)
def persist(self,createtable=True): self._metadata_set() if not tbl_exists(self.database,self.tbl_name) ==True: tbl_create(self.database, self.tbl_name, self.tbl_col_defn) result,exec_str = tbl_rows_insert(self.database, self.tbl_name, self.tbl_col_names, self.tbl_row_values) return(result,exec_str)
def persist(self,
f=None,
column_defn=[("id", "integer"), ("bucket", "integer"),
("watts", "integer"), ("hr", "integer"),
("filename", "text")],
column_names=["id", "bucket", "watts", "hr", "filename"]):
database = Database(self.databasename)
_rows = self.dump(f)
with database:
if tbl_exists(database, self.tablename) == False:
tbl_create(database, self.tablename, column_defn)
try:
tbl_rows_insert(database, self.tablename, column_names, _rows)
except Exception, e:
log.log(PRIORITY.FAILURE,
msg="timseries persistence failed in db [" +
database.name + "] [" + e.message + "]")
else:
def formats_db_load(dbname="test_ssloader"):
tblname = "formats"
hex2name = {}
for key, value in colors.attr_get_keyval(include_callable=False,
include_baseattr=False):
hex2name[value] = key
formats_col_defn = [('name', 'text'), ('fgcolor', 'text'),
('bgcolor', 'text'), ('__id', 'text'),
('__timestamp', 'text')]
formats_col_names = [row[0] for row in formats_col_defn]
dbrows = []
for name, bg in colorpalette.iteritems():
if fontpalette.has_key(name):
fg = fontpalette[name]
else:
fg = '#000000'
__id = IDGenerator().getid()
__timestamp = datetime.now().strftime("%H:%M:%S")
dbrows.append([
"\"" + name + "\"", "\"" + hex2name[fg] + "\"",
"\"" + hex2name[bg] + "\"", "\"" + __id + "\"",
"\"" + __timestamp + "\""
])
database = Database(dbname)
with database:
if tbl_exists(database, tblname) == True:
tbl_remove(database, tblname)
tbl_create(database, tblname, formats_col_defn)
exec_str, result = tbl_rows_insert(database, tblname,
formats_col_names, dbrows)
def test_tbl_exists_false(self):
database = Database(test_db.name,True)
with database:
self.assertFalse(tbl_exists(database,'foobar'))
def test_tbl_exists(self):
database = Database(test_db.name,True)
with database:
self.assertTrue(tbl_exists(database,'tbl_name_test'))
import sys
from os import remove
from database_util import Database, tbl_exists
from database_table_util import tbl_move
if len(sys.argv) <> 4:
print "usage: dbtblmove.py dbsource dbtarget tblname"
print
print "e.g. python ./dbtblmove.py fucia.sqlite quad.sqlite formats"
exit()
argvnames = ['dbsource', 'dbtarget', 'tblname']
args = dict(zip(argvnames, sys.argv[1:]))
dbtarget = Database(args['dbtarget'])
with dbtarget:
if tbl_exists(dbtarget, args['tblname']) == True:
print "table ", args['tblname'], " already exists in db ", args[
'dbtarget']
exit()
tbl_move(Database(args['dbsource']), Database(args['dbtarget']),
args['tblname'])
with dbtarget:
if tbl_exists(dbtarget, args['tblname']) == True:
print "table ", args['tblname'], " moved to db ", args['dbtarget']
import sys
from os import remove
from database_util import Database, tbl_exists
from database_table_util import tbl_move
if len(sys.argv) <> 4:
print "usage: dbtblmove.py dbsource dbtarget tblname"
print
print "e.g. python ./dbtblmove.py fucia.sqlite quad.sqlite formats"
exit()
argvnames = ['dbsource','dbtarget','tblname']
args = dict(zip(argvnames,sys.argv[1:]))
dbtarget = Database(args['dbtarget'])
with dbtarget:
if tbl_exists(dbtarget,args['tblname']) == True:
print "table ",args['tblname']," already exists in db ",args['dbtarget']
exit()
tbl_move(Database(args['dbsource']),
Database(args['dbtarget']),
args['tblname'])
with dbtarget:
if tbl_exists(dbtarget,args['tblname']) == True:
print "table ",args['tblname']," moved to db ",args['dbtarget']