bool TestExtMysql::test_mysql_unbuffered_query() { Variant conn = f_mysql_connect(TEST_HOSTNAME, TEST_USERNAME, TEST_PASSWORD); VERIFY(CreateTestTable()); VS(f_mysql_query("insert into test (name) values ('test'),('test2')"), true); Variant res = f_mysql_unbuffered_query("select * from test"); Variant row = f_mysql_fetch_assoc(res); VS(f_print_r(row, true), "Array\n" "(\n" " [id] => 1\n" " [name] => test\n" ")\n"); row = f_mysql_fetch_assoc(res); VS(f_print_r(row, true), "Array\n" "(\n" " [id] => 2\n" " [name] => test2\n" ")\n"); row = f_mysql_fetch_assoc(res); VS(row, false); return Count(true); }
bool TestExtMysql::test_mysql_list_tables() { Variant conn = f_mysql_connect(TEST_HOSTNAME, TEST_USERNAME, TEST_PASSWORD); Variant res = f_mysql_list_tables(TEST_DATABASE); Variant table = f_mysql_fetch_assoc(res); VERIFY(!table[String("Tables_in_") + TEST_DATABASE].toString().empty()); return Count(true); }
bool TestExtMysql::test_mysql_list_processes() { Variant conn = f_mysql_connect(TEST_HOSTNAME, TEST_USERNAME, TEST_PASSWORD); Variant res = f_mysql_list_processes(); Variant process = f_mysql_fetch_assoc(res); VERIFY(!process["Id"].toString().empty()); return Count(true); }
bool TestExtMysql::test_mysql_list_dbs() { Variant conn = f_mysql_connect(TEST_HOSTNAME, TEST_USERNAME, TEST_PASSWORD); Variant res = f_mysql_list_dbs(); Variant db = f_mysql_fetch_assoc(res); VERIFY(!db["Database"].toString().empty()); return Count(true); }
bool TestExtMysql::test_mysql_list_processes() { static const StaticString s_Id("Id"); Variant conn = f_mysql_connect(TEST_HOSTNAME, TEST_USERNAME, TEST_PASSWORD); Variant res = f_mysql_list_processes(); Variant process = f_mysql_fetch_assoc(res); VERIFY(!process.toArray()[s_Id].toString().empty()); return Count(true); }
bool TestExtMysql::test_mysql_list_dbs() { static const StaticString s_Database("Database"); Variant conn = f_mysql_connect(TEST_HOSTNAME, TEST_USERNAME, TEST_PASSWORD); Variant res = f_mysql_list_dbs(); Variant db = f_mysql_fetch_assoc(res); if (db[s_Database].toString().empty()) { return CountSkip(); } return Count(true); }