Commit Graph

716 Commits

Author SHA1 Message Date
781b8436a3 maintenance: bump version to 1.7.0
Some checks failed
build / python (push) Failing after 1m49s
maintenance: update changelog with release notes
maintenance: update __version__ in dataset/__init__
2025-11-09 17:03:37 +01:00
73c4c0f4bc refactor: simplify database and table interactions
feat: update sqlalchemy version to 2.0.0
refactor: improve table insert and update methods
refactor: streamline table select and distinct queries
refactor: simplify table delete and schema creation
feat: test: update tests to reflect api changes
2025-11-09 17:02:19 +01:00
Gregor Aisch
b2ab09e58c
Merge pull request #424 from investigativedata/fix/distinct-slice
Respect _limit and _offset kwargs for select distinct
2025-02-05 12:22:42 +00:00
Simon Wörpel
d61d309637
Respect _limit and _offset kwargs for select distinct 2023-08-08 15:42:38 +02:00
Friedrich Lindenberg
5c2dc8d3af Bump version: 1.6.1 → 1.6.2 2023-07-12 10:51:27 +02:00
Friedrich Lindenberg
4ca0584d3f try this 2023-07-12 10:38:20 +02:00
Friedrich Lindenberg
dbc6dc5744 Bump version: 1.6.0 → 1.6.1 2023-07-12 10:37:16 +02:00
Friedrich Lindenberg
3e974c9070
Merge pull request #423 from catileptic/bugfix/419
Fix add_column method to work with Alembic 1.11+
2023-07-12 10:34:38 +02:00
Alex Stefanescu
5d44006c40
Fix add_column method to work with Alembic 1.11+ 2023-07-12 10:16:58 +02:00
Friedrich Lindenberg
0757b5010b Bump version: 1.5.2 → 1.6.0 2023-01-30 09:55:46 +01:00
Friedrich Lindenberg
cea87af0b2 pin sqlalchemy below 2.0.0 2023-01-30 09:51:40 +01:00
Friedrich Lindenberg
b99e4f95d8
Merge pull request #398 from timgates42/bugfix_typos
docs: Fix a few typos
2022-12-27 15:35:21 +01:00
Tim Gates
976c25ad14
docs: Fix a few typos
There are small typos in:
- dataset/table.py
- docs/queries.rst
- docs/quickstart.rst

Fixes:
- Should read `significant` rather than `signficant`.
- Should read `parameterisation` rather than `paramterisation`.
- Should read `explicitly` rather than `explicetly`.

Signed-off-by: Tim Gates <tim.gates@iress.com>
2022-07-17 12:21:02 +10:00
Friedrich Lindenberg
be81e8f000
Merge pull request #397 from xqm32/fix-typo
docs: fix typo for `Database.query()`
2022-06-03 08:54:53 +02:00
xqm32
6d6e581edb docs: fix typo for Database.query() 2022-06-03 01:11:49 +08:00
Friedrich Lindenberg
7e921501f6 add missing arguments, fixes #391. 2022-01-07 13:09:25 +01:00
Friedrich Lindenberg
75c12f79cc Bump version: 1.5.1 → 1.5.2 2021-12-16 11:10:24 +01:00
Friedrich Lindenberg
6121e517a8 Consider PK when checking for indexes, fixes #382. 2021-12-16 11:06:31 +01:00
Friedrich Lindenberg
602d52f416 Try to make convert row work on sqla 1.3 and 1.4. 2021-12-16 10:21:40 +01:00
Friedrich Lindenberg
8c91b6feaa Bump version: 1.5.0 → 1.5.1 2021-11-17 18:32:29 +01:00
Friedrich Lindenberg
4e359f5e01 Formatting fixes 2021-11-17 18:27:48 +01:00
Friedrich Lindenberg
5885680645
Merge pull request #387 from kapily/sqlite_uri
Add SQLite url builder
2021-11-17 18:10:42 +01:00
Friedrich Lindenberg
6cdafa59b0
Merge pull request #388 from kapily/rename_to_on_connec
Rename to on connect statements
2021-11-17 18:10:09 +01:00
Kapil Yedidi
5f17e92293 Rename to on connect statements 2021-11-17 09:09:03 -08:00
Friedrich Lindenberg
d0491ec0e3
Merge pull request #386 from kapily/add_arbitrary_pragmas
Allow passing in arbitrary sqlite pragmas
2021-11-17 17:53:22 +01:00
Kapil Yedidi
433bc0a5ba Made requested change 2021-11-17 08:52:14 -08:00
Kapil Yedidi
5663dc8251 saving state 2021-11-17 08:46:27 -08:00
Kapil Yedidi
eb06d95559 Bug fix 2021-11-16 15:11:55 -08:00
Kapil Yedidi
5f93c3748a Add SQLite url builder 2021-11-15 09:00:33 -08:00
Kapil Yedidi
42ee4530bb Allow passing in off arbitrary sqlite pragmas 2021-11-15 08:08:10 -08:00
Friedrich Lindenberg
b1638a41d6 Switch from nose to pytest 2021-10-30 12:07:06 +02:00
Friedrich Lindenberg
63c8357d1b
Merge pull request #385 from ammgws/patch-1
docs: fix broken examples for `find`
2021-10-29 13:49:21 +02:00
Jason Nader
6ade1fdeb8
docs: fix examples for find 2021-10-27 15:07:52 +09:00
Friedrich Lindenberg
e5d52d6eee
Merge pull request #381 from mijaba/master
Fix for startswith/endswith
2021-08-11 20:59:22 +02:00
mijaba
79a47a4f6a
Merge pull request #1 from mijaba/mijaba-patch-1
Update table.py to fix startswith/endswith
2021-08-11 14:29:15 +02:00
mijaba
043db2bcaa
Update table.py 2021-08-11 14:27:24 +02:00
Friedrich Lindenberg
7b90d76097 Rename function, fixes #377. 2021-07-29 17:35:03 +02:00
Friedrich Lindenberg
41b7552df1
Merge pull request #376 from Remalloc/master
Remove all keys from values
2021-07-29 15:49:56 +02:00
Friedrich Lindenberg
01866c0a61
Create FUNDING.yml 2021-06-25 13:51:49 +02:00
remalloc.virtual@gmail.com
7f49e89350 Remove all keys from values 2021-06-09 14:16:40 +08:00
Friedrich Lindenberg
f7254e5021
Merge pull request #373 from Remalloc/master
Update api.rst
2021-06-07 09:37:21 +02:00
Remalloc
bd307909ef
Update api.rst
Add missing method "update_many"
2021-06-03 14:31:55 +08:00
Friedrich Lindenberg
8f78466fcb
Merge pull request #368 from pudo/dependabot/add-v2-config-file
Upgrade to GitHub-native Dependabot
2021-05-28 13:31:42 +02:00
dependabot-preview[bot]
8bccd6264b
Upgrade to GitHub-native Dependabot 2021-04-28 22:02:23 +00:00
Friedrich Lindenberg
0e5dee2357 Bump version: 1.4.5 → 1.5.0 2021-04-22 19:01:41 +02:00
Friedrich Lindenberg
a75b7c4c93 Fix linting issue 2021-04-22 18:54:19 +02:00
Friedrich Lindenberg
c13b79fc59 Try to fix #365. 2021-04-22 18:51:27 +02:00
Friedrich Lindenberg
45794d349f
Merge pull request #364 from branchjoshua/bugfix-database-close
Fixes pudo/dataset#363
2021-04-22 18:46:59 +02:00
Joshua Branch
ed3b120f85 Fixes pudo/dataset#363 by tracking checked-out sqlalchemy database connections, on a per-thread basis, and closing all connections when Database.close() is called. 2021-03-10 00:35:04 -05:00
Friedrich Lindenberg
2791a61939 Bump version: 1.4.4 → 1.4.5 2021-02-08 11:37:18 +01:00