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)
def updateIsAvailable():
print "RUN : updateIsAvailable()"
query = """
SELECT id, url_source, is_available FROM {0}
WHERE status = 'Approved' OR status = 'Enabled'
""".format(config.TABLE_PRODUCT)
try:
print query
cursor.execute(query)
results = cursor.fetchall()
for row in results:
status = util.checkURL(row[1])
if status != row[2]:
setAvailable(row[0], status)
except Exception as e:
print(e)
