search

SEMOSS / Semoss_new_hire

Used to onboard new hires. Prevent added noise to the Semoss repo to prevent confusion. This is a way to teach the git remote workflow and check pull requests that aren't intended for Semoss but rather to train new hires. This also, will allow us to not confuse admins of the main Semoss repo with nonsensical pull requests.
Apache License 2.0
0 stars 0 forks source link

WeatherToExcelReactor #2

Open EJV20 opened 4 weeks ago

EJV20 commented 4 weeks ago

Task

Create a new branch with your username but do not push the branch. Implement a WeatherToExcelReactor that generates an Excel spreadsheet containing daily weather data for a fictional location over a specified duration. Additionally, save this data in the security database in new table(s). The user must provide the following information in the Reactor call - "Name of the fictional place", "Name of the real place", "the duration, which can be days months or years" (10 days or 10 months or 10 years etc), "the starting date". Create another reactor that returns all the data for a made up place.

Excel Spreadsheet Format:

Filename: Format as "location - duration.xlsx". Examples: "Jeffland - 10 years.xlsx", "Roseville - 5 months.xlsx". Data Columns: Date, High, Low, etc. Daily data example: 01-02-2022, 60, 50, etc. Summary statistics at the bottom: Mean: mean, mean, etc. Median: median, median, etc Mode: Mode, Mode, etc Standard Deviation: stddev, stddev, etc.

Database Integration:

Save the generated weather data in new table(s) within the security database. This can be accessed by going to settings and running a query in admin mode in Semoss, within the security DB.

Refer to AbstractSecurityUtils.init() for information about the database structure. Update SecurityOwlCreator as relevant. Look around the file system for examples.

Existing Codebase References:

Reactors: LLMReactor ToExcelReactor Database Initialization: AbstractSecurityUtils.init() Security Integration: SecurityOwlCreator

manamittal commented 2 weeks ago

Task

Create a new branch with your username and issue number (git checkout -b ejv20-2) and implement a WeatherToExcelReactor that generates an Excel spreadsheet containing daily weather data for a fictional location over a specified duration. Additionally, save this data in the security database in new table(s) and push the changes to a remote repository.

The user must provide the following information in the Reactor call - "Name of the fictional place", "Name of the real place", "the duration, which can be days months or years" (10 days or 10 months or 10 years etc), "the starting date".

Excel Spreadsheet Format:

Filename: Format as "location - duration.xlsx". Examples: "Jeffland - 10 years.xlsx", "Roseville - 5 months.xlsx". Data Columns: Date, High, Low, etc. Daily data example: 01-02-2022, 60, 50, etc. Summary statistics at the bottom: Mean: mean, mean, etc. Median: median, median, etc Mode: Mode, Mode, etc Standard Deviation: stddev, stddev, etc.

Database Integration:

Save the generated weather data in new table(s) within the security database. This can be accessed by going to settings and running a query in admin mode in Semoss, within the security DB.

Refer to AbstractSecurityUtils.init() for information about the database structure. Update SecurityOwlCreator as relevant. Look around the file system for examples.

Existing Codebase References:

Reactors: LLMReactor ToExcelReactor Database Initialization: AbstractSecurityUtils.init() Security Integration: SecurityOwlCreator

To push from your local Semoss repo, to the remote Semoss_new_hire repo you can do the following:

git remote add newHire https://github.com/SEMOSS/Semoss_new_hire git push newHire Then go to Github to make a pull request