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_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