示例#1
0
        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('\'');
        }
示例#2
0
        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('\'');
        }
示例#3
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();
            }
        }