Python DB 예제들

예제 #1

def updata_sql1(ids, cod_price_1, collection_time):
    try:
        man_db = mandb.DB()
        sql = "UPDATE tb_tm_pachong_data_1 set cod_price_1 = '" + cod_price_1 + "',collection_time = '" + collection_time + "' where pachong_data_id = " + ids + " ;"
        man_db.execute1(sql)
        print(" [ *** 更新商品信息 *** ] ")
    except Exception as e:
        print("error")

예제 #2

def get_tb_links1():
    try:
        man_db = mandb.DB()
        sql = "SELECT pachong_data_id,cod_link from tb_tm_pachong_data_1 WHERE pingtai = '淘宝' ;"
        print(sql)
        return_datas = man_db.execute_seles1(sql)
        return return_datas
    except Exception as e:
        print("error")

예제 #3

파일: input_data.py 프로젝트: mangenotwork/DataAcquisition

def adddata(listss):
	try:
		man_db = mandb.DB()
		sql = "INSERT INTO timu_2 ( njtype, tmtype, urls, tmdata, daandata, jiexi) \
					VALUES ('"+listss[0]+"', '"+listss[1]+"', '"+listss[2]+"', \
					'"+str(listss[3]).replace("'","\"")+"', '"+str(listss[4]).replace("'","\"")+"', '"+str(listss[5]).replace("'","\"")+"' );"
		man_db.execute(sql)
	except Exception as e:
		print(e)
		return adddata(listss)

예제 #4

파일: szys_list.py 프로젝트: mangenotwork/DataAcquisition

def get_allcount():
    while True:
        man_db = mandb.DB()
        sql = "\
	        select count(sydata_id) from sydata_dzys where fenlei = '人群' ;\
	    "

        return_datas = man_db.execute_seles1(sql)
        if return_datas != False:
            return return_datas[0][0]

예제 #5

파일: szys_list.py 프로젝트: mangenotwork/DataAcquisition

def get_rsc1(pgnumber):
    try:
        man_db = mandb.DB()
        sql = "\
        select sydata_id,title,fenlei from sydata_dzys where fenlei = '人群' LIMIT " + str(
            pgnumber * 100) + ",100;\
        "

        return_datas = man_db.execute_seles1(sql)
        return return_datas
    except Exception as e:
        return ""

예제 #6

파일: szys_list.py 프로젝트: mangenotwork/DataAcquisition

def get_ttys_data1(pgnumber):
    print(pgnumber)
    print(type(pgnumber))
    pgnumber = pgnumber * 20
    man_db = mandb.DB()
    sql = "\
		select tt.sydata_id, tt.fenlei, GROUP_CONCAT(ti.imgpath SEPARATOR '|') as link, tt.title \
		from sydata_ttys tt INNER JOIN sydata_ttys_imgs ti ON tt.sydata_id=substring(ti.sydata_id,5) \
		where tt.fenlei = '营养科普' \
		GROUP BY tt.sydata_id LIMIT " + str(pgnumber) + ",20; "
    return_datas = man_db.execute_seles1(sql)
    if return_datas != False:
        return return_datas

예제 #7

파일: szys_list.py 프로젝트: mangenotwork/DataAcquisition

def get_rsc(pgnumber):
    while True:
        try:
            man_db = mandb.DB()
            sql = "\
			select sydata_id,title,fenlei from sydata_dzys where fenlei = '人群' LIMIT " + str(
                pgnumber * 100) + ",100;\
			"

            return_datas = man_db.execute_seles1(sql)
            if return_datas != False:
                return return_datas
        except Exception as e:
            print("link Error")

예제 #8

파일: update_tm.py 프로젝트: mangenotwork/DataAcquisition

def updata_sql(ids,cod_price_1,collection_time):
    man_db = mandb.DB()
    sql = "UPDATE tb_tm_pachong_data_1 set cod_price_1 = '"+cod_price_1+"',collection_time = '"+collection_time+"' where pachong_data_id = "+ids+" ;"
    man_db.execute(sql)
    print(" [ *** 更新商品信息 *** ] ")






#for tbdata in get_tm_links():
#    print(tbdata[0])
#    print(tbdata[1])

    '''

예제 #9

파일: szys_list.py 프로젝트: mangenotwork/DataAcquisition

def get_ttys_data(pgnumber):
    while True:
        try:
            man_db = mandb.DB()
            sql = "\
				select tt.sydata_id, tt.fenlei, GROUP_CONCAT(ti.imgpath SEPARATOR '|') as link, tt.title \
				from sydata_ttys tt INNER JOIN sydata_ttys_imgs ti ON tt.sydata_id=substring(ti.sydata_id,5) \
				where tt.fenlei = '养生食谱' \
				GROUP BY tt.sydata_id \
				LIMIT " + str(int(pgnumber) * 20) + ",20;"
            return_datas = man_db.execute_seles1(sql)
            if return_datas != False:
                return return_datas
        except Exception as e:
            print("link Error")
            get_ttys_data(pgnumber)

예제 #10

 def wrapper(*args, **kwargs):
     man_db = mandb.DB()
     return func(man_db, *args, **kwargs)

예제 #11

def updata_sql(ids,cod_price_1,collection_time):
    man_db = mandb.DB()
    sql = "UPDATE jd_pachong_data_1 set cod_price_1 = '"+cod_price_1+"',collection_time = '"+collection_time+"' where pachong_data_id = "+ids+" ;"
    man_db.execute(sql)
    print(" [ *** 更新商品信息 *** ] ")

예제 #12

def get_jd_links():
    man_db = mandb.DB()
    sql ="SELECT pachong_data_id,cod_link from jd_pachong_data_1 where substring(collection_time, 7, 1) != '8' LIMIT 100000;"
    print(sql)
    return_datas = man_db.execute_seles(sql)
    return return_datas

예제 #13

def get_tb_links():
    man_db = mandb.DB()
    sql = "SELECT pachong_data_id,cod_link from tb_tm_pachong_data_1 WHERE pingtai = '淘宝'  and substring(collection_time, 7, 1) != '7';"
    print(sql)
    return_datas = man_db.execute_seles1(sql)
    return return_datas

예제 #14

파일: update_tm.py 프로젝트: mangenotwork/DataAcquisition

def get_tm_links():
    man_db = mandb.DB()
    sql ="SELECT pachong_data_id,cod_link from tb_tm_pachong_data_1 WHERE pingtai = '天猫' LIMIT 50;"
    print(sql)
    return_datas = man_db.execute_seles(sql)
    return return_datas