Class: Hash

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

Instance Method Summary collapse

Instance Method Details

#to_sql_create_query(table_name) ⇒ Object 



162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
 
# File 'lib/table_syncer.rb', line 162

def to_sql_create_query(table_name)
  query = "insert into #{table_name} ("
  comma = ''
  self.each_key { |key_name|
    query += "#{comma}#{key_name} "
    comma = ','
  }
  query += ") values ( "
  comma = ''
  self.each_key { |key_name|
    query += "#{comma} #{self[key_name] ? "'" + self[key_name].gsub("'", "\\\\'") + "'" : 'NULL'}" # assume it will leave the others are null, I guess
    comma = ','
  }
  query += ");"
end

#to_sql_update_query(table_name, nonmatching_keys) ⇒ Object

ltodo take some ‘params’ :)



151
152
153
154
155
156
157
158
159
160
 
# File 'lib/table_syncer.rb', line 151

def to_sql_update_query(table_name, nonmatching_keys) # ltodo take some 'params' :)
  raise unless self['id']
  query = "update #{table_name} set"
    comma = ''
  self.each_key do |key|
    query << "#{comma} #{key} = #{self[key] ? "'" + self[key].gsub("'", "\\\\'") + "'": 'NULL'}" if nonmatching_keys.include? key
    comma = ',' if nonmatching_keys.include? key
  end
  query << " where id = #{self['id']}"
end