Commits · master · Kris Vanneste / simpledb

04 Jan, 2022 2 commits

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

24 Nov, 2019 1 commit
- Allowed 'where_clause' and 'having_clause' arguments of build_sql_query function to be lists. · 271609df
  Kris Vanneste authored Nov 24, 2019
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@5858 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
  271609df
09 Apr, 2019 1 commit
- Added get_sql_command and get_sql_commands methods to MySQLDB. · fe0a1ee8
  Kris Vanneste authored Apr 09, 2019
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@5309 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
  fe0a1ee8
04 Apr, 2019 1 commit

Added close and __del__ methods to MySQLDB. · bf130d9a

Kris Vanneste authored Apr 04, 2019

Close cursor and connection in query_mysql_db_generic.

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

bf130d9a

03 Apr, 2019 1 commit

Added update_column method to SQLDB. · f3bee23c

Kris Vanneste authored Apr 03, 2019

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

f3bee23c

12 Feb, 2019 1 commit
- Moved call to connection.enable_load_extension inside try statement in connect method of SQLiteDB. · 897ed5ec
  Kris Vanneste authored Feb 12, 2019
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@5048 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
  897ed5ec
06 Feb, 2019 4 commits

Fixed wrong indent in query_sqlite_db_generic function. · 37452d59

Kris Vanneste authored Feb 06, 2019

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

37452d59

Added print_table argument to query_sqlite_db and query_sqlite_db_generic functions. · f0cf6f4f
Kris Vanneste authored Feb 06, 2019
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@4999 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
f0cf6f4f
Added print_table argument to query_mysql_db and query_mysql_db_generic functions. · dad36439
Kris Vanneste authored Feb 06, 2019
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@4998 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
dad36439

Modified query_generic method of SQLDB in order to preserve column order when... · 78a216ef

Kris Vanneste authored Feb 06, 2019

Modified query_generic method of SQLDB in order to preserve column order when printing results to a table.
Pass missing group_clause to build_sql_query in query method of SQLDB.
Apply rollback if dry_run argument is True in add_records, delete_records and update_row methods of SQLDB.
Added update_rows method to SQLDB.

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

78a216ef

27 Dec, 2018 2 commits

Renamed has_spatialite attribute of SQLiteDB to HAS_SPATIALITE. · 21895e1f
Kris Vanneste authored Dec 27, 2018
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@4925 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
21895e1f

Simplified import mechanism. · f4294435

Kris Vanneste authored Dec 27, 2018

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

f4294435

13 Dec, 2018 1 commit

More robust implementation of __getitem__ and __getattr__ methods of SQLRecord. · 9ac8298e

Kris Vanneste authored Dec 13, 2018

Added get method to SQLRecord.

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

9ac8298e

26 Nov, 2018 1 commit
- Updated import_table_from_gis_file method of SQLiteDB due to changes in geotools module (2). · da622b72
  Kris Vanneste authored Nov 26, 2018
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@4798 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
  da622b72
23 Nov, 2018 1 commit
- Updated import_table_from_gis_file method of SQLiteDB due to changes in geotools module. · f68ad9b7
  Kris Vanneste authored Nov 23, 2018
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@4795 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
  f68ad9b7
19 Nov, 2018 1 commit
- Implemented a functioning relative submodule import mechanism. · 5a46cad5
  Kris Vanneste authored Nov 19, 2018
```
git-svn-id: https://svn.seismo.oma.be/svn/seismo/db/simpledb/trunk@4788 40b490c5-b4d9-47cb-8714-9bef99b524d5
```
  5a46cad5