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;
}
