bjc3SZSS

1#!/usr/bin/env ruby
2
3require 'mysql2'
4require 'ap'
5
6client = Mysql2::Client.new(
7  :username => 'injekt',
8  :password => 'foo',
9  :database => 'test_one'
10)
11
12queries = DATA.read.split("\n\n")
13
14queries.each do |query|
15  client.query query
16end
17
18client.query("SELECT *, INET_NTOA(`addr`) AS `ip` FROM `users` LIMIT 1").each do |user|
19  ap user
20end
21
22__END__
23DROP TABLE IF EXISTS `users`;
24
25CREATE TABLE `users` (
26  `id`          INT NOT NULL AUTO_INCREMENT,
27  `name`        VARCHAR(15) NOT NULL,
28  `password`    VARCHAR(32) NOT NULL,
29  `addr`        INT(10) NOT NULL,
30  PRIMARY KEY (`id`)
31);
32
33INSERT INTO `users`
34  (`name`, `password`, `addr`) 
35VALUES  
36  ('injekt', md5('bar'), INET_ATON('127.0.0.1'));