int runTestAtrtClient(NDBT_Context* ctx, NDBT_Step* step){ AtrtClient atrt; SqlResultSet clusters; if (!atrt.getClusters(clusters)) return NDBT_FAILED; int i= 0; while(clusters.next()) { ndbout << clusters.column("name") << endl; if (i++ == 1){ ndbout << "removing: " << clusters.column("name") << endl; clusters.remove(); } } clusters.reset(); while(clusters.next()) { ndbout << clusters.column("name") << endl; } return NDBT_OK; }
int runTestDbUtil(NDBT_Context* ctx, NDBT_Step* step){ DbUtil sql; { // Select all rows from mysql.user SqlResultSet result; if (!sql.doQuery("SELECT * FROM mysql.user", result)) return NDBT_FAILED; // result.print(); while(result.next()) { ndbout << result.column("host") << ", " << result.column("uSer") << ", " << result.columnAsInt("max_updates") << ", " << endl; } result.reset(); while(result.next()) { ndbout << result.column("host") << endl; } } { // No column name, query should fail Properties args; SqlResultSet result; if (sql.doQuery("SELECT * FROM mysql.user WHERE name=?", args, result)) return NDBT_FAILED; result.print(); } { // Select nonexisiting rows from mysql.user Properties args; SqlResultSet result; args.put("0", "no_such_host"); if (!sql.doQuery("SELECT * FROM mysql.user WHERE host=?", args, result)) return NDBT_FAILED; ndbout << "no rows" << endl; result.print(); // Change args to an find one row args.clear(); args.put("0", "localhost"); if (!sql.doQuery("SELECT host, user FROM mysql.user WHERE host=?", args, result)) return NDBT_FAILED; result.print(); } { if (!sql.doQuery("CREATE TABLE sql_client_test (a int, b varchar(255))")) return NDBT_FAILED; if (!sql.doQuery("INSERT INTO sql_client_test VALUES(1, 'hello'), (2, 'bye')")) return NDBT_FAILED; // Select all rows from sql_client_test SqlResultSet result; if (!sql.doQuery("SELECT * FROM sql_client_test", result)) return NDBT_FAILED; // result.print(); while(result.next()) { } // Select second row from sql_client_test Properties args; args.put("0", 2); if (!sql.doQuery("SELECT * FROM sql_client_test WHERE a=?", args,result)) return NDBT_FAILED; result.print(); result.reset(); while(result.next()) { ndbout << "a: " << result.columnAsInt("a") << endl; ndbout << "b: " << result.column("b") << endl; if (result.columnAsInt("a") != 2){ ndbout << "hepp1" << endl; return NDBT_FAILED; } if (strcmp(result.column("b"), "bye")){ ndbout << "hepp2" << endl; return NDBT_FAILED; } } if (sql.selectCountTable("sql_client_test") != 2) { ndbout << "Got wrong count" << endl; return NDBT_FAILED; } if (!sql.doQuery("DROP TABLE sql_client_test")) return NDBT_FAILED; } return NDBT_OK; }