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