Esempio n. 1
0
        public void ConnectTest()
        {
            var server = Utility.LoadServers("TestData/servers.yml")["pgsql"];
            var sql    = new PgSql(server, false);
            var res    = sql.Connect();

            Assert.True(res);
        }
Esempio n. 2
0
        public void QueryTest()
        {
            var server = Utility.LoadServers("TestData/servers.yml")["pgsql"];
            var db     = Utility.LoadDataBase("TestData/pgsql.yml");

            var sql   = new PgSql(server, false);
            var res   = sql.Connect();
            var query = sql.Query(db);

            _output.WriteLine(query);
            Assert.False(string.IsNullOrWhiteSpace(query));
        }
Esempio n. 3
0
        public void ReCreateTest()
        {
            var server = Utility.LoadServers("TestData/servers.yml")["pgsql"];
            var db     = Utility.LoadDataBase("TestData/pgsql.yml");

            var sql = new PgSql(server, false);

            sql.Connect();
            var result = sql.ReCreate(db, false);

            _output.WriteLine(result.Query);
            Assert.True(result.Success);
        }
Esempio n. 4
0
        public void DiffTest()
        {
            var server = Utility.LoadServers("TestData/servers.yml")["pgsql"];
            var db     = Utility.LoadDataBase("TestData/pgsql.yml");


            var sql = new PgSql(server, false);
            var res = sql.Connect();

            sql.ReCreate(db, false);
            Utility.TrimDataBaseProperties(db);
            var diff = sql.Diff(db);

            Assert.False(diff.HasDiff);
        }
Esempio n. 5
0
        public void ExtractTest()
        {
            var server = Utility.LoadServers("TestData/servers.yml")["pgsql"];
            var db     = Utility.LoadDataBase("TestData/pgsql.yml");
            var sql    = new PgSql(server, false);
            var res    = sql.Connect();

            sql.ReCreate(db, false);

            var extract = sql.Extract();
            var yaml    = Utility.DataBaseToYaml(extract);

            _output.WriteLine(yaml);
            Assert.NotEmpty(db.Tables);
        }