Skip to content
Branch: master
Go to file
Code

Latest commit

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
src
 
 
 
 
 
 
 
 

README.md

mruby-mysql

mruby-mysql is a mrbgems. It provide an interface to mysql with mruby.

install

When you use in your project, please add below to your build_config.rb.

conf.gem :github => 'mattn/mruby-mysql'

Description

# Creates a new handle for accessing a mysql database
db = MySQL::Database.new('db_host', 'db_user', 'password', 'db_name')

you must supply 4 parameters.

Usage

execute_batch

db.execute_batch 'create table foo(id int primary key, text text, f float)'
db.execute_batch('insert into foo(id, text) values(?, ?)', 1, 'foo')

when you want to use create table, drop table, insert, update, delete queries, you need to use execute_batch method.

execute

when you want to use select query, you need to use execute method.

db.execute('select * from foo') do |row, fields|
  puts fields # ["id", "text", "f"]
  puts row # [1, "foo", nil]
end
row = db.execute('select * from foo')
while cols = row.next
  puts cols # [1, "foo", nil]
end
row.close

transaction

This library supports transactions.

# rollback
db.transaction
db.execute_batch('insert into foo(id, text) values(?, ?)', 2, 'baz')
db.rollback
# commit
db.transaction
db.execute_batch('insert into foo(id, text) values(?, ?)', 2, 'baz')
db.commit

License

This project is under the MIT License:

Author

Yasuhiro Matsumoto (a.k.a. mattn)

About

No description, website, or topics provided.

Resources

License

Releases

No releases published

Sponsor this project

 
Learn more about GitHub Sponsors

Contributors 4

  •  
  •  
  •  
  •  
You can’t perform that action at this time.