Class: TestrdGem::Lead

Inherits:
Object
  • Object
show all
Defined in:
lib/testrd_gem/lead.rb

Constant Summary collapse

@@conn = 
PGconn.open(:host => 'ec2-54-235-147-211.compute-1.amazonaws.com', :dbname => 'da0t8bv4p5butg', :user => 'sowqqzffnclwat', :password => 'wJxPixjzZYuASiDjq53lqvyC_e')
@@index =

@@conn = PGconn.open(:dbname => ‘testrd’, :user => ‘dev’)

0

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(name, last_name, email, company, job_title, phone, website) ⇒ Lead

Returns a new instance of Lead.



12
13
14
15
16
 
# File 'lib/testrd_gem/lead.rb', line 12

def initialize(name, last_name, email, company, job_title, phone, website)
  res = @@conn.exec("INSERT INTO leads VALUES (" + @@index.to_s + ",'" + name + "','" + last_name + "','" + email + "','" + company + "','" + job_title + "','" + phone + "','" + website + "')")

  @@index += 1
end

Class Method Details

.all ⇒ Object 



23
24
25
26
27
28
29
30
 
# File 'lib/testrd_gem/lead.rb', line 23

def self.all
  res = @@conn.exec('SELECT * FROM leads')
  result = []
  res.each do |row|
    result.push(row)
  end
  result
end

.count ⇒ Object 



18
19
20
21
 
# File 'lib/testrd_gem/lead.rb', line 18

def self.count
  res = @@conn.exec('SELECT count(*) FROM leads')
  res.getvalue(0,0).to_i
end

.delete(id) ⇒ Object 



37
38
39
40
41
 
# File 'lib/testrd_gem/lead.rb', line 37

def self.delete(id)
  lead_d = self.show(id)
  res = @@conn.exec("DELETE FROM leads WHERE id = '" + id.to_s + "'")
  lead_d
end

.integrate(username, password, token, lead_params) ⇒ Object 



43
44
45
46
47
48
49
50
51
 
# File 'lib/testrd_gem/lead.rb', line 43

def self.integrate(username, password, token, lead_params)
  client = Databasedotcom::Client.new :client_id => "3MVG9KI2HHAq33Rx7XIyfKc5aKIGHGMyvxp9bZHTRZNs1wZs_QI613iMloL9d2waIFXna4oWqvTuJmyMaFJtY", :client_secret => "6763675580231888688"

  client.authenticate :username => username, :password => password + token

  lead_class = client.materialize("Lead")

  client.create(lead_class, lead_params)
end

.show(id) ⇒ Object 



32
33
34
35
 
# File 'lib/testrd_gem/lead.rb', line 32

def self.show(id)
  res = @@conn.exec("SELECT * FROM leads WHERE id = '" + id.to_s + "'")
  res[0]
end