#!/bin/bash

# Directory containing MP3 files
audio_directory="./restart/basic/sound"

# SQL statements
sql_drop_table="DROP TABLE IF EXISTS mp3_files;"
sql_create_table="CREATE TABLE mp3_files (
    id INT AUTO_INCREMENT PRIMARY KEY,
    path_to_audio VARCHAR(255),
    filename VARCHAR(255),
    date_of_creation DATETIME DEFAULT CURRENT_TIMESTAMP
);"

# Execute SQL statements
echo "$sql_drop_table"
echo "$sql_create_table"

# Function to insert entries into the table
insert_entries() {
    for file in "$audio_directory"/*.mp3; do
        filename=$(basename "$file")
        path_to_audio="$audio_directory"
        echo "INSERT INTO mp3_files (path_to_audio, filename) VALUES ('$path_to_audio', '$filename');"
    done
}

# Call function to insert entries
insert_entries