Metadata-Version: 2.0
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
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:

```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)
    ...

```


