Examples of StringColumn

com.brsanthu.dataexporter.model.StringColumn
String column which displays the given string. Default alignment is middle left. @author Santhosh Kumar
com.google.code.or.common.glossary.column.StringColumn
@author Jingqi Xu
infovis.column.StringColumn
org.apache.jena.jdbc.results.metadata.columns.StringColumn
Column information for string columns
org.apache.ws.jaxme.sqls.StringColumn

Interface of a column with datatype {@link Column.Type#CHAR}or {@link Column.Type#VARCHAR}.
@author Jochen Wiedmann
org.cfcc.colfile.StringColumn
org.openbel.framework.common.record.StringColumn
Represents a {@link Column} of type {@link String} where the length of thestring is arbitrary.
This column implementation pads strings with spaces during encoding if the strings are less than the column's size. During encoding, the padding is removed. Encoding strings with length greater than the column's size will result in truncation.
@author Nick Bargnesi

Examples of org.apache.jena.jdbc.results.metadata.columns.StringColumn

     * 
     * @throws SQLException
     */
    @Test
    public void empty_meta_result_set_02() throws SQLException {
        MetaResultSet results = new MetaResultSet(new ColumnInfo[] { new StringColumn("Test", ResultSetMetaData.columnNullable) });


        // Check results metadata
        ResultSetMetaData metadata = results.getMetaData();
        Assert.assertEquals(1, metadata.getColumnCount());

View Full Code Here

Examples of org.apache.jena.jdbc.results.metadata.columns.StringColumn

     * @throws SQLException
     */
    @Test(expected = SQLException.class)
    public void meta_result_set_bad_01() throws SQLException {
        // Every row must have the correct number of columns
        new MetaResultSet(new ColumnInfo[] { new StringColumn("Test", ResultSetMetaData.columnNullable) }, new Object[][] { {} });
    }

View Full Code Here

Examples of org.apache.jena.jdbc.results.metadata.columns.StringColumn

     * @throws SQLException
     */
    @Test
    public void meta_result_set_string_01() throws SQLException {
        MetaResultSet results = new MetaResultSet(
                new ColumnInfo[] { new StringColumn("Test", ResultSetMetaData.columnNullable) }, new Object[][] { { "value" } });


        Assert.assertTrue(results.next());
        String value = results.getString(1);
        Assert.assertEquals("value", value);
        Assert.assertFalse(results.wasNull());

View Full Code Here

Examples of org.apache.jena.jdbc.results.metadata.columns.StringColumn

     * @throws SQLException
     */
    @Test
    public void meta_result_set_string_02() throws SQLException {
        MetaResultSet results = new MetaResultSet(
                new ColumnInfo[] { new StringColumn("Test", ResultSetMetaData.columnNullable) }, new Object[][] { { null } });


        Assert.assertTrue(results.next());
        String value = results.getString(1);
        Assert.assertEquals(null, value);
        Assert.assertTrue(results.wasNull());

View Full Code Here

Examples of org.apache.jena.jdbc.results.metadata.columns.StringColumn

     */
    public static ColumnInfo detectColumnType(String var, Node value, boolean allowsNulls) throws SQLException {
        if (allowsNulls && value == null) {
            // If we are allowing nulls and the value is null just type the
            // column as string
            return new StringColumn(var, ResultSetMetaData.columnNullable);
        } else if (!allowsNulls && value == null) {
            throw new SQLException("Unable to determine column type, column is non-nullable but example value is null");
        } else {
            // We know we have a non-null value so now we need to determine the
            // column type appropriately
            int nullable = allowsNulls ? ResultSetMetaData.columnNullable : ResultSetMetaData.columnNoNulls;
            if (value.isBlank()) {
                // Type blank nodes as strings
                return new StringColumn(var, nullable);
            } else if (value.isURI()) {
                // Type URIs as strings
                // TODO: Does JDBC have a URL type?
                return new StringColumn(var, nullable);
            } else if (value.isLiteral()) {
                // Literals will be typed based on the declared data type where
                // applicable
                String dtUri = value.getLiteralDatatypeURI();
                if (dtUri != null) {
                    // Is a typed literal
                    return selectColumnType(var, dtUri, nullable);
                } else {
                    // Untyped literals are typed as strings
                    return new StringColumn(var, nullable);
                }
            } else {
                // Anything else we treat as a string
                return new StringColumn(var, nullable);
            }
        }
    }

View Full Code Here

Examples of org.apache.jena.jdbc.results.metadata.columns.StringColumn

        } else if (dtUri.equals(XSD.decimal.toString())) {
            // Decimal column
            return new DecimalColumn(var, nullable);
        } else if (dtUri.equals(XSD.duration.toString())) {
            // JDBC has no notion of durations so return as a string
            return new StringColumn(var, nullable);
        } else if (dtUri.equals(XSD.integer.toString()) || dtUri.equals(XSD.xint.toString())
                || dtUri.equals(XSD.xlong.toString())) {
            // Integer column
            return new LongIntegerColumn(var, nullable, true);
        } else if (dtUri.equals(XSD.unsignedInt.toString()) || dtUri.equals(XSD.unsignedLong.toString())) {
            // Unsigned Integer column
            return new LongIntegerColumn(var, nullable, false);
        } else if (dtUri.equals(XSD.positiveInteger.toString()) || dtUri.equals(XSD.nonNegativeInteger.toString())) {
            // Unsigned Integer column
            return new LongIntegerColumn(var, nullable, false);
        } else if (dtUri.equals(XSD.nonPositiveInteger.toString()) || dtUri.equals(XSD.negativeInteger.toString())) {
            // Signed Integer column
            return new LongIntegerColumn(var, nullable, true);
        } else if (dtUri.equals(XSD.xshort.toString())) {
            // Short Integer column
            return new IntegerColumn(var, nullable, true);
        } else if (dtUri.equals(XSD.unsignedShort.toString())) {
            // Unsigned Short Integer column
            return new IntegerColumn(var, nullable, false);
        } else if (dtUri.equals(XSD.xbyte.toString())) {
            // Signed Byte
            return new ByteColumn(var, nullable, true);
        } else if (dtUri.equals(XSD.unsignedByte.toString())) {
            // Unsigned Byte
            return new ByteColumn(var, nullable, false);
        } else if (dtUri.equals(XSD.time.toString())) {
            // Time column
            return new TimeColumn(var, nullable);
        } else if (dtUri.equals(XSD.xboolean.toString())) {
            // Boolean column
            return new BooleanColumn(var, nullable);
        } else if (dtUri.equals(XSD.xdouble.toString())) {
            // Double column
            return new DoubleColumn(var, nullable);
        } else if (dtUri.equals(XSD.xfloat.toString())) {
            // Float column
            return new FloatColumn(var, nullable);
        } else if (dtUri.equals(XSD.xstring.toString())) {
            // String column
            return new StringColumn(var, nullable);
        } else {
            // Anything else we'll treat as a String
            return new StringColumn(var, nullable);
        }
    }

View Full Code Here

Examples of org.apache.jena.jdbc.results.metadata.columns.StringColumn

     */
    public static ColumnInfo detectColumnType(String var, Node value, boolean allowsNulls) throws SQLException {
        if (allowsNulls && value == null) {
            // If we are allowing nulls and the value is null just type the
            // column as string
            return new StringColumn(var, ResultSetMetaData.columnNullable);
        } else if (!allowsNulls && value == null) {
            throw new SQLException("Unable to determine column type, column is non-nullable but example value is null");
        } else {
            // We know we have a non-null value so now we need to determine the
            // column type appropriately
            int nullable = allowsNulls ? ResultSetMetaData.columnNullable : ResultSetMetaData.columnNoNulls;
            if (value.isBlank()) {
                // Type blank nodes as strings
                return new StringColumn(var, nullable);
            } else if (value.isURI()) {
                // Type URIs as strings
                // TODO: Does JDBC have a URL type?
                return new StringColumn(var, nullable);
            } else if (value.isLiteral()) {
                // Literals will be typed based on the declared data type where
                // applicable
                String dtUri = value.getLiteralDatatypeURI();
                if (dtUri != null) {
                    // Is a typed literal
                    return selectColumnType(var, dtUri, nullable);
                } else {
                    // Untyped literals are typed as strings
                    return new StringColumn(var, nullable);
                }
            } else {
                // Anything else we treat as a string
                return new StringColumn(var, nullable);
            }
        }
    }

View Full Code Here

Examples of org.apache.jena.jdbc.results.metadata.columns.StringColumn

        } else if (dtUri.equals(XSD.decimal.toString())) {
            // Decimal column
            return new DecimalColumn(var, nullable);
        } else if (dtUri.equals(XSD.duration.toString())) {
            // JDBC has no notion of durations so return as a string
            return new StringColumn(var, nullable);
        } else if (dtUri.equals(XSD.integer.toString()) || dtUri.equals(XSD.xint.toString())
                || dtUri.equals(XSD.xlong.toString())) {
            // Integer column
            return new LongIntegerColumn(var, nullable, true);
        } else if (dtUri.equals(XSD.unsignedInt.toString()) || dtUri.equals(XSD.unsignedLong.toString())) {
            // Unsigned Integer column
            return new LongIntegerColumn(var, nullable, false);
        } else if (dtUri.equals(XSD.positiveInteger.toString()) || dtUri.equals(XSD.nonNegativeInteger.toString())) {
            // Unsigned Integer column
            return new LongIntegerColumn(var, nullable, false);
        } else if (dtUri.equals(XSD.nonPositiveInteger.toString()) || dtUri.equals(XSD.negativeInteger.toString())) {
            // Signed Integer column
            return new LongIntegerColumn(var, nullable, true);
        } else if (dtUri.equals(XSD.xshort.toString())) {
            // Short Integer column
            return new IntegerColumn(var, nullable, true);
        } else if (dtUri.equals(XSD.unsignedShort.toString())) {
            // Unsigned Short Integer column
            return new IntegerColumn(var, nullable, false);
        } else if (dtUri.equals(XSD.xbyte.toString())) {
            // Signed Byte
            return new ByteColumn(var, nullable, true);
        } else if (dtUri.equals(XSD.unsignedByte.toString())) {
            // Unsigned Byte
            return new ByteColumn(var, nullable, false);
        } else if (dtUri.equals(XSD.time.toString())) {
            // Time column
            return new TimeColumn(var, nullable);
        } else if (dtUri.equals(XSD.xboolean.toString())) {
            // Boolean column
            return new BooleanColumn(var, nullable);
        } else if (dtUri.equals(XSD.xdouble.toString())) {
            // Double column
            return new DoubleColumn(var, nullable);
        } else if (dtUri.equals(XSD.xfloat.toString())) {
            // Float column
            return new FloatColumn(var, nullable);
        } else if (dtUri.equals(XSD.xstring.toString())) {
            // String column
            return new StringColumn(var, nullable);
        } else {
            // Anything else we'll treat as a String
            return new StringColumn(var, nullable);
        }
    }

View Full Code Here

Examples of org.apache.ws.jaxme.sqls.StringColumn

  protected Table getMainTable() {
     if (mainTable == null) {
        Table mt = getSchema().newTable("MAIN");
        Column mtId = mt.newColumn("ID", Column.Type.BIGINT);
        Column mtVer = mt.newColumn("VER", Column.Type.INTEGER);
        StringColumn mtName = (StringColumn) mt.newColumn("NAME", Column.Type.VARCHAR);
        mtName.setLength(60);
        BinaryColumn mtSig = (BinaryColumn) mt.newColumn("SIG", Column.Type.BINARY);
        mtSig.setLength(16);
        mt.newColumn("DATE", Column.Type.DATE);


        Index primaryKey = mt.newPrimaryKey();

View Full Code Here

Examples of org.apache.ws.jaxme.sqls.StringColumn

  }


  protected Table getSubTable() {
    if (subTable == null) {
      Table st = getSchema().newTable("SUB");
      StringColumn stId = (StringColumn) st.newColumn("ID", Column.Type.VARCHAR);
      stId.setLength(32);


      Column stMtId = st.newColumn("MTID", Column.Type.BIGINT);
      Column stMtVer = st.newColumn("MTVER", Column.Type.INTEGER);
      StringColumn stAddress = (StringColumn) st.newColumn("ADDRESS", Column.Type.VARCHAR);
      stAddress.setLength(60);
      StringColumn stEmail = (StringColumn) st.newColumn("EMAIL", Column.Type.VARCHAR);
      stEmail.setLength(60);
      stEmail.setNullable(true);


      Index primaryKey = st.newPrimaryKey();
      primaryKey.addColumn(stId);


      ForeignKey foreignKey = st.newForeignKey(getMainTable());

View Full Code Here

0 1 2 3

TOP

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.