def getLesson(): query = """ SELECT * FROM talk_lessons WHERE is_done = 0 """ return mysql.executeQuery(query)
def getSiteMonitor(monitor): query = """ SELECT site_id, ref_site_url, is_paid FROM site_monitor sm JOIN sites s ON s.id = sm.site_id AND s.is_scam = 0 WHERE sm.is_paid = 0 AND sm.monitor = '{0}' """.format(monitor) return mysql.executeQuery(query)
def getSiteMonitor(): query = """ SELECT site_id, ref_site_url, is_paid FROM site_monitor sm JOIN sites s ON s.id = sm.site_id AND s.is_scam = 0 WHERE sm.is_paid = 0 """ return mysql.executeQuery(query)
def getRcbSites(): query = """ select s.id, s.url, sm.monitor, sm.ref_site_url from sites s join site_monitor sm ON sm.site_id = s.id where s.is_stat = 1 AND s.is_scam=0 """ return mysql.executeQuery(query)
def updateIsAvailable(): print "RUN : updateIsAvailable()" # OR status = 'Enabled' query = """ SELECT id, url_source, is_available FROM {0} WHERE status = 'Approved' """.format(config.TABLE_PRODUCT) results = mysql.executeQuery(query) for row in results: status = util.checkURL(row[1]) if status != row[2]: setAvailable(row[0], status)