import psycopg2
from mobilitydb.psycopg import register
from mobilitydb.examples.db_connect import psycopg_connect
connection = None
try:
# Set the connection parameters to PostgreSQL
connection = psycopg_connect()
connection.autocommit = True
# Register MobilityDB data types
register(connection)
cursor = connection.cursor()
######################
# TBoolInst
######################
select_query = "select * from tbl_tboolinst order by k limit 10"
cursor.execute(select_query)
print("\n****************************************************************")
print("Selecting rows from tbl_tboolinst table\n")
rows = cursor.fetchall()
for row in rows:
print("key =", row[0])
print("tboolinst =", row[1])
if not row[1]:
import pytest
import psycopg2
import os
from mobilitydb import *
from mobilitydb.psycopg import register
db = psycopg2.connect(dbname=os.getenv('PGDATABASE', 'test'))
db.autocommit = True
register(db)
cur = db.cursor()
time_types = [TimestampSet, Period, PeriodSet]
box_types = [TBox, STBox]
duration_suffixes = ['Inst', 'I', 'Seq', 'S']
duration_types = ['INSTANT', 'INSTANTSET', 'SEQUENCE', 'SEQUENCESET']
temporal_types = [TBool, TInt, TFloat, TText, TGeomPoint, TGeogPoint]
def pytest_configure():
for time in time_types:
cur.execute(
'CREATE TABLE IF NOT EXISTS tbl_' + time.__name__.lower() +
'(timetype ' + time.__name__.lower() + ' NOT NULL);')
for box in box_types:
cur.execute(
'CREATE TABLE IF NOT EXISTS tbl_' + box.__name__.lower() +
'(box ' + box.__name__.lower() + ' NOT NULL);')
for ttype in temporal_types:
for suffix, duration in zip(duration_suffixes, duration_types):
cur.execute(
'CREATE TABLE IF NOT EXISTS tbl_' + ttype.__name__.lower() + suffix +
