std::string DeleteCommand::command() const { std::stringstream buf; buf<<"DELETE FROM "<<tablename(); std::string e = exprStr(); if (!e.empty()) { buf<<" "<<e; } return buf.str(); }
void tst_QSqlDriver::record() { QFETCH_GLOBAL(QString, dbName); QSqlDatabase db = QSqlDatabase::database(dbName); CHECK_DATABASE(db); QString tablename(qTableName("relTEST1", __FILE__)); QStringList fields; fields << "id" << "name" << "title_key" << "another_title_key"; //check we can get records using an unquoted mixed case table name QSqlRecord rec = db.driver()->record(tablename); QCOMPARE(rec.count(), 4); if (db.driverName().startsWith("QIBASE")|| db.driverName().startsWith("QOCI") || db.driverName().startsWith("QDB2")) for(int i = 0; i < fields.count(); ++i) fields[i] = fields[i].toUpper(); for (int i = 0; i < fields.count(); ++i) QCOMPARE(rec.fieldName(i), fields[i]); if (db.driverName().startsWith("QIBASE") || db.driverName().startsWith("QOCI") || db.driverName().startsWith("QDB2")) tablename = tablename.toUpper(); else if (db.driverName().startsWith("QPSQL")) tablename = tablename.toLower(); if(!db.driverName().startsWith("QODBC") && !db.databaseName().contains("PostgreSql")) { //check we can get records using a properly quoted table name rec = db.driver()->record(db.driver()->escapeIdentifier(tablename,QSqlDriver::TableName)); QCOMPARE(rec.count(), 4); } for (int i = 0; i < fields.count(); ++i) QCOMPARE(rec.fieldName(i), fields[i]); if( db.driverName().startsWith("QIBASE") || db.driverName().startsWith("QOCI") || db.driverName().startsWith("QDB2")) tablename = tablename.toLower(); else if (db.driverName().startsWith("QPSQL")) tablename = tablename.toUpper(); //check that we can't get records using incorrect tablename casing that's been quoted rec = db.driver()->record(db.driver()->escapeIdentifier(tablename,QSqlDriver::TableName)); if (tst_Databases::isMySQL(db) || db.driverName().startsWith("QSQLITE") || db.driverName().startsWith("QTDS") || tst_Databases::isSqlServer(db) || tst_Databases::isMSAccess(db)) QCOMPARE(rec.count(), 4); //mysql, sqlite and tds will match else QCOMPARE(rec.count(), 0); }
void tst_QSqlDriver::primaryIndex() { QFETCH_GLOBAL(QString, dbName); QSqlDatabase db = QSqlDatabase::database(dbName); CHECK_DATABASE(db); QString tablename(qTableName("relTEST1", __FILE__)); //check that we can get primary index using unquoted mixed case table name QSqlIndex index = db.driver()->primaryIndex(tablename); QCOMPARE(index.count(), 1); if( db.driverName().startsWith("QIBASE") || db.driverName().startsWith("QOCI") || db.driverName().startsWith("QDB2")) QCOMPARE(index.fieldName(0), QString::fromLatin1("ID")); else QCOMPARE(index.fieldName(0), QString::fromLatin1("id")); //check that we can get the primary index using a quoted tablename if( db.driverName().startsWith("QIBASE") || db.driverName().startsWith("QOCI") || db.driverName().startsWith("QDB2")) tablename = tablename.toUpper(); else if (db.driverName().startsWith("QPSQL")) tablename = tablename.toLower(); if(!db.driverName().startsWith("QODBC") && !db.databaseName().contains("PostgreSql")) { index = db.driver()->primaryIndex(db.driver()->escapeIdentifier(tablename, QSqlDriver::TableName)); QCOMPARE(index.count(), 1); } if( db.driverName().startsWith("QIBASE") || db.driverName().startsWith("QOCI") || db.driverName().startsWith("QDB2")) QCOMPARE(index.fieldName(0), QString::fromLatin1("ID")); else QCOMPARE(index.fieldName(0), QString::fromLatin1("id")); //check that we can not get the primary index using a quoted but incorrect table name casing if( db.driverName().startsWith("QIBASE") || db.driverName().startsWith("QOCI") || db.driverName().startsWith("QDB2")) tablename = tablename.toLower(); else if (db.driverName().startsWith("QPSQL")) tablename = tablename.toUpper(); index = db.driver()->primaryIndex(db.driver()->escapeIdentifier(tablename, QSqlDriver::TableName)); if (tst_Databases::isMySQL(db) || db.driverName().startsWith("QSQLITE") || db.driverName().startsWith("QTDS") || tst_Databases::isSqlServer(db) || tst_Databases::isMSAccess(db)) QCOMPARE(index.count(), 1); //mysql will always find the table name regardless of casing else QCOMPARE(index.count(), 0); }
int ModApiMainMenu::l_get_table_index(lua_State *L) { GUIEngine* engine = getGuiEngine(L); assert(engine != 0); std::wstring tablename(narrow_to_wide(luaL_checkstring(L, 1))); GUITable *table = engine->m_menu->getTable(tablename); s32 selection = table ? table->getSelected() : 0; if (selection >= 1) lua_pushinteger(L, selection); else lua_pushnil(L); return 1; }
status_t SaveRules(const char *path, BObjectList<FilerRule> *ruleList) { BEntry entry("/boot/home/config/settings/FilerRules"); if (entry.Exists()) entry.Remove(); CppSQLite3DB db; db.open("/boot/home/config/settings/FilerRules"); // While we could use other means of obtaining table names, this table is also // used for maintaining the order of the rules, which must be preserved DBCommand(db,"create table RuleList (ruleid int primary key, name varchar);", "PrefsWindow::SaveRules"); BString command; for (int32 i = 0; i < ruleList->CountItems(); i++) { FilerRule *rule = ruleList->ItemAt(i); // Test table: // 0) Entry type (test vs action) // 1) type // 2) mode // 3) value // 4) attribute type (if Attribute test) // 5) attribute type public name (short description) // 6) attribute public name (if Attribute test) BString tablename(EscapeIllegalCharacters(rule->GetDescription())); command = "create table "; command << tablename << "(entrytype varchar, testtype varchar, testmode varchar, testvalue varchar, attrtype varchar, attrtypename varchar, attrpublicname varchar);"; DBCommand(db,command.String(), "PrefsWindow::SaveRules"); command = "insert into RuleList values("; command << i << ",'" << tablename << "');"; DBCommand(db,command.String(), "PrefsWindow::SaveRules"); for (int32 j = 0; j < rule->CountTests(); j++) { BMessage *test = rule->TestAt(j); if (!test) continue; BString name,mode,value,mimeType,typeName, attrType, attrName; test->FindString("name",&name); test->FindString("mode",&mode); test->FindString("value",&value); test->FindString("mimetype",&mimeType); test->FindString("typename",&typeName); test->FindString("attrtype",&attrType); test->FindString("attrname",&attrName); command = "insert into "; command << tablename << " values('test', '" << EscapeIllegalCharacters(name.String()) << "', '" << EscapeIllegalCharacters(mode.String()) << "', '" << EscapeIllegalCharacters(value.String()) << "', '" << EscapeIllegalCharacters(mimeType.String()) << "', '" << EscapeIllegalCharacters(typeName.String()) << "', '" << EscapeIllegalCharacters(attrName.String()) << "');"; DBCommand(db,command.String(),"PrefsWindow::SaveRules:save test"); } for (int32 j = 0; j < rule->CountActions(); j++) { BMessage *action = rule->ActionAt(j); if (!action) continue; BString name,value; action->FindString("name",&name); action->FindString("value",&value); command = "insert into "; command << tablename << " values('action', '" << EscapeIllegalCharacters(name.String()) << "', '" << "', '" << EscapeIllegalCharacters(value.String()) << "', '', '', '');"; DBCommand(db,command.String(),"PrefsWindow::SaveRules:save action"); } } db.close(); return B_OK; }