Module: Jetski::Database::Base

Extended by:
Base
Included in:
Base, Model
Defined in:
lib/jetski/database/base.rb

Instance Method Summary collapse

Instance Method Details

#create_table_sql(table_name:, field_names: []) ⇒ Object 



10
11
12
13
14
15
16
17
18
19
 
# File 'lib/jetski/database/base.rb', line 10

def create_table_sql(table_name:, field_names: [])
  table_name = pluralize_string(table_name)
  default_fields = [["created_at", "datetime"], ["updated_at", "datetime"], ["id", "integer"]]
  fields = field_names.map { |f| f.split(":") }
  all_fields = fields + default_fields
  _gen_sql = "create table #{table_name} (\n"
  _gen_sql += all_fields.map { |field, data_type| " #{field} #{data_type}" }.join(",\n")
  _gen_sql += ");\n"
  _gen_sql
end

#db ⇒ Object 



6
7
8
 
# File 'lib/jetski/database/base.rb', line 6

def db
  @_db ||= SQLite3::Database.new "test.db"
end

#sql_data_type(str) ⇒ Object 



21
22
23
24
25
26
27
28
 
# File 'lib/jetski/database/base.rb', line 21

def sql_data_type(str)
  case str
  when "", "string"
    "varchar(255)"
  else
    str
  end
end