Dateslices
This project rocks and uses MIT-LICENSE.
This project is based upon groupdate and follows a similar API.
The differences between the groupdate and dateslices are:
- dateslices supports sqlite3in addition to PostgreSQL & MySQL.
- dateslices has much less functionality.
- dateslices ignores timezones.
- dateslices is rails 4 only.
- dateslices uses rspecs for tests.
The reason that I wrote this is that I use sqlite in development, and wanted to make sure that I could test things locally. I didn't understand the test suite of groupdate, so I ended up rewriting it.
Walkthrough
A walkthrough of how this code is written is available on my blog
Usage instructions below.
Example Usage
User.where( :created_at > 1.month.ago ).group_by_day
Summing up a column
User.group_by_day( :created_at, "sum", "karma" )
Averaging a column
Post.group_by_week( :updated_at, "avg", "comment_count")
All find methods
These methods take three optional arguments:
- column to group by, normally "created_at"
- sql function to run, normally "count". Also "sum", "avg"
- column to do the function on, normally "*"
-
group_by_second
-
group_by_minute
-
group_by_hour
-
group_by_day
-
group_by_week
-
group_by_month
-
group_by_year
-
group_by_hour_of_day
-
group_by_day_of_week
-
group_by_day_of_month
-
group_by_month_of_year
Configuration
The output format defaults to a Chartkick compatible hash of dates and values.
If you wish to use the dateslices format, please add Dateslices.output_format = :dateslices to an initializer.
Tests
Rspec tests need to be run out of the spec/dummy directory, and you'll need to have a postgres and a mysql database named "dateslice_test" for them to succeed.