public static KeyValuePair <PostgresProxy, string> getThirdAction() { var thirdPostgresConnection = new PostgresProxy("localhost", "5432", "postgres", "69916010", "Account"); var insertForThird = "UPDATE accounts SET amount = amount - 6"; return(new KeyValuePair <PostgresProxy, string>(thirdPostgresConnection, insertForThird)); }
public static KeyValuePair <PostgresProxy, string> getSecondAction() { var secondPostgresConnection = new PostgresProxy("localhost", "5432", "postgres", "69916010", "HotelBooking"); var insertForSecond = queryBuilder.GetInsertScript("HotelBooking", new List <string>() { "clientname", "hotelname", "arrival", "departure" }, new List <string>() { "Jambo", "Nadia", "2017-08-04", "2017-10-01" }); return(new KeyValuePair <PostgresProxy, string>(secondPostgresConnection, insertForSecond)); }
public static KeyValuePair <PostgresProxy, string> getFirstAction() { var firstPostgresProxy = new PostgresProxy("localhost", "5432", "postgres", "69916010", "FlyBooking"); var insertForFirst = queryBuilder.GetInsertScript("flybooking", new List <string>() { "clientname", "flynumber", @"""From""", @"""To""", @"""Date""" }, new List <string>() { "Jambo", "Tup 12", "Madrid", "Barcelona", "2017-07-01" }); return(new KeyValuePair <PostgresProxy, string>(firstPostgresProxy, insertForFirst)); }