Metadata-Version: 2.0
Name: sqlalchemy-hilo
Version: 0.1.1
Summary: HiLo primary key generators for sqlalchemy
Home-page: https://github.com/shosca/sqlalchemy-hilo
Author: UNKNOWN
Author-email: UNKNOWN
License: MIT
Keywords: generator hilo sql sqlalchemy
Platform: UNKNOWN
Classifier: Intended Audience :: Developers
Classifier: Natural Language :: English
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3
Classifier: Development Status :: 2 - Pre-Alpha
Requires-Dist: six (==1.10.0)
Requires-Dist: SQLAlchemy (==1.1.3)
Requires-Dist: setuptools

SQLAlchemy HiLo PK Generator
============================

There are two flavors of the HiLo generator, ``HiLoGenerator`` and
``RowPerTableHiLoGenerator``. ``HiLoGenerator`` will create a single
column table to keep track of the ``hi`` value:

.. code:: sql

    CREATE TABLE single_hilo (
        next_hi BIGINT NOT NULL
    )

``RowPerTableHiLoGenerator`` will create a two column table to keep
track of the ``hi`` value per table per row:

.. code:: sql

    CREATE TABLE row_per_table_hilo (
            table_name VARCHAR(255) NOT NULL,
            next_hi BIGINT NOT NULL,
            PRIMARY KEY (table_name)
    )

You can use them in your models like any other ``Sequence``:

.. code:: python

    class Entity(Base):

        id = Column(BigInteger(), HiLoGenerator(), primary_key=True)
        ...

or

.. code:: python

    class Entity(Base):

        id = Column(BigInteger(), RowPerTableHiLoGenerator(), primary_key=True)
        ...



