from fw import rds

class Setting:
    def __init__(self,record):
        self.id=record['id']
        self.category=record['category']
        self.setting=record['setting']
        self.value=record['value']
        self.status=record['status']
        return

class Settings:
    def get(self,category,setting):
        sql="SELECT * FROM settings WHERE category=%s and setting=%s and status=0;"
        params=(str(category),str(setting))
        records=rds.executeSQL(sql, params)
        
        if len(records)==0:
            return None
        
        dataset=[]
        for record in records:
            data=Setting(record)
            dataset.append(data)
        
        return dataset

    def first(self,category,setting):
        sql="SELECT * FROM settings WHERE category=%s and setting=%s and status=0;"
        params=(str(category),str(setting))
        records=rds.executeSQL(sql, params)
        
        if len(records)==0:
            return None
        
        record=records[0]
        data=Setting(record)
        
        return data