public void ShouldGenerateDeleteDocumentClassWhereLimitQuery() { string generatedQuery = new OSqlDeleteDocument() .Class <TestProfileClass>() .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 = "DELETE FROM TestProfileClass " + "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 ShouldGenerateDeleteDocumentFromObjectOClassNameQuery() { TestProfileClass profile = new TestProfileClass(); string generatedQuery = new OSqlDeleteDocument() .Delete(profile) .ToString(); string query = "DELETE FROM TestProfileClass"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateDeleteDocumentFromObjectOClassNameQuery() { TestProfileClass profile = new TestProfileClass(); string generatedQuery = new OSqlDeleteDocument() .Delete(profile) .ToString(); string query = "DELETE FROM TestProfileClass"; Assert.Equal(generatedQuery, query); }
public void ShouldGenerateDeleteDocumentFromDocumentOClassNameQuery() { ODocument document = new ODocument(); document.OClassName = "TestVertexClass"; string generatedQuery = new OSqlDeleteDocument() .Delete(document) .ToString(); string query = "DELETE FROM TestVertexClass"; Assert.Equal(generatedQuery, query); }
public void ShouldGenerateDeleteDocumentFromDocumentOClassNameQuery() { ODocument document = new ODocument(); document.OClassName = "TestVertexClass"; string generatedQuery = new OSqlDeleteDocument() .Delete(document) .ToString(); string query = "DELETE FROM TestVertexClass"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateDeleteDocumentFromObjectOridQuery() { TestProfileClass profile = new TestProfileClass(); profile.ORID = new ORID(8, 0); string generatedQuery = new OSqlDeleteDocument() .Delete(profile) .ToString(); string query = "DELETE FROM TestProfileClass " + "WHERE @rid = #8:0"; Assert.Equal(generatedQuery, query); }
public void ShouldGenerateDeleteDocumentFromObjectOridQuery() { TestProfileClass profile = new TestProfileClass(); profile.ORID = new ORID(8, 0); string generatedQuery = new OSqlDeleteDocument() .Delete(profile) .ToString(); string query = "DELETE FROM TestProfileClass " + "WHERE @rid = #8:0"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateDeleteDocumentFromDocumentOridQuery() { ODocument document = new ODocument(); document.OClassName = "TestVertexClass"; document.ORID = new ORID(8, 0); string generatedQuery = new OSqlDeleteDocument() .Delete(document) .ToString(); string query = "DELETE FROM TestVertexClass " + "WHERE @rid = #8:0"; Assert.AreEqual(generatedQuery, query); }
public void ShouldGenerateDeleteDocumentFromDocumentOridQuery() { ODocument document = new ODocument(); document.OClassName = "TestVertexClass"; document.ORID = new ORID(8, 0); string generatedQuery = new OSqlDeleteDocument() .Delete(document) .ToString(); string query = "DELETE FROM TestVertexClass " + "WHERE @rid = #8:0"; Assert.Equal(generatedQuery, query); }
public void ShouldGenerateDeleteDocumentClassWhereLimitQuery() { string generatedQuery = new OSqlDeleteDocument() .Class<TestProfileClass>() .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 = "DELETE FROM TestProfileClass " + "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.Equal(generatedQuery, query); }