semvec/pypi-packages huggingface dataset:
db-query 1.3.0
Module for comfortable using of databases (tested for sqlite3)
License: MIT

# db_query
Python3 module for comfortable using of database (tested for sqlite3)

Usage:

    import db_query
    table = db_query.Table(sqlite3.connect('datebase.db'), 'tablename')
    table.where(column1=value1, column2=value2) # -> list of rows matching given equalities
    table.where(column1=(value11, value12), column2=value2) # -> executes 'SELECT * FROM tablename WHERE (column1 = value11 OR column1 = value12) AND column2 = value2' and returns result
    table.where_raw('column1 LIKE "val%1" AND column2 = "kek"') # "raw" sql query (beware of vulnerabilities)
    table(...) # -> table.where(...)
    table.insert(value1, value2, ...) # insert new row into table
    table.insert(column1=value1) # this also works - can be used if columns have default values
    table.where(...).select(column1, column2) # executes 'SELECT column1, column2 FROM tablename WHERE ...' (and returnes result)
    table.where(...).select() # -> table.where(...)
    table.where(...).column1 # -> [_[0] for _ in table.where(...).select('column1')]
    table.where(...)['column1'] # same
    table.where(...).update(column1=value1, column2=value2) # update table
    table.where(...).column1 = new_value # -> table.where(...).update(column1=new_value)
    table.where(...).delete() # delete matching rows
    table.delete(*args, **kwargs) # same
circleci 1.2.2
Python wrapper for the CircleCI API
License: MIT
Requires Python: >=3
Keywords: circleci ci cd api sdk

circleci.py
===========

Python Wrapper and SDK around the CircleCI API

.. image:: https://circleci.com/gh/levlaz/circleci.py.svg?style=shield
    :target: https://circleci.com/gh/levlaz/circleci.py
    :alt: CI Status

.. image:: https://codecov.io/gh/levlaz/circleci.py/branch/master/graph/badge.svg
    :target: https://codecov.io/gh/levlaz/circleci.py
    :alt: Code Coverage

.. image:: https://badge.fury.io/py/circleci.svg
    :target: https://badge.fury.io/py/circleci
    :alt: PyPi PAckage

.. image:: https://readthedocs.org/projects/circlecipy/badge/?version=latest
    :target: http://circlecipy.readthedocs.io/en/latest/?badge=latest
    :alt: Documentation Status

Warnings
========

* circleci.py does not yet fully support CircleCI 2.1 or the Workflows API

Features
========

1. Supports the `latest v1.1 of the CircleCI API <https://circleci.com/docs/api/v1-reference/>`__.
2. Supports both circleci.com and `CircleCI server <https://circleci.com/enterprise/>`__ (aka "Enterprise").
3. Experimental API endpoints using undocumented aspects of the API.

Installation
============

circleci.py requires Python 3. `Python 2 will be EOL <https://www.python.org/dev/peps/pep-0373/>`__ soon, it's time to make the switch.

::

    pip install circleci

Quickstart
==========

Make a `new API token <https://circleci.com/account/api>`__ in the CircleCI application.

Import the CircleCI API and start using methods:

::

    from circleci.api import Api

    circleci = Api("$YOUR_TOKEN")

    # get info about your user
    circleci.get_user_info()

    # get list of all of your projects
    circleci.get_projects()

* You can read the `general documentation <https://circlecipy.readthedocs.io/en/latest/?badge=latest>`_ for more information about using circleci.py.
* If you are interesting in hacking on this library, check out the `developer documentation <https://circlecipy.readthedocs.io/en/latest/dev.html>`_.

Real World Examples
===================

Here are a couple of real world examples of this library being used. If you want to add your example here, open up a PR.

* `Lambda Function to Deploy via CircleCI <https://github.com/launchdarkly/SupportService/blob/master/LdLambda.py>`_ -- in this example the library is used to trigger deployment jobs in response to a webhook that triggers an AWS Lambda Job via AWS API Gateway.

Contributing
============

Please create an issue with a description of your problem, or open a pull request with a fix.

License
=======

MIT

Original Author
===============

Lev Lazinskiy - `https://levlaz.org <https://levlaz.org>`_