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)
