private string GetInsertStatement(SqlVendor vendor)
{
var headerSb = new StringBuilder();
var valuesSb = new StringBuilder();
headerSb.AppendFormat("INSERT INTO {0} (", parent.TableName);
valuesSb.Append(" VALUES(");
int i = 0;
foreach (var columnValue in _columnValues.Values)
{
headerSb.Append(columnValue.Key);
valuesSb.Append(columnValue.GetValue(vendor));
if (i < (_columnValues.Count - 1))
{
headerSb.Append(", ");
valuesSb.Append(", ");
}
i++;
}
headerSb.Append(")");
valuesSb.Append(")");
headerSb.Append(valuesSb);
return(headerSb.ToString());
}
private string GetUpdateStatement(SqlVendor vendor)
{
var sb = new StringBuilder();
sb.AppendFormat("UPDATE {0} SET ", parent.TableName);
int i = 0;
// Can't include unique id column name in update because
// it is considered an error in some database engines
// (SQL Server, for instance).
var query = _columnValues.Where(pair => pair.Key.ToUpper() != idKeyValuePair.Key.ToUpper());
int queryCount = query.Count();
foreach (var pair in query)
{
var columnValue = pair.Value;
sb.AppendFormat("{0} = {1}", columnValue.Key, columnValue.GetValue(vendor));
if (i < (queryCount - 1))
{
sb.Append(", ");
}
i++;
}
sb.AppendFormat(" WHERE {0} = {1}", idKeyValuePair.Key, idKeyValuePair.Value);
return(sb.ToString());
}
public string GetValue(SqlVendor vendor)
{
if (SqlVendor.Oracle == vendor && _value is DateTime)
{
var dt = (DateTime)_value;
return(string.Format(
"to_date('{0}/{1}/{2} {3}:{4}:{5}', 'YYYY/MM/DD HH:MI:SS')",
dt.Year,
dt.Month.ToString(CultureInfo.InvariantCulture).PadLeft(2, '0'),
dt.Day.ToString(CultureInfo.InvariantCulture).PadLeft(2, '0'),
dt.Hour.ToString(CultureInfo.InvariantCulture).PadLeft(2, '0'),
dt.Minute.ToString(CultureInfo.InvariantCulture).PadLeft(2, '0'),
dt.Second.ToString(CultureInfo.InvariantCulture).PadLeft(2, '0')));
}
return(_shouldFormat ? _value.ToSqlValueString() : _value.ToString());
}
public string GetValue(SqlVendor vendor)
{
if (SqlVendor.Oracle == vendor && _value is DateTime)
{
var dt = (DateTime) _value;
return string.Format(
"to_date('{0}/{1}/{2} {3}:{4}:{5}', 'YYYY/MM/DD HH:MI:SS')",
dt.Year,
dt.Month.ToString(CultureInfo.InvariantCulture).PadLeft(2, '0'),
dt.Day.ToString(CultureInfo.InvariantCulture).PadLeft(2, '0'),
dt.Hour.ToString(CultureInfo.InvariantCulture).PadLeft(2, '0'),
dt.Minute.ToString(CultureInfo.InvariantCulture).PadLeft(2, '0'),
dt.Second.ToString(CultureInfo.InvariantCulture).PadLeft(2, '0'));
}
return _shouldFormat ? _value.ToSqlValueString() : _value.ToString();
}
/// <summary>
/// Initializes a new instance of the <see cref="AbstractConnectionAttribute"/> class.
/// </summary>
/// <param name="vendor">The vendor.</param>
protected AbstractConnectionAttribute(SqlVendor vendor)
{
Vendor = vendor;
}
/// <summary>
/// Initializes a new instance of the <see cref="ConnectionFromFile"/> class.
/// </summary>
/// <param name="vendor">The vendor.</param>
public ConnectionFromFile(SqlVendor vendor)
: base(vendor)
{
}
/// <summary>
/// Initializes a new instance of the <see cref="ConnectionAttribute"/> class.
/// </summary>
/// <param name="vendor">The vendor.</param>
/// <param name="connectionString">The connection string.</param>
public ConnectionAttribute(SqlVendor vendor, string connectionString) : base(vendor)
{
this.connectionString = connectionString;
}
public string GetValue(SqlVendor vendor)
{
return Value;
}
private string GetUpdateStatement(SqlVendor vendor)
{
var sb = new StringBuilder();
sb.AppendFormat("UPDATE {0} SET ", parent.TableName);
int i = 0;
// Can't include unique id column name in update because
// it is considered an error in some database engines
// (SQL Server, for instance).
var query = _columnValues.Where(pair => pair.Key.ToUpper() != idKeyValuePair.Key.ToUpper());
int queryCount = query.Count();
foreach (var pair in query)
{
var columnValue = pair.Value;
sb.AppendFormat("{0} = {1}", columnValue.Key, columnValue.GetValue(vendor));
if (i < (queryCount - 1))
{
sb.Append(", ");
}
i++;
}
sb.AppendFormat(" WHERE {0} = {1}", idKeyValuePair.Key, idKeyValuePair.Value);
return sb.ToString();
}
private string GetInsertStatement(SqlVendor vendor)
{
var headerSb = new StringBuilder();
var valuesSb = new StringBuilder();
headerSb.AppendFormat("INSERT INTO {0} (", parent.TableName);
valuesSb.Append(" VALUES(");
int i = 0;
foreach (var columnValue in _columnValues.Values)
{
headerSb.Append(columnValue.Key);
valuesSb.Append(columnValue.GetValue(vendor));
if (i < (_columnValues.Count-1))
{
headerSb.Append(", ");
valuesSb.Append(", ");
}
i++;
}
headerSb.Append(")");
valuesSb.Append(")");
headerSb.Append(valuesSb);
return headerSb.ToString();
}
public TestConnectionAttribute(SqlVendor vendor) : base(vendor)
{
}
public string GetValue(SqlVendor vendor)
{
return(Value);
}
public TestConnectionAttribute(SqlVendor vendor)
: base(vendor)
{
}
