Class: Mysql
- Inherits:
-
Object
- Object
- Mysql
- Defined in:
- lib/mysql.rb,
ext/mysql_api/mysql.c
Overview
define version string to be used internally for the Gem by Hoe.
Defined Under Namespace
Modules: GemVersion Classes: Error, Field, Result, RowOffset, Stmt, Time
Constant Summary collapse
- VERSION =
Mysql constant
INT2FIX(MYSQL_RUBY_VERSION)
- OPT_CONNECT_TIMEOUT =
INT2NUM(MYSQL_OPT_CONNECT_TIMEOUT)
- OPT_COMPRESS =
INT2NUM(MYSQL_OPT_COMPRESS)
- OPT_NAMED_PIPE =
INT2NUM(MYSQL_OPT_NAMED_PIPE)
- INIT_COMMAND =
INT2NUM(MYSQL_INIT_COMMAND)
- READ_DEFAULT_FILE =
INT2NUM(MYSQL_READ_DEFAULT_FILE)
- READ_DEFAULT_GROUP =
INT2NUM(MYSQL_READ_DEFAULT_GROUP)
- SET_CHARSET_DIR =
INT2NUM(MYSQL_SET_CHARSET_DIR)
- SET_CHARSET_NAME =
INT2NUM(MYSQL_SET_CHARSET_NAME)
- OPT_LOCAL_INFILE =
INT2NUM(MYSQL_OPT_LOCAL_INFILE)
- OPT_PROTOCOL =
INT2NUM(MYSQL_OPT_PROTOCOL)
- SHARED_MEMORY_BASE_NAME =
INT2NUM(MYSQL_SHARED_MEMORY_BASE_NAME)
- OPT_READ_TIMEOUT =
INT2NUM(MYSQL_OPT_READ_TIMEOUT)
- OPT_WRITE_TIMEOUT =
INT2NUM(MYSQL_OPT_WRITE_TIMEOUT)
- SECURE_AUTH =
INT2NUM(MYSQL_SECURE_AUTH)
- OPT_GUESS_CONNECTION =
INT2NUM(MYSQL_OPT_GUESS_CONNECTION)
- OPT_USE_EMBEDDED_CONNECTION =
INT2NUM(MYSQL_OPT_USE_EMBEDDED_CONNECTION)
- OPT_USE_REMOTE_CONNECTION =
INT2NUM(MYSQL_OPT_USE_REMOTE_CONNECTION)
- SET_CLIENT_IP =
INT2NUM(MYSQL_SET_CLIENT_IP)
- REFRESH_GRANT =
INT2NUM(REFRESH_GRANT)
- REFRESH_LOG =
INT2NUM(REFRESH_LOG)
- REFRESH_TABLES =
INT2NUM(REFRESH_TABLES)
- REFRESH_HOSTS =
INT2NUM(REFRESH_HOSTS)
- REFRESH_STATUS =
INT2NUM(REFRESH_STATUS)
- REFRESH_THREADS =
INT2NUM(REFRESH_THREADS)
- REFRESH_SLAVE =
INT2NUM(REFRESH_SLAVE)
- REFRESH_MASTER =
INT2NUM(REFRESH_MASTER)
- CLIENT_FOUND_ROWS =
INT2NUM(CLIENT_FOUND_ROWS)
- CLIENT_NO_SCHEMA =
INT2NUM(CLIENT_NO_SCHEMA)
- CLIENT_COMPRESS =
INT2NUM(CLIENT_COMPRESS)
- CLIENT_ODBC =
INT2NUM(CLIENT_ODBC)
- CLIENT_LOCAL_FILES =
INT2NUM(CLIENT_LOCAL_FILES)
- CLIENT_IGNORE_SPACE =
INT2NUM(CLIENT_IGNORE_SPACE)
- CLIENT_CHANGE_USER =
INT2NUM(CLIENT_CHANGE_USER)
- CLIENT_INTERACTIVE =
INT2NUM(CLIENT_INTERACTIVE)
- CLIENT_SSL =
INT2NUM(CLIENT_SSL)
- CLIENT_IGNORE_SIGPIPE =
INT2NUM(CLIENT_IGNORE_SIGPIPE)
- CLIENT_TRANSACTIONS =
INT2NUM(CLIENT_TRANSACTIONS)
- CLIENT_MULTI_STATEMENTS =
INT2NUM(CLIENT_MULTI_STATEMENTS)
- CLIENT_MULTI_RESULTS =
INT2NUM(CLIENT_MULTI_RESULTS)
- OPTION_MULTI_STATEMENTS_ON =
INT2NUM(MYSQL_OPTION_MULTI_STATEMENTS_ON)
- OPTION_MULTI_STATEMENTS_OFF =
INT2NUM(MYSQL_OPTION_MULTI_STATEMENTS_OFF)
Class Method Summary collapse
-
.client_info ⇒ Object
client_info().
-
.client_version ⇒ Object
client_version().
-
.connect(*args) ⇒ Object
real_connect(host=nil, user=nil, passwd=nil, db=nil, port=nil, sock=nil, flag=nil).
-
.debug(str) ⇒ Object
my_debug(string).
-
.escape_string(str) ⇒ Object
escape_string(string).
-
.get_client_info ⇒ Object
client_info().
-
.get_client_version ⇒ Object
client_version().
-
.init ⇒ Object
init().
-
.new(*args) ⇒ Object
real_connect(host=nil, user=nil, passwd=nil, db=nil, port=nil, sock=nil, flag=nil).
-
.quote(str) ⇒ Object
escape_string(string).
-
.real_connect(*args) ⇒ Object
real_connect(host=nil, user=nil, passwd=nil, db=nil, port=nil, sock=nil, flag=nil).
Instance Method Summary collapse
-
#affected_rows ⇒ Object
affected_rows().
-
#autocommit(mode) ⇒ Object
autocommit().
-
#change_user(*args) ⇒ Object
change_user(user=nil, passwd=nil, db=nil).
-
#character_set_name ⇒ Object
character_set_name().
-
#client_info ⇒ Object
client_info().
-
#client_version ⇒ Object
client_version().
-
#close ⇒ Object
close().
-
#commit ⇒ Object
commit().
-
#connect(*args) ⇒ Object
real_connect(host=nil, user=nil, passwd=nil, db=nil, port=nil, sock=nil, flag=nil).
-
#create_db(db) ⇒ Object
create_db(db).
-
#drop_db(db) ⇒ Object
drop_db(db).
-
#dump_debug_info ⇒ Object
dump_debug_info().
-
#errno ⇒ Object
errno().
-
#error ⇒ Object
error().
-
#escape_string(str) ⇒ Object
escape_string(string).
-
#field_count ⇒ Object
field_count().
-
#get_client_info ⇒ Object
client_info().
-
#get_client_version ⇒ Object
client_version().
-
#get_host_info ⇒ Object
host_info().
-
#get_proto_info ⇒ Object
proto_info().
-
#get_server_info ⇒ Object
server_info().
-
#get_server_version ⇒ Object
server_version().
-
#host_info ⇒ Object
host_info().
-
#info ⇒ Object
info().
-
#initialize(*args) ⇒ Object
constructor
initialize().
-
#insert_id ⇒ Object
insert_id().
-
#kill(pid) ⇒ Object
kill(pid).
-
#list_dbs(*args) ⇒ Object
list_dbs(db=nil).
-
#list_fields(*args) ⇒ Object
list_fields(table, field=nil).
-
#list_processes ⇒ Object
list_processes().
-
#list_tables(*args) ⇒ Object
list_tables(table=nil).
-
#more_results ⇒ Object
more_results().
-
#more_results? ⇒ Boolean
more_results().
- #next_result ⇒ Object
-
#options(*args) ⇒ Object
options(opt, value=nil).
-
#ping ⇒ Object
ping().
-
#prepare(query) ⇒ Object
prepare(query).
-
#proto_info ⇒ Object
proto_info().
-
#query(sql) ⇒ Object
query(sql).
-
#query_with_result ⇒ Object
query_with_result().
-
#query_with_result=(flag) ⇒ Object
query_with_result=(flag).
-
#quote(str) ⇒ Object
escape_string(string).
-
#real_connect(*args) ⇒ Object
real_connect(host=nil, user=nil, passwd=nil, db=nil, port=nil, sock=nil, flag=nil).
-
#real_query(sql) ⇒ Object
query(sql).
-
#reconnect ⇒ Object
reconnect().
-
#reconnect=(flag) ⇒ Object
reconnect=(flag).
-
#refresh(r) ⇒ Object
refresh®.
-
#reload ⇒ Object
reload().
-
#rollback ⇒ Object
rollback().
-
#select_db(db) ⇒ Object
select_db(db).
-
#server_info ⇒ Object
server_info().
-
#server_version ⇒ Object
server_version().
-
#set_server_option(option) ⇒ Object
set_server_option(option).
-
#shutdown(*args) ⇒ Object
shutdown().
-
#sqlstate ⇒ Object
sqlstate().
-
#ssl_set(*args) ⇒ Object
ssl_set(key=nil, cert=nil, ca=nil, capath=nil, cipher=nil).
-
#stat ⇒ Object
stat().
-
#stmt_init ⇒ Object
stmt_init().
-
#store_result ⇒ Object
store_result().
-
#thread_id ⇒ Object
thread_id().
-
#use_result ⇒ Object
use_result().
-
#warning_count ⇒ Object
warning_count().
Constructor Details
#initialize(*args) ⇒ Object
initialize()
440 441 442 443 |
# File 'ext/mysql_api/mysql.c', line 440
static VALUE initialize(int argc, VALUE* argv, VALUE obj)
{
return obj;
}
|
Class Method Details
.client_info ⇒ Object
client_info()
295 296 297 298 |
# File 'ext/mysql_api/mysql.c', line 295
static VALUE client_info(VALUE klass)
{
return rb_tainted_str_new2(mysql_get_client_info());
}
|
.client_version ⇒ Object
client_version()
311 312 313 314 |
# File 'ext/mysql_api/mysql.c', line 311
static VALUE client_version(VALUE obj)
{
return INT2NUM(mysql_get_client_version());
}
|
.connect(*args) ⇒ Object
real_connect(host=nil, user=nil, passwd=nil, db=nil, port=nil, sock=nil, flag=nil)
230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 |
# File 'ext/mysql_api/mysql.c', line 230
static VALUE real_connect(int argc, VALUE* argv, VALUE klass)
{
VALUE host, user, passwd, db, port, sock, flag;
char *h, *u, *p, *d, *s;
unsigned int pp, f;
struct mysql* myp;
VALUE obj;
#if MYSQL_VERSION_ID >= 32200
rb_scan_args(argc, argv, "07", &host, &user, &passwd, &db, &port, &sock, &flag);
d = NILorSTRING(db);
f = NILorINT(flag);
#elif MYSQL_VERSION_ID >= 32115
rb_scan_args(argc, argv, "06", &host, &user, &passwd, &port, &sock, &flag);
f = NILorINT(flag);
#else
rb_scan_args(argc, argv, "05", &host, &user, &passwd, &port, &sock);
#endif
h = NILorSTRING(host);
u = NILorSTRING(user);
p = NILorSTRING(passwd);
pp = NILorINT(port);
s = NILorSTRING(sock);
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_stop_timer();
#endif
obj = Data_Make_Struct(klass, struct mysql, 0, free_mysql, myp);
#if MYSQL_VERSION_ID >= 32200
mysql_init(&myp->handler);
if (mysql_real_connect(&myp->handler, h, u, p, d, pp, s, f) == NULL)
#elif MYSQL_VERSION_ID >= 32115
if (mysql_real_connect(&myp->handler, h, u, p, pp, s, f) == NULL)
#else
if (mysql_real_connect(&myp->handler, h, u, p, pp, s) == NULL)
#endif
{
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_start_timer();
#endif
mysql_raise(&myp->handler);
}
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_start_timer();
#endif
myp->handler.reconnect = 0;
myp->connection = Qtrue;
myp->query_with_result = Qtrue;
rb_obj_call_init(obj, argc, argv);
return obj;
}
|
.debug(str) ⇒ Object
my_debug(string)
302 303 304 305 306 |
# File 'ext/mysql_api/mysql.c', line 302
static VALUE my_debug(VALUE obj, VALUE str)
{
mysql_debug(StringValuePtr(str));
return obj;
}
|
.escape_string(str) ⇒ Object
escape_string(string)
285 286 287 288 289 290 291 292 |
# File 'ext/mysql_api/mysql.c', line 285
static VALUE escape_string(VALUE klass, VALUE str)
{
VALUE ret;
Check_Type(str, T_STRING);
ret = rb_str_new(0, (RSTRING_LEN(str))*2+1);
rb_str_set_len(ret, mysql_escape_string(RSTRING_PTR(ret), RSTRING_PTR(str), RSTRING_LEN(str)));
return ret;
}
|
.get_client_info ⇒ Object
client_info()
295 296 297 298 |
# File 'ext/mysql_api/mysql.c', line 295
static VALUE client_info(VALUE klass)
{
return rb_tainted_str_new2(mysql_get_client_info());
}
|
.get_client_version ⇒ Object
client_version()
311 312 313 314 |
# File 'ext/mysql_api/mysql.c', line 311
static VALUE client_version(VALUE obj)
{
return INT2NUM(mysql_get_client_version());
}
|
.init ⇒ Object
init()
216 217 218 219 220 221 222 223 224 225 226 227 |
# File 'ext/mysql_api/mysql.c', line 216
static VALUE init(VALUE klass)
{
struct mysql* myp;
VALUE obj;
obj = Data_Make_Struct(klass, struct mysql, 0, free_mysql, myp);
mysql_init(&myp->handler);
myp->connection = Qfalse;
myp->query_with_result = Qtrue;
rb_obj_call_init(obj, 0, NULL);
return obj;
}
|
.new(*args) ⇒ Object
real_connect(host=nil, user=nil, passwd=nil, db=nil, port=nil, sock=nil, flag=nil)
230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 |
# File 'ext/mysql_api/mysql.c', line 230
static VALUE real_connect(int argc, VALUE* argv, VALUE klass)
{
VALUE host, user, passwd, db, port, sock, flag;
char *h, *u, *p, *d, *s;
unsigned int pp, f;
struct mysql* myp;
VALUE obj;
#if MYSQL_VERSION_ID >= 32200
rb_scan_args(argc, argv, "07", &host, &user, &passwd, &db, &port, &sock, &flag);
d = NILorSTRING(db);
f = NILorINT(flag);
#elif MYSQL_VERSION_ID >= 32115
rb_scan_args(argc, argv, "06", &host, &user, &passwd, &port, &sock, &flag);
f = NILorINT(flag);
#else
rb_scan_args(argc, argv, "05", &host, &user, &passwd, &port, &sock);
#endif
h = NILorSTRING(host);
u = NILorSTRING(user);
p = NILorSTRING(passwd);
pp = NILorINT(port);
s = NILorSTRING(sock);
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_stop_timer();
#endif
obj = Data_Make_Struct(klass, struct mysql, 0, free_mysql, myp);
#if MYSQL_VERSION_ID >= 32200
mysql_init(&myp->handler);
if (mysql_real_connect(&myp->handler, h, u, p, d, pp, s, f) == NULL)
#elif MYSQL_VERSION_ID >= 32115
if (mysql_real_connect(&myp->handler, h, u, p, pp, s, f) == NULL)
#else
if (mysql_real_connect(&myp->handler, h, u, p, pp, s) == NULL)
#endif
{
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_start_timer();
#endif
mysql_raise(&myp->handler);
}
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_start_timer();
#endif
myp->handler.reconnect = 0;
myp->connection = Qtrue;
myp->query_with_result = Qtrue;
rb_obj_call_init(obj, argc, argv);
return obj;
}
|
.quote(str) ⇒ Object
escape_string(string)
285 286 287 288 289 290 291 292 |
# File 'ext/mysql_api/mysql.c', line 285
static VALUE escape_string(VALUE klass, VALUE str)
{
VALUE ret;
Check_Type(str, T_STRING);
ret = rb_str_new(0, (RSTRING_LEN(str))*2+1);
rb_str_set_len(ret, mysql_escape_string(RSTRING_PTR(ret), RSTRING_PTR(str), RSTRING_LEN(str)));
return ret;
}
|
.real_connect(*args) ⇒ Object
real_connect(host=nil, user=nil, passwd=nil, db=nil, port=nil, sock=nil, flag=nil)
230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 |
# File 'ext/mysql_api/mysql.c', line 230
static VALUE real_connect(int argc, VALUE* argv, VALUE klass)
{
VALUE host, user, passwd, db, port, sock, flag;
char *h, *u, *p, *d, *s;
unsigned int pp, f;
struct mysql* myp;
VALUE obj;
#if MYSQL_VERSION_ID >= 32200
rb_scan_args(argc, argv, "07", &host, &user, &passwd, &db, &port, &sock, &flag);
d = NILorSTRING(db);
f = NILorINT(flag);
#elif MYSQL_VERSION_ID >= 32115
rb_scan_args(argc, argv, "06", &host, &user, &passwd, &port, &sock, &flag);
f = NILorINT(flag);
#else
rb_scan_args(argc, argv, "05", &host, &user, &passwd, &port, &sock);
#endif
h = NILorSTRING(host);
u = NILorSTRING(user);
p = NILorSTRING(passwd);
pp = NILorINT(port);
s = NILorSTRING(sock);
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_stop_timer();
#endif
obj = Data_Make_Struct(klass, struct mysql, 0, free_mysql, myp);
#if MYSQL_VERSION_ID >= 32200
mysql_init(&myp->handler);
if (mysql_real_connect(&myp->handler, h, u, p, d, pp, s, f) == NULL)
#elif MYSQL_VERSION_ID >= 32115
if (mysql_real_connect(&myp->handler, h, u, p, pp, s, f) == NULL)
#else
if (mysql_real_connect(&myp->handler, h, u, p, pp, s) == NULL)
#endif
{
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_start_timer();
#endif
mysql_raise(&myp->handler);
}
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_start_timer();
#endif
myp->handler.reconnect = 0;
myp->connection = Qtrue;
myp->query_with_result = Qtrue;
rb_obj_call_init(obj, argc, argv);
return obj;
}
|
Instance Method Details
#affected_rows ⇒ Object
affected_rows()
446 447 448 449 |
# File 'ext/mysql_api/mysql.c', line 446
static VALUE affected_rows(VALUE obj)
{
return INT2NUM(mysql_affected_rows(GetHandler(obj)));
}
|
#autocommit(mode) ⇒ Object
autocommit()
801 802 803 804 805 806 807 808 809 |
# File 'ext/mysql_api/mysql.c', line 801
static VALUE autocommit(VALUE obj, VALUE mode)
{
MYSQL* m = GetHandler(obj);
int f;
f = (mode == Qnil || mode == Qfalse || (rb_type(mode) == T_FIXNUM && NUM2INT(mode) == 0)) ? 0 : 1;
if (mysql_autocommit(m, f) != 0)
mysql_raise(m);
return obj;
}
|
#change_user(*args) ⇒ Object
change_user(user=nil, passwd=nil, db=nil)
453 454 455 456 457 458 459 460 461 462 463 464 465 |
# File 'ext/mysql_api/mysql.c', line 453
static VALUE change_user(int argc, VALUE* argv, VALUE obj)
{
VALUE user, passwd, db;
char *u, *p, *d;
MYSQL* m = GetHandler(obj);
rb_scan_args(argc, argv, "03", &user, &passwd, &db);
u = NILorSTRING(user);
p = NILorSTRING(passwd);
d = NILorSTRING(db);
if (mysql_change_user(m, u, p, d) != 0)
mysql_raise(m);
return obj;
}
|
#character_set_name ⇒ Object
character_set_name()
470 471 472 473 |
# File 'ext/mysql_api/mysql.c', line 470
static VALUE character_set_name(VALUE obj)
{
return rb_tainted_str_new2(mysql_character_set_name(GetHandler(obj)));
}
|
#client_info ⇒ Object
client_info()
295 296 297 298 |
# File 'ext/mysql_api/mysql.c', line 295
static VALUE client_info(VALUE klass)
{
return rb_tainted_str_new2(mysql_get_client_info());
}
|
#client_version ⇒ Object
client_version()
311 312 313 314 |
# File 'ext/mysql_api/mysql.c', line 311
static VALUE client_version(VALUE obj)
{
return INT2NUM(mysql_get_client_version());
}
|
#close ⇒ Object
close()
477 478 479 480 481 482 483 |
# File 'ext/mysql_api/mysql.c', line 477
static VALUE my_close(VALUE obj)
{
MYSQL* m = GetHandler(obj);
mysql_close(m);
GetMysqlStruct(obj)->connection = Qfalse;
return obj;
}
|
#commit ⇒ Object
commit()
783 784 785 786 787 788 789 |
# File 'ext/mysql_api/mysql.c', line 783
static VALUE commit(VALUE obj)
{
MYSQL* m = GetHandler(obj);
if (mysql_commit(m) != 0)
mysql_raise(m);
return obj;
}
|
#connect(*args) ⇒ Object
real_connect(host=nil, user=nil, passwd=nil, db=nil, port=nil, sock=nil, flag=nil)
323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 |
# File 'ext/mysql_api/mysql.c', line 323
static VALUE real_connect2(int argc, VALUE* argv, VALUE obj)
{
VALUE host, user, passwd, db, port, sock, flag;
char *h, *u, *p, *d, *s;
unsigned int pp, f;
MYSQL* m = GetHandler(obj);
rb_scan_args(argc, argv, "07", &host, &user, &passwd, &db, &port, &sock, &flag);
d = NILorSTRING(db);
f = NILorINT(flag);
h = NILorSTRING(host);
u = NILorSTRING(user);
p = NILorSTRING(passwd);
pp = NILorINT(port);
s = NILorSTRING(sock);
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_stop_timer();
#endif
if (mysql_real_connect(m, h, u, p, d, pp, s, f) == NULL) {
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_start_timer();
#endif
mysql_raise(m);
}
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_start_timer();
#endif
m->reconnect = 0;
GetMysqlStruct(obj)->connection = Qtrue;
return obj;
}
|
#create_db(db) ⇒ Object
create_db(db)
487 488 489 490 491 492 493 |
# File 'ext/mysql_api/mysql.c', line 487
static VALUE create_db(VALUE obj, VALUE db)
{
MYSQL* m = GetHandler(obj);
if (mysql_create_db(m, StringValuePtr(db)) != 0)
mysql_raise(m);
return obj;
}
|
#drop_db(db) ⇒ Object
drop_db(db)
496 497 498 499 500 501 502 |
# File 'ext/mysql_api/mysql.c', line 496
static VALUE drop_db(VALUE obj, VALUE db)
{
MYSQL* m = GetHandler(obj);
if (mysql_drop_db(m, StringValuePtr(db)) != 0)
mysql_raise(m);
return obj;
}
|
#dump_debug_info ⇒ Object
dump_debug_info()
507 508 509 510 511 512 513 |
# File 'ext/mysql_api/mysql.c', line 507
static VALUE dump_debug_info(VALUE obj)
{
MYSQL* m = GetHandler(obj);
if (mysql_dump_debug_info(m) != 0)
mysql_raise(m);
return obj;
}
|
#errno ⇒ Object
errno()
517 518 519 520 |
# File 'ext/mysql_api/mysql.c', line 517
static VALUE my_errno(VALUE obj)
{
return INT2NUM(mysql_errno(GetHandler(obj)));
}
|
#error ⇒ Object
error()
523 524 525 526 |
# File 'ext/mysql_api/mysql.c', line 523
static VALUE my_error(VALUE obj)
{
return rb_str_new2(mysql_error(GetHandler(obj)));
}
|
#escape_string(str) ⇒ Object
escape_string(string)
428 429 430 431 432 433 434 435 436 |
# File 'ext/mysql_api/mysql.c', line 428
static VALUE real_escape_string(VALUE obj, VALUE str)
{
MYSQL* m = GetHandler(obj);
VALUE ret;
Check_Type(str, T_STRING);
ret = rb_str_new(0, (RSTRING_LEN(str))*2+1);
rb_str_set_len(ret, mysql_real_escape_string(m, RSTRING_PTR(ret), RSTRING_PTR(str), RSTRING_LEN(str)));
return ret;
}
|
#field_count ⇒ Object
field_count()
529 530 531 532 |
# File 'ext/mysql_api/mysql.c', line 529
static VALUE field_count(VALUE obj)
{
return INT2NUM(mysql_field_count(GetHandler(obj)));
}
|
#get_client_info ⇒ Object
client_info()
295 296 297 298 |
# File 'ext/mysql_api/mysql.c', line 295
static VALUE client_info(VALUE klass)
{
return rb_tainted_str_new2(mysql_get_client_info());
}
|
#get_client_version ⇒ Object
client_version()
311 312 313 314 |
# File 'ext/mysql_api/mysql.c', line 311
static VALUE client_version(VALUE obj)
{
return INT2NUM(mysql_get_client_version());
}
|
#get_host_info ⇒ Object
host_info()
535 536 537 538 |
# File 'ext/mysql_api/mysql.c', line 535
static VALUE host_info(VALUE obj)
{
return rb_tainted_str_new2(mysql_get_host_info(GetHandler(obj)));
}
|
#get_proto_info ⇒ Object
proto_info()
541 542 543 544 |
# File 'ext/mysql_api/mysql.c', line 541
static VALUE proto_info(VALUE obj)
{
return INT2NUM(mysql_get_proto_info(GetHandler(obj)));
}
|
#get_server_info ⇒ Object
server_info()
547 548 549 550 |
# File 'ext/mysql_api/mysql.c', line 547
static VALUE server_info(VALUE obj)
{
return rb_tainted_str_new2(mysql_get_server_info(GetHandler(obj)));
}
|
#get_server_version ⇒ Object
server_version()
771 772 773 774 |
# File 'ext/mysql_api/mysql.c', line 771
static VALUE server_version(VALUE obj)
{
return INT2NUM(mysql_get_server_version(GetHandler(obj)));
}
|
#host_info ⇒ Object
host_info()
535 536 537 538 |
# File 'ext/mysql_api/mysql.c', line 535
static VALUE host_info(VALUE obj)
{
return rb_tainted_str_new2(mysql_get_host_info(GetHandler(obj)));
}
|
#info ⇒ Object
info()
553 554 555 556 557 |
# File 'ext/mysql_api/mysql.c', line 553
static VALUE info(VALUE obj)
{
const char* p = mysql_info(GetHandler(obj));
return p? rb_tainted_str_new2(p): Qnil;
}
|
#insert_id ⇒ Object
insert_id()
560 561 562 563 |
# File 'ext/mysql_api/mysql.c', line 560
static VALUE insert_id(VALUE obj)
{
return INT2NUM(mysql_insert_id(GetHandler(obj)));
}
|
#kill(pid) ⇒ Object
kill(pid)
566 567 568 569 570 571 572 573 |
# File 'ext/mysql_api/mysql.c', line 566
static VALUE my_kill(VALUE obj, VALUE pid)
{
int p = NUM2INT(pid);
MYSQL* m = GetHandler(obj);
if (mysql_kill(m, p) != 0)
mysql_raise(m);
return obj;
}
|
#list_dbs(*args) ⇒ Object
list_dbs(db=nil)
576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 |
# File 'ext/mysql_api/mysql.c', line 576
static VALUE list_dbs(int argc, VALUE* argv, VALUE obj)
{
unsigned int i, n;
VALUE db, ret;
MYSQL* m = GetHandler(obj);
MYSQL_RES* res;
rb_scan_args(argc, argv, "01", &db);
res = mysql_list_dbs(m, NILorSTRING(db));
if (res == NULL)
mysql_raise(m);
n = mysql_num_rows(res);
ret = rb_ary_new2(n);
for (i=0; i<n; i++)
rb_ary_store(ret, i, rb_tainted_str_new2(mysql_fetch_row(res)[0]));
mysql_free_result(res);
return ret;
}
|
#list_fields(*args) ⇒ Object
list_fields(table, field=nil)
597 598 599 600 601 602 603 604 605 606 607 |
# File 'ext/mysql_api/mysql.c', line 597
static VALUE list_fields(int argc, VALUE* argv, VALUE obj)
{
VALUE table, field;
MYSQL* m = GetHandler(obj);
MYSQL_RES* res;
rb_scan_args(argc, argv, "11", &table, &field);
res = mysql_list_fields(m, StringValuePtr(table), NILorSTRING(field));
if (res == NULL)
mysql_raise(m);
return mysqlres2obj(res);
}
|
#list_processes ⇒ Object
list_processes()
610 611 612 613 614 615 616 617 |
# File 'ext/mysql_api/mysql.c', line 610
static VALUE list_processes(VALUE obj)
{
MYSQL* m = GetHandler(obj);
MYSQL_RES* res = mysql_list_processes(m);
if (res == NULL)
mysql_raise(m);
return mysqlres2obj(res);
}
|
#list_tables(*args) ⇒ Object
list_tables(table=nil)
620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 |
# File 'ext/mysql_api/mysql.c', line 620
static VALUE list_tables(int argc, VALUE* argv, VALUE obj)
{
VALUE table;
MYSQL* m = GetHandler(obj);
MYSQL_RES* res;
unsigned int i, n;
VALUE ret;
rb_scan_args(argc, argv, "01", &table);
res = mysql_list_tables(m, NILorSTRING(table));
if (res == NULL)
mysql_raise(m);
n = mysql_num_rows(res);
ret = rb_ary_new2(n);
for (i=0; i<n; i++)
rb_ary_store(ret, i, rb_tainted_str_new2(mysql_fetch_row(res)[0]));
mysql_free_result(res);
return ret;
}
|
#more_results ⇒ Object
more_results()
832 833 834 835 836 837 838 |
# File 'ext/mysql_api/mysql.c', line 832
static VALUE more_results(VALUE obj)
{
if (mysql_more_results(GetHandler(obj)) == 0)
return Qfalse;
else
return Qtrue;
}
|
#more_results? ⇒ Boolean
more_results()
832 833 834 835 836 837 838 |
# File 'ext/mysql_api/mysql.c', line 832
static VALUE more_results(VALUE obj)
{
if (mysql_more_results(GetHandler(obj)) == 0)
return Qfalse;
else
return Qtrue;
}
|
#next_result ⇒ Object
840 841 842 843 844 845 846 847 848 849 850 |
# File 'ext/mysql_api/mysql.c', line 840
static VALUE next_result(VALUE obj)
{
MYSQL* m = GetHandler(obj);
int ret;
ret = mysql_next_result(m);
if (ret > 0)
mysql_raise(m);
if (ret == 0)
return Qtrue;
return Qfalse;
}
|
#options(*args) ⇒ Object
options(opt, value=nil)
357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 |
# File 'ext/mysql_api/mysql.c', line 357
static VALUE options(int argc, VALUE* argv, VALUE obj)
{
VALUE opt, val;
int n;
my_bool b;
char* v;
MYSQL* m = GetHandler(obj);
rb_scan_args(argc, argv, "11", &opt, &val);
switch(NUM2INT(opt)) {
case MYSQL_OPT_CONNECT_TIMEOUT:
#if MYSQL_VERSION_ID >= 40100
case MYSQL_OPT_PROTOCOL:
#endif
#if MYSQL_VERSION_ID >= 40101
case MYSQL_OPT_READ_TIMEOUT:
case MYSQL_OPT_WRITE_TIMEOUT:
#endif
if (val == Qnil)
rb_raise(rb_eArgError, "wrong # of arguments(1 for 2)");
n = NUM2INT(val);
v = (char*)&n;
break;
case MYSQL_INIT_COMMAND:
case MYSQL_READ_DEFAULT_FILE:
case MYSQL_READ_DEFAULT_GROUP:
#if MYSQL_VERSION_ID >= 32349
case MYSQL_SET_CHARSET_DIR:
case MYSQL_SET_CHARSET_NAME:
#endif
#if MYSQL_VERSION_ID >= 40100
case MYSQL_SHARED_MEMORY_BASE_NAME:
#endif
#if MYSQL_VERSION_ID >= 40101
case MYSQL_SET_CLIENT_IP:
#endif
if (val == Qnil)
rb_raise(rb_eArgError, "wrong # of arguments(1 for 2)");
v = StringValuePtr(val);
break;
#if MYSQL_VERSION_ID >= 40101
case MYSQL_SECURE_AUTH:
if (val == Qnil || val == Qfalse)
b = 1;
else
b = 0;
v = (char*)&b;
break;
#endif
#if MYSQL_VERSION_ID >= 32349
case MYSQL_OPT_LOCAL_INFILE:
if (val == Qnil || val == Qfalse)
v = NULL;
else {
n = 1;
v = (char*)&n;
}
break;
#endif
default:
v = NULL;
}
if (mysql_options(m, NUM2INT(opt), v) != 0)
rb_raise(eMysql, "unknown option: %d", NUM2INT(opt));
return obj;
}
|
#ping ⇒ Object
ping()
642 643 644 645 646 647 648 |
# File 'ext/mysql_api/mysql.c', line 642
static VALUE ping(VALUE obj)
{
MYSQL* m = GetHandler(obj);
if (mysql_ping(m) != 0)
mysql_raise(m);
return obj;
}
|
#prepare(query) ⇒ Object
prepare(query)
894 895 896 897 898 899 |
# File 'ext/mysql_api/mysql.c', line 894
static VALUE prepare(VALUE obj, VALUE query)
{
VALUE st;
st = stmt_init(obj);
return stmt_prepare(st, query);
}
|
#proto_info ⇒ Object
proto_info()
541 542 543 544 |
# File 'ext/mysql_api/mysql.c', line 541
static VALUE proto_info(VALUE obj)
{
return INT2NUM(mysql_get_proto_info(GetHandler(obj)));
}
|
#query(sql) ⇒ Object
query(sql)
731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 |
# File 'ext/mysql_api/mysql.c', line 731
static VALUE query(VALUE obj, VALUE sql)
{
int loop = 0;
MYSQL* m = GetHandler(obj);
Check_Type(sql, T_STRING);
if (GetMysqlStruct(obj)->connection == Qfalse) {
rb_raise(eMysql, "query: not connected");
}
if (rb_block_given_p()) {
if (mysql_real_query(m, RSTRING_PTR(sql), RSTRING_LEN(sql)) != 0)
mysql_raise(m);
do {
MYSQL_RES* res = mysql_store_result(m);
if (res == NULL) {
if (mysql_field_count(m) != 0)
mysql_raise(m);
} else {
VALUE robj = mysqlres2obj(res);
rb_ensure(rb_yield, robj, res_free, robj);
}
#if MYSQL_VERSION_ID >= 40101
if ((loop = mysql_next_result(m)) > 0)
mysql_raise(m);
} while (loop == 0);
#else
} while (0);
#endif
return obj;
}
|
#query_with_result ⇒ Object
query_with_result()
903 904 905 906 |
# File 'ext/mysql_api/mysql.c', line 903
static VALUE query_with_result(VALUE obj)
{
return GetMysqlStruct(obj)->query_with_result? Qtrue: Qfalse;
}
|
#query_with_result=(flag) ⇒ Object
query_with_result=(flag)
909 910 911 912 913 914 915 |
# File 'ext/mysql_api/mysql.c', line 909
static VALUE query_with_result_set(VALUE obj, VALUE flag)
{
if (TYPE(flag) != T_TRUE && TYPE(flag) != T_FALSE)
rb_raise(rb_eTypeError, "invalid type, required true or false.");
GetMysqlStruct(obj)->query_with_result = flag;
return flag;
}
|
#quote(str) ⇒ Object
escape_string(string)
428 429 430 431 432 433 434 435 436 |
# File 'ext/mysql_api/mysql.c', line 428
static VALUE real_escape_string(VALUE obj, VALUE str)
{
MYSQL* m = GetHandler(obj);
VALUE ret;
Check_Type(str, T_STRING);
ret = rb_str_new(0, (RSTRING_LEN(str))*2+1);
rb_str_set_len(ret, mysql_real_escape_string(m, RSTRING_PTR(ret), RSTRING_PTR(str), RSTRING_LEN(str)));
return ret;
}
|
#real_connect(*args) ⇒ Object
real_connect(host=nil, user=nil, passwd=nil, db=nil, port=nil, sock=nil, flag=nil)
323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 |
# File 'ext/mysql_api/mysql.c', line 323
static VALUE real_connect2(int argc, VALUE* argv, VALUE obj)
{
VALUE host, user, passwd, db, port, sock, flag;
char *h, *u, *p, *d, *s;
unsigned int pp, f;
MYSQL* m = GetHandler(obj);
rb_scan_args(argc, argv, "07", &host, &user, &passwd, &db, &port, &sock, &flag);
d = NILorSTRING(db);
f = NILorINT(flag);
h = NILorSTRING(host);
u = NILorSTRING(user);
p = NILorSTRING(passwd);
pp = NILorINT(port);
s = NILorSTRING(sock);
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_stop_timer();
#endif
if (mysql_real_connect(m, h, u, p, d, pp, s, f) == NULL) {
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_start_timer();
#endif
mysql_raise(m);
}
#ifdef HAVE_RB_THREAD_START_TIMER
rb_thread_start_timer();
#endif
m->reconnect = 0;
GetMysqlStruct(obj)->connection = Qtrue;
return obj;
}
|
#real_query(sql) ⇒ Object
query(sql)
731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 |
# File 'ext/mysql_api/mysql.c', line 731
static VALUE query(VALUE obj, VALUE sql)
{
int loop = 0;
MYSQL* m = GetHandler(obj);
Check_Type(sql, T_STRING);
if (GetMysqlStruct(obj)->connection == Qfalse) {
rb_raise(eMysql, "query: not connected");
}
if (rb_block_given_p()) {
if (mysql_real_query(m, RSTRING_PTR(sql), RSTRING_LEN(sql)) != 0)
mysql_raise(m);
do {
MYSQL_RES* res = mysql_store_result(m);
if (res == NULL) {
if (mysql_field_count(m) != 0)
mysql_raise(m);
} else {
VALUE robj = mysqlres2obj(res);
rb_ensure(rb_yield, robj, res_free, robj);
}
#if MYSQL_VERSION_ID >= 40101
if ((loop = mysql_next_result(m)) > 0)
mysql_raise(m);
} while (loop == 0);
#else
} while (0);
#endif
return obj;
}
|
#reconnect ⇒ Object
reconnect()
918 919 920 921 |
# File 'ext/mysql_api/mysql.c', line 918
static VALUE reconnect(VALUE obj)
{
return GetHandler(obj)->reconnect ? Qtrue : Qfalse;
}
|
#reconnect=(flag) ⇒ Object
reconnect=(flag)
924 925 926 927 928 |
# File 'ext/mysql_api/mysql.c', line 924
static VALUE reconnect_set(VALUE obj, VALUE flag)
{
GetHandler(obj)->reconnect = (flag == Qnil || flag == Qfalse) ? 0 : 1;
return flag;
}
|
#refresh(r) ⇒ Object
refresh®
651 652 653 654 655 656 657 |
# File 'ext/mysql_api/mysql.c', line 651
static VALUE refresh(VALUE obj, VALUE r)
{
MYSQL* m = GetHandler(obj);
if (mysql_refresh(m, NUM2INT(r)) != 0)
mysql_raise(m);
return obj;
}
|
#reload ⇒ Object
reload()
660 661 662 663 664 665 666 |
# File 'ext/mysql_api/mysql.c', line 660
static VALUE reload(VALUE obj)
{
MYSQL* m = GetHandler(obj);
if (mysql_reload(m) != 0)
mysql_raise(m);
return obj;
}
|
#rollback ⇒ Object
rollback()
792 793 794 795 796 797 798 |
# File 'ext/mysql_api/mysql.c', line 792
static VALUE rollback(VALUE obj)
{
MYSQL* m = GetHandler(obj);
if (mysql_rollback(m) != 0)
mysql_raise(m);
return obj;
}
|
#select_db(db) ⇒ Object
select_db(db)
669 670 671 672 673 674 675 |
# File 'ext/mysql_api/mysql.c', line 669
static VALUE select_db(VALUE obj, VALUE db)
{
MYSQL* m = GetHandler(obj);
if (mysql_select_db(m, StringValuePtr(db)) != 0)
mysql_raise(m);
return obj;
}
|
#server_info ⇒ Object
server_info()
547 548 549 550 |
# File 'ext/mysql_api/mysql.c', line 547
static VALUE server_info(VALUE obj)
{
return rb_tainted_str_new2(mysql_get_server_info(GetHandler(obj)));
}
|
#server_version ⇒ Object
server_version()
771 772 773 774 |
# File 'ext/mysql_api/mysql.c', line 771
static VALUE server_version(VALUE obj)
{
return INT2NUM(mysql_get_server_version(GetHandler(obj)));
}
|
#set_server_option(option) ⇒ Object
set_server_option(option)
855 856 857 858 859 860 861 |
# File 'ext/mysql_api/mysql.c', line 855
static VALUE set_server_option(VALUE obj, VALUE option)
{
MYSQL *m = GetHandler(obj);
if (mysql_set_server_option(m, NUM2INT(option)) != 0)
mysql_raise(m);
return obj;
}
|
#shutdown(*args) ⇒ Object
shutdown()
678 679 680 681 682 683 684 685 686 687 688 689 690 691 |
# File 'ext/mysql_api/mysql.c', line 678
static VALUE my_shutdown(int argc, VALUE* argv, VALUE obj)
{
MYSQL* m = GetHandler(obj);
VALUE level;
rb_scan_args(argc, argv, "01", &level);
#if MYSQL_VERSION_ID >= 40103
if (mysql_shutdown(m, NIL_P(level) ? SHUTDOWN_DEFAULT : NUM2INT(level)) != 0)
#else
if (mysql_shutdown(m) != 0)
#endif
mysql_raise(m);
return obj;
}
|
#sqlstate ⇒ Object
sqlstate()
864 865 866 867 868 |
# File 'ext/mysql_api/mysql.c', line 864
static VALUE sqlstate(VALUE obj)
{
MYSQL *m = GetHandler(obj);
return rb_tainted_str_new2(mysql_sqlstate(m));
}
|
#ssl_set(*args) ⇒ Object
ssl_set(key=nil, cert=nil, ca=nil, capath=nil, cipher=nil)
814 815 816 817 818 819 820 821 822 823 824 825 826 827 |
# File 'ext/mysql_api/mysql.c', line 814
static VALUE ssl_set(int argc, VALUE* argv, VALUE obj)
{
VALUE key, cert, ca, capath, cipher;
char *s_key, *s_cert, *s_ca, *s_capath, *s_cipher;
MYSQL* m = GetHandler(obj);
rb_scan_args(argc, argv, "05", &key, &cert, &ca, &capath, &cipher);
s_key = NILorSTRING(key);
s_cert = NILorSTRING(cert);
s_ca = NILorSTRING(ca);
s_capath = NILorSTRING(capath);
s_cipher = NILorSTRING(cipher);
mysql_ssl_set(m, s_key, s_cert, s_ca, s_capath, s_cipher);
return obj;
}
|
#stat ⇒ Object
stat()
694 695 696 697 698 699 700 701 |
# File 'ext/mysql_api/mysql.c', line 694
static VALUE my_stat(VALUE obj)
{
MYSQL* m = GetHandler(obj);
const char* s = mysql_stat(m);
if (s == NULL)
mysql_raise(m);
return rb_tainted_str_new2(s);
}
|
#stmt_init ⇒ Object
stmt_init()
873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 |
# File 'ext/mysql_api/mysql.c', line 873
static VALUE stmt_init(VALUE obj)
{
MYSQL *m = GetHandler(obj);
MYSQL_STMT *s;
struct mysql_stmt* stmt;
my_bool true = 1;
VALUE st_obj;
if ((s = mysql_stmt_init(m)) == NULL)
mysql_raise(m);
if (mysql_stmt_attr_set(s, STMT_ATTR_UPDATE_MAX_LENGTH, &true))
rb_raise(rb_eArgError, "mysql_stmt_attr_set() failed");
st_obj = Data_Make_Struct(cMysqlStmt, struct mysql_stmt, 0, free_mysqlstmt, stmt);
memset(stmt, 0, sizeof(*stmt));
stmt->stmt = s;
stmt->closed = Qfalse;
return st_obj;
}
|
#store_result ⇒ Object
store_result()
704 705 706 707 708 709 710 711 |
# File 'ext/mysql_api/mysql.c', line 704
static VALUE store_result(VALUE obj)
{
MYSQL* m = GetHandler(obj);
MYSQL_RES* res = mysql_store_result(m);
if (res == NULL)
mysql_raise(m);
return mysqlres2obj(res);
}
|
#thread_id ⇒ Object
thread_id()
714 715 716 717 |
# File 'ext/mysql_api/mysql.c', line 714
static VALUE thread_id(VALUE obj)
{
return INT2NUM(mysql_thread_id(GetHandler(obj)));
}
|
#use_result ⇒ Object
use_result()
720 721 722 723 724 725 726 727 |
# File 'ext/mysql_api/mysql.c', line 720
static VALUE use_result(VALUE obj)
{
MYSQL* m = GetHandler(obj);
MYSQL_RES* res = mysql_use_result(m);
if (res == NULL)
mysql_raise(m);
return mysqlres2obj(res);
}
|
#warning_count ⇒ Object
warning_count()
777 778 779 780 |
# File 'ext/mysql_api/mysql.c', line 777
static VALUE warning_count(VALUE obj)
{
return INT2NUM(mysql_warning_count(GetHandler(obj)));
}
|