HiveSQL for Ruby developers
@inertia is developing and maintaining a library for Ruby developers
Gem repository: https://github.com/inertia186/hive_sql
Installation
First, install ruby. One way to do this is install rvm. Once ruby is installed, install hive_sql
with the gem
command:
gem install hive_sql
Or, add it to your Gemfile
:
gem 'hive_sql'
How To Use (Standalone)
gem install hive_sql
export HIVESQL_HOST=<your hivesql host>
export HIVESQL_USERNAME=<your hivesql username>
export HIVESQL_PASSWORD=<your hivesql password>
hive_sql top upvoted
The above example will query the top upvoted content for the last 7 days.
Models
Account
Block
Transaction
various operations
Comment
Community
Role
Subscriber
Follower
Reblog
Tag
Token
Witness
Followers
How to query today's followers:
followers = HiveSQL::Tx::Custom::Follow
followers.following(:alice).today.count
Reblog
How to query today's reblogs:
reblogs = HiveSQL::Tx::Custom::Reblog
reblogs.author(:alice).today.count
Account Witness Proxy
How to query current accounts that are actively using a proxy:
proxied = HiveSQL::Tx::AccountWitnessProxy.active('alice')
proxied.pluck(:account)
Applications
How to query comments by application:
comments = HiveSQL::Comment.app('esteem').where(author: 'good-karma')
License
HiveSQL gem is licensed under a Creative Commons CC0 License.
Last updated