def operate(self):
if base.operation.operate(self):
self.dbname = self.getSingleOption("name")
self.where = self.getSingleOption("where")
db = db_objects.db(self.dbname)
data = db.delete_tag(self.where)
errorMessage = data[0]
data = data[1]
if errorMessage == None:
if self.where == None:
print self.output_string("Delete all tag",
base.Colors.Purple, True)
else:
print self.output_string(
"Delete tag where (%s)" % (str(self.where)),
base.Colors.Purple, True)
pass
for row in data:
print "\t", self.output_string("[deleted] ",
base.Colors.Red, True),
print self.output_string(str(row[0]), base.Colors.Red,
False), ":",
print self.output_string(str(row[1]), base.Colors.Red,
False)
pass
pass
else:
self.error(errorMessage)
return False
def operate(self):
if base.operation.operate(self):
self.dbname = self.getSingleOption("name")
self.detail = self.getSingleOption("detail")
db = db_objects.db(self.dbname)
if not db.exists():
self.error("Benchmark data does not exist.")
self.error("\tLooking for '%s'."%(db.name))
return False
fromTable = "sqlite_master"
where = "type = 'table'"
select = "*"
(errorMessage,data) = db.raw_query(select,fromTable,where)
print self.output_string("Table names",base.Colors.Purple,True)
if errorMessage == None:
data = data[1]
for i in data:
if self.detail:
print "\n\t",self.output_string(str(i[1]),base.Colors.Blue,False)
statement = i[4]
start_index = statement.find("(")
statement = statement[start_index+1:len(statement)-1]
members = statement.split(",")
for m in members:
print "\t\t",self.output_string(str(m),base.Colors.Cyan,False)
else:
print "\t",self.output_string(str(i[1]),base.Colors.Blue,False)
else:
self.error(errorMessage)
pass
return False
def operate(self):
if base.operation.operate(self):
self.dbname = self.getSingleOption("name")
self.location = self.getSingleOption("location")
self.db = db_objects.db(self.dbname)
db_report = db_objects.db_report.db_report(self.db)
return db_report.report(self, self.location)
return False
def setup(self):
self.db = db_objects.db(self.dbname)
self.db.create_database()
self.suite_name = "."
if self.arguments and len(self.arguments):
self.suite_name = self.arguments[0]
self.suite_name = os.path.abspath(self.suite_name)
self.suite_info = self.__read_suite_info__(self.suite_name,True)
if self.suite_info:
root_suite = self.__find_parent__(self.suite_info)
if root_suite:
if self.__update_suite_info_database__(root_suite):
return self.__update_case_database__(self.suite_info)
return (None,None)
def __init__(self):
runnable.operation.__init__(self)
self.add_argument("engine","str","ig","engine (ig)")
self.add_argument("page_size","eval",14,"page size page_size=pow(2,value) valid_values=[10,11,12,13,14,15,16]")
self.add_argument("diskmap",int,None,"disk map variable (for config).")
self.add_argument("hostmap","str",None,"host map variable (for config) [remote | local].")
self.config = config.ig.Config
self.rootResultsPath = os.path.abspath("results")
self.version = None
self.engine = "ig"
self.propertyFile = ig_property.PropertyFile("ig.properties")
self.db = db_objects.db()
self.db.create_database()
self.diskmap = None
self.hostmap = None
pass
def operate(self):
if base.operation.operate(self):
self.dbname = self.getSingleOption("name")
self.select = self.getSingleOption("select")
self.fromTable = self.getSingleOption("from")
self.where = self.getSingleOption("where")
db = db_objects.db(self.dbname)
print self.output_string("Query results", base.Colors.Purple, True)
(errorMessage, data) = db.raw_query(self.select, self.fromTable,
self.where)
if errorMessage == None:
description = data[0]
data = data[1]
counter = len(description)
print "\n--"
for d in description:
print self.output_string(d[0], base.Colors.Blue, True),
if counter > 1:
print "|",
pass
counter -= 1
pass
print "\n--"
for row in data:
counter = len(row)
for item in row:
if (type(item)
== types.StringType) or (type(item)
== types.UnicodeType):
print self.output_string('"%s"' % (item),
base.Colors.Blue, False),
else:
print self.output_string(item, base.Colors.Blue,
False),
pass
if counter > 1:
print "|",
pass
counter -= 1
pass
print
print "--\n"
pass
else:
self.error(errorMessage)
pass
return False
def operate(self):
if base.operation.operate(self):
self.dbname = self.getSingleOption("name")
self.select = self.getSingleOption("select")
self.fromTable = self.getSingleOption("from")
self.where = self.getSingleOption("where")
db = db_objects.db(self.dbname)
print self.output_string("Query results",base.Colors.Purple,True)
(errorMessage,data) = db.raw_query(self.select,self.fromTable,self.where)
if errorMessage == None:
description = data[0]
data = data[1]
counter = len(description)
print "\n--"
for d in description:
print self.output_string(d[0],base.Colors.Blue,True),
if counter > 1:
print "|",
pass
counter -= 1
pass
print "\n--"
for row in data:
counter = len(row)
for item in row:
if (type(item) == types.StringType) or (type(item) == types.UnicodeType):
print self.output_string('"%s"'%(item),base.Colors.Blue,False),
else:
print self.output_string(item,base.Colors.Blue,False),
pass
if counter > 1:
print "|",
pass
counter -= 1
pass
print
print "--\n"
pass
else:
self.error(errorMessage)
pass
return False
def __init__(self):
runnable.operation.__init__(self)
self.add_argument("engine", "str", "ig", "engine (ig)")
self.add_argument(
"page_size", "eval", 14,
"page size page_size=pow(2,value) valid_values=[10,11,12,13,14,15,16]"
)
self.add_argument("diskmap", int, None,
"disk map variable (for config).")
self.add_argument("hostmap", "str", None,
"host map variable (for config) [remote | local].")
self.config = config.ig.Config
self.rootResultsPath = os.path.abspath("results")
self.version = None
self.engine = "ig"
self.propertyFile = ig_property.PropertyFile("ig.properties")
self.db = db_objects.db()
self.db.create_database()
self.diskmap = None
self.hostmap = None
pass
def operate(self):
if base.operation.operate(self):
self.dbname = self.getSingleOption("name")
self.where = self.getSingleOption("where")
db = db_objects.db(self.dbname)
data = db.delete_tag(self.where)
errorMessage = data[0]
data = data[1]
if errorMessage == None:
if self.where == None:
print self.output_string("Delete all tag",base.Colors.Purple,True)
else:
print self.output_string("Delete tag where (%s)"%(str(self.where)),base.Colors.Purple,True)
pass
for row in data:
print "\t",self.output_string("[deleted] ",base.Colors.Red,True),
print self.output_string(str(row[0]),base.Colors.Red,False),":",
print self.output_string(str(row[1]),base.Colors.Red,False)
pass
pass
else:
self.error(errorMessage)
return False
def operate(self):
if base.operation.operate(self):
self.dbname = self.getSingleOption("name")
self.detail = self.getSingleOption("detail")
db = db_objects.db(self.dbname)
if not db.exists():
self.error("Benchmark data does not exist.")
self.error("\tLooking for '%s'." % (db.name))
return False
fromTable = "sqlite_master"
where = "type = 'table'"
select = "*"
(errorMessage, data) = db.raw_query(select, fromTable, where)
print self.output_string("Table names", base.Colors.Purple, True)
if errorMessage == None:
data = data[1]
for i in data:
if self.detail:
print "\n\t", self.output_string(
str(i[1]), base.Colors.Blue, False)
statement = i[4]
start_index = statement.find("(")
statement = statement[start_index + 1:len(statement) -
1]
members = statement.split(",")
for m in members:
print "\t\t", self.output_string(
str(m), base.Colors.Cyan, False)
else:
print "\t", self.output_string(str(i[1]),
base.Colors.Blue, False)
else:
self.error(errorMessage)
pass
return False
