public override string GetSyntax()
{
/*
* insert into [target_schema].[target_table] (col1, col2,...)
* select
* col1 = [tbl].col,
* col2 = [tbl].col ...
* from [schema].[table] [tbl]
* joins...
* where
* <policy>
*/
if (TargetTable == null)
{
return("");
}
var sql_insert = string.Format("insert into {0} ({1})", TargetTable.FullName, string.Join(", ", ColumnsValues.Select(cv => cv.TargetColumn.FullName).ToList()));
sql_insert += "\r\nselect" + string.Join(",\r\n\t", ColumnsValues.Select(cv => cv.ToString()).ToList());
//sql_insert += "\r\nfrom " + Table.FullName + " [tbl]";
//joins
sql_insert += WherePolicy == null ? "" : WherePolicy.GetQuery(false, true);
//where key
sql_insert += (WherePolicy == null ? "\r\nwhere" : "") + " [tbl].[" + Table.PrimaryKey.Columns.First().Name + "] = @pk_value";
//where
//if (WherePolicy != null)
// sql_insert += "\r\nAND\r\n" + WherePolicy.WhereExpression;
return(sql_insert);
}
public override string GetSyntax()
{
/*
* delete [target_schema].[target_table]
* from [schema].[table] [tbl]
* joins...
* where
* <policy>
*/
var sql_delete = string.Format("delete from {0}", TargetTable.FullName);
//joins
sql_delete += WherePolicy == null ? "" : WherePolicy.GetQuery(false, true);
//where key
sql_delete += (WherePolicy == null ? "\r\nwhere" : "") + " [tbl].[" + Table.PrimaryKey.Columns.First().Name + "] = @pk_value";
//where
//if (WherePolicy != null)
// sql_insert += "\r\nAND\r\n" + WherePolicy.WhereExpression;
return(sql_delete);
}
