Skip to main content

A wrapper library for ORM-like SQL builder and executor

Project description

Algoseek Connector

Documentation Status example workflow

A wrapper library for ORM-like SQL builder and executor. The library provides a simple pythonic interface to algoseek datasets with custom data filtering/selection.

Supported Features

The following query operations on datasets are supported:

  • Selecting columns and arbitrary expressions based on columns
  • Filtering by column value/column expression
  • Grouping by column(s)
  • Sorting by column(s)
  • All common arithmetic, logical operations on dataset columns and function application
  • Fetching query results as a pandas DataFrame

Installation

algoseek-connector is available on the Python Package Index. Install it using the pip command:

pip install algoseek-connector

Documentation

Documentation is available here.

Dev installation

algoseek-connector is installed using Poetry.

A Makefile recipe is available to install the package in developer mode along with developer dependencies:

make dev-install

If make is not available, run:

poetry install --with dev,docs
pre-commit install

Testing

Refer to the README inside the tests directory.

Building the docs

The documentation is generated using the sphinx library. First, install the necessary dependencies with the following command:

poetry install --with docs

Build the documentation using the Makefile located in the docs directory:

make html

Publishing to pypi

In order to pubish a new package version to pypi:

  • update library version in pyproject.toml (note, we use semantic versioning with where version numbers correspond to major, minor and patch)
  • run poetry build to create a package
  • configure your pypi credentials for poetry with poetry config http-basic.pypi <username> <password>
  • run poetry publish to publish the library to PyPI

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

algoseek_connector-2.1.4.tar.gz (33.9 kB view hashes)

Uploaded Source

Built Distribution

algoseek_connector-2.1.4-py3-none-any.whl (43.9 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