Skip to content

Instantly share code, notes, and snippets.

View meltzerj's full-sized avatar

meltzerj

17 followers · 11 following
View GitHub Profile
@meltzerj
meltzerj / gist:956641
Created May 5, 2011 06:39
has_many :recent_events, :class_name => "TimelineEvent",
:finder_sql => 'SELECT timeline_events.* FROM timeline_events
WHERE ' + RECENT_EVENTS_CONDITION + '
ORDER BY timeline_events.created_at DESC'
@meltzerj
meltzerj / gist:956633
Created May 5, 2011 06:25
RECENT_EVENTS_CONDITION = '(actor_type = \'User\' AND actor_id IN (SELECT followed_id FROM relationships WHERE follower_id = #{id}))'
has_many :recent_events, :class_name => "TimelineEvent",
:conditions => :filter_event,
:finder_sql => 'SELECT timeline_events.* FROM timeline_events
WHERE ' + RECENT_EVENTS_CONDITION + '
ORDER BY timeline_events.created_at DESC',
:counter_sql => 'SELECT COUNT(*) FROM timeline_events
WHERE ' + RECENT_EVENTS_CONDITION
@meltzerj
meltzerj / gist:956619
Created May 5, 2011 06:14
>> User.first.recent_events
=> [#<TimelineEvent id: 124, event_type: "vote_updated", subject_type: "VideoVote", actor_type: "User", secondary_subject_type: "Video", subject_id: 639, actor_id: 58, secondary_subject_id: 506, created_at: "2011-05-05 08:56:07", updated_at: "2011-05-05 08:56:07">,
@meltzerj
meltzerj / gist:954853
Created May 4, 2011 06:56
<%= current_user.profiles_shown_video.where("video_id = ?", params[:id]).each do |p| %>
<ul>
<li><%= p.user.name %></li>
</ul>
<% end %>
@meltzerj
meltzerj / gist:954819
Created May 4, 2011 06:06
ActionController::RoutingError in Videos#feed_display
Showing /rubyprograms/dreamstill/app/views/timeline_events/_video_added.html.erb where line #4 raised:
No route matches {:action=>"show", :controller=>"videos"}
4: added <%= link_to "a song.", video_path(event.subject), :class => "normal squeeze" %></p>
@meltzerj
meltzerj / gist:954804
Created May 4, 2011 05:35
has_many :videos, :through => :showable_videos
has_many :videos
@meltzerj
meltzerj / gist:951211
Created May 2, 2011 05:47
def create
@signed_user = SignedUser.find_or_initialize_by_email(params[:signed_user][:email])
if @signed_user.new_record?
if @signed_user.save
#UserMailer.registration_confirmation(@signed_user).deliver
redirect_to signed_user_path(@signed_user)
else
render :action => 'new'
end
else
@meltzerj
meltzerj / gist:951210
Created May 2, 2011 05:46
def create
@signed_user = SignedUser.find_or_initialize_by_email(params[:signed_user][:email])
if @signed_user.new_record?
if @signed_user.save
#UserMailer.registration_confirmation(@signed_user).deliver
redirect_to signed_user_path(@signed_user)
end
else
render :action => 'new'
end
@meltzerj
meltzerj / gist:951207
Created May 2, 2011 05:35
def create
@signed_user = SignedUser.find_or_create_by_email(params[:signed_user][:email])
if @signed_user.save
UserMailer.registration_confirmation(@signed_user).deliver
redirect_to signed_user_path(@signed_user)
else
render :action => 'new'
end
end
@meltzerj
meltzerj / gist:950326
Created May 1, 2011 07:37
AREL (0.4ms) INSERT INTO "invitations" ("updated_at", "sender_id", "invitation_url", "created_at") VALUES ('2011-05-01 10:35:33.346784', NULL, 'http://www.dreamstill.com/?id=', '2011-05-01 10:35:33.346784')
AREL (0.1ms) INSERT INTO "signed_users" ("invitation_id", "updated_at", "link", "email", "created_at") VALUES (26, '2011-05-01 10:35:33.348869', '', '[email protected]', '2011-05-01 10:35:33.348869')
AREL (0.1ms) UPDATE "invitations" SET "updated_at" = '2011-05-01 10:35:33.350287', "sender_id" = 273 WHERE "invitations"."id" = 26
Redirected to http://localhost:3000/signed_users/273
Completed 302 Found in 36ms