QString TemporalType::toString() const
{
if (!m_periodId.isEmpty())
return m_periodId;
if (!typeLabel().isEmpty())
return typeLabel();
return QObject::tr("Unnamed period");
}
QString RightsType::toString() const
{
if (m_rights)
return m_rights->toString();
if (!typeLabel().isEmpty())
return typeLabel();
return QObject::tr("Unspecified rights");
}
void QBuildingCardPropertiesWidget::toXml( QDomElement & root )
{
QRequirementsCardPropertiesWidget::toXml( root );
root.setAttribute( ATTRIBUTE_TYPE, typeLabel()->text() );
root.setAttribute( ATTRIBUTE_FACTION, factionCombo_->currentText() );
}
void QBuildingCardPropertiesWidget::createWidgets()
{
typeLabel()->setText( tr( "Building" ) );
QLabel * factionLabel = new QLabel( tr( "Faction:" ) );
setup( factionCombo_, factionsMap_.keys() );
addLineToLayout( layout(), { factionLabel, factionCombo_ } );
}
QJsonObject * QBuildingCardPropertiesWidget::toJson()
{
QJsonObject * data = QRequirementsCardPropertiesWidget::toJson();
data->insert( ATTRIBUTE_TYPE, typeLabel()->text() );
data->insert( ATTRIBUTE_FACTION, factionCombo_->currentText() );
return data;
}
void AlterTable::on_actionAgregar_Columna_triggered() {
QDialog dialog(this);
dialog.setWindowTitle("Agregar");
QLabel messageLabel("Nombre de Columna:", &dialog);
QLineEdit columnNameLineEdit(&dialog);
QLabel typeLabel("Tipo:");
QComboBox typeComboBox(&dialog);
typeComboBox.addItems(QStringList()
<< "TINYINT"
<< "SMALLINT"
<< "MEDIUMINT"
<< "INT"
<< "BIGINT"
<< "BIT"
<< "FLOAT"
<< "DOUBLE"
<< "DECIMAL"
<< "CHAR"
<< "VARCHAR"
<< "TINYTEXT"
<< "TEXT"
<< "MEDIUMTEXT"
<< "LONGTEXT"
<< "BINARY"
<< "VARBINARY"
<< "TINYBLOB"
<< "BLOB"
<< "MEDIUMBLOB"
<< "LONGBLOB"
<< "DATE"
<< "TIME"
<< "YEAR"
<< "DATETIME"
<< "TIMESTAMP"
<< "POINT"
<< "LINESTRING"
<< "POLYGON"
<< "GEOMETRY"
<< "MULTIPOINT"
<< "MULTILINESTRING"
<< "MULTIPOLYGON"
<< "GEOMETRYCOLLECTION"
<< "ENUM"
<< "SET");
QVBoxLayout *layout = new QVBoxLayout;
layout->addWidget(&messageLabel);
layout->addWidget(&columnNameLineEdit);
layout->addWidget(&typeLabel);
layout->addWidget(&typeComboBox);
QPushButton addPushButton("Agregar", &dialog);
QPushButton cancelPushButton("Cancelar", &dialog);
connect(&addPushButton, SIGNAL(clicked()), &dialog, SLOT(accept()));
connect(&cancelPushButton, SIGNAL(clicked()), &dialog, SLOT(reject()));
QHBoxLayout *buttonsLayout = new QHBoxLayout;
buttonsLayout->addWidget(&addPushButton);
buttonsLayout->addWidget(&cancelPushButton);
layout->addLayout(buttonsLayout);
dialog.setLayout(layout);
if (dialog.exec() == QDialog::Rejected) { return; }
int lenght = 0;
if (typeComboBox.currentText() == "VARCHAR" ||
typeComboBox.currentText() == "VARBINARY") {
QInputDialog inDialog(&dialog);
inDialog.setWindowTitle("Longitud");
inDialog.setLabelText("Longitud:");
inDialog.setInputMode(QInputDialog::IntInput);
if (inDialog.exec() == QInputDialog::Rejected) { return; }
lenght = inDialog.intValue();
}
QDialog configurationDialog(&dialog);
configurationDialog.setWindowTitle("Configuración");
QRadioButton afterOfRadioButton("Despues de", &configurationDialog);
QRadioButton lastRadioButton("Al Final", &configurationDialog);
lastRadioButton.setChecked(true);
QVBoxLayout *layoutConf = new QVBoxLayout;
QPushButton acceptPushButton("Aceptar", &configurationDialog);
QPushButton cancelConfPushButton("Cancelar", &configurationDialog);
connect(&acceptPushButton, SIGNAL(clicked()), &configurationDialog,
SLOT(accept()));
connect(&cancelConfPushButton, SIGNAL(clicked()), &configurationDialog,
SLOT(reject()));
layoutConf->addWidget(&afterOfRadioButton);
layoutConf->addWidget(&lastRadioButton);
QHBoxLayout *buttonsConfLayout = new QHBoxLayout;
buttonsConfLayout->addWidget(&acceptPushButton);
buttonsConfLayout->addWidget(&cancelConfPushButton);
layoutConf->addLayout(buttonsConfLayout);
configurationDialog.setLayout(layoutConf);
if (configurationDialog.exec() == QDialog::Rejected) { return; }
QString afterOfString = QString();
if (afterOfRadioButton.isChecked()) {
QInputDialog inDialog(&configurationDialog);
inDialog.setWindowTitle("Referencia");
inDialog.setLabelText("Columna:");
if (inDialog.exec() == QInputDialog::Rejected) {
QMessageBox mBox(this);
mBox.setWindowTitle("ERROR");
mBox.setIcon(QMessageBox::Critical);
mBox.setText(
"No se puede continuar con la operación de agregado");
mBox.exec();
return;
}
afterOfString = inDialog.textValue();
}
QString queryString = "ALTER TABLE " + tableName + " ADD COLUMN " +
columnNameLineEdit.text() + " " + typeComboBox.currentText();
if (typeComboBox.currentText() == "VARCHAR" ||
typeComboBox.currentText() == "VARBINARY") {
queryString += "(" + QString::number(lenght) + ")";
}
if (afterOfRadioButton.isChecked()) {
queryString += " AFTER " + afterOfString;
}
queryString += ";";
QSqlQuery query(*db);
query.exec(queryString);
if (query.lastError().isValid()) {
QMessageBox mBox(this);
mBox.setWindowTitle("ERROR");
mBox.setIcon(QMessageBox::Critical);
mBox.setText("No se puede realizar la operación de agregado");
mBox.exec();
return;
}
QString strQuery;
if (engineName == "sqlite") {
strQuery = QString("PRAGMA table_info(%1)").arg(tableName);
} else if (engineName == "mysql") {
strQuery = QString("SHOW COLUMNS FROM %1").arg(tableName);
}
queryModel->setQuery(strQuery);
counterOfColumns->setText(QString::number(queryModel->rowCount()));
}
void AlterTable::on_actionModificar_Columna_triggered() {
QDialog dialog(this);
dialog.setWindowTitle("Modificar Columna");
QRadioButton isNullableRadioButton("Puede ser Nulo", &dialog);
QRadioButton isNotNullableRadioButton("No puede ser Nulo", &dialog);
isNullableRadioButton.setChecked(true);
QLabel messageLabel("Nombre de Columna", &dialog);
QLineEdit columnNameLineEdit(&dialog);
QLabel typeLabel("Tipo", &dialog);
QComboBox typeComboBox(&dialog);
typeComboBox.addItems(QStringList()
<< "TINYINT"
<< "SMALLINT"
<< "MEDIUMINT"
<< "INT"
<< "BIGINT"
<< "BIT"
<< "FLOAT"
<< "DOUBLE"
<< "DECIMAL"
<< "CHAR"
<< "VARCHAR"
<< "TINYTEXT"
<< "TEXT"
<< "MEDIUMTEXT"
<< "LONGTEXT"
<< "BINARY"
<< "VARBINARY"
<< "TINYBLOB"
<< "BLOB"
<< "MEDIUMBLOB"
<< "LONGBLOB"
<< "DATE"
<< "TIME"
<< "YEAR"
<< "DATETIME"
<< "TIMESTAMP"
<< "POINT"
<< "LINESTRING"
<< "POLYGON"
<< "GEOMETRY"
<< "MULTIPOINT"
<< "MULTILINESTRING"
<< "MULTIPOLYGON"
<< "GEOMETRYCOLLECTION"
<< "ENUM"
<< "SET");
QPushButton acceptPushButton("Aceptar", &dialog);
QPushButton cancelPushButton("Cancelar", &dialog);
connect(&acceptPushButton, SIGNAL(clicked()), &dialog, SLOT(accept()));
connect(&cancelPushButton, SIGNAL(clicked()), &dialog, SLOT(reject()));
QVBoxLayout *layout = new QVBoxLayout;
layout->addWidget(&isNullableRadioButton);
layout->addWidget(&isNotNullableRadioButton);
layout->addWidget(&messageLabel);
layout->addWidget(&columnNameLineEdit);
layout->addWidget(&typeLabel);
layout->addWidget(&typeComboBox);
QHBoxLayout *buttonsLayout = new QHBoxLayout;
buttonsLayout->addWidget(&acceptPushButton);
buttonsLayout->addWidget(&cancelPushButton);
layout->addLayout(buttonsLayout);
dialog.setLayout(layout);
if (dialog.exec() == QDialog::Rejected) { return; }
if (columnNameLineEdit.text() == QString()) {
QMessageBox mBox(this);
mBox.setWindowTitle("ERROR");
mBox.setIcon(QMessageBox::Critical);
mBox.setText(
"No se puede realizar la operación de modificación");
mBox.exec();
return;
}
QString lenghtString = QString();
if (typeComboBox.currentText() == "VARCHAR" ||
typeComboBox.currentText() == "VARBINARY") {
QDialog lenDialog(&dialog);
lenDialog.setWindowTitle("Longitud");
QVBoxLayout *layout = new QVBoxLayout;
QHBoxLayout *topLayout = new QHBoxLayout;
topLayout->addWidget(new QLabel("Longitud:", &lenDialog));
QLineEdit lenValueText(&lenDialog);
topLayout->addWidget(&lenValueText);
QHBoxLayout *layoutButtons = new QHBoxLayout;
QPushButton okButton("Aceptar", &lenDialog);
QPushButton cancelButton("Cancelar", &lenDialog);
layoutButtons->addWidget(&okButton);
layoutButtons->addWidget(&cancelButton);
layout->addLayout(topLayout);
layout->addLayout(layoutButtons);
lenDialog.setLayout(layout);
connect(&okButton, SIGNAL(clicked()), &lenDialog, SLOT(accept()));
connect(&cancelButton, SIGNAL(clicked()), &lenDialog, SLOT(reject()));
if (lenDialog.exec() == QDialog::Rejected) {
QMessageBox mBox;
mBox.setWindowTitle("ERROR");
mBox.setIcon(QMessageBox::Critical);
mBox.setText(
"No se puede continuar con la operación de modificación");
mBox.exec();
return;
}
lenghtString = "(" + lenValueText.text() + ")";
}
QString isNullString = QString();
if (isNotNullableRadioButton.isChecked()) { isNullString = "NOT NULL"; }
QSqlQuery query(*db);
query.exec("ALTER TABLE " + tableName + " CHANGE COLUMN " +
columnNameLineEdit.text() + " " + columnNameLineEdit.text() + " " +
typeComboBox.currentText() + lenghtString + " " +
isNullString + ";");
QString strQuery;
if (engineName == "sqlite") {
strQuery = QString("PRAGMA table_info(%1)").arg(tableName);
} else if (engineName == "mysql") {
strQuery = QString("SHOW COLUMNS FROM %1").arg(tableName);
}
queryModel->setQuery(strQuery);
}
