/* refresh(r) */ static VALUE refresh(VALUE obj, VALUE r) { MYSQL* m = GetHandler(obj); if (mysql_refresh(m, NUM2INT(r)) != 0) mysql_raise(m); return obj; }
static int test_wl4284_1(MYSQL *mysql) { int rc; MYSQL_ROW row; MYSQL_RES *result; if (mysql_get_server_version(mysql) < 60000) { diag("Test requires MySQL Server version 6.0 or above"); return SKIP; } /* set AUTOCOMMIT to OFF */ rc= mysql_autocommit(mysql, FALSE); check_mysql_rc(rc, mysql); rc= mysql_query(mysql, "DROP TABLE IF EXISTS trans"); check_mysql_rc(rc, mysql); rc= mysql_query(mysql, "CREATE TABLE trans (a INT) ENGINE= InnoDB"); check_mysql_rc(rc, mysql); rc= mysql_query(mysql, "INSERT INTO trans VALUES(1)"); check_mysql_rc(rc, mysql); rc= mysql_refresh(mysql, REFRESH_GRANT | REFRESH_TABLES); check_mysql_rc(rc, mysql); rc= mysql_rollback(mysql); check_mysql_rc(rc, mysql); rc= mysql_query(mysql, "SELECT * FROM trans"); check_mysql_rc(rc, mysql); result= mysql_use_result(mysql); FAIL_IF(!result, "Invalid result set"); row= mysql_fetch_row(result); FAIL_IF(!row, "Can't fetch row"); mysql_free_result(result); /* set AUTOCOMMIT to OFF */ rc= mysql_autocommit(mysql, FALSE); check_mysql_rc(rc, mysql); rc= mysql_query(mysql, "DROP TABLE trans"); check_mysql_rc(rc, mysql); return OK; }
int CDatabase_Connection::refresh(unsigned int options) { return mysql_refresh(&my, options); }