def get_ms_macross(platform):
ms_list = []
sql = ""
#reload(sys)
#sys.setdefaultencoding('utf8')
db = DB.db.DB_MYSQL()
#db.connect("192.168.8.101", 3317, "public", "funshion", "macross")
db.connect(DB.db.DB_CONFIG.host, DB.db.DB_CONFIG.port,
DB.db.DB_CONFIG.user, DB.db.DB_CONFIG.password,
DB.db.DB_CONFIG.db)
if (platform == 'mobile'):
sql = "select s.server_id, s.server_name, s.server_ip, s.server_port, s.controll_ip, s.controll_port, s.ml_room_id, l.room_name, \
s.server_version, s.protocol_version, s.is_valid, s.is_dispatch, s.is_pause \
from fs_server s, fs_mobile_location l where s.ml_room_id=l.room_id and s.is_valid=1 and s.type_id=1 order by s.server_id"
elif (platform == 'pc'):
sql = "select s.server_id, s.server_name, s.server_ip, s.server_port, s.controll_ip, s.controll_port, s.room_id, l.room_name, \
s.server_version, s.protocol_version, s.is_valid, s.is_dispatch, s.is_pause \
from fs_server s, fs_server_location l where s.room_id=l.room_id and s.is_valid=1 and s.type_id=1 order by s.server_id"
db.execute(sql)
for row in db.cur.fetchall():
ms = {}
col_num = 0
for r in row:
if (col_num == 0):
ms['server_id'] = r
elif (col_num == 1):
ms['server_name'] = r
elif (col_num == 2):
ms['server_ip'] = r
elif (col_num == 3):
ms['server_port'] = r
elif (col_num == 4):
ms['controll_ip'] = r
elif (col_num == 5):
ms['controll_port'] = r
elif (col_num == 6):
ms['room_id'] = r
elif (col_num == 7):
ms['room_name'] = r
elif (col_num == 8):
ms['server_version'] = r
elif (col_num == 9):
ms['protocol_version'] = r
elif (col_num == 10):
ms['is_valid'] = r
elif (col_num == 11):
ms['is_dispatch'] = r
elif (col_num == 12):
ms['is_pause'] = r
col_num += 1
ms_list.append(ms)
db.close()
return ms_list
def get_tasks_macross(self):
db = DB.db.DB_MYSQL()
#db.connect("192.168.8.101", 3317, "public", "funshion", "macross")
db.connect(DB.db.DB_CONFIG.host, DB.db.DB_CONFIG.port,
DB.db.DB_CONFIG.user, DB.db.DB_CONFIG.password,
DB.db.DB_CONFIG.db)
for one in self.ms_list:
print '%d, %s get tasks begin' % (one.db_record.server_id,
one.db_record.controll_ip)
sql = ""
if (self.platform == 'mobile'):
sql = "SELECT dat_hash FROM fs_mobile_dat d, fs_mobile_ms_dat m WHERE d.dat_id = m.dat_id AND m.server_id=%d" % (
one.db_record.server_id)
elif (self.platform == 'pc'):
sql = "SELECT task_hash FROM fs_task t,fs_ms_task m WHERE t.task_id = m.task_id AND m.server_id=%d" % (
one.db_record.server_id)
print sql
db.execute(sql)
#print type(db.cur)
#print type(db.cur.fetchall())
for row in db.cur.fetchall():
col_num = 0
for r in row:
if (col_num == 0):
#print str(r)
one.task_dict[str(r)] = '1'
col_num += 1
print '%d, %s get tasks end, task_number=%d' % (
one.db_record.server_id, one.db_record.controll_ip,
len(one.task_dict))
db.close()
#del db
return True
def get_tasks_macross_pc(self):
db = DB.db.DB_MYSQL()
#db.connect("192.168.8.101", 3317, "public", "funshion", "macross")
db.connect(DB.db.DB_CONFIG.host, DB.db.DB_CONFIG.port, DB.db.DB_CONFIG.user, DB.db.DB_CONFIG.password, DB.db.DB_CONFIG.db)
for one in self.ms_list:
print '%d, %s get tasks begin' % (one.db_record.server_id, one.db_record.controll_ip)
sql = "SELECT t.task_hash, t.create_time FROM fs_task t, fs_ms_task m WHERE t.task_id = m.task_id AND m.server_id=%d" % (one.db_record.server_id)
print sql
db.execute(sql)
#print type(db.cur)
#print type(db.cur.fetchall())
for row in db.cur.fetchall():
col_num = 0
one_task = {}
for r in row:
if(col_num == 0):
one_task['hash'] = r
elif(col_num == 1):
one_task['online_time'] = r
elif(col_num == 2):
one_task['filesize'] = r
col_num += 1
one.task_dict[one_task['hash']] = one_task
one.init_task_num = len(one.task_dict)
print '%d, %s get tasks end, task_number=%d' % (one.db_record.server_id, one.db_record.controll_ip, len(one.task_dict))
if(self.log_file != None):
self.log_file.write('%d, %s get tasks end, task_number=%d\n' % (one.db_record.server_id, one.db_record.controll_ip, len(one.task_dict)))
db.close()
#del db
return True
def get_tasks_macross(self):
db = DB.db.DB_MYSQL()
#db.connect("192.168.8.101", 3317, "public", "funshion", "macross")
db.connect(DB.db.DB_CONFIG.host, DB.db.DB_CONFIG.port, DB.db.DB_CONFIG.user, DB.db.DB_CONFIG.password, DB.db.DB_CONFIG.db)
for one in self.ms_list:
print '%d, %s get tasks begin' % (one.db_record.server_id, one.db_record.controll_ip)
sql = ""
if(self.platform == 'mobile'):
sql = "SELECT dat_hash FROM fs_mobile_dat d, fs_mobile_ms_dat m WHERE d.dat_id = m.dat_id AND m.server_id=%d" % (one.db_record.server_id)
elif(self.platform == 'pc'):
sql = "SELECT task_hash FROM fs_task t,fs_ms_task m WHERE t.task_id = m.task_id AND m.server_id=%d" % (one.db_record.server_id)
print sql
db.execute(sql)
#print type(db.cur)
#print type(db.cur.fetchall())
for row in db.cur.fetchall():
col_num = 0
for r in row:
if(col_num == 0):
#print str(r)
one.task_dict[str(r)] = '1'
col_num += 1
print '%d, %s get tasks end, task_number=%d' % (one.db_record.server_id, one.db_record.controll_ip, len(one.task_dict))
db.close()
#del db
return True
def get_room_macross(platform):
room_list = []
sql = ""
#reload(sys)
#sys.setdefaultencoding('utf8')
db = DB.db.DB_MYSQL()
db.connect(DB.db.DB_CONFIG.host, DB.db.DB_CONFIG.port,
DB.db.DB_CONFIG.user, DB.db.DB_CONFIG.password,
DB.db.DB_CONFIG.db)
if (platform == "mobile"):
sql = "select l.room_id, l.room_name, l.is_valid from fs_server s, fs_mobile_location l where s.ml_room_id=l.room_id and s.is_valid=1 and l.is_valid=1 group by l.room_id order by l.room_id"
elif (platform == "pc"):
sql = "select l.room_id, l.room_name, l.is_valid from fs_server s, fs_server_location l where s.room_id=l.room_id and s.is_valid=1 and l.is_valid=1 group by l.room_id order by l.room_id"
db.execute(sql)
for row in db.cur.fetchall():
room = {}
col_num = 0
for r in row:
if (col_num == 0):
room['room_id'] = r
elif (col_num == 1):
room['room_name'] = r
elif (col_num == 2):
room['is_valid'] = r
col_num += 1
room_list.append(room)
db.close()
return room_list
def get_room_macross(platform):
room_list = []
sql = ""
#reload(sys)
#sys.setdefaultencoding('utf8')
db = DB.db.DB_MYSQL()
db.connect(DB.db.DB_CONFIG.host, DB.db.DB_CONFIG.port, DB.db.DB_CONFIG.user, DB.db.DB_CONFIG.password, DB.db.DB_CONFIG.db)
if(platform == "mobile"):
sql = "select l.room_id, l.room_name, l.is_valid from fs_server s, fs_mobile_location l where s.ml_room_id=l.room_id and s.is_valid=1 and l.is_valid=1 group by l.room_id order by l.room_id"
elif(platform == "pc"):
sql = "select l.room_id, l.room_name, l.is_valid from fs_server s, fs_server_location l where s.room_id=l.room_id and s.is_valid=1 and l.is_valid=1 group by l.room_id order by l.room_id"
db.execute(sql)
for row in db.cur.fetchall():
room = {}
col_num = 0
for r in row:
if(col_num == 0):
room['room_id'] = r
elif(col_num == 1):
room['room_name'] = r
elif(col_num == 2):
room['is_valid'] = r
col_num += 1
room_list.append(room)
db.close()
return room_list
def get_tasks_macross_mobile(begin_date, end_date):
task_list = []
sql = ""
#reload(sys)
#sys.setdefaultencoding('utf8')
where_condition = ''
if(len(begin_date) > 0):
begin_time = '%s-%s-%s 00:00:00' % (begin_date[0:4], begin_date[4:6], begin_date[6:8])
where_condition += " and create_time >= '%s'" % (begin_time)
if(len(end_date) > 0):
end_time = '%s-%s-%s 00:00:00' % (end_date[0:4], end_date[4:6], end_date[6:8])
where_condition += " and create_time < '%s'" % (end_time)
db = DB.db.DB_MYSQL()
db.connect(DB.db.DB_CONFIG.host, DB.db.DB_CONFIG.port, DB.db.DB_CONFIG.user, DB.db.DB_CONFIG.password, DB.db.DB_CONFIG.db)
#sql = "select dat_hash, create_time from fs_mobile_dat where state!='dismissed' " + where_condition
sql = "select dat_hash, create_time, filesize from fs_mobile_dat where state!='dismissed' " + where_condition
print sql
db.execute(sql)
for row in db.cur.fetchall():
task1 = {}
col_num = 0
for r in row:
if(col_num == 0):
task1['hash'] = r
elif(col_num == 1):
task1['online_time'] = r
elif(col_num == 2):
task1['filesize'] = r
col_num += 1
task_list.append(task1)
print 'task_list num: %d' % (len(task_list))
sql = "select video_hash, create_time, filesize from fs_video_dat where state!='dismissed' " + where_condition
print sql
db.execute(sql)
for row in db.cur.fetchall():
task1 = {}
col_num = 0
for r in row:
if(col_num == 0):
task1['hash'] = r
elif(col_num == 1):
task1['online_time'] = r
elif(col_num == 2):
task1['filesize'] = r
col_num += 1
task_list.append(task1)
print 'task_list num: %d' % (len(task_list))
db.close()
return task_list
def get_ms_macross(platform):
ms_list = []
sql = ""
#reload(sys)
#sys.setdefaultencoding('utf8')
db = DB.db.DB_MYSQL()
#db.connect("192.168.8.101", 3317, "public", "funshion", "macross")
db.connect(DB.db.DB_CONFIG.host, DB.db.DB_CONFIG.port, DB.db.DB_CONFIG.user, DB.db.DB_CONFIG.password, DB.db.DB_CONFIG.db)
if(platform == 'mobile'):
sql = "select s.server_id, s.server_name, s.server_ip, s.server_port, s.controll_ip, s.controll_port, s.ml_room_id, l.room_name, \
s.server_version, s.protocol_version, s.is_valid, s.is_dispatch, s.is_pause \
from fs_server s, fs_mobile_location l where s.ml_room_id=l.room_id and s.is_valid=1 and s.support_live=0 and s.type_id=1 order by s.server_id"
elif(platform == 'pc'):
sql = "select s.server_id, s.server_name, s.server_ip, s.server_port, s.controll_ip, s.controll_port, s.room_id, l.room_name, \
s.server_version, s.protocol_version, s.is_valid, s.is_dispatch, s.is_pause \
from fs_server s, fs_server_location l where s.room_id=l.room_id and s.is_valid=1 and s.support_live=0 and s.type_id=1 order by s.server_id"
db.execute(sql)
for row in db.cur.fetchall():
ms = {}
col_num = 0
for r in row:
if(col_num == 0):
ms['server_id'] = r
elif(col_num == 1):
ms['server_name'] = r
elif(col_num == 2):
ms['server_ip'] = r
elif(col_num == 3):
ms['server_port'] = r
elif(col_num == 4):
ms['controll_ip'] = r
elif(col_num == 5):
ms['controll_port'] = r
elif(col_num == 6):
ms['room_id'] = r
elif(col_num == 7):
ms['room_name'] = r
elif(col_num == 8):
ms['server_version'] = r
elif(col_num == 9):
ms['protocol_version'] = r
elif(col_num == 10):
ms['is_valid'] = r
elif(col_num == 11):
ms['is_dispatch'] = r
elif(col_num == 12):
ms['is_pause'] = r
col_num += 1
ms_list.append(ms)
db.close()
return ms_list
def show_task_list(request, platform):
output = ''
hashs = request.REQUEST['hashs']
hash_list = hashs.split(',')
#reload(sys)
#sys.setdefaultencoding('utf8')
db = DB.db.DB_MYSQL()
#db.connect("192.168.8.101", 3317, "public", "funshion", "macross")
db.connect(DB.db.DB_CONFIG.host, DB.db.DB_CONFIG.port, DB.db.DB_CONFIG.user, DB.db.DB_CONFIG.password, DB.db.DB_CONFIG.db)
if(platform == 'mobile'):
sql = 'select dat_hash, cid, serialid, media_id, dat_name from fs_mobile_dat where dat_hash='
elif(platform == 'pc'):
sql = 'select a.hashid, a.dat_id, a.serialid, b.media_id, a.dat_name from fs_dat_file a, fs_media_serials b where a.serialid=b.serialid and a.hashid='
for hashid in hash_list:
title = '<h1>hash: %s</h1>' % (hashid)
output += title
sql_where = sql + '"%s"'%(hashid)
db.execute(sql_where)
task_list = []
for row in db.cur.fetchall():
task = {}
col_num = 0
for r in row:
if(col_num == 0):
task['hash'] = r
elif(col_num == 1):
task['cid'] = r
elif(col_num == 2):
task['serialid'] = r
elif(col_num == 3):
task['media_id'] = r
elif(col_num == 4):
task['dat_name'] = r
col_num += 1
task_list.append(task)
for task in task_list:
output += '%s,%s,%s,%s,%s\n' % (task['hash'], task['cid'], task['serialid'], task['media_id'], task['dat_name'])
db.close()
return HttpResponse(output)
def Leer():
a = db.connect("select * from Liga")
lista = []
for b in a:
L = liga(b['Id_Liga'], b['Nombre'], b['Pais'], b['Division'],
b['Cant_descensos'])
lista.append(L)
return lista
def Leer():
a = db.connect("select * from Equipo")
lista = []
listaLiga = liga.Leer()
for b in a:
for c in listaLiga:
if c.id_liga == b['Liga']:
E = equipo(b['Id_Equipo'], c, b['Fundacion'], b['Nombre'])
lista.append(E)
return lista
def Leer():
a = db.connect("select * from DT")
lista = []
listaEquipos = equipo.Leer()
for b in a:
for c in listaEquipos:
if c.id_equipo == b['Equipo']:
DT = dt(b['Dni'], b['Nombre'], b['Apellido'], b['Sueldo'], b['Fecha_nac'], b['Nacionalidad'],c)
lista.append(DT)
return lista
def db_calc_cold(platform):
sql = ""
#reload(sys)
#sys.setdefaultencoding('utf8')
db = DB.db.DB_MYSQL()
#db.connect("192.168.160.203", 3306, "admin", "123456", "mediaserver")
db.connect(DB.db.MS_DB_CONFIG.host, DB.db.MS_DB_CONFIG.port, DB.db.MS_DB_CONFIG.user, DB.db.MS_DB_CONFIG.password, DB.db.MS_DB_CONFIG.db)
if(platform == 'mobile'):
sql = "update mobile_task set cold1=TIMESTAMPDIFF(DAY, NOW(), last_hit_time) where last_hit_time is not null"
db.execute(sql)
sql = "update mobile_task set cold1=TIMESTAMPDIFF(DAY, NOW(), online_time) where last_hit_time is null and online_time is not null"
db.execute(sql)
elif(platform == 'pc'):
sql = "update pc_task set cold1=TIMESTAMPDIFF(DAY, NOW(), last_hit_time) where last_hit_time is not null"
db.execute(sql)
sql = "update pc_task set cold1=TIMESTAMPDIFF(DAY, NOW(), online_time) where last_hit_time is null and online_time is not null"
db.execute(sql)
db.close()
return
def get_tasks_macross_pc(begin_date, end_date):
task_list = []
sql = ""
#reload(sys)
#sys.setdefaultencoding('utf8')
where_condition = ''
if(len(begin_date) > 0):
begin_time = '%s-%s-%s 00:00:00' % (begin_date[0:4], begin_date[4:6], begin_date[6:8])
where_condition += " and fs_task.create_time >= '%s'" % (begin_time)
if(len(end_date) > 0):
end_time = '%s-%s-%s 00:00:00' % (end_date[0:4], end_date[4:6], end_date[6:8])
where_condition += " and fs_task.create_time < '%s'" % (end_time)
db = DB.db.DB_MYSQL()
db.connect(DB.db.DB_CONFIG.host, DB.db.DB_CONFIG.port, DB.db.DB_CONFIG.user, DB.db.DB_CONFIG.password, DB.db.DB_CONFIG.db)
#where_condition = " and fs_task.task_hash='92A20D164F8D5F18F2433E9CB39703E2A381EDDC'"
#sql = "select task_hash, create_time from fs_task where state!='dismissed' " + where_condition
#sql = "select t.task_hash, t.create_time, d.file_size from fs_task t, fs_dat_file d where t.task_hash=d.hashid and t.state!='dismissed' " + where_condition
sql = "select fs_task.task_hash, fs_task.create_time, fs_dat_file.file_size from fs_task LEFT JOIN fs_dat_file ON fs_task.task_hash=fs_dat_file.hashid where fs_task.state!='dismissed'" + where_condition
print sql
db.execute(sql)
for row in db.cur.fetchall():
task1 = {}
col_num = 0
for r in row:
if(col_num == 0):
task1['hash'] = r
elif(col_num == 1):
task1['online_time'] = r
elif(col_num == 2):
task1['filesize'] = r
col_num += 1
task_list.append(task1)
db.close()
return task_list
def Leer():
a = db.connect("select * from Jugador")
lista = []
listaEquipos = equipo.Leer()
for b in a:
for c in listaEquipos:
if c.id_equipo == b['Equipo']:
j = jugador(b['Dni'], b['Nombre'], b['Apellido'],
b['Sueldo'], b['Fecha_nac'], b['Nacionalidad'],
c, b['Posicion'])
lista.append(j)
return lista
def MenuDelete(self):
print('---------MENU---------')
print('|1) Liga |')
print('|2) Equipo |')
print('|3) Jugador |')
print('|4) DT |')
print('|5) Todo |')
print('----------------------')
a = int(input())
if a == 1:
self.MostrarLiga()
b = int(input('Inserte el id de la liga'))
ligas = liga.Leer()
for c in ligas:
if b == c.id_liga:
c.Borrar()
if a == 2:
self.MostrarEquipo()
b = int(input('Inserte el id del Equipo'))
equipos = equipo.Leer()
for c in equipos:
if b == c.id_equipo:
c.Borrar()
if a == 3:
self.MostrarJugador()
b = int(input('Inserte el dni del Jogadore'))
jugadores = jugador.Leer()
for c in jugadores:
if b == c.dni:
c.Borrar()
if a == 4:
self.MostrarDT()
b = int(input('Inserte el dni del DT'))
Dts = dt.Leer()
for c in Dts:
if b == c.dni:
c.Borrar()
if a == 5:
a = db.connect('delete from Liga;')
self.MENU()
def get_cold_tasks_rule1(platform):
task_list = []
db = DB.db.DB_MYSQL()
db.connect(DB.db.MS_DB_CONFIG.host, DB.db.MS_DB_CONFIG.port, DB.db.MS_DB_CONFIG.user, DB.db.MS_DB_CONFIG.password, DB.db.MS_DB_CONFIG.db)
sql = "SELECT hash, online_time, is_valid, filesize, hot, cold1, cold2, cold3, last_hit_time, total_hits_num FROM %s_task ORDER BY cold1 ASC, hot ASC" % (platform)
print sql
db.execute(sql)
for row in db.cur.fetchall():
task1 = {}
col_num = 0
for r in row:
if(col_num == 0):
task1['hash'] = r
elif(col_num == 1):
task1['online_time'] = r
elif(col_num == 2):
task1['is_valid'] = r
elif(col_num == 3):
task1['filesize'] = r
elif(col_num == 4):
task1['hot'] = r
elif(col_num == 5):
task1['cold1'] = r
elif(col_num == 6):
task1['cold2'] = r
elif(col_num == 7):
task1['cold3'] = r
elif(col_num == 8):
task1['last_hit_time'] = r
elif(col_num == 9):
task1['total_hits_num'] = r
col_num += 1
task_list.append(task1)
return task_list
def Actualizar(self):
a = db.connect(
"update Equipo set Fundacion = '%s' , Nombre = '%s' where Id_Equipo = %s;"
% (self.fundacion, self.nombre, self.id_equipo))
def Insert(self):
a = db.connect("INSERT INTO `mydb`.`DT` (`Dni`, `Nombre`, `Apellido`, `Sueldo`, `Fecha_nac`, `Nacionalidad`, "
"`Equipo`) VALUES (%s,'%s','%s','%s','%s','%s',%s);"
% (self.dni,self.nombre,self.apellido,self.sueldo,self.fecha_nac,self.nacionalidad
,self.equipo))
def Borrar(self):
a = db.connect("delete from Liga where Id_Liga = %s" % (self.id_liga))
def Borrar(self):
a = db.connect("delete from DT where Dni = %s" % self.dni)
def Actualizar(self):
a = db.connect("update DT set Nombre = '%s' ,Apellido = '%s' ,Sueldo = %s ,Fecha_nac = '%s' ,"
"Nacionalidad = '%s' ,Equipo = %s where Dni = %s;" %
(self.nombre,self.apellido,self.sueldo,self.fecha_nac,
self.nacionalidad,self.equipo,self.dni))
def Actualizar(self):
a = db.connect(
"update Liga set Pais = '%s' , Division = '%s' , Cant_descensos = %s , Nombre = '%s' where "
"Id_Liga = %s ; " % (self.pais, self.division, self.cant_descensos,
self.nombre, self.id_liga))
def Borrar(self):
a = db.connect("delete from Jugador where Dni = %s ;" % self.dni)
def Insert(self):
a = db.connect(
"INSERT INTO `mydb`.`Liga` (`Pais`, `Id_Liga`, `Division`, `Cant_descensos`, `Nombre`) VALUES ('%s',%s,'%s',%s,'%s')"
% (self.pais, self.id_liga, self.division, self.cant_descensos,
self.nombre))
def Insert(self):
a = db.connect(
"INSERT INTO `mydb`.`Equipo` (`Id_Equipo`, `Liga`, `Fundacion`, `Nombre`) VALUES (%s,%s,'%s','%s')"
% (self.id_equipo, self.liga, self.fundacion, self.nombre))
def Borrar(self):
a = db.connect("delete from Equipo where Id_Equipo = %s" %
(self.id_equipo))
