public void GetAndCreateTest()
{
GeneratorSettings generatorSettings = new GeneratorSettings();
UniqueNamer uniqueNamer = new UniqueNamer();
TemplateContent templateContent = new TemplateContent(generatorSettings, uniqueNamer);
AbpDbContentTemplate abpDbContentTemplate = new AbpDbContentTemplate(templateContent);
MySQLSchemaProvider mySqlSchemaProvider = new MySQLSchemaProvider();
const string mysqlConn = "Server=127.0.0.1;Database=esms;Uid=root;Pwd=123qwe!@#;";
SchemaSelector schemaSelector = new SchemaSelector(mySqlSchemaProvider, mysqlConn);
foreach (TableSchema tableSchema in schemaSelector.Tables)
{
foreach (DataObjectBase columnSchema in tableSchema.Columns)
{
Console.WriteLine(columnSchema.FullName);
}
}
//EntityContext<AbpEntity, AbpEntityProperty> entityContext = abpDbContentTemplate.GetAndCreate(schemaSelector);
//Entity<AbpEntityProperty> entity = entityContext.Entities.First(t => t.ClassName == "SysUser");
//foreach (Relationship relationship in entity.Relationships.Where(t=>t.ThisEntity.Contains("SysUser")&&t.ThisPropertyName=="LastRole"))
//{
// Console.WriteLine(relationship.JoinTable);
//}
}
public void GenerateTest()
{
GeneratorSettings generatorSettings = new GeneratorSettings();
MySQLSchemaProvider mySqlSchemaProvider = new MySQLSchemaProvider();
const string mysqlConn = "Server=127.0.0.1;Database=yt_qd_ytsf;Uid=root;Pwd=123qwe!@#;";
SchemaSelector schemaSelector = new SchemaSelector(mySqlSchemaProvider, mysqlConn);
Generator generator = new Generator();
generator.Settings.TableNaming = generatorSettings.TableNaming;
generator.Settings.EntityNaming = generatorSettings.EntityNaming;
generator.Settings.RelationshipNaming = generatorSettings.RelationshipNaming;
generator.Settings.ContextNaming = generatorSettings.ContextNaming;
EntityContext entityContext = generator.Generate(schemaSelector);
foreach (Entity entity in entityContext.Entities)
{
Property property =
entity.Properties.FirstOrDefault(
t => (t.IsPrimaryKey.HasValue && t.IsPrimaryKey.Value) && (t.IsIdentity.HasValue && t.IsIdentity.Value));
Console.WriteLine(entity.ClassName + " --- " + (property != null ? property.PropertyName : ""));
}
}
