官术网_书友最值得收藏!

Extras for geospatial support

Unfortunately, Exposed doesn't natively support PostGIS functionality such as geometry types or geospatial requests. This is an excellent opportunity to use Extension functions by Kotlin and fill the missing support without modifying the original source.

Adding support for location

The location data for the message is in the form of coordinates. To store such a data structure in the database, we define PointColumnType to store and get the location data for the message:

     * It represents the point column type for Exposed
*/
class PointColumnType(private val srid: Int = 4326) : ColumnType()
{
override fun sqlType() = "GEOMETRY(Point, $srid)"
override fun valueFromDB(value: Any) = if (value is PGgeometry)
value.geometry else value
override fun notNullValueToDB(value: Any): Any {
if (value is Point) {
if (value.srid == Point.UNKNOWN_SRID) value.srid = srid
return PGgeometry(value)
}
return value
}
}

And add an Extension function to directly use Point Column in our Messages object:

    /**
* Extension function to get point column type from the table
*/
fun Table.point(name: String, srid: Int = 4326): Column<Point>
= registerColumn(name, PointColumnType())

Adding support for location-bound queries

One more extra geospatial functionality we need is firing SQL queries within a selected area of the map; that is a bounded box. For that we need to create an expression for the required column type, PGbox2d, which represents the bounded location:

    /**
* Special type to represent the box and if location of message
* is inside the specified box
*/
class WithinOp(private val expr1: Expression<*>, private val box:
PGbox2d) : Op<Boolean>() {
override fun toSQL(queryBuilder: QueryBuilder) =
"${expr1.toSQL(queryBuilder)} && ST_MakeEnvelope(${box.llb.x},
${box.llb.y}, ${box.urt.x}, ${box.urt.y}, 4326)"
}

And an Extension function to use the feature to check if the message is in the specified region:

    /**
* To check if the message location is within the specified box
area.
* Returns true if yes else false
*/
infix fun ExpressionWithColumnType<*>.within(box: PGbox2d):
Op<Boolean>= WithinOp(this, box)
主站蜘蛛池模板: 阿拉善左旗| 普格县| 永吉县| 磴口县| 台东市| 英德市| 嵊泗县| 来宾市| 福海县| 利辛县| 沙坪坝区| 尉氏县| 万山特区| 银川市| 鄢陵县| 德庆县| 青冈县| 山东| 赤城县| 正蓝旗| 都兰县| 濮阳市| 汝阳县| 陵水| 龙州县| 怀仁县| 沾益县| 探索| 徐水县| 海原县| 龙口市| 景泰县| 宜城市| 秀山| 诸暨市| 武宣县| 镇远县| 达拉特旗| 寿宁县| 甘德县| 盱眙县|