/// <summary> /// 批量删除 /// </summary> /// <remarks>按主键数据作为查询依据</remarks> /// <param name="domainModel">领域模型</param> /// <param name="domainObject">领域对象</param> /// <param name="dataID">主键数据</param> /// <param name="shardingKeyValue">分库分表键值对</param> /// <returns>删除SQL</returns> public void DeleteByIDs(DomainModel.Spi.DomainModel domainModel, DomainModel.Spi.DomainObject domainObject, IEnumerable <string> dataIDs, ShardingValue shardingKeyValue = null) { if (domainModel == null) { throw new ArgumentNullException("DataDeleteService.DeleteByID.domainModel"); } if (domainObject == null) { throw new ArgumentNullException("DataDeleteService.DeleteByID.domainObject"); } if (dataIDs == null || dataIDs.Count() == 0) { throw new ArgumentNullException("DataDeleteService.DeleteByID.dataIDs"); } var sqlList = new SqlStatementCollection(); foreach (var dataID in dataIDs) { var sqls = SQLBuilderFactory.CreateSQLBuilder().ParseDeleteSqlByID(domainModel, domainObject, dataID, shardingKeyValue); sqlList.AddRange(sqls); } var db = DatabaseFactory.CreateDefaultDatabase(); db.ExecuteSQLWithTransaction(sqlList); }
/// <summary> /// 根据已经解析的SqlSchema,解析生成带数据的Update语句。 /// </summary> /// <param name="sqlSchemata">已经解析的SqlSchema。</param> /// <param name="domainModel">领域对象</param> /// <param name="context">数据上下文</param> /// <returns>Insert语句集合</returns> private SqlStatementCollection ParseUpdateSqlDetail(SqlStatementCollection sqlSchemata, DomainModel.Spi.DomainModel domainModel, DomainModel.Spi.DomainObject domainObject, DataContext dataContext, Dictionary<string, ShardingTarget> routeInfo) { var result = new SqlStatementCollection(); if (!dataContext.Data.ContainsKey(domainObject.ID)) { return result; } var data = dataContext.Data[domainObject.ID]; if (data == null || data.Count == 0) return result; var strategy = new UpdateSqlBuildStrategy(); for (int i = 0; i < dataContext.Data[domainObject.ID].Count; i++) { dataContext.CurrentDataIndex = i; var context = new SqlBuildingContext(domainModel, domainObject, SQLBuilderUtils.GetCurrentDbType(), dataContext); context.RouteInfo = routeInfo; var rowSqls = new SqlStatementCollection(); var sqls = sqlSchemata.Where(s => s.SqlBuildingInfo.CurrentNode.ID == domainObject.ID).ToList(); rowSqls.AddRangeClone(sqls); strategy.BuildTableSqlDetail(rowSqls, context); result.AddRange(rowSqls); } return result; }
/// <summary> /// 保存领域模型数据 /// </summary> /// <param name="domainModel">领域模型</param> /// <param name="instanceList">对象实例集合</param> /// <param name="shardingValueList">分区分表键值对集合</param> public void SaveBatch(DomainModel.Spi.DomainModel domainModel, List <object> instanceList, List <ShardingValue> shardingValueList = null) { if (domainModel == null) { throw new ArgumentNullException("SaveService.Save.domainModel"); } if (instanceList == null) { throw new ArgumentNullException("SaveService.Save.instanceList"); } var sqls = new SqlStatementCollection(); for (int i = 0; i < instanceList.Count; i++) { var currentObj = instanceList[i]; ShardingValue shardingValue = null; if (shardingValueList != null) { shardingValue = shardingValueList[i]; } var sqlstatements = SQLBuilderFactory.CreateSQLBuilder().ParseInsertSql(domainModel, currentObj, shardingValue); sqls.AddRange(sqlstatements); } var db = DatabaseFactory.CreateDefaultDatabase(); db.ExecuteSQLWithTransaction(sqls); }
private void ParseDeleteSqlDetail(SqlStatementCollection sqlSchemata, SqlStatementCollection result, DomainModel.Spi.DomainModel domainModel, DomainModel.Spi.DomainObject domainObject, DataContext dataContext, Dictionary <string, ShardingTarget> routeInfo) { //构造SQL语句的条件 var strategy = new DeleteSqlBuildStrategy(); var context = new SqlBuildingContext(domainModel, domainObject, domainObject.DataObject.DataSource.DbType, dataContext); context.RouteInfo = routeInfo; var rowSqls = new SqlStatementCollection(); var sqls = sqlSchemata.Where(s => s.SqlBuildingInfo.CurrentNode.ID == domainObject.ID).ToList(); rowSqls.AddRangeClone(sqls); strategy.BuildTableSqlDetail(rowSqls, context); result.AddRange(rowSqls); //递归处理子对象 if (domainObject.ChildDomainObjects.Count == 0) { return; } foreach (var childModelObject in domainObject.ChildDomainObjects) { ParseDeleteSqlDetail(sqlSchemata, result, domainModel, childModelObject, dataContext, routeInfo); } }
/// <summary> /// 根据已经解析的SqlSchema,解析生成带数据的Update语句。 /// </summary> /// <param name="sqlSchemata">已经解析的SqlSchema。</param> /// <param name="domainModel">领域对象</param> /// <param name="context">数据上下文</param> /// <returns>Insert语句集合</returns> private SqlStatementCollection ParseUpdateSqlDetail(SqlStatementCollection sqlSchemata, DomainModel.Spi.DomainModel domainModel, DataContext context, Dictionary<string, ShardingTarget> routeInfo) { var result = new SqlStatementCollection(); foreach (var node in domainModel.DomainObjects) { var data = context.Data[node.ID]; if (data == null || data.Count == 0) continue; context.ResetCurrentDataIndex(); var nodeSqls = ParseUpdateSqlDetail(sqlSchemata, domainModel, node, context, routeInfo); result.AddRange(nodeSqls); } return result; }
/// <summary> /// 构造查询SQL语句的主干结构 /// </summary> /// <param name="dataObject">数据对象</param> /// <returns>查询SQL语句的主干结构</returns> private void ParseDeleteSqlSchema(SqlStatementCollection sqlSchemata, DomainModel.Spi.DomainModel domainModel, DomainModel.Spi.DomainObject domainObject, Dictionary<string, ShardingTarget> routeInfo, DataContext dataContext) { var selectStrategy = new DeleteSqlBuildStrategy(); var context = new SqlBuildingContext(domainModel, domainObject, SQLBuilderUtils.GetCurrentDbType(), dataContext); context.RouteInfo = routeInfo; var nodeSqlSchemata = selectStrategy.BuildTableSqlSchema(context); sqlSchemata.AddRange(nodeSqlSchemata); //递归处理子对象 if (domainObject.ChildDomainObjects.Count == 0) return; foreach (var childModelObject in domainObject.ChildDomainObjects) { ParseDeleteSqlSchema(sqlSchemata, domainModel, childModelObject, routeInfo, dataContext); } }
/// <summary> /// 解析生成Insert语句的主干部分。 /// </summary> /// <param name="sqlSchemata">Insert语句的主干。</param> /// <param name="co">通用中间对象。</param> /// <param name="node">通用中间对象的节点。</param> /// <returns>Insert语句的主干部分。</returns> private void ParseInsertSqlSchema(SqlStatementCollection sqlSchemata, DomainModel.Spi.DomainModel domainModel, DomainModel.Spi.DomainObject domainObject, Dictionary <string, ShardingTarget> routeInfo) { var insertStrategy = new InsertSqlBuildStrategy(); var context = new SqlBuildingContext(domainModel, domainObject, domainObject.DataObject.DataSource.DbType); context.RouteInfo = routeInfo; var nodeSqlSchemata = insertStrategy.BuildTableSqlSchema(context); sqlSchemata.AddRange(nodeSqlSchemata); //递归处理子对象 if (context.Node.ChildDomainObjects.Count == 0) { return; } foreach (var childModelObject in context.Node.ChildDomainObjects) { ParseInsertSqlSchema(sqlSchemata, domainModel, childModelObject, routeInfo); } }
/// <summary> /// 解析生成Insert语句的主干部分。 /// </summary> /// <param name="sqlSchemata">Insert语句的主干。</param> /// <param name="co">通用中间对象。</param> /// <param name="node">通用中间对象的节点。</param> /// <returns>Insert语句的主干部分。</returns> private void ParseUpdateSqlSchema(SqlStatementCollection sqlSchemata, DomainModel.Spi.DomainModel domainModel, DomainModel.Spi.DomainObject domainObject, Dictionary <string, ShardingTarget> routeInfo, DataContext dataContext) { var updateStrategy = new UpdateSqlBuildStrategy(); var context = new SqlBuildingContext(domainModel, domainObject, domainObject.DataObject.DataSource.DbType); context.RouteInfo = routeInfo; if (dataContext.GetCurrentDataContextItem(domainObject.ID) != null) { var nodeSqlSchemata = updateStrategy.BuildTableSqlSchema(context); sqlSchemata.AddRange(nodeSqlSchemata); } //递归处理子对象 if (context.Node.ChildDomainObjects.Count == 0) { return; } foreach (var childModelObject in context.Node.ChildDomainObjects) { ParseUpdateSqlSchema(sqlSchemata, domainModel, childModelObject, routeInfo, dataContext); } }