Skip to content

Instantly share code, notes, and snippets.

View mitchellhenke's full-sized avatar

Mitchell Henke mitchellhenke

108 followers · 4 following
View GitHub Profile
@mitchellhenke
mitchellhenke / iex.exs
Last active August 29, 2015 14:21
User |> User.search("mitch") |> Repo.all
# [debug] SELECT u0."id", u0."username" FROM "users" AS u0 WHERE (u0."name" % $1) ORDER BY similarity(u0."name", $2) DESC ["mitch", "mitch"] (1.9ms)
[%User{__meta__: %Ecto.Schema.Metadata{source: "users", state: :loaded},
username: "mitch"},
%User{__meta__: %Ecto.Schema.Metadata{source: "users", state: :loaded},
username: "mitch3"}]
@mitchellhenke
mitchellhenke / user.ex
Created May 13, 2015 14:44
defmodule User do
use Ecto.Model
schema "users" do
field :username, :string
end
def search(query, search_term) do
from(u in query,
where: fragment("? % ?", u.username, ^search_term),
@mitchellhenke
mitchellhenke / migration.exs
Created May 13, 2015 14:43
defmodule Repo.Migrations.UserSearch do
use Ecto.Migration
def up do
execute "CREATE extension if not exists pg_trgm;"
execute "CREATE INDEX users_username_trgm_index ON users USING gin (username gin_trgm_ops);"
end
def down do
execute "DROP INDEX users_username_trgm_index;"
@mitchellhenke
mitchellhenke / user.ex
Created May 13, 2015 14:42
defmodule User do
use Ecto.Model
schema "users" do
field :username, :string
end
end
@mitchellhenke
mitchellhenke / Run things in Sequel on connect
Created October 22, 2014 17:54
after_connect = proc do |connection|
connection.query("UPDATE items set text='testing' where id = 34;")
end
Sequel::Model.db = Sequel.connect(ENV['DATABASE_URL'], after_connect: after_connect)
@mitchellhenke
mitchellhenke / review_images_controller.rb
Created December 17, 2013 04:42
module Review
module Account
class ReviewImagesController < ApplicationController
def create
puts params
render :json => {:stuff=>params}.to_json
end
end
@mitchellhenke
mitchellhenke / form
Created August 16, 2012 20:29
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Padrino Admin</title>
<%= stylesheet_link_tag :base, "themes/default/style" %>
</head>
<body>
<div id="container">
<div id="box">