def insertpositionforce(self,key_word_id,position,day,month,year):
     '''Insert position yandex output (force)'''
     self.cursor.execute("SELECT * FROM positions WHERE key_word_id = '" + str(key_word_id) + "' AND position = '" + str(position) + "' AND day = '" + day + "' AND month = '" + month + "' AND year = '" + year + "'")
     if MysqlProvider._getrowcount(self)==0:
         self.cursor.execute("INSERT INTO positions SET key_word_id = '" + str(key_word_id) + "',position = '" + str(position) + "',day = '" + day + "',month = '" + month + "',year = '" + year + "'")
     else:
         result=self.cursor.fetchall()
         id=result[0]['id']
         self.cursor.execute("UPDATE positions SET key_word_id = '" + str(key_word_id) + "',position = '" + str(position) + "',day = '" + day + "',month = '" + month + "',year = '" + year + "' WHERE id="+id)     
 def geiipfromcity(self,city_id):
     '''Get IP-address around the city'''
     sql="SELECT ip FROM `ip_addresses` WHERE city_id=%s ORDER BY RAND() LIMIT 1" %city_id
     self.cursor.execute(sql)
     result=self.cursor.fetchall()
     if MysqlProvider._getrowcount(self)==0:
         sql="SELECT ip FROM `ip_addresses` ORDER BY RAND() LIMIT 1"
         self.cursor.execute(sql)
         result=self.cursor.fetchall()
     return result[0]['ip']
Example #3
0
 def geiipfromcity(self, city_id):
     '''Get IP-address around the city'''
     sql = "SELECT ip FROM `ip_addresses` WHERE city_id=%s ORDER BY RAND() LIMIT 1" % city_id
     self.cursor.execute(sql)
     result = self.cursor.fetchall()
     if MysqlProvider._getrowcount(self) == 0:
         sql = "SELECT ip FROM `ip_addresses` ORDER BY RAND() LIMIT 1"
         self.cursor.execute(sql)
         result = self.cursor.fetchall()
     return result[0]['ip']
Example #4
0
 def insertposition(self, key_word_id, position, day, month, year):
     '''Insert position google output'''
     self.cursor.execute(
         "SELECT * FROM google_positions WHERE key_word_id = '" +
         str(key_word_id) + "' AND position = '" + str(position) +
         "' AND day = '" + day + "' AND month = '" + month +
         "' AND year = '" + year + "'")
     if MysqlProvider._getrowcount(self) == 0:
         self.cursor.execute(
             "INSERT INTO google_positions SET key_word_id = '" +
             str(key_word_id) + "',position = '" + str(position) +
             "',day = '" + day + "',month = '" + month + "',year = '" +
             year + "'")
Example #5
0
 def insertpositionforce(self, key_word_id, position, day, month, year):
     '''Insert position google output (force)'''
     self.cursor.execute(
         "SELECT * FROM google_positions WHERE key_word_id = '" +
         str(key_word_id) + "' AND position = '" + str(position) +
         "' AND day = '" + day + "' AND month = '" + month +
         "' AND year = '" + year + "'")
     if MysqlProvider._getrowcount(self) == 0:
         GoogleMysqlProvider.insertposition(self, key_word_id, position,
                                            day, month, year)
     else:
         result = self.cursor.fetchall()
         id = result[0]['id']
         self.cursor.execute("UPDATE google_positions SET key_word_id = '" +
                             str(key_word_id) + "',position = '" +
                             str(position) + "',day = '" + day +
                             "',month = '" + month + "',year = '" + year +
                             "' WHERE id=" + id)
 def insertposition(self,key_word_id,position,day,month,year):
     '''Insert position google output'''
     self.cursor.execute("SELECT * FROM google_positions WHERE key_word_id = '" + str(key_word_id) + "' AND position = '" + str(position) + "' AND day = '" + day + "' AND month = '" + month + "' AND year = '" + year + "'")
     if MysqlProvider._getrowcount(self)==0:
         self.cursor.execute("INSERT INTO google_positions SET key_word_id = '" + str(key_word_id) + "',position = '" + str(position) + "',day = '" + day + "',month = '" + month + "',year = '" + year + "'")