コード例 #1
0
        protected override void CleanUp()
        {
            using (var conn = new AutoCheck.Core.Connectors.Postgres(_HOST, _ADMIN, _ADMIN, _ADMIN)){ //default BBDD postgres can be used to user management
                foreach (string user in new string[] {
                    "createuser_user1",
                    "createuser_user2",
                    "createuser_user3",
                    "createuser_user4",
                    "existuser_user1",
                    "existuser_user2",
                    "dropuser_user1",
                    "dropuser_user2",
                    "existrole_role1",
                    "existrole_role2",
                    "createrole_role1",
                    "createrole_role2",
                    "droprole_role1",
                    "droprole_role2",
                    "permissionmanagement_role1",
                    "permissionmanagement_user1"
                })
                {
                    try{ conn.ExecuteNonQuery(string.Format("REASSIGN OWNED BY {0} TO postgres", user)); } catch {}
                    try{ conn.ExecuteNonQuery(string.Format("DROP OWNED BY {0}", user)); } catch {}
                    try{ conn.ExecuteNonQuery(string.Format("DROP USER {0}", user)); } catch {}
                }
            }

            Connectors.Clear();
        }