34 Old database being overwritten after each restart of the service

[jindaznb]

This pr fix ticket #34 , #32. add validation for db initlization, if current database exist, will not create new database to overwrite old database. For detailed testing in production env see below server logs.

• I also closed PR #33, since this PR contains #33. Feel free to let me know need to PR seperately.

for ticket #32, create CSV and download wav

[ec2-user@ip-172-31-49-141 VoiceCollector]$  curl -X GET http://localhost:5000/api/v1/speak/get_csv
{"csv_path":"/data/voice/output","message":"CSV file generation complete apiv2"}
[ec2-user@ip-172-31-49-141 ~]$ cd VoiceCollector/data/voice/output/
[ec2-user@ip-172-31-49-141 output]$ ls
output.csv  test16.wav  test1.wav  test21.wav  test33.wav  test93.wav
[ec2-user@ip-172-31-49-141 output]$ cat output.csv 
audio_id,session_id,s3_url,date,ref_id,transcription,audio_path
1,21.268907222589316,test21.268907222589316.webm,2023-11-27 08:49:36,29,0 1 2 3 4 5 6 7 8 9 10,/data/voice/output/test21.wav

for ticket #34,

• check db before restart

  [ec2-user@ip-172-31-49-141 sqlite]$ sqlite3 database.db 
  SQLite version 3.7.17 2013-05-20 00:56:22
  Enter ".help" for instructions
  Enter SQL statements terminated with a ";"
  sqlite> select * from audio;
  1|21.268907222589316|test21.268907222589316.webm|2023-11-27 08:49:36|29

• shutdown and restart application

  [ec2-user@ip-172-31-49-141 VoiceCollector]$ docker-compose -f docker-compose.prod.yml down
  [+] Running 5/4
  ✔ Container certbot               Removed                                               0.4s 
  ✔ Container minio-container       Removed                                              10.3s 
  ✔ Container server-container      Removed                                               0.8s 
  ✔ Container web-container         Removed                                               0.5s 
  ✔ Network voicecollector_default  Removed                                               0.1s 
  [ec2-user@ip-172-31-49-141 VoiceCollector]$ docker-compose -f docker-compose.prod.yml up -d
  [+] Running 5/5
  ✔ Network voicecollector_default  Created                                               0.1s 
  ✔ Container certbot               Started                                               0.1s 
  ✔ Container minio-container       Started                                               0.1s 
  ✔ Container server-container      Started                                               0.1s 
  ✔ Container web-container         Started                                               0.1s 

• inspect DB again after restart:

  
  [ec2-user@ip-172-31-49-141 VoiceCollector]$ cd data/sqlite/
  [ec2-user@ip-172-31-49-141 sqlite]$ sqlite3 database.db 
  SQLite version 3.7.17 2013-05-20 00:56:22
  Enter ".help" for instructions
  Enter SQL statements terminated with a ";"
  sqlite> select * from audio;
  1|21.268907222589316|test21.268907222589316.webm|2023-11-27 08:49:36|29