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>(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(); } }