Commit Graph

193 Commits

Author SHA1 Message Date
utapyngo
6d7b6250c5 Support for using LIMIT N BY feature
See https://clickhouse.yandex/docs/en/query_language/select/#limit-by-clause
2020-01-20 19:53:38 +07:00
Itai Shirav
4848c7f813 Support LowCardinality columns in ad-hoc queries 2019-12-12 22:09:35 +02:00
Roy Belio
bcc4c29d10 Drying get_sql methods
Some updates to Nullable documentation
2019-06-24 18:54:55 +03:00
Roy Belio
3ba44608f3 RAMEN-206 Support LowCardinality in infi.clickhouse_orm 2019-06-24 14:20:18 +03:00
Roy Belio
2d3441b127 RAMEN-208 Support codec compression for clickhouse 2019-06-24 12:31:19 +03:00
Roy Belio
1889ac6372 Minor bug fixes
field creation won't allow empty string materialized field.
repliaca_name check is none
fix enum usage
typos fix
2019-06-23 11:53:58 +03:00
Roy Belio
4d2ebd65fb RAMEN-208 Support codec compression for clickhouse 2019-06-23 11:53:20 +03:00
Itai Shirav
840b29499a UUIDField compatibility with Python 3 2019-06-13 08:58:39 +03:00
Itai Shirav
da87a151df Fix querysets using the SystemPart model 2019-06-13 08:38:06 +03:00
Itai Shirav
9dd1a8f409 - Add log_statements parameter to database initializer
- Fix test_merge which fails on ClickHouse v19.8.3
2019-06-13 08:12:56 +03:00
Itai Shirav
7a2c8515a2 Update docs 2019-06-13 05:19:16 +03:00
Itai Shirav
4561159218 Merge branch 'develop' of https://github.com/kpotehin/infi.clickhouse_orm into kpotehin-develop 2019-06-13 05:08:59 +03:00
Itai Shirav
cadba6f6aa Support default/alias/materialized for nullable fields 2019-06-13 05:07:56 +03:00
Itai Shirav
7946a2a272 Update docs 2019-02-27 08:58:41 +02:00
Itai Shirav
191eac4424 Remove unused method 2019-02-27 08:56:04 +02:00
Itai Shirav
7ed62ffd2c Merge branch 'qs-with-totals' of https://github.com/carrotquest/infi.clickhouse_orm into carrotquest-qs-with-totals 2019-02-27 08:45:22 +02:00
Itai Shirav
ad81a811fc Memory engine does not support PREWHERE 2019-02-27 08:41:16 +02:00
Itai Shirav
64920a96c7 Merge branch 'qs-prewhere' of https://github.com/carrotquest/infi.clickhouse_orm into carrotquest-qs-prewhere 2019-02-27 07:41:17 +02:00
Itai Shirav
b8fd39c6a6 Use HTTP Basic Authentication instead of passing the credentials in the URL 2019-02-26 23:12:32 +02:00
Itai Shirav
81e942a4d2 Fix pagination when asking for the last page on a query that matches no records 2019-02-26 22:58:59 +02:00
Itai Shirav
bec45b53fa Fix parsing of server errors in ClickHouse v19.3.3+ 2019-02-26 22:46:00 +02:00
Kuzma Leshakov
cb91971fd9 Fix #110 2019-02-22 14:38:12 +03:00
Itai Shirav
efe270b502 Migrations - cannot add a new materialized field after a regular field 2019-01-28 10:08:07 +02:00
Kirill Potekhin
1388dd9e27 UUIDField added for ClickHouse UUID type 2018-12-20 01:35:13 +03:00
M1ha
6902de3b94 Fix fo conditions_as_sql method by review 2018-12-19 10:06:57 +05:00
M1ha
d912bf56d7 Merge branch 'qs-prewhere' into qs-with-totals 2018-12-17 10:30:01 +05:00
M1ha
d1e61dc420 Fixed invalid condtion joins in _filter_or_exclude (multiple_exclude_test) 2018-12-17 10:26:35 +05:00
M1ha
375316fbf3 Merge branch 'develop' into qs-prewhere
# Conflicts:
#	src/infi/clickhouse_orm/query.py
2018-12-17 10:21:58 +05:00
Itai Shirav
9df82a44ec Added verify_ssl_cert parameter to database initializer 2018-12-14 11:13:23 +02:00
Itai Shirav
8c22c753a8 Use requests Session object for better performance 2018-12-14 11:06:57 +02:00
Itai Shirav
64d15cf3b6 Update docs 2018-12-14 08:34:40 +02:00
Itai Shirav
2f54b3ca5a Merge branch 'qs-final' of https://github.com/carrotquest/infi.clickhouse_orm into carrotquest-qs-final 2018-12-14 08:31:48 +02:00
Itai Shirav
5c78c315ee Update test to verify issue #89 2018-12-14 08:29:08 +02:00
Itai Shirav
3478e59dd3 Merge branch 'issue-89-fix' of https://github.com/carrotquest/infi.clickhouse_orm into carrotquest-issue-89-fix 2018-12-14 08:21:29 +02:00
Itai Shirav
374f2dfe3e Update docs 2018-12-14 08:20:43 +02:00
M1ha
c56820fb6c Fix https://github.com/Infinidat/infi.clickhouse_orm/issues/89 2018-12-13 15:40:08 +05:00
M1ha
5f4023f120 Added with_totals method 2018-12-12 15:33:35 +05:00
M1ha
0c92e2ac74 Simplified conditions, built by Q objects, if many conditions are joined in same mode 2018-12-11 18:04:08 +05:00
M1ha
12463c61b8 1) Fixed bugs
2) Edited the docs
3) Added test for prewhere
2018-12-11 17:25:54 +05:00
M1ha
76dfdb6012 Fixed bug in final() method engine validation 2018-12-11 16:47:39 +05:00
M1ha
95055996ad 1) Further refactoring of as_sql():
merged very similar QuerySet and AggregateQuerySet methods
2) Fixed some bugs, caused by conditions_as_sql() parameters change
2018-12-08 11:57:08 +05:00
M1ha
3bc5f27cda 1) Unified QuerySet filter and exclude methods,
so both can load *q and **kwargs at the same time
 and accept prewhere flag
2) Added ability to add prewhere clause
 in QuerySet.filter() and QuerySet.exclude() methods
3) Added ability to check, if Q() object is empty (including bool check)
4) Refactored QuerySet.as_sql() method:
 + don't add GROUP BY and WHERE if it's not needed
 + ability to add PREWHERE condition
 + Common style of adding optional query parts
2018-12-08 11:40:05 +05:00
M1ha
7f38f8c654 Added fina() QuerySet method
Added tests for ite
Not tested in case of https://github.com/Infinidat/infi.clickhouse_orm/issues/93
2018-12-02 12:14:19 +05:00
P R
75f0ad9882
Update database.py
Added connection timeout parameter
2018-11-28 00:09:53 +07:00
Itai Shirav
f24749112e support decimal fields 2018-10-14 09:26:07 +03:00
Itai Shirav
658c7b42ee Bug fix: wrong parentheses when building queries using Q objects 2018-10-13 19:49:12 +03:00
Itai Shirav
f2a731711d Bug fix: QuerySet.count() ignores slicing 2018-10-13 19:29:36 +03:00
Itai Shirav
6416b25818 Merge branch 'filtering_null' of https://github.com/kalombos/infi.clickhouse_orm into kalombos-filtering_null 2018-08-19 18:36:08 +03:00
Itai Shirav
44d3dcee34 Added Database.does_table_exist method 2018-08-19 18:20:17 +03:00
Itai Shirav
acf2f7a189 Check for database existence, to allow delayed creation 2018-08-19 18:02:37 +03:00