Week 5

July 24th 2023

• Testing Streamlit Apps and negative testing
• Documenting the testing details
• Adding Streamlit documentation to CCTV-docs. PR opened here
• PR closed
  • Update: The documentation has been moved to https://projects.gqc.com/internal/CCTV/

July 25th 2023

• Completed testing Streamlit apps. Documented them in the issue here and closed it. Also, documented it on projects.gqc.com

July 26th 2023

• Created a duplicate copy of SD1_label_images notebbok as 'metro_label_images' in gqc-utility.
• Cleaned SD1 notebook to get rid of other utility code and unnecessary code.
• To-Do
  • Migrate .bashrc changes on MSI to Ubuntu server (under Jake's desk)
  • Look into naming conventions for DB tables
    • Inconsistent names causes problem to run SQLite queries.
    • For example, tables with spaces in the names have to be quoted with '' in order to run the SQL query.
    • This will also not support using autofill on pressing tab.
  • Look into PPT Deven used for presentation (under /Srujana/downloads/)
  • Capture data flow and logic (especially for labelling) using Excalidraw or any tool

July 27th 2023

• To-Do
  • PACP Code
    • Verify the SD1 PACP code list Vannary sent
    • Ask SD1 for code list? Mostly no
  • all_conditions table
    1. video_file & distance as primary composite key
    2. code = [c1 c2 c3]
  • Labelled_frame table
    • To have 'fname' with extension
  • Update labels col where condition_code_list != NULL

July 28th 2023

• Add in Dev docs - not to paste images inside notebooks but reference them as hyperlinks by saving images in the repository
  • Added in python > best practices in general site.
• Make changes to repositories - streamlit details in pipe-breaks-transfer-learning
• Rename lifelines env to pipe-breaks env on MSI
• Need env for prediction
• Resonate34 - look into it
• Fix the regex in flood-cv {put a * instead of +}
  • cctv_name : use path instead of regex to split on / and on . to get file name
• Remove the flood_cv repo
• Set passwords (static-web-apps -> app -> configuration -> general settings)