def saveSQLiteServiceConfig(json):
servicename = "masar"
servicedesc = 'machine snapshot, archiving, and retrieve service'
__sqlitedb__ = os.environ["MASAR_SQLITE_DB"]
with masarsqlite.connect(__sqlitedb__) as conn:
saveService(conn, servicename, desc=servicedesc)
for conf in json['configs']:
try:
saveServiceConfig(conn,
servicename,
conf['config_name'],
system=conf['system'],
status='active',
configdesc=conf['config_desc'])
except: # TODO: This should be more specific
print("configuration name (%s) exists already." %
(conf['config_name']))
for conf in json['pvg2config']:
try:
saveServicePvGroup(conn, conf['config_name'], conf['pvgroups'])
except:
print "Service config " + str(
conf['config_name']
) + " already has associated pvgroups: " + str(
conf['pvgroups'])
conn.commit()
def SQLITE_DB_TEST_SETUP():
# DB SETUP
__sqlitedb__ = os.environ["MASAR_SQLITE_DB"]
try:
conn = sqlite3.connect(__sqlitedb__)
cur = conn.cursor()
__sql__ = None
if __sql__ is None:
from pymasarsqlite.db.masarsqlite import SQL
else:
sqlfile = open(__sql__)
SQL = sqlfile.read()
if SQL is None:
print('SQLite script is empty. Cannot create SQLite db.')
raise IOError('SQLite script is empty. Cannot create SQLite db.')
else:
cur.executescript(SQL)
cur.execute("PRAGMA main.page_size= 4096;")
cur.execute("PRAGMA main.default_cache_size= 10000;")
cur.execute("PRAGMA main.locking_mode=EXCLUSIVE;")
cur.execute("PRAGMA main.synchronous=NORMAL;")
cur.execute("PRAGMA main.journal_mode=WAL;")
cur.execute("PRAGMA main.temp_store = MEMORY;")
cur.execute('select name from sqlite_master where type=\'table\'')
masarconf = 'SR_All_20140421'
servicename = 'masar'
pvgname = 'masarpvgroup'
pvgdesc = 'this is my new pv group for masar service with same group name'
pvs = [
"masarExample0000", "masarExample0001", "masarExampleBoUninit",
"masarExampleMbboUninit", "masarExample0002", "masarExample0003",
"masarExample0004", "masarExampleCharArray",
"masarExampleShortArray", "masarExampleLongArray",
"masarExampleStringArray", "masarExampleFloatArray",
"masarExampleDoubleArray", "masarExampleMbboUninitTest"
]
res = savePvGroup(conn, pvgname, func=pvgdesc)
res = saveGroupPvs(conn, pvgname, pvs)
pvgroups = retrievePvGroups(conn)
saveService(conn, servicename, desc='test desc')
saveServiceConfig(conn,
servicename,
masarconf,
system='SR',
status='active',
configversion=20140420,
configdesc='test desc')
res = saveServicePvGroup(conn, masarconf, [pvgname])
pvlist = retrieveServiceConfigPVs(conn,
masarconf,
servicename=servicename)
results = retrieveServiceConfigs(conn, servicename, masarconf)
conn.commit()
conn.close()
except sqlite3.Error, e:
print("Error %s:" % e.args[0])
raise
def SQLITE_DB_TEST_SETUP():
# DB SETUP
__sqlitedb__ = os.environ["MASAR_SQLITE_DB"]
try:
conn = sqlite3.connect(__sqlitedb__)
cur = conn.cursor()
__sql__ = None
if __sql__ is None:
from pymasarsqlite.db.masarsqlite import SQL
else:
sqlfile = open(__sql__)
SQL = sqlfile.read()
if SQL is None:
print ('SQLite script is empty. Cannot create SQLite db.')
raise IOError('SQLite script is empty. Cannot create SQLite db.')
else:
cur.executescript(SQL)
cur.execute("PRAGMA main.page_size= 4096;")
cur.execute("PRAGMA main.default_cache_size= 10000;")
cur.execute("PRAGMA main.locking_mode=EXCLUSIVE;")
cur.execute("PRAGMA main.synchronous=NORMAL;")
cur.execute("PRAGMA main.journal_mode=WAL;")
cur.execute("PRAGMA main.temp_store = MEMORY;")
cur.execute('select name from sqlite_master where type=\'table\'')
masarconf = 'SR_All_20140421'
servicename = 'masar'
pvgname = 'masarpvgroup'
pvgdesc = 'this is my new pv group for masar service with same group name'
pvs = ["masarExample0000",
"masarExample0001",
"masarExampleBoUninit",
"masarExampleMbboUninit",
"masarExample0002",
"masarExample0003",
"masarExample0004",
"masarExampleCharArray",
"masarExampleShortArray",
"masarExampleLongArray",
"masarExampleStringArray",
"masarExampleFloatArray",
"masarExampleDoubleArray",
"masarExampleMbboUninitTest"]
res = savePvGroup(conn, pvgname, func=pvgdesc)
res = saveGroupPvs(conn, pvgname, pvs)
pvgroups = retrievePvGroups(conn)
saveService(conn, servicename, desc='test desc')
saveServiceConfig(conn, servicename, masarconf, system='SR', status='active',
configversion=20140420, configdesc='test desc')
res = saveServicePvGroup(conn, masarconf, [pvgname])
pvlist = retrieveServiceConfigPVs(conn, masarconf, servicename=servicename)
results = retrieveServiceConfigs(conn, servicename, masarconf)
conn.commit()
conn.close()
except sqlite3.Error, e:
print ("Error %s:" % e.args[0])
raise
def createMasarDb():
noOverwrite = False
if os.path.exists(__sqlitedb__):
if os.path.isfile(__sqlitedb__):
print ("""SQLite database {0} exists already.""".format(__sqlitedb__))
if sys.version_info[:2] > (3,0):
answer = input ('Do you want to overwrite it? Yes, [N]o (default = No):')
else:
answer = raw_input('Do you want to overwrite it? Yes, [N]o (default = No):')
noOverwrite = checkAnswer(answer)
else:
print ("""SQLite database name {0} already exists as a directory.""".format(__sqlitedb__))
sys.exit()
if noOverwrite:
print ("Not going to overwrite existing SQLite db.")
sys.exit()
else:
print ("create a new SQLite db: %s."%(__sqlitedb__))
conn = None
sqlfile = None
os.environ["MASAR_SQLITE_DB"] = __sqlitedb__
try:
if __sql__ is None:
from pymasarsqlite.db.masarsqlite import SQL
else:
sqlfile = open(__sql__)
SQL = sqlfile.read()
if SQL is None:
print ('SQLite script is empty. Cannot create SQLite db.')
sys.exit()
else:
conn = sqlite3.connect(__sqlitedb__)
cur = conn.cursor()
cur.executescript(SQL)
cur.execute("PRAGMA main.page_size= 4096;")
cur.execute("PRAGMA main.default_cache_size= 10000;")
cur.execute("PRAGMA main.locking_mode=EXCLUSIVE;")
cur.execute("PRAGMA main.synchronous=NORMAL;")
cur.execute("PRAGMA main.journal_mode=WAL;")
cur.execute("PRAGMA main.temp_store = MEMORY;")
from pymasarsqlite.service.service import (saveService)
saveService(conn, 'masar', desc='machine snapshot, archiving, and retrieve service')
except sqlite3.Error, e:
print ("Error %s:" % e.args[0])
sys.exit(1)
def saveSQLiteServiceConfig(json):
servicename = "masar"
servicedesc = 'machine snapshot, archiving, and retrieve service'
__sqlitedb__ = os.environ["MASAR_SQLITE_DB"]
with sqlite3.connect(__sqlitedb__) as conn:
saveService(conn, servicename, desc=servicedesc)
for conf in json['configs']:
try:
saveServiceConfig(conn, servicename, conf['config_name'], system=conf['system'], status='active', configdesc=conf['config_desc'])
except: # TODO: This should be more specific
print ("configuration name (%s) exists already." % (conf['config_name']))
for conf in json['pvg2config']:
try:
saveServicePvGroup(conn, conf['config_name'], conf['pvgroups'])
except:
print "Service config " + str(conf['config_name']) + " already has associated pvgroups: " + str(conf['pvgroups'])
conn.commit()
def testMultiGroup(self):
# DB SETUP
__sqlitedb__ = os.environ["MASAR_SQLITE_DB"]
try:
conn = sqlite3.connect(__sqlitedb__)
pvgname1 = 'masarpvgroup1'
pvgdesc1 = 'this is my new pv group for masar service with same group name'
pvs1 = ["masarExample0000",
"masarExample0001",
"masarExampleBoUninit",
"masarExampleMbboUninit",
"masarExample0002",
"masarExample0003",
"masarExampleFloatArray",
"masarExample0004"]
res1 = savePvGroup(conn, pvgname1, func=pvgdesc1)
res1 = saveGroupPvs(conn, pvgname1, pvs1)
pvgname2 = 'masarpvgroup2'
pvgdesc2 = 'this is my new pv group for masar service with same group name'
pvs2 = ["masarExample0000",
"masarExample0001",
"masarExample0002",
"masarExample0004",
"masarExampleCharArray",
"masarExampleShortArray",
"masarExampleLongArray",
"masarExampleStringArray",
"masarExampleFloatArray",
"masarExampleDoubleArray",
"masarExampleMbboUninitTest"]
res2 = savePvGroup(conn, pvgname2, func=pvgdesc2)
res2 = saveGroupPvs(conn, pvgname2, pvs2)
pvgroups = retrievePvGroups(conn)
self.assertEqual(pvgroups[0][1], "masarpvgroup")
self.assertEqual(pvgroups[1][1], "masarpvgroup1")
self.assertEqual(pvgroups[2][1], "masarpvgroup2")
pvgroups = retrieveGroupPvs(conn, 2)
self.assertEqual(pvgroups[0][0], "masarExample0000")
self.assertEqual(pvgroups[1][0], "masarExample0001")
self.assertEqual(pvgroups[2][0], "masarExampleBoUninit")
self.assertEqual(pvgroups[3][0], "masarExampleMbboUninit")
self.assertEqual(pvgroups[4][0], "masarExample0002")
self.assertEqual(pvgroups[5][0], "masarExample0003")
self.assertEqual(pvgroups[6][0], "masarExample0004")
self.assertEqual(pvgroups[7][0], "masarExampleFloatArray")
pvgroups = retrieveGroupPvs(conn, 3)
self.assertEqual(pvgroups[0][0], "masarExample0000")
self.assertEqual(pvgroups[1][0], "masarExample0001")
self.assertEqual(pvgroups[2][0], "masarExample0002")
self.assertEqual(pvgroups[3][0], "masarExample0004")
self.assertEqual(pvgroups[4][0], "masarExampleCharArray")
self.assertEqual(pvgroups[5][0], "masarExampleShortArray")
self.assertEqual(pvgroups[6][0], "masarExampleLongArray")
self.assertEqual(pvgroups[7][0], "masarExampleStringArray")
self.assertEqual(pvgroups[8][0], "masarExampleFloatArray")
self.assertEqual(pvgroups[9][0], "masarExampleDoubleArray")
self.assertEqual(pvgroups[10][0], "masarExampleMbboUninitTest")
servicename = "masar"
masarconf = "testconf"
saveService(conn, servicename, desc='test desc')
saveServiceConfig(conn, servicename, masarconf, system='SR', status='active',
configversion=20140420, configdesc='test desc')
res = saveServicePvGroup(conn, masarconf, [pvgname1, pvgname2])
conn.commit()
conn.close()
except:
raise
save_params = {'configname': 'testconf',
'servicename': 'masar'}
res1 = self.mc.saveSnapshot(save_params)
self.assertNotEqual(res1, None)
self.assertNotEqual(res1, False)
event_id = res1[0]
retrieve_params = {'eventid': str(event_id)}
result = self.mc.retrieveSnapshot(retrieve_params)
self.assertNotEqual(result, None)
self.assertNotEqual(result, False)
expected_results = (('masarExample0000', # ChannelName 0
'masarExample0001', # ChannelName 1
'masarExampleBoUninit', # ChannelName 2
'masarExampleMbboUninit', # ChannelName 3
'masarExample0002', # ChannelName 4
'masarExample0003', # ChannelName 5
'masarExample0004', # ChannelName 6
'masarExampleCharArray', # ChannelName 7
'masarExampleShortArray', # ChannelName 8
'masarExampleLongArray', # ChannelName 9
'masarExampleStringArray', # ChannelName 10
'masarExampleFloatArray', # ChannelName 11
'masarExampleDoubleArray', # ChannelName 12
'masarExampleMbboUninitTest'), # ChannelName 13
(10, # 0000 Value
'string value', # 0001 Value
'0', # BoUninit Value (appropriately returned as string,
1, # MbboUninit Value
'zero', # 0002 Value
'one', # 0003 Value
1.9, # 0004 Value
(), # CharArray Value
(), # ShortArray Value
(), # LongArray Value
(), # StringArray Value
(), # FloatArrayValue
(), # DoubleArray Value
1), # MbboUninitTest Value
(5, 0, 0, 5, 0, 0, 6, 4, 1, 5, 0, 2, 6, 5), # DBR type
(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1), # isConnected
(631152000, 631152000, 631152000, 631152000, 631152000, 631152000, 631152000, 631152000, 631152000, 631152000,
631152000, 631152000, 631152000, 631152000), # SecondsPastEpoch
(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), # NanoSeconds
(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), # UserTag
(0, 0, 3, 0, 3, 0, 0, 3, 3, 3, 3, 3, 3, 0), # Severity
(3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3), # Status
('UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM',
'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM')) # Message
self.assertSequenceEqual(result, expected_results)
def initService():
saveService(conn,
'masar',
desc='machine snapshot, archiving, and retrieve service')
saveService(conn, 'archive', desc='machine archiving service')
def testSaveSQLiteServiceConfigs(self):
# DB SETUP
__sqlitedb__ = os.environ["MASAR_SQLITE_DB"]
try:
conn = sqlite3.connect(__sqlitedb__)
cur = conn.cursor()
__sql__ = None
if __sql__ is None:
from pymasarsqlite.db.masarsqlite import SQL
else:
sqlfile = open(__sql__)
SQL = sqlfile.read()
if SQL is None:
print ('SQLite script is empty. Cannot create SQLite db.')
raise IOError('SQLite script is empty. Cannot create SQLite db.')
else:
cur.executescript(SQL)
cur.execute("PRAGMA main.page_size= 4096;")
cur.execute("PRAGMA main.default_cache_size= 10000;")
cur.execute("PRAGMA main.locking_mode=EXCLUSIVE;")
cur.execute("PRAGMA main.synchronous=NORMAL;")
cur.execute("PRAGMA main.journal_mode=WAL;")
cur.execute("PRAGMA main.temp_store = MEMORY;")
cur.execute('select name from sqlite_master where type=\'table\'')
masarconf = 'SR_All_20140421'
servicename = 'masar'
pvgname = 'masarpvgroup'
pvgdesc = 'this is my new pv group for masar service with same group name'
pvs = ["masarExample0000",
"masarExample0001",
"masarExampleBoUninit",
"masarExampleMbboUninit",
"masarExample0002",
"masarExample0003",
"masarExample0004",
"masarExampleCharArray",
"masarExampleShortArray",
"masarExampleLongArray",
"masarExampleStringArray",
"masarExampleFloatArray",
"masarExampleDoubleArray",
"masarExampleMbboUninitTest"]
res = savePvGroup(conn, pvgname, func=pvgdesc)
res = saveGroupPvs(conn, pvgname, pvs)
pvgroups = retrievePvGroups(conn)
saveService(conn, servicename, desc='test desc')
conn.commit()
conn.close()
savePvGroups(self.parsed_json['pvgroups'])
saveSQLiteServiceConfig(self.parsed_json)
conn = sqlite3.connect(__sqlitedb__)
pvgroups = retrievePvGroups(conn)
self.assertEqual('BR_MG_Set_20130419', pvgroups[1][1])
self.assertEqual('Booster magnet power supply set points', pvgroups[1][2])
self.assertEqual(3, len(pvgroups[1][3].split(':'))) # Confirms correct date format
self.assertEqual(3, len(pvgroups[1][3].split('-'))) # 2016-07-28 18:18:36
self.assertEqual(None, pvgroups[1][4])
configresult = retrieveServiceConfigs(conn)
self.assertEqual('BR_MG_SCR_20130419', configresult[1][1])
self.assertEqual('BR ramping PS daily SCR setpoint', configresult[1][2])
self.assertEqual(3, len(configresult[1][3].split(':'))) # Confirms correct date format
self.assertEqual(3, len(configresult[1][3].split('-'))) # 2016-07-28 18:18:36
self.assertEqual(None, configresult[1][4])
self.assertEqual('active', configresult[1][5])
except sqlite3.Error, e:
print ("Error %s:" % e.args[0])
raise
def testConfiguration(self):
channel = 'masarService'
self.mc = masarClient.client(channelname=channel)
# DB SETUP
__sqlitedb__ = os.environ["MASAR_SQLITE_DB"]
try:
conn = sqlite3.connect(__sqlitedb__)
cur = conn.cursor()
__sql__ = None
if __sql__ is None:
from pymasarsqlite.db.masarsqlite import SQL
else:
sqlfile = open(__sql__)
SQL = sqlfile.read()
if SQL is None:
print('SQLite script is empty. Cannot create SQLite db.')
sys.exit()
else:
cur.executescript(SQL)
cur.execute("PRAGMA main.page_size= 4096;")
cur.execute("PRAGMA main.default_cache_size= 10000;")
cur.execute("PRAGMA main.locking_mode=EXCLUSIVE;")
cur.execute("PRAGMA main.synchronous=NORMAL;")
cur.execute("PRAGMA main.journal_mode=WAL;")
cur.execute("PRAGMA main.temp_store = MEMORY;")
cur.execute('select name from sqlite_master where type=\'table\'')
masarconf = 'SR_All_20140421'
servicename = 'masar'
pvgname = 'masarpvgroup'
pvgdesc = 'this is my new pv group for masar service with same group name'
pvs = ["masarExampleDoubleArray"]
res = savePvGroup(conn, pvgname, func=pvgdesc)
self.assertEqual([1], res)
res2 = saveGroupPvs(conn, pvgname, pvs)
with self.assertRaises(Exception) as context:
saveGroupPvs(conn, "badname", pvs)
self.assertEqual(
context.exception.message,
'pv group name (badname) is not unique, or not exist.')
self.assertEqual([1], res2)
pvgroups = retrievePvGroups(conn)
self.assertEqual(5, len(pvgroups[0]))
self.assertEqual(1, pvgroups[0][0])
self.assertEqual(pvgname, pvgroups[0][1])
self.assertEqual(pvgdesc, pvgroups[0][2])
self.assertNotEqual(None, pvgroups[0][3])
# The following 2 tests are to confirm the date string is in the correct format
self.assertEqual(3, len(pvgroups[0][3].split('-')))
self.assertEqual(3, len(pvgroups[0][3].split(':')))
self.assertEqual(None, pvgroups[0][4])
test_desc = 'test desc'
test_system = 'SR'
test_status = 'active'
test_version = 20140420
saveService(conn, servicename, desc=test_desc)
with self.assertRaises(Exception) as context:
saveServiceConfig(conn,
"bad servicename",
masarconf,
system=test_system,
status=test_status,
configversion=test_version,
configdesc=test_desc)
self.assertEqual(
"service with given name (bad servicename) does not exist.",
context.exception.message)
with self.assertRaises(Exception) as context:
saveServiceConfig(conn,
servicename,
masarconf,
system=test_system,
status="bad status",
configversion=test_version,
configdesc=test_desc)
self.assertEqual(
"Service status has to be either active, or inactive",
context.exception.message)
saveServiceConfig(conn,
servicename,
masarconf,
system=test_system,
status=test_status,
configversion=test_version,
configdesc=test_desc)
with self.assertRaises(Exception) as context:
saveServiceConfig(conn,
servicename,
masarconf,
system=test_system,
status=test_status,
configversion=test_version,
configdesc=test_desc)
self.assertEqual('service config exists already.',
context.exception.message)
with self.assertRaises(
IndexError
): # TODO: Should this be a more specific error message?
saveServicePvGroup(conn, "bad config", [pvgname])
with self.assertRaises(Exception) as context:
res3 = saveServicePvGroup(
conn, masarconf,
["bad pvgname"]) # this test prints a message to console
self.assertEqual(
"given pv group name (bad pvgname) does not exist.",
context.exception.message)
res3 = saveServicePvGroup(conn, masarconf, [pvgname])
self.assertEqual([1], res3)
with self.assertRaises(Exception) as context:
pvlist = retrieveServiceConfigPVs(
conn, masarconf, servicename="bad servicename")
pvlist = retrieveServiceConfigPVs(conn,
masarconf,
servicename=servicename)
self.assertEqual(
context.exception.message,
'Given service (bad servicename) does not exist.')
self.assertEqual(pvs, pvlist)
self.expected_column_names = ('config_idx', 'config_name',
'config_desc', 'config_create_date',
'config_version', 'status')
results = retrieveServiceConfigs(conn, "bad servicename",
masarconf)
self.assertSequenceEqual(self.expected_column_names, results[0])
self.assertEqual(1, len(results)) # IE: no data returned
self.assertEqual(len(self.expected_column_names), len(results[0]))
results = retrieveServiceConfigs(conn, servicename, "bad conf")
self.assertSequenceEqual(self.expected_column_names, results[0])
self.assertEqual(1, len(results)) # IE: no data returned
self.assertEqual(len(self.expected_column_names), len(results[0]))
results = retrieveServiceConfigs(conn, servicename, masarconf)
# Label tests
self.assertSequenceEqual(self.expected_column_names, results[0])
self.assertEqual(2, len(results))
self.assertEqual(len(self.expected_column_names), len(results[0]))
# Data tests
self.assertEqual(masarconf, results[1][1])
self.assertEqual(test_desc, results[1][2])
self.assertNotEqual(None, results[1][3])
self.assertEqual(1, results[1][0])
self.assertEqual(len(self.expected_column_names), len(results[1]))
# The following 2 tests are to confirm the date string is in the correct format
self.assertEqual(3, len(results[1][3].split('-')))
self.assertEqual(3, len(results[1][3].split(':')))
self.assertEqual(test_version, results[1][4])
self.assertEqual(test_status, results[1][5])
conn.commit()
conn.close()
except sqlite3.Error, e:
print("Error %s:" % e.args[0])
raise
def saveService(self):
saveService(self.conn, self.servicename, desc=self.servicedesc)
def testMultiGroup(self):
# DB SETUP
__sqlitedb__ = os.environ["MASAR_SQLITE_DB"]
try:
conn = sqlite3.connect(__sqlitedb__)
pvgname1 = 'masarpvgroup1'
pvgdesc1 = 'this is my new pv group for masar service with same group name'
pvs1 = [
"masarExample0000", "masarExample0001", "masarExampleBoUninit",
"masarExampleMbboUninit", "masarExample0002",
"masarExample0003", "masarExampleFloatArray",
"masarExample0004"
]
res1 = savePvGroup(conn, pvgname1, func=pvgdesc1)
res1 = saveGroupPvs(conn, pvgname1, pvs1)
pvgname2 = 'masarpvgroup2'
pvgdesc2 = 'this is my new pv group for masar service with same group name'
pvs2 = [
"masarExample0000", "masarExample0001", "masarExample0002",
"masarExample0004", "masarExampleCharArray",
"masarExampleShortArray", "masarExampleLongArray",
"masarExampleStringArray", "masarExampleFloatArray",
"masarExampleDoubleArray", "masarExampleMbboUninitTest"
]
res2 = savePvGroup(conn, pvgname2, func=pvgdesc2)
res2 = saveGroupPvs(conn, pvgname2, pvs2)
pvgroups = retrievePvGroups(conn)
self.assertEqual(pvgroups[0][1], "masarpvgroup")
self.assertEqual(pvgroups[1][1], "masarpvgroup1")
self.assertEqual(pvgroups[2][1], "masarpvgroup2")
pvgroups = retrieveGroupPvs(conn, 2)
self.assertEqual(pvgroups[0][0], "masarExample0000")
self.assertEqual(pvgroups[1][0], "masarExample0001")
self.assertEqual(pvgroups[2][0], "masarExampleBoUninit")
self.assertEqual(pvgroups[3][0], "masarExampleMbboUninit")
self.assertEqual(pvgroups[4][0], "masarExample0002")
self.assertEqual(pvgroups[5][0], "masarExample0003")
self.assertEqual(pvgroups[6][0], "masarExample0004")
self.assertEqual(pvgroups[7][0], "masarExampleFloatArray")
pvgroups = retrieveGroupPvs(conn, 3)
self.assertEqual(pvgroups[0][0], "masarExample0000")
self.assertEqual(pvgroups[1][0], "masarExample0001")
self.assertEqual(pvgroups[2][0], "masarExample0002")
self.assertEqual(pvgroups[3][0], "masarExample0004")
self.assertEqual(pvgroups[4][0], "masarExampleCharArray")
self.assertEqual(pvgroups[5][0], "masarExampleShortArray")
self.assertEqual(pvgroups[6][0], "masarExampleLongArray")
self.assertEqual(pvgroups[7][0], "masarExampleStringArray")
self.assertEqual(pvgroups[8][0], "masarExampleFloatArray")
self.assertEqual(pvgroups[9][0], "masarExampleDoubleArray")
self.assertEqual(pvgroups[10][0], "masarExampleMbboUninitTest")
servicename = "masar"
masarconf = "testconf"
saveService(conn, servicename, desc='test desc')
saveServiceConfig(conn,
servicename,
masarconf,
system='SR',
status='active',
configversion=20140420,
configdesc='test desc')
res = saveServicePvGroup(conn, masarconf, [pvgname1, pvgname2])
conn.commit()
conn.close()
except:
raise
save_params = {'configname': 'testconf', 'servicename': 'masar'}
res1 = self.mc.saveSnapshot(save_params)
self.assertNotEqual(res1, None)
self.assertNotEqual(res1, False)
event_id = res1[0]
retrieve_params = {'eventid': str(event_id)}
result = self.mc.retrieveSnapshot(retrieve_params)
self.assertNotEqual(result, None)
self.assertNotEqual(result, False)
expected_results = (
(
'masarExample0000', # ChannelName 0
'masarExample0001', # ChannelName 1
'masarExampleBoUninit', # ChannelName 2
'masarExampleMbboUninit', # ChannelName 3
'masarExample0002', # ChannelName 4
'masarExample0003', # ChannelName 5
'masarExample0004', # ChannelName 6
'masarExampleCharArray', # ChannelName 7
'masarExampleShortArray', # ChannelName 8
'masarExampleLongArray', # ChannelName 9
'masarExampleStringArray', # ChannelName 10
'masarExampleFloatArray', # ChannelName 11
'masarExampleDoubleArray', # ChannelName 12
'masarExampleMbboUninitTest'), # ChannelName 13
(
10, # 0000 Value
'string value', # 0001 Value
'0', # BoUninit Value (appropriately returned as string,
1, # MbboUninit Value
'zero', # 0002 Value
'one', # 0003 Value
1.9, # 0004 Value
(), # CharArray Value
(), # ShortArray Value
(), # LongArray Value
(), # StringArray Value
(), # FloatArrayValue
(), # DoubleArray Value
1), # MbboUninitTest Value
(5, 0, 0, 5, 0, 0, 6, 4, 1, 5, 0, 2, 6, 5), # DBR type
(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1), # isConnected
(631152000, 631152000, 631152000, 631152000, 631152000, 631152000,
631152000, 631152000, 631152000, 631152000, 631152000, 631152000,
631152000, 631152000), # SecondsPastEpoch
(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), # NanoSeconds
(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), # UserTag
(0, 0, 3, 0, 3, 0, 0, 3, 3, 3, 3, 3, 3, 0), # Severity
(3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3), # Status
('UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM',
'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM',
'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM', 'UDF_ALARM')) # Message
self.assertSequenceEqual(result, expected_results)
def initService():
saveService(conn, 'masar', desc='machine snapshot, archiving, and retrieve service')
saveService(conn, 'archive', desc='machine archiving service')
