| <p>SQL: <%= @users.to_sql %></p> | |
| <h2>Your first #{search_limit} results</h2> | |
| <table> | |
| <thead> | |
| <th><%= sort_link @search, :id, {}, :method => action_name == 'advanced_search' ? :post : :get %></th> | |
| <th><%= sort_link @search, :first_name, {}, :method => action_name == 'advanced_search' ? :post : :get %></th> | |
| # ... | |
| </thead> |
| # controller | |
| def proc_csv | |
| import = Import.find(params[:id]) | |
| if import.load_csv | |
| flash[:notice] = "woo" | |
| redirect_to some_url | |
| else | |
| flash[:error] = "ohoh" | |
| end | |
| end |
| # model CLINIC has many TREATMENTS | |
| <%= check_box_tag "q[treatments_id_eq_ALL][]", treatment.id, {} %> | |
| = f.input :category_name_eq, :collection=>Estate::Category.all.map(&:name), :as=>:check_boxes |
| f.collection_select :some_id_in, Model.all, :id, :name, {}, {:multiple => true} | |
| # I have to do the following to get the select field I want: | |
| search_form_for @search do |f| | |
| f.collection_select :level_in, Log.levels, :to_s, :to_s, {}, { size: Log.levels.length, multiple: true } | |
| class Forum < ActiveRecord::Base | |
| has_many :posts, :inverse_of => :forum | |
| end | |
| class Post < ActiveRecord::Base | |
| belongs_to :forum, :inverse_of => :posts | |
| end |
| class AuditInfo < ActiveRecord::Base | |
| belongs_to :arc_info | |
| def self.import(file) | |
| begin | |
| if file.path | |
| CSV.foreach(file.path, headers: true, col_sep: "\t") do |row| | |
| audit_info = AuditInfo.create! row.to_hash | |
| arc_info = audit_info.arc_info | |
| arc_info.update_attribute(:status, audit_info.computed_status) |
| WITH table_scans as ( | |
| SELECT relid, | |
| tables.idx_scan + tables.seq_scan as all_scans, | |
| ( tables.n_tup_ins + tables.n_tup_upd + tables.n_tup_del ) as writes, | |
| pg_relation_size(relid) as table_size | |
| FROM pg_stat_user_tables as tables | |
| ), | |
| all_writes as ( | |
| SELECT sum(writes) as total_writes | |
| FROM table_scans |
| class Cleaner | |
| def domain_from_email(email) | |
| email.match(/([\w+\-.]+)@([a-z\d\-.]+\.[a-z]{2,4}+)/)[2] | |
| end | |
| def area_code_only(phone_number) | |
| phone_number.match(/(\+*\d{1,})*([ |\(])*(\d{3})[^\d]*(\d{3})[^\d]*(\d{4})/)[3] | |
| end | |
| def get_secret_message(string) |
#What are database tables, column, and rows? What's the purpose of each?
Table is a collection of columns and rows
Column is a particular datatype, named with lowercase_separated_with_underscores
Row is a collection of data elements in a table each represented by a column, synonym for record
#How's a database similar and different from a spreadsheet?
| describe "the idea creation process", :type => :feature do | |
| it "goes to the home page" do | |
| visit '/' | |
| within("#session") do | |
| fill_in 'Title', :with => 'great idea' | |
| fill_in 'Description', :with => 'so awesome all the things' | |
| end | |
| click_button 'submit' | |
| expect(page).to have_content 'Great Idea' | |
| end |