Last active
May 29, 2020 17:30
-
-
Save theotherzach/5130140 to your computer and use it in GitHub Desktop.
Rails 4 and Postgres: Getting HStore and Array
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
class AddHstoreExtension < ActiveRecord::Migration | |
def up | |
execute 'CREATE EXTENSION hstore' | |
end | |
def down | |
execute 'DROP EXTENSION hstore' | |
end | |
end |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
class CreateDueDates < ActiveRecord::Migration | |
def change | |
create_table :due_dates do |t| | |
t.string :name | |
t.text :description | |
t.date :start | |
t.string :tags, array: true | |
t.hstore :recur | |
t.timestamps | |
end | |
end | |
end |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<div class="field"> | |
<%= f.label :tags %><br /> | |
<%= f.collection_check_boxes :tags, %w[CAT Payroll Sales School City State Federal], :to_s, :to_s %> | |
</div> | |
<div class="field"> | |
<%= f.label :frequency %><br /> | |
<%= f.collection_select :frequency, %w[Daily Weekly Monthly Quarterly Annualy], :to_s, :to_s %> | |
</div> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
class DueDate < ActiveRecord::Base | |
store_accessor :recur, :frequency | |
store_accessor :recur, :day_of_week | |
store_accessor :recur, :day_of_month | |
end |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
class DueDatesController < ApplicationController | |
before_action :set_due_date, only: [:show, :edit, :update, :destroy] | |
def index | |
@due_dates = DueDate.all | |
end | |
def show | |
end | |
def new | |
@due_date = DueDate.new | |
end | |
def edit | |
end | |
def create | |
@due_date = DueDate.new(due_date_params) | |
respond_to do |format| | |
if @due_date.save | |
format.html { redirect_to @due_date, notice: 'Due date was successfully created.' } | |
format.json { render action: 'show', status: :created, location: @due_date } | |
else | |
format.html { render action: 'new' } | |
format.json { render json: @due_date.errors, status: :unprocessable_entity } | |
end | |
end | |
end | |
def update | |
respond_to do |format| | |
if @due_date.update(due_date_params) | |
format.html { redirect_to @due_date, notice: 'Due date was successfully updated.' } | |
format.json { head :no_content } | |
else | |
format.html { render action: 'edit' } | |
format.json { render json: @due_date.errors, status: :unprocessable_entity } | |
end | |
end | |
end | |
private | |
def set_due_date | |
@due_date = DueDate.find(params[:id]) | |
end | |
def due_date_params | |
params.require(:due_date).permit( | |
:name, :description, :start, { :tags => [] }, :recur, | |
:day_of_month, :day_of_week, :frequency | |
) | |
end | |
end |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
@mwmeyer you saved my day