def Minit():
if config.mysqlMaxHandle < config.mysqlHandleNumber:
Mloger.info("wrong config:101")
for i in range(config.mysqlHandleNumber):
p = sql_operator.sql_operate(config.Config_mysql_connect)
Mglobal.Qmysql.put(p)
def connectionMade(self):
ipinfo = self.transport.getPeer()
if len(self.factory.clients) >= self.factory.max_client:
self.transport.loseConnection()
else:
Mloger.info('ip:%s : connect successfully!' % (ipinfo))
def action(self, data):
conn = Qmysql.get()
# Mloger.info('callback is %s'%UsrLoginStatue[self.call_back])
insertdata = 'select ssid from sensor where uid =%s' % (data.decode())
print(insertdata)
ans = conn._queryall(insertdata)
print(ans)
if (ans[0] == None):
Mloger.error('query wrong!')
return Define['ERRORSQL']
else:
Mloger.info("select ok!")
Qmysql.put(conn)
return ans
def action(self, data):
conn = Qmysql.get()
# Mloger.info('callback is %s'%UsrLoginStatue[self.call_back])
print('do action..')
insertdata = 'select SQL_NO_CACHE message from message where uid =%s && ssid = %s order by data desc limit 0,%d' % (
self.se.nowid, data.decode(), self.se.shownum)
print(insertdata)
ans = conn._queryall(insertdata)
print(ans)
if (ans[0] == None):
Mloger.error('query wrong!')
return Define['ERRORSQL']
else:
Mloger.info("select ok!")
Qmysql.put(conn)
return ans
def action(self, data):
self.call_back.write('data recieved'.encode())
conn = Qmysql.get()
# Mloger.info('callback is %s'%UsrLoginStatue[self.call_back])
insertdata = 'select uid from user where usrname=\'%s\'' % (
data.decode())
print(insertdata)
ans = conn._query(insertdata)
print(ans)
if (ans[0] == None):
Mloger.error('query wrong!')
return Define['ERRORSQL']
else:
Mloger.info("select ok!")
Qmysql.put(conn)
return ans[0]
def action(self, data):
self.call_back.write('data recieved'.encode())
conn = Qmysql.get()
#Mloger.info('callback is %s'%UsrLoginStatue[self.call_back])
insertdata = 'insert into message(uid,message,data,ssid) values(%d,\'%s\',\'%s\',%s)' % (
self.se.uid, data.decode(), Mglobal.Systime.getmysqltime(),
self.ssid)
print(insertdata)
ans = conn._insert(insertdata)
if (type(ans) is int) and (ans == 0):
Mloger.info("data insert ok!")
Qmysql.put(conn)
return ans
else:
Mloger.error('insert wrong!')
return '0'
def processCmd(self, rdata, command_id):
Mloger.info("command_id:")
Mloger.info(command_id)
Mloger.info("rdata:" + rdata)
#self.transport.write(rdata.encode())
if command_id == Define['RECVDATA']:
ssid = rdata.split(";")[0]
ssdata = rdata.split(";")[1]
print('ssid:', ssid)
testh = dt.dataHandle(ssid, ssdata, self)
testh.handle()
if command_id == 2:
self.decryptdata(rdata)
RKey.loadPubkey(rdata)
if command_id == 3:
self.decryptdata(rdata)
RKey.loadPrikey(rdata)
if command_id == Define['ACCOUNT']:
print("getuid")
han = dt.getuid(rdata, self)
re = han.handle()
if command_id == Define['NUMDATA']:
print(rdata)
tnum = int(rdata)
if tnum > 14:
self.shownum = tnum
if command_id == Define['Online']:
line = ''
flag = 0
if Mglobal.UsrLoginStatue:
for k, v in Mglobal.UsrLoginStatue.items():
if v == 1:
flag = 1
line = line + str(k) + ';'
print(line)
if flag:
self.transport.write(line.encode())
else:
self.transport.write("None".encode())
else:
self.transport.write("None".encode())
if command_id == Define['onlineSS']:
self.nowid = rdata
print(rdata)
han = dt.getssid(rdata, self)
re = han.handle()
if command_id == Define['SSDATA']:
print(rdata)
han = dt.getssdata(rdata, self)
re = han.handle()
def connectionLost(self, reason):
print(self.uid)
Mglobal.UsrLoginStatue[self.uid] = 0
Mloger.info('ip:%s : lost connect' % self.transport.getPeer())
def __init__(self, max_client):
self.max_client = max_client
self.clients = []
Mloger.info('reactor start...ok!')
def err(self, failure):
Mloger.error(failure)