/// <summary> /// 同步模型结构到数据库 /// </summary> /// <param name="modelType"></param> public static void SyncModelToDb(Type modelType) { var createSql = GetCreateSql(modelType); var dropSql = $"DROP TABLE IF EXISTS `{GetTableName(modelType)}`;"; var sql = string.Concat(dropSql, Environment.NewLine, createSql); BaseDbService.Execute(sql); }
public static Tuple <List <string>, List <string> > GetClass() { var assembly = typeof(Account).Assembly; var toCreateModels = new List <string>(); var existModels = new List <string>(); var existList = BaseDbService.Query <string>("show tables"); foreach (var type in assembly.GetExportedTypes()) { if (type.IsEnum) { continue; } if (type.IsInterface) { continue; } if (!type.FullName.Contains(packageName)) { continue; } var name = GetTableName(type); if (existList.Contains(name)) { existModels.Add(type.FullName); } else { toCreateModels.Add(type.FullName); } } existModels.Sort(); toCreateModels.Sort(); return(Tuple.Create(existModels, toCreateModels)); }