/// <summary>
/// Genera el schema de la base de datos seleccionada y devuelve un objeto Database.
/// </summary>
public Database Process(MySqlOption filters)
{
Database databaseSchema = new Database();
GenerateTables tables = new GenerateTables(connectioString, filters);
tables.OnTableProgress += new Progress.ProgressHandler(tables_OnTableProgress);
databaseSchema.Tables = tables.Get(databaseSchema);
return(databaseSchema);
}
public void QuerySelect()
{
var option = new MySqlOption();
var query = queryBuilder.Build(Query.From <Students>());
Assert.AreEqual("select * from `Students`", query.SQL);
var q = queryBuilder.Build(Query.From <Students>().Select(t => t.Id));
Assert.AreEqual("select `Students`.`Id` from `Students`", q.SQL);
var query2 = queryBuilder.Build(Query.From <Peoples, Students>().Select((p, s) => new { p.Id, s.ClassId }));
Assert.AreEqual("select `Peoples`.`Id` as Id,`Students`.`ClassId` as ClassId from `Peoples`,`Students`", query2.SQL);
var query3 = queryBuilder.Build(Query.From <Peoples, Students, Teachers>().Select((p, s, t) => new { p.Id, s.ClassId, s.School, t.Job }));
Assert.AreEqual("select `Peoples`.`Id` as Id,`Students`.`ClassId` as ClassId,`Students`.`School` as School,`Teachers`.`Job` as Job from `Peoples`,`Students`,`Teachers`", query3.SQL);
var query4 = queryBuilder.Build(Query.From <Peoples>().Select((p) => new[] { nameof(Peoples.Age), nameof(Peoples.Id) }));
Assert.AreEqual("select `Age`,`Id` from `Peoples`", query4.SQL);
}
/// <summary>
/// Constructor de la clase.
/// </summary>
/// <param name="connectioString">Connection string de la base</param>
public GenerateTables(string connectioString, MySqlOption filter)
{
this.connectioString = connectioString;
this.tableFilter = filter;
}
/// <summary>
/// Constructor de la clase.
/// </summary>
/// <param name="connectioString">Connection string de la base</param>
public GenerateConstraint(string connectioString, MySqlOption filter)
{
this.connectioString = connectioString;
}
