org.jooq.util.oracle.OracleUDTDefinition Maven / Gradle / Ivy
/**
* Copyright (c) 2009-2013, Lukas Eder, [email protected]
* All rights reserved.
*
* This software is licensed to you under the Apache License, Version 2.0
* (the "License"); You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*
* . Redistributions of source code must retain the above copyright notice, this
* list of conditions and the following disclaimer.
*
* . Redistributions in binary form must reproduce the above copyright notice,
* this list of conditions and the following disclaimer in the documentation
* and/or other materials provided with the distribution.
*
* . Neither the name "jOOQ" nor the names of its contributors may be
* used to endorse or promote products derived from this software without
* specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
* ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
* LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
* CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
* INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
* CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
* ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
* POSSIBILITY OF SUCH DAMAGE.
*/
package org.jooq.util.oracle;
import static org.jooq.util.oracle.sys.Tables.ALL_ARGUMENTS;
import static org.jooq.util.oracle.sys.Tables.ALL_TYPE_ATTRS;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.jooq.Record;
import org.jooq.util.AbstractUDTDefinition;
import org.jooq.util.AttributeDefinition;
import org.jooq.util.DataTypeDefinition;
import org.jooq.util.DefaultAttributeDefinition;
import org.jooq.util.DefaultDataTypeDefinition;
import org.jooq.util.RoutineDefinition;
import org.jooq.util.SchemaDefinition;
public class OracleUDTDefinition extends AbstractUDTDefinition {
public OracleUDTDefinition(SchemaDefinition schema, String name, String comment) {
super(schema, name, comment);
}
@Override
protected List getElements0() throws SQLException {
List result = new ArrayList();
for (Record record : create().select(
ALL_TYPE_ATTRS.ATTR_NAME,
ALL_TYPE_ATTRS.ATTR_NO,
ALL_TYPE_ATTRS.ATTR_TYPE_NAME,
ALL_TYPE_ATTRS.LENGTH,
ALL_TYPE_ATTRS.PRECISION,
ALL_TYPE_ATTRS.SCALE)
.from(ALL_TYPE_ATTRS)
.where(ALL_TYPE_ATTRS.OWNER.equal(getSchema().getName()))
.and(ALL_TYPE_ATTRS.TYPE_NAME.equal(getName()))
.orderBy(ALL_TYPE_ATTRS.ATTR_NO).fetch()) {
DataTypeDefinition type = new DefaultDataTypeDefinition(
getDatabase(),
getSchema(),
record.getValue(ALL_TYPE_ATTRS.ATTR_TYPE_NAME),
record.getValue(ALL_TYPE_ATTRS.LENGTH, int.class),
record.getValue(ALL_TYPE_ATTRS.PRECISION, int.class),
record.getValue(ALL_TYPE_ATTRS.SCALE, int.class));
AttributeDefinition attribute = new DefaultAttributeDefinition(
this,
record.getValue(ALL_TYPE_ATTRS.ATTR_NAME),
record.getValue(ALL_TYPE_ATTRS.ATTR_NO, int.class),
type);
result.add(attribute);
}
return result;
}
@Override
protected List getRoutines0() {
List result = new ArrayList();
for (Record record : create()
.selectDistinct(
ALL_ARGUMENTS.OBJECT_NAME,
ALL_ARGUMENTS.OBJECT_ID,
ALL_ARGUMENTS.OVERLOAD)
.from(ALL_ARGUMENTS)
.where(ALL_ARGUMENTS.OWNER.equal(getSchema().getName()))
.and(ALL_ARGUMENTS.PACKAGE_NAME.equal(getName()))
.orderBy(
ALL_ARGUMENTS.OBJECT_NAME,
ALL_ARGUMENTS.OVERLOAD)
.fetch()) {
result.add(new OracleRoutineDefinition(getSchema(),
this,
record.getValue(ALL_ARGUMENTS.OBJECT_NAME),
"",
record.getValue(ALL_ARGUMENTS.OBJECT_ID),
record.getValue(ALL_ARGUMENTS.OVERLOAD)));
}
return result;
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy