public void ShouldGenerateUpdateRemoveCollectionItemQuery() { string generatedQuery = new OSqlUpdate() .Record(new ORID(8, 0)) .Remove("foo", 123) .ToString(); string query = "UPDATE #8:0 " + "REMOVE foo = 123"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGeneratUpdateRecordFromOridQueryUsingMergeKeyword() { string generatedQuery = new OSqlUpdate() .Update(new ORID(8, 0)) .Merge(TestConstants.MergeJson) .ToString(); string query = "UPDATE #8:0 " + "MERGE " + TestConstants.MergeJson; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateAddCollectionItemQuery() { string generatedQuery = new OSqlUpdate() .Record(new ORID(8, 0)) .Add("foo", "foo string value") .ToString(); string query = "UPDATE #8:0 " + "ADD foo = 'foo string value'"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGeneratUpdateRecordFromOridQueryUsingContentKeyword() { string generatedQuery = new OSqlUpdate() .Update(new ORID(8, 0)) .Content(TestConstants.UpdateJson) .ToString(); string query = "UPDATE #8:0 " + "CONTENT " + TestConstants.UpdateJson; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateRemoveFieldsQuery() { string generatedQuery = new OSqlUpdate() .Record(new ORID(8, 0)) .Remove("foo") .Remove("bar") .ToString(); string query = "UPDATE #8:0 " + "REMOVE foo, bar"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateUsingMergeKeyword() { string generatedQuery = new OSqlUpdate() .Update("bogusId") .Class("TestVertexClass") .Merge(TestConstants.MergeJson) .ToString(); string query = "UPDATE TestVertexClass " + "MERGE " + TestConstants.MergeJson; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateUsingContentKeyword() { string generatedQuery = new OSqlUpdate() .Update("bogusId") .Class("TestVertexClass") .Content(TestConstants.UpdateJson) .ToString(); string query = "UPDATE TestVertexClass " + "CONTENT " + TestConstants.UpdateJson; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateRecordSetQuery() { string generatedQuery = new OSqlUpdate() .Record(new ORID(8, 0)) .Set("foo", "foo string value") .Set("bar", 12345) .ToString(); string query = "UPDATE #8:0 " + "SET foo = 'foo string value', " + "bar = 12345"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateClassFromObjectQuery() { TestProfileClass profile = new TestProfileClass(); profile.Name = "Johny"; profile.Surname = "Bravo"; string generatedQuery = new OSqlUpdate() .Update(profile) .ToString(); string query = "UPDATE TestProfileClass " + "SET Name = 'Johny', " + "Surname = 'Bravo'"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateClusterQuery() { ODocument document = new ODocument() .SetField("foo", "foo string value") .SetField("bar", 12345); string generatedQuery = new OSqlUpdate() .Update(document) .Cluster("TestCluster") .ToString(); string query = "UPDATE cluster:TestCluster " + "SET foo = 'foo string value', " + "bar = 12345"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateClusterQuery() { ODocument document = new ODocument() .SetField("foo", "foo string value") .SetField("bar", 12345); string generatedQuery = new OSqlUpdate() .Update(document) .Cluster("TestCluster") .ToString(); string query = "UPDATE cluster:TestCluster " + "SET foo = 'foo string value', " + "bar = 12345"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateRecordFromOridQuery() { ODocument document = new ODocument() .SetField("foo", "foo string value") .SetField("bar", 12345); string generatedQuery = new OSqlUpdate() .Update(new ORID(8, 0)) .Set(document) .ToString(); string query = "UPDATE #8:0 " + "SET foo = 'foo string value', " + "bar = 12345"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateClassFromObjectQuery() { TestProfileClass profile = new TestProfileClass(); profile.Name = "Johny"; profile.Surname = "Bravo"; string generatedQuery = new OSqlUpdate() .Update(profile) .ToString(); string query = "UPDATE TestProfileClass " + "SET Name = 'Johny', " + "Surname = 'Bravo'"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateClassFromDocumentQuery() { ODocument document = new ODocument(); document.OClassName = "TestVertexClass"; document .SetField("foo", "foo string value") .SetField("bar", 12345); string generatedQuery = new OSqlUpdate() .Update(document) .ToString(); string query = "UPDATE TestVertexClass " + "SET foo = 'foo string value', " + "bar = 12345"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateWhereLimitQuery() { ODocument document = new ODocument(); document.ORID = new ORID(8, 0); document .SetField("foo", "foo string value") .SetField("bar", 12345); string generatedQuery = new OSqlUpdate() .Update(document) .Where("foo").Equals("whoa") .Or("foo").NotEquals(123) .And("foo").Lesser(1) .And("foo").LesserEqual(2) .And("foo").Greater(3) .And("foo").GreaterEqual(4) .And("foo").Like("%whoa%") .And("foo").IsNull() .And("foo").Contains("johny") .And("foo").Contains("name", "johny") .Limit(5) .ToString(); string query = "UPDATE #8:0 " + "SET foo = 'foo string value', " + "bar = 12345 " + "WHERE foo = 'whoa' " + "OR foo != 123 " + "AND foo < 1 " + "AND foo <= 2 " + "AND foo > 3 " + "AND foo >= 4 " + "AND foo LIKE '%whoa%' " + "AND foo IS NULL " + "AND foo CONTAINS 'johny' " + "AND foo CONTAINS (name = 'johny') " + "LIMIT 5"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateClassFromDocumentQuery() { ODocument document = new ODocument(); document.OClassName = "TestVertexClass"; document .SetField("foo", "foo string value") .SetField("bar", 12345); string generatedQuery = new OSqlUpdate() .Update(document) .ToString(); string query = "UPDATE TestVertexClass " + "SET foo = 'foo string value', " + "bar = 12345"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateRecordSetQuery() { string generatedQuery = new OSqlUpdate() .Record(new ORID(8, 0)) .Set("foo", "foo string value") .Set("bar", 12345) .ToString(); string query = "UPDATE #8:0 " + "SET foo = 'foo string value', " + "bar = 12345"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateWhereLimitQuery() { ODocument document = new ODocument(); document.ORID = new ORID(8, 0); document .SetField("foo", "foo string value") .SetField("bar", 12345); string generatedQuery = new OSqlUpdate() .Update(document) .Where("foo").Equals("whoa") .Or("foo").NotEquals(123) .And("foo").Lesser(1) .And("foo").LesserEqual(2) .And("foo").Greater(3) .And("foo").GreaterEqual(4) .And("foo").Like("%whoa%") .And("foo").IsNull() .And("foo").Contains("johny") .And("foo").Contains("name", "johny") .Limit(5) .ToString(); string query = "UPDATE #8:0 " + "SET foo = 'foo string value', " + "bar = 12345 " + "WHERE foo = 'whoa' " + "OR foo != 123 " + "AND foo < 1 " + "AND foo <= 2 " + "AND foo > 3 " + "AND foo >= 4 " + "AND foo LIKE '%whoa%' " + "AND foo IS NULL " + "AND foo CONTAINS 'johny' " + "AND foo CONTAINS (name = 'johny') " + "LIMIT 5"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateAddCollectionItemQuery() { string generatedQuery = new OSqlUpdate() .Record(new ORID(8, 0)) .Add("foo", "foo string value") .ToString(); string query = "UPDATE #8:0 " + "ADD foo = 'foo string value'"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateRecordFromDocumentQuery() { ODocument document = new ODocument(); document.ORID = new ORID(8, 0); document .SetField("foo", "foo string value") .SetField("bar", 12345); string generatedQuery = new OSqlUpdate() .Update(document) .ToString(); string query = "UPDATE #8:0 " + "SET foo = 'foo string value', " + "bar = 12345"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateRemoveCollectionItemQuery() { string generatedQuery = new OSqlUpdate() .Record(new ORID(8, 0)) .Remove("foo", 123) .ToString(); string query = "UPDATE #8:0 " + "REMOVE foo = 123"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateUpdateRemoveFieldsQuery() { string generatedQuery = new OSqlUpdate() .Record(new ORID(8, 0)) .Remove("foo") .Remove("bar") .ToString(); string query = "UPDATE #8:0 " + "REMOVE foo, bar"; Assert.AreEqual(generatedQuery, query); }