Method insert

buzz/db/dao/dao.py:20–35

(self, record: T)

        self.table = table

    def insert(self, record: T):
        query = self._create_query()
        fields = [
            field for field in record.__dict__.keys() if field not in self.ignore_fields
        ]
        query.prepare(
            f"""
            INSERT INTO {self.table} ({", ".join(fields)})
            VALUES ({", ".join([f":{key}" for key in fields])})
        """
        )
        for field in fields:
            query.bindValue(f":{field}", getattr(record, field))

        if not query.exec():
            raise Exception(query.lastError().text())

    def find_by_id(self, id: Any) -> T | None:
        query = self._create_query()