Class: Airrecord::Table

Inherits:
Object
  • Object
show all
Defined in:
lib/airrecord/table.rb

Class Attribute Summary collapse

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(fields, id: nil, created_at: nil) ⇒ Table 



106
107
108
109
110
 
# File 'lib/airrecord/table.rb', line 106

def initialize(fields, id: nil, created_at: nil)
  @id = id
  self.created_at = created_at
  self.fields = fields
end

Class Attribute Details

.api_key ⇒ Object 



12
13
14
 
# File 'lib/airrecord/table.rb', line 12

def api_key
  defined?(@api_key) ? @api_key : Airrecord.api_key
end

.base_key ⇒ Object

Returns the value of attribute base_key.



4
5
6
 
# File 'lib/airrecord/table.rb', line 4

def base_key
  @base_key
end

.table_name ⇒ Object

Returns the value of attribute table_name.



4
5
6
 
# File 'lib/airrecord/table.rb', line 4

def table_name
  @table_name
end

Instance Attribute Details

#created_at ⇒ Object

Returns the value of attribute created_at.



104
105
106
 
# File 'lib/airrecord/table.rb', line 104

def created_at
  @created_at
end

#fields ⇒ Object

Returns the value of attribute fields.



104
105
106
 
# File 'lib/airrecord/table.rb', line 104

def fields
  @fields
end

#id ⇒ Object (readonly)

Returns the value of attribute id.



104
105
106
 
# File 'lib/airrecord/table.rb', line 104

def id
  @id
end

#updated_keys ⇒ Object (readonly)

Returns the value of attribute updated_keys.



104
105
106
 
# File 'lib/airrecord/table.rb', line 104

def updated_keys
  @updated_keys
end

Class Method Details

.belongs_to(method_name, options) ⇒ Object Also known as: has_one 



30
31
32
 
# File 'lib/airrecord/table.rb', line 30

def belongs_to(method_name, options)
  has_many(method_name, options.merge(single: true))
end

.client ⇒ Object 



7
8
9
10
 
# File 'lib/airrecord/table.rb', line 7

def client
  @@clients ||= {}
  @@clients[api_key] ||= Client.new(api_key)
end

.create(fields) ⇒ Object 



53
54
55
 
# File 'lib/airrecord/table.rb', line 53

def create(fields)
  new(fields).tap { |record| record.save }
end

.find(id) ⇒ Object 



36
37
38
39
40
41
42
43
44
45
 
# File 'lib/airrecord/table.rb', line 36

def find(id)
  response = client.connection.get("/v0/#{base_key}/#{client.escape(table_name)}/#{id}")
  parsed_response = client.parse(response.body)

  if response.success?
    self.new(parsed_response["fields"], id: id)
  else
    client.handle_error(response.status, parsed_response)
  end
end

.find_many(ids) ⇒ Object 



47
48
49
50
51
 
# File 'lib/airrecord/table.rb', line 47

def find_many(ids)
  or_args = ids.map { |id| "RECORD_ID() = '#{id}'"}.join(',')
  formula = "OR(#{or_args})"
  records(filter: formula).sort_by { |record| or_args.index(record.id) }
end

.has_many(method_name, options) ⇒ Object 



16
17
18
19
20
21
22
23
24
25
26
27
28
 
# File 'lib/airrecord/table.rb', line 16

def has_many(method_name, options)
  define_method(method_name.to_sym) do
    # Get association ids in reverse order, because Airtable’s UI and API
    # sort associations in opposite directions. We want to match the UI.
    ids = (self[options.fetch(:column)] || []).reverse
    table = Kernel.const_get(options.fetch(:class))
    options[:single] ? table.find(ids.first) : table.find_many(ids)
  end

  define_method("#{method_name}=".to_sym) do |value|
    self[options.fetch(:column)] = Array(value).map(&:id).reverse
  end
end

.records(filter: nil, sort: nil, view: nil, offset: nil, paginate: true, fields: nil, max_records: nil, page_size: nil) ⇒ Object Also known as: all 



57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
 
# File 'lib/airrecord/table.rb', line 57

def records(filter: nil, sort: nil, view: nil, offset: nil, paginate: true, fields: nil, max_records: nil, page_size: nil)
  options = {}
  options[:filterByFormula] = filter if filter

  if sort
    options[:sort] = sort.map { |field, direction|
      { field: field.to_s, direction: direction }
    }
  end

  options[:view] = view if view
  options[:offset] = offset if offset
  options[:fields] = fields if fields
  options[:maxRecords] = max_records if max_records
  options[:pageSize] = page_size if page_size

  path = "/v0/#{base_key}/#{client.escape(table_name)}"
  response = client.connection.get(path, options)
  parsed_response = client.parse(response.body)

  if response.success?
    records = parsed_response["records"]
    records = records.map { |record|
      self.new(record["fields"], id: record["id"], created_at: record["createdTime"])
    }

    if paginate && parsed_response["offset"]
      records.concat(records(
        filter: filter,
        sort: sort,
        view: view,
        paginate: paginate,
        fields: fields,
        offset: parsed_response["offset"],
        max_records: max_records,
        page_size: page_size,
      ))
    end

    records
  else
    client.handle_error(response.status, parsed_response)
  end
end

Instance Method Details

#==(other) ⇒ Object Also known as: eql? 



183
184
185
186
 
# File 'lib/airrecord/table.rb', line 183

def ==(other)
  self.class == other.class &&
    serializable_fields == other.serializable_fields
end

#[](key) ⇒ Object 



116
117
118
119
 
# File 'lib/airrecord/table.rb', line 116

def [](key)
  validate_key(key)
  fields[key]
end

#[]=(key, value) ⇒ Object 



121
122
123
124
125
126
 
# File 'lib/airrecord/table.rb', line 121

def []=(key, value)
  validate_key(key)
  return if fields[key] == value # no-op
  @updated_keys << key
  fields[key] = value
end

#create ⇒ Object

Raises:



128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
 
# File 'lib/airrecord/table.rb', line 128

def create
  raise Error, "Record already exists (record has an id)" unless new_record?

  body = { fields: serializable_fields }.to_json
  response = client.connection.post("/v0/#{self.class.base_key}/#{client.escape(self.class.table_name)}", body, { 'Content-Type' => 'application/json' })
  parsed_response = client.parse(response.body)

  if response.success?
    @id = parsed_response["id"]
    self.created_at = parsed_response["createdTime"]
    self.fields = parsed_response["fields"]
  else
    client.handle_error(response.status, parsed_response)
  end
end

#destroy ⇒ Object

Raises:



166
167
168
169
170
171
172
173
174
175
176
177
 
# File 'lib/airrecord/table.rb', line 166

def destroy
  raise Error, "Unable to destroy new record" if new_record?

  response = client.connection.delete("/v0/#{self.class.base_key}/#{client.escape(self.class.table_name)}/#{self.id}")
  parsed_response = client.parse(response.body)

  if response.success?
    true
  else
    client.handle_error(response.status, parsed_response)
  end
end

#hash ⇒ Object 



190
191
192
 
# File 'lib/airrecord/table.rb', line 190

def hash
  serializable_fields.hash
end

#new_record? ⇒ Boolean 



112
113
114
 
# File 'lib/airrecord/table.rb', line 112

def new_record?
  !id
end

#save ⇒ Object 



144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
 
# File 'lib/airrecord/table.rb', line 144

def save
  return create if new_record?

  return true if @updated_keys.empty?

  # To avoid trying to update computed fields we *always* use PATCH
  body = {
    fields: Hash[@updated_keys.map { |key|
      [key, fields[key]]
    }]
  }.to_json

  response = client.connection.patch("/v0/#{self.class.base_key}/#{client.escape(self.class.table_name)}/#{self.id}", body, { 'Content-Type' => 'application/json' })
  parsed_response = client.parse(response.body)

  if response.success?
    self.fields = parsed_response["fields"]
  else
    client.handle_error(response.status, parsed_response)
  end
end

#serializable_fields ⇒ Object 



179
180
181
 
# File 'lib/airrecord/table.rb', line 179

def serializable_fields
  fields
end