/// write to preference table sql
void preferences::writeDB(){
string str2;
stringstream os;
os << "INSERT INTO pref (usr, PASS, SERVER, PRT, SQLTABLE, SQL, PLAYLISTDIR) VALUES ('"
<< USER << "','" << PASS << "','" << SERVER << "','" << PORT << "','" << TABLE << "','" << DBlocation << "','" << PLAYLISTDIR << "')";
str2 = os.str();
writeMe(str2);
}
void playlistobj::writeNew(fileObj &src){
char *qryState;
for(int i =0; i< pl_obj_count; i++){
qryState = new char[strlen(src.getName(i))+strlen(src.getPath(i))+250];
sprintf(qryState, "INSERT INTO playlist_items (lcl_dir_name, lcl_dir_path, lcl_dir_id, lcl_dir_par, lcl_dir_type) VALUES ('%s', '%s', '%d', '%d', '%s')",
src.getName(i), src.getPath(i), src.getID(i), playlistCount, "song");
}
writeMe(string(qryState));
delete [] qryState;
}
/*
* Fill new playlist
*/
void playlistobj::writeNew(){
char *qryState;
for(int i =0; i< playlistCount; i++){
qryState = new char[strlen(playlistName.c_str())+250];
sprintf(qryState, "INSERT INTO playlists (lcl_dir_name, lcl_dir_path, lcl_dir_id, lcl_dir_par, lcl_dir_type) VALUES ('%s', '%s', '%d', '%d', '%s')",
playlistName.c_str(), "-", playlistCount, 0, 0, "playlist");
}
writeMe(string(qryState));
delete [] qryState;
}
/*
* create new playlist
*/
void playlistobj::AddNew(string name){
initPlaylist();
string newQry[2];
newQry[0] = "create table playlists (key INTEGER PRIMARY KEY,lcl_dir_name TEXT,lcl_dir_path TEXT,lcl_dir_id integer,lcl_dir_par integer,lcl_dir_type TEXT)";
newQry[1] = "create table playlist_items (key INTEGER PRIMARY KEY,lcl_dir_name TEXT,lcl_dir_path TEXT,lcl_dir_id integer,lcl_dir_par integer,lcl_dir_type TEXT)";
for(int i =0; i<2; i++){
writeMe(newQry[i]);
}
playlistCount++; // number of playlists
playlistName = name;
}
/// create database
void preferences::createDB() {
OpenDB();
string finalQry[7];
finalQry[0] = "create table Artists(key INTEGER PRIMARY KEY,Artist TEXT,ArtistID integer, ArtistPar integer) ";
finalQry[1] = "create table Albums(key INTEGER PRIMARY KEY,Album TEXT,AlbumID integer, AlbumPar integer)";
finalQry[2] = "create table Songs(key INTEGER PRIMARY KEY,Song TEXT,SongID integer, SongPar integer)";
finalQry[3] = "create table Videos(key INTEGER PRIMARY KEY,Video TEXT,VideoID integer, VideoPar integer)";
finalQry[4] = "create table VidDirs(key INTEGER PRIMARY KEY,VidDir TEXT,VidDirID integer, VidDirPar integer)";
finalQry[5] = "create table pref(key INTEGER PRIMARY KEY,usr TEXT,PASS TEXT,SERVER TEXT,PRT TEXT,SQLTABLE TEXT,SQL TEXT,PLAYLISTDIR TEXT)";
finalQry[6] = "create table radio(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL DEFAULT (0),name TEXT NOT NULL,url TEXT NOT NULL)";
for(int i=0; i<7; i++){
writeMe(finalQry[i]);
}
}
/// remove Preference database
void preferences::deletePrefDB() {
string finalRMPrefqry = "drop table pref if exists";
if(QFile::exists(DBlocation.c_str())){
writeMe(finalRMPrefqry);
}
}
/// create Preference database
void preferences::createPrefDB() {
string finalQry;
finalQry = "create table pref(key INTEGER PRIMARY KEY,usr TEXT,PASS TEXT,SERVER TEXT,PRT TEXT,SQLTABLE TEXT,SQL TEXT,PLAYLISTDIR TEXT)";
writeMe(finalQry);
writeDB();
}
