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)