/// <summary> /// Initializes a new instance of the <see cref="CopyOriginalCustomerNotesToFirstNote"/> class. /// </summary> public CopyOriginalCustomerNotesToFirstNote() : base(ApplicationContext.Current.DatabaseContext.SqlSyntax, Umbraco.Core.Logging.Logger.CreateWithDefaultLog4NetConfiguration()) { var dbContext = ApplicationContext.Current.DatabaseContext; _database = dbContext.Database; _sqlSyntax = dbContext.SqlSyntax; _noteService = MerchelloContext.Current.Services.NoteService; }
/// <summary> /// Initializes a new instance of the <see cref="AddInvoiceCurrencyCodeColumn"/> class. /// </summary> public AddInvoiceCurrencyCodeColumn() : base(ApplicationContext.Current.DatabaseContext.SqlSyntax, Umbraco.Core.Logging.Logger.CreateWithDefaultLog4NetConfiguration()) { var dbContext = ApplicationContext.Current.DatabaseContext; _database = dbContext.Database; _sqlSyntax = dbContext.SqlSyntax; _invoiceService = (InvoiceService)MerchelloContext.Current.Services.InvoiceService; }
/// <summary> /// Initializes a new instance of the <see cref="CoreBootManager"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntaxProvider"> /// The <see cref="ISqlSyntaxProvider"/>. /// </param> internal CoreBootManager(ILogger logger, ISqlSyntaxProvider sqlSyntaxProvider) { Mandate.ParameterNotNull(logger, "Logger"); Mandate.ParameterNotNull(sqlSyntaxProvider, "sqlSyntaxProvider"); _logger = logger; _sqlSyntaxProvider = sqlSyntaxProvider; SetUnitOfWorkProvider(); }
/// <summary> /// Initializes a new instance of the <see cref="CoreMigrationManager"/> class. /// </summary> /// <param name="database"> /// The database. /// </param> /// <param name="sqlSyntaxProvider"> /// The SQL Syntax Provider. /// </param> /// <param name="logger"> /// The logger. /// </param> public CoreMigrationManager(Database database, ISqlSyntaxProvider sqlSyntaxProvider, ILogger logger) { Mandate.ParameterNotNull(database, "database"); Mandate.ParameterNotNull(sqlSyntaxProvider, "sqlSyntaxProvider"); Mandate.ParameterNotNull(logger, "logger"); _database = database; _sqlSyntaxProvider = sqlSyntaxProvider; _logger = logger; }
/// <summary> /// Initializes a new instance of the <see cref="MerchelloDatabaseSchemaHelper"/> class. /// </summary> /// <param name="db"> /// The DB. /// </param> /// <param name="logger"> /// The logger. /// </param> /// <param name="syntaxProvider"> /// The syntax provider. /// </param> internal MerchelloDatabaseSchemaHelper(Database db, ILogger logger, ISqlSyntaxProvider syntaxProvider) { Mandate.ParameterNotNull(db, "db"); Mandate.ParameterNotNull(logger, "logger"); Mandate.ParameterNotNull(syntaxProvider, "syntaxProvider"); _db = db; _logger = logger; _syntaxProvider = syntaxProvider; this._umbSchemaHelper = new DatabaseSchemaHelper(db, logger, syntaxProvider); }
//[TestFixtureSetUp] public void Init() { var syntax = (DbSyntax)Enum.Parse(typeof(DbSyntax), ConfigurationManager.AppSettings["syntax"]); // sets up the Umbraco SqlSyntaxProvider Singleton SqlSyntaxProviderTestHelper.EstablishSqlSyntax(syntax); _sqlSyntax = SqlSyntaxProviderTestHelper.SqlSyntaxProvider(syntax); //AutoMapperMappings.CreateMappings(); _logger = Logger.CreateWithDefaultLog4NetConfiguration(); _database = new PetaPocoUnitOfWorkProvider(_logger).GetUnitOfWork().Database; }
/// <summary> /// Initializes a new instance of the <see cref="RepositoryFactory"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The SQL syntax. /// </param> public RepositoryFactory(ILogger logger, ISqlSyntaxProvider sqlSyntax) : this(ApplicationContext.Current.ApplicationCache, logger, sqlSyntax) { }
/// <summary> /// Initializes a new instance of the <see cref="PaymentService"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The SQL syntax /// </param> /// <param name="appliedPaymentService"> /// The applied payment service. /// </param> internal PaymentService(ILogger logger, ISqlSyntaxProvider sqlSyntax, IAppliedPaymentService appliedPaymentService) : this(new RepositoryFactory(logger, sqlSyntax), logger, appliedPaymentService) { }
public CreateSensitiveDataUserGroup(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
/// <summary> /// Initializes a new instance of the <see cref="RepositoryFactory"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The SQL syntax. /// </param> public RepositoryFactory(ILogger logger, ISqlSyntaxProvider sqlSyntax) : this(false, new NullCacheProvider(), new ObjectCacheRuntimeCacheProvider(), logger, sqlSyntax) { }
/// <summary> /// Initializes a new instance of the <see cref="ItemCacheService"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The SQL syntax. /// </param> public ItemCacheService(ILogger logger, ISqlSyntaxProvider sqlSyntax) : this(new RepositoryFactory(logger, sqlSyntax), logger) { }
public AlterSyntaxBuilder(IMigrationContext context, ISqlSyntaxProvider sqlSyntax, params DatabaseProviders[] databaseProviders) { _context = context; _sqlSyntax = sqlSyntax; _databaseProviders = databaseProviders; }
public EasyADRepository(UmbracoDatabase database, ISqlSyntaxProvider sqlSyntax) { _database = database; _sqlSyntax = sqlSyntax; }
public AddUserStartNodeTable(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
public CreateInitialTables(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { _schemaHelper = new DatabaseSchemaHelper(_database, logger, sqlSyntax); }
public ModelToSqlExpressionVisitor(ISqlSyntaxProvider sqlSyntax, IMapperCollection mappers) : base(sqlSyntax) { _mappers = mappers; _mapper = mappers[typeof(T)]; // throws if not found }
public ContentPreviewRepository(IScopeUnitOfWork work, CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntax) : base(work, cache, logger, sqlSyntax) { }
public InitialMigration(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { this.databaseSchema = new DatabaseSchemaHelper(this.database, logger, sqlSyntax); }
/// <summary> /// Initializes a new instance of the <see cref="CreateDatabase"/> class. /// </summary> /// <param name="database"> /// The database. /// </param> /// <param name="sqlSyntaxProvider"> /// The sql Syntax Provider. /// </param> /// <param name="logger"> /// The logger. /// </param> internal CreateDatabase(Database database, ISqlSyntaxProvider sqlSyntaxProvider, ILogger logger) { _database = database; _logger = logger; _schemaHelper = new MerchelloDatabaseSchemaHelper(database, logger, sqlSyntaxProvider); }
public RemoveStylesheetDataAndTablesAgain(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
/// <summary> /// Initializes a new instance of the <see cref="PagedRepositoryBase{TEntity,TDto}"/> class. /// </summary> /// <param name="work"> /// The work. /// </param> /// <param name="cache"> /// The cache. /// </param> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The SQL Syntax. /// </param> protected PagedRepositoryBase(IDatabaseUnitOfWork work, CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntax) : base(work, cache, logger, sqlSyntax) { }
public UpdateToNewMemberPropertyAliases(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
/// <summary> /// Initializes a new instance of the <see cref="AddTaxMethodColumn"/> class. /// </summary> /// <param name="sqlSyntax"> /// The SQL syntax. /// </param> /// <param name="logger"> /// The logger. /// </param> public AddTaxMethodColumn(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { _sqlSyntaxProvider = ApplicationContext.Current.DatabaseContext.SqlSyntax; _databaseSchemaHelper = new DatabaseSchemaHelper(ApplicationContext.Current.DatabaseContext.Database, Umbraco.Core.Logging.Logger.CreateWithDefaultLog4NetConfiguration(), _sqlSyntaxProvider); }
/// <summary> /// Gets the tag SQL used to retrieve paged posts for particular tags for a given articulate root node /// </summary> /// <param name="selectCols"></param> /// <param name="masterModel"></param> /// <param name="sqlSyntax"></param> /// <param name="publishedDatePropertyTypeId"> /// This is needed to perform the sorting on published date, this is the PK of the property type for publishedDate on the ArticulatePost content type /// </param> /// <returns></returns> /// <remarks> /// TODO: We won't need this when this is fixed http://issues.umbraco.org/issue/U4-9290 /// </remarks> private static Sql GetContentByTagQueryForPaging(string selectCols, IMasterModel masterModel, ISqlSyntaxProvider sqlSyntax, int publishedDatePropertyTypeId) { var sql = new Sql() .Select(selectCols) .From("umbracoNode") .InnerJoin("cmsDocument") .On("cmsDocument.nodeId = umbracoNode.id") .InnerJoin("cmsPropertyData") .On("cmsPropertyData.versionId = cmsDocument.versionId") .Where("umbracoNode.nodeObjectType = @nodeObjectType", new { nodeObjectType = Constants.ObjectTypes.Document }) //Must be published, this will ensure there's only one version selected .Where("cmsDocument.published = 1") //must only return rows with the publishedDate property data so we only get one row and so we can sort on `cmsPropertyData.dataDate` which will be the publishedDate .Where("cmsPropertyData.propertytypeid = @propTypeId", new { propTypeId = publishedDatePropertyTypeId }) //only get nodes underneath the current articulate root .Where("umbracoNode." + sqlSyntax.GetQuotedColumnName("path") + " LIKE @path", new { path = masterModel.RootBlogNode.Path + ",%" }); return(sql); }
/// <summary> /// Initializes a new instance of the <see cref="AnonymousCustomerService"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The SQL syntax. /// </param> public AnonymousCustomerService(ILogger logger, ISqlSyntaxProvider sqlSyntax) : this(logger, new RepositoryFactory(logger, sqlSyntax)) { }
public static Sql GroupBy <TColumn>(this Sql sql, Expression <Func <TColumn, object> > columnMember, ISqlSyntaxProvider sqlProvider) { var column = ExpressionHelper.FindProperty(columnMember) as PropertyInfo; var columnName = column.FirstAttribute <ColumnAttribute>().Name; return(sql.GroupBy(sqlProvider.GetQuotedColumnName(columnName))); }
/// <summary> /// Gets the basic tag SQL used to retrieve tags for a given articulate root node /// </summary> /// <param name="selectCols"></param> /// <param name="masterModel"></param> /// <param name="sqlSyntax"></param> /// <returns></returns> /// <remarks> /// TODO: We won't need this when this is fixed http://issues.umbraco.org/issue/U4-9290 /// </remarks> private static Sql GetTagQuery(string selectCols, IMasterModel masterModel, ISqlSyntaxProvider sqlSyntax) { var sql = new Sql() .Select(selectCols) .From("cmsTags") .InnerJoin("cmsTagRelationship") .On("cmsTagRelationship.tagId = cmsTags.id") .InnerJoin("cmsContent") .On("cmsContent.nodeId = cmsTagRelationship.nodeId") .InnerJoin("umbracoNode") .On("umbracoNode.id = cmsContent.nodeId") .Where("umbracoNode.nodeObjectType = @nodeObjectType", new {nodeObjectType = Constants.ObjectTypes.Document}) //only get nodes underneath the current articulate root .Where("umbracoNode." + sqlSyntax.GetQuotedColumnName("path") + " LIKE @path", new {path = masterModel.RootBlogNode.Path + ",%"}); return sql; }
public RepositoryFactory( bool disableAllCache, IRuntimeCacheProvider nullCacheProvider, IRuntimeCacheProvider runtimeCacheProvider, ILogger logger, ISqlSyntaxProvider sqlSyntaxProvider) : this(ApplicationContext.Current.ApplicationCache, logger, sqlSyntaxProvider) { }
/// <summary> /// Constructor /// </summary> /// <param name="work"></param> /// <param name="cacheHelper"></param> /// <param name="logger"></param> /// <param name="sqlSyntax"></param> /// <param name="passwordConfiguration"> /// A dictionary specifying the configuration for user passwords. If this is null then no password configuration will be persisted or read. /// </param> public UserRepository(IScopeUnitOfWork work, CacheHelper cacheHelper, ILogger logger, ISqlSyntaxProvider sqlSyntax, IDictionary <string, string> passwordConfiguration = null) : base(work, cacheHelper, logger, sqlSyntax) { _passwordConfiguration = passwordConfiguration; }
public UpdateAllowedMediaTypesAtRoot(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
/// <summary> /// Initializes a new instance of the <see cref="CustomerAddressService"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The SQL syntax. /// </param> public CustomerAddressService(ILogger logger, ISqlSyntaxProvider sqlSyntax) : this(new RepositoryFactory(logger, sqlSyntax), logger) { }
internal AddIndexToUmbracoNodeTable(ISqlSyntaxProvider sqlSyntax, ILogger logger, bool skipIndexCheck) : base(sqlSyntax, logger) { _skipIndexCheck = skipIndexCheck; }
/// <summary> /// Initializes a new instance of the <see cref="RepositoryFactory"/> class. /// </summary> /// <param name="cache"> /// The cache. /// </param> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntaxProvider"> /// The sql syntax provider. /// </param> internal RepositoryFactory(CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntaxProvider) { _cacheHelper = cache; _logger = logger; _sqlSyntax = sqlSyntaxProvider; }
public AddIndexToUmbracoNodeTable(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
/// <summary> /// Initializes a new instance of the <see cref="StoreSettingService"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The SQL syntax. /// </param> public StoreSettingService(ILogger logger, ISqlSyntaxProvider sqlSyntax) : this(new RepositoryFactory(logger, sqlSyntax), logger) { }
public UpdateDataExpression(DatabaseProviders current, DatabaseProviders[] databaseProviders, ISqlSyntaxProvider sqlSyntax) : base(current, databaseProviders, sqlSyntax) { }
public LocalMigrationContext(DatabaseProviders databaseProvider, Database database, ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(databaseProvider, database, logger) { _sqlSyntax = sqlSyntax; }
/// <summary> /// Initializes a new instance of the <see cref="AppliedPaymentService"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The sql syntax. /// </param> public AppliedPaymentService(ILogger logger, ISqlSyntaxProvider sqlSyntax) : this(logger, new RepositoryFactory(logger, sqlSyntax)) { }
public AddSprintProgressTablePk(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
/// <summary> /// Initializes a new instance of the <see cref="AddRedirectPaymentMethodType"/> class. /// </summary> /// <param name="sqlSyntax"> /// The SQL syntax. /// </param> /// <param name="logger"> /// The logger. /// </param> public AddRedirectPaymentMethodType(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { var dbContext = ApplicationContext.Current.DatabaseContext; _database = dbContext.Database; }
public EnsureAppsTreesUpdated(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
/// <summary> /// Initializes a new instance of the <see cref="ProductVariantService"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The SQL syntax. /// </param> public ProductVariantService(ILogger logger, ISqlSyntaxProvider sqlSyntax) : this(new RepositoryFactory(logger, sqlSyntax), logger) { }
public DataTypeDefinitionRepository(IDatabaseUnitOfWork work, CacheHelper cache, CacheHelper cacheHelper, ILogger logger, ISqlSyntaxProvider sqlSyntax, IContentTypeRepository contentTypeRepository) : base(work, cache, logger, sqlSyntax) { _cacheHelper = cacheHelper; _contentTypeRepository = contentTypeRepository; _preValRepository = new DataTypePreValueRepository(work, CacheHelper.CreateDisabledCacheHelper(), logger, sqlSyntax); }
/// <summary> /// Initializes a new instance of the <see cref="WebMigrationManager"/> class. /// </summary> /// <param name="database"> /// The database. /// </param> /// <param name="sqlSyntax"> /// The SQL syntax. /// </param> /// <param name="logger"> /// The logger. /// </param> /// <remarks> /// Used for testing /// </remarks> internal WebMigrationManager(Database database, ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(database, sqlSyntax, logger) { }
public DataTypePreValueRepository(IDatabaseUnitOfWork work, CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntax) : base(work, cache, logger, sqlSyntax) { }
/// <summary> /// Initializes a new instance of the <see cref="RepositoryFactory"/> class. /// </summary> /// <param name="disableAllCache"> /// The disable all cache. /// </param> /// <param name="nullCacheProvider"> /// The null cache provider. /// </param> /// <param name="runtimeCacheProvider"> /// The runtime cache provider. /// </param> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntaxProvider"> /// The SQL syntax provider. /// </param> public RepositoryFactory( bool disableAllCache, IRuntimeCacheProvider nullCacheProvider, IRuntimeCacheProvider runtimeCacheProvider, ILogger logger, ISqlSyntaxProvider sqlSyntaxProvider) { _disableAllCache = disableAllCache; _nullCacheProvider = nullCacheProvider; _runtimeCacheProvider = runtimeCacheProvider; _logger = logger; _sqlSyntax = sqlSyntaxProvider; }
public AlterTagsTable(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
/// <summary> /// Initializes a new instance of the <see cref="WebBootManager"/> class. /// Constructor for unit tests, ensures some resolvers are not initialized /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The <see cref="ISqlSyntaxProvider"/> /// </param> /// <param name="isForTesting"> /// The is For Testing. /// </param> internal WebBootManager(ILogger logger, ISqlSyntaxProvider sqlSyntax, bool isForTesting = false) : base(logger, sqlSyntax) { _isForTesting = isForTesting; }
public DeleteIndexExpression(DatabaseProviders current, DatabaseProviders[] databaseProviders, ISqlSyntaxProvider sqlSyntax) : base(current, databaseProviders, sqlSyntax) { Index = new IndexDefinition(); }
/// <summary> /// Initializes a new instance of the <see cref="DatabaseSchemaCreation"/> class. /// </summary> /// <param name="database"> /// The database. /// </param> /// <param name="logger"> /// The logger. /// </param> /// <param name="databaseSchemaHelper"> /// The database Schema Helper. /// </param> public DatabaseSchemaCreation(Database database, ILogger logger, DatabaseSchemaHelper databaseSchemaHelper, ISqlSyntaxProvider sqlSyntax) { _database = database; _logger = logger; _umbSchemaHelper = databaseSchemaHelper; _sqlSyntax = sqlSyntax; }
public LanguageRepository(IScopeUnitOfWork work, CacheHelper cache, ILogger logger, ISqlSyntaxProvider sqlSyntax) : base(work, cache, logger, sqlSyntax) { }
public AddRegexToRedirectsTable(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
public AddTourDataUserColumn(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
/// <summary> /// Initializes a new instance of the <see cref="PaymentService"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The SQL syntax. /// </param> public PaymentService(ILogger logger, ISqlSyntaxProvider sqlSyntax) : this(logger, sqlSyntax, new AppliedPaymentService(logger, sqlSyntax)) { }
/// <summary> /// Initializes a new instance of the <see cref="ShipmentService"/> class. /// </summary> /// <param name="logger"> /// The logger. /// </param> /// <param name="sqlSyntax"> /// The sql syntax. /// </param> public ShipmentService(ILogger logger, ISqlSyntaxProvider sqlSyntax) : this(new RepositoryFactory(logger, sqlSyntax), logger) { }
/// <summary> /// Initializes a new instance of the <see cref="MerchelloMigrationBase"/> class. /// </summary> /// <param name="sqlSyntax"> /// The SQL syntax. /// </param> /// <param name="logger"> /// The logger. /// </param> protected MerchelloMigrationBase(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
public NormalizeTemplateGuids(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
public AddMissingForeignKeyForContentType(ISqlSyntaxProvider sqlSyntax, ILogger logger) : base(sqlSyntax, logger) { }
public static Sql OrderByDescending <TColumn>(this Sql sql, Expression <Func <TColumn, object> > columnMember, ISqlSyntaxProvider sqlSyntax) { var column = ExpressionHelper.FindProperty(columnMember) as PropertyInfo; var columnName = column.FirstAttribute <ColumnAttribute>().Name; var type = typeof(TColumn); var tableNameAttribute = type.FirstAttribute <TableNameAttribute>(); string tableName = tableNameAttribute == null ? string.Empty : tableNameAttribute.Value; var syntax = string.Format("{0}.{1} DESC", sqlSyntax.GetQuotedTableName(tableName), sqlSyntax.GetQuotedColumnName(columnName)); return(sql.OrderBy(syntax)); }