#include "medialist.h"
#include "mediaedit/mediaedit.h"
#include "joblist/joblist.h"
+#include "relabel/relabel.h"
+#include "run/run.h"
MediaList::MediaList()
{
setupUi(this);
m_name = "Media";
pgInitialize();
+ QTreeWidgetItem* thisitem = mainWin->getFromHash(this);
+ thisitem->setIcon(0,QIcon(QString::fromUtf8(":images/cartridge.svg")));
/* mp_treeWidget, Storage Tree Tree Widget inherited from ui_medialist.h */
m_populated = false;
m_checkcurwidget = true;
m_closeable = false;
- setTitle();
+ /* add context sensitive menu items specific to this classto the page
+ * selector tree. m_contextActions is QList of QActions */
+ m_contextActions.append(actionRefreshMediaList);
+ dockPage();
}
MediaList::~MediaList()
void MediaList::populateTree()
{
QTreeWidgetItem *mediatreeitem, *pooltreeitem, *topItem;
- QString currentpool("");
- QString resultline;
- QStringList results;
- const char *query =
- "SELECT Pool.Name AS Pool, Media.VolumeName AS Media, Media.MediaId AS Id, Media.VolStatus AS VolStatus,"
- " Media.Enabled AS Enabled, Media.VolBytes AS Bytes, Media.VolFiles AS FileCount, Media.VolJobs AS JobCount,"
- " Media.VolRetention AS VolumeRetention, Media.MediaType AS MediaType, Media.LastWritten AS LastWritten"
- " FROM Media, Pool"
- " WHERE Media.PoolId=Pool.PoolId"
- " ORDER BY Pool";
+
+ if (!m_console->preventInUseConnect())
+ return;
+
QStringList headerlist = (QStringList()
- << "Pool Name" << "Volume Name" << "Media Id" << "Volume Status" << "Enabled"
- << "Volume Bytes" << "Volume Files" << "Volume Jobs" << "Volume Retention"
- << "Media Type" << "Last Written");
+ << "Volume Name" << "Id" << "Status" << "Enabled" << "Bytes" << "Files"
+ << "Jobs" << "Retention" << "Media Type" << "Slot" << "Use Duration"
+ << "Max Jobs" << "Max Files" << "Max Bytes" << "Recycle" << "Enabled"
+ << "RecyclePool" << "Last Written");
+ int statusIndex = headerlist.indexOf("Status");
m_checkcurwidget = false;
mp_treeWidget->clear();
topItem->setText(0, "Pools");
topItem->setData(0, Qt::UserRole, 0);
topItem->setExpanded(true);
-
+
mp_treeWidget->setHeaderLabels(headerlist);
- /* FIXME Make this a user configurable loggin action and dont use printf */
- //printf("MediaList query cmd : %s\n",query);
- if (m_console->sql_cmd(query, results)) {
- QString field;
- QStringList fieldlist;
-
- foreach (resultline, results) {
- fieldlist = resultline.split("\t");
- int index = 0;
- /* Iterate through fields in the record */
- foreach (field, fieldlist) {
- field = field.trimmed(); /* strip leading & trailing spaces */
- if (field != "") {
- /* The first field is the pool name */
- if (index == 0) {
- /* If new pool name, create new Pool item */
- if (currentpool != field) {
- currentpool = field;
- pooltreeitem = new QTreeWidgetItem(topItem);
- pooltreeitem->setText(0, field);
- pooltreeitem->setData(0, Qt::UserRole, 1);
- pooltreeitem->setExpanded(true);
- }
- mediatreeitem = new QTreeWidgetItem(pooltreeitem);
+ QString query;
+
+ foreach (QString pool_listItem, m_console->pool_list) {
+ pooltreeitem = new QTreeWidgetItem(topItem);
+ pooltreeitem->setText(0, pool_listItem);
+ pooltreeitem->setData(0, Qt::UserRole, 1);
+ pooltreeitem->setExpanded(true);
+
+ query = "SELECT Media.VolumeName AS Media, "
+ " Media.MediaId AS Id, Media.VolStatus AS VolStatus,"
+ " Media.Enabled AS Enabled, Media.VolBytes AS Bytes,"
+ " Media.VolFiles AS FileCount, Media.VolJobs AS JobCount,"
+ " Media.VolRetention AS VolumeRetention, Media.MediaType AS MediaType,"
+ " Media.Slot AS Slot, Media.VolUseDuration AS UseDuration,"
+ " Media.MaxVolJobs AS MaxJobs, Media.MaxVolFiles AS MaxFiles,"
+ " Media.MaxVolBytes AS MaxBytes, Media.Recycle AS Recycle,"
+ " Media.Enabled AS enabled, Pol.Name AS RecyclePool,"
+ " Media.LastWritten AS LastWritten"
+ " FROM Media"
+ " LEFT OUTER JOIN Pool ON (Media.PoolId=Pool.PoolId)"
+ " LEFT OUTER JOIN Pool AS Pol ON (Media.recyclepoolid=Pol.PoolId)"
+ " WHERE";
+ query += " Pool.Name='" + pool_listItem + "'";
+ query += " ORDER BY Media";
+
+ if (mainWin->m_sqlDebug) {
+ Pmsg1(000, "MediaList query cmd : %s\n",query.toUtf8().data());
+ }
+ QStringList results;
+ if (m_console->sql_cmd(query, results)) {
+ QString field;
+ QStringList fieldlist;
+
+ /* Iterate through the lines of results. */
+ foreach (QString resultline, results) {
+ fieldlist = resultline.split("\t");
+ int index = 0;
+ mediatreeitem = new QTreeWidgetItem(pooltreeitem);
+
+ /* Iterate through fields in the record */
+ foreach (field, fieldlist) {
+ field = field.trimmed(); /* strip leading & trailing spaces */
+ if (field != "") {
mediatreeitem->setData(index, Qt::UserRole, 2);
- } else {
- /* Put media fields under the pool tree item */
mediatreeitem->setData(index, Qt::UserRole, 2);
mediatreeitem->setText(index, field);
+ if (index == statusIndex) {
+ setStatusColor(mediatreeitem, field, index);
+ }
}
- }
- index++;
- }
- }
- }
+ index++;
+ } /* foreach field */
+ } /* foreach resultline */
+ } /* if results from query */
+ } /* foreach pool_listItem */
/* Resize the columns */
for(int cnter=0; cnter<headerlist.count(); cnter++) {
mp_treeWidget->resizeColumnToContents(cnter);
}
}
+void MediaList::setStatusColor(QTreeWidgetItem *item, QString &field, int &index)
+{
+ if (field == "Append" ) {
+ item->setBackground(index, Qt::green);
+ } else if (field == "Error") {
+ item->setBackground(index, Qt::red);
+ } else if ((field == "Used") || ("Full")){
+ item->setBackground(index, Qt::yellow);
+ }
+}
+
/*
* Called from the signal of the context sensitive menu!
*/
-void MediaList::editMedia()
+void MediaList::editVolume()
{
- MediaEdit* edit = new MediaEdit(m_console, m_currentlyselected);
- edit->show();
+ MediaEdit* edit = new MediaEdit(mainWin->getFromHash(this), m_currentVolumeId);
+ connect(edit, SIGNAL(destroyed()), this, SLOT(populateTree()));
}
/*
{
QString emptyclient("");
QTreeWidgetItem *parentItem = mainWin->getFromHash(this);
- mainWin->createPageJobList(m_currentlyselected, emptyclient, parentItem);
+ mainWin->createPageJobList(m_currentVolumeName, emptyclient, parentItem);
}
/*
if (m_checkcurwidget) {
/* The Previous item */
if (previouswidgetitem) { /* avoid a segfault if first time */
- int treedepth = previouswidgetitem->data(0, Qt::UserRole).toInt();
- if (treedepth == 2){
- mp_treeWidget->removeAction(actionEditVolume);
- mp_treeWidget->removeAction(actionListJobsOnVolume);
- }
+ mp_treeWidget->removeAction(actionEditVolume);
+ mp_treeWidget->removeAction(actionListJobsOnVolume);
+ mp_treeWidget->removeAction(actionDeleteVolume);
+ mp_treeWidget->removeAction(actionPruneVolume);
+ mp_treeWidget->removeAction(actionPurgeVolume);
+ mp_treeWidget->removeAction(actionRelabelVolume);
+ mp_treeWidget->removeAction(actionAllVolumesFromPool);
}
int treedepth = currentwidgetitem->data(0, Qt::UserRole).toInt();
+ m_currentVolumeName=currentwidgetitem->text(0);
if (treedepth == 2){
- m_currentlyselected=currentwidgetitem->text(1);
+ m_currentVolumeId=currentwidgetitem->text(1);
mp_treeWidget->addAction(actionEditVolume);
mp_treeWidget->addAction(actionListJobsOnVolume);
+ mp_treeWidget->addAction(actionDeleteVolume);
+ mp_treeWidget->addAction(actionPruneVolume);
+ mp_treeWidget->addAction(actionPurgeVolume);
+ mp_treeWidget->addAction(actionRelabelVolume);
+ } else if (treedepth == 1) {
+/* *******FIXME******
+ * I can't seem to get "All volumes from pool" or "Volume from pool" to work
+ * in one sentence command. Works when you do it one step at a time vi console
+ mp_treeWidget->addAction(actionAllVolumesFromPool);
+*/
}
}
}
{
mp_treeWidget->setContextMenuPolicy(Qt::ActionsContextMenu);
mp_treeWidget->addAction(actionRefreshMediaList);
- connect(actionEditVolume, SIGNAL(triggered()), this, SLOT(editMedia()));
+ connect(actionEditVolume, SIGNAL(triggered()), this, SLOT(editVolume()));
connect(actionListJobsOnVolume, SIGNAL(triggered()), this, SLOT(showJobs()));
+ connect(actionDeleteVolume, SIGNAL(triggered()), this, SLOT(deleteVolume()));
+ connect(actionPurgeVolume, SIGNAL(triggered()), this, SLOT(purgeVolume()));
+ connect(actionPruneVolume, SIGNAL(triggered()), this, SLOT(pruneVolume()));
+ connect(actionRelabelVolume, SIGNAL(triggered()), this, SLOT(relabelVolume()));
connect(mp_treeWidget, SIGNAL(
currentItemChanged(QTreeWidgetItem *, QTreeWidgetItem *)),
this, SLOT(treeItemChanged(QTreeWidgetItem *, QTreeWidgetItem *)));
/* connect to the action specific to this pages class */
connect(actionRefreshMediaList, SIGNAL(triggered()), this,
SLOT(populateTree()));
+ connect(actionAllVolumesFromPool, SIGNAL(triggered()), this, SLOT(allVolumesFromPool()));
}
/*
{
if(!m_populated) {
populateTree();
- /* add context sensitive menu items specific to this classto the page
- * selector tree. m_m_contextActions is QList of QActions, so this is
- * only done once with the first population. */
- m_contextActions.append(actionRefreshMediaList);
/* Create the context menu for the medialist tree */
createContextMenu();
m_populated=true;
}
}
+
+/*
+ * Called from the signal of the context sensitive menu to delete a volume!
+ */
+void MediaList::deleteVolume()
+{
+ if (QMessageBox::warning(this, tr("Bat"),
+ tr("Are you sure you want to delete?? !!!.\n"
+"This delete command is used to delete a Volume record and all associated catalog"
+" records that were created. This command operates only on the Catalog"
+" database and has no effect on the actual data written to a Volume. This"
+" command can be dangerous and we strongly recommend that you do not use"
+" it unless you know what you are doing. All Jobs and all associated"
+" records (File and JobMedia) will be deleted from the catalog."
+ "Press OK to proceed with delete operation.?"),
+ QMessageBox::Ok | QMessageBox::Cancel)
+ == QMessageBox::Cancel) { return; }
+
+ QString cmd("delete volume=");
+ cmd += m_currentVolumeName;
+ consoleCommand(cmd);
+}
+
+/*
+ * Called from the signal of the context sensitive menu to purge!
+ */
+void MediaList::purgeVolume()
+{
+ if (QMessageBox::warning(this, tr("Bat"),
+ tr("Are you sure you want to purge ?? !!!.\n"
+"The Purge command will delete associated Catalog database records from Jobs and"
+" Volumes without considering the retention period. Purge works only on the"
+" Catalog database and does not affect data written to Volumes. This command can"
+" be dangerous because you can delete catalog records associated with current"
+" backups of files, and we recommend that you do not use it unless you know what"
+" you are doing.\n"
+ "Press OK to proceed with the purge operation?"),
+ QMessageBox::Ok | QMessageBox::Cancel)
+ == QMessageBox::Cancel) { return; }
+
+ QString cmd("purge volume=");
+ cmd += m_currentVolumeName;
+ consoleCommand(cmd);
+ populateTree();
+}
+
+/*
+ * Called from the signal of the context sensitive menu to prune!
+ */
+void MediaList::pruneVolume()
+{
+ new prunePage(m_currentVolumeName, "");
+}
+
+/*
+ * Called from the signal of the context sensitive menu to relabel!
+ */
+void MediaList::relabelVolume()
+{
+ setConsoleCurrent();
+ new relabelDialog(m_console, m_currentVolumeName);
+}
+
+/*
+ * Called from the signal of the context sensitive menu to purge!
+ */
+void MediaList::allVolumesFromPool()
+{
+ QString cmd("update pool=");
+ cmd += m_currentVolumeName + " All Volumes From Pool";
+ consoleCommand(cmd);
+ populateTree();
+}