Example usage for io.netty.buffer ByteBuf writeByte

Introduction

In this page you can find the example usage for io.netty.buffer ByteBuf writeByte.

Prototype

public abstract ByteBuf writeByte(int value);

Source Link

Document

Sets the specified byte at the current writerIndex and increases the writerIndex by 1 in this buffer.

Usage

From source file:com.antsdb.saltedfish.server.mysql.PacketEncoder.java

License:Open Source License

/**
 * //from   w w  w. ja  v  a  2s  . c  o m
 * From server to client. One packet for each row in the result set.
 * 
 * <pre>
 * Bytes                   Name
 * -----                   ----
 * n (Length Coded String) (column value)
 * ...
 * 
 * (column value):         The data in the column, as a character string.
 *                         If a column is defined as non-character, the
 *                         server converts the value into a character
 *                         before sending it. Since the value is a Length
 *                         Coded String, a NULL can be represented with a
 *                         single byte containing 251(see the description
 *                         of Length Coded Strings in section "Elements" above).
 * 
 * @see http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#Row_Data_Packet
 * </pre>
 * 
 * @param buffer
 * @param fieldValues
 */
public void writeRowBinaryBody(ByteBuf buffer, long pRecord, CursorMeta meta, int nColumns) {
    if ((pRecord != 0) && (nColumns > 0)) {
        // start of package
        buffer.writeByte(0);

        int nullByteCnt = (nColumns + 7 + 2) / 8;

        byte[] nullBitmap = new byte[nullByteCnt];
        int nullPos = buffer.writerIndex();

        buffer.writeBytes(nullBitmap);

        for (int i = 0; i < nColumns; i++) {
            long pValue = Record.getValueAddress(pRecord, i);
            if (pValue != 0) {
                writeValue(buffer, meta.getColumn(i), pValue);
            } else {
                nullBitmap[(i + 2) / 8] |= 1 << (i + 2) % 8;
            }
        }

        int endPos = buffer.writerIndex();

        buffer.writerIndex(nullPos);
        buffer.writeBytes(nullBitmap);

        buffer.writerIndex(endPos);
    }
}

---

From source file:com.antsdb.saltedfish.server.mysql.PacketEncoder.java

License:Open Source License

private boolean writeValueFast(ByteBuf buffer, FieldMeta meta, long pValue) {
    DataType type = meta.getType();//from  ww w .  j a  v  a 2  s . c o m
    byte format = Value.getFormat(null, pValue);
    if (type.getSqlType() == Types.TINYINT) {
        if (format == Value.FORMAT_INT4) {
            buffer.writeByte(Int4.get(pValue));
            return true;
        } else if (format == Value.FORMAT_INT8) {
            buffer.writeByte((int) Int8.get(null, pValue));
            return true;
        }
    } else if (type.getJavaType() == Boolean.class) {
        boolean b = FishBool.get(null, pValue);
        buffer.writeByte(b ? 1 : 0);
        return true;
    } else if (type.getJavaType() == Integer.class) {
        if (format == Value.FORMAT_INT4) {
            BufferUtils.writeUB4(buffer, Int4.get(pValue));
            return true;
        } else if (format == Value.FORMAT_INT8) {
            BufferUtils.writeUB4(buffer, (int) Int8.get(null, pValue));
            return true;
        }
    } else if (type.getJavaType() == Long.class) {
        if (format == Value.FORMAT_INT4) {
            BufferUtils.writeLongLong(buffer, Int4.get(pValue));
            return true;
        } else if (format == Value.FORMAT_INT8) {
            BufferUtils.writeLongLong(buffer, Int8.get(null, pValue));
            return true;
        }
    } else if (type.getJavaType() == Float.class) {
        if (format == Value.FORMAT_FLOAT4) {
            BufferUtils.writeUB4(buffer, Float.floatToIntBits(Float4.get(null, pValue)));
            return true;
        }
    } else if (type.getJavaType() == Double.class) {
        if (format == Value.FORMAT_FLOAT4) {
            BufferUtils.writeLongLong(buffer, Double.doubleToLongBits(Float8.get(null, pValue)));
            return true;
        }
    }
    return false;
}

---

From source file:com.antsdb.saltedfish.server.mysql.PacketEncoder.java

License:Open Source License

private void writeValueSlow(ByteBuf buffer, FieldMeta meta, long pValue) {
    Object value = FishObject.get(null, pValue);
    DataType type = meta.getType();//from   ww  w  .  j  ava  2 s. co m
    if (type.getSqlType() == Types.TINYINT) {
        buffer.writeByte((Integer) value);
    } else if (type.getJavaType() == Integer.class) {
        BufferUtils.writeUB4(buffer, (Integer) value);
    } else if (type.getJavaType() == Long.class) {
        BufferUtils.writeLongLong(buffer, (Long) value);
    } else if (type.getJavaType() == Float.class) {
        BufferUtils.writeUB4(buffer, Float.floatToIntBits((Float) value));
    } else if (type.getJavaType() == Double.class) {
        BufferUtils.writeLongLong(buffer, Double.doubleToLongBits((Double) value));
    } else if (type.getJavaType() == Timestamp.class) {
        BufferUtils.writeTimestamp(buffer, (Timestamp) value);
    } else if (type.getJavaType() == Date.class) {
        BufferUtils.writeDate(buffer, (Date) value);
    } else if (type.getJavaType() == byte[].class) {
        BufferUtils.writeWithLength(buffer, (byte[]) value);
    } else {
        BufferUtils.writeLenString(buffer, value.toString(), this.cs);
    }
}

---

From source file:com.antsdb.saltedfish.server.mysql.PacketEncoder.java

License:Open Source License

/**
  * /*from w  w  w. j  av  a 2 s  .c o  m*/
  * From server to client. One packet for each row in the result set.
  * 
  * <pre>
  * Bytes                   Name
  * -----                   ----
  * n (Length Coded String) (column value)
  * ...
  * 
  * (column value):         The data in the column, as a character string.
  *                         If a column is defined as non-character, the
  *                         server converts the value into a character
  *                         before sending it. Since the value is a Length
  *                         Coded String, a NULL can be represented with a
  *                         single byte containing 251(see the description
  *                         of Length Coded Strings in section "Elements" above).
  * 
  * @see http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#Row_Data_Packet
  * </pre>
  * 
  * @param buffer
  * @param nColumns 
  * @param rowRec
  */
public void writeRowTextBody(ByteBuf buffer, long pRecord, int nColumns) {
    for (int i = 0; i < nColumns; i++) {
        Object fv = Record.getValue(pRecord, i);
        if (fv instanceof Boolean) {
            // mysql has no boolean it is actually tinyint
            fv = ((Boolean) fv) ? 1 : 0;
        }
        if (fv == null) {
            // null mark is 251
            buffer.writeByte((byte) 251);
        } else if (fv instanceof Duration) {
            Duration t = (Duration) fv;
            String text = DurationFormatUtils.formatDuration(t.toMillis(), "HH:mm:ss");
            BufferUtils.writeLenString(buffer, text, this.cs);
        } else if (fv instanceof Timestamp) {
            // @see ResultSetRow#getDateFast, mysql jdbc driver only take precision 19,21,29 if callers wants
            // to get a Date from a datetime column
            Timestamp ts = (Timestamp) fv;
            if (ts.getTime() == Long.MIN_VALUE) {
                // mysql '0000-00-00 00:00:00' is treated as null in jdbc
                buffer.writeByte((byte) 251);
            } else {
                String text;
                if (ts.getNanos() == 0) {
                    text = TIMESTAMP19_FORMAT.format(ts);
                } else {
                    text = TIMESTAMP29_FORMAT.format(ts);
                }
                BufferUtils.writeLenString(buffer, text, this.cs);
            }
        } else if (fv instanceof byte[]) {
            BufferUtils.writeWithLength(buffer, (byte[]) fv);
        } else if ((fv instanceof Date) && (((Date) fv).getTime() == Long.MIN_VALUE)) {
            // mysql '0000-00-00' is treated as null in jdbc
            buffer.writeByte((byte) 251);
        } else {
            String val = fv.toString();
            if (val.length() == 0) {
                // empty mark is 0
                buffer.writeByte((byte) 0);
            } else {
                BufferUtils.writeLenString(buffer, val, this.cs);
            }
        }
    }
}

---

From source file:com.antsdb.saltedfish.server.mysql.PacketEncoder.java

License:Open Source License

/**
 * /*  w  ww.j  av a 2s.c  o  m*/
 * From server to client during initial handshake.
 * 
 * <pre>
 * Bytes                        Name
 * -----                        ----
 * 1                            protocol_version
 * n (Null-Terminated String)   server_version
 * 4                            thread_id
 * 8                            scramble_buff
 * 1                            (filler) always 0x00
 * 2                            server_capabilities
 * 1                            server_language
 * 2                            server_status
 * 13                           (filler) always 0x00 ...
 * 13                           rest of scramble_buff (4.1)
 * 
 * @see http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#Handshake_Initialization_Packet
 * </pre>
 * 
 * @param buffer
 * @param serverVersion
 * @param protocolVersion
 * @param threadId
 * @param capability
 * @param charSet
 * @param status
 */
public static void writeHandshakeBody(ByteBuf buffer, String serverVersion, byte protocolVersion, long threadId,
        int capability, byte charSet, int status) {
    buffer.writeByte(protocolVersion);
    BufferUtils.writeString(buffer, serverVersion);
    BufferUtils.writeUB4(buffer, threadId);
    // seed
    byte[] seed = new byte[] { 0x50, 0x3a, 0x6e, 0x3d, 0x25, 0x40, 0x51, 0x56 };
    buffer.writeBytes(seed);
    buffer.writeByte(0);
    // lower 16 bits of sever capacity
    BufferUtils.writeInt(buffer, capability);
    // serverCharsetIndex
    buffer.writeByte(charSet);
    // server status 
    BufferUtils.writeInt(buffer, status);
    // upper 16 bits of server capacity
    BufferUtils.writeInt(buffer, capability >>> 16);
    // plugin data length
    if ((capability & MysqlServerHandler.CLIENT_PLUGIN_AUTH) != 0) {
        buffer.writeByte(0x15);
    } else {
        buffer.writeByte(0);
    }
    // fill the rest 10 bytes with 0
    buffer.writeZero(10);
    if ((capability & MysqlServerHandler.CLIENT_PLUGIN_AUTH) != 0) {
        // no idea what this means, copied from trace
        buffer.writeBytes(
                new byte[] { 0x73, 0x68, 0x2f, 0x50, 0x27, 0x6f, 0x7a, 0x38, 0x46, 0x38, 0x26, 0x51, 0x00 });
        BufferUtils.writeString(buffer, MysqlServerHandler.AUTH_MYSQL_NATIVE);
    }
}

---

From source file:com.antsdb.saltedfish.server.mysql.PacketEncoder.java

License:Open Source License

/**
 * /*from w w  w .j  a  va 2 s . co m*/
 * From server to client in response to command, if no error and no result set.
 * 
 * <pre>
 * Bytes                       Name
 * -----                       ----
 * 1                           field_count, always = 0
 * 1-9 (Length Coded Binary)   affected_rows
 * 1-9 (Length Coded Binary)   insert_id
 * 2                           server_status
 * 2                           warning_count
 * n   (until end of packet)   message fix:(Length Coded String)
 * 
 * @see http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#OK_Packet
 * </pre>
 * 
 * @param buffer
 */
public void writeOKBody(ByteBuf buffer, long affectedRows, long insertId, String message, Session session) {
    // filed count
    buffer.writeByte(0x00);
    // affected rows
    BufferUtils.writeLength(buffer, affectedRows);
    // inserId
    BufferUtils.writeLength(buffer, insertId);
    // server status
    int status = 0;
    if (session.isAutoCommit()) {
        status |= SERVER_STATUS_AUTOCOMMIT;
    }
    Transaction trx = session.getTransaction();
    if (trx != null) {
        if (trx.getTrxId() < 0) {
            status |= SERVER_STATUS_IN_TRANS;
        }
    }
    BufferUtils.writeUB2(buffer, status);
    // warning count = 0
    BufferUtils.writeUB2(buffer, 0);
    // message
    if (message != null) {
        BufferUtils.writeLenString(buffer, message, Charsets.UTF_8);
    }
}

---

From source file:com.antsdb.saltedfish.server.mysql.PacketEncoder.java

License:Open Source License

/**
 * // ww w .j ava 2 s.c o  m
 * From server to client in response to command, if error.
 * 
 * <pre>
 * Bytes                       Name
 * -----                       ----
 * 1                           field_count, always = 0xff
 * 2                           errno
 * 1                           (sqlstate marker), always '#'
 * 5                           sqlstate (5 characters)
 * n                           message
 * 
 * @see http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#Error_Packet
 * </pre>
 * 
 * @param buffer
 * @param errno
 * @param message
 */
public void writeErrorBody(ByteBuf buffer, int errno, ByteBuffer message) {
    // field count
    buffer.writeByte((byte) 0xff);
    // error number
    BufferUtils.writeUB2(buffer, errno);
    // sql state mark
    buffer.writeByte((byte) '#');
    // sql state
    buffer.writeBytes("HY000".getBytes());
    if (message != null) {
        buffer.writeBytes(message);
    }
}

---

From source file:com.antsdb.saltedfish.server.mysql.PacketEncoder.java

License:Open Source License

/**
 * /*from   ww w .  j av a 2 s.co m*/
 * From Server To Client, at the end of a series of Field Packets, and at the
 * end of a series of Data Packets.With prepared statements, EOF Packet can also
 * end parameter information, which we'll describe later.
 * 
 * <pre>
 * Bytes                 Name
 * -----                 ----
 * 1                     field_count, always = 0xfe
 * 2                     warning_count
 * 2                     Status Flags
 * 
 * @see http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#EOF_Packet
 * </pre>
 * 
 * 
 * @param out
 * @param session 
 */
public void writeEOFBody(ByteBuf out, Session session) {
    // field count
    out.writeByte((byte) 0xfe);
    // warning count = 0
    BufferUtils.writeUB2(out, 0);
    // status = 2
    int status = 0x20;
    if (session.isAutoCommit()) {
        status |= SERVER_STATUS_AUTOCOMMIT;
    }
    Transaction trx = session.getTransaction();
    if (trx != null) {
        if (trx.getTrxId() < 0) {
            status |= SERVER_STATUS_IN_TRANS;
        }
    }
    BufferUtils.writeUB2(out, status);
}

---

From source file:com.antsdb.saltedfish.server.mysql.PacketEncoder.java

License:Open Source License

/**
 * /*from  w w  w . j  a  v  a 2  s .c  o m*/
 * Registers a slave at the master. Should be sent before requesting a binlog events with COM_BINLOG_DUMP.
 * 
 * <pre>
 * Bytes                        Name
 * -----                        ----
 *   1              [15] COM_REGISTER_SLAVE
 *   4              server-id
 *   1              slaves hostname length
 *   string[$len]   slaves hostname
 *   1              slaves user len
 *   string[$len]   slaves user
 *   1              slaves password len
 *   string[$len]   slaves password
 *   2              slaves mysql-port
 *   4              replication rank
 *   4              master-id
 * 
 * @see https://dev.mysql.com/doc/internals/en/com-register-slave.html
 * </pre>
 * 
 */
public void writeRegisterSlave(ByteBuf buffer, int serverId) {
    // code for COM_REGISTER_SLAVE is 0x15 
    buffer.writeByte(0x15);
    BufferUtils.writeUB4(buffer, serverId);
    // usually empty
    BufferUtils.writeLenString(buffer, "", Charsets.UTF_8);
    // usually empty
    BufferUtils.writeLenString(buffer, "", Charsets.UTF_8);
    // usually empty
    BufferUtils.writeLenString(buffer, "", Charsets.UTF_8);
    // usually empty
    BufferUtils.writeUB2(buffer, 0);
    // replication rank to be ignored
    buffer.writeBytes(new byte[4]);
    // master id, usually 0
    BufferUtils.writeUB4(buffer, 0);
}

---

From source file:com.antsdb.saltedfish.server.mysql.PacketEncoder.java

License:Open Source License

/**
 * /*from   w ww .  ja  va  2s  .com*/
 * Requests a binlog network stream from the master starting a given position.
 * 
 * <pre>
 * Bytes                        Name
 * -----                        ----
 *   1              [12] COM_BINLOG_DUMP
 *   4              binlog-pos
 *   2              flags
 *   4              server-id
 *   string[EOF]    binlog-filename
 * 
 * @see https://dev.mysql.com/doc/internals/en/com-binlog-dump.html
 * </pre>
 * 
 */
public void writeBinlogDump(ByteBuf buffer, long binlogPos, int serverId, String binlogName) {
    // code for COM_BINLOG_DUMP is 0x12 
    buffer.writeByte(0x12);
    BufferUtils.writeUB4(buffer, binlogPos);
    // flag, 0 means don't send EOF if no more bing log
    BufferUtils.writeUB2(buffer, 0);
    // server id of this slave
    BufferUtils.writeUB4(buffer, serverId);
    // binlog file name
    BufferUtils.writeString(buffer, binlogName);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »