aboutsummaryrefslogtreecommitdiffstats
path: root/src
Commit message (Collapse)AuthorAgeFilesLines
* Deleted the fact_table schema py fileslian-manonog2024-08-234-233/+157
| | | | | | Completed Lambda_handler for transform_lambda - and other helper functions. Testing is still to be done. Need to implement lambda layer to share helper functions across all lambdas
* dataframes combined into one fileT-Aji2024-08-231-0/+238
|
* Merge branch 'feature/transform-fact-sales-order' of ↵T-Aji2024-08-232-5/+53
|\ | | | | | | https://github.com/ajschofield/de-project-bentley into feature/transform-fact-sales-order
| * wip: wrote pseudocode for lambda handler in writing df to parquet file ↵lian-manonog2024-08-222-5/+53
| | | | | | | | format and uploading the parquet files
* | payment schema addedT-Aji2024-08-232-2/+46
|/
* complete code for tables for purchase schema including a scrape for ↵Ang Bel2024-08-221-18/+48
| | | | currency table. Test to be done
* add fact tableT-Aji2024-08-221-50/+0
|
* Merge branch 'feature/transform-fact-sales-order' of ↵T-Aji2024-08-221-23/+30
|\ | | | | | | https://github.com/ajschofield/de-project-bentley into feature/transform-fact-sales-order
| * refactored approach to writing transformation as functions per df. WIPAng Bel2024-08-221-23/+30
| |
* | add fact tableT-Aji2024-08-221-4/+31
|/
* passing tests create_dim_design and create_dim_staffT-Aji2024-08-221-0/+50
|
* refactor df creation into funcT-Aji2024-08-221-70/+34
|
* wip: creating dim dataframesT-Aji2024-08-223-9/+58
|\
| * wip: fact_purchase_order schemalian-manonog2024-08-213-3/+37
| |
| * style: format code with Autopep8, Black and Ruff Formatterdeepsource-autofix[bot]2024-08-211-18/+68
| | | | | | | | | | | | This commit fixes the style issues introduced in 20a3bd8 according to the output from Autopep8, Black and Ruff Formatter. Details: https://github.com/ajschofield/de-project-bentley/pull/85
* | began dim_date dfT-Aji2024-08-211-18/+17
|/
* 5 dim tables createdT-Aji2024-08-211-15/+33
|
* add dim tables: design, staff, currency, location (wip)Ellie2024-08-211-0/+54
|
* Merge branch 'development' into feature/transform_lambdabulve-ad2024-08-214-96/+86
|\
| * chore: tidy-up repository & remove unused filesAlex Schofield2024-08-201-49/+0
| |
| * feat: add more logging for debuggingAlex Schofield2024-08-201-2/+5
| |
| * refactor: change rows output to debug logger outputAlex Schofield2024-08-201-2/+1
| |
| * feat: add additional logging and exclude unnecessary tableAlex Schofield2024-08-201-5/+7
| |
| * feat: add advanced loggingAlex Schofield2024-08-201-5/+11
| |
| * feat: conditional logic for if bucket is emptyAlex Schofield2024-08-201-9/+23
| |
| * feat: revert s3 streaming to previous implementation for uploadingAlex Schofield2024-08-201-31/+25
| |
| * fix(extract_lambda): fix UnboundLocalError when db is called before it is ↵Alex Schofield2024-08-201-0/+1
| | | | | | | | assigned a value
| * refactor: optimise s3 streaming & file namingAlex Schofield2024-08-191-11/+6
| |
| * feat: use buffers for s3 upload instead of csv filesAlex Schofield2024-08-191-17/+33
| |
| * refactor: remove print statements in process_and_upload_tablesAlex Schofield2024-08-191-2/+0
| |
| * refactor: add timestamp function in extract_lambda.pyAlex Schofield2024-08-191-12/+17
| |
| * chore: reorganise imports in extract_lambdaAlex Schofield2024-08-191-5/+5
| |
| * refactor(retrieve_secrets): add logging for ClientErrorAlex Schofield2024-08-191-0/+1
| |
| * refactor(retrieve_secrets): improve error handling when retrieving secretsAlex Schofield2024-08-191-0/+3
| |
| * refactor(lambda_handler): remove unnecessary else statementAlex Schofield2024-08-191-8/+7
| |
| * refactor(retrieve_secrets): use aws recommended method for retrieving secretsAlex Schofield2024-08-191-8/+11
| |
| * refactor(log): implement logging ancestry - avoid using root loggerAlex Schofield2024-08-191-1/+1
| |
| * Merge branch 'development' into feature/test-process-upload-tables-v2Alex2024-08-191-0/+1
| |\
| | * Merge branch 'development' into extract-lambda-code-updateAlex2024-08-193-17/+18
| | |\
| | * | wip: fixed broken tests; hashed out test_error_retrieving_objectlian-manonog2024-08-191-0/+1
| | | |
| * | | style: format code with Autopep8, Black and Ruff Formatterdeepsource-autofix[bot]2024-08-191-5/+3
| | | | | | | | | | | | | | | | | | | | | | | | This commit fixes the style issues introduced in 4f629e5 according to the output from Autopep8, Black and Ruff Formatter. Details: https://github.com/ajschofield/de-project-bentley/pull/65
| * | | add working process and upload tables testEllie2024-08-191-2/+2
| | | |
| * | | wip: fixing last testEllie2024-08-191-2/+3
| | |/ | |/|
| * | style: format code with Autopep8, Black and Ruff Formatterdeepsource-autofix[bot]2024-08-193-17/+18
| |/ | | | | | | | | | | This commit fixes the style issues introduced in e27c6b4 according to the output from Autopep8, Black and Ruff Formatter. Details: https://github.com/ajschofield/de-project-bentley/pull/55
* | style: format code with Autopep8, Black and Ruff Formatterdeepsource-autofix[bot]2024-08-211-16/+20
| | | | | | | | | | | | This commit fixes the style issues introduced in b882bb0 according to the output from Autopep8, Black and Ruff Formatter. Details: https://github.com/ajschofield/de-project-bentley/pull/84
* | complete version of read from s3 subfolderAng Bel2024-08-211-32/+1
| |
* | (tests) Read from s3 to df passesAng Bel2024-08-211-22/+4
| |
* | function to write files from s3 into a list of dataframes. Current test is ↵Ang Bel2024-08-211-4/+30
| | | | | | | | failing due to AioClientCreator object has no attribute "_inject_s3_input_parameters"
* | wip: just more pseudocodelian-manonog2024-08-201-12/+26
| |
* | wip: writing pseudocode logic for the lambda_handlerlian-manonog2024-08-201-14/+22
| |
git.ajschof.me — hosted by ajschofield — powered by cgit