private static string InsertMultipleValues(int size, string name, Fields fields, IEnumerable <Row> rows, AbstractConnection connection)
{
var sqlBuilder = new StringBuilder();
var safeName = connection.TableVariable ? name : connection.Enclose(name);
foreach (var group in rows.Partition(size))
{
sqlBuilder.Append(string.Format("\r\nINSERT INTO {0}\r\nVALUES({1});", safeName, string.Join("),\r\n(", RowsToValues(fields, @group))));
}
return(sqlBuilder.ToString());
}
public void Drop(AbstractConnection connection, Entity entity) {
if (!EntityExists.Exists(connection, entity))
return;
var sql = string.Format(FORMAT, connection.Enclose(entity.OutputName()));
using (var cn = connection.GetConnection()) {
cn.Open();
cn.Execute(sql);
connection.Logger.EntityDebug(entity.Name, "Dropped Output {0}", entity.OutputName());
}
}
public void Drop(AbstractConnection connection, Entity entity)
{
if (!EntityExists.Exists(connection, entity))
{
return;
}
var sql = string.Format(FORMAT, connection.Enclose(entity.OutputName()));
using (var cn = connection.GetConnection()) {
cn.Open();
cn.Execute(sql);
connection.Logger.EntityDebug(entity.Name, "Dropped Output {0}", entity.OutputName());
}
}
private static string InsertMultipleValues(int size, string name, Fields fields, IEnumerable<Row> rows, AbstractConnection connection) {
var sqlBuilder = new StringBuilder();
var safeName = connection.TableVariable ? name : connection.Enclose(name);
foreach (var group in rows.Partition(size)) {
sqlBuilder.Append(string.Format("\r\nINSERT INTO {0}\r\nVALUES({1});", safeName, string.Join("),\r\n(", RowsToValues(fields, @group))));
}
return sqlBuilder.ToString();
}
public List<string> SelectKeys(AbstractConnection connection) {
var selectKeys = new List<string>();
foreach (var field in PrimaryKey.WithInput()) {
selectKeys.Add(
field.Alias.Equals(field.Name)
? connection.Enclose(field.Name)
: string.Format("{0} AS {1}", connection.Enclose(field.Name), connection.Enclose(field.Alias))
);
}
return selectKeys;
}