module Create
Public Instance Methods
build_create_query(obj)
click to toggle source
# File lib/yaml2sql.rb, line 31 def build_create_query(obj) name = obj['name'] create = "create table if not exists #{name}" insert = create_insert_str(obj['columns'], obj['foreign'], obj['indexes']) create + insert end
create_insert_str(columns_obj, foreign_obj, indexes_obj)
click to toggle source
# File lib/yaml2sql.rb, line 19 def create_insert_str(columns_obj, foreign_obj, indexes_obj) insert_statements = ['id integer primary key autoincrement'] insert_statements += columns_obj.map{ |x| create_single_insert(x) } insert_statements += foreign_obj.map{ |x| create_single_foreign(x) } if foreign_obj insert_statements = "(#{insert_statements.join(',')});" insert_statements += indexes_obj.map { |x| create_single_index(x) }.join(" ") if indexes_obj insert_statements end
create_single_foreign(foreign_obj)
click to toggle source
# File lib/yaml2sql.rb, line 9 def create_single_foreign(foreign_obj) name, table, key = ['name', 'table', 'key'].map{ |x| foreign_obj[x] } "foreign key (#{name}) references #{table}(#{key})" end
create_single_index(index_obj)
click to toggle source
# File lib/yaml2sql.rb, line 14 def create_single_index(index_obj) name, table, key = ['name', 'table', 'key'].map{ |x| index_obj[x] } "create index if not exists #{name} on #{table + '(' + key + ');'}" end
create_single_insert(insert_obj)
click to toggle source
# File lib/yaml2sql.rb, line 4 def create_single_insert(insert_obj) name, type = insert_obj['name'], insert_obj['type'] "#{name} #{type} #{'unique' if insert_obj.key?('unique')}" end
create_tables(obj)
click to toggle source
# File lib/yaml2sql.rb, line 38 def create_tables(obj) obj["tables"].map{ |x| build_create_query(x) } end