Benjamin Renard
6ccea48b23
Db: allow to specify a list as a WHERE clause value and they will be combined as a IN clause
Run tests / tests (push) Failing after 1m22s
2024-10-14 19:03:37 +02:00
3cf6a2682c
opening_hours: global rework to make module more atomic and add somes new helper methods
Run tests / tests (push) Failing after 1m35s
2024-04-01 19:37:51 +02:00
85caf81ac2
Introduce some new pre-commit hooks
2024-03-15 10:23:21 +01:00
Benjamin Renard
371d194728
PgDB: fix doSelect() method to retreive list of dicts instead of list of lists.
2023-12-15 12:12:48 +01:00
Benjamin Renard
dcaec24ea4
PgDB / MyDB / OracleDB: add limit parameter to select() method
2023-12-15 11:35:43 +01:00
Benjamin Renard
8a0a65465d
Update pre-commit config and fix some pylint & bandit warnings
2023-10-27 13:35:59 +02:00
Benjamin Renard
62c3fadf96
Introduce pyupgrade,isort,black and configure pre-commit hooks to run all testing tools before commit
ci/woodpecker/push/woodpecker Pipeline failed
2023-01-16 12:56:12 +01:00
Benjamin Renard
508a28e5c8
tests: add some tests on BooleanOption
2023-01-09 13:33:14 +01:00
da63f533be
Abstract common DB methods in mysql.db.DB class and use it as base to implement PgDB, OracleDB and MyDB
ci/woodpecker/push/woodpecker Pipeline was successful
ci/woodpecker/tag/woodpecker Pipeline was successful
2023-01-07 02:19:18 +01:00
b0fd2b1c6d
Code cleaning
2023-01-06 22:18:18 +01:00
815081d544
PgDB: Fix tests
ci/woodpecker/push/woodpecker Pipeline was successful
2023-01-06 21:10:25 +01:00
Benjamin Renard
ad04357c6b
Code cleaning
2023-01-06 19:38:32 +01:00
Benjamin Renard
eb183b0d3b
config: split console logging between stdout & stderr base on level
ci/woodpecker/push/woodpecker Pipeline was successful
2023-01-06 18:19:48 +01:00
Benjamin Renard
c643fd30ac
oracle: fix closing cursors
2022-12-09 12:20:01 +01:00
Benjamin Renard
252f9a87ac
tests: fix oracle test_truncate
2022-04-27 17:11:02 +02:00
Benjamin Renard
0a0fae3e90
Add TelltaleFile helper class
2022-04-12 12:59:20 +02:00
Benjamin Renard
7b1019cb1b
Add oracle lib
...
Based on mylib.pgsql.PgDB exiting lib and cx_Oracle,
mylib.oracle.OracleDB provide an easy way to execute simple SQL query on
an Oracle Database server.
2021-11-07 22:00:21 +01:00
Benjamin Renard
c77f9e5674
PgSQL: fix quoting table name with schema prefix
2021-11-07 21:57:00 +01:00
Benjamin Renard
6b825813c1
PgSQL: code cleaning
2021-11-07 21:37:18 +01:00
Benjamin Renard
86be381db9
Add some unit tests on config lib
2021-11-06 15:36:51 +01:00
Benjamin Renard
439a1e9b33
tests: fix some pylint warnings & errors
2021-11-03 17:06:37 +01:00
Benjamin Renard
9d611284ef
PgDB._add_where_clauses: Fix handling fields already in params
2021-11-03 17:04:58 +01:00
Benjamin Renard
afe54819bb
Improve PgDB class and add unit tests
2021-10-06 21:33:25 +02:00
Benjamin Renard
6bbacce38a
Code cleaning
2021-05-19 19:19:57 +02:00
Benjamin Renard
bd4845f780
Switch to module style lib, make python3 compatibility and clean code
2021-05-19 18:07:42 +02:00
Benjamin Renard
764d92a40c
Add opening_hours lib
2018-11-15 15:45:45 +01:00
