Module: Views

Defined in:
lib/jungle_path/app/schemas/views.rb

Class Method Summary collapse

Class Method Details

.filter_contact ⇒ Object 



5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
 
# File 'lib/jungle_path/app/schemas/views.rb', line 5

def self.filter_contact
  @filter_contact = JunglePath::DBModel::View.new(
    JunglePath::SQL::Helpers.sql("
      create or replace function filter_contact(p_contact_id int)
      returns table (
        id int,
        name text,
        email text,
        user_id int,
        created_at timestamp,
        created_by_user_id int,
        updated_at timestamp,
        updated_by_user_id int
      )
      as
      $body$
        select
          a.*
        from contact a
        where a.id = p_contact_id
      $body$
      language sql;
    "),
    "drop function filter_contact(int)",
    [:contact],
    [:contact_id]
  ) unless @filter_contact
  @filter_contact
end

.filter_test ⇒ Object 



35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
 
# File 'lib/jungle_path/app/schemas/views.rb', line 35

def self.filter_test
  @filter_test = JunglePath::DBModel::View.new(
    JunglePath::SQL::Helpers.sql("
      create or replace function filter_test(p_contact_id int)
      returns table (
        id int,
        name text,
        email text,
        user_id int,
        created_at timestamp,
        created_by_user_id int,
        updated_at timestamp,
        updated_by_user_id int
      )
      as
      $body$
        select
          a.*
        from contact a
        where a.id = p_contact_id
      $body$
      language sql;
    "),
    "drop function filter_test(int)",
    [:contact, :test],
    [:contact_id]
  ) unless @filter_test
  @filter_test
end