Coverage for gws-app/gws/lib/sa/__init__.py: 100%

1"""Convenience wrapper for SQLAlchemy imports. 

2 

3Re-exports everything from ``sqlalchemy``, together with ``sqlalchemy.exc`` as ``exc``, 

4``sqlalchemy.orm`` as ``orm`` and ``geoalchemy2`` as ``geo``. ``Error`` is an alias 

5for ``sqlalchemy.exc.SQLAlchemyError``. 

6 

7Example:: 

8 

9 import gws.lib.sa as sa 

10 

11 tab = sa.Table('places', sa.MetaData(), sa.Column('id', sa.Integer, primary_key=True)) 

12 geom_col = sa.Column('geom', sa.geo.Geometry('POINT', srid=3857)) 

13 try: 

14 ... 

15 except sa.Error: 

16 ... 

17""" 

18import sqlalchemy.exc 

19# noinspection PyUnresolvedReferences 

20from sqlalchemy import * 

21# noinspection PyUnresolvedReferences 

22import sqlalchemy.exc as exc 

23# noinspection PyUnresolvedReferences 

24import sqlalchemy.orm as orm 

25# noinspection PyUnresolvedReferences 

26import geoalchemy2 as geo 

27 

28Error = sqlalchemy.exc.SQLAlchemyError