Releases: Flowminder/FlowKit
1.27.0
Changelog
All notable changes to FlowKit will be documented in this file.
The format is based on Keep a Changelog.
1.27.0
Added
- Added FlowDB table
infrastructure.invalid_cell_info
for recording cell information that could not be included ininfrastructure.cell_info
(including cells with null or duplicate cell IDs). #6626 - The file name of FlowDB's automatically generated at init config file can now be specified by setting the
AUTO_CONFIG_FILE_NAME
environment variable. By default this ispostgresql.configurator.conf
.
Changed
- FlowDB now triggers an ANALYZE on newly created cache tables to generate statistics rather than waiting for autovacuum
- FlowDB now produces JSON formatted logs by default. Set
FLOWDB_LOG_DEST=csvlog
for the old default behaviour. - The logging destination of FlowDB can now be configured at init by setting the
FLOWDB_LOG_DEST
environment variable, valid options arestderr
,csvlog
, andjsonlog
. - The location inside the container of FlowDB's automatically generated config file has changed to
/flowdb_autoconf/$AUTO_CONFIG_FILE_NAME
.
What's Changed
- Bump jupyter/scipy-notebook from
053aea4
toa47b0df
by @dependabot in #6632 - Bump cypress from 13.6.0 to 13.11.0 in /flowauth/frontend by @dependabot in #6650
- Use 'SELECT DISTINCT ON' in LastLocation by @jc-harrison in #6622
- Autoanalyze cache tables by @greenape in #6599
- Bump pytest from 8.2.0 to 8.2.2 in /flowapi by @dependabot in #6654
- Bump structlog from 24.1.0 to 24.2.0 in /flowmachine by @dependabot in #6634
- Bump sqlalchemy from 2.0.29 to 2.0.30 in /flowauth by @dependabot in #6569
- Fix slow displacement test by @greenape in #6652
- Bump cryptography from 42.0.7 to 42.0.8 in /flowapi by @dependabot in #6639
- Bump pytest-asyncio from 0.23.6 to 0.23.7 in /flowapi by @dependabot in #6615
- Add invalid_cell_info table and change exclude constraint on cell_info by @jc-harrison in #6627
- Bump approvaltests from 12.2.0 to 12.2.1 in /flowmachine by @dependabot in #6648
- Bump redis from 5.0.5 to 5.0.6 in /flowmachine by @dependabot in #6656
- Json logs by @greenape in #6600
- Allow specifying auto config path by @greenape in #6601
- Bump numpy from 1.26.4 to 2.0.0 in /flowdb/testdata/synthetic_data by @dependabot in #6658
- Bump jupyter/scipy-notebook from
01a2c6c
toe5ef944
by @dependabot in #6659
Full Changelog: 1.26.0...1.27.0
1.26.0
Changed
- FlowDB now enables partitionwise aggregation planning by default
- FlowDB now uses a default fillfactor of 100 for cache table indexes
Fixed
- Queries that have multiple of the same subquery with different parameters no longer cause duplicate scopes in tokens. #6580
- FlowETL QA checks
count_imeis
,count_imsis
,max_msisdns_per_imei
andmax_msisdns_per_imsi
now only count non-null IMEIs/IMSIs. #6619
What's Changed
- Revert "Delete .github/dependabot.yml" by @greenape in #6512
- Bump github/codeql-action from 2 to 3 by @dependabot in #6514
- Exclude flowetl from dependabot entirely by @greenape in #6553
- Bump black from 24.3.0 to 24.4.2 in /flowdb by @dependabot in #6518
- Bump black from 24.3.0 to 24.4.2 in /flowdb/testdata/synthetic_data by @dependabot in #6519
- Bump husky from 8.0.3 to 9.0.11 in /flowauth/frontend by @dependabot in #6520
- Bump black from 24.3.0 to 24.4.2 in /flowauth by @dependabot in #6530
- Bump prance from 0.21.8.0 to 23.6.21.0 in /flowapi by @dependabot in #6537
- Bump pytest from 8.1.1 to 8.2.0 in /flowmachine by @dependabot in #6539
- Bump black from 24.3.0 to 24.4.2 in /flowmachine by @dependabot in #6548
- Bump numpy from 1.26.2 to 1.26.4 in /flowdb/testdata/synthetic_data by @dependabot in #6525
- Bump tar from 6.1.12 to 6.2.1 in /flowauth/frontend by @dependabot in #6489
- Bump sqlalchemy from 1.4.44 to 2.0.29 in /flowauth by @dependabot in #6541
- Bump pytest from 8.1.1 to 8.2.0 in /flowauth by @dependabot in #6552
- Bump black from 24.3.0 to 24.4.2 in /flowapi by @dependabot in #6546
- Bump freezegun from 1.4.0 to 1.5.0 in /flowauth by @dependabot in #6545
- Bump redis from 5.0.3 to 5.0.4 in /flowauth by @dependabot in #6550
- Bump jsonschema from 4.17.3 to 4.22.0 in /flowapi by @dependabot in #6554
- Bump classnames from 2.3.2 to 2.5.1 in /flowauth/frontend by @dependabot in #6555
- Bump flask from 2.2.5 to 3.0.3 in /flowauth by @dependabot in #6549
- Bump flask-sqlalchemy from 3.0.5 to 3.1.1 in /flowauth by @dependabot in #6556
- Bump prettier from 3.1.0 to 3.2.5 in /flowauth/frontend by @dependabot in #6532
- Bump marshmallow from 3.21.1 to 3.21.2 in /flowmachine by @dependabot in #6559
- Bump pyzmq from 26.0.2 to 26.0.3 in /flowmachine by @dependabot in #6558
- Bump pyzmq from 26.0.2 to 26.0.3 in /flowapi by @dependabot in #6560
- Bump approvaltests from 11.2.1 to 12.0.0 in /flowmachine by @dependabot in #6551
- Bump jsonschema from 4.17.3 to 4.22.0 in /flowapi by @dependabot in #6561
- Bump tqdm from 4.66.2 to 4.66.4 in /flowclient by @dependabot in #6562
- Enable partitionwise aggregation in pg config by @greenape in #6511
- Bump cryptography from 42.0.5 to 42.0.6 in /flowauth by @dependabot in #6566
- Bump sqlalchemy from 2.0.29 to 2.0.30 in /flowmachine by @dependabot in #6565
- Bump cryptography from 42.0.5 to 42.0.6 in /flowapi by @dependabot in #6567
- Bump werkzeug from 3.0.2 to 3.0.3 in /flowapi by @dependabot in #6568
- Bump jinja2 from 3.1.3 to 3.1.4 in /flowdb/testdata/synthetic_data by @dependabot in #6570
- Bump sqlalchemy from 2.0.29 to 2.0.30 in /flowdb/testdata/synthetic_data by @dependabot in #6571
- Bump cryptography from 42.0.5 to 42.0.6 in /flowkit_jwt_generator by @dependabot in #6572
- Bump werkzeug from 3.0.2 to 3.0.3 in /flowauth by @dependabot in #6573
- Bump jinja2 from 3.1.3 to 3.1.4 in /flowapi by @dependabot in #6575
- Bump cryptography from 42.0.6 to 42.0.7 in /flowkit_jwt_generator by @dependabot in #6579
- Update GADM download URL by @jc-harrison in #6589
- Bump deps by @jc-harrison in #6587
- Deduped recieved scopes by @Thingus in #6581
- Bump black from 24.3.0 to 24.4.2 in /flowmachine by @dependabot in #6590
- Bump black from 24.3.0 to 24.4.2 in /flowapi by @dependabot in #6591
- Bump black from 24.3.0 to 24.4.2 in /flowdb/testdata/synthetic_data by @dependabot in #6594
- Bump black from 24.3.0 to 24.4.2 in /flowdb by @dependabot in #6595
- Bump prance from 0.21.8.0 to 23.6.21.0 in /flowapi by @dependabot in #6593
- Bump jsonschema from 4.17.3 to 4.22.0 in /flowapi by @dependabot in #6592
- Bump black from 24.3.0 to 24.4.2 in /flowauth by @dependabot in #6597
- Bump jupyter/scipy-notebook from
a7fb226
to85bef7e
by @dependabot in #6605 - Bump python-rapidjson from 1.16 to 1.17 in /flowmachine by @dependabot in #6611
- Bump quart from 0.19.5 to 0.19.6 in /flowapi by @dependabot in #6606
- Bump jsonschema from 4.17.3 to 4.22.0 in /flowapi by @dependabot in #6596
- Bump python-rapidjson from 1.16 to 1.17 in /flowapi by @dependabot in #6607
- Increase index fillfactor on cache tables by @greenape in #6598
- Bump requests from 2.31.0 to 2.32.2 in /flowkit_jwt_generator by @dependabot in #6620
- Bump pytest-asyncio from 0.23.6 to 0.23.7 in /flowmachine by @dependabot in #6609
- Bump requests from 2.31.0 to 2.32.0 in /flowmachine by @dependabot in #6616
- Bump requests from 2.31.0 to 2.32.0 in /flowauth by @dependabot in #6618
- Bump requests from 2.31.0 to 2.32.0 in /flowapi by @dependabot in #6617
- Bump approvaltests from 12.1.0 to 12.2.0 in /flowmachine by @dependabot in #6610
- Bump jupyter/scipy-notebook from
85bef7e
to053aea4
by @dependabot in #6614 - Ignore null IMEI/IMSI in QA checks by @jc-harrison in #6621
- Bump pytest from 8.2.0 to 8.2.1 in /flowkit_jwt_generator by @dependabot in #6623
- Bump watchdog from 4.0.0 to 4.0.1 in /flowmachine by @dependabot in #6624
- Bump structlog from 24.1.0 to 24.2.0 in /flowdb/testdata/synthetic_data by @dependabot in #6629
- Bump structlog from 24.1.0 to 24.2.0 in /flowapi by @dependabot in #6630
- Bump hypercorn from 0.16.0 to 0.17.2 in /flowapi by @dependabot in #6631
- Bump structlog from 24.1.0 to 24.2.0 in /flowauth by @dependabot in #6633
- Bump hypercorn from 0.17.2 to 0.17.3 in /flowapi by @dependabot in #6635
- Bump requests from 2.32.2 to 2.32.3 in /flowkit_jwt_generator by @dependabot in #6636
- Bump cryptography from 42.0.7 to 42.0.8 in /flowauth by @dependabot in #6640
- Bump cryptography from 42.0.7 to 42.0.8 in /flowkit_jwt_generator by @dependabot in #6641
- Bump pytest from 8.2.1 to 8.2.2 in /flowkit_jwt_generator by @dependabot in #6642
- Bump prettier from 3.2.5 to 3.3.1 in /flowauth/frontend by @dependabot in #6643
- Bump marshmallow from 3.21.2 to 3.21.3 in /flowmachine by @dependabot in #6644
- Bump tornado from 6.4 to 6.4.1 in /flowmachine by @dependabot in #6645
- Bump redis from 5.0.4 to 5.0.5 in /flowauth by @dependabot in #6646
- Bump redis from 5.0.4 to 5.0.5 in /flowmachine by @dependabot in https://github.com/Flowminder/Flow...
1.25.0
Fixed
- FlowETL
get_qa_checks
no longer attempts to create duplicate tasks for QA checks defined in the DAG folder. #6494
Removed
- Removed
flowpyter-task
from the FlowETL Docker image. For a Docker image withflowpyter-task
included, see flowminder/flowbot.
1.24.0
Added
- Test and synthetic data generators now perform QA checks on the generated data. #6467
- Added new
/qa
endpoint to FlowAPI and FlowClient, which supports getting the results of QA checks run by FlowETL #2704 - Added new
available_qa_checks
property to flowmachineConnection
objects #2704 - Added new
get_qa_checks
method to flowmachineConnection
objects #2704
Fixed
- Test QA check IDs are now of the same format as those produced by FlowETL. #6472
- FlowAuth now runs migrations correctly on startup. #6480
What's Changed
- Mock qa data by @Thingus in #6465
- No more before_first_request by @greenape in #6266
- Test qa data rename by @Thingus in #6470
- Bump black from 24.2.0 to 24.3.0 in /flowdb by @dependabot in #6473
- Bump black from 24.2.0 to 24.3.0 in /flowdb/tests by @dependabot in #6476
- Bump express from 4.17.1 to 4.19.2 in /flowauth/frontend by @dependabot in #6481
- Fix missing migrations by @greenape in #6483
- Flowapi qa checks by @Thingus in #6471
Full Changelog: 1.23.0...1.24.0
1.23.0
Changed
-
MostFrequentLocation
now breaks ties based on the last used location, instead of by arbitrary Postgres sort order. #6268 -
Users no longer have write access to the public schema in FlowDB following a change introduced in PostgreSQL 15
-
FlowDB is now built on PostgreSQL 16, debian bullseye
Warning
You may need to update your docker version to use newer releases of FlowDB. You will also need to create a fresh database and reimport data if you are upgrading from a previous FlowDB release.
What's Changed
- Break ties in MostFrequentLocation using last event by @greenape in #6466
- Postgres 16 by @greenape in #6468
- Bump follow-redirects from 1.15.4 to 1.15.6 in /flowauth/frontend by @dependabot in #6469
Full Changelog: 1.22.0...1.23.0
1.22.0
Added
- FlowETL sensor
NRowsPresentSensor
which checks for a specified minimum number of rows.
Changed
ForeignStagingTableOperator
will now error if the underlying file cannot be read or the command returns an error. #5763- Flowmachine now requires SQLAlchemy >= 2.0.0 #6066
What's Changed
- Bump cryptography from 42.0.0 to 42.0.2 in /flowkit_jwt_generator by @dependabot in #6450
- Bump cryptography from 42.0.0 to 42.0.2 in /deployment by @dependabot in #6453
- Fix no poke by @greenape in #6448
- Bump cryptography from 42.0.2 to 42.0.4 in /flowkit_jwt_generator by @dependabot in #6457
- Bump cryptography from 42.0.2 to 42.0.4 in /deployment by @dependabot in #6460
- Bump es5-ext from 0.10.53 to 0.10.63 in /flowauth/frontend by @dependabot in #6462
- Sqlalachemy 2 by @greenape in #6461
- Bump ip from 1.1.5 to 1.1.9 in /flowauth/frontend by @dependabot in #6456
- Bump deps by @greenape in #6463
- Unpin examples from old jupyter by @greenape in #6464
Full Changelog: 1.21.1...1.22.0
1.21.1
Changed
- Upgraded Python dependencies
What's Changed
- Bump deps by @jc-harrison in #6442
- Release 1.21.1 by @jc-harrison in #6443
- Bump cryptography from 41.0.7 to 42.0.0 in /flowkit_jwt_generator by @dependabot in #6444
- Bump cryptography from 41.0.7 to 42.0.0 in /deployment by @dependabot in #6446
Full Changelog: 1.21.0...1.21.1
1.21.0
Added
- Added new FlowDB tables
infrastructure.cell_info
andinfrastructure.cells_table_versions
to keep track of changes to the cell info over time (note: the new tables have not yet replacedinfrastructure.cells
as the source of cell information for FlowKit queries). #6184
What's Changed
- Bump tiangolo/uwsgi-nginx-flask from
0ceb6c7
tof918c2e
by @dependabot in #6412 - Bump deps by @jc-harrison in #6413
- Remove AutoFlow references from docs by @jc-harrison in #6410
- Bump cryptography from 41.0.5 to 41.0.6 in /flowapi by @dependabot in #6415
- Bump cryptography from 41.0.5 to 41.0.6 in /flowkit_jwt_generator by @dependabot in #6414
- Bump cryptography from 41.0.5 to 41.0.6 in /deployment by @dependabot in #6416
- Bump black from 23.7.0 to 23.11.0 in /flowkit_jwt_generator by @dependabot in #6418
- Bump cryptography from 41.0.6 to 41.0.7 in /flowkit_jwt_generator by @dependabot in #6417
- Bump sqlalchemy from 1.4.50 to 2.0.23 in /flowmachine by @dependabot in #6419
- Bump ipykernel from 6.26.0 to 6.27.1 in /flowmachine by @dependabot in #6421
- Bump pyyaml from 5.3.1 to 6.0.1 in /flowapi by @dependabot in #6423
- Bump prance from 0.21.8.0 to 23.6.21.0 in /flowapi by @dependabot in #6425
- Bump black from 23.9.1 to 23.11.0 in /flowmachine by @dependabot in #6420
- Bump jsonschema from 4.17.3 to 4.20.0 in /flowapi by @dependabot in #6424
- Bump deps by @jc-harrison in #6426
- Bump deps by @jc-harrison in #6430
- Bump deps by @jc-harrison in #6432
- Bump follow-redirects from 1.14.9 to 1.15.4 in /flowauth/frontend by @dependabot in #6434
- Bump gitpython from 3.1.40 to 3.1.41 in /flowdb/tests by @dependabot in #6436
- Bump jinja2 from 3.1.2 to 3.1.3 in /flowauth by @dependabot in #6437
- Bump jinja2 from 3.1.2 to 3.1.3 in /deployment by @dependabot in #6438
- Cell info table by @jc-harrison in #6433
Full Changelog: 1.20.0...1.21.0
1.20.0
Changed
- Updated flowpyter-task to 1.1.0
Removed
- Removed AutoFlow. #6394
What's Changed
- Bump prettier from 3.0.3 to 3.1.0 in /flowauth/frontend by @dependabot in #6400
- Bump numpy from 1.25.2 to 1.26.2 in /flowdb/testdata/synthetic_data by @dependabot in #6403
- Bump pandas from 2.1.2 to 2.1.3 in /flowdb/testdata/synthetic_data by @dependabot in #6402
- Bump cypress from 13.5.0 to 13.5.1 in /flowauth/frontend by @dependabot in #6404
- Bump deps and pin base images by @jc-harrison in #6406
- Bump cypress from 13.5.1 to 13.6.0 in /flowauth/frontend by @dependabot in #6408
- Bump flowpyter-task to 1.1.0 by @greenape in #6409
Full Changelog: 1.19.1...1.20.0
1.19.1
Added
- flowpyter-task now included in the flowetl image
What's Changed
- Bump black from 23.10.1 to 23.11.0 in /flowdb by @dependabot in #6396
- Bump cypress from 13.3.3 to 13.5.0 in /flowauth/frontend by @dependabot in #6397
- Remove AutoFlow by @jc-harrison in #6395
- Bump actions/checkout from 2 to 4 by @dependabot in #6398
- Bump python deps and Airflow by @jc-harrison in #6393
- Adding flowpytertask to flowetl requirements by @Thingus in #6286
Full Changelog: 1.19.0...1.19.1