Class: DbCompile::Construct

Inherits:
Object
  • Object
show all
Defined in:
lib/dbcompile/construct.rb

Overview

Anything that can be expressed in SQL

Direct Known Subclasses

Function, Trigger, View

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(name, root_path) ⇒ Construct 



9
10
11
12
13
 
# File 'lib/dbcompile/construct.rb', line 9

def initialize(name, root_path)
  @name = name
  @root_path = root_path
  build_path
end

Instance Attribute Details

#dependencies ⇒ Object

Returns the value of attribute dependencies.



7
8
9
 
# File 'lib/dbcompile/construct.rb', line 7

def dependencies
  @dependencies
end

#name ⇒ Object

Returns the value of attribute name.



4
5
6
 
# File 'lib/dbcompile/construct.rb', line 4

def name
  @name
end

#path ⇒ Object

Returns the value of attribute path.



5
6
7
 
# File 'lib/dbcompile/construct.rb', line 5

def path
  @path
end

#root_path ⇒ Object

Returns the value of attribute root_path.



6
7
8
 
# File 'lib/dbcompile/construct.rb', line 6

def root_path
  @root_path
end

Instance Method Details

#build_path ⇒ Object

Override this to set path the SQL source



16
17
 
# File 'lib/dbcompile/construct.rb', line 16

def build_path
end

#does_one_exist?(sql) ⇒ Boolean

checks to see if one object exists based on the sql string generated by an individual construct



43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
 
# File 'lib/dbcompile/construct.rb', line 43

def does_one_exist?(sql)
  result = ActiveRecord::Base.connection.execute(sql)
  case ActiveRecord::Base.connection.class.to_s
  when "ActiveRecord::ConnectionAdapters::PostgreSQLAdapter"
    return result.num_tuples == 1
  when "ActiveRecord::ConnectionAdapters::OracleEnhancedAdapter"
    row_count= 0
    while f = result.fetch
      row_count += 1
    end
    return row_count == 1
  else
    return result.length == 1
  end
end

#execute ⇒ Object

Execute the source to create contruct in database



20
21
22
 
# File 'lib/dbcompile/construct.rb', line 20

def execute
  ActiveRecord::Base.connection.execute(source)
end

#source ⇒ Object

Return the SQL source. Do any magic wrapping here.



25
26
27
28
29
30
 
# File 'lib/dbcompile/construct.rb', line 25

def source
  f = File.open(File.join(root_path, path))
  data = f.read
  f.close
  data
end

#verify ⇒ Object

Override to verify the existence of the construct Return true for verified successs Return false for verified failure Return nil otherwise



36
37
 
# File 'lib/dbcompile/construct.rb', line 36

def verify
end