#!/usr/bin/env ruby

require 'mysql2'
require 'ap'

client = Mysql2::Client.new(
  :username => 'injekt',
  :password => 'foo',
  :database => 'test_one'
)

queries = DATA.read.split("\n\n")

queries.each do |query|
  client.query query
end

client.query("SELECT *, INET_NTOA(`addr`) AS `ip` FROM `users` LIMIT 1").each do |user|
  ap user
end

__END__
DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id`          INT NOT NULL AUTO_INCREMENT,
  `name`        VARCHAR(15) NOT NULL,
  `password`    VARCHAR(32) NOT NULL,
  `addr`        INT(10) NOT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `users`
  (`name`, `password`, `addr`)
VALUES
  ('injekt', md5('bar'), INET_ATON('127.0.0.1'));