QSqlRecord DatabaseLayout::formatRecord(const LoggingEvent &rEvent)
{
QSqlField field;
QSqlRecord record;
if (!mTimeStamp.isEmpty())
{
field.setName(mTimeStamp);
field.setType(QVariant::DateTime);
field.setGenerated(true);
field.setValue(DateTime::fromMSecsSinceEpoch(rEvent.timeStamp()));
record.append(field);
}
if (!mLoggerName.isEmpty())
{
field.setName(mLoggerName);
field.setType(QVariant::String);
field.setGenerated(true);
field.setValue(rEvent.loggerName());
record.append(field);
}
if (!mThreadName.isEmpty())
{
field.setName(mThreadName);
field.setType(QVariant::String);
field.setGenerated(true);
field.setValue(rEvent.threadName());
record.append(field);
}
if (!mLevel.isEmpty())
{
field.setName(mLevel);
field.setType(QVariant::String);
field.setGenerated(true);
field.setValue(rEvent.level().toString());
record.append(field);
}
if (!mMessage.isEmpty())
{
field.setName(mMessage);
field.setType(QVariant::String);
field.setGenerated(true);
field.setValue(rEvent.message());
record.append(field);
}
return record;
}
QSqlRecord QPSQLResult::record() const
{
QSqlRecord info;
if (!isActive() || !isSelect())
return info;
int count = PQnfields(d->result);
for (int i = 0; i < count; ++i) {
QSqlField f;
if (d->driver->isUtf8)
f.setName(QString::fromUtf8(PQfname(d->result, i)));
else
f.setName(QString::fromLocal8Bit(PQfname(d->result, i)));
f.setType(qDecodePSQLType(PQftype(d->result, i)));
int len = PQfsize(d->result, i);
int precision = PQfmod(d->result, i);
// swap length and precision if length == -1
if (len == -1 && precision > -1) {
len = precision - 4;
precision = -1;
}
f.setLength(len);
f.setPrecision(precision);
f.setSqlType(PQftype(d->result, i));
info.append(f);
}
return info;
}
static QString qCreateParamString(const QVector<QVariant> boundValues, const QSqlDriver *driver)
{
if (boundValues.isEmpty())
return QString();
QString params;
QSqlField f;
for (int i = 0; i < boundValues.count(); ++i) {
const QVariant &val = boundValues.at(i);
f.setType(val.type());
if (val.isNull())
f.clear();
else
f.setValue(val);
if(!params.isNull())
params.append(QLatin1String(", "));
params.append(driver->formatValue(f));
}
return params;
}
