Example #1
0
        public async Task <IResponseEntity> InitDb(DbConnectItem req)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append("<ul>");
            sb.Append("<li>创建数据连接对象 开始</li>");

            var      dbType  = (FreeSql.DataType)Enum.Parse(typeof(FreeSql.DataType), req.DbType);
            var      connStr = req.ConnectionString;
            IFreeSql fsql    = new FreeSqlBuilder()
                               .UseConnectionString(dbType, connStr)
                               .UseAutoSyncStructure(true)               //自动同步实体结构【开发环境必备】
                               .Build();
            DbConnection dbConnection = fsql.Ado.MasterPool.Get().Value; // 这儿验证 连接是否成功,这句代码可以不要,如果连接字符不变正确,为了提早发现(报异常)

            fsql.Aop.AuditValue += SyncDataAuditValue;

            sb.Append("<li>创建数据连接对象 结束</li>");

            sb.Append("<li>创建数据库结构及初始化数据 开始</li>");
            using (var uow = fsql.CreateUnitOfWork())
                using (var tran = uow.GetOrBeginTransaction())
                {
                    SeedDataEntity data = (new SeedData()).GetSeedData();
                    sb.Append("<ul>");
                    await InitDtData(fsql, data.SysApiEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysConditionEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysDictionaryEntryEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysDictionaryHeaderEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysConfigEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysGroupEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysPermissionEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysResourceEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysRoleEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysRPermissionConditionEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysRPermissionRoleEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysRResourceApiEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysRRoleResourceEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysSettingEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysUserEntities.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysLoginLogEntities?.ToArray(), tran, sb);
                    await InitDtData(fsql, data.SysOperationLogEntities?.ToArray(), tran, sb);

                    sb.Append("</ul>");
                    uow.Commit();
                }

            sb.Append("<li>创建数据库结构及初始化数据 结束</li>");
            sb.Append("</ul>");

            fsql.Dispose();

            return(ResponseEntity.Ok("初始化成功", msg: sb.ToString()));
        }
Example #2
0
        public IResponseEntity GenerateSeedData(DbConnectItem req)
        {
            var      dbType  = (FreeSql.DataType)Enum.Parse(typeof(FreeSql.DataType), req.DbType);
            var      connStr = req.ConnectionString;
            IFreeSql fsql    = new FreeSqlBuilder()
                               .UseConnectionString(dbType, connStr)
                               .Build();
            var seedData = new SeedData();

            seedData.GenerateSeedData(fsql);
            return(ResponseEntity.Ok("种子数据生成成功"));
        }
Example #3
0
        public IResponseEntity TestDbConnect(DbConnectItem req)
        {
            try
            {
                var      dbType  = (FreeSql.DataType)Enum.Parse(typeof(FreeSql.DataType), req.DbType);
                var      connStr = req.ConnectionString;
                IFreeSql fsql    = new FreeSql.FreeSqlBuilder()
                                   .UseConnectionString(dbType, connStr)
                                   .Build();

                // 这儿验证 连接是否成功
                //var a = fsql.DbFirst.GetDatabases();
                //Fsql.Ado.MasterPool.Get().Value
                DbConnection dbConnection = fsql.Ado.MasterPool.Get().Value;

                fsql.Dispose();

                return(ResponseEntity.Ok("连接成功"));
            }
            catch (Exception ex)
            {
                return(ResponseEntity.Error(ex.Message));
            }
        }