Class: Mysql
- Inherits:
-
Object
- Object
- Mysql
- Defined in:
- ext/mysql.c
Defined Under Namespace
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()
464 465 466 467 |
# File 'ext/mysql.c', line 464
static VALUE initialize(int argc, VALUE* argv, VALUE obj)
{
return obj;
}
|
Class Method Details
.client_info ⇒ Object
client_info()
325 326 327 328 |
# File 'ext/mysql.c', line 325
static VALUE client_info(VALUE klass)
{
return rb_enc_tainted_str_new2(mysql_get_client_info());
}
|
.client_version ⇒ Object
client_version()
341 342 343 344 |
# File 'ext/mysql.c', line 341
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)
266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 |
# File 'ext/mysql.c', line 266
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);
rb_thread_stop_timer();
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
{
rb_thread_start_timer();
mysql_raise(&myp->handler);
}
rb_thread_start_timer();
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)
332 333 334 335 336 |
# File 'ext/mysql.c', line 332
static VALUE my_debug(VALUE obj, VALUE str)
{
mysql_debug(StringValuePtr(str));
return obj;
}
|
.escape_string(str) ⇒ Object
escape_string(string)
315 316 317 318 319 320 321 322 |
# File 'ext/mysql.c', line 315
static VALUE escape_string(VALUE klass, VALUE str)
{
VALUE ret;
Check_Type(str, T_STRING);
ret = rb_enc_str_new(0, (RSTRING_LEN(str))*2+1, DEFAULT_ENCODING);
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()
325 326 327 328 |
# File 'ext/mysql.c', line 325
static VALUE client_info(VALUE klass)
{
return rb_enc_tainted_str_new2(mysql_get_client_info());
}
|
.get_client_version ⇒ Object
client_version()
341 342 343 344 |
# File 'ext/mysql.c', line 341
static VALUE client_version(VALUE obj)
{
return INT2NUM(mysql_get_client_version());
}
|
.init ⇒ Object
init()
252 253 254 255 256 257 258 259 260 261 262 263 |
# File 'ext/mysql.c', line 252
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)
266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 |
# File 'ext/mysql.c', line 266
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);
rb_thread_stop_timer();
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
{
rb_thread_start_timer();
mysql_raise(&myp->handler);
}
rb_thread_start_timer();
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)
315 316 317 318 319 320 321 322 |
# File 'ext/mysql.c', line 315
static VALUE escape_string(VALUE klass, VALUE str)
{
VALUE ret;
Check_Type(str, T_STRING);
ret = rb_enc_str_new(0, (RSTRING_LEN(str))*2+1, DEFAULT_ENCODING);
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)
266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 |
# File 'ext/mysql.c', line 266
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);
rb_thread_stop_timer();
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
{
rb_thread_start_timer();
mysql_raise(&myp->handler);
}
rb_thread_start_timer();
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()
470 471 472 473 |
# File 'ext/mysql.c', line 470
static VALUE affected_rows(VALUE obj)
{
return INT2NUM(mysql_affected_rows(GetHandler(obj)));
}
|
#autocommit(mode) ⇒ Object
autocommit()
825 826 827 828 829 830 831 832 833 |
# File 'ext/mysql.c', line 825
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)
477 478 479 480 481 482 483 484 485 486 487 488 489 |
# File 'ext/mysql.c', line 477
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()
494 495 496 497 |
# File 'ext/mysql.c', line 494
static VALUE character_set_name(VALUE obj)
{
return rb_enc_tainted_str_new2(mysql_character_set_name(GetHandler(obj)));
}
|
#client_info ⇒ Object
client_info()
325 326 327 328 |
# File 'ext/mysql.c', line 325
static VALUE client_info(VALUE klass)
{
return rb_enc_tainted_str_new2(mysql_get_client_info());
}
|
#client_version ⇒ Object
client_version()
341 342 343 344 |
# File 'ext/mysql.c', line 341
static VALUE client_version(VALUE obj)
{
return INT2NUM(mysql_get_client_version());
}
|
#close ⇒ Object
close()
501 502 503 504 505 506 507 |
# File 'ext/mysql.c', line 501
static VALUE my_close(VALUE obj)
{
MYSQL* m = GetHandler(obj);
mysql_close(m);
GetMysqlStruct(obj)->connection = Qfalse;
return obj;
}
|
#commit ⇒ Object
commit()
807 808 809 810 811 812 813 |
# File 'ext/mysql.c', line 807
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)
353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 |
# File 'ext/mysql.c', line 353
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);
rb_thread_stop_timer();
if (mysql_real_connect(m, h, u, p, d, pp, s, f) == NULL) {
rb_thread_start_timer();
mysql_raise(m);
}
rb_thread_start_timer();
m->reconnect = 0;
GetMysqlStruct(obj)->connection = Qtrue;
return obj;
}
|
#create_db(db) ⇒ Object
create_db(db)
511 512 513 514 515 516 517 |
# File 'ext/mysql.c', line 511
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)
520 521 522 523 524 525 526 |
# File 'ext/mysql.c', line 520
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()
531 532 533 534 535 536 537 |
# File 'ext/mysql.c', line 531
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()
541 542 543 544 |
# File 'ext/mysql.c', line 541
static VALUE my_errno(VALUE obj)
{
return INT2NUM(mysql_errno(GetHandler(obj)));
}
|
#error ⇒ Object
error()
547 548 549 550 |
# File 'ext/mysql.c', line 547
static VALUE my_error(VALUE obj)
{
return rb_str_new2(mysql_error(GetHandler(obj)));
}
|
#escape_string(str) ⇒ Object
escape_string(string)
452 453 454 455 456 457 458 459 460 |
# File 'ext/mysql.c', line 452
static VALUE real_escape_string(VALUE obj, VALUE str)
{
MYSQL* m = GetHandler(obj);
VALUE ret;
Check_Type(str, T_STRING);
ret = rb_enc_str_new(0, (RSTRING_LEN(str))*2+1, DEFAULT_ENCODING);
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()
553 554 555 556 |
# File 'ext/mysql.c', line 553
static VALUE field_count(VALUE obj)
{
return INT2NUM(mysql_field_count(GetHandler(obj)));
}
|
#get_client_info ⇒ Object
client_info()
325 326 327 328 |
# File 'ext/mysql.c', line 325
static VALUE client_info(VALUE klass)
{
return rb_enc_tainted_str_new2(mysql_get_client_info());
}
|
#get_client_version ⇒ Object
client_version()
341 342 343 344 |
# File 'ext/mysql.c', line 341
static VALUE client_version(VALUE obj)
{
return INT2NUM(mysql_get_client_version());
}
|
#get_host_info ⇒ Object
host_info()
559 560 561 562 |
# File 'ext/mysql.c', line 559
static VALUE host_info(VALUE obj)
{
return rb_enc_tainted_str_new2(mysql_get_host_info(GetHandler(obj)));
}
|
#get_proto_info ⇒ Object
proto_info()
565 566 567 568 |
# File 'ext/mysql.c', line 565
static VALUE proto_info(VALUE obj)
{
return INT2NUM(mysql_get_proto_info(GetHandler(obj)));
}
|
#get_server_info ⇒ Object
server_info()
571 572 573 574 |
# File 'ext/mysql.c', line 571
static VALUE server_info(VALUE obj)
{
return rb_enc_tainted_str_new2(mysql_get_server_info(GetHandler(obj)));
}
|
#get_server_version ⇒ Object
server_version()
795 796 797 798 |
# File 'ext/mysql.c', line 795
static VALUE server_version(VALUE obj)
{
return INT2NUM(mysql_get_server_version(GetHandler(obj)));
}
|
#host_info ⇒ Object
host_info()
559 560 561 562 |
# File 'ext/mysql.c', line 559
static VALUE host_info(VALUE obj)
{
return rb_enc_tainted_str_new2(mysql_get_host_info(GetHandler(obj)));
}
|
#info ⇒ Object
info()
577 578 579 580 581 |
# File 'ext/mysql.c', line 577
static VALUE info(VALUE obj)
{
const char* p = mysql_info(GetHandler(obj));
return p? rb_enc_tainted_str_new2(p): Qnil;
}
|
#insert_id ⇒ Object
insert_id()
584 585 586 587 |
# File 'ext/mysql.c', line 584
static VALUE insert_id(VALUE obj)
{
return INT2NUM(mysql_insert_id(GetHandler(obj)));
}
|
#kill(pid) ⇒ Object
kill(pid)
590 591 592 593 594 595 596 597 |
# File 'ext/mysql.c', line 590
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)
600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 |
# File 'ext/mysql.c', line 600
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_enc_tainted_str_new2(mysql_fetch_row(res)[0]));
mysql_free_result(res);
return ret;
}
|
#list_fields(*args) ⇒ Object
list_fields(table, field=nil)
621 622 623 624 625 626 627 628 629 630 631 |
# File 'ext/mysql.c', line 621
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()
634 635 636 637 638 639 640 641 |
# File 'ext/mysql.c', line 634
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)
644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 |
# File 'ext/mysql.c', line 644
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_enc_tainted_str_new2(mysql_fetch_row(res)[0]));
mysql_free_result(res);
return ret;
}
|
#more_results ⇒ Object
more_results()
856 857 858 859 860 861 862 |
# File 'ext/mysql.c', line 856
static VALUE more_results(VALUE obj)
{
if (mysql_more_results(GetHandler(obj)) == 0)
return Qfalse;
else
return Qtrue;
}
|
#more_results? ⇒ Boolean
more_results()
856 857 858 859 860 861 862 |
# File 'ext/mysql.c', line 856
static VALUE more_results(VALUE obj)
{
if (mysql_more_results(GetHandler(obj)) == 0)
return Qfalse;
else
return Qtrue;
}
|
#next_result ⇒ Object
864 865 866 867 868 869 870 871 872 873 874 |
# File 'ext/mysql.c', line 864
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)
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 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 |
# File 'ext/mysql.c', line 381
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()
666 667 668 669 670 671 672 |
# File 'ext/mysql.c', line 666
static VALUE ping(VALUE obj)
{
MYSQL* m = GetHandler(obj);
if (mysql_ping(m) != 0)
mysql_raise(m);
return obj;
}
|
#prepare(query) ⇒ Object
prepare(query)
918 919 920 921 922 923 |
# File 'ext/mysql.c', line 918
static VALUE prepare(VALUE obj, VALUE query)
{
VALUE st;
st = stmt_init(obj);
return stmt_prepare(st, query);
}
|
#proto_info ⇒ Object
proto_info()
565 566 567 568 |
# File 'ext/mysql.c', line 565
static VALUE proto_info(VALUE obj)
{
return INT2NUM(mysql_get_proto_info(GetHandler(obj)));
}
|
#query(sql) ⇒ Object
query(sql)
755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 |
# File 'ext/mysql.c', line 755
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()
927 928 929 930 |
# File 'ext/mysql.c', line 927
static VALUE query_with_result(VALUE obj)
{
return GetMysqlStruct(obj)->query_with_result? Qtrue: Qfalse;
}
|
#query_with_result=(flag) ⇒ Object
query_with_result=(flag)
933 934 935 936 937 938 939 |
# File 'ext/mysql.c', line 933
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)
452 453 454 455 456 457 458 459 460 |
# File 'ext/mysql.c', line 452
static VALUE real_escape_string(VALUE obj, VALUE str)
{
MYSQL* m = GetHandler(obj);
VALUE ret;
Check_Type(str, T_STRING);
ret = rb_enc_str_new(0, (RSTRING_LEN(str))*2+1, DEFAULT_ENCODING);
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)
353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 |
# File 'ext/mysql.c', line 353
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);
rb_thread_stop_timer();
if (mysql_real_connect(m, h, u, p, d, pp, s, f) == NULL) {
rb_thread_start_timer();
mysql_raise(m);
}
rb_thread_start_timer();
m->reconnect = 0;
GetMysqlStruct(obj)->connection = Qtrue;
return obj;
}
|
#real_query(sql) ⇒ Object
query(sql)
755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 |
# File 'ext/mysql.c', line 755
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()
942 943 944 945 |
# File 'ext/mysql.c', line 942
static VALUE reconnect(VALUE obj)
{
return GetHandler(obj)->reconnect ? Qtrue : Qfalse;
}
|
#reconnect=(flag) ⇒ Object
reconnect=(flag)
948 949 950 951 952 |
# File 'ext/mysql.c', line 948
static VALUE reconnect_set(VALUE obj, VALUE flag)
{
GetHandler(obj)->reconnect = (flag == Qnil || flag == Qfalse) ? 0 : 1;
return flag;
}
|
#refresh(r) ⇒ Object
refresh®
675 676 677 678 679 680 681 |
# File 'ext/mysql.c', line 675
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()
684 685 686 687 688 689 690 |
# File 'ext/mysql.c', line 684
static VALUE reload(VALUE obj)
{
MYSQL* m = GetHandler(obj);
if (mysql_reload(m) != 0)
mysql_raise(m);
return obj;
}
|
#rollback ⇒ Object
rollback()
816 817 818 819 820 821 822 |
# File 'ext/mysql.c', line 816
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)
693 694 695 696 697 698 699 |
# File 'ext/mysql.c', line 693
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()
571 572 573 574 |
# File 'ext/mysql.c', line 571
static VALUE server_info(VALUE obj)
{
return rb_enc_tainted_str_new2(mysql_get_server_info(GetHandler(obj)));
}
|
#server_version ⇒ Object
server_version()
795 796 797 798 |
# File 'ext/mysql.c', line 795
static VALUE server_version(VALUE obj)
{
return INT2NUM(mysql_get_server_version(GetHandler(obj)));
}
|
#set_server_option(option) ⇒ Object
set_server_option(option)
879 880 881 882 883 884 885 |
# File 'ext/mysql.c', line 879
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()
702 703 704 705 706 707 708 709 710 711 712 713 714 715 |
# File 'ext/mysql.c', line 702
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()
888 889 890 891 892 |
# File 'ext/mysql.c', line 888
static VALUE sqlstate(VALUE obj)
{
MYSQL *m = GetHandler(obj);
return rb_enc_tainted_str_new2(mysql_sqlstate(m));
}
|
#ssl_set(*args) ⇒ Object
ssl_set(key=nil, cert=nil, ca=nil, capath=nil, cipher=nil)
838 839 840 841 842 843 844 845 846 847 848 849 850 851 |
# File 'ext/mysql.c', line 838
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()
718 719 720 721 722 723 724 725 |
# File 'ext/mysql.c', line 718
static VALUE my_stat(VALUE obj)
{
MYSQL* m = GetHandler(obj);
const char* s = mysql_stat(m);
if (s == NULL)
mysql_raise(m);
return rb_enc_tainted_str_new2(s);
}
|
#stmt_init ⇒ Object
stmt_init()
897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 |
# File 'ext/mysql.c', line 897
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()
728 729 730 731 732 733 734 735 |
# File 'ext/mysql.c', line 728
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()
738 739 740 741 |
# File 'ext/mysql.c', line 738
static VALUE thread_id(VALUE obj)
{
return INT2NUM(mysql_thread_id(GetHandler(obj)));
}
|
#use_result ⇒ Object
use_result()
744 745 746 747 748 749 750 751 |
# File 'ext/mysql.c', line 744
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()
801 802 803 804 |
# File 'ext/mysql.c', line 801
static VALUE warning_count(VALUE obj)
{
return INT2NUM(mysql_warning_count(GetHandler(obj)));
}
|