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