public async Task Setup() { Host = "databank.c9mrseu2nxwi.us-east-1.rds.amazonaws.com"; var ignore = new Ignore(); Username = ignore.Username; Password = ignore.Password; Database = ignore.Database; Port = 5432; LoginInfo = new SqlToolAuthenticationInformation(Host, Username, Password, Database, Port); var sqlToolAuthenticationInformation = new SqlToolAuthenticationInformation(); var connectionString = sqlToolAuthenticationInformation.GetPostgresConnectionString(); setupInsertRepo = new InsertRepository(); selectKeysList = new List <string>(new string[] { "firstname", "lastname", "email", "created_date", "address", "city", "state", "zip" }); selectValuesList = new List <string>(new string[] { "Tyler", "Durden", "*****@*****.**", "420 Paper St.", "Wilmington", "DE", "19886" }); verifyUpdateValuesList = new List <string>(new string[] { "Brad", "Pitt", "*****@*****.**", "8/18/1980 12:00:00 AM" }); await setupInsertRepo.Command(connString, "Insert into people (firstname, lastname, email, created_date) values ('Robert', 'Paulson', '*****@*****.**', current_timestamp)"); await setupInsertRepo.Command(connString, "Insert into people (firstname, lastname, email, created_date) values ('Tyler', 'Durden', '*****@*****.**', current_timestamp)"); await setupInsertRepo.Command(connString, "Insert into address (pid, address, city, state, zip, created_on) " + " values ((select id from people where email = '*****@*****.**'), '420 Paper St.', 'Wilmington', 'DE', '19886', current_timestamp)"); await setupInsertRepo.Command(connString, "Insert into people (firstname, lastname, email, created_date) values ('Edward', 'Norton', '*****@*****.**', current_timestamp)"); }
public static string AskUserForAuthenticationInformation() { InitialUserPrompts(); var sqlToolAuthenticationInfo = new SqlToolAuthenticationInformation(); return(sqlToolAuthenticationInfo.GetPostgresConnectionString()); }