· 8 years ago · Apr 26, 2018, 05:06 PM
1#!/usr/bin/env ruby
2$:.unshift File.dirname(__FILE__) + '/../../lib/'
3require 'rubygems'
4require 'q4m'
5
6database = "test_q4m"
7table = "example_json_queue_monitor"
8sql = "CREATE TABLE IF NOT EXISTS #{table} (v TEXT NOT NULL) ENGINE=QUEUE;"
9
10begin
11 dbh = DBI.connect "DBI:Mysql:database=#{database}", "root", ""
12 dbh.do sql
13rescue
14 p "ERROR: #{$!}"
15end