public override string GetInsertCommandText(IDatabaseConnectionModel databaseConnectionModel)
{
string table = databaseConnectionModel.GetTablePrefixed(TableName);
return string.Format("INSERT INTO {0} (name, slug, term_group) VALUES (@name, @slug, @termGroup)", table);
}
public override string GetInsertCommandText(IDatabaseConnectionModel databaseConnectionModel)
{
string table = databaseConnectionModel.GetTablePrefixed(TableName);
return string.Format("INSERT INTO {0} (term_id, taxonomy, description, parent) VALUES (@termId, @taxonomy, @description, @parent)", table);
}
public override string GetInsertCommandText(IDatabaseConnectionModel databaseConnectionModel)
{
string table = databaseConnectionModel.GetTablePrefixed(TableName);
return string.Format("INSERT INTO {0} (object_id, term_taxonomy_id, term_order) VALUES (@objectId, @termTaxonomyId, @termOrder)", table);
}
public override string GetInsertCommandText(IDatabaseConnectionModel databaseConnectionModel)
{
string table = databaseConnectionModel.GetTablePrefixed(TableName);
return string.Format("INSERT INTO {0} (post_id, meta_key, meta_value) VALUES (@postId, @metaKey, @metaValue)", table);
}
public override string GetInsertPostProcessingCommandText(IDatabaseConnectionModel databaseConnectionModel)
{
string table = databaseConnectionModel.GetTablePrefixed(TableName);
return string.Format("UPDATE {0} SET guid = @guid WHERE ID = @id", table);
}
public override string GetInsertCommandText(IDatabaseConnectionModel databaseConnectionModel)
{
string table = databaseConnectionModel.GetTablePrefixed(TableName);
return string.Format("INSERT INTO {0} (post_title, post_name, post_excerpt, post_content, menu_order, post_type, post_author, post_parent, guid, post_status, ping_status, comment_status, post_date, post_date_gmt, post_modified, post_modified_gmt, post_content_filtered, to_ping, pinged, post_password, post_mime_type) VALUES (@title, @name, @excerpt, @content, @menuOrder, @type, @author, @parent, @guid, @postStatus, @pingStatus, @commentStatus, @date, @dateGmt, @modified, @modifiedGmt, @contentFiltered, @toPing, @pinged, @password, @mimeType)", table);
}