/// <summary> /// SheetからEntityTableへの変換 /// </summary> /// <param name="sheet">対象シート</param> /// <returns>変換したEntityTable</returns> /// <remarks> /// Excel格納情報 (列,行)表記 /// ( 2, 2) テーブル物理名(値は文字列) /// ( 2, 3) テーブル論理名(値は文字列) /// 以下フィールド情報。5行目はヘッダー、6行目から空白値まで値 /// ( 1, 6) フィールドNoの開始位置(値は数値) /// ( 2, 6) フィールド物理名の開始位置(値は文字列) /// ( 3, 6) フィールド論理名の開始位置(値は文字列) /// ( 4, 6) フィールドコメントの開始位置(値は文字列) /// ( 5, 6) フィールド型の開始位置(値は文字列) /// ( 6, 6) フィールドサイズの開始位置(値は数値) /// ( 7, 6) フィールドNull制約有無の開始位置(値は〇 or 空白) /// ( 8, 6) フィールドデフォルト値の開始位置(値は文字列) /// ( 9, 6) フィールド主キーの開始位置(値は〇 or 空白) /// /// </remarks> private EntityTable ConvertSheetToEntityTable(ExcelObject sheet) { var newEntityTable = new EntityTable { PhysicsName = sheet["B2"], LogicName = sheet["B3"] }; var fields = new List <EntityField>(); for (int cnt = 0; cnt < 65535; cnt++) { var row = (cnt + 6).ToString(); // フィールドのNo値が空白の場合、処理を抜ける if (string.IsNullOrEmpty(sheet["A" + row])) { break; } var field = new EntityField(); field.No = intParseEx(sheet["A" + row]); field.PhysicsName = sheet["B" + row]; field.LogicName = sheet["C" + row]; //field.Comment = sheet["D" + row]; field.FieldType = SqlServerConfiguration.ConvertFieldTypeToString(sheet["E" + row]); field.FieldSize = sheet["F" + row] == "" ? 0 : intParseEx(sheet["F" + row]); field.Nullable = sheet["G" + row] == "〇" ? true : false; field.Required = sheet["H" + row] == "〇" ? true : false; fields.Add(field); } newEntityTable.Fields = fields; return(newEntityTable); }
public void x(string connectionString) { var sqlServerConfiguration = new SqlServerConfiguration(connectionString); ScenarioContext.Current.Set(sqlServerConfiguration); DatabaseSteps.ClearTheEventStore(); }
public void Configure(string collectorName, XElement configElement, ISystemMetricsService systemMetrics) { _systemMetrics = systemMetrics; var config = new SqlServerConfiguration(configElement.Attribute("connectionString").Value, configElement.ToInt("writeBatchSize")); _connectionString = config.ConnectionString; _collectorName = collectorName; _retries = config.Retries; InitialiseRetryHandling(); _batchBlock = new BatchBlock <GraphiteLine>(config.WriteBatchSize); _actionBlock = new ActionBlock <GraphiteLine[]>(p => SendToDB(p), new ExecutionDataflowBlockOptions { MaxDegreeOfParallelism = 1 }); _batchBlock.LinkTo(_actionBlock); _batchBlock.Completion.ContinueWith(p => _actionBlock.Complete()); _actionBlock.Completion.ContinueWith(p => { IsActive = false; }); Completion = new Task(() => { _log.Info("SqlServerBackend - Completion has been signaled. Waiting for action block to complete."); _batchBlock.Complete(); _actionBlock.Completion.Wait(); }); }
public SqlServerConfigurationForm(SqlServerConfiguration config) { this.InitializeComponent(); if (config != null) { this.rbWindowsAuth.Checked = config.UseWindowsAuthentication; this.rbSqlServerAuth.Checked = !config.UseWindowsAuthentication; this.tbServerName.Text = config.ServerName; this.chbSavePassword.Checked = config.SavePassword; if (!config.UseWindowsAuthentication) { this.tbUsername.Text = config.Username; this.tbPassword.Text = config.Password; } if (!string.IsNullOrEmpty(config.DatabaseName)) { this.rbDatabaseName.Checked = true; this.cmbDatabaseName.Text = config.DatabaseName; } else if (!string.IsNullOrEmpty(config.AttachDatabaseFileName)) { this.rbDatabaseFile.Checked = true; this.tbAttachDatabaseFileName.Text = config.AttachDatabaseFileName; this.tbAttachDatabaseLogicalName.Text = config.LogicalName; } else { this.rbDatabaseName.Checked = true; } } else { this.rbWindowsAuth.Checked = this.rbDatabaseName.Checked = true; } }
protected DataAccessModelConfiguration CreateSqlServerConfiguration(string databaseName) { DataAccessModelConfiguration retval; var connectionString = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_CONNECTIONSTRING"); if (connectionString == null) { var host = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_HOST") ?? ".\\SQLEXPRESS"; var userName = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_USERNAME"); var password = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_PASSWORD"); retval = SqlServerConfiguration.Create(databaseName, host, userName: userName, password: password, multipleActiveResultsets: true); } else { retval = SqlServerConfiguration.Create(connectionString); } retval.AlwaysSubmitDefaultValues = this.alwaysSubmitDefaultValues; retval.ValueTypesAutoImplicitDefault = this.valueTypesAutoImplicitDefault; retval.SaveAndReuseGeneratedAssemblies = true; retval.SqlDatabaseContextInfos[0].SqlDataTypes = new List <Type> { typeof(SqlFixedDateDataType) }; return(retval); }
protected override IEventStore GetEventStore(SimpleCqrs.IServiceLocator serviceLocator) { var configuration = new SqlServerConfiguration("Server=(local)\\sqlexpress;Database=test_event_store;Trusted_Connection=True;", "dbo", "json_event_store"); return(new SqlServerEventStore(configuration, new JsonDomainEventSerializer())); }
protected override SimpleCqrs.Eventing.IEventStore GetEventStore(IServiceLocator serviceLocator) { var configuration = new SqlServerConfiguration(CONNECTION_STRING);//, //"dbo", "json_event_store"); return(new SqlServerEventStore(configuration, new JsonDomainEventSerializer())); }
protected override IEventStore GetEventStore(SimpleCqrs.IServiceLocator serviceLocator) { var configuration = new SqlServerConfiguration(CONNECTION_STRING);//, //"dbo", "binary_event_store"); return(new SqlServerEventStore(configuration, new BinaryDomainEventSerializer())); }
public DbConnection(SqlServerConfiguration sqlServerConfiguration) { Host = sqlServerConfiguration.Host; Port = sqlServerConfiguration.Port; Username = sqlServerConfiguration.Username; Password = sqlServerConfiguration.Password; DbName = sqlServerConfiguration.DbName; }
public static SqlServerConfiguration CreateConfiguration(string connectionString) { if (me == null) { lock (padlock) { me = new SqlServerConfiguration(connectionString); } } return(me); }
public static IHummingbirdEventBusHostBuilder AddSqlServerEventLogging(this IHummingbirdEventBusHostBuilder hostBuilder, Action <SqlServerConfiguration> setupFactory) { #region 配置 setupFactory = setupFactory ?? throw new ArgumentNullException(nameof(setupFactory)); var configuration = new SqlServerConfiguration(); setupFactory(configuration); #endregion hostBuilder.Services.AddTransient <SqlServerConfiguration>(a => configuration); hostBuilder.Services.AddTransient <IDbConnectionFactory>(a => new DbConnectionFactory(configuration.ConnectionString)); hostBuilder.Services.AddTransient <IEventLogger, SqlServerEventLogger>(); return(hostBuilder); }
protected DataAccessModelConfiguration CreateSqlServerConfiguration(string databaseName) { DataAccessModelConfiguration retval; var databaseRegex = new Regex(@"(?:(?:Initial Catalog)|(?:Database))\s*=\s*([^;$]+)[;$]", RegexOptions.IgnoreCase); var connectionString = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_CONNECTIONSTRING"); if (connectionString == null) { var host = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_HOST") ?? ".\\SQLEXPRESS"; var userName = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_USERNAME"); var password = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER_PASSWORD"); retval = SqlServerConfiguration.Create(databaseName, host, userName: userName, password: password, multipleActiveResultsets: true); } else { if (!databaseRegex.IsMatch(connectionString)) { connectionString = $"Database={databaseName};{connectionString}"; } else { connectionString = databaseRegex.Replace(connectionString, $"Database={databaseName};"); } retval = SqlServerConfiguration.Create(connectionString); } retval.AlwaysSubmitDefaultValues = this.alwaysSubmitDefaultValues; retval.ValueTypesAutoImplicitDefault = this.valueTypesAutoImplicitDefault; retval.SaveAndReuseGeneratedAssemblies = true; retval.SqlDatabaseContextInfos[0].SqlDataTypes = new List <Type> { typeof(SqlFixedDateDataType) }; return(retval); }
private DbConnection CreateConnectionToSqlServer(string connectionString) { var sqlServerConfiguration = SqlServerConfiguration.CreateConfiguration(connectionString); return(new DbConnection(sqlServerConfiguration)); }
public static IdentityBuilder AddDapperIdentityForSqlServer <TKey, TUserRole, TRoleClaim>(this IdentityBuilder builder, SqlServerConfiguration configurationOverride) { builder.Services.AddSingleton <SqlConfiguration>(configurationOverride); AddStores(builder.Services, builder.UserType, builder.RoleType, typeof(TKey), typeof(TUserRole), typeof(TRoleClaim)); return(builder); }
protected DataAccessModelConfiguration CreateSqlServerConfiguration(string databaseName) { return(SqlServerConfiguration.Create(databaseName, "localhost", null, null)); }
protected DataAccessModelConfiguration CreateSqlServerConfiguration(string databaseName) { return(SqlServerConfiguration.Create(databaseName, "localhost", multipleActiveResultsets: true)); }
protected DataAccessModelConfiguration CreateSqlServerConfiguration(string databaseName) { var host = Environment.GetEnvironmentVariable("SHAOLINQ_TESTS_SQLSERVER") ?? ".\\SQLEXPRESS"; return SqlServerConfiguration.Create(databaseName, host, multipleActiveResultsets: true, deleteDatabaseDropsTablesOnly:true); }
public SqlExecutorTests() { m_SqlServerConfiguration = SqlServerConfiguration.ReadAppSettings(); }
protected override IEventStore GetEventStore(SimpleCqrs.IServiceLocator serviceLocator) { var configuration = new SqlServerConfiguration(Constants.SampleCQRSConnectionString); return(new SqlServerEventStore(configuration, new JsonDomainEventSerializer())); }
public static IServiceCollection UsingARMOrchestration(this IServiceCollection services, ARMOrchestrationSqlServerConfig config) { SqlServerConfiguration sqlServerConfiguration = new SqlServerConfiguration() { AutoCreate = config.Database.AutoCreate, ConnectionString = config.Database.ConnectionString, HubName = config.Database.HubName, SchemaName = config.Database.SchemaName, CommunicationWorkerOptions = config.CommunicationWorkerOptions, OrchestrationServiceSettings = config.OrchestrationServiceSettings }; sqlServerConfiguration.OrchestrationWorkerOptions.FetchJobCount = config.OrchestrationWorkerOptions.FetchJobCount; sqlServerConfiguration.OrchestrationWorkerOptions.GetBuildInTaskActivitiesFromInterface = config.OrchestrationWorkerOptions.GetBuildInTaskActivitiesFromInterface; sqlServerConfiguration.OrchestrationWorkerOptions.GetBuildInOrchestrators = (sp) => { IList <(string, string, Type)> orchList; if (config.OrchestrationWorkerOptions.GetBuildInOrchestrators == null) { orchList = new List <(string, string, Type)>(); } else { orchList = config.OrchestrationWorkerOptions.GetBuildInOrchestrators(sp); } orchList.Add((ResourceOrchestration.Name, "1.0", typeof(ResourceOrchestration))); orchList.Add((DeploymentOrchestration.Name, "1.0", typeof(DeploymentOrchestration))); orchList.Add((RequestOrchestration.Name, "1.0", typeof(RequestOrchestration))); orchList.Add((CopyOrchestration.Name, "1.0", typeof(CopyOrchestration))); return(orchList); }; sqlServerConfiguration.OrchestrationWorkerOptions.GetBuildInTaskActivities = (sp) => { IList <(string, string, Type)> activityTypes; if (config.OrchestrationWorkerOptions.GetBuildInTaskActivities == null) { activityTypes = new List <(string, string, Type)>(); } else { activityTypes = config.OrchestrationWorkerOptions.GetBuildInTaskActivities(sp); } activityTypes.Add((DeploymentOperationActivity.Name, "1.0", typeof(DeploymentOperationActivity))); activityTypes.Add((WaitDependsOnActivity.Name, "1.0", typeof(WaitDependsOnActivity))); activityTypes.Add((ValidateTemplateActivity.Name, "1.0", typeof(ValidateTemplateActivity))); activityTypes.Add((AsyncRequestActivity.Name, "1.0", typeof(AsyncRequestActivity))); activityTypes.Add((ExpandResourcePropertiesActivity.Name, "1.0", typeof(ExpandResourcePropertiesActivity))); return(activityTypes); }; services.UsingOrchestration(sqlServerConfiguration); #region WaitDependsOnWorker services.AddSingleton <WaitDependsOnWorker>(); services.AddSingleton <IHostedService>(p => p.GetService <WaitDependsOnWorker>()); #endregion WaitDependsOnWorker services.AddSingleton <ARMOrchestrationClient>(); services.AddSingleton <ARMTemplateHelper>(); services.AddSingleton <ARMFunctions>(); services.Configure <ARMOrchestrationOptions>((opt) => { opt.Database = config.Database; }); return(services); }
public static IdentityBuilder AddDapperIdentityForSqlServer(this IdentityBuilder builder, SqlServerConfiguration configurationOverride) { builder.Services.AddSingleton <SqlConfiguration>(configurationOverride); AddStores(builder.Services, builder.UserType, builder.RoleType); return(builder); }