Search in sources :

Example 31 with DbUri

use of com.github.mgramin.sqlboot.model.uri.impl.DbUri in project sql-boot by sql-boot.

the class DbUriTest method testAction.

@Test
public void testAction() {
    DbUri dbUri = new DbUri("table/hr.p*/count?limit=10");
    System.out.println(dbUri.action());
}
Also used : DbUri(com.github.mgramin.sqlboot.model.uri.impl.DbUri) Test(org.junit.Test)

Example 32 with DbUri

use of com.github.mgramin.sqlboot.model.uri.impl.DbUri in project sql-boot by sql-boot.

the class SelectWrapperTest method read.

@Test
public void read() throws Exception {
    final List<DbResource> resources = type.read(new DbUri("table/hr.persons?select=schema")).collect(Collectors.toList());
    for (DbResource resource : resources) {
        assertEquals(1, resource.headers().size());
    }
    assertEquals(3, resources.size());
}
Also used : DbUri(com.github.mgramin.sqlboot.model.uri.impl.DbUri) DbResource(com.github.mgramin.sqlboot.model.resource.DbResource) Test(org.junit.Test)

Example 33 with DbUri

use of com.github.mgramin.sqlboot.model.uri.impl.DbUri in project sql-boot by sql-boot.

the class LimitWrapperTest method read.

@Test
public void read() throws Exception {
    assertEquals(3, type.read(new DbUri("table/hr.persons")).count());
    assertEquals(3, type.read(new DbUri("table/hr.persons?limit=3")).count());
    assertEquals(2, type.read(new DbUri("table/hr.persons?limit=2")).count());
    assertEquals(1, type.read(new DbUri("table/hr.persons?limit=1")).count());
}
Also used : DbUri(com.github.mgramin.sqlboot.model.uri.impl.DbUri) Test(org.junit.Test)

Aggregations

DbUri (com.github.mgramin.sqlboot.model.uri.impl.DbUri)33 DbResource (com.github.mgramin.sqlboot.model.resource.DbResource)25 Test (org.junit.Test)18 ResourceType (com.github.mgramin.sqlboot.model.resource_type.ResourceType)16 SqlPlaceholdersWrapper (com.github.mgramin.sqlboot.model.uri.wrappers.SqlPlaceholdersWrapper)13 BootException (com.github.mgramin.sqlboot.exceptions.BootException)12 DbResourceImpl (com.github.mgramin.sqlboot.model.resource.impl.DbResourceImpl)12 LinkedHashMap (java.util.LinkedHashMap)12 ResultSet (java.sql.ResultSet)11 ResultSetMetaData (java.sql.ResultSetMetaData)11 SQLException (java.sql.SQLException)11 ArrayList (java.util.ArrayList)11 TableJdbcResourceType (com.github.mgramin.sqlboot.model.resource_type.impl.jdbc.schema.table.TableJdbcResourceType)5 Uri (com.github.mgramin.sqlboot.model.uri.Uri)4 FsResourceTypes (com.github.mgramin.sqlboot.model.resource_type.impl.composite.FsResourceTypes)2 WhereWrapper (com.github.mgramin.sqlboot.model.resource_type.wrappers.list.WhereWrapper)2 JdbcSqlQuery (com.github.mgramin.sqlboot.sql.impl.JdbcSqlQuery)2 GroovyTemplateGenerator (com.github.mgramin.sqlboot.template.generator.impl.GroovyTemplateGenerator)2 Connection (java.sql.Connection)2 Map (java.util.Map)2