public static IPostgresTuple CreateRecordTupleFrom(global::UseCase1.FormGroup item, bool[] useColumn)
{
if (item == null)
{
return(null);
}
var items = new IPostgresTuple[ColumnCount];
if (useColumn[Property_ID_Index])
{
items[Property_ID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.ID);
}
if (useColumn[Property_Name_Index])
{
items[Property_Name_Index] = _DatabaseCommon.Utility.StringToTuple(item.Name);
}
if (item.FormsURI != null)
{
if (useColumn[Property_FormsURI_Index])
{
items[Property_FormsURI_Index] = ArrayTuple.Create(item.FormsURI, it => new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(it));
}
}
;
return(RecordTuple.From(items));
}
public static IPostgresTuple CreateExtendedRecordTupleFrom(global::UseCase1.Customer item, bool[] useColumn)
{
if (item == null)
{
return(null);
}
var items = new IPostgresTuple[ExtendedColumnCount];
if (useColumn[ExtendedProperty_ID_Index])
{
items[ExtendedProperty_ID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.ID);
}
if (useColumn[ExtendedProperty_Name_Index])
{
items[ExtendedProperty_Name_Index] = _DatabaseCommon.Utility.StringToTuple(item.Name);
}
if (useColumn[ExtendedProperty_RegistrationNumber_Index])
{
items[ExtendedProperty_RegistrationNumber_Index] = _DatabaseCommon.Utility.IntegerToTuple(item.RegistrationNumber);
}
if (item.SubmissionsURI != null)
{
if (useColumn[ExtendedProperty_SubmissionsURI_Index])
{
items[ExtendedProperty_SubmissionsURI_Index] = ArrayTuple.Create(item.SubmissionsURI, it => new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(it));
}
}
;
return(RecordTuple.From(items));
}
public static IPostgresTuple CreateExtendedTupleFrom(global::UseCase1.Form item)
{
if (item == null)
{
return(null);
}
var items = new IPostgresTuple[ExtendedColumnCount];
items[ExtendedProperty_ID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.ID);
items[ExtendedProperty_Name_Index] = _DatabaseCommon.Utility.StringToTuple(item.Name);
items[ExtendedProperty_Schema_Index] = _DatabaseCommon.Utility.StringToTuple(item.Schema);
if (item.GroupURI != null)
{
items[ExtendedProperty_GroupURI_Index] = new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(item.GroupURI);
}
;
items[ExtendedProperty_GroupID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.GroupID);
items[ExtendedProperty_Status_Index] = _DatabaseCommon.FactoryUseCase1_FormStatus.FormStatusConverter.CreateTupleFrom(item.Status);
items[ExtendedProperty_Inputs_Index] = ArrayTuple.Create(item.Inputs, _DatabaseCommon.FactoryUseCase1_Entry.EntryConverter.CreateExtendedTupleFrom);
items[ExtendedProperty_Outputs_Index] = ArrayTuple.Create(item.Outputs, _DatabaseCommon.FactoryUseCase1_Entry.EntryConverter.CreateExtendedTupleFrom);
if (item.SubmissionsURI != null)
{
items[ExtendedProperty_SubmissionsURI_Index] = ArrayTuple.Create(item.SubmissionsURI, it => new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(it));
}
;
return(RecordTuple.From(items));
}
public static IPostgresTuple CreateExtendedTupleFrom(global::UseCase1.SelectedSubmission item)
{
if (item == null)
{
return(null);
}
var items = new IPostgresTuple[ExtendedColumnCount];
items[ExtendedProperty_URI_Index] = new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(item.URI);
items[ExtendedProperty_Customer_Index] = _DatabaseCommon.Utility.StringToTuple(item.Customer);
items[ExtendedProperty_Form_Index] = _DatabaseCommon.Utility.StringToTuple(item.Form);
items[ExtendedProperty_Schema_Index] = _DatabaseCommon.Utility.StringToTuple(item.Schema);
items[ExtendedProperty_FormInputs_Index] = ArrayTuple.Create(item.FormInputs, _DatabaseCommon.FactoryUseCase1_Entry.EntryConverter.CreateExtendedTupleFrom);
items[ExtendedProperty_Group_Index] = _DatabaseCommon.Utility.StringToTuple(item.Group);
items[ExtendedProperty_Comments_Index] = _DatabaseCommon.Utility.StringToTuple(item.Comments);
items[ExtendedProperty_Date_Index] = _DatabaseCommon.Utility.TimestampToTuple(item.Date);
return(RecordTuple.From(items));
}
public static void ToArray <T>(TextWriter sw, char[] buf, T[] data, Func <T, IPostgresTuple> converter)
{
if (data == null)
{
sw.Write("NULL");
return;
}
var arr = new IPostgresTuple[data.Length];
for (int i = 0; i < data.Length; i++)
{
arr[i] = converter(data[i]);
}
sw.Write('\'');
var tuple = ArrayTuple.From(arr);
tuple.InsertRecord(sw, buf, string.Empty, PostgresTuple.EscapeQuote);
sw.Write('\'');
}
public static void ToArray <T>(StreamWriter sw, IEnumerable <T> data, Func <T, PostgresTuple> converter)
{
if (data == null)
{
sw.Write("NULL");
return;
}
var list = new List <PostgresTuple>();
foreach (var item in data)
{
list.Add(converter(item));
}
sw.Write('\'');
var arr = new ArrayTuple(list.ToArray());
arr.InsertRecord(sw, string.Empty, PostgresTuple.EscapeQuote);
sw.Write('\'');
}
public static void ToArray <T>(TextWriter sw, char[] buf, IEnumerable <T> data, Func <T, IPostgresTuple> converter)
{
if (data == null)
{
sw.Write("NULL");
return;
}
var count = data.Count();
var tuples = new IPostgresTuple[count];
int i = 0;
foreach (var item in data)
{
tuples[i++] = converter(item);
}
sw.Write('\'');
var arr = ArrayTuple.From(tuples);
arr.InsertRecord(sw, buf, string.Empty, PostgresTuple.EscapeQuote);
sw.Write('\'');
}
private void _InternalDoPersist(Revenj.Utility.ChunkedMemoryStream cms, global::FormABC.Input[] insertedData, List <KeyValuePair <global::FormABC.Input, global::FormABC.Input> > updatedData, global::FormABC.Input[] deletedData)
{
var sw = cms.GetWriter();
if (insertedData.Length == 1 && updatedData.Count == 0 && deletedData.Length == 0)
{
sw.Write("/*NO LOAD BALANCE*/SELECT \"FormABC\".\"insert_Input\"(ARRAY['");
_DatabaseCommon.FactoryFormABC_Input.InputConverter.CreateRecordTupleFrom(insertedData[0], _DatabaseCommon.FactoryFormABC_Input.InputConverter.TableTuples).InsertRecord(sw, cms.SmallBuffer, string.Empty, PostgresTuple.EscapeQuote);
sw.Write(@"'::""FormABC"".""Input_entity""])");
sw.Flush();
cms.Position = 0;
var com = PostgresCommandFactory.NewCommand(cms, "SELECT \"FormABC\".\"insert_Input\"(:insert)");
DatabaseQuery.Execute(com);
}
else if (insertedData.Length == 0 && updatedData.Count == 1 && deletedData.Length == 0)
{
sw.Write("/*NO LOAD BALANCE*/SELECT \"FormABC\".\"update_Input\"(ARRAY['");
_DatabaseCommon.FactoryFormABC_Input.InputConverter.CreateRecordTupleFrom(updatedData[0].Key, _DatabaseCommon.FactoryFormABC_Input.InputConverter.PrimaryKeyUpdateTuples).InsertRecord(sw, cms.SmallBuffer, string.Empty, PostgresTuple.EscapeQuote);
sw.Write(@"'::""FormABC"".""Input_entity""],ARRAY['");
_DatabaseCommon.FactoryFormABC_Input.InputConverter.CreateRecordTupleFrom(updatedData[0].Value, _DatabaseCommon.FactoryFormABC_Input.InputConverter.TableTuples).InsertRecord(sw, cms.SmallBuffer, string.Empty, PostgresTuple.EscapeQuote);
sw.Write(@"'::""FormABC"".""Input_entity""]");
sw.Write(')');
sw.Flush();
cms.Position = 0;
var com = PostgresCommandFactory.NewCommand(cms, "SELECT \"FormABC\".\"update_Input\"(:old_record,:new_record)");
string _sqlError = null;
DatabaseQuery.Execute(com, dr => _sqlError = dr.GetString(0));
if (_sqlError != null)
{
throw new PostgresException(_sqlError);
}
}
else
{
sw.Write("/*NO LOAD BALANCE*/SELECT \"FormABC\".\"persist_Input\"('");
var arr = new IPostgresTuple[insertedData.Length];
for (int i = 0; i < insertedData.Length; i++)
{
arr[i] = _DatabaseCommon.FactoryFormABC_Input.InputConverter.CreateRecordTupleFrom(insertedData[i], _DatabaseCommon.FactoryFormABC_Input.InputConverter.TableTuples);
}
ArrayTuple.From(arr).InsertRecord(sw, cms.SmallBuffer, string.Empty, PostgresTuple.EscapeQuote);
sw.Write(@"'::""FormABC"".""Input_entity""[],'");
arr = new IPostgresTuple[updatedData.Count];
for (int i = 0; i < updatedData.Count; i++)
{
arr[i] = _DatabaseCommon.FactoryFormABC_Input.InputConverter.CreateRecordTupleFrom(updatedData[i].Key, _DatabaseCommon.FactoryFormABC_Input.InputConverter.PrimaryKeyUpdateTuples);
}
ArrayTuple.From(arr).InsertRecord(sw, cms.SmallBuffer, string.Empty, PostgresTuple.EscapeQuote);
sw.Write(@"'::""FormABC"".""Input_entity""[],'");
for (int i = 0; i < updatedData.Count; i++)
{
arr[i] = _DatabaseCommon.FactoryFormABC_Input.InputConverter.CreateRecordTupleFrom(updatedData[i].Value, _DatabaseCommon.FactoryFormABC_Input.InputConverter.TableTuples);
}
ArrayTuple.From(arr).InsertRecord(sw, cms.SmallBuffer, string.Empty, PostgresTuple.EscapeQuote);
sw.Write(@"'::""FormABC"".""Input_entity""[],'");
arr = new IPostgresTuple[deletedData.Length];
for (int i = 0; i < deletedData.Length; i++)
{
arr[i] = _DatabaseCommon.FactoryFormABC_Input.InputConverter.CreateRecordTupleFrom(deletedData[i], _DatabaseCommon.FactoryFormABC_Input.InputConverter.PrimaryKeyDeleteTuples);
}
ArrayTuple.From(arr).InsertRecord(sw, cms.SmallBuffer, string.Empty, PostgresTuple.EscapeQuote);
sw.Write(@"'::""FormABC"".""Input_entity""[]");
sw.Write(")");
sw.Flush();
cms.Position = 0;
var com = PostgresCommandFactory.NewCommand(cms, "SELECT \"FormABC\".\"persist_Input\"(:insert,:update_pairs,:delete)");
string _sqlError = null;
DatabaseQuery.Execute(com, dr => _sqlError = dr.GetString(0));
if (_sqlError != null)
{
throw new PostgresException(_sqlError);
}
}
foreach (var item in insertedData)
{
item.__ResetChangeTracking();
}
foreach (var item in updatedData)
{
item.Value.__ResetChangeTracking();
}
}
