public void MetaParametersTest() { MySqlDataset target = CreateTarget(); Parameter p = target.StoredProcedures["GraywulfSchemaTest", "", "spTest"].Parameters["hello"]; //Parameter p = sp.Parameters["hello"]; Assert.IsTrue(p.Metadata.Summary == "spTestComment"); }
private MySqlDataset CreateTestDataset() { var csb = new MySqlConnectionStringBuilder(Jhu.Graywulf.Schema.Test.AppSettings.MySqlConnectionString); var ds = new MySqlDataset(Jhu.Graywulf.Test.Constants.TestDatasetName, csb.ConnectionString) { DatabaseName = csb.Database }; return(ds); }
protected override DatasetBase LoadDataset(string datasetName) { string key = String.Format("{0}{1}", prefix, datasetName); MySqlDataset ds = new MySqlDataset( datasetName, ConfigurationManager.ConnectionStrings[key].ConnectionString); return ds; }
public void MetaObjectsTest() { MySqlDataset target = CreateTarget(); Table t1 = target.Tables["GraywulfSchemaTest", "", "Book"]; Assert.IsTrue(t1.Metadata.Summary == "this is my own table comment"); Table t2 = target.Tables["GraywulfSchemaTest", "", "Author"]; Assert.IsTrue(t2.Metadata.Summary == ""); }
public void MetaColumnsTest() { MySqlDataset target = CreateTarget(); Table t1 = target.Tables["GraywulfSchemaTest", "", "Book"]; Column c1 = t1.Columns["ID"]; Assert.IsTrue(c1.Metadata.Summary == "id of user"); Table t2 = target.Tables["GraywulfSchemaTest", "", "Author"]; Column c2 = t2.Columns["ID"]; Assert.IsTrue(c2.Metadata.Summary == ""); }
public void TableColumnsDataTypeTest() { MySqlDataset target = CreateTarget(); //Get a single table Table t1 = target.Tables["GraywulfSchemaTest", "", "SampleData"]; Assert.IsTrue(t1.Columns.Count == 39); Assert.IsTrue(t1.Columns["column_bool"].DataType.Name == "tinyint"); Assert.IsTrue(t1.Columns["column_tinyint"].DataType.Name == "tinyint"); Assert.IsTrue(t1.Columns["column_smallint"].DataType.Name == "smallint"); Assert.IsTrue(t1.Columns["column_mediumint"].DataType.Name == "bigint"); Assert.IsTrue(t1.Columns["column_integer"].DataType.Name == "int"); Assert.IsTrue(t1.Columns["column_bigint"].DataType.Name == "bigint"); Assert.IsTrue(t1.Columns["column_int"].DataType.Name == "int"); Assert.IsTrue(t1.Columns["column_float"].DataType.Name == "float"); Assert.IsTrue(t1.Columns["column_double"].DataType.Name == "real"); Assert.IsTrue(t1.Columns["column_decimal"].DataType.Name == "decimal"); Assert.IsTrue(t1.Columns["column_date"].DataType.Name == "date"); Assert.IsTrue(t1.Columns["column_datetime"].DataType.Name == "datetime"); Assert.IsTrue(t1.Columns["column_year"].DataType.Name == "tinyint"); Assert.IsTrue(t1.Columns["column_time"].DataType.Name == "time"); Assert.IsTrue(t1.Columns["column_timestamp"].DataType.Name == "timestamp"); Assert.IsTrue(t1.Columns["column_tinytext"].DataType.Name == "text"); Assert.IsTrue(t1.Columns["column_text"].DataType.Name == "text"); Assert.IsTrue(t1.Columns["column_mediumtext"].DataType.Name == "text"); Assert.IsTrue(t1.Columns["column_longtext"].DataType.Name == "text"); Assert.IsTrue(t1.Columns["column_tinyblob"].DataType.Name == "nvarchar"); Assert.IsTrue(t1.Columns["column_blob"].DataType.Name == "nvarchar"); Assert.IsTrue(t1.Columns["column_mediumblob"].DataType.Name == "nvarchar"); Assert.IsTrue(t1.Columns["column_longblob"].DataType.Name == "nvarchar"); Assert.IsTrue(t1.Columns["column_bit"].DataType.Name == "bit"); Assert.IsTrue(t1.Columns["column_set"].DataType.Name == "nvarchar"); Assert.IsTrue(t1.Columns["column_enum"].DataType.Name == "nvarchar"); Assert.IsTrue(t1.Columns["column_binary"].DataType.Name == "binary"); Assert.IsTrue(t1.Columns["column_varbinary"].DataType.Name == "varbinary"); Assert.IsTrue(t1.Columns["column_geometry"].DataType.Name == "nvarchar"); Assert.IsTrue(t1.Columns["column_char"].DataType.Name == "char"); Assert.IsTrue(t1.Columns["column_nchar"].DataType.Name == "char"); Assert.IsTrue(t1.Columns["column_varchar"].DataType.Name == "varchar"); Assert.IsTrue(t1.Columns["column_nvarchar"].DataType.Name == "varchar"); Assert.IsTrue(t1.Columns["column_real"].DataType.Name == "real"); //Test cache Assert.AreEqual(t1.Columns, target.Tables["GraywulfSchemaTest", "", "SampleData"].Columns); Assert.AreEqual(t1.Columns["column_tinyint"], target.Tables["GraywulfSchemaTest", "", "SampleData"].Columns["column_tinyint"]); }
protected override IEnumerable<KeyValuePair<string, DatasetBase>> LoadAllDatasets() { foreach (ConnectionStringSettings s in ConfigurationManager.ConnectionStrings) { if (s.Name.StartsWith(prefix)) { string name = s.Name.Substring(prefix.Length); MySqlDataset ds = new MySqlDataset( name, s.ConnectionString); yield return new KeyValuePair<string, DatasetBase>(name, ds); } } }
private MySqlDataset CreateTestDataset() { var csb = new MySqlConnectionStringBuilder(Jhu.Graywulf.Schema.Test.AppSettings.MySqlConnectionString); var ds = new MySqlDataset(Jhu.Graywulf.Test.Constants.TestDatasetName, csb.ConnectionString) { DatabaseName = csb.Database }; return ds; }