/
SqlServerDelegate.cs
84 lines (72 loc) · 2.71 KB
/
SqlServerDelegate.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
#region License
/*
* Copyright 2009- Marko Lahma
*
* Licensed under the Apache License, Version 2.0 (the "License"); you may not
* use this file except in compliance with the License. You may obtain a copy
* of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
* WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
* License for the specific language governing permissions and limitations
* under the License.
*
*/
#endregion
using System;
using System.Data.Common;
namespace Quartz.Impl.AdoJobStore
{
/// <summary>
/// A SQL Server specific driver delegate.
/// </summary>
/// <author>Marko Lahma</author>
public class SqlServerDelegate : StdAdoDelegate
{
/// <summary>
/// Gets the select next trigger to acquire SQL clause.
/// SQL Server specific version with TOP functionality
/// </summary>
/// <returns></returns>
protected override string GetSelectNextTriggerToAcquireSql(int maxCount)
{
string sqlSelectNextTriggerToAcquire = SqlSelectNextTriggerToAcquire;
// add limit clause to correct place
sqlSelectNextTriggerToAcquire = "SELECT TOP " + maxCount + " " + sqlSelectNextTriggerToAcquire.Substring(6);
return sqlSelectNextTriggerToAcquire;
}
protected override string GetSelectNextMisfiredTriggersInStateToAcquireSql(int count)
{
if (count != -1)
{
var sqlSelectHasMisfiredTriggersInState = SqlSelectHasMisfiredTriggersInState;
// add limit clause to correct place
sqlSelectHasMisfiredTriggersInState = "SELECT TOP " + count + " " + sqlSelectHasMisfiredTriggersInState.Substring(6);
return sqlSelectHasMisfiredTriggersInState;
}
return base.GetSelectNextMisfiredTriggersInStateToAcquireSql(count);
}
public override void AddCommandParameter(
DbCommand cmd,
string paramName,
object? paramValue,
Enum? dataType = null,
int? size = null)
{
// deeded for SQL Server CE
if (paramValue is bool && dataType == null)
{
paramValue = (bool) paramValue ? 1 : 0;
}
// varbinary support
if (size == null && dataType != null && dataType.Equals(DbProvider.Metadata.DbBinaryType))
{
size = -1;
}
base.AddCommandParameter(cmd, paramName, paramValue, dataType, size);
}
}
}