X-Git-Url: https://us-delaporte.pagekite.me/gitweb/matrix-chore-bot.git/blobdiff_plain/68b00c8ecbd23b7eed4d0942aa8b45f89f2810e0..b602bd00cf0d253cc1d035333a39f0e884120bc5:/matrix_chore_bot/db.py diff --git a/matrix_chore_bot/db.py b/matrix_chore_bot/db.py index 315d279..a0eae22 100644 --- a/matrix_chore_bot/db.py +++ b/matrix_chore_bot/db.py @@ -13,7 +13,6 @@ DATE_FORMAT = '%Y-%m-%d' def today(): return dt.now().strftime(DATE_FORMAT) - logger = logging.getLogger(__name__) logging.basicConfig(filename='chore.log', encoding='utf-8', level=logging.DEBUG) @@ -36,14 +35,14 @@ def get_chore(session, chore_id): return session.exec(cmd).first() class Data(): - def __init__(self, db_file=None): - - if not db_file: - db_file = os.path.join(os.environ.get('MATRIX_DATA_DIR'), 'chores.db') + def __init__(self, db_file): self.file = db_file self.engine = self.get_engine() + def get_db_file(self): + return self.file + def get_engine(self): return create_engine(f"sqlite:///{self.file}") @@ -86,12 +85,23 @@ class Data(): cmd = select(Chore) chores = session.exec(cmd).all() if(not chores): - retuls.append('None Found') + results.append('None Found') for chore in chores: results.append(Data.check_chore(session, chore.id)) return results + def filter(self, term): + results = [] + for item in self.list(): + if term in item: + results.append(item) + + return results + + + + def add(self, name): try: with Session(self.engine) as session: