/// <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();
        }
Ejemplo n.º 3
0
        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();
            });
        }
Ejemplo n.º 4
0
 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;
     }
 }
Ejemplo n.º 5
0
        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);
        }
Ejemplo n.º 6
0
        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()));
        }
Ejemplo n.º 7
0
        protected override SimpleCqrs.Eventing.IEventStore GetEventStore(IServiceLocator serviceLocator)
        {
            var configuration = new SqlServerConfiguration(CONNECTION_STRING);//,

            //"dbo", "json_event_store");
            return(new SqlServerEventStore(configuration, new JsonDomainEventSerializer()));
        }
Ejemplo n.º 8
0
        protected override IEventStore GetEventStore(SimpleCqrs.IServiceLocator serviceLocator)
        {
            var configuration = new SqlServerConfiguration(CONNECTION_STRING);//,

            //"dbo", "binary_event_store");
            return(new SqlServerEventStore(configuration, new BinaryDomainEventSerializer()));
        }
Ejemplo n.º 9
0
        public void x(string connectionString)
        {
            var sqlServerConfiguration = new SqlServerConfiguration(connectionString);

            ScenarioContext.Current.Set(sqlServerConfiguration);

            DatabaseSteps.ClearTheEventStore();
        }
 public DbConnection(SqlServerConfiguration sqlServerConfiguration)
 {
     Host     = sqlServerConfiguration.Host;
     Port     = sqlServerConfiguration.Port;
     Username = sqlServerConfiguration.Username;
     Password = sqlServerConfiguration.Password;
     DbName   = sqlServerConfiguration.DbName;
 }
Ejemplo n.º 11
0
 public static SqlServerConfiguration CreateConfiguration(string connectionString)
 {
     if (me == null)
     {
         lock (padlock)
         {
             me = new SqlServerConfiguration(connectionString);
         }
     }
     return(me);
 }
Ejemplo n.º 12
0
        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);
        }
Ejemplo n.º 13
0
        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));
        }
Ejemplo n.º 15
0
        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);
        }
Ejemplo n.º 16
0
 protected DataAccessModelConfiguration CreateSqlServerConfiguration(string databaseName)
 {
     return(SqlServerConfiguration.Create(databaseName, "localhost", null, null));
 }
Ejemplo n.º 17
0
 protected DataAccessModelConfiguration CreateSqlServerConfiguration(string databaseName)
 {
     return(SqlServerConfiguration.Create(databaseName, "localhost", multipleActiveResultsets: true));
 }
Ejemplo n.º 18
0
        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();
 }
Ejemplo n.º 20
0
        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);
        }
Ejemplo n.º 22
0
        public static IdentityBuilder AddDapperIdentityForSqlServer(this IdentityBuilder builder, SqlServerConfiguration configurationOverride)
        {
            builder.Services.AddSingleton <SqlConfiguration>(configurationOverride);

            AddStores(builder.Services, builder.UserType, builder.RoleType);

            return(builder);
        }