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.Submission item) { if (item == null) { return(null); } var items = new IPostgresTuple[ExtendedColumnCount]; items[ExtendedProperty_ID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.ID); if (item.CustomerURI != null) { items[ExtendedProperty_CustomerURI_Index] = new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(item.CustomerURI); } ; items[ExtendedProperty_CustomerID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.CustomerID); if (item.FormURI != null) { items[ExtendedProperty_FormURI_Index] = new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(item.FormURI); } ; items[ExtendedProperty_FormID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.FormID); items[ExtendedProperty_Comments_Index] = _DatabaseCommon.Utility.StringToTuple(item.Comments); items[ExtendedProperty_Date_Index] = _DatabaseCommon.Utility.TimestampToTuple(item.Date); items[ExtendedProperty_InputsBytes_Index] = _DatabaseCommon.Utility.BinaryToTuple(item.InputsBytes); items[ExtendedProperty_OutputBytes_Index] = _DatabaseCommon.Utility.BinaryToTuple(item.OutputBytes); 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 CreateExtendedRecordTupleFrom(global::UseCase1.SubmissionList item, bool[] useColumn) { if (item == null) { return(null); } var items = new IPostgresTuple[ExtendedColumnCount]; if (useColumn[ExtendedProperty_URI_Index]) { items[ExtendedProperty_URI_Index] = new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(item.URI); } if (useColumn[ExtendedProperty_Customer_Index]) { items[ExtendedProperty_Customer_Index] = _DatabaseCommon.Utility.StringToTuple(item.Customer); } if (useColumn[ExtendedProperty_Form_Index]) { items[ExtendedProperty_Form_Index] = _DatabaseCommon.Utility.StringToTuple(item.Form); } if (useColumn[ExtendedProperty_Group_Index]) { items[ExtendedProperty_Group_Index] = _DatabaseCommon.Utility.StringToTuple(item.Group); } if (useColumn[ExtendedProperty_Date_Index]) { items[ExtendedProperty_Date_Index] = _DatabaseCommon.Utility.TimestampToTuple(item.Date); } return(RecordTuple.From(items)); }
public static IPostgresTuple CreateExtendedRecordTupleFrom(global::FormABC.Input 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 (item.SubmissionURI != null) { if (useColumn[ExtendedProperty_SubmissionURI_Index]) { items[ExtendedProperty_SubmissionURI_Index] = new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(item.SubmissionURI); } } ; if (useColumn[ExtendedProperty_SubmissionID_Index]) { items[ExtendedProperty_SubmissionID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.SubmissionID); } if (useColumn[ExtendedProperty_BirthYear_Index]) { items[ExtendedProperty_BirthYear_Index] = _DatabaseCommon.Utility.IntegerToTuple(item.BirthYear); } if (useColumn[ExtendedProperty_NumberOfCars_Index]) { items[ExtendedProperty_NumberOfCars_Index] = _DatabaseCommon.Utility.IntegerToTuple(item.NumberOfCars); } return(RecordTuple.From(items)); }
public static IPostgresTuple CreateExtendedRecordTupleFrom(global::FormXYZ.Output 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 (item.SubmissionURI != null) { if (useColumn[ExtendedProperty_SubmissionURI_Index]) { items[ExtendedProperty_SubmissionURI_Index] = new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(item.SubmissionURI); } } ; if (useColumn[ExtendedProperty_SubmissionID_Index]) { items[ExtendedProperty_SubmissionID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.SubmissionID); } if (useColumn[ExtendedProperty_Rgflkj_Index]) { items[ExtendedProperty_Rgflkj_Index] = _DatabaseCommon.Utility.IntegerToTuple(item.Rgflkj); } if (useColumn[ExtendedProperty_XYZ_Index]) { items[ExtendedProperty_XYZ_Index] = _DatabaseCommon.Utility.DecimalToTuple(item.XYZ); } return(RecordTuple.From(items)); }
public static IPostgresTuple CreateExtendedRecordTupleFrom(global::UseCase1.FormList item, bool[] useColumn) { if (item == null) { return(null); } var items = new IPostgresTuple[ExtendedColumnCount]; if (useColumn[ExtendedProperty_URI_Index]) { items[ExtendedProperty_URI_Index] = new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(item.URI); } if (useColumn[ExtendedProperty_Name_Index]) { items[ExtendedProperty_Name_Index] = _DatabaseCommon.Utility.StringToTuple(item.Name); } if (useColumn[ExtendedProperty_Group_Index]) { items[ExtendedProperty_Group_Index] = _DatabaseCommon.Utility.StringToTuple(item.Group); } if (useColumn[ExtendedProperty_Status_Index]) { items[ExtendedProperty_Status_Index] = _DatabaseCommon.FactoryUseCase1_FormStatus.FormStatusConverter.CreateTupleFrom(item.Status); } if (useColumn[ExtendedProperty_SubmissionsCount_Index]) { items[ExtendedProperty_SubmissionsCount_Index] = _DatabaseCommon.Utility.IntegerToTuple(item.SubmissionsCount); } return(RecordTuple.From(items)); }
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 From(IPostgresTuple[] properties) { if (properties == null) return Null; if (properties.Length == 0) return Empty; return new RecordTuple(properties); }
public static IPostgresTuple CreateTupleFrom(global::Test.XYZ item) { if (item == null) { return(null); } var items = new IPostgresTuple[ColumnCount]; items[Property_ID_Index] = _DatabaseCommon.Utility.IntegerToTuple(item.ID); items[Property_From_Index] = _DatabaseCommon.Utility.StringToTuple(item.From); return(RecordTuple.From(items)); }
public static IPostgresTuple CreateTupleFrom(global::UseCase1.Entry item) { if (item == null) { return(null); } var items = new IPostgresTuple[ColumnCount]; items[Property_Description_Index] = _DatabaseCommon.Utility.StringToTuple(item.Description); items[Property_ColumnName_Index] = _DatabaseCommon.Utility.StringToTuple(item.ColumnName); items[Property_DataType_Index] = _DatabaseCommon.FactoryUseCase1_DataType.DataTypeConverter.CreateTupleFrom(item.DataType); return(RecordTuple.From(items)); }
public static IPostgresTuple CreateRecordTupleFrom(global::UseCase1.Submission 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 (item.CustomerURI != null) { if (useColumn[Property_CustomerURI_Index]) { items[Property_CustomerURI_Index] = new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(item.CustomerURI); } } ; if (useColumn[Property_CustomerID_Index]) { items[Property_CustomerID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.CustomerID); } if (item.FormURI != null) { if (useColumn[Property_FormURI_Index]) { items[Property_FormURI_Index] = new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(item.FormURI); } } ; if (useColumn[Property_FormID_Index]) { items[Property_FormID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.FormID); } if (useColumn[Property_Comments_Index]) { items[Property_Comments_Index] = _DatabaseCommon.Utility.StringToTuple(item.Comments); } if (useColumn[Property_Date_Index]) { items[Property_Date_Index] = _DatabaseCommon.Utility.TimestampToTuple(item.Date); } 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 IPostgresTuple Create <T>(T[] elements, Func <T, IPostgresTuple> converter) { if (elements == null) { return(null); } if (elements.Length == 0) { return(Empty); } var tuples = new IPostgresTuple[elements.Length]; for (int i = 0; i < elements.Length; i++) { tuples[i] = converter(elements[i]); } return(new ArrayTuple(tuples)); }
public static IPostgresTuple CreateExtendedRecordTupleFrom(global::Test.XYZ item, bool[] useColumn) { if (item == null) { return(null); } var items = new IPostgresTuple[ExtendedColumnCount]; if (useColumn[ExtendedProperty_ID_Index]) { items[ExtendedProperty_ID_Index] = _DatabaseCommon.Utility.IntegerToTuple(item.ID); } if (useColumn[ExtendedProperty_From_Index]) { items[ExtendedProperty_From_Index] = _DatabaseCommon.Utility.StringToTuple(item.From); } 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 string BuildTuple(this IPostgresTuple tuple, bool quote) { using (var cms = ChunkedMemoryStream.Create()) { var sw = cms.GetWriter(); if (quote) { sw.Write('\''); tuple.InsertRecord(sw, cms.SmallBuffer, string.Empty, EscapeQuote); sw.Write('\''); } else { tuple.InsertRecord(sw, cms.SmallBuffer, string.Empty, null); } sw.Flush(); cms.Position = 0; return(cms.GetReader().ReadToEnd()); } }
public static IPostgresTuple CreateExtendedTupleFrom(global::FormXYZ.Input item) { if (item == null) { return(null); } var items = new IPostgresTuple[ExtendedColumnCount]; items[ExtendedProperty_ID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.ID); if (item.SubmissionURI != null) { items[ExtendedProperty_SubmissionURI_Index] = new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(item.SubmissionURI); } ; items[ExtendedProperty_SubmissionID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.SubmissionID); items[ExtendedProperty_LastPurchase_Index] = _DatabaseCommon.Utility.TimestampToTuple(item.LastPurchase); items[ExtendedProperty_JKhdk_Index] = _DatabaseCommon.Utility.StringToTuple(item.JKhdk); items[ExtendedProperty_Qjfs_Index] = _DatabaseCommon.Utility.IntegerToTuple(item.Qjfs); return(RecordTuple.From(items)); }
public static IPostgresTuple CreateExtendedTupleFrom(global::FormABC.Output item) { if (item == null) { return(null); } var items = new IPostgresTuple[ExtendedColumnCount]; items[ExtendedProperty_ID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.ID); if (item.SubmissionURI != null) { items[ExtendedProperty_SubmissionURI_Index] = new Revenj.DatabasePersistence.Postgres.Converters.ValueTuple(item.SubmissionURI); } ; items[ExtendedProperty_SubmissionID_Index] = _DatabaseCommon.Utility.GuidToTuple(item.SubmissionID); items[ExtendedProperty_ABC_Index] = _DatabaseCommon.Utility.DecimalToTuple(item.ABC); items[ExtendedProperty_XYZ_Index] = _DatabaseCommon.Utility.DecimalToTuple(item.XYZ); items[ExtendedProperty_HasQQQ_Index] = _DatabaseCommon.Utility.BoolToTuple(item.HasQQQ); return(RecordTuple.From(items)); }
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('\''); }
public static IPostgresTuple Create <T>(IEnumerable <T> elements, Func <T, IPostgresTuple> converter) { if (elements == null) { return(null); } var count = elements.Count(); if (count == 0) { return(Empty); } var tuples = new IPostgresTuple[count]; var i = 0; foreach (var el in elements) { tuples[i++] = converter(el); } return(new ArrayTuple(tuples)); }
static ArrayTuple() { Empty = new EmptyArrayTuple(); Null = new NullTuple(); }
internal RecordTuple(IPostgresTuple[] properties) { this.Properties = properties; }
static RecordTuple() { Empty = new EmptyRecordTuple(); Null = new NullTuple(); }
static ValueTuple() { Empty = new EmptyValueTuple(); }
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(); } }