spider_baidutongji/test.py

import json
import util
import db
import db_items

if __name__ == "__main__":
    url = 'https://cbu01.alicdn.com/img/ibank/2017/157/725/4249527751_1185384007.jpg'
    # t = db.get_spider_task()
    goods = {
        'goods_no': '339944',
        'goods_name': '好商品',
        'supplier': '南阳'
    }
    desc_list = [
        "https://blog.csdn.net/tz_zs/article/details/78228542",
        "https://blog.csdn.net/tz_zs/article/details"
    ]
    # t = db.add_shop_goods(goods, desc_list)
    # t = db.add_goods_gallery(3, desc_list)
    # t = db.add_shop_attribute('颜色')
    # t = db.add_shop_goods_attr(3, 4, ["红色", "蓝色"])
    # t = db.add_shop_goods_sku(3, 33889)
    goods = {
        'img_header': "11",
        'img_desc': "11",
        'attr_leading': "11",
        'attr_sku': "11",
        'id': "1",
    }
    # t = db.update_spider_data(goods)
    str = "6901130400001"
    # t = str[0:8]
    url = "https://img.taobao.com/NewGualianyingxiao_4startFlag.gif"
    p = url.rindex(".")
    t = url[p + 1:]
    # if t != "jpg":
    # print(123)
    # print(t)
    # db.add_spider_other()
    # t = db.get_max_spu("平阳县艾维克按摩器材有限公司", "母婴")
    # db.add_shop_goods_sku(11, "永康市天诺工贸有限公司", "家装")
    # t = db.add_shop_attribute("颜色")
    # t = db_items.get_task_items()
    # t = db_items.update_task_items(1)
    goods = {
        'supplier': "是的",
        'category_first': "眼子",
        'url': 'http://bdfsds.com',
        'title': "哈哈"
    }
    # t = db_items.insert_spider_data(goods)

    t = db.get_max_spu("诸暨市大唐振首袜厂", "百货")
    print(t)