const void *NAMETABLE_lookup_tag_binding
(
NAMETABLE_id_t identifier
)
{
if (identifier == NAMETABLE_NIL_ID)
return NULL;
if (nameTable(identifier,tagBinding) == NULL) {
return NULL;
};
return nameTable(identifier,tagBinding)->theBinding;
}
QString TableManagement::buildInsert(QString identifier){
QString tag = "INSERT INTO " + nameTable() + " (";
const QMetaObject *metaObject = object()->metaObject();
for (int i = 1; i < metaObject->propertyCount(); ++i) {
QString nameProperty = QString::fromUtf8(metaObject->property(i).name());
if(nameProperty != identifier){
tag += nameProperty;
if(i < metaObject->propertyCount() - 1) tag += ", ";
else tag += ')';
}
}
tag += " VALUES (";
for (int i = 1; i < metaObject->propertyCount(); ++i) {
QString nameProperty = QString::fromUtf8(metaObject->property(i).name());
if(nameProperty != identifier){
tag += '\'' + object()->property(nameProperty.toLatin1().constData()).toString() + '\'';
if(i != metaObject->propertyCount() - 1) tag += ", ";
else tag += ')';
}
}
qDebug() << tag;
return tag;
}
QString TableManagement::buildDetele(QStringList where, QString myOperator){
QString tag = "DELETE FROM " + nameTable() + " WHERE ";
for(int i = 0;i < where.length(); ++i){
tag += where.at(i) +"='"+
object()->property(where.at(i).toLatin1().constData()).toString() + '\'';
if(i < where.length() - 1) tag += ' ' + myOperator + ' ';
}
return tag;
}
const void *NAMETABLE_lookup_local
(
NAMETABLE_id_t identifier
)
{
if (identifier == NAMETABLE_NIL_ID)
return NULL;
if (nameTable(identifier,bindings) == NULL){
return NULL;
};
if (nameTable(identifier,bindings)->bindingLevel < currentLevel) {
return NULL;
};
return nameTable(identifier,bindings)->theBinding;
}
QString TableManagement::buildCreateTable(){
QString tag = "CREATE TABLE IF NOT EXISTS " + nameTable() + " (";
const QMetaObject *metaObject = object()->metaObject();
for (int i = 1; i < metaObject->propertyCount(); ++i) {
QString propertyName = QString::fromUtf8(metaObject->property(i).name());
tag += propertyName + ' ' +
readType(object()->property(propertyName.toLatin1().constData()));
if(i != metaObject->propertyCount() - 1) tag += ", ";
else tag += ')';
}
return tag;
}
void NAMETABLE_id_to_string
(
NAMETABLE_id_t NAMETABLE_id,
const char ** str_ptr
)
{
NAMETABLE_id_t id;
if (NAMETABLE_id == NAMETABLE_NIL_ID)
*str_ptr = "";
else {
id = NAMETABLE_id;
*str_ptr = nameTable(id,id);
};
}
QString TableManagement::buildUpdate(QString where){
QString tag = "UPDATE " + nameTable() + " SET ";
const QMetaObject *metaObject = object()->metaObject();
for (int i = 1; i < metaObject->propertyCount(); ++i) {
QString nameProperty = QString::fromUtf8(metaObject->property(i).name());
if(nameProperty != where){
tag += nameProperty + "='" +
object()->property(nameProperty.toLatin1().constData()).toString() + '\'';
if(i != metaObject->propertyCount() - 2) tag += ", ";
}
}
tag += " WHERE " + where + "='" +
object()->property(where.toLocal8Bit().data()).toString() + '\'';
return tag;
}
QString TableManagement::buildDeleteAll(){
return "DELETE FROM " + nameTable();
}
QString TableManagement::buildDetele(QString where){
return "DELETE FROM " + nameTable() + " WHERE " + where +
"='" + object()->property(where.toLatin1().constData()).toString() + '\'';
}
