Commits · master · Kris Vanneste / simpledb

01 Jun, 2022 1 commit
- Removed import of unicode_literals from __future__ to preserve PY2 compatibility. · 3947fccb
  Kris Vanneste authored Jun 01, 2022
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8458 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
  3947fccb
04 May, 2022 1 commit

Use try/except in __del__ method of MySQLDB. · af0c235b

Kris Vanneste authored May 04, 2022

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8397 40b490c5-b4d9-47cb-8714-9bef99b524d5

af0c235b

03 May, 2022 1 commit
- Removed with statement in list_table_columns method of SQLDB as it is not compatible with sqlite. · 951ae2d7
  Kris Vanneste authored May 03, 2022
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8394 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
  951ae2d7
22 Apr, 2022 2 commits

Set longer timeout in connect method of SQLiteDB. · ff6666a6

Kris Vanneste authored Apr 22, 2022

Explicitly close database cursor in a number of methods of SQLiteDB.
Small fix in create_gpkg_view method of SQLiteDB.

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8358 40b490c5-b4d9-47cb-8714-9bef99b524d5

ff6666a6

Explicitly close database cursor in a number of methods of SQLDB. · 0b785f9a
Kris Vanneste authored Apr 22, 2022
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8357 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
0b785f9a

05 Apr, 2022 1 commit

Added create_gpkg_view method to SQLiteDB. · 5e3a600d

Kris Vanneste authored Apr 05, 2022

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8340 40b490c5-b4d9-47cb-8714-9bef99b524d5

5e3a600d

01 Apr, 2022 3 commits

Added reconnect method to MySQLDB. · ef913a73

Kris Vanneste authored Apr 01, 2022

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8335 40b490c5-b4d9-47cb-8714-9bef99b524d5

ef913a73

Fixed set_read_only method of MySQLDB. · 9a1a088f

Kris Vanneste authored Apr 01, 2022

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8334 40b490c5-b4d9-47cb-8714-9bef99b524d5

9a1a088f

Added set_read_only method to MySQLDB. · ecdb873e

Kris Vanneste authored Apr 01, 2022

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8333 40b490c5-b4d9-47cb-8714-9bef99b524d5

ecdb873e

17 Mar, 2022 1 commit

Added rename_column method to SQLiteDB. · 1928094d

Kris Vanneste authored Mar 17, 2022

Fixed problem in reorder_columns method of SQLiteDB.

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8301 40b490c5-b4d9-47cb-8714-9bef99b524d5

1928094d

09 Feb, 2022 1 commit

Added 'include_views' argument to list_tables method of SQLiteDB. · 6af5feda

Kris Vanneste authored Feb 09, 2022

Added list_views method to SQLiteDB.
Added 'verbose' argument to import_table method of SQLiteDB.
Added copy_table and reorder_columns methods to SQLiteDB.
Added 'table_name' argument to get_sql_commands method of SQLiteDB.

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8239 40b490c5-b4d9-47cb-8714-9bef99b524d5

6af5feda

04 Feb, 2022 2 commits

Fixed missing db_filespec in query in import_table method of SQLiteDB. · 894994c0
Kris Vanneste authored Feb 04, 2022
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8236 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
894994c0

Added import_table method to SQLiteDB. · e41de0f2

Kris Vanneste authored Feb 04, 2022

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8235 40b490c5-b4d9-47cb-8714-9bef99b524d5

e41de0f2

29 Jan, 2022 1 commit

Added list_geo_tables method to SQLiteDB. · 9b1f7ecc

Kris Vanneste authored Jan 29, 2022

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8220 40b490c5-b4d9-47cb-8714-9bef99b524d5

9b1f7ecc

27 Jan, 2022 1 commit
- Added sqlite_server.py with SQLiteClient and SQLiteServer classes, and updated __init__.py. · d40cd6b2
  Kris Vanneste authored Jan 27, 2022
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8208 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
  d40cd6b2
04 Jan, 2022 2 commits

Added setup.py. · dc34e7bd

Kris Vanneste authored Jan 04, 2022

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8116 40b490c5-b4d9-47cb-8714-9bef99b524d5

dc34e7bd

Check if numpy is available before adding support for numpy arrays. · e484218a
Kris Vanneste authored Jan 04, 2022
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8115 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
e484218a

30 Nov, 2021 1 commit

Added support for numpy arrays in SQLiteDB. · 80fcc81d

Kris Vanneste authored Nov 30, 2021

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8065 40b490c5-b4d9-47cb-8714-9bef99b524d5

80fcc81d

29 Nov, 2021 1 commit

Added export_schema method to SQLiteDB. · 6762589d

Kris Vanneste authored Nov 29, 2021

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@8058 40b490c5-b4d9-47cb-8714-9bef99b524d5

6762589d

11 Nov, 2021 3 commits

Updated TODOs for add_records method of SQLDB. · ae065d99

Kris Vanneste authored Nov 11, 2021

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7995 40b490c5-b4d9-47cb-8714-9bef99b524d5

ae065d99

Added add_records method to SQLiteDB, wrapping the same method in base.py, but... · ae172d3b

Kris Vanneste authored Nov 11, 2021

Added add_records method to SQLiteDB, wrapping the same method in base.py, but returning the IDs of the inserted rows.
Added add_rows alias for add_records method of SQLiteDB.

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7994 40b490c5-b4d9-47cb-8714-9bef99b524d5

ae172d3b

Added docstring to list_tables method of MySQLDB. · cbab7310

Kris Vanneste authored Nov 11, 2021

Added 'verbose' argument to several methods of MySQLDB.
Improved add_records method of MySQLDB.
Added add_rows alias for add_records method of MySQLDB.

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7993 40b490c5-b4d9-47cb-8714-9bef99b524d5

cbab7310

10 Nov, 2021 3 commits

Added add_rows and delete_rows aliases for add_records and delete_records methods of SQLDB. · a2c31661
Kris Vanneste authored Nov 10, 2021
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7991 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
a2c31661

Added set_read_only method to SQLiteDB. · b012fba6

Kris Vanneste authored Nov 10, 2021

Added 'verbose' and/or 'dry_run' arguments to several methods of SQLiteDB.
Fixed PY3 compatibility issue in get_geometry_types method of SQLiteDB.

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7990 40b490c5-b4d9-47cb-8714-9bef99b524d5

b012fba6

Added clear_table method to SQLDB. · 692e4cdd

Kris Vanneste authored Nov 10, 2021

Added 'verbose' and/or 'dry_run' arguments to several methods of SQLDB.
Fixed PY3 compatibility issue in update_row and update_column methods of SQLDB.

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7989 40b490c5-b4d9-47cb-8714-9bef99b524d5

692e4cdd

31 Oct, 2021 2 commits

Added add_records method to MySQLDB, wrapping generic SQLDB.add_records... · cb73cf69

Kris Vanneste authored Oct 31, 2021

Added add_records method to MySQLDB, wrapping generic SQLDB.add_records method, and returning inserted row IDs.

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7971 40b490c5-b4d9-47cb-8714-9bef99b524d5

cb73cf69

Fixed PY3 compatibility issue in add_records method of SQLDB. · 204f0b2d
Kris Vanneste authored Oct 31, 2021
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7970 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
204f0b2d

12 Jul, 2021 1 commit

Kris Vanneste authored Jul 12, 2021

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7830 40b490c5-b4d9-47cb-8714-9bef99b524d5

11d399ee

10 Jul, 2021 2 commits
- Added test folder with test/test_mod_spatialite.py script. · 19fd8497
  Kris Vanneste authored Jul 10, 2021
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7827 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
  19fd8497
- Moved testing for mod_spatialite extension to toplevel of sqlite submodule. · ab4025ff
  Kris Vanneste authored Jul 10, 2021
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7826 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
  ab4025ff
30 Jun, 2021 1 commit

Defined OperationalError. · d781e12b

Kris Vanneste authored Jun 30, 2021

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7804 40b490c5-b4d9-47cb-8714-9bef99b524d5

d781e12b

17 Mar, 2021 3 commits

Return PrettyTable instance instead of printing if 'print_table' argument is... · 8378b8f2

Kris Vanneste authored Mar 17, 2021

Return PrettyTable instance instead of printing if 'print_table' argument is True in query_sqlite_db_generic function.

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7635 40b490c5-b4d9-47cb-8714-9bef99b524d5

8378b8f2

Return PrettyTable instance instead of printing if 'print_table' argument is... · b83ef78c

Kris Vanneste authored Mar 17, 2021

Return PrettyTable instance instead of printing if 'print_table' argument is True in query_mysql_db_generic function.

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7634 40b490c5-b4d9-47cb-8714-9bef99b524d5

b83ef78c

Return PrettyTable instance instead of printing if 'print_table' argument is... · 01906af7

Kris Vanneste authored Mar 17, 2021

Return PrettyTable instance instead of printing if 'print_table' argument is True in query_generic method of SQLDB.

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7633 40b490c5-b4d9-47cb-8714-9bef99b524d5

01906af7

17 Jan, 2021 2 commits

Added 'supported_dbs' toplevel variable. · b275c1bc

Kris Vanneste authored Jan 17, 2021

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7435 40b490c5-b4d9-47cb-8714-9bef99b524d5

b275c1bc

Moved enable_load_extension in try/except statement to catch older python... · 5e53ae47

Kris Vanneste authored Jan 17, 2021

Moved enable_load_extension in try/except statement to catch older python versions not supporting this in connect method of SQLiteDB.

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7434 40b490c5-b4d9-47cb-8714-9bef99b524d5

5e53ae47

20 Oct, 2020 1 commit
- Made loading of spatialite extension more robust in __init__ method of SQLiteDB. · 4993dd47
  Kris Vanneste authored Oct 20, 2020
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@7158 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
  4993dd47
20 Apr, 2020 1 commit

Added drop_geo_table method to SQLiteDB. · ce08cbef

Kris Vanneste authored Apr 20, 2020

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@6568 40b490c5-b4d9-47cb-8714-9bef99b524d5

ce08cbef

06 Dec, 2019 1 commit

Updated import of secrets in __main__ body. · 90efd535

Kris Vanneste authored Dec 06, 2019

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@5938 40b490c5-b4d9-47cb-8714-9bef99b524d5

90efd535

29 Nov, 2019 1 commit

Updated docstring of build_sql_query function. · 82ac05fe

Kris Vanneste authored Nov 29, 2019

git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@5876 40b490c5-b4d9-47cb-8714-9bef99b524d5

82ac05fe