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