Sha256: b1bbbfd670c8a39acb34ca61e06c8697ac9adcae0af0c6db86e80cca82d35fc8
Contents?: true
Size: 1.32 KB
Versions: 11
Compression:
Stored size: 1.32 KB
Contents
# frozen_string_literal: true
# database handling for eDen Db
class Database
class << self
Sequel.extension :migration
def db_access
Sequel.connect("sqlite://eden.sqlite3")
end
def create_table(table_name, type)
eden = Sequel.connect("sqlite://eden.sqlite3")
type= case type
when 'string'
String
when 'int'
Integer
when 'hash'
JSON
when 'date'
DateTime
else
Integer
end
unless eden.table_exists?(table_name)
eden.create_table table_name.to_sym do
# primary_key "#{table_name}_id".to_sym
column "#{table_name}_id".to_sym, type, primary_key: true
end
end
end
def create_column(table, column_name, type)
eden = Sequel.connect("sqlite://eden.sqlite3")
if eden.table_exists?(table) || !eden.schema(table).any? { |col| col[0] == column_name }
begin
Sequel.migration do
change do
add_column table, column_name, type unless eden.schema(table).any? { |column| column.first == column_name }
end
end.apply(eden, :up)
rescue Sequel::DatabaseError => e
puts "column #{e.message} already exist"
end
end
end
end
end
Version data entries
11 entries across 11 versions & 1 rubygems