import sys
import os
from gumby.settings import loadConfig
from gumby.spectraperf.performanceprofile import SessionHelper
if __name__ == '__main__':
if len(sys.argv) < 5:
print "Usage: python store_run_in_database.py configFile csvPath revision testcase"
sys.exit(0)
config = loadConfig(os.path.abspath(sys.argv[1]))
# DATABASE = os.path.abspath("../database/performance.db")
print "Setting database: %s " % config['spectraperf_db_path']
DATABASE = os.path.abspath(config['spectraperf_db_path'])
csvPath = sys.argv[2]
revision = sys.argv[3]
testcase = sys.argv[4]
if not os.path.isfile(csvPath):
print "Not a valid CSV file"
sys.exit(0)
helper = SessionHelper(config)
sess1 = helper.loadSessionFromCSV(revision, testcase, csvPath)
helper.appendData(sess1, csvPath.replace("summary_per_stacktrace.csv", "summary.txt"))
helper.storeInDatabase(sess1)
print "Run stored"
if p != -1:
output = ""
matrix = ActivityMatrix(p.getDatabaseId(), 5, Type.BYTESWRITTEN, rev, testcase)
for i in range(1, 6):
helper = SessionHelper(config)
csv = "%s/report_%s_%d/summary_per_stacktrace.csv" % (csvPath, rev, i)
csvExtra = "%s/report_%s_%d/summary.txt" % (csvPath, rev, i)
if not os.path.isfile(csv):
print "Not a valid CSV file: %s" % csv
continue
sess = helper.loadSessionFromCSV(rev, testcase, csv)
sess.isTestRun = 1
helper.appendData(sess, csvExtra)
helper.storeInDatabase(sess)
fits = p.fitsProfile(sess)
sim = p.similarity(fits)
metricValue = p.similarity(fits)
matrix.addFitsVector(fits)
helper.storeMetricInDatabase(sess, metricValue)
output += "------------------------\n%s\n" % csv
output += "Metric: cosine sim, value: %f\n" % metricValue.value
# print output
matrix.calcSimilarity()
helper = MatrixHelper(config)
import os
from gumby.settings import loadConfig
from gumby.spectraperf.performanceprofile import SessionHelper
if __name__ == '__main__':
if len(sys.argv) < 5:
print "Usage: python store_run_in_database.py configFile csvPath revision testcase"
sys.exit(0)
config = loadConfig(os.path.abspath(sys.argv[1]))
# DATABASE = os.path.abspath("../database/performance.db")
print "Setting database: %s " % config['spectraperf_db_path']
DATABASE = os.path.abspath(config['spectraperf_db_path'])
csvPath = sys.argv[2]
revision = sys.argv[3]
testcase = sys.argv[4]
if not os.path.isfile(csvPath):
print "Not a valid CSV file"
sys.exit(0)
helper = SessionHelper(config)
sess1 = helper.loadSessionFromCSV(revision, testcase, csvPath)
helper.appendData(
sess1, csvPath.replace("summary_per_stacktrace.csv", "summary.txt"))
helper.storeInDatabase(sess1)
print "Run stored"
