public override string ToSql()
{
if (_source?.Any() != true)
{
return(null);
}
var insert = _orm.Insert <T1>()
.AsTable(_tableRule).AsType(_table.Type)
.WithConnection(_connection)
.WithTransaction(_transaction)
.NoneParameter(true) as Internal.CommonProvider.InsertProvider <T1>;
insert._source = _source;
var ocdu = new OdbcPostgreSQLOnConflictDoUpdate <T1>(insert);
ocdu.IgnoreColumns(_table.Columns.Values.Where(a => a.Attribute.CanUpdate == false).Select(a => a.Attribute.Name).ToArray());
if (_table.Columns.Values.Where(a => a.Attribute.IsPrimary == false && a.Attribute.CanUpdate == true).Any() == false)
{
ocdu.DoNothing();
}
var sql = ocdu.ToSql();
_params = insert._params;
return(sql);
}
public override string ToSql()
{
if (_source?.Any() != true)
{
return(null);
}
var sqls = new string[2];
var dbParams = new List <DbParameter>();
var ds = SplitSourceByIdentityValueIsNull(_source);
if (ds.Item1.Any())
{
sqls[0] = string.Join("\r\n\r\n;\r\n\r\n", ds.Item1.Select(a => getInsertSql(a, false)));
}
if (ds.Item2.Any())
{
sqls[1] = string.Join("\r\n\r\n;\r\n\r\n", ds.Item2.Select(a => getInsertSql(a, true)));
}
_params = dbParams.ToArray();
if (ds.Item2.Any() == false)
{
return(sqls[0]);
}
if (ds.Item1.Any() == false)
{
return(sqls[1]);
}
return(string.Join("\r\n\r\n;\r\n\r\n", sqls));
string getInsertSql(List <T1> data, bool flagInsert)
{
var insert = _orm.Insert <T1>()
.AsTable(_tableRule).AsType(_table.Type)
.WithConnection(_connection)
.WithTransaction(_transaction)
.NoneParameter(true) as Internal.CommonProvider.InsertProvider <T1>;
insert._source = data;
insert._table = _table;
insert._noneParameterFlag = flagInsert ? "cuc" : "cu";
string sql = "";
if (IdentityColumn != null && flagInsert)
{
sql = insert.ToSql();
}
else
{
var ocdu = new OdbcPostgreSQLOnConflictDoUpdate <T1>(insert.InsertIdentity());
ocdu._tempPrimarys = _tempPrimarys;
var cols = _table.Columns.Values.Where(a => _tempPrimarys.Contains(a) == false && a.Attribute.CanUpdate == true && _updateIgnore.ContainsKey(a.Attribute.Name) == false);
ocdu.UpdateColumns(cols.Select(a => a.Attribute.Name).ToArray());
if (_doNothing == true || cols.Any() == false)
{
ocdu.DoNothing();
}
sql = ocdu.ToSql();
}
if (string.IsNullOrEmpty(sql))
{
return(null);
}
if (insert._params?.Any() == true)
{
dbParams.AddRange(insert._params);
}
return(sql);
}
}