Class: TestrdGem::Lead

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

Constant Summary collapse

@@conn = 
PGconn.open(:dbname => 'testrd', :user => 'dev')
@@index = 
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.



10
11
12
13
14
 
# File 'lib/testrd_gem/lead.rb', line 10

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 



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

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

.count ⇒ Object 



16
17
18
19
 
# File 'lib/testrd_gem/lead.rb', line 16

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

.delete(id) ⇒ Object 



35
36
37
38
39
 
# File 'lib/testrd_gem/lead.rb', line 35

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) ⇒ Object 



41
42
43
44
45
 
# File 'lib/testrd_gem/lead.rb', line 41

def self.integrate(username, password, token)
  puts "Salesforce Integration"
  #salesforce = SalesforceBulk::Api.new("YOUR_SALESFORCE_USERNAME", "YOUR_SALESFORCE_PASSWORD+YOUR_SALESFORCE_TOKEN")
  salesforce = SalesforceBulk::Api.new(username, password + token)
end

.show(id) ⇒ Object 



30
31
32
33
 
# File 'lib/testrd_gem/lead.rb', line 30

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