internal T GetListValueByName <T>(string value) where T : ListValue
{
var typeToken = GetAssetTypeToken(typeof(T));
var listType = MetaModel.GetAssetType(typeToken);
return(GetListValueByName <T>(listType, value));
}
private IAssetType GetRelatedType(Entity entity, string name)
{
var owningType = MetaModel.GetAssetType(GetAssetTypeToken(entity.GetType()));
var listTypeDef = owningType.GetAttributeDefinition(name);
return(listTypeDef.RelatedAsset);
}
public void ReOpenAnAssetTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
// create a new story
var projectId = Oid.FromToken("Scope:0", metaModel);
var assetType = metaModel.GetAssetType("Story");
var story = services.New(assetType, projectId);
var nameAttribute = assetType.GetAttributeDefinition("Name");
story.SetAttributeValue(nameAttribute, "My New Story");
services.Save(story);
// closes the story
var closeOperation = metaModel.GetOperation("Story.Inactivate");
var closeId = services.ExecuteOperation(closeOperation, story.Oid);
//reopens the story
var activateOperation = metaModel.GetOperation("Story.Reactivate");
var activeId = services.ExecuteOperation(activateOperation, story.Oid);
var query = new Query(activeId.Momentless);
var assetState = metaModel.GetAttributeDefinition("Story.AssetState");
query.Selection.Add(assetState);
var result = services.Retrieve(query);
Asset activeStory = result.Assets[0];
Assert.AreEqual("Active", activeStory.GetAttribute(assetState).Value.ToString());
}
public void HistorySingleAssetTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var memberType = metaModel.GetAssetType("Member");
var idAttribute = memberType.GetAttributeDefinition("ID");
var changeDateAttribute = memberType.GetAttributeDefinition("ChangeDate");
var emailAttribute = memberType.GetAttributeDefinition("Email");
// the boolean parameter specifies we want the historical data
var query = new Query(memberType, true);
query.Selection.Add(changeDateAttribute);
query.Selection.Add(emailAttribute);
var idTerm = new FilterTerm(idAttribute);
idTerm.Equal("Member:20");
query.Filter = idTerm;
var result = services.Retrieve(query);
Assert.AreNotEqual(0, result.Assets.Count);
}
public void UpdateMultiValueRelationTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var storyId = Oid.FromToken("Story:1124", metaModel);
var query = new Query(storyId);
var storyType = metaModel.GetAssetType("Story");
var ownersAttribute = storyType.GetAttributeDefinition("Owners");
query.Selection.Add(ownersAttribute);
var result = services.Retrieve(query);
var story = result.Assets[0];
var values = story.GetAttribute(ownersAttribute).Values;
var owners = values.Cast <object>().ToList();
if (owners.Count >= 1)
{
story.RemoveAttributeValue(ownersAttribute, owners[0]);
}
services.Save(story);
}
protected Object GetSingleListValue(VersionOne.SDK.APIClient.Attribute attribute)
{
if (attribute.Value != null && attribute.Value.ToString() != "NULL")
{
IAssetType assetType = _metaAPI.GetAssetType("List");
Query query = new Query(assetType);
IAttributeDefinition assetIDAttribute = assetType.GetAttributeDefinition("ID");
query.Selection.Add(assetIDAttribute);
IAttributeDefinition nameAttribute = assetType.GetAttributeDefinition("Name");
query.Selection.Add(nameAttribute);
FilterTerm assetName = new FilterTerm(assetIDAttribute);
assetName.Equal(attribute.Value.ToString());
query.Filter = assetName;
QueryResult result = _dataAPI.Retrieve(query);
return(result.Assets[0].GetAttribute(nameAttribute).Value.ToString());
}
else
{
return(DBNull.Value);
}
}
public void FindListOfAssetsTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var assetType = metaModel.GetAssetType("Story");
var query = new Query(assetType);
var nameAttribute = assetType.GetAttributeDefinition("Name");
var priorityAttribute = assetType.GetAttributeDefinition("Priority");
query.Selection.Add(nameAttribute);
query.Selection.Add(priorityAttribute);
query.Find = new QueryFind("High");
var result = services.Retrieve(query);
result.Assets.ForEach(
asset => Assert.IsTrue(asset.GetAttribute(nameAttribute)
.Value
.ToString()
.IndexOf("High", StringComparison.OrdinalIgnoreCase)
>= 0));
Assert.IsTrue(result.Assets.Count > 1);
}
public void DeleteAnAssetTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
// create a new story so we can delete it
var projectId = Oid.FromToken("Scope:0", metaModel);
var assetType = metaModel.GetAssetType("Story");
var newStory = services.New(assetType, projectId);
var nameAttribute = assetType.GetAttributeDefinition("Name");
newStory.SetAttributeValue(nameAttribute, "My New Story");
services.Save(newStory);
// delete the story
var deleteOperation = metaModel.GetOperation("Story.Delete");
var deletedId = services.ExecuteOperation(deleteOperation, newStory.Oid);
var query = new Query(deletedId.Momentless);
QueryResult result = services.Retrieve(query);
Assert.AreEqual(0, result.TotalAvaliable);
// The delete operation returns the Oid with the new Moment of the deleted asset.
// Future queries will automatically exclude deleted assets from results.
// Currently there is no support for undeleting a deleted asset.
}
public void QueryTrackedEpicsByProject()
{
var metaConnector = new V1APIConnector(VersionOneUrl + "meta.v1/", "admin", "admin");
var metaModel = new MetaModel(metaConnector);
var epicType = metaModel.GetAssetType("Epic");
var scopeType = metaModel.GetAssetType("Scope");
var query = new Query(epicType);
const string scopeId = "Scope:1025";
var notClosedScopeAttribute = scopeType.GetAttributeDefinition("AssetState");
var notClosedEpicAttribute = epicType.GetAttributeDefinition("AssetState");
var notClosedEpicTerm = new FilterTerm(notClosedEpicAttribute);
notClosedEpicTerm.NotEqual("Closed");
var notClosedScopeTerm = new FilterTerm(notClosedScopeAttribute);
notClosedScopeTerm.NotEqual("Closed");
var scopeAttribute = epicType.GetAttributeDefinition("Scope.ParentMeAndUp");
scopeAttribute = scopeAttribute.Filter(notClosedScopeTerm);
var scopeTerm = new FilterTerm(scopeAttribute);
scopeTerm.Equal(scopeId);
var superAndUpAttribute = epicType.GetAttributeDefinition("SuperAndUp");
superAndUpAttribute = superAndUpAttribute.Filter(scopeTerm);
var superAndUpTerm = new FilterTerm(superAndUpAttribute);
superAndUpTerm.NotExists();
var filter = new AndFilterTerm(scopeTerm, notClosedEpicTerm, superAndUpTerm);
query.Filter = filter;
var builder = new QueryURLBuilder(query);
var result = builder.ToString();
Assert.AreEqual("Data/Epic?sel=&where=(Epic.Scope.ParentMeAndUp[AssetState!='Closed']='Scope%3a1025';Epic.AssetState!='Closed';-Epic.SuperAndUp[Scope.ParentMeAndUp[AssetState!='Closed']='Scope:1025'])", result);
}
protected string CheckForDuplicateInV1(string AssetType, string AttributeName, string AttributeValue)
{
//if (AssetType.StartsWith("Custom_"))
//{
// return null;
//}
IAssetType assetType = _metaAPI.GetAssetType(AssetType);
//_logger.Info("CheckForDuplicateInV1: assetType is {0} amd value is {1} ", AssetType, AttributeValue);
Query query = new Query(assetType);
IAttributeDefinition valueAttribute = assetType.GetAttributeDefinition(AttributeName);
query.Selection.Add(valueAttribute);
FilterTerm idFilter = new FilterTerm(valueAttribute);
idFilter.Equal(AttributeValue);
query.Filter = idFilter;
QueryResult result = _dataAPI.Retrieve(query);
if (result.TotalAvaliable > 0)
{
return(result.Assets[0].Oid.Token.ToString());
}
else
{
return(null);
}
}
/// <summary>
/// Find an asset in the asset cache or create one for this id
/// </summary>
/// <param name="id"></param>
/// <param name="assetTypeToken">The Asset Type Token of the asset to create if one does not already exist</param>
/// <returns>An Asset that will exist in the asset cache</returns>
private Asset GetAsset(object id, string assetTypeToken)
{
Asset result;
if (!assetCache.TryGetValue(id, out result))
{
var assetType = MetaModel.GetAssetType(assetTypeToken);
var assetId = id as AssetID;
result = assetId != null ? new Asset(Oid.FromToken(assetId, MetaModel)) : new Asset(assetType);
SetAsset(id, result);
}
return(result);
}
public void TestFixtureSetUp()
{
V1APIConnector dataConnector = new V1APIConnector(v1Url + dataPath, username, password);
V1APIConnector metaConnector = new V1APIConnector(v1Url + metaPath);
V1APIConnector localConnector = new V1APIConnector(v1Url + localizationPath);
localizer = new Localizer(localConnector);
metaModel = new MetaModel(metaConnector);
services = new Services(metaModel, dataConnector);
timeboxType = metaModel.GetAssetType("Timebox");
timeboxName = timeboxType.GetAttributeDefinition("Name");
timeboxID = timeboxType.GetAttributeDefinition("ID");
}
public void TestFixtureSetUp()
{
V1APIConnector dataConnector = new V1APIConnector(v1Url + dataPath, username, password);
V1APIConnector metaConnector = new V1APIConnector(v1Url + metaPath);
V1APIConnector localConnector = new V1APIConnector(v1Url + localizationPath);
localizer = new Localizer(localConnector);
metaModel = new MetaModel(metaConnector);
services = new Services(metaModel, dataConnector);
timeboxType = metaModel.GetAssetType("Timebox");
timeboxName = timeboxType.GetAttributeDefinition("Name");
timeboxID = timeboxType.GetAttributeDefinition("ID");
}
public void QueryProjects() {
var proxyProvider = new ProxyProvider(new Uri(ProxyPath), ProxyUsername, ProxyPassword);
IAPIConnector metaConnector = new V1APIConnector(V1Path + "meta.v1/", V1Username, V1Password, false, proxyProvider);
IMetaModel metaModel = new MetaModel(metaConnector);
IAPIConnector dataConnector = new V1APIConnector(V1Path + "rest-1.v1/", V1Username, V1Password, false, proxyProvider);
IServices services = new Services(metaModel, dataConnector);
var projectType = metaModel.GetAssetType("Scope");
var scopeQuery = new Query(projectType);
var result = services.Retrieve(scopeQuery);
Assert.IsTrue(result.Assets.Count > 0);
}
internal T New <T>(Entity inTheContextOf) where T : Entity
{
var contextOid = GetOid(inTheContextOf);
var assetTypeToken = GetAssetTypeToken(typeof(T));
var typeToCreate = MetaModel.GetAssetType(assetTypeToken);
var shell = Services.New(typeToCreate, contextOid);
var result = CreateWrapper <T>();
SetAsset(result.InstanceKey, shell);
return(result);
}
public void QueryProjects()
{
var proxyProvider = new ProxyProvider(new Uri(ProxyPath), ProxyUsername, ProxyPassword);
IAPIConnector metaConnector = new V1APIConnector(V1Path + "meta.v1/", V1Username, V1Password, false, proxyProvider);
IMetaModel metaModel = new MetaModel(metaConnector);
IAPIConnector dataConnector = new V1APIConnector(V1Path + "rest-1.v1/", V1Username, V1Password, false, proxyProvider);
IServices services = new Services(metaModel, dataConnector);
var projectType = metaModel.GetAssetType("Scope");
var scopeQuery = new Query(projectType);
var result = services.Retrieve(scopeQuery);
Assert.IsTrue(result.Assets.Count > 0);
}
public void AddNewAssetTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var projectId = Oid.FromToken("Scope:0", metaModel);
var assetType = metaModel.GetAssetType("Story");
var newStory = services.New(assetType, projectId);
var nameAttribute = assetType.GetAttributeDefinition("Name");
newStory.SetAttributeValue(nameAttribute, "My New Story");
services.Save(newStory);
Assert.IsFalse(newStory.Oid.IsNull);
}
public void GetMultipleAssetsTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var assetType = metaModel.GetAssetType("Story");
var query = new Query(assetType);
var nameAttribute = assetType.GetAttributeDefinition("Name");
var estimateAttribute = assetType.GetAttributeDefinition("Estimate");
query.Selection.Add(nameAttribute);
query.Selection.Add(estimateAttribute);
var result = services.Retrieve(query);
Assert.IsTrue(result.Assets.Count > 1);
}
public void PageListOfAssetsTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var storyType = metaModel.GetAssetType("Story");
var query = new Query(storyType)
{
Paging = { PageSize = 3, Start = 0 }
};
var result = services.Retrieve(query);
Assert.AreEqual(3, result.Assets.Count);
// The PageSize property shown asks for 3 items, and the Start property indicates to start at 0.
// The next 3 items can be retrieved with PageSize=3, Start=3.
}
public void HistoryListOfAssetsTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var memberType = metaModel.GetAssetType("Member");
var query = new Query(memberType, true);
var changeDateAttribute = memberType.GetAttributeDefinition("ChangeDate");
var emailAttribute = memberType.GetAttributeDefinition("Email");
query.Selection.Add(changeDateAttribute);
query.Selection.Add(emailAttribute);
var result = services.Retrieve(query);
Assert.AreNotEqual(0, result.TotalAvaliable);
}
public void GetMultipleAssetsTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var assetType = metaModel.GetAssetType("Story");
var query = new Query(assetType);
var nameAttribute = assetType.GetAttributeDefinition("Name");
var estimateAttribute = assetType.GetAttributeDefinition("Estimate");
query.Selection.Add(nameAttribute);
query.Selection.Add(estimateAttribute);
var result = services.Retrieve(query);
Assert.Greater(result.Assets.Count, 1);
}
public void SortListOfAssetsTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var assetType = metaModel.GetAssetType("Story");
var query = new Query(assetType);
var nameAttribute = assetType.GetAttributeDefinition("Name");
var estimateAttribute = assetType.GetAttributeDefinition("Estimate");
query.Selection.Add(nameAttribute);
query.Selection.Add(estimateAttribute);
query.OrderBy.MinorSort(estimateAttribute, OrderBy.Order.Ascending);
var result = services.Retrieve(query);
}
public void UpdateSingleValueRelationTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var storyId = Oid.FromToken("Story:1094", metaModel);
var query = new Query(storyId);
var storyType = metaModel.GetAssetType("Story");
var sourceAttribute = storyType.GetAttributeDefinition("Source");
query.Selection.Add(sourceAttribute);
var result = services.Retrieve(query);
var story = result.Assets[0];
var oldSource = story.GetAttribute(sourceAttribute).Value.ToString();
story.SetAttributeValue(sourceAttribute, GetNextSourceId(oldSource));
services.Save(story);
}
public void HistoryAsOfTimeTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var storyType = metaModel.GetAssetType("Story");
var query = new Query(storyType, true);
var nameAttribute = storyType.GetAttributeDefinition("Name");
var estimateAttribute = storyType.GetAttributeDefinition("Estimate");
query.Selection.Add(nameAttribute);
query.Selection.Add(estimateAttribute);
query.AsOf = DateTime.Now.AddDays(-7);
QueryResult result = services.Retrieve(query);
Assert.AreNotEqual(0, result.TotalAvaliable);
}
/**************************************************************************************
* Protected methods used by derived classes.
**************************************************************************************/
protected Asset GetAssetFromV1(string AssetID)
{
Oid assetId = Oid.FromToken(AssetID, _metaAPI);
Query query = new Query(assetId);
IAssetType assetType = _metaAPI.GetAssetType("Epic");
IAttributeDefinition assetStateAttribute = assetType.GetAttributeDefinition("AssetState");
query.Selection.Add(assetStateAttribute);
QueryResult result = _dataAPI.Retrieve(query);
if (result.Assets.Count > 0)
{
return(result.Assets[0]);
}
else
{
return(null);
}
}
static void Main(string[] args)
{
var dataConnector = new VersionOneAPIConnector(BASE_URL + "/rest-1.v1/").WithOAuth2(SecretsFile, CredsFile);
var metaConnector = new VersionOneAPIConnector(BASE_URL + "/meta.v1/");
var metaModel = new MetaModel(metaConnector);
var services = new Services(metaModel, dataConnector);
var scopeType = metaModel.GetAssetType("Member");
var nameAttr = scopeType.GetAttributeDefinition("Name");
var descAttr = scopeType.GetAttributeDefinition("Nickname");
var worksItemsNameAttr = scopeType.GetAttributeDefinition("OwnedWorkitems.Name");
var query = new Query(scopeType);
var whereAdmin = new FilterTerm(descAttr);
whereAdmin.Equal("admin");
var whereNotTheAdmin = new FilterTerm(nameAttr);
whereNotTheAdmin.NotEqual("theAdmin");
var andFilter = new AndFilterTerm(whereAdmin, whereNotTheAdmin);
query.Filter = andFilter;
query.Selection.AddRange(new[] { nameAttr, descAttr, worksItemsNameAttr });
var result = services.Retrieve(query);
foreach (var asset in result.Assets)
{
Console.WriteLine("Name: " + asset.GetAttribute(nameAttr).Value);
Console.WriteLine("Description: " + asset.GetAttribute(descAttr).Value);
var workItems = asset.GetAttribute(worksItemsNameAttr).ValuesList;
Console.WriteLine("Workitems count: " + workItems.Count);
foreach (var workitem in workItems)
{
Console.WriteLine("Workitem: " + workitem);
}
}
Console.ReadLine();
}
public void UpdateScalarAttributeTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var storyId = Oid.FromToken("Story:1094", metaModel);
var query = new Query(storyId);
var storyType = metaModel.GetAssetType("Story");
var nameAttribute = storyType.GetAttributeDefinition("Name");
query.Selection.Add(nameAttribute);
var result = services.Retrieve(query);
var story = result.Assets[0];
var oldName = story.GetAttribute(nameAttribute).Value.ToString();
story.SetAttributeValue(nameAttribute, Guid.NewGuid().ToString());
services.Save(story);
Assert.AreNotEqual(oldName, story.GetAttribute(nameAttribute).Value.ToString());
}
/// <summary>
/// Use the Filter property of the Query object to filter the results that are returned.
/// This query will retrieve only Story assets with a "ToDo" of zero.
/// </summary>
public void FilterListOfAssetsTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var assetType = metaModel.GetAssetType("Task");
var query = new Query(assetType);
var nameAttribute = assetType.GetAttributeDefinition("Name");
var todoAttribute = assetType.GetAttributeDefinition("ToDo");
query.Selection.Add(nameAttribute);
query.Selection.Add(todoAttribute);
var toDoTerm = new FilterTerm(todoAttribute);
toDoTerm.Equal(0);
query.Filter = toDoTerm;
var result = services.Retrieve(query);
result.Assets.ForEach(asset =>
Assert.AreEqual(0, asset.GetAttribute(todoAttribute).Value));
}
public void QueryTrackedEpicsForMultipleProjectsUsingVariables()
{
var metaConnector = new V1APIConnector(VersionOneUrl + "meta.v1/", "admin", "admin");
var metaModel = new MetaModel(metaConnector);
var scopeVariable = new QueryVariable("Scope", "Scope:2176");
var epicType = metaModel.GetAssetType("Epic");
var query = new Query(epicType);
var notClosedEpicAttribute = epicType.GetAttributeDefinition("AssetState");
var notClosedEpicTerm = new FilterTerm(notClosedEpicAttribute);
notClosedEpicTerm.NotEqual("Closed");
var scopeAttribute = epicType.GetAttributeDefinition("Scope");
var scopeTerm = new FilterTerm(scopeAttribute);
scopeTerm.Operate(FilterTerm.Operator.Equal, scopeVariable);
var superAndUpAttribute = epicType.GetAttributeDefinition("SuperAndUp").Filter(scopeTerm);
var superAndUpTerm = new FilterTerm(superAndUpAttribute);
superAndUpTerm.NotExists();
var filter = new AndFilterTerm(notClosedEpicTerm, scopeTerm, superAndUpTerm);
query.Filter = filter;
query.Variables.Add(scopeVariable);
var builder = new QueryURLBuilder(query);
var result = builder.ToString();
Assert.AreEqual("Data/Epic?sel=&where=(Epic.AssetState!='Closed';Epic.Scope=$Scope;-Epic.SuperAndUp[Scope=$Scope])&with=$Scope=Scope%3A2176", result);
}
internal bool MultiRelationIsReadOnly(Entity entity, string attributeName)
{
return
(MetaModel.GetAssetType(GetAssetTypeToken(entity.GetType())).GetAttributeDefinition(attributeName).
IsReadOnly);
}
public void DeleteAnAssetTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
// create a new story so we can delete it
var projectId = Oid.FromToken("Scope:0", metaModel);
var assetType = metaModel.GetAssetType("Story");
var newStory = services.New(assetType, projectId);
var nameAttribute = assetType.GetAttributeDefinition("Name");
newStory.SetAttributeValue(nameAttribute, "My New Story");
services.Save(newStory);
// delete the story
var deleteOperation = metaModel.GetOperation("Story.Delete");
var deletedId = services.ExecuteOperation(deleteOperation, newStory.Oid);
var query = new Query(deletedId.Momentless);
QueryResult result = services.Retrieve(query);
Assert.AreEqual(0, result.TotalAvaliable);
// The delete operation returns the Oid with the new Moment of the deleted asset.
// Future queries will automatically exclude deleted assets from results.
// Currently there is no support for undeleting a deleted asset.
}
public void ReOpenAnAssetTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
// create a new story
var projectId = Oid.FromToken("Scope:0", metaModel);
var assetType = metaModel.GetAssetType("Story");
var story = services.New(assetType, projectId);
var nameAttribute = assetType.GetAttributeDefinition("Name");
story.SetAttributeValue(nameAttribute, "My New Story");
services.Save(story);
// closes the story
var closeOperation = metaModel.GetOperation("Story.Inactivate");
var closeId = services.ExecuteOperation(closeOperation, story.Oid);
//reopens the story
var activateOperation = metaModel.GetOperation("Story.Reactivate");
var activeId = services.ExecuteOperation(activateOperation, story.Oid);
var query = new Query(activeId.Momentless);
var assetState = metaModel.GetAttributeDefinition("Story.AssetState");
query.Selection.Add(assetState);
var result = services.Retrieve(query);
Asset activeStory = result.Assets[0];
Assert.AreEqual("Active", activeStory.GetAttribute(assetState).Value.ToString());
}
public void UpdateMultiValueRelationTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var storyId = Oid.FromToken("Story:1124", metaModel);
var query = new Query(storyId);
var storyType = metaModel.GetAssetType("Story");
var ownersAttribute = storyType.GetAttributeDefinition("Owners");
query.Selection.Add(ownersAttribute);
var result = services.Retrieve(query);
var story = result.Assets[0];
var values = story.GetAttribute(ownersAttribute).Values;
var owners = values.Cast<object>().ToList();
if (owners.Count >= 1) story.RemoveAttributeValue(ownersAttribute, owners[0]);
services.Save(story);
}
public void AddNewAssetTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var projectId = Oid.FromToken("Scope:0", metaModel);
var assetType = metaModel.GetAssetType("Story");
var newStory = services.New(assetType, projectId);
var nameAttribute = assetType.GetAttributeDefinition("Name");
newStory.SetAttributeValue(nameAttribute, "My New Story");
services.Save(newStory);
Assert.False(newStory.Oid.IsNull);
}
public static QueryBuilder For(string assetTypeToken, MetaModel metaModel)
{
var assetType = metaModel.GetAssetType(assetTypeToken);
return(new QueryBuilder(assetType, metaModel));
}
public void UpdateSingleValueRelationTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var storyId = Oid.FromToken("Story:1094", metaModel);
var query = new Query(storyId);
var storyType = metaModel.GetAssetType("Story");
var sourceAttribute = storyType.GetAttributeDefinition("Source");
query.Selection.Add(sourceAttribute);
var result = services.Retrieve(query);
var story = result.Assets[0];
var oldSource = story.GetAttribute(sourceAttribute).Value.ToString();
story.SetAttributeValue(sourceAttribute, GetNextSourceId(oldSource));
services.Save(story);
}
public void HistoryListOfAssetsTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var memberType = metaModel.GetAssetType("Member");
var query = new Query(memberType, true);
var changeDateAttribute = memberType.GetAttributeDefinition("ChangeDate");
var emailAttribute = memberType.GetAttributeDefinition("Email");
query.Selection.Add(changeDateAttribute);
query.Selection.Add(emailAttribute);
var result = services.Retrieve(query);
Assert.AreNotEqual(0, result.TotalAvaliable);
}
public void HistoryAsOfTimeTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var storyType = metaModel.GetAssetType("Story");
var query = new Query(storyType, true);
var nameAttribute = storyType.GetAttributeDefinition("Name");
var estimateAttribute = storyType.GetAttributeDefinition("Estimate");
query.Selection.Add(nameAttribute);
query.Selection.Add(estimateAttribute);
query.AsOf = DateTime.Now.AddDays(-7);
QueryResult result = services.Retrieve(query);
Assert.AreNotEqual(0, result.TotalAvaliable);
}
public void PageListOfAssetsTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var storyType = metaModel.GetAssetType("Story");
var query = new Query(storyType) { Paging = { PageSize = 3, Start = 0 } };
var result = services.Retrieve(query);
Assert.AreEqual(3, result.Assets.Count);
// The PageSize property shown asks for 3 items, and the Start property indicates to start at 0.
// The next 3 items can be retrieved with PageSize=3, Start=3.
}
public void HistorySingleAssetTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var memberType = metaModel.GetAssetType("Member");
var idAttribute = memberType.GetAttributeDefinition("ID");
var changeDateAttribute = memberType.GetAttributeDefinition("ChangeDate");
var emailAttribute = memberType.GetAttributeDefinition("Email");
// the boolean parameter specifies we want the historical data
var query = new Query(memberType, true);
query.Selection.Add(changeDateAttribute);
query.Selection.Add(emailAttribute);
var idTerm = new FilterTerm(idAttribute);
idTerm.Equal("Member:20");
query.Filter = idTerm;
var result = services.Retrieve(query);
Assert.AreNotEqual(0, result.Assets.Count);
}
public void SortListOfAssetsTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var assetType = metaModel.GetAssetType("Story");
var query = new Query(assetType);
var nameAttribute = assetType.GetAttributeDefinition("Name");
var estimateAttribute = assetType.GetAttributeDefinition("Estimate");
query.Selection.Add(nameAttribute);
query.Selection.Add(estimateAttribute);
query.OrderBy.MinorSort(estimateAttribute, OrderBy.Order.Ascending);
var result = services.Retrieve(query);
}
public void FindListOfAssetsTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var assetType = metaModel.GetAssetType("Story");
var query = new Query(assetType);
var nameAttribute = assetType.GetAttributeDefinition("Name");
var priorityAttribute = assetType.GetAttributeDefinition("Priority");
query.Selection.Add(nameAttribute);
query.Selection.Add(priorityAttribute);
query.Find = new QueryFind("High");
var result = services.Retrieve(query);
result.Assets.ForEach(
asset => Assert.GreaterOrEqual(asset.GetAttribute(nameAttribute)
.Value
.ToString()
.IndexOf("High", StringComparison.OrdinalIgnoreCase)
, 0));
Assert.Greater(result.Assets.Count, 1);
}
public void QueryTrackedEpicsForMultipleProjectsUsingVariables() {
var metaConnector = new V1APIConnector(VersionOneUrl + "meta.v1/", "admin", "admin");
var metaModel = new MetaModel(metaConnector);
var scopeVariable = new QueryVariable("Scope", "Scope:2176");
var epicType = metaModel.GetAssetType("Epic");
var query = new Query(epicType);
var notClosedEpicAttribute = epicType.GetAttributeDefinition("AssetState");
var notClosedEpicTerm = new FilterTerm(notClosedEpicAttribute);
notClosedEpicTerm.NotEqual("Closed");
var scopeAttribute = epicType.GetAttributeDefinition("Scope");
var scopeTerm = new FilterTerm(scopeAttribute);
scopeTerm.Operate(FilterTerm.Operator.Equal, scopeVariable);
var superAndUpAttribute = epicType.GetAttributeDefinition("SuperAndUp").Filter(scopeTerm);
var superAndUpTerm = new FilterTerm(superAndUpAttribute);
superAndUpTerm.NotExists();
var filter = new AndFilterTerm(notClosedEpicTerm, scopeTerm, superAndUpTerm);
query.Filter = filter;
query.Variables.Add(scopeVariable);
var builder = new QueryURLBuilder(query);
var result = builder.ToString();
Assert.AreEqual("Data/Epic?sel=&where=(Epic.AssetState!='Closed';Epic.Scope=$Scope;-Epic.SuperAndUp[Scope=$Scope])&with=$Scope=Scope%3A2176", result);
}
/// <summary>
/// Use the Filter property of the Query object to filter the results that are returned.
/// This query will retrieve only Story assets with a "ToDo" of zero.
/// </summary>
public void FilterListOfAssetsTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var assetType = metaModel.GetAssetType("Task");
var query = new Query(assetType);
var nameAttribute = assetType.GetAttributeDefinition("Name");
var todoAttribute = assetType.GetAttributeDefinition("ToDo");
query.Selection.Add(nameAttribute);
query.Selection.Add(todoAttribute);
var toDoTerm = new FilterTerm(todoAttribute);
toDoTerm.Equal(0);
query.Filter = toDoTerm;
var result = services.Retrieve(query);
result.Assets.ForEach(asset =>
Assert.AreEqual(0, asset.GetAttribute(todoAttribute).Value));
}
public void UpdateScalarAttributeTest()
{
IMetaModel metaModel = new MetaModel(new VersionOneAPIConnector(_metaUrl));
IServices services = new Services(
metaModel,
new VersionOneAPIConnector(_dataUrl).WithVersionOneUsernameAndPassword(_username, _password));
var storyId = Oid.FromToken("Story:1094", metaModel);
var query = new Query(storyId);
var storyType = metaModel.GetAssetType("Story");
var nameAttribute = storyType.GetAttributeDefinition("Name");
query.Selection.Add(nameAttribute);
var result = services.Retrieve(query);
var story = result.Assets[0];
var oldName = story.GetAttribute(nameAttribute).Value.ToString();
story.SetAttributeValue(nameAttribute, Guid.NewGuid().ToString());
services.Save(story);
Assert.AreNotEqual(oldName, story.GetAttribute(nameAttribute).Value.ToString());
}
public void QueryTrackedEpicsByProject() {
var metaConnector = new V1APIConnector(VersionOneUrl + "meta.v1/", "admin", "admin");
var metaModel = new MetaModel(metaConnector);
var epicType = metaModel.GetAssetType("Epic");
var scopeType = metaModel.GetAssetType("Scope");
var query = new Query(epicType);
const string scopeId = "Scope:1025";
var notClosedScopeAttribute = scopeType.GetAttributeDefinition("AssetState");
var notClosedEpicAttribute = epicType.GetAttributeDefinition("AssetState");
var notClosedEpicTerm = new FilterTerm(notClosedEpicAttribute);
notClosedEpicTerm.NotEqual("Closed");
var notClosedScopeTerm = new FilterTerm(notClosedScopeAttribute);
notClosedScopeTerm.NotEqual("Closed");
var scopeAttribute = epicType.GetAttributeDefinition("Scope.ParentMeAndUp");
scopeAttribute = scopeAttribute.Filter(notClosedScopeTerm);
var scopeTerm = new FilterTerm(scopeAttribute);
scopeTerm.Equal(scopeId);
var superAndUpAttribute = epicType.GetAttributeDefinition("SuperAndUp");
superAndUpAttribute = superAndUpAttribute.Filter(scopeTerm);
var superAndUpTerm = new FilterTerm(superAndUpAttribute);
superAndUpTerm.NotExists();
var filter = new AndFilterTerm(scopeTerm, notClosedEpicTerm, superAndUpTerm);
query.Filter = filter;
var builder = new QueryURLBuilder(query);
var result = builder.ToString();
Assert.AreEqual("Data/Epic?sel=&where=(Epic.Scope.ParentMeAndUp[AssetState!='Closed']='Scope%3a1025';Epic.AssetState!='Closed';-Epic.SuperAndUp[Scope.ParentMeAndUp[AssetState!='Closed']='Scope:1025'])", result);
}
static void Main(string[] args)
{
//string file = args[0];
string file = @"C:\Users\MIRVIN\Desktop\Training Wheels\SampleAttachment\bin\Debug\testfile.rtf";
if (File.Exists(file))
{
Console.WriteLine("Uploading {0}", file);
string mimeType = MimeType.Resolve(file);
IMetaModel metaModel = new MetaModel(new V1APIConnector(ApplicationURL + "meta.v1/"));
IServices services = new Services(metaModel, new V1APIConnector(ApplicationURL + "rest-1.v1/", _username, _password, _integrated));
IAttachments attachments = new Attachments(new V1APIConnector(ApplicationURL + "attachment.img/", _username, _password, _integrated));
//cleanjeans scope
Oid attachmentContext = Oid.FromToken("Scope:5067", metaModel);
IAssetType attachmentType = metaModel.GetAssetType("Attachment");
IAttributeDefinition attachmentNameDef = attachmentType.GetAttributeDefinition("Name");
IAttributeDefinition attachmentContentDef = attachmentType.GetAttributeDefinition("Content");
IAttributeDefinition attachmentContentTypeDef = attachmentType.GetAttributeDefinition("ContentType");
IAttributeDefinition attachmentFileNameDef = attachmentType.GetAttributeDefinition("Filename");
Asset newAttachment = services.New(attachmentType, attachmentContext);
newAttachment.SetAttributeValue(attachmentNameDef, "New Attachment");
newAttachment.SetAttributeValue(attachmentContentDef, string.Empty);
newAttachment.SetAttributeValue(attachmentContentTypeDef, mimeType);
newAttachment.SetAttributeValue(attachmentFileNameDef, file);
services.Save(newAttachment);
//Setup and attach the payload
string attachmentKey = newAttachment.Oid.Key.ToString();
int buffersize = 4096;
using (FileStream input = new FileStream(file, FileMode.Open, FileAccess.Read))
{
using (Stream output = attachments.GetWriteStream(attachmentKey))
{
byte[] buffer = new byte[buffersize];
for (; ;)
{
int read = input.Read(buffer, 0, buffersize);
if (read == 0)
{
break;
}
output.Write(buffer, 0, read);
}
}
}
attachments.SetWriteStream(attachmentKey, mimeType);
Console.WriteLine("{0} uploaded", file);
}
else
{
Console.WriteLine("{0} does not exist", file);
}
}