Skip to main content

MongoDB connector for BI SQLAlchemy Dialect

Project description

MongoDB connector for BI SQLAlchemy dialect.

https://img.shields.io/pypi/v/sqlalchemy_mongobi.svg https://img.shields.io/travis/smarzola/sqlalchemy-mongobi.svg

MongoDB connector for BI does not have support for transactions but SQLAlchemy DBAPI layer uses ROLLBACKs after the connection initialization even if the connection pool is configured with reset_on_return=False. This dialect ignores COMMITs and ROLLBACKs, and uses the NullPool connection pool (which means no pooling, opens and closes the underlying DB-API connection per each connection open/close).

Usage

The DSN format is similar to that of mysql:

engine = create_engine(
    "mongobi://user?source=auth_db:password@url:port/database",
    connect_args={
        "ssl": {
            "mode": "PREFERRED"
        }
    },
    pool_reset_on_return=False,
)

DBAPI Support

The following DBAPI options are available:

  • mysqlclient:

    mongobi+mysqldb://user?source=auth_db:password@url:port/database
  • PyMySQL:

    mongobi+pymysql://user?source=auth_db:password@url:port/database

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

sqlalchemy_mongobi-0.2.1.tar.gz (3.6 kB view details)

Uploaded Source

Built Distribution

sqlalchemy_mongobi-0.2.1-py3-none-any.whl (4.5 kB view details)

Uploaded Python 3

File details

Details for the file sqlalchemy_mongobi-0.2.1.tar.gz.

File metadata

  • Download URL: sqlalchemy_mongobi-0.2.1.tar.gz
  • Upload date:
  • Size: 3.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.10.0 pkginfo/1.4.2 requests/2.19.1 setuptools/28.8.0 requests-toolbelt/0.8.0 tqdm/4.26.0 CPython/3.6.4

File hashes

Hashes for sqlalchemy_mongobi-0.2.1.tar.gz
Algorithm Hash digest
SHA256 e04d16035bb19241f0a05afdf3196e040ec0c2f0880d56dc16139b82ab599f0c
MD5 04f74b02254d1ef622d449b9b1b3e9b1
BLAKE2b-256 feaac14e2c98cefe5e556575f6f9e041627e09f93f808aaf02e6f7a8c95a7adc

See more details on using hashes here.

File details

Details for the file sqlalchemy_mongobi-0.2.1-py3-none-any.whl.

File metadata

  • Download URL: sqlalchemy_mongobi-0.2.1-py3-none-any.whl
  • Upload date:
  • Size: 4.5 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.10.0 pkginfo/1.4.2 requests/2.19.1 setuptools/28.8.0 requests-toolbelt/0.8.0 tqdm/4.26.0 CPython/3.6.4

File hashes

Hashes for sqlalchemy_mongobi-0.2.1-py3-none-any.whl
Algorithm Hash digest
SHA256 4c1459913f923e3035f361a014fdfd17e12e44f2ddd555fa7295d09492ece5c1
MD5 944cdaefd4e5992b4d155135df0f049e
BLAKE2b-256 df5a0a8098130152caddb238399d696c20794b97057605095cf7d2f66b729f84

See more details on using hashes here.

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