Class: DmLiveResources::Resource

Inherits:
Object
  • Object
show all
Defined in:
lib/dm_live_resources/resource.rb

Class Method Summary collapse

Class Method Details

.add_gsheet_data(data_hash, file, title) ⇒ Object 



39
40
41
42
43
44
45
 
# File 'lib/dm_live_resources/resource.rb', line 39

def add_gsheet_data(data_hash,
	                file,
	                title)
  data_hash[:file] = file
  data_hash[:description] = title
  return data_hash
end

.data_as_hash(gs_api_key, gs_identifier, gs_sheets, gs_title, dm_api_key, dm_id) ⇒ Object 



29
30
31
32
33
34
35
36
37
 
# File 'lib/dm_live_resources/resource.rb', line 29

def data_as_hash(gs_api_key, gs_identifier, gs_sheets, gs_title, dm_api_key, dm_id)
  data = { gs_api_key: gs_api_key,
           gs_identifier: gs_identifier,
           gs_sheets: gs_sheets,
           gs_title: gs_title,
           dm_api_key: dm_api_key,
           dm_id: dm_id}
  return data
end

.db ⇒ Object 



6
7
8
9
10
11
12
 
# File 'lib/dm_live_resources/resource.rb', line 6

def db
  if File.exists? "Resources.db"
    @db = SQLite3::Database.open "Resources.db"
  else
    @db = SQLite3::Database.new "Resources.db"
  end
end

.insert_query(table) ⇒ Object 



47
48
49
 
# File 'lib/dm_live_resources/resource.rb', line 47

def insert_query(table)
  return %Q{INSERT INTO '#{table}' ( GSheetApiKey, GSheetIdentifier, GSheetTitle, GSheetContent, GSheetSheets, DMagicApiKey, DMagicId ) VALUES ( ?,?,?,?,?,?,? )}
end

.remove_db ⇒ Object 



14
15
16
 
# File 'lib/dm_live_resources/resource.rb', line 14

def remove_db
  File.delete("Resources.db") if File.exists? "Resources.db"
end

.return_tables ⇒ Object 



23
24
25
26
27
 
# File 'lib/dm_live_resources/resource.rb', line 23

def return_tables
  # List of all tables in db
  tables = db.execute("SELECT name FROM sqlite_master WHERE type='table'").flatten
  return tables
end

.update_required?(row, sheet) ⇒ Boolean

Returns:

  • (Boolean) 


18
19
20
21
 
# File 'lib/dm_live_resources/resource.rb', line 18

def update_required?(row,
	                 sheet)
  return row['GSheetContent'] != sheet.content
end