备忘－ruby (mysql)

最新推荐文章于 2025-09-11 20:53:34 发布

weixin_33941350

最新推荐文章于 2025-09-11 20:53:34 发布

阅读量72

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 ruby

原文链接：http://www.cnblogs.com/mover/p/3527361.html

本文介绍了一个使用Ruby脚本连接MySQL数据库的方法，并演示了如何执行包括删除和查询在内的多种SQL语句。脚本中定义了数据库连接参数，并通过Mysql2 gem实现了与MySQL的交互。

##############################################################
# Copyright (C), 2013-2014.
#  File name: connect-mysql  
#     Author: cy        
#    Version: 1.0.0      
#       Date: 20140120
# Description: connect mysql 
###############################################################

#!/usr/bin/env ruby 

require 'mysql2'

mysql_host = "drhel35.com"
mysql_username = "root"
mysql_passwd = "xxxxxx.1"
mysql_db = "sysadmin"

delete_user_s1 = 'delete from user_preference where user_id = "#{user_id}"'
delete_user_s2 = 'delete from party_user_mapping where user_id = "#{user_id}"'
delete_user_s3 = 'delete from register_user where username= "#{username}"'
select_user = 'select * from register_user where username = "#{username}"'

connect = Mysql2::Client.new(:host=>"#{mysql_host}", :username=>"#{mysql_username}",:password=>"#{mysql_passwd}",:database=>"#{mysql_db}")
connect.query(delete_user_s1)
connect.query(delete_user_s2)
connect.query(delete_user_s3)
connect.query(select_user)