/// read preference table from sql
void preferences::readDB(){
OpenDB();
int count = 0;
if(db2.open()){
QSqlQuery query(db2);
query = QString("SELECT * FROM pref");
while (query.next()){
QString QVal1 = query.value(1).toString();
QString QVal2 = query.value(2).toString();
QString QVal3 = query.value(3).toString();
QString QVal4 = query.value(4).toString();
QString QVal5 = query.value(5).toString();
QString QVal6 = query.value(6).toString();
QString QVal7 = query.value(7).toString();
setUser(QVal1.toStdString());
setPass(QVal2.toStdString());
setServ(QVal3.toStdString());
setPort(QVal4.toStdString());
setTable(QVal5.toStdString());
setSQL(QVal6.toStdString());
setPlaylistDir(QVal7.toStdString());
}
db2.close();
}
}
/// read preference table from sql
void preferences::readDB(){
if(QFile::exists(DBlocation.c_str())){
db2 = QSqlDatabase::addDatabase("QSQLITE");
db2.setDatabaseName(DBlocation.c_str());
if(db2.open()){
QSqlQuery query(db2);
query = QString("SELECT * FROM pref");
while (query.next()){
QString QVal1 = query.value(1).toString();
QString QVal2 = query.value(2).toString();
QString QVal3 = query.value(3).toString();
QString QVal4 = query.value(4).toString();
QString QVal5 = query.value(5).toString();
QString QVal6 = query.value(6).toString();
setUser(QVal1.toStdString());
setPass(QVal2.toStdString());
setServ(QVal3.toStdString());
setPort(QVal4.toStdString());
setTable(QVal5.toStdString());
setSQL(QVal6.toStdString());
}
}
db2.removeDatabase("QSQLITE");
}
}
preferences& preferences::operator=(const preferences& src){
if(this != &src)
{
setUser(src.USER);
setPass(src.PASS);
setServ(src.SERVER);
setPort(src.PORT);
setTable(src.TABLE);
setSQL(src.DBlocation);
}
return *this;
}
