CData Python Connector for BigCommerce

Build 21.0.7930

From SQLAlchemy

The CData Python Connector for BigCommerce includes a Dialect class that enables integration with SQLAlchemy. The following sections detail various aspects of this integration:

Connecting from SQLAlchemy

See Connecting to construct a URL with which SQLAlchemy loads and uses the appropriate connector automatically.

Reflecting metadata with SQLAlchemy

Reflecting Metadata shows how to model BigCommerce tables with mapped classes.

Querying Data from SQLAlchemy

Querying Data demonstrates how to use mapped classes to query the associated tables.

Updating Data from SQLAlchemy

The provider provides INSERT/UPDATE/DELETE functionality in SQLAlchemy. Updating Data shows how to affect the data in the data source by calling the session's "execute()" method.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930