def _update_bootstrap(self, data, id_instance):
'''
create sql statement to edit in bootstrap table according to given parameters. Also calls relevant validation function for fields
:param kwargs:Dictionary of parameters => name, types, subtype, data
:return: sql update statement or raise exception in case of validation error
'''
kwargs = Validator._bootstrap_validator(data)
return "update bootstrap set name={}, types={}, subtype={}, data={} where id={}".format(
kwargs['name'], kwargs['types'], kwargs['sub_type'],
kwargs['data'], id_instance)
def _insert_bootstrap(self, data):
'''
create sql statement to insert in bootstrap table according to given parameters. Also calls relevant validation function for fields
:param kwargs:Dictionary of parameters => name, types, subtype, data
:return: sql insert statement or raise exception in case of validation error
'''
parameters = ''
for kwargs in data:
kwargs = Validator._bootstrap_validator(kwargs)
parameters += '({}, {}, {}, {}),'.format(kwargs['name'],
kwargs['types'],
kwargs['sub_type'],
kwargs['data'])
return "insert into bootstrap (name, types, subtype, data) values " + parameters[:
-1]
