from fw import rds

class Name:
    def __init__(self,record):
        self.id=record[0]
        self.name_en=record[1]
        self.name_jp=record[2]
        self.num=record[3]
        self.status=record[4]
        return

class Names:
    def __init__(self):
        return

    def get(self,name_en):
        sql="SELECT * FROM names WHERE name_en= ? and status=0;"
        params=(str(name_en),)
        records=rds.executeSQL(sql,params)
        
        if len(records)==0:
            return None
        
        dataset=[]
        for record in records:
            data=Name(record)
            dataset.append(data)
        
        return dataset
    
    def first(self,name_en):
        sql="SELECT * FROM names WHERE name_en= ? and status=0;"
        params=(str(name_en),)
        records=rds.executeSQL(sql,params)
        
        if len(records)==0:
            return None
        
        record=records[0]
        data=Name(record)
        
        return data
    
    def new(self,name_en,name_jp):
        sql="INSERT INTO names (name_en,name_jp) VALUES(?,?);"
        params=(str(name_en),str(name_jp))
        result=rds.executeSQL(sql,params,True)
        
        return result
    
    def set(self,id,num):
        sql="UPDATE names SET num =? where id=?;"
        params=(str(num),str(id))
        result=rds.executeSQL(sql,params,True)
        
        return result