Skip to main content

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

Metadata

Release files for sqlalchemy-mongobi 0.2.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sqlalchemy-mongobi 0.2.1
File Size Uploaded Provenance Actions
sqlalchemy_mongobi-0.2.1.tar.gz 3.6 kB Without provenance Details for sqlalchemy_mongobi-0.2.1.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for sqlalchemy-mongobi 0.2.1
File Interpreter ABI Platform Actions
sqlalchemy_mongobi-0.2.1-py3-none-any.whl Python 3 none any Details for sqlalchemy_mongobi-0.2.1-py3-none-any.whl

Total release size: 8.2 kB

Release files / sqlalchemy_mongobi-0.2.1.tar.gz

Download URL sqlalchemy_mongobi-0.2.1.tar.gz
Size 3.6 kB
Tags Source
SHA-256 checksum
How to use checksums
e04d16035bb19241f0a05afdf3196e040ec0c2f0880d56dc16139b82ab599f0c
BLAKE2b-256 checksum
How to use checksums
feaac14e2c98cefe5e556575f6f9e041627e09f93f808aaf02e6f7a8c95a7adc
Upload date
Uploaded using Trusted Publishing?
What is 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

Release files / sqlalchemy_mongobi-0.2.1-py3-none-any.whl

Download URL sqlalchemy_mongobi-0.2.1-py3-none-any.whl
Size 4.5 kB
Tags Python 3
SHA-256 checksum
How to use checksums
4c1459913f923e3035f361a014fdfd17e12e44f2ddd555fa7295d09492ece5c1
BLAKE2b-256 checksum
How to use checksums
df5a0a8098130152caddb238399d696c20794b97057605095cf7d2f66b729f84
Upload date
Uploaded using Trusted Publishing?
What is 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

Security for sqlalchemy-mongobi 0.2.1

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page