public void Test1()
{
var t1 = new Table("table_1");
var c1 = new Column("name", t1, null);
var c2 = new Column("city", t1, null);
var g = new Generator.PlugIn.BaseSqlGenerator.SqlGeneratorPlugin();
_columns.Add(c1);
_columns.Add(c2);
_tables.Add(t1);
Assert.AreEqual(
"SELECT table_1.name, table_1.city FROM table_1",
g.GetSql(_tables, _columns, _keyPairs)
);
}
public void Test5()
{
var orders = new Table("orders");
var products = new Table("products");
var number = new Column("number", orders, null);
var cost = new Column("price", products, "SUM");
var k1 = new KeyPair(products, "id", orders, "order_id");
var g = new Generator.PlugIn.BaseSqlGenerator.SqlGeneratorPlugin();
_columns.Add(number);
_columns.Add(cost);
_tables.Add(orders);
_tables.Add(products);
_keyPairs.Add(k1);
Assert.AreEqual(
"SELECT orders.number, SUM(products.price) FROM products JOIN orders ON products.order_id = orders.id GROUP BY orders.number",
g.GetSql(_tables, _columns, _keyPairs)
);
}
public void Test3()
{
var t1 = new Table("table_1");
var t2 = new Table("table_2");
var c1 = new Column("name", t1, null);
var c2 = new Column("city", t1, null);
var c3 = new Column("family_name", t2, null);
var k1 = new KeyPair(t2, "id", t1, "family_id");
var g = new Generator.PlugIn.BaseSqlGenerator.SqlGeneratorPlugin();
_columns.Add(c1);
_columns.Add(c2);
_columns.Add(c3);
_tables.Add(t1);
_tables.Add(t2);
_keyPairs.Add(k1);
Assert.AreEqual(
"SELECT table_1.name, table_1.city, table_2.family_name FROM table_2 JOIN table_1 ON table_2.family_id = table_1.id",
g.GetSql(_tables, _columns, _keyPairs)
);
}