Skip to content

Commit 57b22e6

Browse files
pre-commit-ci-lite[bot]mihaibudiu
pre-commit-ci-lite[bot]
authored and
mihaibudiu
committed
[pre-commit.ci lite] apply automatic fixes
1 parent dffaedb commit 57b22e6

2 files changed

Lines changed: 21 additions & 21 deletions

File tree

‎python/tests/aggregate_tests/test_decimal_stddev_pop.py‎

Lines changed: 9 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -5,7 +5,7 @@
55
class aggtst_decimal_stddev_pop(TstView):
66
def __init__(self):
77
# Validated on Postgres
8-
self.data = [{'c1': Decimal('2154.11'), 'c2': Decimal('2318.75')}]
8+
self.data = [{"c1": Decimal("2154.11"), "c2": Decimal("2318.75")}]
99
self.sql = """CREATE MATERIALIZED VIEW decimal_stddev_pop AS SELECT
1010
STDDEV_POP(c1) AS c1,
1111
STDDEV_POP(c2) AS c2
@@ -16,8 +16,8 @@ class aggtst_decimal_stddev_pop_groupby(TstView):
1616
def __init__(self):
1717
# Validated on Postgres
1818
self.data = [
19-
{'id': 0, 'c1': Decimal('0.00'), 'c2': Decimal('785.40')},
20-
{'id': 1, 'c1': Decimal('0.00'), 'c2': Decimal('177.00')}
19+
{"id": 0, "c1": Decimal("0.00"), "c2": Decimal("785.40")},
20+
{"id": 1, "c1": Decimal("0.00"), "c2": Decimal("177.00")},
2121
]
2222
self.sql = """CREATE MATERIALIZED VIEW decimal_stddev_pop_gby AS SELECT
2323
id,
@@ -30,7 +30,7 @@ def __init__(self):
3030
class aggtst_decimal_stddev_pop_distinct(TstView):
3131
def __init__(self):
3232
# Validated on Postgres
33-
self.data = [{'c1': Decimal('2284.78'), 'c2': Decimal('2318.75')}]
33+
self.data = [{"c1": Decimal("2284.78"), "c2": Decimal("2318.75")}]
3434
self.sql = """CREATE MATERIALIZED VIEW decimal_stddev_pop_distinct AS SELECT
3535
STDDEV_POP(DISTINCT c1) AS c1,
3636
STDDEV_POP(DISTINCT c2) AS c2
@@ -41,8 +41,8 @@ class aggtst_decimal_stddev_pop_distinct_groupby(TstView):
4141
def __init__(self):
4242
# Validated on Postgres
4343
self.data = [
44-
{'id': 0, 'c1': Decimal('0.00'), 'c2': Decimal('785.40')},
45-
{'id': 1, 'c1': Decimal('0.00'), 'c2': Decimal('177.00')}
44+
{"id": 0, "c1": Decimal("0.00"), "c2": Decimal("785.40")},
45+
{"id": 1, "c1": Decimal("0.00"), "c2": Decimal("177.00")},
4646
]
4747
self.sql = """CREATE MATERIALIZED VIEW decimal_stddev_pop_distinct_gby AS SELECT
4848
id,
@@ -55,7 +55,7 @@ def __init__(self):
5555
class aggtst_decimal_stddev_pop_where(TstView):
5656
def __init__(self):
5757
# Validated on Postgres
58-
self.data = [{'c1': Decimal('0.00'), 'c2': Decimal('1754.95')}]
58+
self.data = [{"c1": Decimal("0.00"), "c2": Decimal("1754.95")}]
5959
self.sql = """CREATE MATERIALIZED VIEW decimal_stddev_pop_where AS SELECT
6060
STDDEV_POP(c1) FILTER (WHERE c2 > 2231.90) AS c1,
6161
STDDEV_POP(c2) FILTER (WHERE c2 > 2231.90) AS c2
@@ -66,8 +66,8 @@ class aggtst_decimal_stddev_pop_where_groupby(TstView):
6666
def __init__(self):
6767
# Validated on Postgres
6868
self.data = [
69-
{'id': 0, 'c1': None, 'c2': Decimal('0.00')},
70-
{'id': 1, 'c1': Decimal('0.00'), 'c2': Decimal('177.00')}
69+
{"id": 0, "c1": None, "c2": Decimal("0.00")},
70+
{"id": 1, "c1": Decimal("0.00"), "c2": Decimal("177.00")},
7171
]
7272
self.sql = """CREATE MATERIALIZED VIEW decimal_stddev_pop_where_gby AS SELECT
7373
id,

‎python/tests/aggregate_tests/test_decimal_stddev_samp.py‎

Lines changed: 12 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -5,9 +5,9 @@
55
class aggtst_decimal_stddev(TstView):
66
def __init__(self):
77
# Validated on Postgres
8-
self.data = [{'c1': Decimal('2638.23'), 'c2': Decimal('2677.47')}]
8+
self.data = [{"c1": Decimal("2638.23"), "c2": Decimal("2677.47")}]
99
self.sql = """CREATE MATERIALIZED VIEW decimal_stddev_samp AS SELECT
10-
STDDEV_SAMP(c1) AS c1,
10+
STDDEV_SAMP(c1) AS c1,
1111
STDDEV_SAMP(c2) AS c2
1212
FROM decimal_tbl"""
1313

@@ -16,12 +16,12 @@ class aggtst_decimal_stddev_groupby(TstView):
1616
def __init__(self):
1717
# Validated on Postgres
1818
self.data = [
19-
{'id': 0, 'c1': None, 'c2': Decimal('1110.73')},
20-
{'id': 1, 'c1': Decimal('0.00'), 'c2': Decimal('250.31')}
19+
{"id": 0, "c1": None, "c2": Decimal("1110.73")},
20+
{"id": 1, "c1": Decimal("0.00"), "c2": Decimal("250.31")},
2121
]
2222
self.sql = """CREATE MATERIALIZED VIEW decimal_stddev_samp_gby AS SELECT
23-
id,
24-
STDDEV_SAMP(c1) AS c1,
23+
id,
24+
STDDEV_SAMP(c1) AS c1,
2525
STDDEV_SAMP(c2) AS c2
2626
FROM decimal_tbl
2727
GROUP BY id"""
@@ -30,7 +30,7 @@ def __init__(self):
3030
class aggtst_decimal_stddev_distinct(TstView):
3131
def __init__(self):
3232
# Validated on Postgres
33-
self.data = [{'c1': Decimal('3231.16'), 'c2': Decimal('2677.47')}]
33+
self.data = [{"c1": Decimal("3231.16"), "c2": Decimal("2677.47")}]
3434
self.sql = """CREATE MATERIALIZED VIEW decimal_stddev_samp_distinct AS SELECT
3535
STDDEV_SAMP(DISTINCT c1) AS c1,
3636
STDDEV_SAMP(DISTINCT c2) AS c2
@@ -41,8 +41,8 @@ class aggtst_decimal_stddev_distinct_groupby(TstView):
4141
def __init__(self):
4242
# Validated on Postgres
4343
self.data = [
44-
{'id': 0, 'c1': None, 'c2': Decimal('1110.73')},
45-
{'id': 1, 'c1': None, 'c2': Decimal('250.31')}
44+
{"id": 0, "c1": None, "c2": Decimal("1110.73")},
45+
{"id": 1, "c1": None, "c2": Decimal("250.31")},
4646
]
4747
self.sql = """CREATE MATERIALIZED VIEW decimal_stddev_samp_distinct_gby AS SELECT
4848
id,
@@ -55,7 +55,7 @@ def __init__(self):
5555
class aggtst_decimal_stddev_where(TstView):
5656
def __init__(self):
5757
# Validated on Postgres
58-
self.data = [{'c1': Decimal('0.00'), 'c2': Decimal('2149.36')}]
58+
self.data = [{"c1": Decimal("0.00"), "c2": Decimal("2149.36")}]
5959
self.sql = """CREATE MATERIALIZED VIEW decimal_stddev_where AS SELECT
6060
STDDEV_SAMP(c1) FILTER (WHERE c2 > 2231.90) AS c1,
6161
STDDEV_SAMP(c2) FILTER (WHERE c2 > 2231.90) AS c2
@@ -66,8 +66,8 @@ class aggtst_decimal_stddev_where_groupby(TstView):
6666
def __init__(self):
6767
# Validated on Postgres
6868
self.data = [
69-
{'id': 0, 'c1': None, 'c2': None},
70-
{'id': 1, 'c1': Decimal('0.00'), 'c2': Decimal('250.31')}
69+
{"id": 0, "c1": None, "c2": None},
70+
{"id": 1, "c1": Decimal("0.00"), "c2": Decimal("250.31")},
7171
]
7272
self.sql = """CREATE MATERIALIZED VIEW decimal_stddev_where_gby AS SELECT
7373
id,

0 commit comments

Comments
 (0)