/AFKZenCoders

AFKZenCoders

Primary LanguagePythonMIT LicenseMIT

AFKZenCoders

AFKZenCoders

PS12

API endpoints

  • loaded files - displayes the loaded in the DataBase files (CDRs)
  • upload - upload a CSV (CDR) file here and python will add it to the CDR database
  • multi-upload - Upload multiple files here

Upload CSV in this Format

  • delete loaded - deletes the CSV files in the uploads folder and also deletes the database
  • download db - downloads the db file

Sample Queries

  • Query - SELECT * FROM CallData ORDER BY duration DESC
  • Query 2 - SELECT * FROM CallData WHERE cell_type = 'OUT' ORDER BY duration DESC LIMIT 10
  • Query 3 - SELECT * FROM CallData ORDER BY duration DESC LIMIT 10
  • Query 4
  • Query 5
  • Query 6
  • Query 7