postgis 1.0.4

[](https://circleci.com/gh/yohanboniface/psycopg-postgis) [](https://pypi.python.org/pypi/psycopg-postgis) [](https://pypi.python.org/pypi/psycopg-postgis) [](https://pypi.python.org/pypi/psycopg-postgis) [](https://pypi.python.org/pypi/psycopg-postgis)

# python-postgis

psycopg2和asyncpg的PostGIS辅助工具。

## 安装

pip install postgis

如果您想安装编译版本，请首先安装`cython`

pip install cython
pip install postgis


## 使用

您需要注册扩展

# 使用psycopg2
> from postgis.psycopg import register
> register(connection)

# 使用asyncpg
> from postgis.asyncpg import register
> await register(connection)

然后您可以将Python几何实例传递给psycopg

> cursor.execute('INSERT INTO table (geom) VALUES (%s)', [Point(x=1, y=2, srid=4326)])

并且可以以Python几何实例的形式检索数据

> cursor.execute('SELECT geom FROM points LIMIT 1')
> geom = cursor.fetchone()[0]
> geom
<Point POINT(1.0 2.0)>


## 使用psycopg2的示例

> import psycopg2
> from postgis import LineString
> from postgis.psycopg import register
> db = psycopg2.connect(dbname="test")
> register(db)
> cursor.execute('CREATE TABLE IF NOT EXISTS mytable ("geom" geometry(LineString) NOT NULL)')
> cursor.execute('INSERT INTO mytable (geom) VALUES (%s)', [LineString([(1, 2), (3, 4)], srid=4326)])
> cursor.execute('SELECT geom FROM mytable LIMIT 1')
> geom = cursor.fetchone()[0]
> geom
<LineString LINESTRING(1.0 2.0, 3.0 4.0)>
> geom[0]
<Point POINT(1.0 2.0)>
> geom.coords
((1.0, 2.0), (3.0, 4.0))
> geom.geojson
{'coordinates': ((1.0, 2.0), (3.0, 4.0)), 'type': 'LineString'}
> str(geom.geojson)
'{"type": "LineString", "coordinates": [[1, 2], [3, 4]]}'


## 使用 asyncpg 的示例

from postgis.asyncpg import register
pool = await create_pool(**DB_CONFIG, loop=loop, max_size=100,
init=register)