예제 #1
0
        public void GetUnderlyingsTest()
        {
            var wikifolioGuid = new Guid("C03CD005-2A25-4A10-A127-903D2135DFB1");
            var virtualOrderStatementBuilder = new Extractor.StatementBuilder.VirtualOrder(wikifolioGuid, 20);

            Assert.That(
                virtualOrderStatementBuilder.GetUnderlyingsQueryStatement(),
                Is.EqualTo("SELECT [Underlying] FROM dbo.[VirtualOrder] WHERE " + this.ExpectedCondition(20, wikifolioGuid)));
        }
예제 #2
0
        public void QueryStatementTest()
        {
            var wikifolioGuid = new Guid("C03CD005-2A25-4A10-A127-903D2135DFB1");
            var virtualOrderStatementBuilder = new Extractor.StatementBuilder.VirtualOrder(wikifolioGuid);

            this.AssertQueryStatement(virtualOrderStatementBuilder, wikifolioGuid, 50);

            var virtualOrderStatementBuilderWithLimit = new Extractor.StatementBuilder.VirtualOrder(wikifolioGuid, 10);

            this.AssertQueryStatement(virtualOrderStatementBuilderWithLimit, wikifolioGuid, 10);
        }
예제 #3
0
 private void AssertQueryStatement(
     Extractor.StatementBuilder.VirtualOrder virtualOrderStatementBuilder,
     Guid wikifolioGuid,
     int limit)
 {
     Assert.AreEqual(
         "SELECT [ID],[Wikifolio],[Underlying],[Stop],[Limit],[Amount],[CreationDate],[ValidUntilDate],[Status],"
         + "[VirtualOrderGroup],[ActivatingVirtualOrder],[OrderType],[ExecutionPrice],[ExecutionDate],"
         + "[RealisedGainUnderlying],[StatusErrorCode],[PhoneOrder],[OriginalVirtualOrder],[UpdateDate],"
         + "[TakeProfitVirtualOrder],[StopLossVirtualOrder],[MainOrder],[RowVersion],[Weight] "
         + "FROM dbo.[VirtualOrder] WHERE " + this.ExpectedCondition(limit, wikifolioGuid),
         virtualOrderStatementBuilder.QueryStatement());
 }