Build External MySQL Database & Cron Job - Contract to Hire
Phase I: Build External MySQL Database (dB #2) on BlueHost VPS Apache Server subdomain
1.install MySQI database (dB #2) on subdomain;
2. check WooCommerce (WC) to confirm that HPOS is turnrd off;
3. create a “WP/WC Customer Data Dictionary.” This document consisting of all the WP tables which store all the data needed to recreate a customer's order. This document will be used to create the schema for a completely denormalyzed (“flat”) table in dB #2. This flat table will be queried with to deliver subsecond reponse time to SQL queries.
4. use the data dictionary to create a completely denormalyzed, flat table consisting of all unique data fields (no duplicate or redundant data). Each metric (data field) in this flat table must have a unique columna. Each record in this flat table will have a composite key consisting of: WP_order_ID, Plugin system name (derived), and Plugin reponse time (system time). Each WP line_item will have its own column.
5. Testing: input a sample order and query and the WP data fields corresponding to the data fields (metrics) created in the flat table created in dB#2. Query all the columns in the flat table to confirm that the data returned is identical to the sample table and the derived fuelds are populated correcty and the derived system tine is present and correct.
Budget for Phase I ....................... $ 500.
Phase II: Create Cron Job
1. write ETL script to pull data from WP tables documented in Phase I and insert that data into the flat table in dB#2 (also created in Phase I.)
2. write cron job to execute this ETL scriot daily at 12:01 a.m. and schedule using crontabs on the Apache server on the same subdomain. All code must be located on the subdomain and documented. Best practices error handling, ;ogging and security must be followed.
3. Testing: check to make sure the job runs without error and on schedule.
Phase II Budget .............. $ 500.
Total Budget for Job ................. $1,000
Apply Now
Apply Now
1.install MySQI database (dB #2) on subdomain;
2. check WooCommerce (WC) to confirm that HPOS is turnrd off;
3. create a “WP/WC Customer Data Dictionary.” This document consisting of all the WP tables which store all the data needed to recreate a customer's order. This document will be used to create the schema for a completely denormalyzed (“flat”) table in dB #2. This flat table will be queried with to deliver subsecond reponse time to SQL queries.
4. use the data dictionary to create a completely denormalyzed, flat table consisting of all unique data fields (no duplicate or redundant data). Each metric (data field) in this flat table must have a unique columna. Each record in this flat table will have a composite key consisting of: WP_order_ID, Plugin system name (derived), and Plugin reponse time (system time). Each WP line_item will have its own column.
5. Testing: input a sample order and query and the WP data fields corresponding to the data fields (metrics) created in the flat table created in dB#2. Query all the columns in the flat table to confirm that the data returned is identical to the sample table and the derived fuelds are populated correcty and the derived system tine is present and correct.
Budget for Phase I ....................... $ 500.
Phase II: Create Cron Job
1. write ETL script to pull data from WP tables documented in Phase I and insert that data into the flat table in dB#2 (also created in Phase I.)
2. write cron job to execute this ETL scriot daily at 12:01 a.m. and schedule using crontabs on the Apache server on the same subdomain. All code must be located on the subdomain and documented. Best practices error handling, ;ogging and security must be followed.
3. Testing: check to make sure the job runs without error and on schedule.
Phase II Budget .............. $ 500.
Total Budget for Job ................. $1,000
Apply Now
Apply Now