source: OpenRLabs-Git/deploy/rlabs-docker/web2py-rlabs/gluon/packages/dal/pydal/representers/sqlite.py

main
Last change on this file was 42bd667, checked in by David Fuertes <dfuertes@…>, 4 years ago

Historial Limpio

  • Property mode set to 100755
File size: 752 bytes
Line 
1from ..adapters.sqlite import SQLite, Spatialite
2from .base import SQLRepresenter, JSONRepresenter
3from . import representers, before_type, for_type
4
5
6@representers.register_for(SQLite)
7class SQLiteRepresenter(SQLRepresenter, JSONRepresenter):
8    pass
9
10
11@representers.register_for(Spatialite)
12class SpatialiteRepresenter(SQLRepresenter):
13    @before_type("geometry")
14    def geometry_extras(self, field_type):
15        srid = 4326
16        geotype, params = field_type[:-1].split("(")
17        params = params.split(",")
18        if len(params) >= 2:
19            schema, srid = params[:2]
20        return {"srid": srid}
21
22    @for_type("geometry", adapt=False)
23    def _geometry(self, value, srid):
24        return "ST_GeomFromText('%s',%s)" % (value, srid)
Note: See TracBrowser for help on using the repository browser.