[TDR List Table][Java SDK] Insert an Element to a Specified Position in a List

1. Interface Description

Insert new data after a specified position of a list for a specified Key in a table.

2. Version Requirements

This interface is provided in all versions without special requirements.

3. Preparations

Refer to Preparation document to complete the preparation before using this interface and create the following TDR List table.

Get the following information after the preparation. These details will be used by the SDK:

  1. Directory server address list
  2. App ID
  3. App access password
  4. Game zone ID
  5. Table name

4. Example Code

Basic execution process of example code:

  1. Create a client;
  2. Create a request;
  3. Send a request;
  4. Process the response;
  5. Destroy the client.

4.1 Example Code for Synchronous Call

import com.tencent.tcaplus.client.Client;
import com.tencent.tcaplus.client.ClientFactory;
import com.tencent.tcaplus.client.Record;
import com.tencent.tcaplus.client.Request;
import com.tencent.tcaplus.client.Response;
import com.tencent.tdr.tcaplus_protocol_cs.TcaplusProtocolCsConstants;

import java.util.ArrayList;
import java.util.List;

public class Example {

    public static void main(String[] arguments) {
        // 1. Prepare the environment information
        // 1.1. Directory server address list
        List<String> dirList = new ArrayList<String>();
        dirList.add("tcp://x.x.x.x:9999");
        dirList.add("tcp://y.y.y.y:9999");
        // 1.2. App ID
        int appId = 1;
        // 1.3. App password
        String appPassword = "****************";
        // 1.4. Table group ID
        int tableGroupId = 1;
        // 1.5. Table name
        String tableName = "test";

        // 2. Create a client
        Client client = ClientFactory.createClient(appId, tableGroupId, appPassword, dirList);
        try {
            // 3. Construct a request to insert data
            // 3.1. Get the request object. In order to improve the SDK's performance, the Request object is reused
            Request request = client.acquireRequest();
            // 3.2. Set the request type and target table name. Note: The target table must be a List table
            request.setCmd(TcaplusProtocolCsConstants.TCAPLUS_CMD_LIST_ADDAFTER_REQ);
            request.setTableName(tableName);
            // 3.3. Specify where to insert the new data into the list
                  //      In this sample, -1 means to insert at the end of the list. If it is 0, it means to insert after the first data in the list, and so on
            Record record = request.addRecord(-1);
            // 3.4. Set the values of each field of the data. Note: The Key field and the Value field are set in different ways
            record.setKeyInt("gameid", 1);
            record.setKeyInt("itemid", 1);
            record.setKeyString("name", "test");
            record.setValueByte("typeid", (byte) 1);
            record.setValueByte("Data", (byte) 1);
            record.setValueString("uname", "test");

            // 4. Send a request and get the result
            Response response = client.poll(request);

            // 5. Process the result
            if (response.getResult() == 0) {
                // Data insert successful
                // TODO: add the code to process the result of data insert successful here
            } else {
                // Data insert failure
                // TODO: add the code to process the result of data insert failure here
            }
        } finally {
            // 6. Destroy the client object
            ClientFactory.destroyClient(client);
        }
    }

}

4.2 Example Code for Asynchronous Call

import com.tencent.tcaplus.client.Client;
import com.tencent.tcaplus.client.ClientFactory;
import com.tencent.tcaplus.client.Record;
import com.tencent.tcaplus.client.Request;
import com.tencent.tcaplus.client.Response;
import com.tencent.tdr.tcaplus_protocol_cs.TcaplusProtocolCsConstants;

import java.util.ArrayList;
import java.util.List;

public class Example {

    public static void main(String[] arguments) {
        // 1. Prepare the environment information
        // 1.1. Directory server address list
        List<String> dirList = new ArrayList<String>();
        dirList.add("tcp://x.x.x.x:9999");
        dirList.add("tcp://y.y.y.y:9999");
        // 1.2. App ID
        int appId = 1;
        // 1.3. App password
        String appPassword = "****************";
        // 1.4. Table group ID
        int tableGroupId = 1;
        // 1.5. Table name
        String tableName = "test";

        // 2. Create a client
        Client client = ClientFactory.createClient(appId, tableGroupId, appPassword, dirList);
        try {
            // 3. Construct a request to insert data
            // 3.1. Get the request object. In order to improve the SDK's performance, the Request object is reused
            Request request = client.acquireRequest();
            // 3.2. Set the request type and target table name. Note: The target table must be a List table
            request.setCmd(TcaplusProtocolCsConstants.TCAPLUS_CMD_LIST_ADDAFTER_REQ);
            request.setTableName(tableName);
            // 3.3. Specify where to insert the new data into the list
                  //      In this sample, -1 means to insert at the end of the list. If it is 0, it means to insert after the first data in the list, and so on
            Record record = request.addRecord(-1);
            // 3.4. Set the values of each field of the data. Note: The Key field and the Value field are set in different ways
            record.setKeyInt("gameid", 1);
            record.setKeyInt("itemid", 1);
            record.setKeyString("name", "test");
            record.setValueByte("typeid", (byte) 1);
            record.setValueByte("Data", (byte) 1);
            record.setValueString("uname", "test");

            CountDownLatch latch = new CountDownLatch(1);

            // 4. Send the request asynchronously and specify the processor that returns the response. The post method will return the result immediately
            client.post(request, new Future() {

                @Override
                public void onResponse(Response response) {
                    // 5. Process the response
                    if (response.getResult() == 0) {
                        // Data getting success
                        // TODO: add the subsequent processing code of successful data getting here
                    } else {
                        // Data getting failure
                        // TODO: add the subsequent processing code of failed data getting here
                    }
                }

            });

            latch.await();
        } finally {
            // 6. Destroy the client object
            ClientFactory.destroyClient(client);
        }
    }

}

5. Method Description in Request Object

Note: If there is an unlisted Request object method, it means that the method is invalid in the scenario of inserting data.

Method signature Method description
void setCmd(int cmd) Set the request type (command). cmd: request type, fixed to TcaplusProtocolCsConstants.TCAPLUS_CMD_LIST_ADDAFTER_REQ.
void setTableName(String tableName) Set the target table name. TableName: target table name, which cannot be null.
Record addRecord(int index) Create and set a new data object (Record). The user can call the setXXX method of the object to set the values of each field of the new data. Index: the serial number of the position where the new data is to be inserted. - 1 means to insert at the end of the list, 0 means to insert after the first element of the list, and so on.

5.1. Method Description in Request Data Object

Note: If there is an unlisted Record object method, it means that the method is invalid in the scenario of inserting data.

Method signature Method description
void setVersion(int version) Set the version number of the record. Version: if it is set to a negative number, it means that version control is not started for the current data.
void setKeyByte(String fieldName, byte value) Set the value of the Key field for the specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java byte type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setKeyShort(String fieldName, short value) Set the value of the Key field for the specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java short type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setKeyInt(String fieldName, int value) Set the value of the Key field for the specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java int type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setKeyLong(String fieldName, long value) Set the value of the Key field for the specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java long type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setKeyFloat(String fieldName, float value) Set the value of the Key field for the specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java float type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setKeyDouble(String fieldName, double value) Set the value of the Key field for the specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java double type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setKeyString(String fieldName, String value) Set the value of the Key field for the specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java String type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setKeyBlob(String fieldName, byte[] value) Set the value of the Key field for the specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java[]. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setValueByte(String fieldName, byte value) Set the value of a Value field of a specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java byte type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setValueShort(String fieldName, short value) Set the value of a Value field of a specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java short type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setValueInt(String fieldName, int value) Set the value of a Value field of a specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java int type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setValueLong(String fieldName, long value) Set the value of a Value field of a specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java long type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setValueFloat(String fieldName, float value) Set the value of a Value field of a specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java float type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setValueDouble(String fieldName, double value) Set the value of a Value field of a specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java double type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setValueString(String fieldName, String value) Set the value of a Value field of a specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java String type. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.
void setValueBlob(String fieldName, byte[] value) Set the value of a Value field of a specified name. Note: This method can only be called to set the field value when the field type defined in the TDR table description file corresponds to the Java[]. Otherwise, the server will report parameter errors when processing the request. See Relationship between TDR Table Field Types and Java Types. fieldName: field name, which cannot be null. Value: the new value of the field.

6. Method Description in Response Object

Note: If there is an unlisted Reponse object method, it means that the method is invalid in the scenario of inserting data.

Method signature Method description
int getResult() Get the response code of the data insertion request. 0 indicates that the operation succeeds. If the value is not 0, the operation is abnormal. Please refer to Response Code Meaning Description.

7. FAQ

For details, see Meaning and Handling of Error Codes.

8. Other Reference Documents

[TDR List Table][C++ SDK] Interface Description for Inserting an Element into a Specified Position in a List

[TDR List Table] [Go SDK] Interface Description for Inserting an Element into a Specified Position in a List

results matching ""

    No results matching ""