Skip to main content

Easy Python database interaction

Project description

easy_db

easy_db is a tool designed to quickly allow Python database interaction capabilities from a consolidated, simple user interface.

Current Features

  • DataBase class can handle both SQLite and Access file-based databases

    • To "connect" to a database, use:
      db = easy_db.DataBase('test_sqlite3_db.db')
      
    • Then, retrieve table names with:
      db.pull_all_table_names()
      
    • Run a "SELECT * ..." query on any table:
      db.pull_full_table('TEST_TABLE')
      
      • returned object is a list of dicts where each dict represents a row and is form {column: value}
      • pull_full_table uses functools.lru_cache to limit repetative database queries
  • For more fine-grained control of database work, theDataBase.provide_db_connection method is a decorator that can provide functions with a database connection (and cursor if specified). ```sh db = easy_db.DataBase('test_sqlite3_db.db')

    @db.provide_db_connection(also_cursor=True)
    def awesome_function(conn, cursor, x):
        data = cursor.execute('...SPECIAL SQL...').fetchall()
        conn.close()
        return data
    ```
    

License

MIT

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

easy_db-0.5.6.tar.gz (7.8 kB view hashes)

Uploaded Source

Built Distribution

easy_db-0.5.6-py3-none-any.whl (13.5 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page