def parameters(filter_tag, filter_name):
"""Connect to host and retrieve parameter list."""
mssql_conn = mssql(host_info.address,
strip_R_from_db_name(host_info.database))
mssql_conn.connect()
params = mssql_conn.create_parameter_record(filter_tag, filter_name)
mssql_conn.close()
print(params)
def parameters(filter_tag, filter_name):
"""Connect to host and retrieve parameter list."""
mssql_conn = mssql(host_info.address,
strip_R_from_db_name(host_info.database))
mssql_conn.connect()
params = mssql_conn.create_parameter_record(filter_tag, filter_name)
mssql_conn.close()
print(params)
def alarmconfig(filter_tag, filter_name, outfile):
"""Connect to host and retrieve parameter list."""
mssql_conn = mssql(host_info.address,
strip_R_from_db_name(host_info.database))
mssql_conn.connect()
alarmconfig = mssql_conn.create_alarmconfig_record(filter_tag, filter_name)
mssql_conn.close()
if (outfile != ''):
with open(outfile, "w") as f:
f.write(alarmconfig.to_csv().encode("UTF-8"))
else:
print(alarmconfig)
def tagid_by_name(tagname):
"""Search hosts db for tag entries matching the given name.
Return tagid.
"""
try:
toc = tic()
mssql_conn = mssql(host_info.address,
strip_R_from_db_name(host_info.database))
mssql_conn.connect()
mssql_conn.execute("SELECT TLGTAGID, VARNAME FROM PDE#TAGs WHERE "
"VARNAME LIKE '%{name}%'".format(name=tagname))
if mssql_conn.rowcount():
for rec in mssql_conn.fetchall():
print rec
print("Fetched data in {time}.".format(time=round(toc(), 3)))
except Exception as e:
print(e)
finally:
mssql_conn.close()
def tagid_by_name(tagname):
"""Search hosts db for tag entries matching the given name.
Return tagid.
"""
try:
toc = tic()
mssql_conn = mssql(host_info.address,
strip_R_from_db_name(host_info.database))
mssql_conn.connect()
mssql_conn.execute("SELECT TLGTAGID, VARNAME FROM PDE#TAGs WHERE "
"VARNAME LIKE '%{name}%'".format(name=tagname))
if mssql_conn.rowcount():
for rec in mssql_conn.fetchall():
print rec
print("Fetched data in {time}.".format(time=round(toc(), 3)))
except Exception as e:
print(e)
finally:
mssql_conn.close()
def __init__(self):
self.msdb = mssql()
self.mysqldb = mysql()
VALUES
(44
,'192.168.1.13'
,'sessionid'
,'psuid'
,2
,'OperationDescription'
,'%s'
,19
,1
,1
,1
,'ISIP');
"""
sql = mssql.mssql()
sql.conn("192.168.1.13", "psplayer", "psplayer", "psplayer")
print time.strftime("%Y/%m/%d %H:%M:%S")
start = time.time()
n = 1
while 1:
loginname = "ps_008A%d" % n
s1 = "insert into account( loginname, password, nickname, email, country, city, sex, birth, sendemail, rightid, type, RegProductID ) values ( N'%s', N'%s', N'%s', N'%s', %d, N'%s', %d, '%d-%d-%d', %d, %d, %d, %d )" % (
loginname, "09e31d1ab4de57a06dac4834a7cb1432", "", "*****@*****.**", 4,
"d", 1, 1983, 12, 1, 1, 1, 1, 1)
sql.exe(s1)
n += 1
if n % 1000 == 0:
print n, time.time()
VALUES
(44
,'192.168.1.13'
,'sessionid'
,'psuid'
,2
,'OperationDescription'
,'%s'
,19
,1
,1
,1
,'ISIP');
"""
sql = mssql.mssql()
sql.conn("192.168.1.13","psplayer","psplayer","psplayer")
print time.strftime("%Y/%m/%d %H:%M:%S")
start = time.time()
n= 1
while 1:
loginname = "ps_008A%d" % n
s1 = "insert into account( loginname, password, nickname, email, country, city, sex, birth, sendemail, rightid, type, RegProductID ) values ( N'%s', N'%s', N'%s', N'%s', %d, N'%s', %d, '%d-%d-%d', %d, %d, %d, %d )" % (loginname, "09e31d1ab4de57a06dac4834a7cb1432", "","*****@*****.**",4,"d",1, 1983,12,1, 1,1,1,1)
sql.exe(s1)
n+=1
if n % 1000 == 0:
print n ,time.time()
