def __init__(self):
self.cam_anio = 0 # 4 digitos
self.cam_num = 0 # 4 digitos
self.numero = 0 # 4 digitos
self.fecha = ''
self.comentario = ''
self.db = DBConn()
def __init__(self):
self.ecam_anio = 0
self.ecam_num = 0
self.env_num = 0
self.env_fecha = "0000-00-00"
self.env_monto = 0.0
self.db = DBConn()
def __init__(self):
self.idpersona = ''
self.nombre = ''
self.apellido = ''
self.dni = 0
self.fecha_nacimiento = ''
self.db = DBConn()
def __init__(self):
self.icam_anio = 0
self.icam_num = 0
self.i_numero = 0
self.i_fecha = ""
self.i_monto = 0.0
self.i_concepto = ""
self.db = DBConn()
def __init__(self):
self.dni = ''
self.nombre = ''
self.apellidos = ''
self.genero = ''
self.direccion = ''
self.fNacimiento = ''
self.codPostal = ''
self.db = DBConn()
def __init__(self):
self.mcam_anio = 0
self.mcam_num = 0
self.mcaj_numero = 0
self.mov_numero = 0
self.mov_monto = 0.0
self.mov_tipo = 0 #1:ingresos varios; 2:egresos varios
self.mov_comentario = ""
self.db = DBConn()
def __init__(self):
self.anio = 0 #hasta 4 digitos
self.num = 0 #hasta 4 digitos
self.cli_codigo = ''
self.inicio = '' #fecha
self.fin = '' #fecha
self.comentario = '' #hasta 700 caracteres
self.usuario = 0
self.db = DBConn()
def __init__(self):
self.mcam_anio = 0
self.mcam_num = 0
self.mcaj_numero = 0
self.mcli_codigo = ""
self.movcli_monto = 0.0
self.movcli_entregado = 0
self.movcli_forma_pago = 0
self.movcli_diferencia = 0.0
self.db = DBConn()
def __init__(self):
self.cam_anio = 0
self.cam_num = 0
self.lis_numero = 0
self.cli_codigo = ''
self.deuda = 0.0
self.cant = 0 # De 0 a 99
self.camp = ""
self.entregado = '0000/00/00' #0000/00/00: No entregado
self.forma_pago = 0 #0: No pagado; 1:Efectivo; 2:Boleta; 3:Oficina
self.medio_entr = 0 #0; 1:Caja; 2:Envio
self.rebote = "#$NINGUNO$#"
self.db = DBConn()
def __init__(self):
self.anio = 0 #hasta 4 digitos
self.num = 0 #hasta 4 digitos
self.cli_codigo = ''
self.inicio = '' #fecha
self.ini_reparto = '' # fecha de inicio de reparto
self.fin_reparto = '' # fecha de fin de reparto
self.base = 0.00 # base de distribucion
self.parametro = 0.00 # distribucion = (pedidos a cobrar) x parametro + base
self.diferencia = 0.00 # monto de diferencia con campania anterior
self.fin = '' #fecha
self.comentario = '' #hasta 700 caracteres
self.usuario = 0
self.db = DBConn()
def load_items(start=0, num=-1):
if num == -1:
num = int(1e8)
LOAD_SQL = "SELECT domain FROM {TABLE_NAME} " \
"WHERE {constraint} LIMIT {START},{LIMIT}" \
"".format(TABLE_NAME=LOAD_SQL_TABLE,constraint="result_flag is null",START=start,LIMIT=num) # sql语句导出数据
db = DBConn()
db.get_mysql_conns(num=1)
db.exec_sql(LOAD_SQL)
result = db.mysql_cur.fetchall()
items = [item[0] for item in result]
db.close_mysql_conns()
print "load %s items" % len(items)
return items
def __init__(self): self.codigo = "" self.apenom = "" self.zona = "" self.domicilio = "" self.telefonos = "" self.barrio = "" self.localidad = "" self.seccion = "" self.descripcion = "" self.referencia = 0 # 0: Sale a reparto; 1: R/D; 2: N/S self.crut_id = 0 self.orden = 0 self.estado = 0 self.alta = "" self.baja = "" self.db = DBConn()
def task(process_id, share_q):
print 'Run task %s (%s)...' % (process_id, os.getpid())
UPDATE_SQL = "UPDATE {TABLE_NAME} SET result_flag=%s,illegal_type=%s WHERE domain=%s".format(
TABLE_NAME=UPDATE_SQL_TABLE)
start = time.time()
db = DBConn()
db.get_mysql_conns(num=1)
dt = DetectionTools('tencent')
count = 0
while (isinstance(share_q, list)
and len(share_q)) or (hasattr(share_q, 'empty')
and not share_q.empty()):
count += 1
if isinstance(share_q, list):
item = share_q.pop(0)
else:
item = share_q.get()
domain = item
print "{0}:{1}".format(count, domain)
result = dt.main(domain)
if result == "未知".decode("utf8"):
is_illegal = -1
elif result == "安全".decode("utf8"):
is_illegal = 0
else:
is_illegal = 1
print "this domain is a %s website" % result
db.exec_sql(UPDATE_SQL, data=(is_illegal, result, domain))
print count
if count % 10 == 0:
print "commit %d records" % count
db.mysql_conn.commit()
print "commit %d records" % count
db.mysql_conn.commit()
db.close_mysql_conns()
dt.destory_driver()
del dt, db
end = time.time()
print 'Task %s runs %0.2f seconds.' % (process_id, (end - start))
def __init__(self):
self.usuario = ''
self.clave = ''
self.tipo = ''
self.estado = 1
self.db = DBConn()
def __init__(self):
self.id = 0
self.pais = ''
self.abbr = ''
self.db = DBConn()
def __init__(self):
self.db = DBConn()
def __init__(self):
self.id = 0
self.fullname = ""
self.phone = ""
self.mail = ""
self.db = DBConn()
def __init__(self):
self.tipo = ""
self.descripcion = ""
self.estado = 1
self.db = DBConn()
def __init__(self):
self.idpersona = 0
self.nombre = ''
self.apellido = ''
self.db = DBConn()
