# Sqlcomposer

Compose SQL from Mybatis log

## Installation

Install it yourself as:

    $ gem install sqlcomposer

Or:

    $ sudo gem install sqlcomposer

## Usage

Copy log content like this:

```
2019-05-10 10:27:22.023 [XNIO-2 task-3] DEBUG c.k.d.s.s.r.m.S.getPerson - ==>  Preparing: SELECT * FROM person where name = ? and age = ?
2019-05-10 10:27:22.025 [XNIO-2 task-3] DEBUG c.k.d.s.s.r.m.S.getPerson - ==> Parameters: 张三(String), 20(Integer)
```

then execute:

     $ pbpaste | sqlcomposer
     
will print out:

    SELECT * FROM person where name = '张三' and age = 20 ;

## Development

After checking out the repo, run `bin/setup` to install dependencies. Then, run `rake spec` to run the tests. You can also run `bin/console` for an interactive prompt that will allow you to experiment.

To install this gem onto your local machine, run `bundle exec rake install`. To release a new version, update the version number in `version.rb`, and then run `bundle exec rake release`, which will create a git tag for the version, push git commits and tags, and push the `.gem` file to [rubygems.org](https://rubygems.org).

## Contributing

Bug reports and pull requests are welcome on GitHub at https://github.com/lululau/sqlcomposer. This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the [Contributor Covenant](http://contributor-covenant.org) code of conduct.

## License

The gem is available as open source under the terms of the [MIT License](https://opensource.org/licenses/MIT).

## Code of Conduct

Everyone interacting in the Sqlcomposer project’s codebases, issue trackers, chat rooms and mailing lists is expected to follow the [code of conduct](https://github.com/lululau/sqlcomposer/blob/master/CODE_OF_CONDUCT.md).