rubyでSQLを書き換える

インストール

rubyとsql-parserをセットアップする

[vagrant@localhost ~]$ sudo yum install ruby-devel
[vagrant@localhost ~]$ sudo gem install sql-parser
[vagrant@localhost ~]$ irb

サンプルコード

SQLのfromを書き換える

irb(main):001:0> require 'sql-parser'
irb(main):002:0> parser = SQLParser::Parser.new
irb(main):003:0> ast = parser.scan_str('SELECT * FROM users WHERE id = 1')
irb(main):004:0> users = SQLParser::Statement::Table.new('users_001')
irb(main):005:0> from_clause = SQLParser::Statement::FromClause.new(users)
irb(main):006:0> where_clause = ast.query_expression.table_expression.where_clause
irb(main):007:0> table_expression = SQLParser::Statement::TableExpression.new(from_clause, where_clause)
irb(main):008:0> list = ast.query_expression.list
irb(main):009:0> select_statement = SQLParser::Statement::Select.new(list, table_expression)
irb(main):010:0> select_statement.to_sql
=> "SELECT * FROM `users_001` WHERE `id` = 1"

ライブラリ

• https://github.com/cryodex/sql-parser

参考

• rubyでSQL文をパースする

以上