MCPcopy
hub / github.com/geldata/gel / test_sql_native_query_00

Method test_sql_native_query_00

tests/test_sql_query.py:3012–3041  ·  view source on GitHub ↗
(self)

Source from the content-addressed store, hash-verified

3010 self.assertEqual(res1, res2)
3011
3012 async def test_sql_native_query_00(self):
3013 await self.assert_sql_query_result(
3014 """
3015 SELECT
3016 1 AS a,
3017 'two' AS b,
3018 to_json('three'::text) AS c,
3019 timestamp '2000-12-16 12:21:13' AS d,
3020 timestamp with time zone '2000-12-16 12:21:13' AS e,
3021 date '0001-01-01 AD' AS f,
3022 interval '2000 years' AS g,
3023 ARRAY[1, 2, 3] AS h,
3024 FALSE AS i,
3025 3.4 AS j
3026 """,
3027 [
3028 {
3029 "a": 1,
3030 "b": "two",
3031 "c": '"three"',
3032 "d": "2000-12-16T12:21:13",
3033 "e": "2000-12-16T12:21:13+00:00",
3034 "f": "0001-01-01",
3035 "g": edgedb.RelativeDuration(months=2000 * 12),
3036 "h": [1, 2, 3],
3037 "i": False,
3038 "j": 3.4,
3039 }
3040 ],
3041 )
3042
3043 async def test_sql_native_query_01(self):
3044 await self.assert_sql_query_result(

Callers

nothing calls this directly

Calls 1

Tested by

no test coverage detected