API reference

This chapter explains the complete API of Pandemy.

Pandemy consists of two main classes: DatabaseManager and SQLContainer. Each SQL dialect is implemented as a subclass of DatabaseManager. The SQLContainer serves as a container of the SQL statements used by the DatabaseManager of an application.

Table of contents

• DatabaseManager
  • DatabaseManager
    • DatabaseManager.delete_all_records_from_table()
    • DatabaseManager.execute()
    • DatabaseManager.load_table()
    • DatabaseManager.manage_foreign_keys()
    • DatabaseManager.merge_df()
    • DatabaseManager.save_df()
    • DatabaseManager.upsert_table()
  • SQLiteDb
    • SQLiteDb.conn_str
    • SQLiteDb.manage_foreign_keys()
  • OracleDb
    • OracleDb.from_url()
    • OracleDb.from_engine()
• SQLContainer
  • SQLContainer
    • SQLContainer.replace_placeholders()
  • Placeholder
• Exceptions
  • PandemyError
  • InvalidInputError
  • DatabaseManagerError
  • CreateConnectionURLError
  • CreateEngineError
  • DatabaseFileNotFoundError
  • DataTypeConversionError
  • DeleteFromTableError
  • ExecuteStatementError
  • InvalidColumnNameError
  • InvalidTableNameError
  • LoadTableError
  • SaveDataFrameError
  • SetIndexError
  • SQLStatementNotSupportedError
  • TableExistsError
• Attributes
  • __versiontuple__
  • __version__
  • __releasedate__