//static
QList<QVariant> KexiQueryParameters::getParameters(QWidget *parent,
const KexiDB::Driver &driver, KexiDB::QuerySchema& querySchema, bool &ok)
{
Q_UNUSED(driver);
ok = false;
const KexiDB::QuerySchemaParameterList params(querySchema.parameters());
QList<QVariant> values;
const QString caption(i18nc("Enter Query Parameter Value", "Enter Parameter Value"));
for (KexiDB::QuerySchemaParameterListConstIterator it = params.constBegin();
it != params.constEnd(); ++it) {
switch ((*it).type) {
case KexiDB::Field::Byte:
case KexiDB::Field::ShortInteger:
case KexiDB::Field::Integer:
case KexiDB::Field::BigInteger: {
//! @todo problem for ranges in case of BigInteger - will disappear when we remove use of KInputDialog
int minValue, maxValue;
//! @todo add support for unsigned parameter here
KexiDB::getLimitsForType((*it).type, minValue, maxValue);
const int result = KInputDialog::getInteger(
caption, (*it).message, 0, minValue, maxValue, 1/*step*/, 10/*base*/, &ok, parent);
if (!ok)
return QList<QVariant>(); //cancelled
values.append(result);
break;
}
case KexiDB::Field::Boolean: {
QStringList list;
list << i18nc("Boolean True - Yes", "Yes") << i18nc("Boolean False - No", "No");
const QString result = KInputDialog::getItem(
caption, (*it).message, list, 0/*current*/, false /*!editable*/, &ok, parent);
if (!ok || result.isEmpty())
return QList<QVariant>(); //cancelled
values.append(result == list.first());
break;
}
case KexiDB::Field::Date: {
KexiDateFormatter df;
const QString result = KInputDialog::getText(
caption, (*it).message, QString(), &ok, parent, 0/*name*/,
//! @todo add validator
0/*validator*/, df.inputMask());
if (!ok)
return QList<QVariant>(); //cancelled
values.append(df.fromString(result));
break;
}
case KexiDB::Field::DateTime: {
KexiDateFormatter df;
KexiTimeFormatter tf;
const QString result = KInputDialog::getText(
caption, (*it).message, QString(), &ok, parent, 0/*name*/,
//! @todo add validator
0/*validator*/, KexiDateTimeFormatter::inputMask(df, tf));
if (!ok)
return QList<QVariant>(); //cancelled
values.append(KexiDateTimeFormatter::fromString(df, tf, result));
break;
}
case KexiDB::Field::Time: {
KexiTimeFormatter tf;
const QString result = KInputDialog::getText(
caption, (*it).message, QString(), &ok, parent, 0/*name*/,
//! @todo add validator
0/*validator*/, tf.inputMask());
if (!ok)
return QList<QVariant>(); //cancelled
values.append(tf.fromString(result));
break;
}
case KexiDB::Field::Float:
case KexiDB::Field::Double: {
// KInputDialog::getDouble() does not work well, use getText and double validator
KDoubleValidator validator(0);
const QString textResult(
KInputDialog::getText(caption, (*it).message, QString(),
&ok, parent, &validator));
if (!ok || textResult.isEmpty())
return QList<QVariant>(); //cancelled
//! @todo this value will be still rounded: consider storing them as a decimal type
//! (e.g. using a special qint64+decimalplace class)
const double result = textResult.toDouble(&ok); //this is also good for float (to avoid rounding)
if (!ok)
return QList<QVariant>();
values.append(result);
break;
}
case KexiDB::Field::Text:
case KexiDB::Field::LongText: {
const QString result = KInputDialog::getText(
caption, (*it).message, QString(), &ok, parent);
if (!ok)
return QList<QVariant>(); //cancelled
values.append(result);
break;
}
case KexiDB::Field::BLOB: {
//! @todo BLOB input unsupported
values.append(QByteArray());
}
default:
kWarning() << "KexiQueryParameters::getParameters() unsupported type " << KexiDB::Field::typeName((*it).type)
<< " for parameter \"" << (*it).message << "\" - aborting query execution!";
return QList<QVariant>();
}
}
ok = true;
return values;
}
