Feluda

Chore

* chore: amazon mq send_message lint fix ([`063096c`](https://github.com/tattle-made/feluda/commit/063096cecf0b980d1f95482fc189a7825c8ac917))

* chore: adding else condition of media_type ([`4e6e4eb`](https://github.com/tattle-made/feluda/commit/4e6e4eb6c7c66a299bfcb43dabaeee36d825acbb))

* chore: media_type is command line arg in payload writer ([`9d0fa4e`](https://github.com/tattle-made/feluda/commit/9d0fa4eaf2094201a15ee18c1c8c96d4c9ef9d4c))

* chore: store check ([`2df0db6`](https://github.com/tattle-made/feluda/commit/2df0db66cc090cb4dce52deb632092d9168dd4e4))

Feature

* feat: media worker supports amazon mq ([`8b92b7f`](https://github.com/tattle-made/feluda/commit/8b92b7fb19daefa83a80c263771dea29c3001417))

* feat: Amazon MQ ([`766b805`](https://github.com/tattle-made/feluda/commit/766b8050e86e4eee23c10bf634b0c72e14091314))

* feat: media worker supports audio ([`b92a4d4`](https://github.com/tattle-made/feluda/commit/b92a4d47b47abe3f6335e2011c5f9d760c12d6e8))

* feat: media worker supports video ([`ffba9cd`](https://github.com/tattle-made/feluda/commit/ffba9cda73d4ec6baabbced19409d5dbdb33e7c4))

Fix

* fix: Updated vulnerable pillow dependency in requirements ([`efd1be8`](https://github.com/tattle-made/feluda/commit/efd1be8bf979d27383e3c7cad2b11a26003ede39))

* fix: setting up payload for audio ([`3a87ce0`](https://github.com/tattle-made/feluda/commit/3a87ce03a3d7d21aa7f0a60a960d28516a7799a8))

* fix: postgres media worker table ([`dd974d2`](https://github.com/tattle-made/feluda/commit/dd974d2837a0b01301f1d66933d99a3f66fcd581))

* fix: media factory audio function update & setting up media worker ([`2e0fda5`](https://github.com/tattle-made/feluda/commit/2e0fda53bf28ea7d652b60075a99ed6cdeb0b2b5))

Refactor

* refactor: config supports postgres & feat: setting up media payload writer ([`f43f205`](https://github.com/tattle-made/feluda/commit/f43f2057c695425f6c9fc1fc552910a85f7f1d79))

Unknown

* Merge pull request 257 from tattle-made/hotfix

Hotfix ([`67ac03a`](https://github.com/tattle-made/feluda/commit/67ac03aba15a1f7dbad0641f9539cec09a9b7bdb))

* Merge pull request 256 from duggalsu/update_pillow

Update pillow ([`44b0f88`](https://github.com/tattle-made/feluda/commit/44b0f88e4de6d566bbb6ed8fb6ab0a0db0fe5ec4))

Ci

* ci: Added npm ci for pinned package installation
- Added setup node version action ([`fd4a8f1`](https://github.com/tattle-made/feluda/commit/fd4a8f10d85aa2688589215a106224bfc7aead68))

* ci: Added using ruff action for CI linting ([`ed89995`](https://github.com/tattle-made/feluda/commit/ed89995589dc55b2a251b3c49696c303891d17cf))

Fix

* fix: Add pinned dev requirements
- Added dev requirements for feluda core, video and audio benchmark
- Fixed video benchmark not working without new boto3 dependency
- Fixed audio benchmark not working without new wget dependency ([`d974e7e`](https://github.com/tattle-made/feluda/commit/d974e7e0ff262e46a779add1e4f1aeaef4e70f25))

Unknown

* Merge pull request 244 from tattle-made/hotfix

Hotfix ([`7bae56d`](https://github.com/tattle-made/feluda/commit/7bae56d6cbcf7896bdfe0c79d9e1e76869d04c3d))

* Merge pull request 243 from duggalsu/add_dev_requirements

Add dev requirements ([`aa2c09f`](https://github.com/tattle-made/feluda/commit/aa2c09f9d9607880e3e9eb1e418aa5044294c960))

* Merge pull request 242 from tattle-made/hotfix

Hotfix ([`efb06e5`](https://github.com/tattle-made/feluda/commit/efb06e57791e47b27303e0419307f8b8236669fb))

* Merge pull request 241 from duggalsu/use_npm_pinned

Use npm pinned ([`52a4bbf`](https://github.com/tattle-made/feluda/commit/52a4bbf4e7f24936ee8ed1703fbe806b93da62c9))

* Merge pull request 240 from duggalsu/use_ci_ruff_action

ci: Added using ruff action for CI linting ([`5d7137b`](https://github.com/tattle-made/feluda/commit/5d7137bb29e71a09d30ece4fc9e535bd9c8dd872))

Chore

* chore: Added security policy ([`2628ddb`](https://github.com/tattle-made/feluda/commit/2628ddbbaaf05bae7feb794a3c4c9fed53b650b7))

Ci

* ci: Fix bandit to run from single workflow
- Added bandit.yml to run on PR
- Disabled bandit from pr-security.yml ([`e441f2e`](https://github.com/tattle-made/feluda/commit/e441f2e14291451d70b61ca955dae71ecc3646cd))

* ci: Added ci test for media file hash operator ([`e5f6414`](https://github.com/tattle-made/feluda/commit/e5f64141f3c594f04e0d6f5701a3ae5d9c98bfff))

Fix

* fix: Added pinned pip package
- Added base requirements.in with pip
- Created base requirements.txt with pip pinned by hash
- Recreated requirements.txt with --allow-unsafe to get correct setuptools
- Updated feluda core dockerfile to install pip using base requirements
- Updated ci test dockerfile to install pip using base requirements
- Updated all benchmark dockerfiles to install pip using base requirements
- Updated all worker dockerfiles to install pip using base requirements
- Updated readme pip install and pip-compile commands ([`810a45e`](https://github.com/tattle-made/feluda/commit/810a45eae4b681799173286b683e64b2d387e38f))

Unknown

* Merge pull request 239 from tattle-made/hotfix

Hotfix ([`3113756`](https://github.com/tattle-made/feluda/commit/31137560f3099895918e4e27d35d9537a8344074))

* Merge pull request 238 from duggalsu/add_base_requirements

Add base requirements ([`0391f2a`](https://github.com/tattle-made/feluda/commit/0391f2a5cbc6ab05d663332e3c35179581398479))

* Merge pull request 237 from tattle-made/hotfix

Hotfix ([`83e2efd`](https://github.com/tattle-made/feluda/commit/83e2efd7d643ccd89c1be9c9131e2428dae7aa5e))

* Merge pull request 236 from duggalsu/fix_bandit_codeql_warning

Fix bandit codeql warning ([`a7c05bb`](https://github.com/tattle-made/feluda/commit/a7c05bba72bbff11c5aac44f7e93959f09a3e557))

* - Test inverted ternary operator ([`fe03cb5`](https://github.com/tattle-made/feluda/commit/fe03cb5059c53771f7d8f32098f678795be9037c))

* - Modify env settings ([`2d48897`](https://github.com/tattle-made/feluda/commit/2d488971013c8cdccc0fd84f320ad012571a7f9e))

* - Test switch conditional values ([`7f1315a`](https://github.com/tattle-made/feluda/commit/7f1315a3318f71cc4d915f974369a97c2e392f83))

* - Set conditional falsy and truthy values ([`f85d164`](https://github.com/tattle-made/feluda/commit/f85d164d8237b8a01d2f3ffa72c82c383f5268cd))

* - Fix env var boolean setting ([`68923a6`](https://github.com/tattle-made/feluda/commit/68923a683dffaeecb2697e51f7d5be16a7e51141))

* - Added conditional exit_zero for bandit ([`764b8bb`](https://github.com/tattle-made/feluda/commit/764b8bbf79a9caa3f3445ad9d1981309739704ea))

* Merge pull request 235 from tattle-made/hotfix

Hotfix ([`650a379`](https://github.com/tattle-made/feluda/commit/650a379bbc6ecc92ae4cc5a0e397d17e04a69578))

* Merge pull request 234 from duggalsu/add_ci_test_media_file_hash

Add ci test media file hash ([`88f1d30`](https://github.com/tattle-made/feluda/commit/88f1d3062ef3ada6ecb767cb389c50db9ebfebf5))

* Merge pull request 233 from tattle-made/hotfix

Hotfix ([`13829a6`](https://github.com/tattle-made/feluda/commit/13829a6d4b72dbb49450572d5d827e0c2b88a952))

* Merge pull request 232 from duggalsu/add_security_policy

Add security policy ([`f0f6d70`](https://github.com/tattle-made/feluda/commit/f0f6d701dc3117c16c0e542c0201784c6ae8d7f9))

Chore

* chore: adding context manager to audio operator ([`38f610f`](https://github.com/tattle-made/feluda/commit/38f610fa6101fcdcd80b02d43e61dec514685e1a))

* chore: updating table name ([`c015d30`](https://github.com/tattle-made/feluda/commit/c015d30b9dad79617195b1cab31a4b6491490933))

Ci

* ci: Added PR checks to run on main branch ([`efc63e7`](https://github.com/tattle-made/feluda/commit/efc63e716bfd224bad7cc07864ab0db999bd24cb))

Feature

* feat: Added audio CRC write to postgres
- Modified video worker column value ([`17ca1a7`](https://github.com/tattle-made/feluda/commit/17ca1a72b8b47ba9203a9ac7f107e40d5b4d248d))

* feat: Add video CRC to postgres
- Created trigger function for updating timestamp
- Modified create table function with conditional for table
- Added create table for storing CRC
- Added function to create trigger for table
- Modified store and update functions to store worker_column
- Added postgres init and call to storing video CRC
- Pinned images in docker compose ([`f11e1c8`](https://github.com/tattle-made/feluda/commit/f11e1c844512e138e7420a5469416f9707cc2b3e))

* feat: hash worker can add data to postgresql ([`eae1993`](https://github.com/tattle-made/feluda/commit/eae1993db5f043b1c8e04b4fb7fcec4d67191114))

* feat: Added creation of CRC for video and audio vec for media matching ([`ca52993`](https://github.com/tattle-made/feluda/commit/ca529937c13f6b998541d6e0363d179991426232))

* feat: Add calculating video vec CRC for media matching ([`9d57125`](https://github.com/tattle-made/feluda/commit/9d571257f8bb41a495160a62847ca46db4ab838c))

Fix

* fix(security): SQL issues
- Replaced all dynamic SQL with prepared statements
- Removed all f-strings
- Added str conversion to hash function on db store as failsafe ([`8e86b2a`](https://github.com/tattle-made/feluda/commit/8e86b2a0937a3092ba49c8357a5ad7753daa3cc3))

* fix(security): SQL issues

Conflicts:
src/core/store/postgresql.py ([`3a5f003`](https://github.com/tattle-made/feluda/commit/3a5f003cafe0e1342eb352aea2e59a514b9bc475))

* fix: store and update postgres functions to support hash worker ([`1511228`](https://github.com/tattle-made/feluda/commit/151122862a4cfe1adbaf9dbdd7999f3c5319e5e2))

* fix: postgres store and update func in hash worker ([`f7cb056`](https://github.com/tattle-made/feluda/commit/f7cb056fc9cd7a201ebb8d73726857dc5438ed51))

* fix: Update urllib3 package and fix feluda core dockerfile
- Updated urllib3 manually for botocore compatibility
- Updated groupadd, useradd and mkdir commands to handle failure
- Added setting python user to debug image
- Added venv volume to feluda api in docker compose file
- Added build args for feluda indexer and reporter
- Added volumes in docker compose file ([`317c2a0`](https://github.com/tattle-made/feluda/commit/317c2a09a7bfa0daebff97b78ff5d35a05c06af3))

Refactor

* refactor: commenting init func ([`bbdffbe`](https://github.com/tattle-made/feluda/commit/bbdffbece59cd5fb737f48df6299235f4c0aa542))

Unknown

* Merge pull request 230 from tattle-made/development

merge dev to main ([`ed75278`](https://github.com/tattle-made/feluda/commit/ed752788090d1b1c7fdfa84e6389116bd68985ac))

* Merge pull request 229 from duggalsu/test_sql

Fix SQL queries ([`81a99ed`](https://github.com/tattle-made/feluda/commit/81a99eda41303fb1f7138a5453640d3d2652ed8f))

* Merge pull request 228 from aatmanvaidya/hash-worker-update

fix: postgres store and update func in hash worker ([`27f6715`](https://github.com/tattle-made/feluda/commit/27f671523fa2eb9643308d884b8244be9bbac743))

* Merge pull request 227 from aatmanvaidya/audio-delete

chore: adding context manager to audio operator ([`bd6202f`](https://github.com/tattle-made/feluda/commit/bd6202ff12b06612f529285f44a1821c2b1f9678))

* Merge pull request 226 from duggalsu/add_crc_postgres_audio

feat: Added audio CRC write to postgres ([`ddc008a`](https://github.com/tattle-made/feluda/commit/ddc008a4beffcb55d71080670968b0965c6d5692))

* Merge pull request 225 from duggalsu/add_crc_postgres

feat: Add video CRC to postgres ([`6d173bb`](https://github.com/tattle-made/feluda/commit/6d173bba4a729a172697b2059737d34029ffbb28))

* Merge pull request 224 from tattle-made/hotfix

Hotfix ([`34f3ed0`](https://github.com/tattle-made/feluda/commit/34f3ed0c6e03ef765cb3c29140f635982ed68c34))

* Merge pull request 223 from duggalsu/add_pr_checks_main

Add pr checks main ([`aceb907`](https://github.com/tattle-made/feluda/commit/aceb9078c991a239d04227214b8519f06635fbbf))

* Merge pull request 222 from duggalsu/update_urllib3_audio_video_requirements

fix: Update urllib3 package and fix feluda core dockerfile ([`e5e5f4e`](https://github.com/tattle-made/feluda/commit/e5e5f4e29e73cc2afc478cc925f00b430b3430d6))

* Merge pull request 221 from aatmanvaidya/postgres-hash

feat: hash worker can add data to postgresql ([`c34a6b3`](https://github.com/tattle-made/feluda/commit/c34a6b39e28d26c01a83f94690101a394009573e))

* Merge pull request 220 from duggalsu/impl_media_crc

Impl media crc ([`f4018b0`](https://github.com/tattle-made/feluda/commit/f4018b01ad62183ae1bde2026aed272da6d5f8a5))

Fix

* fix(ci): Fixed github workflow docker build args format ([`b6a3d14`](https://github.com/tattle-made/feluda/commit/b6a3d14ee6f12b7614fcd2613abc3879a9505f8c))

Unknown

* Merge pull request 219 from tattle-made/hotfix

Hotfix ([`4b4a3ff`](https://github.com/tattle-made/feluda/commit/4b4a3ffebd2241add79a676d4a196b7ca2e7faa7))

* Merge pull request 218 from duggalsu/fix_docker_build_args_format

Fix docker build args format ([`fe1adfd`](https://github.com/tattle-made/feluda/commit/fe1adfd9593131245889932722ed9f2ece853032))

Fix

* fix(ci): Added docker build args to github workflows ([`496d600`](https://github.com/tattle-made/feluda/commit/496d60029d2ef9cc8b95ed3ca4e88d3d5f511aa0))

Unknown

* Merge pull request 217 from tattle-made/hotfix

Hotfix ([`c039f63`](https://github.com/tattle-made/feluda/commit/c039f631d7c8f39e7b7a123fc17519f5103a103d))

* Merge pull request 216 from duggalsu/fix_docker_build_args

Fix docker build args ([`ef9c159`](https://github.com/tattle-made/feluda/commit/ef9c1596b79595bbfab65b5b0b71dc3fe520dc09))