Natacha natachaS

💭

Living life one PR at a time...

Engineering Leader

natachaS / 02_methods.rb

Created June 3, 2014 15:12 — forked from anonymous/02_methods.rb

	require 'pg'
	require 'pry'

	conn = PG.connect(dbname: 'chinook')

	def add_artist(db_conn, name)
	sql = <<-SQL
	INSERT INTO artists (name)
	VALUES ($1) RETURNING id
	SQL

natachaS / 03_objects.rb

Created June 3, 2014 15:12 — forked from anonymous/03_objects.rb

	require 'pg'
	require 'pry'

	class Artist
	CONN = PG.connect(dbname: 'chinook')
	attr_accessor :id, :name

	def self.new_from_row(row)
	id = row["id"]
	name = row["name"]

natachaS / 01_pg.rb

Created June 3, 2014 15:12 — forked from anonymous/01_pg.rb

	require 'pg'
	require 'pry'
	conn = PG.connect(dbname: 'chinook')
	binding.pry

natachaS / 03_objects.rb

Created June 4, 2014 14:49 — forked from anonymous/03_objects.rb

	require 'pg'
	require 'pry'

	class Artist
	CONN = PG.connect(dbname: 'chinook')
	attr_accessor :id, :name

	def self.new_from_row(row)
	id = row["id"]
	name = row["name"]

natachaS / observer.rb

Created June 4, 2014 14:50 — forked from anonymous/observer.rb

	class Artist
	attr_reader :subscribers, :name, :label

	def initialize(name, label)
	@name = name
	@label = label
	@subscribers = []
	end

	def add_subscriber(subscriber)

natachaS / 01_orm_with_sequel.rb

Created June 4, 2014 17:55 — forked from anonymous/01_orm_with_sequel.rb

	require 'sequel'
	require 'pry'

	class Artist
	# CONN = PG.connect(dbname: 'chinook')
	DB = Sequel.postgres('chinook')
	attr_accessor *DB[:artists].columns

	def self.new_from_row(row)
	id = row[:id]

natachaS / 02_sequel_orm.rb

Created June 4, 2014 17:55 — forked from anonymous/02_sequel_orm.rb

Interview Prep