async def test_tgeogpointinst_constructors(connection,
expected_tgeogpointinst):
params = TGeogPointInst(expected_tgeogpointinst)
await connection.execute(
'INSERT INTO tbl_tgeogpointinst (temp) VALUES ($1)', params)
result = await connection.fetchval(
'SELECT temp FROM tbl_tgeogpointinst WHERE temp=$1', params, column=0)
assert result == TGeogPointInst(expected_tgeogpointinst)
def test_tgeogpointinst_constructors(cursor, expected_tgeogpointinst):
if isinstance(expected_tgeogpointinst, tuple):
params = [TGeogPointInst(*expected_tgeogpointinst)]
else:
params = [TGeogPointInst(expected_tgeogpointinst)]
cursor.execute('INSERT INTO tbl_tgeogpointinst (temp) VALUES (%s)', params)
cursor.execute('SELECT temp FROM tbl_tgeogpointinst WHERE temp=%s', params)
result = cursor.fetchone()[0]
if isinstance(expected_tgeogpointinst, tuple):
assert result == TGeogPointInst(*expected_tgeogpointinst)
else:
assert result == TGeogPointInst(expected_tgeogpointinst)
def test_tgeogpointseq_accessors(cursor, expected_tgeogpointseq):
assert TGeogPointSeq(expected_tgeogpointseq).srid == 4326
assert TGeogPointSeq(expected_tgeogpointseq).tempSubtype() == 'Sequence'
assert TGeogPointSeq(expected_tgeogpointseq).getValues == LineString(
[Point(10.0, 10.0),
Point(20.0, 20.0),
Point(10.0, 10.0)])
assert TGeogPointSeq(expected_tgeogpointseq).startValue == Point(
10.0, 10.0)
assert TGeogPointSeq(expected_tgeogpointseq).endValue == Point(10.0, 10.0)
assert TGeogPointSeq(expected_tgeogpointseq).getTime == PeriodSet(
'{[2019-09-01 00:00:00+01, 2019-09-03 00:00:00+01]}')
assert TGeogPointSeq(expected_tgeogpointseq).duration == timedelta(2)
assert TGeogPointSeq(expected_tgeogpointseq).timespan == timedelta(2)
assert TGeogPointSeq(expected_tgeogpointseq).period == Period(
'[2019-09-01 00:00:00+01, 2019-09-03 00:00:00+01]')
assert TGeogPointSeq(expected_tgeogpointseq).numInstants == 3
assert TGeogPointSeq(
expected_tgeogpointseq).startInstant == TGeogPointInst(
'Point(10.0 10.0)@2019-09-01 00:00:00+01')
assert TGeogPointSeq(expected_tgeogpointseq).endInstant == TGeogPointInst(
'Point(10.0 10.0)@2019-09-03 00:00:00+01')
assert TGeogPointSeq(expected_tgeogpointseq).instantN(2) == TGeogPointInst(
'Point(20.0 20.0)@2019-09-02 00:00:00+01')
assert TGeogPointSeq(expected_tgeogpointseq).instants == \
[TGeogPointInst('Point(10.0 10.0)@2019-09-01 00:00:00+01'),
TGeogPointInst('Point(20.0 20.0)@2019-09-02 00:00:00+01'),
TGeogPointInst('Point(10.0 10.0)@2019-09-03 00:00:00+01')]
assert TGeogPointSeq(expected_tgeogpointseq).numTimestamps == 3
assert TGeogPointSeq(expected_tgeogpointseq).startTimestamp == parse(
'2019-09-01 00:00:00+01')
assert TGeogPointSeq(expected_tgeogpointseq).endTimestamp == parse(
'2019-09-03 00:00:00+01')
assert TGeogPointSeq(expected_tgeogpointseq).timestampN(2) == parse(
'2019-09-02 00:00:00+01')
assert TGeogPointSeq(expected_tgeogpointseq).timestamps == [
parse('2019-09-01 00:00:00+01'),
parse('2019-09-02 00:00:00+01'),
parse('2019-09-03 00:00:00+01')
]
assert TGeogPointSeq(expected_tgeogpointseq).intersectsTimestamp(
parse('2019-09-01 00:00:00+01')) == True
assert TGeogPointSeq(expected_tgeogpointseq).intersectsTimestamp(
parse('2019-09-04 00:00:00+01')) == False
assert TGeogPointSeq(expected_tgeogpointseq).intersectsTimestampSet(
TimestampSet(
'{2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01}')) == True
assert TGeogPointSeq(expected_tgeogpointseq).intersectsTimestampSet(
TimestampSet(
'{2019-09-04 00:00:00+01, 2019-09-05 00:00:00+01}')) == False
assert TGeogPointSeq(expected_tgeogpointseq).intersectsPeriod(
Period('[2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01]')) == True
assert TGeogPointSeq(expected_tgeogpointseq).intersectsPeriod(
Period('[2019-09-04 00:00:00+01, 2019-09-05 00:00:00+01]')) == False
assert TGeogPointSeq(expected_tgeogpointseq).intersectsPeriodSet(
PeriodSet(
'{[2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01]}')) == True
assert TGeogPointSeq(expected_tgeogpointseq).intersectsPeriodSet(
PeriodSet(
'{[2019-09-04 00:00:00+01, 2019-09-05 00:00:00+01]}')) == False
def test_tgeogpoints_accessors(cursor, expected_tgeogpoints):
assert TGeogPointS(expected_tgeogpoints).srid == 4326
assert TGeogPointS(expected_tgeogpoints).duration() == 'SequenceSet'
assert TGeogPointS(expected_tgeogpoints).getValues == \
GeometryCollection([Point(10.0, 10.0), LineString([Point(20.0, 20.0), Point(30.0, 30.0)])])
assert TGeogPointS(expected_tgeogpoints).startValue == Point(10.0, 10.0)
assert TGeogPointS(expected_tgeogpoints).endValue == Point(30.0, 30.0)
# assert TGeogPointS(expected_tgeogpoints).valueRange == geompointrange(Point(10.0, 10.0), Point(30.0, 30.0), upper_inc=True)
assert TGeogPointS(expected_tgeogpoints).getTime == PeriodSet(
'{[2019-09-01 00:00:00+01, 2019-09-01 00:00:00+01],[2019-09-02 00:00:00+01, 2019-09-03 00:00:00+01]}'
)
assert TGeogPointS(expected_tgeogpoints).timespan == timedelta(1)
assert TGeogPointS(expected_tgeogpoints).period == Period(
'[2019-09-01 00:00:00+01, 2019-09-03 00:00:00+01]')
assert TGeogPointS(expected_tgeogpoints).numInstants == 3
assert TGeogPointS(expected_tgeogpoints).startInstant == TGeogPointInst(
'Point(10.0 10.0)@2019-09-01 00:00:00+01')
assert TGeogPointS(expected_tgeogpoints).endInstant == TGeogPointInst(
'Point(30.0 30.0)@2019-09-03 00:00:00+01')
assert TGeogPointS(expected_tgeogpoints).instantN(2) == TGeogPointInst(
'Point(20.0 20.0)@2019-09-02 00:00:00+01')
assert TGeogPointS(expected_tgeogpoints).instants == [
TGeogPointInst('Point(10.0 10.0)@2019-09-01 00:00:00+01'),
TGeogPointInst('Point(20.0 20.0)@2019-09-02 00:00:00+01'),
TGeogPointInst('Point(30.0 30.0)@2019-09-03 00:00:00+01')
]
assert TGeogPointS(expected_tgeogpoints).numTimestamps == 3
assert TGeogPointS(expected_tgeogpoints).startTimestamp == parse(
'2019-09-01 00:00:00+01')
assert TGeogPointS(expected_tgeogpoints).endTimestamp == parse(
'2019-09-03 00:00:00+01')
assert TGeogPointS(expected_tgeogpoints).timestampN(2) == parse(
'2019-09-02 00:00:00+01')
assert TGeogPointS(expected_tgeogpoints).timestamps == [
parse('2019-09-01 00:00:00+01'),
parse('2019-09-02 00:00:00+01'),
parse('2019-09-03 00:00:00+01')
]
assert TGeogPointS(expected_tgeogpoints).numSequences == 2
assert TGeogPointS(expected_tgeogpoints).startSequence == TGeogPointSeq(
'[Point(10.0 10.0)@2019-09-01 00:00:00+01]')
assert TGeogPointS(expected_tgeogpoints).endSequence == TGeogPointSeq(
'[Point(20.0 20.0)@2019-09-02 00:00:00+01, Point(30.0 30.0)@2019-09-03 00:00:00+01]'
)
assert TGeogPointS(expected_tgeogpoints).sequenceN(2) == TGeogPointSeq(
'[Point(20.0 20.0)@2019-09-02 00:00:00+01, Point(30.0 30.0)@2019-09-03 00:00:00+01]'
)
assert TGeogPointS(expected_tgeogpoints).sequences == [
TGeogPointSeq('[Point(10.0 10.0)@2019-09-01 00:00:00+01]'),
TGeogPointSeq(
'[Point(20.0 20.0)@2019-09-02 00:00:00+01, Point(30.0 30.0)@2019-09-03 00:00:00+01]'
)
]
assert TGeogPointS(expected_tgeogpoints).intersectsTimestamp(
parse('2019-09-01 00:00:00+01')) == True
assert TGeogPointS(expected_tgeogpoints).intersectsTimestamp(
parse('2019-09-04 00:00:00+01')) == False
assert TGeogPointS(expected_tgeogpoints).intersectsTimestampset(
TimestampSet(
'{2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01}')) == True
assert TGeogPointS(expected_tgeogpoints).intersectsTimestampset(
TimestampSet(
'{2019-09-04 00:00:00+01, 2019-09-05 00:00:00+01}')) == False
assert TGeogPointS(expected_tgeogpoints).intersectsPeriod(
Period('[2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01]')) == True
assert TGeogPointS(expected_tgeogpoints).intersectsPeriod(
Period('[2019-09-04 00:00:00+01, 2019-09-05 00:00:00+01]')) == False
assert TGeogPointS(expected_tgeogpoints).intersectsPeriodset(
PeriodSet(
'{[2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01]}')) == True
assert TGeogPointS(expected_tgeogpoints).intersectsPeriodset(
PeriodSet(
'{[2019-09-04 00:00:00+01, 2019-09-05 00:00:00+01]}')) == False
def test_tgeogpointinst_accessors(cursor, expected_tgeogpointinst):
assert TGeogPointInst(expected_tgeogpointinst).srid == 4326
assert TGeogPointInst(expected_tgeogpointinst).duration() == 'Instant'
assert TGeogPointInst(expected_tgeogpointinst).getValue == Point(
10.0, 10.0)
assert TGeogPointInst(expected_tgeogpointinst).getValues == Point(
10.0, 10.0)
assert TGeogPointInst(expected_tgeogpointinst).startValue == Point(
10.0, 10.0)
assert TGeogPointInst(expected_tgeogpointinst).endValue == Point(
10.0, 10.0)
assert TGeogPointInst(expected_tgeogpointinst).getTimestamp == parse(
'2019-09-01 00:00:00+01')
assert TGeogPointInst(expected_tgeogpointinst).getTime == PeriodSet(
'{[2019-09-01 00:00:00+01, 2019-09-01 00:00:00+01]}')
assert TGeogPointInst(expected_tgeogpointinst).timespan == timedelta(0)
assert TGeogPointInst(expected_tgeogpointinst).period == Period(
'[2019-09-01 00:00:00+01, 2019-09-01 00:00:00+01]')
assert TGeogPointInst(expected_tgeogpointinst).numInstants == 1
assert TGeogPointInst(
expected_tgeogpointinst).startInstant == TGeogPointInst(
'Point(10.0 10.0)@2019-09-01 00:00:00+01')
assert TGeogPointInst(
expected_tgeogpointinst).endInstant == TGeogPointInst(
'Point(10.0 10.0)@2019-09-01 00:00:00+01')
assert TGeogPointInst(expected_tgeogpointinst).instantN(
1) == TGeogPointInst('Point(10.0 10.0)@2019-09-01 00:00:00+01')
assert TGeogPointInst(expected_tgeogpointinst).instants == [
TGeogPointInst('Point(10.0 10.0)@2019-09-01 00:00:00+01')
]
assert TGeogPointInst(expected_tgeogpointinst).numTimestamps == 1
assert TGeogPointInst(expected_tgeogpointinst).startTimestamp == parse(
'2019-09-01 00:00:00+01')
assert TGeogPointInst(expected_tgeogpointinst).endTimestamp == parse(
'2019-09-01 00:00:00+01')
assert TGeogPointInst(expected_tgeogpointinst).timestampN(1) == parse(
'2019-09-01 00:00:00+01')
assert TGeogPointInst(expected_tgeogpointinst).timestamps == [
parse('2019-09-01 00:00:00+01')
]
assert TGeogPointInst(expected_tgeogpointinst).intersectsTimestamp(
parse('2019-09-01 00:00:00+01')) == True
assert TGeogPointInst(expected_tgeogpointinst).intersectsTimestamp(
parse('2019-09-02 00:00:00+01')) == False
assert TGeogPointInst(expected_tgeogpointinst).intersectsTimestampset(
TimestampSet(
'{2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01}')) == True
assert TGeogPointInst(expected_tgeogpointinst).intersectsTimestampset(
TimestampSet(
'{2019-09-02 00:00:00+01, 2019-09-03 00:00:00+01}')) == False
assert TGeogPointInst(expected_tgeogpointinst).intersectsPeriod(
Period('[2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01]')) == True
assert TGeogPointInst(expected_tgeogpointinst).intersectsPeriod(
Period('(2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01]')) == False
assert TGeogPointInst(expected_tgeogpointinst).intersectsPeriod(
Period('[2019-09-02 00:00:00+01, 2019-09-03 00:00:00+01]')) == False
assert TGeogPointInst(expected_tgeogpointinst).intersectsPeriodset(
PeriodSet(
'{[2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01]}')) == True
assert TGeogPointInst(expected_tgeogpointinst).intersectsPeriodset(
PeriodSet(
'{(2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01]}')) == False
assert TGeogPointInst(expected_tgeogpointinst).intersectsPeriodset(
PeriodSet(
'{[2019-09-02 00:00:00+01, 2019-09-03 00:00:00+01]}')) == False
def test_tgeogpointi_accessors(cursor, expected_tgeogpointi):
assert TGeogPointI(expected_tgeogpointi).srid == 4326
assert TGeogPointI(expected_tgeogpointi).duration() == 'InstantSet'
assert TGeogPointI(expected_tgeogpointi).getValues == \
MultiPoint([Point(10.0, 10.0),Point(20.0, 20.0),Point(30.0, 30.0)])
assert TGeogPointI(expected_tgeogpointi).startValue == Point(10.0, 10.0)
assert TGeogPointI(expected_tgeogpointi).endValue == Point(30.0, 30.0)
assert TGeogPointI(expected_tgeogpointi).getTime == \
PeriodSet(
'{[2019-09-01 00:00:00+01, 2019-09-01 00:00:00+01], [2019-09-02 00:00:00+01, 2019-09-02 00:00:00+01], '
'[2019-09-03 00:00:00+01, 2019-09-03 00:00:00+01]}')
assert TGeogPointI(expected_tgeogpointi).timespan == timedelta(0)
assert TGeogPointI(expected_tgeogpointi).period == Period(
'[2019-09-01 00:00:00+01, 2019-09-03 00:00:00+01]')
assert TGeogPointI(expected_tgeogpointi).numInstants == 3
assert TGeogPointI(expected_tgeogpointi).startInstant == TGeogPointInst(
'Point(10.0 10.0)@2019-09-01 00:00:00+01')
assert TGeogPointI(expected_tgeogpointi).endInstant == TGeogPointInst(
'Point(30.0 30.0)@2019-09-03 00:00:00+01')
assert TGeogPointI(expected_tgeogpointi).instantN(2) == TGeogPointInst(
'Point(20.0 20.0)@2019-09-02 00:00:00+01')
assert TGeogPointI(expected_tgeogpointi).instants == [
TGeogPointInst('Point(10.0 10.0)@2019-09-01 00:00:00+01'),
TGeogPointInst('Point(20.0 20.0)@2019-09-02 00:00:00+01'),
TGeogPointInst('Point(30.0 30.0)@2019-09-03 00:00:00+01')
]
assert TGeogPointI(expected_tgeogpointi).numTimestamps == 3
assert TGeogPointI(expected_tgeogpointi).startTimestamp == parse(
'2019-09-01 00:00:00+01')
assert TGeogPointI(expected_tgeogpointi).endTimestamp == parse(
'2019-09-03 00:00:00+01')
assert TGeogPointI(expected_tgeogpointi).timestampN(2) == parse(
'2019-09-02 00:00:00+01')
assert TGeogPointI(expected_tgeogpointi).timestamps == [
parse('2019-09-01 00:00:00+01'),
parse('2019-09-02 00:00:00+01'),
parse('2019-09-03 00:00:00+01')
]
assert TGeogPointI(expected_tgeogpointi).intersectsTimestamp(
parse('2019-09-01 00:00:00+01')) == True
assert TGeogPointI(expected_tgeogpointi).intersectsTimestamp(
parse('2019-09-04 00:00:00+01')) == False
assert TGeogPointI(expected_tgeogpointi).intersectsTimestampset(
TimestampSet(
'{2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01}')) == True
assert TGeogPointI(expected_tgeogpointi).intersectsTimestampset(
TimestampSet(
'{2019-09-04 00:00:00+01, 2019-09-05 00:00:00+01}')) == False
assert TGeogPointI(expected_tgeogpointi).intersectsPeriod(
Period('[2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01]')) == True
assert TGeogPointI(expected_tgeogpointi).intersectsPeriod(
Period('(2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01)')) == False
assert TGeogPointI(expected_tgeogpointi).intersectsPeriod(
Period('[2019-09-04 00:00:00+01, 2019-09-05 00:00:00+01]')) == False
assert TGeogPointI(expected_tgeogpointi).intersectsPeriodset(
PeriodSet(
'{[2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01]}')) == True
assert TGeogPointI(expected_tgeogpointi).intersectsPeriodset(
PeriodSet(
'{(2019-09-01 00:00:00+01, 2019-09-02 00:00:00+01)}')) == False
assert TGeogPointI(expected_tgeogpointi).intersectsPeriodset(
PeriodSet(
'{[2019-09-04 00:00:00+01, 2019-09-05 00:00:00+01]}')) == False
PeriodSet(
'{[2019-09-02 00:00:00+01, 2019-09-03 00:00:00+01]}')) == False
@pytest.mark.parametrize('expected_tgeogpointi', [
'{Point(10.0 10.0)@2019-09-01 00:00:00+01, Point(20.0 20.0)@2019-09-02 00:00:00+01, '
'Point(10.0 10.0)@2019-09-03 00:00:00+01}',
'SRID=4326;{Point(10.0 10.0)@2019-09-01 00:00:00+01, Point(20.0 20.0)@2019-09-02 00:00:00+01, '
'Point(10.0 10.0)@2019-09-03 00:00:00+01}',
('Point(10.0 10.0)@2019-09-01 00:00:00+01',
'Point(20.0 20.0)@2019-09-02 00:00:00+01',
'Point(10.0 10.0)@2019-09-03 00:00:00+01'),
('SRID=4326;Point(10.0 10.0)@2019-09-01 00:00:00+01',
'SRID=4326;Point(20.0 20.0)@2019-09-02 00:00:00+01',
'SRID=4326;Point(10.0 10.0)@2019-09-03 00:00:00+01'),
(TGeogPointInst('Point(10.0 10.0)@2019-09-01 00:00:00+01'),
TGeogPointInst('Point(20.0 20.0)@2019-09-02 00:00:00+01'),
TGeogPointInst('Point(10.0 10.0)@2019-09-03 00:00:00+01')),
(TGeogPointInst('SRID=4326;Point(10.0 10.0)@2019-09-01 00:00:00+01'),
TGeogPointInst('SRID=4326;Point(20.0 20.0)@2019-09-02 00:00:00+01'),
TGeogPointInst('SRID=4326;Point(10.0 10.0)@2019-09-03 00:00:00+01')),
[
'Point(10.0 10.0)@2019-09-01 00:00:00+01',
'Point(20.0 20.0)@2019-09-02 00:00:00+01',
'Point(10.0 10.0)@2019-09-03 00:00:00+01'
],
[
'SRID=4326;Point(10.0 10.0)@2019-09-01 00:00:00+01',
'SRID=4326;Point(20.0 20.0)@2019-09-02 00:00:00+01',
'SRID=4326;Point(10.0 10.0)@2019-09-03 00:00:00+01'
],
assert result == TGeogPointInst(expected_tgeogpointinst)
@pytest.mark.parametrize('expected_tgeogpointinstset', [
'{Point(10.0 10.0)@2019-09-01 00:00:00+01, Point(20.0 20.0)@2019-09-02 00:00:00+01, '
'Point(10.0 10.0)@2019-09-03 00:00:00+01}',
'SRID=4326;{Point(10.0 10.0)@2019-09-01 00:00:00+01, Point(20.0 20.0)@2019-09-02 00:00:00+01, '
'Point(10.0 10.0)@2019-09-03 00:00:00+01}',
('Point(10.0 10.0)@2019-09-01 00:00:00+01', 'Point(20.0 20.0)@2019-09-02 00:00:00+01',
'Point(10.0 10.0)@2019-09-03 00:00:00+01'),
['Point(10.0 10.0)@2019-09-01 00:00:00+01', 'Point(20.0 20.0)@2019-09-02 00:00:00+01',
'Point(10.0 10.0)@2019-09-03 00:00:00+01'],
('SRID=4326;Point(10.0 10.0)@2019-09-01 00:00:00+01', 'SRID=4326;Point(20.0 20.0)@2019-09-02 00:00:00+01',
'SRID=4326;Point(10.0 10.0)@2019-09-03 00:00:00+01'),
['SRID=4326;Point(10.0 10.0)@2019-09-01 00:00:00+01', 'SRID=4326;Point(20.0 20.0)@2019-09-02 00:00:00+01',
'SRID=4326;Point(10.0 10.0)@2019-09-03 00:00:00+01'],
(TGeogPointInst('Point(10.0 10.0)@2019-09-01 00:00:00+01'),
TGeogPointInst('Point(20.0 20.0)@2019-09-02 00:00:00+01'),
TGeogPointInst('Point(10.0 10.0)@2019-09-03 00:00:00+01')),
[TGeogPointInst('Point(10.0 10.0)@2019-09-01 00:00:00+01'),
TGeogPointInst('Point(20.0 20.0)@2019-09-02 00:00:00+01'),
TGeogPointInst('Point(10.0 10.0)@2019-09-03 00:00:00+01')],
(TGeogPointInst('SRID=4326;Point(10.0 10.0)@2019-09-01 00:00:00+01'),
TGeogPointInst('SRID=4326;Point(20.0 20.0)@2019-09-02 00:00:00+01'),
TGeogPointInst('SRID=4326;Point(10.0 10.0)@2019-09-03 00:00:00+01')),
[TGeogPointInst('SRID=4326;Point(10.0 10.0)@2019-09-01 00:00:00+01'),
TGeogPointInst('SRID=4326;Point(20.0 20.0)@2019-09-02 00:00:00+01'),
TGeogPointInst('SRID=4326;Point(10.0 10.0)@2019-09-03 00:00:00+01')],
])
async def test_tgeogpointinstset_constructor(connection, expected_tgeogpointinstset):
if isinstance(expected_tgeogpointinstset, tuple):
params = TGeogPointInstSet(*expected_tgeogpointinstset)
