void FileManagerAddDlg::slotBtnOk()
{
const QList<QListWidgetItem *> itemsToAdd = listWidget.selectedItems();
QProgressDialog progressDlg("Reading file tags...", "Abbrechen", 0, listWidget.selectedItems().size(), this);
progressDlg.setWindowModality(Qt::WindowModal);
sqlhelper.start_insert_sequence();
for(int cnt = 0; cnt != itemsToAdd.size(); ++cnt)
{
#if 0
//QString insert_cmd("INSERT INTO `musicdb`.`main` (`id` ,`titel` ,`kuenstler` ,`album` ,`tag` ,`genre` ,`jahr` ,`philipp` ,`johannes` ,`dateityp` ,`qualitaet` ,`bew_joh` ,`bew_phil` ,`pfad`) VALUES (NULL , '");
QString insert_cmd("NULL , '");
insert_cmd.append("', '");
insert_cmd.append("', '");
insert_cmd.append("', '");
insert_cmd.append("', '");
insert_cmd.append("', '");
insert_cmd.append("', '");
insert_cmd.append("1");
insert_cmd.append("', '");
insert_cmd.append("1");
insert_cmd.append("', '");
insert_cmd.append("', '");
insert_cmd.append("', '");
insert_cmd.append("', '");
insert_cmd.append("', '");
QString _filename = itemsToAdd[cnt]->text();
_filename.replace('\'', "\\'");
insert_cmd.append(_filename);
insert_cmd.append("'");
printf("Insert command: %s\n", insert_cmd.toAscii().data());
sqlhelper.INSERT(insert_cmd);
#else
progressDlg.setValue(cnt);
progressDlg.show();
if (progressDlg.wasCanceled())
break;
sqlhelper.INSERT(itemsToAdd[cnt]->text().toAscii().data());
#endif
}
sqlhelper.stop_insert_sequence();
if(itemsToAdd.size() > 0)
accept();
}
void AddEntryDlg::OnButtonEditInsertPressed()
{
//QString insert_cmd("UPDATE 'musicdb'.'main' SET 'titel' = '");
QString insert_cmd("UPDATE 'main' SET 'titel' = '");
insert_cmd.append(corr(le_title.text()));
insert_cmd.append("', 'kuenstler' = '");
insert_cmd.append(corr(le_artist.text()));
insert_cmd.append("', 'album' = '");
insert_cmd.append(corr(le_album.text()));
insert_cmd.append("', 'tag' = '");
insert_cmd.append(corr(le_tag.text()));
insert_cmd.append("', 'genre' = '");
insert_cmd.append(corr(le_genre.text()));
insert_cmd.append("', 'jahr' = '");
insert_cmd.append(le_year.text());
insert_cmd.append("', 'others' = '");
if(cb_interest_others.isChecked())
insert_cmd.append("1");
else
insert_cmd.append("0");
insert_cmd.append("', 'yours' = '");
if(cb_interest_yours.isChecked())
insert_cmd.append("1");
else
insert_cmd.append("0");
insert_cmd.append("', 'dateityp' = '");
insert_cmd.append(le_filetype.text());
insert_cmd.append("', 'qualitaet' = '");
insert_cmd.append(le_quality.text());
insert_cmd.append("', 'bew_yours' = '");
insert_cmd.append(QString::number(sb_vote_yours.value()));
insert_cmd.append("', 'bew_others' = '");
insert_cmd.append(QString::number(sb_vote_others.value()));
insert_cmd.append("', 'pfad' = '");
insert_cmd.append(le_path.text());
insert_cmd.append("', 'url' = '");
insert_cmd.append(corr(le_source.text()));
insert_cmd.append("' WHERE 'main'.'id' =");
insert_cmd.append(QString::number(editnum));
printf("Query command: %s\n", insert_cmd.toAscii().data());
sqlhelper.exec(insert_cmd);
accept();
}
void AddEntryDlg::OnButtonInsertPressed() // depricated ?
{
QString filepath = le_path.text();
QByteArray md5sum;
QDateTime last_changed;
if(!filepath.isEmpty() && !QFile::exists(filepath))
{
if( QMessageBox::No == QMessageBox::question(this, "Incorrect Filepath", "The File does not exist. Do you really want to continue?", QMessageBox::Yes | QMessageBox::No, QMessageBox::No))
return;
calculate_md5sum(filepath.toAscii().data(), &md5sum);
last_changed = QFileInfo(filepath).lastModified();
}
QString insert_cmd("INSERT INTO 'main' ('id' ,'titel' ,'kuenstler' ,'album' ,'tag' ,'genre' ,'jahr' ,'others' ,'yours' ,'dateityp' ,'qualitaet' ,'bew_yours' ,'bew_others' ,'pfad', 'last_changed', 'md5sum', 'url') VALUES (NULL , '");
insert_cmd.append(corr(le_title.text()));
insert_cmd.append("', '");
insert_cmd.append(corr(le_artist.text()));
insert_cmd.append("', '");
insert_cmd.append(corr(le_album.text()));
insert_cmd.append("', '");
insert_cmd.append(corr(le_tag.text()));
insert_cmd.append("', '");
insert_cmd.append(corr(le_genre.text()));
insert_cmd.append("', '");
insert_cmd.append(le_year.text());
insert_cmd.append("', '");
if(cb_interest_others.isChecked())
insert_cmd.append("1");
else
insert_cmd.append("0");
insert_cmd.append("', '");
if(cb_interest_yours.isChecked())
insert_cmd.append("1");
else
insert_cmd.append("0");
insert_cmd.append("', '");
insert_cmd.append(le_filetype.text());
insert_cmd.append("', '");
insert_cmd.append(le_quality.text());
insert_cmd.append("', '");
insert_cmd.append(QString::number(sb_vote_yours.value()));
insert_cmd.append("', '");
insert_cmd.append(QString::number(sb_vote_others.value()));
insert_cmd.append("', '");
insert_cmd.append(filepath);
insert_cmd.append("', '");
insert_cmd.append(last_changed.toTime_t());
insert_cmd.append("', '");
insert_cmd.append(md5sum.toHex().data());
insert_cmd.append("', '");
insert_cmd.append(corr(le_source.text()));
insert_cmd.append("');");
printf("Query command: %s\n", insert_cmd.toAscii().data());
sqlhelper.exec(insert_cmd);
// sqlhelper.INSERT(insert_cmd);
accept();
}
int lua_set_cmd_list(lua_State *L)
{
lua_gettop(L);
insert_cmd((char *)lua_tostring(L,1), (char *)lua_tostring(L,2));
return 0;
}
