replace "jaar_type" "otx_word", "hub_label" with "otx_group_id", "otx_acct_id", "otx_road", "otx_label", really simplifies a lot and makes the explanations cleaner - Githubissues

jschalk / jaar

Cross-cultural communication engine built on customizable economic systems. Produces personalized agendas, calendars, finance reports for users.

0 stars 1 forks source link

replace "jaar_type" "otx_word", "hub_label" with "otx_group_id", "otx_acct_id", "otx_road", "otx_label", really simplifies a lot and makes the explanations cleaner #388

Closed jschalk closed 3 days ago

jschalk commented 6 days ago

[x] create GroupBridge and get it working, perhaps inherit class methods from BridgeUnit
[x] create AcctBridge and get it working, perhaps inherit class methods from BridgeUnit
[x] create RoadBridge and get it working, perhaps inherit class methods from BridgeUnit
[x] create BridgeCore class that will be inherited by GroupBridge, AcctBridge, RoadBridge
[x] move attrs and methods from BridgeUnit to BridgeCore until BridgeUnit can be deleted.
[x] delete BridgeUnit from codebase

jschalk commented 5 days ago

[x] delete birdgeunit_old.py

jschalk commented 5 days ago

[x] get "is_valid" working for acctbridge, groupbridge, roadbridge
[x] get "get_create_inx" working for acctbridge, groupbridge, roadbridge

jschalk commented 5 days ago

having problems with RoadBridge.reveal_inx() because of roadnode/roadunit difference. Obvious solution is to create UnitRoadBridge and NodeRoadBridge. And then using otx_label, inx_label and otx_road, otx_road Going to close this ticket for now. Leaving thecode in the codebase because probably will have to come back to this.

jschalk commented 4 days ago

[x] rewrite jungle to zoo tests so that otx2inx sheets with jaar_type is replaced by acct_stage, group_stage, node_stage, road_stage

jschalk commented 4 days ago

[x] break up test_world_jungle_to_zoo into "test_world_0_jungle_to_zoo", "test_world_1_zoo_to_otx_staging", "test_world_2_staging_to_agg"

jschalk commented 4 days ago

[ ] create test_world_etl1_zoo_otx_group
[ ] create test_world_etl1_zoo_otx_node
[ ] create test_world_etl1_zoo_otx_road
[ ] consider deleting nub_label meme

jschalk commented 4 days ago

[ ] add test that confirms bridge_acct_id brick etl creates acct_agg sheet and does not delete current "group_agg" sheet

jschalk commented 4 days ago

[ ] add update_or_create_excel_sheet to pandas tools

[ ] replace all excel writes with update_or_create_excel_sheet

def update_or_create_sheet(file_path, sheet_name, dataframe):
"""
Updates or creates an Excel sheet with a specified DataFrame.

Args:
- file_path (str): The path to the Excel file.
- sheet_name (str): The name of the sheet to update or create.
- dataframe (pd.DataFrame): The DataFrame to write to the sheet.
"""
# Check if the file exists
if not os.path.exists(file_path):
    # If file does not exist, create it with the specified sheet
    with pd.ExcelWriter(file_path, engine='xlsxwriter') as writer:
        dataframe.to_excel(writer, sheet_name=sheet_name, index=False)
    print(f"File '{file_path}' created with sheet '{sheet_name}'.")
    return

# If the file exists, check for the sheet
try:
    with pd.ExcelWriter(file_path, engine='openpyxl', mode='a', if_sheet_exists='replace') as writer:
        dataframe.to_excel(writer, sheet_name=sheet_name, index=False)
    print(f"Sheet '{sheet_name}' in file '{file_path}' replaced successfully.")
except Exception as e:
    print(f"An error occurred: {e}")