public User GetUserByEmail(DfpUser user, string email) {
UserService userService = (UserService) user.GetService(DfpService.v201411.UserService);
// Create a Statement to get all users sorted by name.
Statement statement = new Statement();
statement.query = string.Format("where email = '{0}' LIMIT 1", email);
UserPage page = userService.getUsersByStatement(statement);
if (page.results != null && page.results.Length > 0) {
return page.results[0];
} else {
return null;
}
}
private static bool StatementsAreEqual(Statement s1, Statement s2) {
// Assumes both Statements are non-null and have non-null properties
if (String.Compare(s1.query, s2.query, true) != 0) {
return false;
}
if (s1.values.Length != s2.values.Length) {
return false;
}
// Assumes Statement values are in the same order
for (int i = 0; i < s1.values.Length; i++) {
if (!StringValueMapEntriesAreEqual(s1.values[i], s2.values[i])) {
return false;
}
}
return true;
}
public virtual UpdateResult performAdRuleAction(AdRuleAction adRuleAction, Statement filterStatement) {
object[] results = this.Invoke("performAdRuleAction", new object[] { adRuleAction, filterStatement });
return ((UpdateResult) (results[0]));
}
public AdUnit FindRootAdUnit(DfpUser user) {
// Get InventoryService.
InventoryService inventoryService =
(InventoryService)user.GetService(DfpService.v201411.InventoryService);
// Create a Statement to only select the root ad unit.
Statement statement = new Statement();
statement.query = "WHERE parentId IS NULL LIMIT 500";
// Get ad units by Statement.
AdUnitPage page = inventoryService.getAdUnitsByStatement(statement);
return page.results[0];
}
public void TestPerformPlacementAction() {
Statement statement = new Statement();
statement.query = string.Format("WHERE status = '{0}'", InventoryStatus.ACTIVE);
DeactivatePlacements action = new DeactivatePlacements();
UpdateResult result = null;
Assert.DoesNotThrow(delegate() {
result = placementService.performPlacementAction(action, statement);
});
Assert.NotNull(result);
Assert.GreaterOrEqual(result.numChanges, 0);
}
public void TestPerformLineItemCreativeAssociationAction() {
Statement statement = new Statement();
statement.query = string.Format("WHERE lineItemId = '{0}' LIMIT 1", lineItemId3);
DeactivateLineItemCreativeAssociations action = new DeactivateLineItemCreativeAssociations();
UpdateResult result = null;
Assert.DoesNotThrow(delegate() {
result = licaService.performLineItemCreativeAssociationAction(action, statement);
});
Assert.NotNull(result);
Assert.AreEqual(result.numChanges, 1);
}
public void TestStatementBuilderIncludesKeywordPrefix() {
StatementBuilder statementBuilder = new StatementBuilder()
.Where("WHEREWITHALL = 1");
Statement expectedStatement = new Statement();
expectedStatement.query = "WHERE WHEREWITHALL = 1";
expectedStatement.values = new String_ValueMapEntry[0];
Assert.True(StatementsAreEqual(expectedStatement,
statementBuilder.ToStatement()));
}
public void TestStatementBuilderBlankStatement() {
StatementBuilder statementBuilder = new StatementBuilder();
Statement expectedStatement = new Statement();
expectedStatement.query = "";
expectedStatement.values = new String_ValueMapEntry[0];
Assert.True(StatementsAreEqual(expectedStatement,
statementBuilder.ToStatement()));
}
public virtual CreativeSetPage getCreativeSetsByStatement(Statement statement) {
object[] results = this.Invoke("getCreativeSetsByStatement", new object[] { statement });
return ((CreativeSetPage) (results[0]));
}
public virtual UpdateResult performProposalLineItemAction(ProposalLineItemAction proposalLineItemAction, Statement filterStatement) {
object[] results = this.Invoke("performProposalLineItemAction", new object[] { proposalLineItemAction, filterStatement });
return ((UpdateResult) (results[0]));
}
public virtual ProposalLineItemPage getProposalLineItemsByStatement(Statement filterStatement) {
object[] results = this.Invoke("getProposalLineItemsByStatement", new object[] { filterStatement });
return ((ProposalLineItemPage) (results[0]));
}
public virtual UpdateResult performLineItemCreativeAssociationAction(LineItemCreativeAssociationAction lineItemCreativeAssociationAction, Statement filterStatement) {
object[] results = this.Invoke("performLineItemCreativeAssociationAction", new object[] { lineItemCreativeAssociationAction, filterStatement });
return ((UpdateResult) (results[0]));
}
public virtual LineItemCreativeAssociationPage getLineItemCreativeAssociationsByStatement(Statement filterStatement) {
object[] results = this.Invoke("getLineItemCreativeAssociationsByStatement", new object[] { filterStatement });
return ((LineItemCreativeAssociationPage) (results[0]));
}
public virtual UpdateResult performSharedAdUnitAction(SharedAdUnitAction sharedAdUnitAction, Statement filterStatement) {
object[] results = this.Invoke("performSharedAdUnitAction", new object[] { sharedAdUnitAction, filterStatement });
return ((UpdateResult) (results[0]));
}
public virtual SharedAdUnitPage getSharedAdUnitsByStatement(Statement filterStatement) {
object[] results = this.Invoke("getSharedAdUnitsByStatement", new object[] { filterStatement });
return ((SharedAdUnitPage) (results[0]));
}
public void TestCreateOrders() {
Order order1 = new Order();
order1.name = string.Format("Order #{0}", new TestUtils().GetTimeStamp());
order1.advertiserId = advertiserId;
order1.traffickerId = traffickerId;
order1.currencyCode = "USD";
Order order2 = new Order();
order2.name = string.Format("Order #{0}", new TestUtils().GetTimeStamp());
order2.advertiserId = advertiserId;
order2.traffickerId = traffickerId;
order2.currencyCode = "USD";
Order[] newOrders = null;
Assert.DoesNotThrow(delegate() {
newOrders = orderService.createOrders(new Order[] {order1, order2});
});
Statement statement = new Statement();
statement.query = string.Format("WHERE advertiserId = '{0}' LIMIT 500", advertiserId);
OrderPage page = orderService.getOrdersByStatement(statement);
Assert.NotNull(newOrders);
Assert.AreEqual(newOrders.Length, 2);
Assert.AreEqual(order1.name, newOrders[0].name);
Assert.AreEqual(order1.advertiserId, newOrders[0].advertiserId);
Assert.AreEqual(order1.traffickerId, newOrders[0].traffickerId);
Assert.AreEqual(order1.currencyCode, newOrders[0].currencyCode);
Assert.AreEqual(order2.name, newOrders[1].name);
Assert.AreEqual(order2.advertiserId, newOrders[1].advertiserId);
Assert.AreEqual(order2.traffickerId, newOrders[1].traffickerId);
Assert.AreEqual(order2.currencyCode, newOrders[1].currencyCode);
}
public void TestGetCompaniesByStatement() {
Statement statement = new Statement();
statement.query = string.Format("WHERE id = {0} ORDER BY name LIMIT 1", testCompany1.id);
CompanyPage page = null;
Assert.DoesNotThrow(delegate() {
page = companyService.getCompaniesByStatement(statement);
});
Assert.NotNull(page);
Assert.NotNull(page.results);
Assert.AreEqual(page.results.Length, 1);
Assert.NotNull(page.results[0]);
Assert.AreEqual(page.results[0].id, testCompany1.id);
Assert.AreEqual(page.results[0].name, testCompany1.name);
}
public virtual CompanyPage getCompaniesByStatement(Statement filterStatement) {
object[] results = this.Invoke("getCompaniesByStatement", new object[] { filterStatement });
return ((CompanyPage) (results[0]));
}
public void TestStatementBuilderBasicStatement() {
StatementBuilder statementBuilder = new StatementBuilder()
.Where("ID = 1");
Statement expectedStatement = new Statement();
expectedStatement.query = "WHERE ID = 1";
expectedStatement.values = new String_ValueMapEntry[0];
Assert.True(StatementsAreEqual(expectedStatement,
statementBuilder.ToStatement()));
}
public virtual CreativeWrapperPage getCreativeWrappersByStatement(Statement filterStatement) {
object[] results = this.Invoke("getCreativeWrappersByStatement", new object[] { filterStatement });
return ((CreativeWrapperPage) (results[0]));
}
public void TestAllStatementBuilderPartialFunctions() {
StatementBuilder statementBuilder = new StatementBuilder()
.Select("Name, Id")
.From("Geo_Target")
.Where("Targetable = :targetable")
.OrderBy("Id DESC")
.Limit(StatementBuilder.SUGGESTED_PAGE_LIMIT)
.Offset(0)
.AddValue("targetable", true)
.IncreaseOffsetBy(StatementBuilder.SUGGESTED_PAGE_LIMIT)
.RemoveLimitAndOffset();
Assert.AreEqual(null, statementBuilder.GetOffset());
Statement expectedStatement = new Statement();
expectedStatement.query = "SELECT Name, Id FROM Geo_Target"
+ " WHERE Targetable = :targetable ORDER BY Id DESC";
String_ValueMapEntry targetableEntry = new String_ValueMapEntry();
targetableEntry.key = "targetable";
BooleanValue targetableValue = new BooleanValue();
targetableValue.value = true;
targetableEntry.value = targetableValue;
expectedStatement.values = new String_ValueMapEntry[] {targetableEntry};
Assert.True(StatementsAreEqual(expectedStatement, statementBuilder.ToStatement()));
}
public virtual UpdateResult performCreativeWrapperAction(CreativeWrapperAction creativeWrapperAction, Statement filterStatement) {
object[] results = this.Invoke("performCreativeWrapperAction", new object[] { creativeWrapperAction, filterStatement });
return ((UpdateResult) (results[0]));
}
public void TestGetLineItemCreativeAssociationsByStatement() {
Statement statement = new Statement();
statement.query = string.Format("WHERE lineItemId = '{0}' LIMIT 500", lineItemId3);
LineItemCreativeAssociationPage page = null;
Assert.DoesNotThrow(delegate() {
page = licaService.getLineItemCreativeAssociationsByStatement(statement);
});
Assert.NotNull(page);
Assert.NotNull(page.results);
Assert.AreEqual(page.totalResultSetSize, 1);
Assert.NotNull(page.results[0]);
Assert.AreEqual(page.results[0].creativeId, lica1.creativeId);
Assert.AreEqual(page.results[0].lineItemId, lica1.lineItemId);
}
public virtual PlacementPage getPlacementsByStatement(Statement filterStatement) {
object[] results = this.Invoke("getPlacementsByStatement", new object[] { filterStatement });
return ((PlacementPage) (results[0]));
}
public void TestGetPlacementsByStatement() {
// Create a Statement to only select active placements.
Statement statement = new Statement();
statement.query = string.Format("WHERE id = '{0}'", placement.id);
PlacementPage page = null;
Assert.DoesNotThrow(delegate() {
page = placementService.getPlacementsByStatement(statement);
});
Assert.NotNull(page);
Assert.NotNull(page.results);
Assert.AreEqual(page.results.Length, 1);
Assert.AreEqual(page.results[0].id, placement.id);
Assert.AreEqual(page.results[0].name, placement.name);
Assert.AreEqual(page.results[0].description, placement.description);
Assert.Contains(adUnit1.id, page.results[0].targetedAdUnitIds);
Assert.Contains(adUnit2.id, page.results[0].targetedAdUnitIds);
}
public virtual UpdateResult performPlacementAction(PlacementAction placementAction, Statement filterStatement) {
object[] results = this.Invoke("performPlacementAction", new object[] { placementAction, filterStatement });
return ((UpdateResult) (results[0]));
}
/// <summary>
/// Gets the <see cref="Statement"/> representing the state of this
/// statement builder.
/// </summary>
/// <returns>The statement.</returns>
public Statement ToStatement() {
Statement statement = new Statement();
statement.query = BuildQuery();
statement.values = valueEntries.ToArray();
return statement;
}
public void TestPerformOrderAction() {
Statement statement = new Statement();
statement.query = string.Format("WHERE status IN ('{0}', '{1}')",
OrderStatus.DRAFT, OrderStatus.PENDING_APPROVAL);
ApproveOrders action = new ApproveOrders();
UpdateResult result = null;
Assert.DoesNotThrow(delegate() {
result = orderService.performOrderAction(action, statement);
});
Assert.NotNull(result);
Assert.GreaterOrEqual(result.numChanges, 0);
}
public void TestUpdateOrders() {
Statement statement = new Statement();
statement.query = String.Format("WHERE id = {0} LIMIT 1", orderId);
Order order = orderService.getOrdersByStatement(statement).results[0];
order.notes = "Spoke to advertiser. All is well.";
Order[] newOrders = null;
Assert.DoesNotThrow(delegate() {
newOrders = orderService.updateOrders(new Order[] {order});
});
Assert.NotNull(newOrders);
Assert.AreEqual(newOrders.Length, 1);
Assert.AreEqual(order.id, newOrders[0].id);
Assert.AreEqual(order.name, newOrders[0].name);
Assert.AreEqual(order.notes, newOrders[0].notes);
Assert.AreEqual(order.advertiserId, newOrders[0].advertiserId);
Assert.AreEqual(order.traffickerId, newOrders[0].traffickerId);
Assert.AreEqual(order.currencyCode, newOrders[0].currencyCode);
}
public virtual AdRulePage getAdRulesByStatement(Statement statement) {
object[] results = this.Invoke("getAdRulesByStatement", new object[] { statement });
return ((AdRulePage) (results[0]));
}