コード例 #1
0
 def closed(self, reason):
     db = OracleStore()
     conn = db.get_connection()
     sql = '''update t_spider_state set contentstate = 1'''
     db.insert_operation(conn, sql)
     #logger.info('------keyweibocontent_spider closed------')
     print '------keyweibocontent_spider closed------'
コード例 #2
0
    def closed(self,reason):
        db = OracleStore();conn = db.get_connection()
        cur = conn.cursor()
        for key in self.atuser_dict.keys(): #插入@用户uid信息
            sql= """update t_user_weibocontent_atuser set atuserID = %s where userID = %s and atuser = '******'""" % (self.atuser_dict.get(key),self.uid,key)
            cur.execute(sql)
            conn.commit()

        sql = '''update t_spider_state set contentstate = 1'''
        db.insert_operation(conn,sql)
        print '------weibocontent_info_spider closed------'                                                                                                               
コード例 #3
0
    def closed(self, reason):
        db = OracleStore()
        conn = db.get_connection()
        cur = conn.cursor()
        for key in self.atuser_dict.keys():  #插入@用户uid信息
            sql = """update t_user_weibocontent_atuser set atuserID = %s where userID = %s and atuser = '******'""" % (
                self.atuser_dict.get(key), self.uid, key)
            cur.execute(sql)
            conn.commit()

        sql = '''update t_spider_state set contentstate = 1'''
        db.insert_operation(conn, sql)
        print '------weibocontent_info_spider closed------'
コード例 #4
0
 def closed(self, reason):
     db = OracleStore()
     conn = db.get_connection()
     sql = 'update t_spider_state set searchstate=1'
     db.insert_operation(conn, sql)
     print '------keyuser_spider closed------'
コード例 #5
0
 def closed(self,reason):
     db = OracleStore();conn = db.get_connection()
     sql = 'update t_spider_state set userinfostate = 1'
     db.insert_operation(conn,sql)
     print '------userinfo_list_spider closed------'
コード例 #6
0
 def closed(self,reason):
     db = OracleStore();conn = db.get_connection()
     sql = '''update t_spider_state set contentstate = 1'''
     db.insert_operation(conn,sql)
     #logger.info('------keyweibocontent_spider closed------')                                                                                                                 
     print '------keyweibocontent_spider closed------'