// // // ************************************* // **** 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()); }