SchemaRepository¶

Find SchemaDAO by Catalog and Schema Names¶

SchemaInfoDAO getSchemaDAO(
  Session session,
  String catalogName,
  String schemaName)

getSchemaDAO requests the system-wide CatalogRepository for the CatalogInfoDAO.

Catalog not found: [catalogName]"

In the end, getSchemaDAO finds the SchemaInfoDAO for the catalog and the schemaName schema.

getSchemaDAO is used when:

• FunctionRepository is requested to createFunction, getSchemaId, getFunctionDAO, deleteFunction
• SchemaRepository is requested to createSchema, getSchemaDAO, updateSchema
• TableRepository is requested to getSchemaId
• VolumeRepository is requested to createVolume, getVolumeDAO, listVolumes, deleteVolume
• RepositoryUtils is requested to getSchemaId

Find SchemaDAO by Catalog ID and Schema Name¶

SchemaInfoDAO getSchemaDAO(
  Session session,
  UUID catalogId,
  String schemaName)

getSchemaDAO creates the following query (using the given Session) for the given schemaName and catalogId:

FROM SchemaInfoDAO WHERE name = [schemaName] and catalogId = :catalogId

getSchemaDAO executes the query and returns a single result of the query, or null if the query returns no results.

getSchemaDAO is used when:

• SchemaRepository is requested to delete a schema