public void Issue_No16_SortedList()
{
Database.CreateTestCollection(Database.TestDocumentCollectionName, ACollectionType.Document);
var db = new ADatabase(Database.Alias);
var entity = new IssueNo16Entity();
entity.SortedList = new SortedList <int, bool>();
entity.SortedList.Add(1, true);
entity.SortedList.Add(2, false);
entity.SortedList.Add(3, false);
entity.SortedList.Add(4, false);
var createResult = db.Document.Create <IssueNo16Entity>(Database.TestDocumentCollectionName, entity);
Assert.IsTrue(createResult.Success);
var getResult = db.Document.Get <IssueNo16Entity>(createResult.Value.ID());
Assert.IsTrue(getResult.Success);
Assert.IsTrue(getResult.HasValue);
for (int i = 0; i < getResult.Value.SortedList.Count; i++)
{
Assert.AreEqual(entity.SortedList.ElementAt(i).Key, getResult.Value.SortedList.ElementAt(i).Key);
Assert.AreEqual(entity.SortedList.ElementAt(i).Value, getResult.Value.SortedList.ElementAt(i).Value);
}
}
public void Issue_No15_List_save_and_retrieve()
{
Database.CreateTestCollection(Database.TestDocumentCollectionName, ACollectionType.Document);
var db = new ADatabase(Database.Alias);
var entity = new IssueNo15Entity();
entity.ListNumbers = new List <int> {
1, 2, 3
};
entity.ArrayNumbers = new int[] { 4, 5, 6 };
var createResult = db.Document.Create <IssueNo15Entity>(Database.TestDocumentCollectionName, entity);
Assert.IsTrue(createResult.Success);
var getresult = db.Document.Get <IssueNo15Entity>(createResult.Value.ID());
Assert.IsTrue(getresult.Success);
Assert.IsTrue(getresult.HasValue);
for (int i = 0; i < getresult.Value.ListNumbers.Count; i++)
{
Assert.AreEqual(entity.ListNumbers[i], getresult.Value.ListNumbers[i]);
}
for (int i = 0; i < getresult.Value.ArrayNumbers.Length; i++)
{
Assert.AreEqual(entity.ArrayNumbers[i], getresult.Value.ArrayNumbers[i]);
}
}
public void Should_create_hash_index()
{
Database.CreateTestCollection(Database.TestDocumentCollectionName, ACollectionType.Document);
var db = new ADatabase(Database.Alias);
var createResult = db.Index
.Type(AIndexType.Hash)
.Unique(true)
.Fields("foo", "bar")
.Create(Database.TestDocumentCollectionName);
Assert.AreEqual(201, createResult.StatusCode);
Assert.IsTrue(createResult.Success);
Assert.IsTrue(createResult.HasValue);
Assert.IsTrue(createResult.Value.IsID("id"));
Assert.AreEqual(AIndexType.Hash, createResult.Value.Enum <AIndexType>("type"));
Assert.IsTrue(createResult.Value.Bool("unique"));
Assert.IsFalse(createResult.Value.Bool("sparse"));
Assert.AreEqual(1, createResult.Value.Int("selectivityEstimate"));
Assert.AreEqual(2, createResult.Value.Size("fields"));
new List <string> {
"foo", "bar"
}.ForEach(field => Assert.IsTrue(createResult.Value.List <string>("fields").Contains(field)));
Assert.IsTrue(createResult.Value.Bool("isNewlyCreated"));
}
public void Should_get_all_indexes_in_collection()
{
Database.CreateTestDatabase(Database.TestDatabaseGeneral);
Database.CreateTestCollection(Database.TestDocumentCollectionName, ACollectionType.Document);
var db = new ADatabase(Database.Alias);
var operationResult = db.Collection
.GetAllIndexes(Database.TestDocumentCollectionName);
Assert.AreEqual(200, operationResult.StatusCode);
Assert.IsTrue(operationResult.Success);
Assert.IsTrue(operationResult.HasValue);
Assert.IsTrue(operationResult.Value.Size("indexes") > 0);
Assert.IsTrue(operationResult.Value.IsDocument("identifiers"));
}
public void Should_get_all_documents_in_collection()
{
Database.CreateTestDatabase(Database.TestDatabaseGeneral);
Database.CreateTestCollection(Database.TestDocumentCollectionName, ACollectionType.Document);
Database.ClearCollectionAndFetchTestDocumentData(Database.TestDocumentCollectionName);
var db = new ADatabase(Database.Alias);
var operationResult = db.Collection
.GetAllDocuments(Database.TestDocumentCollectionName);
Assert.AreEqual(200, operationResult.StatusCode);
Assert.IsTrue(operationResult.Success);
Assert.IsTrue(operationResult.HasValue);
Assert.AreEqual(operationResult.Value.Count, 2);
Assert.IsFalse(string.IsNullOrEmpty(operationResult.Value[0]));
Assert.IsFalse(string.IsNullOrEmpty(operationResult.Value[1]));
}
public void Issue_No8_Guid_conversion()
{
Database.CreateTestCollection(Database.TestDocumentCollectionName, ACollectionType.Document);
var db = new ADatabase(Database.Alias);
var demo = new IssueNo8Entity();
demo.SomeOtherId = Guid.NewGuid();
demo.Name = "My name";
var createResult = db.Document.Create <IssueNo8Entity>(Database.TestDocumentCollectionName, demo);
Assert.IsTrue(createResult.Success);
var getresult = db.Document.Get <IssueNo8Entity>(createResult.Value.ID());
Assert.IsTrue(getresult.Success);
Assert.AreEqual(demo.SomeOtherId.ToString(), getresult.Value.SomeOtherId.ToString());
}
public void Should_create_cap_contraint()
{
Database.CreateTestCollection(Database.TestDocumentCollectionName, ACollectionType.Document);
var db = new ADatabase(Database.Alias);
var createResult = db.Index
.Type(AIndexType.Cap)
.Size(10)
.Create(Database.TestDocumentCollectionName);
Assert.AreEqual(201, createResult.StatusCode);
Assert.IsTrue(createResult.Success);
Assert.IsTrue(createResult.HasValue);
Assert.IsTrue(createResult.Value.IsID("id"));
Assert.AreEqual(AIndexType.Cap, createResult.Value.Enum <AIndexType>("type"));
Assert.IsFalse(createResult.Value.Bool("unique"));
Assert.AreEqual(10, createResult.Value.Long("size"));
Assert.AreEqual(0, createResult.Value.Long("byteSize"));
Assert.IsTrue(createResult.Value.Bool("isNewlyCreated"));
}
public void Issue_No9_Enum_type_handling()
{
Database.CreateTestCollection(Database.TestDocumentCollectionName, ACollectionType.Document);
var db = new ADatabase(Database.Alias);
var demo = new IssueNo9Entity();
demo.SomeOtherId = Guid.NewGuid();
demo.Name = "My name";
demo.MyFavoriteColor = IssueNo9Entity.Color.Blue;
var createResult = db.Document.Create <IssueNo9Entity>(Database.TestDocumentCollectionName, demo);
Assert.IsTrue(createResult.Success);
var getResult = db.Document.Get <IssueNo9Entity>(createResult.Value.ID());
Assert.IsTrue(getResult.Success);
Assert.AreEqual(demo.MyFavoriteColor, getResult.Value.MyFavoriteColor);
var getDocResult = db.Document.Get(createResult.Value.ID());
Assert.IsTrue(getDocResult.Success);
Assert.IsTrue(getDocResult.Value.IsString("MyFavoriteColor"));
Assert.AreEqual(demo.MyFavoriteColor.ToString(), getDocResult.Value.String("MyFavoriteColor"));
// change JSON serialization options to serialize enum types as values (integers and not strings)
ASettings.JsonParameters.UseValuesOfEnums = true;
var createResult2 = db.Document.Create <IssueNo9Entity>(Database.TestDocumentCollectionName, demo);
Assert.IsTrue(createResult2.Success);
var getDocResult2 = db.Document.Get(createResult2.Value.ID());
Assert.IsTrue(getDocResult2.Success);
Assert.IsTrue(getDocResult2.Value.IsLong("MyFavoriteColor"));
Assert.AreEqual((int)demo.MyFavoriteColor, getDocResult2.Value.Int("MyFavoriteColor"));
}
public void Should_delete_index()
{
Database.CreateTestCollection(Database.TestDocumentCollectionName, ACollectionType.Document);
var db = new ADatabase(Database.Alias);
var createResult = db.Index
.Type(AIndexType.Hash)
.Unique(true)
.Fields("foo", "bar")
.Create(Database.TestDocumentCollectionName);
Assert.AreEqual(201, createResult.StatusCode);
Assert.IsTrue(createResult.Success);
var deleteResult = db.Index
.Delete(createResult.Value.String("id"));
Assert.AreEqual(200, deleteResult.StatusCode);
Assert.IsTrue(deleteResult.Success);
Assert.IsTrue(deleteResult.HasValue);
Assert.IsTrue(deleteResult.Value.IsID("id"));
Assert.AreEqual(createResult.Value.String("id"), deleteResult.Value.String("id"));
}
//[Test()]
public void Insertion_10k()
{
Database.CreateTestCollection(Database.TestDocumentCollectionName, ACollectionType.Document);
var db = new ADatabase(Database.Alias);
var startTime = DateTime.Now;
Debug.WriteLine("Start Time: " + startTime.ToLongTimeString());
var entity = new PerformanceEntity();
entity.Id = "1234567890123456789012345678901234";
entity.Key = "1234567";
entity.Revision = "1234567";
entity.Name = "Mohamad Abu Bakar";
entity.IcNumber = "1234567-12-3444";
entity.Department = "IT Department";
entity.Height = 1234;
entity.DateOfBirth = new DateTime(2015, 1, 27, 3, 33, 3);
entity.Salary = 3333;
var jsonEntity = JSON.ToJSON(entity);
for (int i = 0; i < 10000; i++)
{
// var entity = new PerformanceEntity();
// entity.Id = "1234567890123456789012345678901234";
// entity.Key = "1234567";
// entity.Revision = "1234567";
// entity.Name = "Mohamad Abu Bakar";
// entity.IcNumber = "1234567-12-3444";
// entity.Department = "IT Department";
// entity.Height = 1234;
// entity.DateOfBirth = new DateTime(2015, 1, 27, 3, 33, 3);
// entity.Salary = 3333;
// var entity = new Dictionary<string, object>()
// .String("Id", "1234567890123456789012345678901234")
// .String("Key", "1234567")
// .String("Revision", "1234567")
// .String("Name", "Mohamad Abu Bakar")
// .String("IcNumber", "1234567-12-3444")
// .String("Department", "IT Department")
// .Int("Height", 1234)
// .DateTime("DateOfBirth", new DateTime(2015, 1, 27, 3, 33, 3))
// .Int("Salary", 3333);
//var createResult = db.Document.Create(Database.TestDocumentCollectionName, jsonEntity);
SimpleHttpPostCreateDocument(
"http://localhost:8529/_db/" + Database.TestDatabaseGeneral + "/_api/document?collection=" + Database.TestDocumentCollectionName,
jsonEntity
);
//var updateDocument = new Dictionary<string, object>()
// .String("DocumentId", "SomeId");
//db2.Document.Update(result.Value.ID(), updateDocument);
}
/*var tasks = new Task[10];
*
* for (int i = 0; i < 10; i++)
* {
* tasks[i] = Task.Factory.StartNew(() =>
* {
* int messages_sent_by_one_task = 0;
*
* while(messages_sent_by_one_task < 1000)
* {
* SimpleHttpPostCreateDocument(
* "http://localhost:8529/_db/" + Database.TestDatabaseGeneral + "/_api/document?collection=" + Database.TestDocumentCollectionName,
* jsonEntity
* );
*
* messages_sent_by_one_task++;
* }
* });
* }
*
* while (tasks.Any(t => !t.IsCompleted)) { }*/
var endTime = DateTime.Now;
TimeSpan duration = endTime - startTime;
Debug.WriteLine("End Time: " + endTime.ToLongTimeString());
Debug.WriteLine("Total time taken: " + duration.TotalSeconds);
}
public DocumentOperationsTests()
{
Database.CreateTestDatabase(Database.TestDatabaseGeneral);
Database.CreateTestCollection(Database.TestDocumentCollectionName, ACollectionType.Document);
}
public void Issue_No34_MapAttributesToProperties()
{
Database.CreateTestCollection(Database.TestDocumentCollectionName, ACollectionType.Document);
Database.CreateTestCollection(Database.TestEdgeCollectionName, ACollectionType.Edge);
var db = new ADatabase(Database.Alias);
var vertex1 = new IssueNo34Entity
{
Key = "5",
Foo = "some string value",
Bar = 12345
};
var createResult1 = db.Document.Create(Database.TestDocumentCollectionName, vertex1);
Assert.IsTrue(createResult1.Success);
Assert.IsTrue(createResult1.HasValue);
Assert.AreEqual(vertex1.Key, createResult1.Value.Key());
var getResult1 = db.Document.Get <IssueNo34Entity>(createResult1.Value.ID());
Assert.IsTrue(getResult1.Success);
Assert.IsTrue(getResult1.HasValue);
Assert.AreEqual(vertex1.Key, getResult1.Value.Key);
Assert.AreEqual(vertex1.Foo, getResult1.Value.Foo);
Assert.AreEqual(vertex1.Bar, getResult1.Value.Bar);
var vertex2 = new IssueNo34Entity
{
Key = "8",
Foo = "some other string value",
Bar = 67890
};
var createResult2 = db.Document.Create(Database.TestDocumentCollectionName, vertex2);
Assert.IsTrue(createResult2.Success);
Assert.IsTrue(createResult2.HasValue);
Assert.AreEqual(vertex2.Key, createResult2.Value.Key());
var getResult2 = db.Document.Get <IssueNo34Entity>(createResult2.Value.ID());
Assert.IsTrue(getResult2.Success);
Assert.IsTrue(getResult2.HasValue);
Assert.AreEqual(vertex2.Key, getResult2.Value.Key);
Assert.AreEqual(vertex2.Foo, getResult2.Value.Foo);
Assert.AreEqual(vertex2.Bar, getResult2.Value.Bar);
var edge = new IssueNo34Entity
{
From = createResult1.Value.ID(),
To = createResult2.Value.ID(),
Key = "10",
Foo = "edge string value",
Bar = 13579
};
var createEdge = db
.Document
.ReturnNew()
.CreateEdge(Database.TestEdgeCollectionName, edge.From, edge.To, edge);
Assert.IsTrue(createEdge.Success);
Assert.IsTrue(createEdge.HasValue);
Assert.AreEqual(edge.Key, createEdge.Value.Key());
var getEdge = db.Document.Get <IssueNo34Entity>(createEdge.Value.ID());
Assert.IsTrue(getEdge.Success);
Assert.IsTrue(getEdge.HasValue);
Assert.AreEqual(edge.From, getEdge.Value.From);
Assert.AreEqual(edge.To, getEdge.Value.To);
Assert.AreEqual(edge.Key, getEdge.Value.Key);
Assert.AreEqual(edge.Foo, getEdge.Value.Foo);
Assert.AreEqual(edge.Bar, getEdge.Value.Bar);
var queryVertex1Result = db.Query
.Aql($"FOR item IN {Database.TestDocumentCollectionName} FILTER item._key == \"{vertex1.Key}\" RETURN item")
.ToObject <IssueNo34Entity>();
Assert.IsTrue(queryVertex1Result.Success);
Assert.IsTrue(queryVertex1Result.HasValue);
Assert.AreEqual(vertex1.Key, queryVertex1Result.Value.Key);
Assert.AreEqual(vertex1.Foo, queryVertex1Result.Value.Foo);
Assert.AreEqual(vertex1.Bar, queryVertex1Result.Value.Bar);
var queryVertex2Result = db.Query
.Aql($"FOR item IN {Database.TestDocumentCollectionName} FILTER item._key == \"{vertex2.Key}\" RETURN item")
.ToObject <IssueNo34Entity>();
Assert.IsTrue(queryVertex2Result.Success);
Assert.IsTrue(queryVertex2Result.HasValue);
Assert.AreEqual(vertex2.Key, queryVertex2Result.Value.Key);
Assert.AreEqual(vertex2.Foo, queryVertex2Result.Value.Foo);
Assert.AreEqual(vertex2.Bar, queryVertex2Result.Value.Bar);
var queryEdgeResult = db.Query
.Aql($"FOR item IN {Database.TestEdgeCollectionName} FILTER item._key == \"{edge.Key}\" RETURN item")
.ToObject <IssueNo34Entity>();
Assert.IsTrue(queryEdgeResult.Success);
Assert.IsTrue(queryEdgeResult.HasValue);
Assert.AreEqual(edge.From, queryEdgeResult.Value.From);
Assert.AreEqual(edge.To, queryEdgeResult.Value.To);
Assert.AreEqual(edge.Key, queryEdgeResult.Value.Key);
Assert.AreEqual(edge.Foo, queryEdgeResult.Value.Foo);
Assert.AreEqual(edge.Bar, queryEdgeResult.Value.Bar);
}