This is a framework developed in Perl to analyse the data created by the Avenir systems. The analysis done by the framework will help with finding trends within the products developed, which could help to make the products more user-friendly and efficient.
I have created/ collected a bunch of tutorials for people who are interested in learning the basics of Perl and SQL:
- Perl Tutorial
- SQL Commands & Syntaxes
- Basic Data analysis Learnings
- Setting up your own VM with Debian
- Gnuplot: Graphing Tutorial for noobs
- To run all all scripts and store them in the 'reports' directory:
perl main
or./run
- To run files from a specific directory:
perl main -s scripts/aix
- To run files from a specific file:
perl main -s scripts/aix/action_count.sql
- To store reports in a specific directory:
perl main -d reports/aix
- To format the script file type:
perl main -f csv
- To set the name of the client server:
perl main -c aix
- Source :
-src
or-s
- Destination:
-dest
or-d
- Format:
-format
or-f
- Client:
-client
or-c
- Graph:
-g
To graph the reports generated by the framework you can do one of the following:
- Execute the 'run' bash script with the flag
-g
following the path to file./run -g reports/topFeatures.sql
- Learn basic and Perl and SQL ๐ (checkout the tutorials I made!)
- Set up VM ๐
- Develop a Perl framework that runs SQL on Avenir database
- Recursively execute sql files from any directory
- Move modules to seperate 'pm' files
- Generate command line flags for users
- Add Error log message with a timestamp
- Create run and install bash scripts
- Exception handling for subroutines
- Generate graphs based on report files generated by SQL queries using Gnuplot
- Create a list of trends to be found and make SQL scripts for them
- Make the graphs available for users online (maybe via webserver?) - more research needed
- Find trends within the products by checking the data returned by the SQL queries ๐
- Add any details about framework in Wiki
- More to come ๐
๐