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 __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()