• Get all rows when sourcetype isn’t given (by :source). Otherwise, get only rows where sourcetype is given
• Quick ref to SQLAlchemy
• Nếu DELETE mà doc ko tồn tại thì vẫn ok. Khi ấy result.rowcount ra 0 (cái này là row affected)
• Could not locate column in row for column 'status’
• After removing a row, the foreign IDs in other places will be automatically deleted (the tables related to the ID in this table will also be deleted)
• sqlalchemy.exc.ResourceClosedError: This result object is closed
• Convert a result to a list of dict
• Add a new column is_faq to the document table. If the create_date is after "2024-06-04" and the text column contains "Question: <any>, Answer: <any>", set is_faq to True; otherwise, set it to False.
• Only get column text if includeContent=true. If onlyFaqs=true, get all rows, otherwise, get only rows where is_faq=TRUE