Package de.fuberlin.wiwiss.d2rq.algebra

Examples of de.fuberlin.wiwiss.d2rq.algebra.Relation

94
95
96
97
98
99
100
101
102
        db.quoteRelationName(new RelationName(null, "table")));
  }
 
  public void testNoLimit() {
    ConnectedDB db = new DummyDB();
    Relation r = Relation.createSimpleRelation(db, new Attribute[]{foo});
    assertEquals("SELECT DISTINCT \"table\".\"foo\" FROM \"table\"",
        new SelectStatementBuilder(r).getSQLStatement());
  }
View Full Code Here
102
103
104
105
106
107
108
109
110
  }
 
  public void testLimitStandard() {
    DummyDB db = new DummyDB();
    db.setLimit(100);
    Relation r = Relation.createSimpleRelation(db, new Attribute[]{foo});
    assertEquals("SELECT DISTINCT \"table\".\"foo\" FROM \"table\" LIMIT 100",
        new SelectStatementBuilder(r).getSQLStatement());
  }
View Full Code Here
110
111
112
113
114
115
116
117
118
  }
 
  public void testNoLimitMSSQL() {
    DummyDB db = new DummyDB(Vendor.SQLServer);
    db.setLimit(100);
    Relation r = Relation.createSimpleRelation(db, new Attribute[]{foo});
    assertEquals("SELECT DISTINCT TOP 100 \"table\".\"foo\" FROM \"table\"",
        new SelectStatementBuilder(r).getSQLStatement());
  }
View Full Code Here
118
119
120
121
122
123
124
125
126
  }
 
  public void testNoLimitOracle() {
    DummyDB db = new DummyDB(Vendor.Oracle);
    db.setLimit(100);
    Relation r = Relation.createSimpleRelation(db, new Attribute[]{foo});
    assertEquals("SELECT DISTINCT \"table\".\"foo\" FROM \"table\" WHERE (ROWNUM <= 100)",
        new SelectStatementBuilder(r).getSQLStatement());
  }
View Full Code Here
TOP

Related Classes of de.fuberlin.wiwiss.d2rq.algebra.Relation

  • de.fuberlin.wiwiss.d2rq.ClassMapLister
  • de.fuberlin.wiwiss.d2rq.download.DownloadContentQuery
  • de.fuberlin.wiwiss.d2rq.engine.GraphPatternTranslatorTest
  • de.fuberlin.wiwiss.d2rq.find.URIMakerRuleTest
  • de.fuberlin.wiwiss.d2rq.sql.SQLBuildingTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.