public void GetJobs_MixedCasing_ReturnsJob() { string arrangeSql = @" insert into """ + ConnectionUtils.GetSchemaName() + @""".""job"" (""invocationdata"", ""arguments"", ""createdat"") values (@invocationData, @arguments, now() at time zone 'utc') returning ""id"""; var job = Job.FromExpression(() => SampleMethod("Hello")); var invocationData = InvocationData.Serialize(job); UseConnection(sql => { var jobId = sql.Query(arrangeSql, new { invocationData = JobHelper.ToJson(invocationData), arguments = invocationData.Arguments, }).Single().id.ToString(); var state = new Mock <IState>(); state.Setup(x => x.Name).Returns(SucceededState.StateName); state.Setup(x => x.SerializeData()) .Returns(new Dictionary <string, string> { { "SUCCEEDEDAT", "2018-05-03T13:28:18.3939693Z" }, { "PerformanceDuration", "53" }, { "latency", "6730" } }); Commit(sql, x => x.SetJobState(jobId, state.Object)); var monitoringApi = _storage.GetMonitoringApi(); var jobs = monitoringApi.SucceededJobs(0, 10); Assert.NotNull(jobs); }); }
private static string GetSchemaName() { return(ConnectionUtils.GetSchemaName()); }
private NpgsqlConnection CreateConnection() { return(ConnectionUtils.CreateConnection()); }
private PostgreSqlStorage CreateStorage() { return(new PostgreSqlStorage( ConnectionUtils.GetConnectionString(), _options)); }
private static string GetSchemaName() => ConnectionUtils.GetSchemaName();
private CountersAggregationManager CreateManager() { var connectionProvider = ConnectionUtils.GetConnectionProvider(); return(new CountersAggregationManager(connectionProvider, TimeSpan.FromSeconds(1))); }
public PostgreSqlFetchedJobFacts() { _options = new PostgreSqlStorageOptions(); _storage = new PostgreSqlStorage(ConnectionUtils.GetConnectionString()); }
private static JobQueue CreateJobQueue() { var provider = ConnectionUtils.GetConnectionProvider(); return(new JobQueue(provider, new PostgreSqlStorageOptions())); }
private static DefaultConnectionProvider CreateProvider() => new DefaultConnectionProvider(ConnectionUtils.GetConnectionString());
public static void CleanTables(NpgsqlConnection connection) { if (connection == null) { throw new ArgumentNullException(nameof(connection)); } string script = null; script = GetStringResource( typeof(PostgreSqlTestObjectsInitializer).GetTypeInfo().Assembly, "Hangfire.PostgreSql.Tests.Clean.sql").Replace("'hangfire'", string.Format("'{0}'", ConnectionUtils.GetSchemaName())); //connection.Execute(script); using (var transaction = connection.BeginTransaction(IsolationLevel.Serializable)) using (var command = new NpgsqlCommand(script, connection, transaction)) { command.CommandTimeout = 120; try { command.ExecuteNonQuery(); transaction.Commit(); } catch (NpgsqlException) { throw; } } }
private static ExpirationManager CreateManager() => new ExpirationManager(ConnectionUtils.GetConnectionProvider(), TimeSpan.Zero);
private static NpgsqlConnection CreateConnection() => ConnectionUtils.CreateNpgConnection();
public ExpirationManagerFacts() { _storage = new PostgreSqlStorage(ConnectionUtils.GetConnectionString()); _token = new CancellationToken(true); }
private PostgreSqlStorage CreateStorage() => new PostgreSqlStorage(ConnectionUtils.GetConnectionString(), _options);