def create_upsert_statement(self,
table,
fields,
constraint_fields,
statement_string=False,
coalesce=None):
"""returns update statement"""
insert_fields, insert_statement = self.create_insert_statement(
table, fields)
update_statement = self._create_on_duplicate_key_update_statement(
fields,
constraint_fields,
table=table,
coalesce=coalesce,
)
sql = SqlClause(phrases=[insert_statement, update_statement],
phrase_indents=0,
phrase_separator='\n')
if statement_string:
sql = sql.get_sql_clause()
return insert_fields, sql
def create_truncate_table_statement(table, statement_string=False):
"""stuff"""
sql_clause = SqlClause(header='TRUNCATE TABLE `{0}`'.format(table))
# Convert to string
if statement_string:
sql_clause = sql_clause.get_sql_clause()
return [], sql_clause
def create_truncate_table_statement(table, statement_string=False):
"""stuff"""
sql_clause = SqlClause(header='TRUNCATE TABLE `{0}`'.format(table))
# Convert to string
if statement_string:
sql_clause = sql_clause.get_sql_clause()
return [], sql_clause
def create_upsert_statement(self, table, fields, statement_string=False):
"""returns update statement"""
insert_fields, insert_statement = self.create_insert_statement(table, fields)
update_statement = self._create_on_duplicate_key_update_statement(fields)
sql = SqlClause(phrases=[insert_statement, update_statement],
phrase_indents=0,
phrase_separator='\n')
if statement_string:
sql = sql.get_sql_clause()
return insert_fields, sql
