Ruboty::Sql
Sql handler for Ruboty.
Installation
Add this line to your application's Gemfile:
gem 'ruboty-sql'
gem 'sqlite3' # Your database libraryAnd then execute:
$ bundle
Usage
> ruboty sql select * from incenses;
+----------------------------+----+--------+----------------------------+---------+
| created_at | id | source | updated_at | user_id |
+----------------------------+----+--------+----------------------------+---------+
| 2015-03-02 20:48:36.990325 | 1 | | 2015-03-02 20:48:36.990325 | 1 |
| 2015-03-03 18:49:27.894872 | 2 | | 2015-03-03 18:49:27.894872 | 2 |
| 2015-03-07 16:19:12.756657 | 3 | | 2015-03-07 16:19:12.756657 | 1 |
| 2015-03-10 11:11:38.409086 | 4 | api | 2015-03-10 11:11:38.409086 | 1 |
+----------------------------+----+--------+----------------------------+---------+
4 rows in set
ENV
like rails's database.yml.
add prefix RUBOTY_SQL_
adapter => RUBOTY_SQL_ADAPTER
username => RUBOTY_SQL_USERNAME
security (strongly recommended)
Create readonly user.
example for sqlite3
RUBOTY_SQL_ADAPTER=sqlite3
RUBOTY_SQL_DATABASE=/path/to/sqlite3.db
Contributing
- Fork it ( https://github.com/yoshiori/ruboty-sql/fork )
- Create your feature branch (
git checkout -b my-new-feature) - Commit your changes (
git commit -am 'Add some feature') - Push to the branch (
git push origin my-new-feature) - Create a new Pull Request