def getSiteMonitorByRefSiteId(monitor, refSiteId):
query = """
SELECT ref_site_url
FROM site_monitor
WHERE monitor='{0}' AND ref_site_id='{1}'
""".format(monitor, refSiteId)
return mysql.executeScalar(query)
def getSiteId(url):
query = """
SELECT id FROM sites WHERE url = '{0}'
""".format(
url
)
return mysql.executeScalar(query)
def insertSite(obj):
query = """
SELECT id FROM sites WHERE url = '{0}'
""".format(obj['url'])
id = mysql.executeScalar(query)
if id == None:
query = """
INSERT INTO sites(url) values ('{0}')
""".format(obj['url'])
id = mysql.executeInsert(query)
return id
def countDeletedProducts():
util.logNow("RUN : countDeletedProducts()")
query = """
SELECT COUNT(*) FROM {0} WHERE is_deleted = 1
""".format(config.TABLE_PRODUCT)
return mysql.executeScalar(query)
