Skip to content

Latest commit

 

History

History
47 lines (35 loc) · 1.75 KB

README.md

File metadata and controls

47 lines (35 loc) · 1.75 KB
Raw

Event generator for scheduler based applications

Github Hosted URL: https://react-scheduler

Use cases

  1. CRON job scheduling
  2. Event management scheduling

Haivng an experience into database development using SQL Server, inspiration of building event generation applicaiton on ReactJS landed when I learned about dbo.sysschedule table in SQL Server. Going through the design of sysschedule table, it was quite impressive how MS managed this entire table using just a flat table structure represented by JSON in our case.


This JSON structure cater all the different type of schedules that can be built using this application. Few modifications were done to enhance the functionality

{
  "name": "Christmas fest",
  "description": "Description goes here",
  "freq_type": 1,
  "freq_interval": 0,
  "freq_relative_interval": 0,
  "freq_recurrence_factor": 0,
  "active_start_date": "2021-12-17",
  "active_end_date": "2021-12-17",
  "active_start_time": "02:00",
  "active_end_time": "02:00",
  "freq_subday_type": 1,
  "freq_subday_interval": 0,
  "duration_subday_type": 1,
  "duration_interval": "",
  "occurance_choice_state": false
}

When the submit button is clicked, it generates all the events that this schedule is supposed to have.

SQL Server job scheduler image not available

To setting up local machine with requirements - follow requirements.txt

Edit package.json

"homepage": "http://<your-github-account>.github.io/<your-repo-name>"