Skip to content

Instantly share code, notes, and snippets.

View natachaS's full-sized avatar
💭
Living life one PR at a time...

Natacha natachaS

💭
Living life one PR at a time...
View GitHub Profile
Natacha Springer
Github Username
natachaS
Blog Url
http://natachaspringer.com/
Tagline
Ninja-in-training
touch natachaSpringer.txt
nano natachaSpringer.txt
save with CTRL X ENTER
cat natachaSpringer.txt
cat natachaSpringer.txt >natachaSpringercopy.txt
mv natachaSpringercopy.txt stevenrules.txt
cat natachaSpringer.txt stevenrules.txt > everything.txt
echo "I like pina coladas and getting caught in the rain" >> everything.txt
ls *.txt > textfileslist
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
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"]
require 'pg'
require 'pry'
conn = PG.connect(dbname: 'chinook')
binding.pry
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"]
class Artist
attr_reader :subscribers, :name, :label
def initialize(name, label)
@name = name
@label = label
@subscribers = []
end
def add_subscriber(subscriber)
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]
require 'sequel'
require 'pry'
DB = Sequel.postgres('chinook')
class Artist < Sequel::Model
end
class Album < Sequel::Model
end
binding.pry