/smsedge

Primary LanguageJavaScript

SMSEDGE task

Simple client gets logs lists from MySQL db

How to run it

  1. Clone the repo
  2. Run the /api/smsedge.sql script
  3. Open localhost:9000 server in /api dir
  4. npm install && npm start will open a browser at localhost:3000
  5. Enjoy browsing

SMS moving

At the bottom of the /api/smsedge.sql you can find a SP called sp_move_bunch_logs, it accepts a Y-m-d date and moves safely bunch of rows to a new send_log_aggregated table with aggregated log_created_aggregated column

Requirements:

  • PHP 7.1
  • MySQL 5.7
  • Node.js 6+ (tested on 10)

Live version you can see here