bool Table::equals(const voltdb::Table *other) const {
if (!(columnCount() == other->columnCount())) return false;
if (!(indexCount() == other->indexCount())) return false;
if (!(activeTupleCount() == other->activeTupleCount())) return false;
if (!(databaseId() == other->databaseId())) return false;
if (!(tableId() == other->tableId())) return false;
if (!(name() == other->name())) return false;
if (!(tableType() == other->tableType())) return false;
std::vector<voltdb::TableIndex*> indexes = allIndexes();
std::vector<voltdb::TableIndex*> otherIndexes = other->allIndexes();
if (!(indexes.size() == indexes.size())) return false;
for (std::size_t ii = 0; ii < indexes.size(); ii++) {
if (!(indexes[ii]->equals(otherIndexes[ii]))) return false;
}
const voltdb::TupleSchema *otherSchema = other->schema();
if ((!m_schema->equals(otherSchema))) return false;
voltdb::TableIterator firstTI(this);
voltdb::TableIterator secondTI(other);
voltdb::TableTuple firstTuple(m_schema);
voltdb::TableTuple secondTuple(otherSchema);
while(firstTI.next(firstTuple)) {
if (!(secondTI.next(secondTuple))) return false;
if (!(firstTuple.equals(secondTuple))) return false;
}
return true;
}
/*!
Inserts new record into the database, based on the current properties
of the object.
*/
bool TSqlObject::create()
{
// Sets the values of 'created_at', 'updated_at' or 'modified_at' properties
for (int i = metaObject()->propertyOffset(); i < metaObject()->propertyCount(); ++i) {
const char *propName = metaObject()->property(i).name();
QByteArray prop = QByteArray(propName).toLower();
if (prop == CreatedAt || prop == UpdatedAt || prop == ModifiedAt) {
setProperty(propName, QDateTime::currentDateTime());
} else if (prop == LockRevision) {
// Sets the default value of 'revision' property
setProperty(propName, 1); // 1 : default value
} else {
// do nothing
}
}
syncToSqlRecord();
QString autoValName;
QSqlRecord record = *this;
if (autoValueIndex() >= 0) {
autoValName = field(autoValueIndex()).name();
record.remove(autoValueIndex()); // not insert the value of auto-value field
}
QSqlDatabase &database = Tf::currentSqlDatabase(databaseId());
QString ins = database.driver()->sqlStatement(QSqlDriver::InsertStatement, tableName(), record, false);
if (Q_UNLIKELY(ins.isEmpty())) {
sqlError = QSqlError(QLatin1String("No fields to insert"),
QString(), QSqlError::StatementError);
tWarn("SQL statement error, no fields to insert");
return false;
}
TSqlQuery query(database);
bool ret = query.exec(ins);
sqlError = query.lastError();
if (Q_LIKELY(ret)) {
// Gets the last inserted value of auto-value field
if (autoValueIndex() >= 0) {
QVariant lastid = query.lastInsertId();
if (!lastid.isValid() && database.driverName().toUpper() == QLatin1String("QPSQL")) {
// For PostgreSQL without OIDS
ret = query.exec("SELECT LASTVAL()");
sqlError = query.lastError();
if (Q_LIKELY(ret)) {
lastid = query.getNextValue();
}
}
if (lastid.isValid()) {
QObject::setProperty(autoValName.toLatin1().constData(), lastid);
QSqlRecord::setValue(autoValueIndex(), lastid);
}
}
}
return ret;
}
bool IDBIndexBackendImpl::addingKeyAllowed(const IDBKey* indexKey, const IDBKey* primaryKey)
{
if (!m_unique)
return true;
RefPtr<IDBKey> foundPrimaryKey;
bool found = backingStore()->keyExistsInIndex(databaseId(), m_objectStoreBackend->id(), m_id, *indexKey, foundPrimaryKey);
if (!found)
return true;
if (primaryKey && foundPrimaryKey->isEqual(primaryKey))
return true;
return false;
}
/*!
Synchronizes the properties to the internal record data.
This function is for internal use only.
*/
void TSqlObject::syncToSqlRecord()
{
QSqlRecord::operator=(Tf::currentSqlDatabase(databaseId()).record(tableName()));
const QMetaObject *metaObj = metaObject();
for (int i = metaObj->propertyOffset(); i < metaObj->propertyCount(); ++i) {
const char *propName = metaObj->property(i).name();
int idx = indexOf(propName);
if (idx >= 0) {
QSqlRecord::setValue(idx, QObject::property(propName));
} else {
tWarn("invalid name: %s", propName);
}
}
}
bool Table::equals(voltdb::Table *other) {
if (!(columnCount() == other->columnCount())) return false;
if (!(activeTupleCount() == other->activeTupleCount())) return false;
if (!(databaseId() == other->databaseId())) return false;
if (!(name() == other->name())) return false;
if (!(tableType() == other->tableType())) return false;
const voltdb::TupleSchema *otherSchema = other->schema();
if ((!m_schema->equals(otherSchema))) return false;
voltdb::TableIterator firstTI = iterator();
voltdb::TableIterator secondTI = other->iterator();
voltdb::TableTuple firstTuple(m_schema);
voltdb::TableTuple secondTuple(otherSchema);
while(firstTI.next(firstTuple)) {
if (!(secondTI.next(secondTuple))) return false;
if (!(firstTuple.equals(secondTuple))) return false;
}
return true;
}
Database & DataMapper<Subclass, T, I>::getDatabase() const
{
return Database::get(databaseId());
}
/*!
Deletes the record with this primary key from the database.
*/
bool TSqlObject::remove()
{
if (isNew()) {
sqlError = QSqlError(QLatin1String("No record to remove"),
QString(), QSqlError::UnknownError);
tWarn("Unable to remove the '%s' object. Create it before!", metaObject()->className());
return false;
}
QSqlDatabase &database = Tf::currentSqlDatabase(databaseId());
QString del = database.driver()->sqlStatement(QSqlDriver::DeleteStatement, tableName(), *static_cast<QSqlRecord *>(this), false);
if (del.isEmpty()) {
sqlError = QSqlError(QLatin1String("Unable to delete row"),
QString(), QSqlError::StatementError);
return false;
}
del.append(" WHERE ");
int revIndex = -1;
for (int i = metaObject()->propertyOffset(); i < metaObject()->propertyCount(); ++i) {
const char *propName = metaObject()->property(i).name();
QByteArray prop = QByteArray(propName).toLower();
if (prop == LockRevision) {
bool ok;
int revision = property(propName).toInt(&ok);
if (!ok || revision <= 0) {
sqlError = QSqlError(QLatin1String("Unable to convert the 'revision' property to an int"),
QString(), QSqlError::UnknownError);
tError("Unable to convert the 'revision' property to an int, %s", qPrintable(objectName()));
return false;
}
del.append(QLatin1String(propName));
del.append("=").append(TSqlQuery::formatValue(revision, database));
del.append(" AND ");
revIndex = i;
break;
}
}
const char *pkName = metaObject()->property(metaObject()->propertyOffset() + primaryKeyIndex()).name();
if (primaryKeyIndex() < 0 || !pkName) {
QString msg = QString("Primary key not found for table ") + tableName() + QLatin1String(". Create a primary key!");
sqlError = QSqlError(msg, QString(), QSqlError::StatementError);
tError("%s", qPrintable(msg));
return false;
}
del.append(QLatin1String(pkName));
del.append("=").append(TSqlQuery::formatValue(value(pkName), database));
TSqlQuery query(database);
bool ret = query.exec(del);
sqlError = query.lastError();
if (ret) {
// Optimistic lock check
if (query.numRowsAffected() != 1) {
if (revIndex >= 0) {
QString msg = QString("Row was updated or deleted from table ") + tableName() + QLatin1String(" by another transaction");
sqlError = QSqlError(msg, QString(), QSqlError::UnknownError);
throw SqlException(msg, __FILE__, __LINE__);
}
tWarn("Row was deleted by another transaction, %s", qPrintable(tableName()));
}
clear();
}
return ret;
}
/*!
Updates the corresponding record with the properties of the object.
*/
bool TSqlObject::update()
{
if (isNew()) {
sqlError = QSqlError(QLatin1String("No record to update"),
QString(), QSqlError::UnknownError);
tWarn("Unable to update the '%s' object. Create it before!", metaObject()->className());
return false;
}
QSqlDatabase &database = Tf::currentSqlDatabase(databaseId());
QString where(" WHERE ");
// Updates the value of 'updated_at' or 'modified_at' property
bool updflag = false;
int revIndex = -1;
for (int i = metaObject()->propertyOffset(); i < metaObject()->propertyCount(); ++i) {
const char *propName = metaObject()->property(i).name();
QByteArray prop = QByteArray(propName).toLower();
if (!updflag && (prop == UpdatedAt || prop == ModifiedAt)) {
setProperty(propName, QDateTime::currentDateTime());
updflag = true;
} else if (revIndex < 0 && prop == LockRevision) {
bool ok;
int oldRevision = property(propName).toInt(&ok);
if (!ok || oldRevision <= 0) {
sqlError = QSqlError(QLatin1String("Unable to convert the 'revision' property to an int"),
QString(), QSqlError::UnknownError);
tError("Unable to convert the 'revision' property to an int, %s", qPrintable(objectName()));
return false;
}
setProperty(propName, oldRevision + 1);
revIndex = i;
where.append(QLatin1String(propName));
where.append("=").append(TSqlQuery::formatValue(oldRevision, database));
where.append(" AND ");
} else {
// continue
}
}
QString upd; // UPDATE Statement
upd.reserve(255);
upd.append(QLatin1String("UPDATE ")).append(tableName()).append(QLatin1String(" SET "));
int pkidx = metaObject()->propertyOffset() + primaryKeyIndex();
const char *pkName = metaObject()->property(pkidx).name();
if (primaryKeyIndex() < 0 || !pkName) {
QString msg = QString("Primary key not found for table ") + tableName() + QLatin1String(". Create a primary key!");
sqlError = QSqlError(msg, QString(), QSqlError::StatementError);
tError("%s", qPrintable(msg));
return false;
}
QVariant origpkval = value(pkName);
where.append(QLatin1String(pkName));
where.append("=").append(TSqlQuery::formatValue(origpkval, database));
// Restore the value of primary key
QObject::setProperty(pkName, origpkval);
for (int i = metaObject()->propertyOffset(); i < metaObject()->propertyCount(); ++i) {
const char *propName = metaObject()->property(i).name();
QVariant newval = QObject::property(propName);
QVariant recval = QSqlRecord::value(QLatin1String(propName));
if (i != pkidx && recval.isValid() && recval != newval) {
upd.append(QLatin1String(propName));
upd.append(QLatin1Char('='));
upd.append(TSqlQuery::formatValue(newval, database));
upd.append(QLatin1String(", "));
}
}
if (!upd.endsWith(QLatin1String(", "))) {
tSystemDebug("SQL UPDATE: Same values as that of the record. No need to update.");
return true;
}
upd.chop(2);
syncToSqlRecord();
upd.append(where);
TSqlQuery query(database);
bool ret = query.exec(upd);
sqlError = query.lastError();
if (ret) {
// Optimistic lock check
if (revIndex >= 0 && query.numRowsAffected() != 1) {
QString msg = QString("Row was updated or deleted from table ") + tableName() + QLatin1String(" by another transaction");
sqlError = QSqlError(msg, QString(), QSqlError::UnknownError);
throw SqlException(msg, __FILE__, __LINE__);
}
}
return ret;
}
quint32 ContactId::databaseId(const QContact &contact)
{
return databaseId(contact.id());
}
QString ContactId::toString(const QContactId &apiId)
{
return dbIdToString(databaseId(apiId));
}
bool ContactId::isValid(const QContactId &contactId)
{
return isValid(databaseId(contactId));
}
