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()
438 439 440 441 |
# File 'ext/mysql.c', line 438
static VALUE initialize(int argc, VALUE* argv, VALUE obj)
{
return obj;
}
|
Class Method Details
.client_info ⇒ Object
client_info()
299 300 301 302 |
# File 'ext/mysql.c', line 299
static VALUE client_info(VALUE klass)
{
return rb_tainted_str_new2(mysql_get_client_info());
}
|
.client_version ⇒ Object
client_version()
315 316 317 318 |
# File 'ext/mysql.c', line 315
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)
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 283 284 285 286 |
# File 'ext/mysql.c', line 240
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)
306 307 308 309 310 |
# File 'ext/mysql.c', line 306
static VALUE my_debug(VALUE obj, VALUE str)
{
mysql_debug(StringValuePtr(str));
return obj;
}
|
.escape_string(str) ⇒ Object
escape_string(string)
289 290 291 292 293 294 295 296 |
# File 'ext/mysql.c', line 289
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()
299 300 301 302 |
# File 'ext/mysql.c', line 299
static VALUE client_info(VALUE klass)
{
return rb_tainted_str_new2(mysql_get_client_info());
}
|
.get_client_version ⇒ Object
client_version()
315 316 317 318 |
# File 'ext/mysql.c', line 315
static VALUE client_version(VALUE obj)
{
return INT2NUM(mysql_get_client_version());
}
|
.init ⇒ Object
init()
226 227 228 229 230 231 232 233 234 235 236 237 |
# File 'ext/mysql.c', line 226
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)
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 283 284 285 286 |
# File 'ext/mysql.c', line 240
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)
289 290 291 292 293 294 295 296 |
# File 'ext/mysql.c', line 289
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)
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 283 284 285 286 |
# File 'ext/mysql.c', line 240
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()
444 445 446 447 |
# File 'ext/mysql.c', line 444
static VALUE affected_rows(VALUE obj)
{
return INT2NUM(mysql_affected_rows(GetHandler(obj)));
}
|
#autocommit(mode) ⇒ Object
autocommit()
799 800 801 802 803 804 805 806 807 |
# File 'ext/mysql.c', line 799
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)
451 452 453 454 455 456 457 458 459 460 461 462 463 |
# File 'ext/mysql.c', line 451
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()
468 469 470 471 |
# File 'ext/mysql.c', line 468
static VALUE character_set_name(VALUE obj)
{
return rb_tainted_str_new2(mysql_character_set_name(GetHandler(obj)));
}
|
#client_info ⇒ Object
client_info()
299 300 301 302 |
# File 'ext/mysql.c', line 299
static VALUE client_info(VALUE klass)
{
return rb_tainted_str_new2(mysql_get_client_info());
}
|
#client_version ⇒ Object
client_version()
315 316 317 318 |
# File 'ext/mysql.c', line 315
static VALUE client_version(VALUE obj)
{
return INT2NUM(mysql_get_client_version());
}
|
#close ⇒ Object
close()
475 476 477 478 479 480 481 |
# File 'ext/mysql.c', line 475
static VALUE my_close(VALUE obj)
{
MYSQL* m = GetHandler(obj);
mysql_close(m);
GetMysqlStruct(obj)->connection = Qfalse;
return obj;
}
|
#commit ⇒ Object
commit()
781 782 783 784 785 786 787 |
# File 'ext/mysql.c', line 781
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)
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 |
# File 'ext/mysql.c', line 327
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)
485 486 487 488 489 490 491 |
# File 'ext/mysql.c', line 485
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)
494 495 496 497 498 499 500 |
# File 'ext/mysql.c', line 494
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()
505 506 507 508 509 510 511 |
# File 'ext/mysql.c', line 505
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()
515 516 517 518 |
# File 'ext/mysql.c', line 515
static VALUE my_errno(VALUE obj)
{
return INT2NUM(mysql_errno(GetHandler(obj)));
}
|
#error ⇒ Object
error()
521 522 523 524 |
# File 'ext/mysql.c', line 521
static VALUE my_error(VALUE obj)
{
return rb_str_new2(mysql_error(GetHandler(obj)));
}
|
#escape_string(str) ⇒ Object
escape_string(string)
426 427 428 429 430 431 432 433 434 |
# File 'ext/mysql.c', line 426
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()
527 528 529 530 |
# File 'ext/mysql.c', line 527
static VALUE field_count(VALUE obj)
{
return INT2NUM(mysql_field_count(GetHandler(obj)));
}
|
#get_client_info ⇒ Object
client_info()
299 300 301 302 |
# File 'ext/mysql.c', line 299
static VALUE client_info(VALUE klass)
{
return rb_tainted_str_new2(mysql_get_client_info());
}
|
#get_client_version ⇒ Object
client_version()
315 316 317 318 |
# File 'ext/mysql.c', line 315
static VALUE client_version(VALUE obj)
{
return INT2NUM(mysql_get_client_version());
}
|
#get_host_info ⇒ Object
host_info()
533 534 535 536 |
# File 'ext/mysql.c', line 533
static VALUE host_info(VALUE obj)
{
return rb_tainted_str_new2(mysql_get_host_info(GetHandler(obj)));
}
|
#get_proto_info ⇒ Object
proto_info()
539 540 541 542 |
# File 'ext/mysql.c', line 539
static VALUE proto_info(VALUE obj)
{
return INT2NUM(mysql_get_proto_info(GetHandler(obj)));
}
|
#get_server_info ⇒ Object
server_info()
545 546 547 548 |
# File 'ext/mysql.c', line 545
static VALUE server_info(VALUE obj)
{
return rb_tainted_str_new2(mysql_get_server_info(GetHandler(obj)));
}
|
#get_server_version ⇒ Object
server_version()
769 770 771 772 |
# File 'ext/mysql.c', line 769
static VALUE server_version(VALUE obj)
{
return INT2NUM(mysql_get_server_version(GetHandler(obj)));
}
|
#host_info ⇒ Object
host_info()
533 534 535 536 |
# File 'ext/mysql.c', line 533
static VALUE host_info(VALUE obj)
{
return rb_tainted_str_new2(mysql_get_host_info(GetHandler(obj)));
}
|
#info ⇒ Object
info()
551 552 553 554 555 |
# File 'ext/mysql.c', line 551
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()
558 559 560 561 |
# File 'ext/mysql.c', line 558
static VALUE insert_id(VALUE obj)
{
return INT2NUM(mysql_insert_id(GetHandler(obj)));
}
|
#kill(pid) ⇒ Object
kill(pid)
564 565 566 567 568 569 570 571 |
# File 'ext/mysql.c', line 564
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)
574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 |
# File 'ext/mysql.c', line 574
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)
595 596 597 598 599 600 601 602 603 604 605 |
# File 'ext/mysql.c', line 595
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()
608 609 610 611 612 613 614 615 |
# File 'ext/mysql.c', line 608
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)
618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 |
# File 'ext/mysql.c', line 618
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()
830 831 832 833 834 835 836 |
# File 'ext/mysql.c', line 830
static VALUE more_results(VALUE obj)
{
if (mysql_more_results(GetHandler(obj)) == 0)
return Qfalse;
else
return Qtrue;
}
|
#more_results? ⇒ Boolean
more_results()
830 831 832 833 834 835 836 |
# File 'ext/mysql.c', line 830
static VALUE more_results(VALUE obj)
{
if (mysql_more_results(GetHandler(obj)) == 0)
return Qfalse;
else
return Qtrue;
}
|
#next_result ⇒ Object
838 839 840 841 842 843 844 845 846 847 848 |
# File 'ext/mysql.c', line 838
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)
355 356 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 |
# File 'ext/mysql.c', line 355
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()
640 641 642 643 644 645 646 |
# File 'ext/mysql.c', line 640
static VALUE ping(VALUE obj)
{
MYSQL* m = GetHandler(obj);
if (mysql_ping(m) != 0)
mysql_raise(m);
return obj;
}
|
#prepare(query) ⇒ Object
prepare(query)
892 893 894 895 896 897 |
# File 'ext/mysql.c', line 892
static VALUE prepare(VALUE obj, VALUE query)
{
VALUE st;
st = stmt_init(obj);
return stmt_prepare(st, query);
}
|
#proto_info ⇒ Object
proto_info()
539 540 541 542 |
# File 'ext/mysql.c', line 539
static VALUE proto_info(VALUE obj)
{
return INT2NUM(mysql_get_proto_info(GetHandler(obj)));
}
|
#query(sql) ⇒ Object
query(sql)
729 730 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 |
# File 'ext/mysql.c', line 729
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()
901 902 903 904 |
# File 'ext/mysql.c', line 901
static VALUE query_with_result(VALUE obj)
{
return GetMysqlStruct(obj)->query_with_result? Qtrue: Qfalse;
}
|
#query_with_result=(flag) ⇒ Object
query_with_result=(flag)
907 908 909 910 911 912 913 |
# File 'ext/mysql.c', line 907
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)
426 427 428 429 430 431 432 433 434 |
# File 'ext/mysql.c', line 426
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)
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 |
# File 'ext/mysql.c', line 327
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)
729 730 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 |
# File 'ext/mysql.c', line 729
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()
916 917 918 919 |
# File 'ext/mysql.c', line 916
static VALUE reconnect(VALUE obj)
{
return GetHandler(obj)->reconnect ? Qtrue : Qfalse;
}
|
#reconnect=(flag) ⇒ Object
reconnect=(flag)
922 923 924 925 926 |
# File 'ext/mysql.c', line 922
static VALUE reconnect_set(VALUE obj, VALUE flag)
{
GetHandler(obj)->reconnect = (flag == Qnil || flag == Qfalse) ? 0 : 1;
return flag;
}
|
#refresh(r) ⇒ Object
refresh®
649 650 651 652 653 654 655 |
# File 'ext/mysql.c', line 649
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()
658 659 660 661 662 663 664 |
# File 'ext/mysql.c', line 658
static VALUE reload(VALUE obj)
{
MYSQL* m = GetHandler(obj);
if (mysql_reload(m) != 0)
mysql_raise(m);
return obj;
}
|
#rollback ⇒ Object
rollback()
790 791 792 793 794 795 796 |
# File 'ext/mysql.c', line 790
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)
667 668 669 670 671 672 673 |
# File 'ext/mysql.c', line 667
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()
545 546 547 548 |
# File 'ext/mysql.c', line 545
static VALUE server_info(VALUE obj)
{
return rb_tainted_str_new2(mysql_get_server_info(GetHandler(obj)));
}
|
#server_version ⇒ Object
server_version()
769 770 771 772 |
# File 'ext/mysql.c', line 769
static VALUE server_version(VALUE obj)
{
return INT2NUM(mysql_get_server_version(GetHandler(obj)));
}
|
#set_server_option(option) ⇒ Object
set_server_option(option)
853 854 855 856 857 858 859 |
# File 'ext/mysql.c', line 853
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()
676 677 678 679 680 681 682 683 684 685 686 687 688 689 |
# File 'ext/mysql.c', line 676
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()
862 863 864 865 866 |
# File 'ext/mysql.c', line 862
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)
812 813 814 815 816 817 818 819 820 821 822 823 824 825 |
# File 'ext/mysql.c', line 812
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()
692 693 694 695 696 697 698 699 |
# File 'ext/mysql.c', line 692
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()
871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 |
# File 'ext/mysql.c', line 871
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()
702 703 704 705 706 707 708 709 |
# File 'ext/mysql.c', line 702
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()
712 713 714 715 |
# File 'ext/mysql.c', line 712
static VALUE thread_id(VALUE obj)
{
return INT2NUM(mysql_thread_id(GetHandler(obj)));
}
|
#use_result ⇒ Object
use_result()
718 719 720 721 722 723 724 725 |
# File 'ext/mysql.c', line 718
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()
775 776 777 778 |
# File 'ext/mysql.c', line 775
static VALUE warning_count(VALUE obj)
{
return INT2NUM(mysql_warning_count(GetHandler(obj)));
}
|