Example #1
0
 def POST(self):
     post_data = web.input()
     fields_types = post_data.fields_types
     table_name = post_data.table_name
     print fields_types
     print table_name
     #post_data=web.input(name=[])
     CC.create_table(fields_types,table_name)
Example #2
0
 def GET(self,indexname):
     data = OS.get_data('gg', 'gt', indexname)
     print data
     result = CC.insert_data(json.loads(data),indexname)
     #CC.create_table(indexname,fieldswithtypes)
     #TODO
     return result
def initiate_cleaner():
    if cache_state == 0: return True
    table_names = ast.literal_eval(tables)

    while(True):
        for table in table_names:
            cleaning_time = datetime.datetime.now()
            logger.info("Cleaning time: {0}".format(cleaning_time))
            query = "DELETE FROM {0} WHERE expirydatetime <= '{1}'".format(table,cleaning_time)
            try:
                result = CC.delete_data(query)
                logger.info("{0} records deleted from {1}.".format(result,table))
                logger.info("Cleaning done!!!")
            except Exception, err:
                logger.error("Error cleaning tables!")
                logger.error(err)
        time.sleep(cache_cleaning_interval)