/// 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(); }