Differential D29346 Diff 81700 autotests/OrderByColumnTest.cpp

Changeset View

Standalone View

View Options

autotests/OrderByColumnTest.cpp

Show First 20 Lines • Show All 64 Lines • ▼ Show 20 Line(s)37{
65 KDbEscapedString orderBySqlOldApi = orderBy->toSqlString(true, conn, KDb::KDbEscaping); 65​ KDbEscapedString orderBySqlOldApi = orderBy->toSqlString(true, conn, KDb::KDbEscaping);
66 QCOMPARE(orderBySqlOldApi, ""); // alias is not used 66​ QCOMPARE(orderBySqlOldApi, ""); // alias is not used
67 KDbEscapedString orderBySql = orderBy->toSqlString(true, conn, &query, KDb::KDbEscaping); 67​ KDbEscapedString orderBySql = orderBy->toSqlString(true, conn, &query, KDb::KDbEscaping);
68 QCOMPARE(orderBySql, alias); // alias is used to point to the column "'foo'" 68​ QCOMPARE(orderBySql, alias); // alias is used to point to the column "'foo'"
69 69​
70 // change alias to something other than valid ID 70​ // change alias to something other than valid ID
71 QVERIFY(query.setColumnAlias(indexOfField, "0")); 71​ QVERIFY(query.setColumnAlias(indexOfField, "0"));
72 QVERIFY(utils.kdbBuilder()->generateSelectStatement(&sql, &query)); 72​ QVERIFY(utils.kdbBuilder()->generateSelectStatement(&sql, &query));
73 QCOMPARE(sql, "SELECT 'foo' AS \"0\" ORDER BY \"0\""); 73​ QCOMPARE(sql, "SELECT 'foo' AS [0] ORDER BY [0]");
74 orderBySqlOldApi = orderBy->toSqlString(true, conn, KDb::KDbEscaping); 74​ orderBySqlOldApi = orderBy->toSqlString(true, conn, KDb::KDbEscaping);
75 QCOMPARE(orderBySqlOldApi, ""); // alias is not used 75​ QCOMPARE(orderBySqlOldApi, ""); // alias is not used
76 orderBySql = orderBy->toSqlString(true, conn, &query, KDb::KDbEscaping); 76​ orderBySql = orderBy->toSqlString(true, conn, &query, KDb::KDbEscaping);
77 QCOMPARE(orderBySql, "\"0\""); // alias is used to point to the column "'foo'" 77​ QCOMPARE(orderBySql, "[0]"); // alias is used to point to the column "'foo'"
78} 78​}
79 79​
80void OrderByColumnTest::testOrderByIndex() 80​void OrderByColumnTest::testOrderByIndex()
81{ 81​{
82 QVERIFY(utils.testCreateDbWithTables("OrderByColumnTest")); 82​ QVERIFY(utils.testCreateDbWithTables("OrderByColumnTest"));
83 KDbQuerySchema query; 83​ KDbQuerySchema query;
84 KDbTableSchema *carsTable = utils.connection()->tableSchema("cars"); 84​ KDbTableSchema *carsTable = utils.connection()->tableSchema("cars");
85 QVERIFY(carsTable); 85​ QVERIFY(carsTable);
▲ Show 20 Lines • Show All 128 Lines • Show Last 20 Lines