void database::DeleteMP3(string mp3_to_delete)
{
string sql_str = "DELETE FROM mp3 WHERE mp3_pk = " + mp3_to_delete + ";";
ReadFromDatabase(sql_str);
sql_str = "";
sql_str = "DELETE FROM mp3_playlists WHERE mp3_fk = " + mp3_to_delete + ";";
ReadFromDatabase(sql_str);
}
void database::DeletePlaylist(string playlist_to_delete)
{
string sql_str = "DELETE FROM playlists WHERE playlists_pk = " + playlist_to_delete + ";";
ReadFromDatabase(sql_str);
sql_str = "";
sql_str = "DELETE FROM mp3_playlists WHERE playlists_fk = " + playlist_to_delete + ";";
ReadFromDatabase(sql_str);
}
Programming::Programming(QWidget *parent) :
QWidget(parent)
{
for(int i=0;i<20;i++){
ClassTimes.append(true);}
mainbutton = new QPushButton("ساخت برنامه");
mainlayout = new QHBoxLayout(this);
mainlayout->addWidget(mainbutton);
connect(mainbutton,SIGNAL(clicked()),this,SLOT(ReadFromDatabase()));
}
void database::AddNewMP3InDatabase(string mp3_name, string new_mp3_location)
{
string sql_str = "INSERT INTO mp3 (name, location) VALUES (\"" + mp3_name + "\" , \"" + new_mp3_location + "\");";
FileRef file_ref (new_mp3_location.data());
String title = file_ref.tag()->title();
if(title == "")
{
file_ref.tag()->setTitle(mp3_name);
file_ref.save();
}
ReadFromDatabase(sql_str);
}
void database::DisplayPlaylist()
{
string sql_str = "SELECT * FROM playlists;";
int count = 1;
ReadFromDatabase(sql_str);
for (int i = 0; i < (database_info.size()); i++)
{
if (i % 2)
{
cout << count << "." << database_info[i] << endl;
count++;
}
}
}
void database::DisplayMP3()
{
string sql_str = "SELECT * FROM mp3;";
int count = 1;
ReadFromDatabase(sql_str);
for (int i = 0; i < database_info.size(); i++)
{
if (i % 3 == 1)
{
cout << count << "." << database_info[i] << endl;
count++;
}
}
}
void database::EditMP3OnPlaylist(string playlist_to_edit)
{
DisplayMP3InPlaylist(playlist_to_edit);
string mp3_selection = "";
char* mp3_name;
vector<string> mp3 = database_info;
cout << "Select a mp3: ";
cin >> mp3_selection;
cout << endl;
int mp3_selection_num = atoi(mp3_selection.c_str());
cin.ignore();
cout << "Enter new name for MP3: ";
std::cin.getline(mp3_name, 256);
string new_mp3_name = mp3_name;
cout << "Hello, " << mp3_name << "!\n";
string mp3_to_edit = "";
int mp3_key = 0;
int count = 1;
for (int i = 0; i < (mp3.size()); i++)
{
if (i % 2 == 0)
{
if (count == mp3_selection_num)
{
mp3_key = i;
break;
}
else
count++;
}
}
mp3_to_edit = mp3[mp3_key];
string sql_str = "UPDATE mp3 SET name = \"" + new_mp3_name + "\" WHERE mp3_pk = " + mp3_to_edit + ";";
ReadFromDatabase(sql_str);
}
void database::DisplayMP3InPlaylist(string playlist_pk)
{
string sql_str = "SELECT mp3_pk, name FROM mp3 " \
"WHERE mp3_pk IN (SELECT mp3_fk FROM mp3_playlists " \
"WHERE playlists_fk = " + playlist_pk + ");";
int count = 1;
ReadFromDatabase(sql_str);
for (int i = 0; i < database_info.size(); i++)
{
if (i % 2)
{
cout << count << "." << database_info[i] << endl;
count++;
}
}
}
void database::GetPlaylistOrMP3(string playlist_selection_num, bool playlist_or_mp3)
{
string sql_str = "";
if (playlist_or_mp3 == 0)
{
sql_str = "SELECT location FROM mp3 " \
"WHERE mp3_pk IN (SELECT mp3_fk FROM mp3_playlists " \
"WHERE playlists_fk = " + playlist_selection_num + ");";
}
else
{
sql_str = "SELECT location FROM mp3 " \
"WHERE mp3_pk = " + playlist_selection_num + ";";
}
ReadFromDatabase(sql_str);
file_locations = database_info;
}
void database::DeleteMP3FromPlaylist(string playlist_to_delete)
{
DisplayMP3InPlaylist(playlist_to_delete);
string mp3_selection = "";
vector<string> mp3 = database_info;
cout << "Select a mp3: ";
cin >> mp3_selection;
cout << endl;
int mp3_selection_num = atoi(mp3_selection.c_str());
string mp3_to_delete = "";
int mp3_key = 0;
int count = 1;
for (int i = 0; i < (mp3.size()); i++)
{
if (i % 2 == 0)
{
if (count == mp3_selection_num)
{
mp3_key = i;
break;
}
else
count++;
}
}
mp3_to_delete = mp3[mp3_key];
string sql_str = "DELETE FROM mp3_playlists WHERE mp3_fk = " + mp3_to_delete + " AND playlists_fk = " + playlist_to_delete + ";";
ReadFromDatabase(sql_str);
}
void database::AddToPlaylist(string playlist_adding_to)
{
DisplayMP3();
string mp3_selection = "";
vector<string> mp3 = database_info;
cout << "Select a mp3: ";
cin >> mp3_selection;
cout << endl;
int mp3_selection_num = atoi(mp3_selection.c_str());
string mp3_to_add = "";
int mp3_key = 0;
int count = 1;
for (int i = 0; i < (mp3.size()); i++)
{
if (i % 3 == 0)
{
if (count == mp3_selection_num)
{
mp3_key = i;
break;
}
else
count++;
}
}
mp3_to_add = mp3[mp3_key];
string sql_str = "INSERT INTO mp3_playlists (mp3_fk, playlists_fk) VALUES (" + mp3_to_add + " ," + playlist_adding_to + ");";
ReadFromDatabase(sql_str);
}
