Search in sources :

Example 36 with StorableKey

use of com.hortonworks.registries.storage.StorableKey in project registry by hortonworks.

the class MySqlSelectQueryTest method testSelectQuery.

@Test
public void testSelectQuery() throws Exception {
    MySqlSelectQuery mySqlSelectQuery = new MySqlSelectQuery(nameSpace);
    String parametrizedSql = mySqlSelectQuery.getParametrizedSql();
    Assert.assertEquals("SELECT * FROM topic", parametrizedSql);
    Map<Schema.Field, Object> fieldToObjectMap = new HashMap<>();
    fieldToObjectMap.put(new Schema.Field("foo", Schema.Type.LONG), 1);
    mySqlSelectQuery = new MySqlSelectQuery(new StorableKey(nameSpace, new PrimaryKey(fieldToObjectMap)));
    parametrizedSql = mySqlSelectQuery.getParametrizedSql();
    Assert.assertEquals("SELECT * FROM topic WHERE `foo` = ?", parametrizedSql);
}
Also used : OrderByField(com.hortonworks.registries.storage.OrderByField) HashMap(java.util.HashMap) StorableKey(com.hortonworks.registries.storage.StorableKey) Schema(com.hortonworks.registries.common.Schema) PrimaryKey(com.hortonworks.registries.storage.PrimaryKey) MySqlSelectQuery(com.hortonworks.registries.storage.impl.jdbc.provider.mysql.query.MySqlSelectQuery) Test(org.junit.Test)

Example 37 with StorableKey

use of com.hortonworks.registries.storage.StorableKey in project registry by hortonworks.

the class PostgresSelectQueryTest method testSelectQuery.

@Test
public void testSelectQuery() throws Exception {
    PostgresqlSelectQuery postgresqlSelectQuery = new PostgresqlSelectQuery(nameSpace);
    String parametrizedSql = postgresqlSelectQuery.getParametrizedSql();
    Assert.assertEquals("SELECT * FROM \"topic\"", parametrizedSql);
    Map<Schema.Field, Object> fieldToObjectMap = new HashMap<>();
    fieldToObjectMap.put(new Schema.Field("foo", Schema.Type.LONG), 1);
    postgresqlSelectQuery = new PostgresqlSelectQuery(new StorableKey(nameSpace, new PrimaryKey(fieldToObjectMap)));
    parametrizedSql = postgresqlSelectQuery.getParametrizedSql();
    Assert.assertEquals("SELECT * FROM \"topic\" WHERE \"foo\" = ?", parametrizedSql);
}
Also used : OrderByField(com.hortonworks.registries.storage.OrderByField) HashMap(java.util.HashMap) StorableKey(com.hortonworks.registries.storage.StorableKey) Schema(com.hortonworks.registries.common.Schema) PostgresqlSelectQuery(com.hortonworks.registries.storage.impl.jdbc.provider.postgresql.query.PostgresqlSelectQuery) PrimaryKey(com.hortonworks.registries.storage.PrimaryKey) Test(org.junit.Test)

Example 38 with StorableKey

use of com.hortonworks.registries.storage.StorableKey in project registry by hortonworks.

the class PostgresSelectQueryTest method testSelectQueryWithOrderBy.

@Test
public void testSelectQueryWithOrderBy() throws Exception {
    List<OrderByField> orderByFields = Arrays.asList(OrderByField.of("foo", true), OrderByField.of("bar"));
    PostgresqlSelectQuery postgresqlSelectQuery = new PostgresqlSelectQuery("topic", orderByFields);
    String parametrizedSql = postgresqlSelectQuery.getParametrizedSql();
    Assert.assertEquals("SELECT * FROM \"topic\" ORDER BY \"foo\" DESC, ORDER BY \"bar\" ASC", parametrizedSql);
    Map<Schema.Field, Object> fieldToObjectMap = new HashMap<>();
    fieldToObjectMap.put(new Schema.Field("foo", Schema.Type.LONG), 1);
    postgresqlSelectQuery = new PostgresqlSelectQuery(new StorableKey(nameSpace, new PrimaryKey(fieldToObjectMap)), orderByFields);
    parametrizedSql = postgresqlSelectQuery.getParametrizedSql();
    Assert.assertEquals("SELECT * FROM \"topic\" WHERE \"foo\" = ? ORDER BY \"foo\" DESC, ORDER BY \"bar\" ASC", parametrizedSql);
}
Also used : OrderByField(com.hortonworks.registries.storage.OrderByField) OrderByField(com.hortonworks.registries.storage.OrderByField) HashMap(java.util.HashMap) StorableKey(com.hortonworks.registries.storage.StorableKey) Schema(com.hortonworks.registries.common.Schema) PostgresqlSelectQuery(com.hortonworks.registries.storage.impl.jdbc.provider.postgresql.query.PostgresqlSelectQuery) PrimaryKey(com.hortonworks.registries.storage.PrimaryKey) Test(org.junit.Test)

Example 39 with StorableKey

use of com.hortonworks.registries.storage.StorableKey in project registry by hortonworks.

the class GuavaCacheTest method setStorableKey.

private static void setStorableKey() {
    Map<Schema.Field, Object> fieldsToVal = new HashMap<>();
    fieldsToVal.put(new Schema.Field("fn", Schema.Type.STRING), "fv");
    storableKey = new StorableKey("ns", new PrimaryKey(fieldsToVal));
}
Also used : HashMap(java.util.HashMap) StorableKey(com.hortonworks.registries.storage.StorableKey) Schema(com.hortonworks.registries.common.Schema) PrimaryKey(com.hortonworks.registries.storage.PrimaryKey)

Example 40 with StorableKey

use of com.hortonworks.registries.storage.StorableKey in project registry by hortonworks.

the class CatalogTagService method getTag.

@Override
public Tag getTag(Long tagId) {
    Tag tag = new Tag();
    tag.setId(tagId);
    Tag result = this.dao.get(new StorableKey(TAG_NAMESPACE, tag.getPrimaryKey()));
    if (result != null) {
        result.setTags(getTags(getTaggedEntity(result)));
    }
    return result;
}
Also used : StorableKey(com.hortonworks.registries.storage.StorableKey) Tag(com.hortonworks.registries.tag.Tag)

Aggregations

StorableKey (com.hortonworks.registries.storage.StorableKey)72 Schema (com.hortonworks.registries.common.Schema)6 OrderByField (com.hortonworks.registries.storage.OrderByField)6 PrimaryKey (com.hortonworks.registries.storage.PrimaryKey)6 HashMap (java.util.HashMap)6 Test (org.junit.Test)5 QueryParam (com.hortonworks.registries.common.QueryParam)4 StorageManager (com.hortonworks.registries.storage.StorageManager)4 SchemaNotFoundException (com.hortonworks.registries.schemaregistry.errors.SchemaNotFoundException)3 Storable (com.hortonworks.registries.storage.Storable)3 StorageException (com.hortonworks.registries.storage.exception.StorageException)3 Role (com.hortonworks.streamline.streams.security.catalog.Role)3 UserRole (com.hortonworks.streamline.streams.security.catalog.UserRole)3 CacheBuilder (com.google.common.cache.CacheBuilder)2 SchemaVersionInfoCache (com.hortonworks.registries.schemaregistry.cache.SchemaVersionInfoCache)2 CacheBackedStorageManager (com.hortonworks.registries.storage.CacheBackedStorageManager)2 StorageWriter (com.hortonworks.registries.storage.cache.writer.StorageWriter)2 AlreadyExistsException (com.hortonworks.registries.storage.exception.AlreadyExistsException)2 IllegalQueryParameterException (com.hortonworks.registries.storage.exception.IllegalQueryParameterException)2 MySqlSelectQuery (com.hortonworks.registries.storage.impl.jdbc.provider.mysql.query.MySqlSelectQuery)2