public User GetUserByEmail(DfpUser user, string email) {
UserService userService = (UserService) user.GetService(DfpService.v201505.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 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 ContentMetadataKeyHierarchyPage getContentMetadataKeyHierarchiesByStatement(Statement filterStatement) {
object[] results = this.Invoke("getContentMetadataKeyHierarchiesByStatement", new object[] { filterStatement });
return ((ContentMetadataKeyHierarchyPage) (results[0]));
}
public virtual CreativeSetPage getCreativeSetsByStatement(Statement statement) {
object[] results = this.Invoke("getCreativeSetsByStatement", new object[] { statement });
return ((CreativeSetPage) (results[0]));
}
public virtual WorkflowRequestPage getWorkflowRequestsByStatement(Statement filterStatement) {
object[] results = this.Invoke("getWorkflowRequestsByStatement", new object[] { filterStatement });
return ((WorkflowRequestPage) (results[0]));
}
public void TestPerformUserAction()
{
Statement statement = new Statement();
statement.query = string.Format("WHERE id = {0}", salespersonId);
DeactivateUsers action = new DeactivateUsers();
UpdateResult result = null;
Assert.DoesNotThrow(delegate() {
result = userService.performUserAction(action, statement);
});
Assert.NotNull(result);
Assert.AreEqual(result.numChanges, 1);
// Activate the user again.
Assert.DoesNotThrow(delegate() {
result = userService.performUserAction(new ActivateUsers(), statement);
});
Assert.NotNull(result);
Assert.AreEqual(result.numChanges, 1);
}
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 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 performAdExclusionRuleAction(AdExclusionRuleAction adExclusionRuleAction, Statement filterStatement) {
object[] results = this.Invoke("performAdExclusionRuleAction", new object[] { adExclusionRuleAction, filterStatement });
return ((UpdateResult) (results[0]));
}
public virtual SharedAdUnitPage getSharedAdUnitsByStatement(Statement filterStatement) {
object[] results = this.Invoke("getSharedAdUnitsByStatement", new object[] { filterStatement });
return ((SharedAdUnitPage) (results[0]));
}
public virtual CreativeTemplatePage getCreativeTemplatesByStatement(Statement filterStatement) {
object[] results = this.Invoke("getCreativeTemplatesByStatement", new object[] { filterStatement });
return ((CreativeTemplatePage) (results[0]));
}
public virtual AdExclusionRulePage getAdExclusionRulesByStatement(Statement filterStatement) {
object[] results = this.Invoke("getAdExclusionRulesByStatement", new object[] { filterStatement });
return ((AdExclusionRulePage) (results[0]));
}
public virtual AdRulePage getAdRulesByStatement(Statement statement) {
object[] results = this.Invoke("getAdRulesByStatement", new object[] { statement });
return ((AdRulePage) (results[0]));
}
public virtual TeamPage getTeamsByStatement(Statement filterStatement) {
object[] results = this.Invoke("getTeamsByStatement", new object[] { filterStatement });
return ((TeamPage) (results[0]));
}
public virtual UpdateResult performWorkflowRequestAction(WorkflowRequestAction action, Statement filterStatement) {
object[] results = this.Invoke("performWorkflowRequestAction", new object[] { action, filterStatement });
return ((UpdateResult) (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 virtual UpdateResult performSharedAdUnitAction(SharedAdUnitAction sharedAdUnitAction, Statement filterStatement) {
object[] results = this.Invoke("performSharedAdUnitAction", new object[] { sharedAdUnitAction, filterStatement });
return ((UpdateResult) (results[0]));
}
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 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 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 TestPerformAdUnitAction() {
Statement statement = new Statement();
statement.query = string.Format("WHERE id = '{0}' LIMIT 1", adUnit1.id);
UpdateResult result = null;
Assert.DoesNotThrow(delegate() {
result = inventoryService.performAdUnitAction(new DeactivateAdUnits(), statement);
});
Assert.NotNull(result);
Assert.AreEqual(result.numChanges, 1);
}
public virtual LineItemCreativeAssociationPage getLineItemCreativeAssociationsByStatement(Statement filterStatement) {
object[] results = this.Invoke("getLineItemCreativeAssociationsByStatement", new object[] { filterStatement });
return ((LineItemCreativeAssociationPage) (results[0]));
}
public virtual UpdateResult performContentMetadataKeyHierarchyAction(ContentMetadataKeyHierarchyAction contentMetadataKeyHierarchyAction, Statement filterStatement) {
object[] results = this.Invoke("performContentMetadataKeyHierarchyAction", new object[] { contentMetadataKeyHierarchyAction, filterStatement });
return ((UpdateResult) (results[0]));
}
public void TestGetAdUnitsByStatement() {
Statement statement = new Statement();
statement.query = string.Format("WHERE id = '{0}' LIMIT 1", adUnit1.id);
AdUnitPage page = null;
Assert.DoesNotThrow(delegate() {
page = inventoryService.getAdUnitsByStatement(statement);
});
Assert.NotNull(page);
Assert.NotNull(page.results);
Assert.AreEqual(page.totalResultSetSize, 1);
Assert.NotNull(page.results[0]);
Assert.AreEqual(page.results[0].name, adUnit1.name);
Assert.AreEqual(page.results[0].parentId, adUnit1.parentId);
Assert.AreEqual(page.results[0].id, adUnit1.id);
Assert.AreEqual(page.results[0].status, adUnit1.status);
Assert.AreEqual(page.results[0].targetWindow, adUnit1.targetWindow);
}
public virtual UpdateResult performLineItemCreativeAssociationAction(LineItemCreativeAssociationAction lineItemCreativeAssociationAction, Statement filterStatement) {
object[] results = this.Invoke("performLineItemCreativeAssociationAction", new object[] { lineItemCreativeAssociationAction, filterStatement });
return ((UpdateResult) (results[0]));
}
public void TestGetUsersByStatement()
{
Statement statement = new Statement();
statement.query = "ORDER BY name LIMIT 500";
UserPage page = null;
Assert.DoesNotThrow(delegate() {
page = userService.getUsersByStatement(statement);
});
Assert.NotNull(page);
Assert.NotNull(page.results);
List<long> salesPersonIds = new List<long>();
List<long> traffickerIds = new List<long>();
foreach(User tempUser in page.results) {
if (tempUser.roleName == "Salesperson") {
salesPersonIds.Add(tempUser.id);
} else if (tempUser.roleName == "Trafficker") {
traffickerIds.Add(tempUser.id);
}
}
Assert.Contains(salespersonId, salesPersonIds);
Assert.Contains(traffickerId, traffickerIds);
}
public virtual ProposalLineItemPage getProposalLineItemsByStatement(Statement filterStatement) {
object[] results = this.Invoke("getProposalLineItemsByStatement", new object[] { filterStatement });
return ((ProposalLineItemPage) (results[0]));
}
public void TestUpdateUsers()
{
Statement statement = new Statement();
statement.query = String.Format("WHERE id = {0} LIMIT 1", salespersonId);
User user = userService.getUsersByStatement(statement).results[0];
user.preferredLocale = (user.preferredLocale == "fr_FR")? "en_US" : "fr_FR";
User[] newUsers = null;
Assert.DoesNotThrow(delegate() {
newUsers = userService.updateUsers(new User[] {user});
});
Assert.NotNull(newUsers);
Assert.AreEqual(newUsers.Length, 1);
Assert.AreEqual(newUsers[0].id, user.id);
Assert.AreEqual(newUsers[0].preferredLocale, user.preferredLocale);
}
public virtual UpdateResult performProposalLineItemAction(ProposalLineItemAction proposalLineItemAction, Statement filterStatement) {
object[] results = this.Invoke("performProposalLineItemAction", new object[] { proposalLineItemAction, filterStatement });
return ((UpdateResult) (results[0]));
}
