//
//
// *************************************
// **** GetWriteQueryPrefix ****
// *************************************
public override string GetWriteQueryPrefix(DatabaseInfo dataBase)
{
TableInfo.UVFillsTableInfo table = dataBase.UVFills;
// Start of query
StringBuilder query = new StringBuilder();
query.AppendFormat("INSERT INTO {0}", table.TableNameFull);
//
// Fields to write
//
// Id
query.AppendFormat(" ({0}", table.StrategyId);
query.AppendFormat(",{0}", table.InstrumentId);
query.AppendFormat(",{0}", table.UserName);
query.AppendFormat(",{0}", table.RunType);
query.AppendFormat(",{0}", table.PricingEngineName);
// time stamp
query.AppendFormat(",{0}", table.TimeStamp);
query.AppendFormat(",{0}", table.UnixTime);
query.AppendFormat(",{0}", table.UnixMicroSecs);
// data fields
query.AppendFormat(",{0}", table.Qty);
query.AppendFormat(",{0}", table.Price);
query.AppendFormat(",{0}", table.AttributeString);
query.Append(") VALUES");
return(query.ToString());
}
}//
//
//
// *************************************
// **** ToString() ****
// *************************************
//
//
//
//
#endregion//Public Methods
#region Private Methods
// *************************************
// **** GetWriteQuery ****
// *************************************
/// <summary>
/// Caller would like to get a fully formed query to insert into database.
/// </summary>
/// <param name="dataBase"></param>
/// <returns></returns>
private string GetWriteQuery(DatabaseInfo dataBase)
{
TableInfo.UVFillsTableInfo table = dataBase.UVFills;
// Start of query
StringBuilder query = new StringBuilder();
query.Append(GetWriteQueryPrefix(dataBase));
query.AppendFormat("{0} {1};", GetWriteQueryPrefix(dataBase), GetWriteQuerySuffix(dataBase));
return(query.ToString());
}// GetWriteQuery()
//
//
// *************************************
// **** GetWriteQuerySuffix ****
// *************************************
public override string GetWriteQuerySuffix(DatabaseInfo dataBase)
{
TableInfo.UVFillsTableInfo table = dataBase.UVFills;
// Start of query
StringBuilder query = new StringBuilder();
//
// Values to write
//
if (m_ItemsToWrite.Count == 0)
{
return(string.Empty);
}
FillsQueryItem item = this.m_ItemsToWrite[0];
WriteValues(item, ref query);
for (int i = 1; i < m_ItemsToWrite.Count; ++i)
{
query.Append(", ");
item = this.m_ItemsToWrite[i];
WriteValues(item, ref query);
}
return(query.ToString());
}
