/sys2do/handlers/AdminHandler.py

# -*- coding: utf-8 -*-

import logging, traceback

from urllib import urlencode

from datetime import datetime as dt

import tornado.web

from tornado.httpclient import AsyncHTTPClient

from webhelpers.paginate import Page

from sqlalchemy import or_, and_



from sys2do.model import *

from MethodDispatcher import MethodDispatcher

from sys2do.util.taobao import TaoBao

from sys2do import setting





class AdminHandler(MethodDispatcher):

    def index(self, **kw):

        self.render("admin/index.html")







    def taobao_add(self):

        self.render("admin/taobao.html")



    @tornado.web.asynchronous

    def taobao_save(self, **kw):

        if kw["type"] == "nickname":

            self._by_nickname(kw["value"], kw["page"])



    def _by_nickname(self, nickname, page):

        page_size = 50



        fields1 = ["num_iid", "title", "nick", "pic_url", "cid", "price", "type", "delist_time", "post_fee"]

        fields2 = ["num_iid", "title", "nick", "type", "props_name",

                  "cid", "seller_cids", "props", "pic_url", "num", "valid_thru", "list_time",

                  "delist_time", "stuff_status", "price", "post_fee", "express_fee", "ems_fee",

                  "has_discount", "freight_payer", "has_invoice", "has_warranty", "modified",

                  "approve_status", "sell_promise", "desc", "item_img", "prop_img", "has_showcase"]

        params1 = dict(

                    method = 'taobao.items.get',

                    nicks = nickname,

                    fields = ",".join(fields1),

                    page_size = page_size,

                    page_no = page

                    )



        def _getItemDetail(data):

            try:

                info = data["item_get_response"]["item"]

                try:

                    t = DBSession.query(Item).filter(Item.num_iid == info["num_iid"]).one()

                    for f in fields2:

                        if f in ["delist_time", "list_time", "modified", "created"] :

                            setattr(t, f, dt.strptime(info[f], "%Y-%m-%d %H:%M:%S"))

                        elif f == "item_img" :

                            if info["item_imgs"]: setattr(t, f, "|".join([img["url"] for img in info["item_imgs"]["item_img"]]))

                        elif f == "prop_img":

                            if info["item_imgs"]: setattr(t, f, "|".join([img["url"] for img in info["prop_imgs"]["prop_img"]]))

                        else:

                            setattr(t, f, info[f])

                except:

                    params = {}

                    for f in fields2:

                        if f in ["delist_time", "list_time", "modified", "created"] : params[f] = dt.strptime(info[f], "%Y-%m-%d %H:%M:%S")

                        elif f == "item_img" :

                            if info["item_imgs"]: params[f] = "|".join([img["url"] for img in info["item_imgs"]["item_img"]])

                        elif f == "prop_img":

                            if info["item_imgs"]: params[f] = "|".join([img["url"] for img in info["prop_imgs"]["prop_img"]])

                        else : params[f] = info[f]

                    DBSession.add(Item(**params))

            except:

                logging.error(traceback.print_exc())



        def _getLastItemDetail(data):

            _getItemDetail(data)

            DBSession.commit()

            self.render("admin/taobao_result.html")





        def _getItemList(data):

            logging.info("--------- response start -------------")

            items = data["items_get_response"]["items"]["item"]

#            items = [{"num_iid":"9257172491"}]

            for index, item in enumerate(items):

                p = {

                    "method" : "taobao.item.get",

                    "nick" : nickname,

                    "num_iid" : item["num_iid"],

                    "fields" : ",".join(fields2)

                    }



                if index == len(items) - 1 : tmp = TaoBao(p, callback = _getLastItemDetail)

                else :tmp = TaoBao(p, callback = _getItemDetail)

                tmp.fetch()

#                params = {}

#                for f in fields : 

#                    if f == "delist_time" : params[f] = dt.strptime(item[f],"%Y-%m-%d %H:%M:%S")

#                    else : params[f] = item[f]

#                DBSession.add(Item(**params))



#            DBSession.commit()

#            logging.info("\n".join(ids))



        t = TaoBao(params1, callback = _getItemList)

        t.fetch()