Skip to content

Instantly share code, notes, and snippets.

require "sequel"
DB = Sequel.postgres("arel")
DB.create_table!(:movies) { primary_key :id }
class Movie < Sequel::Model
end
# Asterisk (I agree this one isn't ideal)
Movie.select{count{}.*} # SELECT count(*) FROM "movies"
@janko
janko / 01-activerecord.rb
Created May 27, 2015 22:50
PostgreSQL JSON querying in Sequel (my presentation from our local Ruby meetup)
require "active_record"
ActiveRecord::Base.establish_connection('postgres:///testing')
ActiveRecord::Migration.verbose = false
ActiveRecord::Migration.class_eval do
create_table :played_quizzes, force: true do |t|
t.integer :player_ids, array: true
t.json :quiz_snapshot
end
@manveru
manveru / start.rb
Created January 25, 2011 15:47
Generate static pages in Ramaze
require 'ramaze'
class Main < Ramaze::Controller
def index
make_static
end
private
def make_static
layout do |path, wish|
if path !~ /feed|show/
mobile_rendering? ? :mobile : :main
end
end
def self.mobile_rendering?
(request.host =~ /m\.learnivore/) ? true : false
end
require 'rubygems'
require 'anemone'
require 'builder'
sitemap = ""
xml = Builder::XmlMarkup.new(:target => sitemap, :indent=>2)
xml.instruct!
xml.urlset(:xmlns=>'http://www.sitemaps.org/schemas/sitemap/0.9') {
Anemone.crawl("http://www.example.com/", :discard_page_bodies => true) do |anemone|