Metadata-Version: 1.1
Name: sqlalchemy-hilo
Version: 0.1.0
Summary: HiLo primary key generators for sqlalchemy
Home-page: https://github.com/shosca/sqlalchemy-hilo
Author: UNKNOWN
Author-email: UNKNOWN
License: MIT
Description: # 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:
        
        ```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:
        ```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`:
        ```python
        class Entity(Base):
        
            id = Column(BigInteger(), HiLoGenerator(), primary_key=True)
            ...
        
        ```
        
        or
        
        ```python
        class Entity(Base):
        
            id = Column(BigInteger(), RowPerTableHiLoGenerator(), primary_key=True)
            ...
        
        ```
        
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
