User guide

This chapter explains the main concepts and use cases of Pandemy. It starts with a description about the core components of Pandemy: the DatabaseManager and SQLContainer classes. Thereafter the implemented SQL dialects are described.

Table of contents

• The DatabaseManager
  • SQL dialects
  • Core functionality
  • The SQLContainer
• SQLite
  • Initialization
    • Require the database to exist
  • The execute method
    • Parametrized SQL statements
    • Using transactions
  • Save a DataFrame to a table
  • Load a DataFrame from a table
    • Working with datetimes and timezones
  • Update and insert data into a table (upsert)
    • Using the dry_run parameter
  • Using the SQLContainer
    • Replace placeholders
• Oracle
  • Initialization
  • Merge a DataFrame into a table