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));
        }
Exemple #4
0
        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));
        }
Exemple #5
0
        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));
        }
Exemple #8
0
        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));
        }
Exemple #9
0
		public static IPostgresTuple From(IPostgresTuple[] properties)
		{
			if (properties == null)
				return Null;
			if (properties.Length == 0)
				return Empty;
			return new RecordTuple(properties);
		}
Exemple #10
0
        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));
        }
Exemple #11
0
        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));
        }
Exemple #13
0
        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));
        }
Exemple #14
0
        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));
        }
Exemple #15
0
        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('\'');
        }
Exemple #17
0
 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));
        }
Exemple #19
0
        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('\'');
        }
Exemple #21
0
        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));
        }
Exemple #22
0
 static ArrayTuple()
 {
     Empty = new EmptyArrayTuple();
     Null  = new NullTuple();
 }
Exemple #23
0
		internal RecordTuple(IPostgresTuple[] properties)
		{
			this.Properties = properties;
		}
Exemple #24
0
		static RecordTuple()
		{
			Empty = new EmptyRecordTuple();
			Null = new NullTuple();
		}
Exemple #25
0
 static ValueTuple()
 {
     Empty = new EmptyValueTuple();
 }
Exemple #26
0
 static RecordTuple()
 {
     Empty = new EmptyRecordTuple();
     Null  = new NullTuple();
 }
Exemple #27
0
        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();
            }
        }
Exemple #28
0
		static ValueTuple()
		{
			Empty = new EmptyValueTuple();
		}