public DbModelLoader(DbSettings settings, MemoryLog log) { Settings = settings; Log = log; Driver = Settings.ModelConfig.Driver; SetupSchemas(Settings.GetSchemas()); }
public PgDbModelLoader(DbSettings settings, MemoryLog log) : base(settings, log) { // Value identifying tables in information_schema.Tables view; for Postgres it is 'BASE TABLE' base.TableTypeTag = "BASE TABLE"; // Value identifying routines in information_schema.Routines view base.RoutineTypeTag = "FUNCTION"; }
public bool VersionsChanged; //true if detected any version changes #endregion Fields #region Constructors public DbUpgradeInfo(DbSettings settings, DbModel newModel) { Settings = settings; NewDbModel = newModel; var serverType = NewDbModel.Driver.ServerType; Id = Guid.NewGuid(); Method = DbUpgradeMethod.Auto; //might be changed by update tool app UserName = "******"; Status = UpgradeStatus.None; }
public PeopleRepository(string conn, string db) { _config = new DbSettings { connectionstring = conn, database = db, collections = new collections { People = "People" } }; _database = Connect(); }
public SuggestionsRepository(string conn, string db) { _config = new DbSettings { connectionstring = conn, database = db, collections = new collections { Suggestions = "Suggestions" } }; _database = Connect(); }
public ProgramsRepository(string conn, string db) { _config = new DbSettings { connectionstring = conn, database = db, collections = new collections { Programs = "Programs" } }; _database = Connect(); }
static DbSettings() { MySQL = new DbSettings { firstNameEscapeSymbol = "`", secondNameEscapeSymbol = "`", paramPrefix = "@p_" }; MSSQL = new DbSettings { firstNameEscapeSymbol = "[", secondNameEscapeSymbol = "]", paramPrefix = "@p_" }; }
public AddDbCommandsMappingConfig( DbSettings dbSettings, IEnumerable<string> includeFields, IEnumerable<string> excludeFields, string configName) { _dbSettings = dbSettings; _includeFields = includeFields; _excludeFields = excludeFields; _configName = configName; if (_includeFields != null) { _includeFields = _includeFields.Select(f => f.ToUpper()); } if (_excludeFields != null) { _excludeFields = _excludeFields.Select(f => f.ToUpper()); } }
public SQLiteDbModelUpdater(DbSettings settings) : base(settings) { }
public abstract DbModelLoader CreateDbModelLoader(DbSettings settings, SystemLog log);
public PgCategoryRepository(DbSettings _dbSettings, IEventBus _bus) : base(_dbSettings, _bus) { }
public PgUsageLocationStatusRepository(DbSettings _dbSettings, IEventBus _bus) : base(_dbSettings, _bus) { }
public BTable(DbSettings settings, string name) : base(settings, name) { }
public PeopleRepository(IOptions<DbSettings> config) { _config = config.Value; _database = Connect(); }
public PgDbModelUpdater(DbSettings settings) : base(settings) { }
public HomeController(IOptions <DbSettings> dbSettings) { _dbSettings = dbSettings.Value; }
public MongoStudyRepository(DbSettings dbSettings) { _context = new StudiesContext(dbSettings); }
public LocalDbService(DbSettings dbSettings) { ConnectionString = $"Data Source={dbSettings.Address}; AttachDbFilename={dbSettings.Name}; " + "Integrated Security=True; Connect Timeout=30"; }
public void Create(SQL _Sql, LambdaExpression _LambdaExpression) { if (_LambdaExpression.Body is ConstantExpression)//如果是字符串 { var body = (_LambdaExpression.Body as ConstantExpression); this.AddCode(_Sql, body.Value); } else if (_LambdaExpression.Body is MemberExpression) { var _MemberExpression = _LambdaExpression.Body as MemberExpression; if (_MemberExpression.Expression is ConstantExpression) { var value = Parser.Eval(_LambdaExpression.Body); this.AddCode(_Sql, value); } else if (_MemberExpression.Expression is ParameterExpression) { var _ParameterExpression = _MemberExpression.Expression as ParameterExpression; var _TabName = this.AddAlias(_ParameterExpression.Name, _Sql); var _DisplayName = DbSettings.KeywordHandle(_MemberExpression.Member.Name); var column = new List <string>(); column.Add(_TabName + _DisplayName + " AS " + _DisplayName); this.AddCode(_Sql, string.Join(",", column)); } } else if (_LambdaExpression.Body is NewExpression)//如果是匿名对象 { var body = (_LambdaExpression.Body as NewExpression); var values = body.Arguments; var member = body.Members; var column = new List <string>(); var list_member = member.ToList(); foreach (var item in values) { if (item is MemberExpression) { var it = item as MemberExpression; //检查是否有别名 var DisplayName = DbSettings.KeywordHandle(list_member[values.IndexOf(item)].Name); var _TabName = this.AddAlias((it.Expression as ParameterExpression).Name, _Sql); column.Add(_TabName + DbSettings.KeywordHandle(it.Member.Name) + " AS " + DisplayName); } else if (item is ConstantExpression) { var it = item as ConstantExpression; var val = it.Value; //检查是否有别名 '' var DisplayName = list_member[values.IndexOf(item)].Name; if (!string.IsNullOrEmpty(DisplayName)) { //判断别名是否 有 SqlString 关键字 if (DisplayName.StartsWith("SqlString")) { column.Add(val.ToString()); } else { column.Add(DbSettings.KeywordHandle(val.ToString()) + " AS " + DbSettings.KeywordHandle(DisplayName)); } } } else if (item.Type == typeof(string)) { //检查是否有别名 '' var value = Parser.Eval(item).ToString(); var DisplayName = list_member[values.IndexOf(item)].Name; if (!string.IsNullOrEmpty(DisplayName) && DisplayName.StartsWith("SqlString")) { column.Add(value); } } else if (item is ParameterExpression) { this.AnalysisParameterExpression(item as ParameterExpression, column); } } this.AddCode(_Sql, string.Join(",", column)); } else if (_LambdaExpression.Body is ParameterExpression) { var column = new List <string>(); this.AnalysisParameterExpression(_LambdaExpression.Body as ParameterExpression, column); this.AddCode(_Sql, string.Join(",", column)); } else { throw new DbFrameException(" SELECT 语法不支持!"); } }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { // CONFIGURATION SETTINGS var applicationConfiguration = Configuration.GetSection("Application"); var applicationSettings = new ApplicationSettings( applicationConfiguration["DefaultNickname"], applicationConfiguration.GetValue <double>("RadiusAround"), applicationConfiguration["UploadsFolderName"]); services.AddSingleton(applicationSettings); var securityConfiguration = Configuration.GetSection("Security"); var securitySettings = new SecuritySettings( securityConfiguration["EncryptionKey"], securityConfiguration["Issue"], securityConfiguration.GetValue <TimeSpan>("ExpirationPeriod")); services.AddSingleton(securitySettings); // REPOSITORIES IShyneesRepository shyneesRepository; if (Configuration.GetValue <bool>("Database:IsInMemory")) { shyneesRepository = new InMemoryShyneesRepository(); } else { var dbConfiguration = Configuration.GetSection("Database:MongoDB"); var dbSettings = new DbSettings( dbConfiguration["ConnectionString"], dbConfiguration["Database"]); services.AddSingleton(dbSettings); var dbMapper = new DbMapper(); var dbContext = new DbContext(dbSettings); shyneesRepository = new ShyneesRepository(dbContext); } // SERVICES var shyneesService = new ShyneesService(shyneesRepository, applicationSettings); var assetsService = new AssetsService(applicationSettings); services.AddSingleton <IShyneesService>(shyneesService); services.AddSingleton <IAssetsService>(assetsService); // OTHER DEPENDENCIES services.AddScoped <ModelValidationAttribute>(); var jwtIssuer = new JwtIssuer(securitySettings); services.AddSingleton <IJwtIssuer>(jwtIssuer); services.AddAuthentication(JwtBearerDefaults.AuthenticationScheme) .AddJwtBearer(options => { options.TokenValidationParameters = new TokenValidationParameters { ValidateIssuer = false, ValidateAudience = false, ValidateLifetime = true, ValidateIssuerSigningKey = true, IssuerSigningKey = new SymmetricSecurityKey( Encoding.UTF8.GetBytes(securitySettings.EncryptionKey)) }; }); services .AddAuthorization(options => { options.DefaultPolicy = new AuthorizationPolicyBuilder(JwtBearerDefaults.AuthenticationScheme) .RequireAuthenticatedUser().Build(); }); services.AddCors(options => { options.AddPolicy("EnableCORS", builder => { builder.AllowAnyOrigin().AllowAnyHeader().AllowAnyMethod().AllowCredentials().Build(); }); }); services.AddMvc(config => { config.ReturnHttpNotAcceptable = true; }); services.AddSwaggerGen(options => { options.SwaggerDoc("v1", new Info { Title = Configuration["Swagger:Title"], Version = Configuration["Swagger:Version"], Description = Configuration["Swagger:Description"] }); options.AddSecurityDefinition("Bearer", new ApiKeyScheme { Description = "JWT Authorization header using the Bearer scheme. Example: \"Authorization: Bearer {token}\"", Name = "Authorization", In = "header", Type = "apiKey" }); options.IncludeXmlComments(string.Format(@"{0}/ShyneeBackend.Application.xml", AppDomain.CurrentDomain.BaseDirectory)); options.IncludeXmlComments(string.Format(@"{0}/ShyneeBackend.Domain.xml", AppDomain.CurrentDomain.BaseDirectory)); options.DescribeAllEnumsAsStrings(); }); }
public ProjectSeedData(IOptions <DbSettings> dbSettings, IOptions <DbData> dbData) { _dbSettings = dbSettings.Value; _client = new DocumentClient(new Uri(_dbSettings.EndpointUri), _dbSettings.PrimaryKey); _dbData = dbData.Value; _dbName = _dbData.DbName; _projectsCollectionName = _dbData.ProjectsCollectionName; _ticketsCollectionName = _dbData.TicketsCollectionName; _usersCollectionName = _dbData.UsersCollectionName; // init seed data lists _projectsList = new List <Project>() { new Project() { Id = _dbData.AtpId, Name = _dbData.AtpName, Tickets = new List <TicketBase>() { new TicketBase() { Id = _dbData.AtpTicketId1, Name = _dbData.AtpTicketName1 }, new TicketBase() { Id = _dbData.AtpTicketId2, Name = _dbData.AtpTicketName2 } } }, new Project() { Id = _dbData.BtId, Name = _dbData.BtName, Tickets = new List <TicketBase>() { new TicketBase() { Id = _dbData.BtTicketId1, Name = _dbData.BtTicketName1 } } } }; _ticketsList = new List <Ticket>() { new Ticket() { Id = _dbData.AtpTicketId1, Name = _dbData.AtpTicketName1, Description = _dbData.AtpTicketDesc1, ProjectName = _dbData.AtpName }, new Ticket() { Id = _dbData.AtpTicketId2, Name = _dbData.AtpTicketName2, Description = _dbData.AtpTicketDesc2, ProjectName = _dbData.AtpName }, new Ticket() { Id = _dbData.BtTicketId1, Name = _dbData.BtTicketName1, Description = _dbData.BtTicketDesc1, ProjectName = _dbData.BtName }, }; }
public override DbModelLoader CreateDbModelLoader(DbSettings settings, MemoryLog log) { return new SqlCeDbModelLoader(settings, log); }
/// <summary> /// Instantiates a new database interaction object. /// </summary> public OracleManagedDatabase2(string connectionString, DbSettings setting) : base(connectionString, setting) { }
public MsSqlDbModelUpdater(DbSettings settings) : base(settings) { }
/// <summary> /// Instantiates a new database interaction object. /// </summary> public OracleManagedDatabase2(string connectionString, DbSettings setting, IsolationLevel isolation) : base(connectionString, setting, isolation) { }
protected void Page_Load(object sender, EventArgs e) { // Check the templates are loaded, else load them #if !DEBUG if (templates == null) { templates = new UberCMS.Misc.HtmlTemplates(); templates.reloadFromDisk(AppDomain.CurrentDomain.BaseDirectory + "\\Installer\\Templates"); } #else if (templates == null) templates = new UberCMS.Misc.HtmlTemplates(); templates.reloadFromDisk(AppDomain.CurrentDomain.BaseDirectory + "\\Installer\\Templates"); #endif // Check if any DB settings have been loaded, else load them if (dbSettings == null && File.Exists(AppDomain.CurrentDomain.BaseDirectory + "\\CMS.config")) { XmlDocument settings = new XmlDocument(); settings.LoadXml(File.ReadAllText(AppDomain.CurrentDomain.BaseDirectory + "\\CMS.config")); dbSettings = new DbSettings( settings["settings"]["db"]["host"].InnerText, settings["settings"]["db"]["database"].InnerText, settings["settings"]["db"]["username"].InnerText, settings["settings"]["db"]["password"].InnerText, int.Parse(settings["settings"]["db"]["port"].InnerText) ); settings = null; } // Invoke the correct page to handle the request UberCMS.Misc.PageElements pageElements = new UberCMS.Misc.PageElements(); pageElements["URL"] = ResolveUrl("/install"); pageElements["BASE_URL"] = ResolveUrl("/"); StringBuilder content = new StringBuilder(); #if !INSTALLED switch (Request.QueryString["1"]) { case "home": case null: pageHome(ref pageElements, Request, Response, ref content); break; case "setup": pageSetup(ref pageElements, Request, Response, ref content); break; case "install": pageInstall(ref pageElements, Request, Response, ref content); break; } #else Response.Redirect(ResolveUrl("")); #endif // Build and display the final output pageElements["CONTENT"] = content.ToString(); StringBuilder template = new StringBuilder(templates[TEMPLATES_KEY]["template"]); pageElements.replaceElements(ref template, 0, 5); Response.Write(template.ToString()); }
public PeopleRepository(DbSettings config) { _config = config; _database = Connect(); }
public MsSqlDbModelLoader(DbSettings settings, MemoryLog log) : base(settings, log) { base.TableTypeTag = "BASE TABLE"; base.RoutineTypeTag = "PROCEDURE"; }
public NotificationDbContext(IOptions <DbSettings> dbSetting) { this._dbSetting = dbSetting.Value; }
public HotelRepository(DbSettings dbSettings) { Login = Environment.GetEnvironmentVariable("NEO4J_USER_NAME"); Password = Environment.GetEnvironmentVariable("NEO4J_PASSWORD"); GraphClient = new BoltGraphClient(new Uri(dbSettings.DbConnectionString), Login, Password); }
public static string BuildConnectionString(DbSettings dbSettings) { return($"SERVER={dbSettings.server};DATABASE={dbSettings.database};UID={dbSettings.database_user};PASSWORD={dbSettings.database_password};Charset=utf8;"); }
public DataLayerModule(IReloadingManager <AppSettings> appSettings) { _dbSettings = appSettings.CurrentValue.CrossChainTransfersService.Db; }
public DatabaseModule(DbSettings settings) { _settings = settings; }
public SqlCeDbModelUpdater(DbSettings settings) : base(settings) { }
public ExampleRepository(IMapper mapper, IOptions <DbSettings> options) { _mapper = mapper; _dbSettings = options.Value; }
public SqlServerDbEngine(DbSettings dbSettings) : base(dbSettings) { _connectionString = string.Format("Data Source={0};Initial Catalog={1};Integrated Security=True", _dbSettings.HOST, _dbSettings.DB_NAME); }
/// <summary> /// Instantiates a new encapsulated asynchronous database interaction object according to database setting. /// </summary> public IDatabaseAsync2 GetDbObjectAsync(DbSettings setting) { return(GetDbObject(setting) as IDatabaseAsync2); }
public SqlCeDbModelLoader(DbSettings settings, MemoryLog log) : base(settings, log) { }
/// <summary> /// Instantiates a new encapsulated asynchronous database interaction object according to database setting and transaction isolation. /// </summary> public IDatabaseAsync2 GetDbObjectAsync(DbSettings setting, IsolationLevel isolation) { return(GetDbObject(setting, isolation) as IDatabaseAsync2); }
public override DbModelUpdater CreateDbModelUpdater(DbSettings settings) { return new SqlCeDbModelUpdater(settings); }
/// <summary> /// Instantiates a new encapsulated asynchronous database interaction object according to provider and database setting. /// </summary> public IDatabaseAsync2 GetDbObjectAsync(Provider provider, DbSettings setting) { return(GetDbObject(provider, setting) as IDatabaseAsync2); }
public DbModelUpdater(DbSettings settings) { Settings = settings; }
/// <summary> /// Instantiates a new encapsulated asynchronous database interaction object according to provider, database setting and transaction isolation. /// </summary> public IDatabaseAsync2 GetDbObjectAsync(Provider provider, DbSettings setting, IsolationLevel isolation) { return(GetDbObject(provider, setting, isolation) as IDatabaseAsync2); }
public PgResourceRepository(DbSettings _dbSettings, IEventBus _bus) : base(_dbSettings, _bus) { }
/// <summary> /// Instantiates a new encapsulated asynchronous database interaction object according to database setting. /// </summary> public IDatabaseAsync2 GetDbObjectAsync(string connectionString, DbSettings setting) { return(GetDbObject(connectionString, setting) as IDatabaseAsync2); }
public ISettings GetAllowedSettings(int id) { DbSettings settingsCache = Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.GetIdentifier(CacheObject.AllowedLearningModuleSettings, id)] as DbSettings; if (settingsCache != null) return settingsCache; using (NpgsqlConnection con = PostgreSQLConn.CreateConnection(Parent.CurrentUser)) { using (NpgsqlCommand cmd = con.CreateCommand()) { cmd.CommandText = "SELECT allowed_settings_id FROM \"LearningModules\" WHERE id=:id"; cmd.Parameters.Add("id", id); int? settingsid = PostgreSQLConn.ExecuteScalar<int>(cmd, Parent.CurrentUser); if (!settingsid.HasValue) return null; DbSettings settings = new DbSettings(settingsid.Value, false, Parent); Parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.AllowedLearningModuleSettings, id, Cache.DefaultSettingsValidationTime)] = settings; return settings; } } }
public abstract DbModelLoader CreateDbModelLoader(DbSettings settings, MemoryLog log);
protected DbEngine(DbSettings dbSettings) { _dbSettings = dbSettings; }
/// <summary> /// Gets the default settings. /// </summary> /// <param name="id">The id.</param> /// <returns></returns> /// <remarks>Documented by Dev08, 2009-01-12</remarks> public ISettings GetDefaultSettings(int id) { DbSettings settingsCache = parent.CurrentUser.Cache[ObjectLifetimeIdentifier.GetIdentifier(CacheObject.DefaultLearningModuleSettings, id)] as DbSettings; if (settingsCache != null) return settingsCache; using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser)) { cmd.CommandText = "SELECT default_settings_id FROM \"LearningModules\" WHERE id=@id"; cmd.Parameters.Add("@id", id); int? settingsid = MSSQLCEConn.ExecuteScalar<int>(cmd); if (!settingsid.HasValue) return null; DbSettings settings = new DbSettings(settingsid.Value, false, parent); parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.DefaultLearningModuleSettings, id, Cache.DefaultSettingsValidationTime)] = settings; return settings; } }
public SuggestionsRepository(DbSettings config) { _config = config; _database = Connect(); }
public override DbModelUpdater CreateDbModelUpdater(DbSettings settings) { return(new SqlCeDbModelUpdater(settings)); }
public ProgramsRepository(DbSettings config) { _config = config; _database = Connect(); }
public override DbModelLoader CreateDbModelLoader(DbSettings settings, SystemLog log) { return(new SqlCeDbModelLoader(settings, log)); }
/// <summary> /// Gets the user settings. /// </summary> /// <param name="id">The id.</param> /// <returns></returns> /// <remarks>Documented by Dev08, 2009-01-12</remarks> public ISettings GetUserSettings(int id) { DbSettings settingsCache = parent.CurrentUser.Cache[ObjectLifetimeIdentifier.GetIdentifier(CacheObject.UserLearningModuleSettings, id)] as DbSettings; if (settingsCache != null) return settingsCache; int count; using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser)) { cmd.CommandText = "SELECT count(*) FROM \"UserProfilesLearningModulesSettings\" WHERE user_id=@param_user_id and lm_id=@param_lm_id;"; cmd.Parameters.Add("@param_user_id", parent.CurrentUser.Id); cmd.Parameters.Add("@param_lm_id", id); count = Convert.ToInt32(MSSQLCEConn.ExecuteScalar(cmd)); } int result; if (count < 1) //Create new settings { using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser)) { cmd.CommandText = "INSERT INTO \"UserProfilesLearningModulesSettings\" (user_id, lm_id, settings_id) VALUES (@param_user_id, @param_lm_id, @param_new_settings);"; cmd.Parameters.Add("@param_user_id", parent.CurrentUser.Id); cmd.Parameters.Add("@param_lm_id", id); cmd.Parameters.Add("@param_new_settings", MsSqlCeSettingsConnector.CreateNewSettings(parent)); MSSQLCEConn.ExecuteNonQuery(cmd); } using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser)) { cmd.CommandText = "SELECT settings_id FROM \"UserProfilesLearningModulesSettings\" WHERE user_id=@param_user_id and lm_id=@param_lm_id;"; cmd.Parameters.Add("@param_user_id", parent.CurrentUser.Id); cmd.Parameters.Add("@param_lm_id", id); result = Convert.ToInt32(MSSQLCEConn.ExecuteScalar(cmd)); } //Selected Learn Chapters using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser)) { cmd.CommandText = "SELECT id FROM \"Chapters\" WHERE lm_id=@param_lm_id"; cmd.Parameters.Add("@param_lm_id", id); SqlCeDataReader reader = MSSQLCEConn.ExecuteReader(cmd); while (reader.Read()) { using (SqlCeCommand cmd2 = MSSQLCEConn.CreateCommand(parent.CurrentUser)) { cmd2.CommandText = "INSERT INTO \"SelectedLearnChapters\" VALUES (@cid, @result);"; cmd2.Parameters.Add("@cid", reader["id"]); cmd2.Parameters.Add("@result", result); MSSQLCEConn.ExecuteNonQuery(cmd2); } } reader.Close(); } DbSettings settings = new DbSettings(result, false, parent); parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.UserLearningModuleSettings, id, Cache.DefaultSettingsValidationTime)] = settings; return settings; } else { using (SqlCeCommand cmd = MSSQLCEConn.CreateCommand(parent.CurrentUser)) { cmd.CommandText = "SELECT settings_id FROM \"UserProfilesLearningModulesSettings\" WHERE user_id=@param_user_id and lm_id=@param_lm_id;"; cmd.Parameters.Add("@param_user_id", parent.CurrentUser.Id); cmd.Parameters.Add("@param_lm_id", id); result = Convert.ToInt32(MSSQLCEConn.ExecuteScalar(cmd)); } DbSettings settings = new DbSettings(result, false, parent); parent.CurrentUser.Cache[ObjectLifetimeIdentifier.Create(CacheObject.UserLearningModuleSettings, id, Cache.DefaultSettingsValidationTime)] = settings; return settings; } }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { services.Configure <IdentityOptions>(options => { // Password settings. options.Password.RequireDigit = true; options.Password.RequireLowercase = true; options.Password.RequireNonAlphanumeric = true; options.Password.RequireUppercase = true; options.Password.RequiredLength = 6; options.Password.RequiredUniqueChars = 1; // Lockout settings. options.Lockout.DefaultLockoutTimeSpan = TimeSpan.FromMinutes(5); options.Lockout.MaxFailedAccessAttempts = 5; options.Lockout.AllowedForNewUsers = true; // User settings. options.User.AllowedUserNameCharacters = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789-._@+"; options.User.RequireUniqueEmail = false; }); services .AddAuthentication(CookieAuthenticationDefaults.AuthenticationScheme) .AddCookie(CookieAuthenticationDefaults.AuthenticationScheme, options => { // Cookie settings options.Cookie.HttpOnly = true; options.ExpireTimeSpan = TimeSpan.FromMinutes(5); options.LoginPath = "/api/login"; options.AccessDeniedPath = "/api/register"; options.SlidingExpiration = true; }); var dbSettings = new DbSettings() { DataBasePath = "db/main.db", Name = "main", Password = "" }; var creator = new SQLiteDBCreator(dbSettings, _logger); if (!creator.DatabaseExists()) { creator.CreateEmptyDB(); } var connectionHolder = new SQLiteConnectionProvider(dbSettings, _logger); DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.SqliteDialect(); var database = new Database(connectionHolder.CreateConnection(), new SqlGeneratorImpl(new DapperExtensionsConfiguration(typeof(AutoClassMapper <>), new[] { typeof(SqliteClassMapping).Assembly }, new SqliteDialect()))); services.AddSingleton <IFileStorage>(new FileStorage("db/images")); services.AddSingleton <IDatabase>(database); services.AddSingleton <IUserManager, UserManager>(); services.AddSingleton <IPointManager, PointManager>(); services.AddSingleton <IPointCommentEntityManager, PointCommentEntityManager>(); services.AddSingleton <ILikeManager, LikeManager>(); services.AddLogging(config => { config.AddDebug(); config.AddConsole(); }); services.AddMvc(options => { options.InputFormatters.Insert(0, new BinaryInputFormatter()); }).SetCompatibilityVersion(CompatibilityVersion.Version_2_2); }
/// <summary> /// Instantiates a new encapsulated asynchronous database interaction object according to provider, database setting and transaction isolation. /// </summary> public IDatabaseAsync2 GetDbObjectAsync(string connectionString, Provider provider, DbSettings setting, IsolationLevel isolation) { return(GetDbObject(connectionString, provider, setting, isolation) as IDatabaseAsync2); }
public void ConfigureServices(IServiceCollection services) { services.AddCors(options => { options.AddPolicy(MyAllowOrigins, builder => builder // .WithOrigins("http://localhost:63342") .AllowAnyOrigin() // .AllowCredentials() .AllowAnyHeader() .AllowAnyMethod() ); }); services.Configure <ApiBehaviorOptions>(options => options.SuppressModelStateInvalidFilter = true); services.Configure <ApiSettings>(Configuration.GetSection("AppSettings:APISettings")); var dbSettings = new DbSettings { DB_HOST = Configuration.GetSection("DB_HOST").Value, DB_PORT = Configuration.GetSection("DB_PORT").Value, DB_USER = Configuration.GetSection("DB_USER").Value, DB_PASSWORD = Configuration.GetSection("DB_PASSWORD").Value, DB_NAME = Configuration.GetSection("DB_NAME").Value }; services.AddDbContext <ApplicationDbContext>(options => options.UseNpgsql(dbSettings.DbConnectionString, optionsBuilder => optionsBuilder.MigrationsAssembly(typeof(ApplicationDbContext).Assembly.FullName))); services.AddAuthentication(JwtBearerDefaults.AuthenticationScheme) .AddJwtBearer(options => { var apiSettings = Configuration.GetSection("AppSettings:APISettings").Get <ApiSettings>(); // options.RequireHttpsMetadata = true; options.TokenValidationParameters = new TokenValidationParameters { ClockSkew = TimeSpan.Zero, ValidateAudience = true, ValidAudience = apiSettings.AUDIENCE, ValidateIssuer = true, ValidIssuer = apiSettings.ISSUER, ValidateIssuerSigningKey = true, IssuerSigningKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(apiSettings.PublicKey)), // To allow return custom response for expired token ValidateLifetime = false, }; options.Events = new JwtBearerEvents { OnMessageReceived = context => { var accessToken = context.Request.Query["access_token"]; var path = context.HttpContext.Request.Path; if (!String.IsNullOrEmpty(path) && path.StartsWithSegments("/api/ws")) { context.Token = accessToken; } return(Task.CompletedTask); } }; }); services.AddAuthorization(); services.AddSignalR(); services.AddControllers(options => { options.Filters.Add(typeof(ValidateModelAttribute)); options.Filters.Add(typeof(StatusCodeFilter)); }) .AddFluentValidation(fv => { ValidatorConfigurationOverload.Override(); fv.RegisterValidatorsFromAssemblyContaining <DTO.DependencyInjectionModule>(); }); services.AddDirectoryBrowser(); services.AddSingleton(MappingConfig.GetMapper()); DependencyInjectionModule.Load(services); }
public abstract DbModelUpdater CreateDbModelUpdater(DbSettings settings);
public StudiesContext(DbSettings settings) { var client = new MongoClient(settings.ConnectionString); _databsae = client.GetDatabase(settings.Database); }