def _insert_query(self,
model,
objs,
fields,
return_id=True,
raw=False,
using=None,
update = [],
replace = False,
ignore = False,
):
query = sql.InsertQuery(model)
query.insert_values(fields, objs, raw=raw)
compiler = query.get_compiler(using=using)
post_str = ''
if(update):
xupdate = self._build_update(fields, update)
if(xupdate):
update_str = ','.join([
"`%s` = %s"%(key,value)
for key, value in six.iteritems(xupdate)
])
post_str = 'on duplicate key update %s'%(update_str)
pre_replace_str = ''
if(replace):
pre_replace_str = 'REPLACE'
if(ignore):
pre_replace_str = 'INSERT IGNORE'
return self._insert_query_execute_sql(
compiler = compiler,
return_id = return_id,
pre_replace_str = pre_replace_str,
post_str = post_str
)
def _insert_query(
self,
model,
objs,
fields,
return_id=True,
raw=False,
using=None,
update=[],
replace=False,
ignore=False,
):
query = sql.InsertQuery(model)
query.insert_values(fields, objs, raw=raw)
compiler = query.get_compiler(using=using)
post_str = ''
if (update):
xupdate = self._build_update(fields, update)
if (xupdate):
update_str = ','.join([
"`%s` = %s" % (key, value)
for key, value in six.iteritems(xupdate)
])
post_str = 'on duplicate key update %s' % (update_str)
pre_replace_str = ''
if (replace):
pre_replace_str = 'REPLACE'
if (ignore):
pre_replace_str = 'INSERT IGNORE'
return self._insert_query_execute_sql(compiler=compiler,
return_id=return_id,
pre_replace_str=pre_replace_str,
post_str=post_str)
def insert_query_sqlx(model, values, return_id=False, raw_values=False):
"""overrides insert_query() from models.query module"""
query = sql.InsertQuery(model, connection)
query.insert_values(values, raw_values)
return query.as_sql() # return SQL tuple
def insert_query_sqlx(model, values, return_id=False, raw_values=False):
"""overrides insert_query() from models.query module"""
query = sql.InsertQuery(model, connection)
query.insert_values(values, raw_values)
return query.as_sql() # return SQL tuple