85caf81ac2
Introduce some new pre-commit hooks
2024-03-15 10:23:21 +01: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
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
Benjamin Renard
ad04357c6b
Code cleaning
2023-01-06 19:38:32 +01:00
Benjamin Renard
c643fd30ac
oracle: fix closing cursors
2022-12-09 12:20:01 +01:00
Benjamin Renard
9a89638e54
Code cleaning
2022-01-20 19:14:16 +01:00
Benjamin Renard
8e4864f2d5
OracleDB: add exit_on_error parameter to connect method
2021-11-23 13:03:55 +01:00
Benjamin Renard
ef510a36ee
OracleDB: add debug of SQL query in doSQL & doSelect methods
2021-11-19 11:52:50 +01:00
Benjamin Renard
5acbdbe8e3
OracleDB: add INFO log message on server connection
2021-11-18 19:56:07 +01:00
Benjamin Renard
f8225bfbc9
OracleDB: Add format_param method
2021-11-18 19:21:43 +01:00
Benjamin Renard
0eda55f11c
OracleDB.select: add support for orderby clause specify by tuple
2021-11-18 12:43:02 +01:00
Benjamin Renard
48c1fb085e
OracleDB.truncate: fix SQL query (TABLE word needed)
2021-11-18 12:34:30 +01: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
