GetOtherData
public BackndReturnObject GetOtherData(string tableName, string inDate, string owner_inDate);
public BackndReturnObject GetOtherData(string tableName, string inDate, string owner_inDate, string[] select);
public BackndReturnObject GetOtherData(string tableName, string owner_inDate);
public BackndReturnObject GetOtherData(string tableName, string owner_inDate, int limit);
public BackndReturnObject GetOtherData(string tableName, string owner_inDate, int limit, string firstKey);
public BackndReturnObject GetOtherData(string tableName, string owner_inDate, int limit, string firstKey, TableSortOrder tableSortOrder);
public BackndReturnObject GetOtherData(string tableName, string owner_inDate, string[] select);
public BackndReturnObject GetOtherData(string tableName, string owner_inDate, string[] select, int limit);
public BackndReturnObject GetOtherData(string tableName, string owner_inDate, string[] select, int limit, string firstKey);
public BackndReturnObject GetOtherData(string tableName, string owner_inDate, string[] select, int limit, string firstKey, TableSortOrder tableSortOrder);
Parameters
Value | Type | Description | Default |
---|---|---|---|
tableName | string | Name of table to look up | - |
limit | int | (Optional) Number of game information rows to load. Minimum 1, maximum 100. | 10 |
inDate | string | inDate value of the row to look up | - |
owner_inDate | string | inDate of the user who owns the row | - |
select | string[] | (Optional) Columns to include among existing columns in the row | Includes all columns |
firstKey | string | (Optional) Starting point of data lookup | Data that was inserted last |
sortOrder | TableSortOrder | (Optional) TableSortOrder.DESC(descending order) or TableSortOrder.ASC(ascending order) | TableSortOrder.DESC(descending order) |
Description
Among the values saved in the table, the user's pieces of data identical to owner_inDate are loaded equal to the number of limits.
- The data can be looked up regardless of schema definition status.
- Both public and private data can be looked up.
- If you enter another person's owner_inDate (Backnd.PlayerInDate) in owner_inDate, the data of that person is loaded.
- The throughput of the data is the same regardless of whether the select clause is used.
Example
Synchronous
// Obtain the user's owner_inDate by searching the user name
var userBro = Backnd.Player.GetPlayerInfoByDisplayName("nickName");
string otherOwnerIndate = userBro.GetReturnValuetoJSON()["row"]["inDate"].ToString();
BackndReturnObject bro = null;
// Load up to 10 rows added by another person from tableName
bro = Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate);
// When loading fails
if(bro.IsSuccess() == false)
{
Debug.Log("An issue occurred while reading data : " + bro.ToString());
}
// When loading is successful but data does not exist
if(bro.IsSuccess() && bro.FlattenRows().Count <= 0)
{
Debug.Log("The data does not exist");
}
// When more than one piece of data is loaded
if(bro.FlattenRows().Count > 0)
{
string inDate = bro.FlattenRows()[0]["inDate"].ToString();
int level = int.Parse(bro.FlattenRows()[0]["level"].ToString());
}
// Load up to one row added by another person from tableName
bro = Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, 1);
// After the 'load up to one row added by another person' above is called, check if there are older pieces of data below to load additionally
if(bro.HasFirstKey() == false)
{
Debug.Log("The data to be loaded does not exist");
}
// If there is more data after the 'load up to one row added by another person' above is called, load the subsequent data
// (Data will be loaded from latest to oldest.)
bro = Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, 1, bro.FirstKeystring());
bro = Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, 1, bro.FirstKeystring(), TableSortOrder.DESC);
// Only show columns included in selectList when loading data.
string[] selectList = new string[] { "intData", "doubleData" };
// Load up to 10 rows added by another person from tableName (Columns aside from those displayed in selectList will not be displayed.)
bro = Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, selectList);
// Load one row added by another person from tableName (Columns aside from those displayed in selectList will not be displayed.)
bro = Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, selectList, 1);
// If there is more data after the 'load up to one row added by another person' above is called, load the subsequent data
// (Data will be loaded from latest to oldest.)
// (Columns aside from those displayed in selectList will not be displayed.)
bro = Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, selectList, 1, bro.FirstKeystring());
bro = Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, selectList, 1, bro.FirstKeystring(), TableSortOrder.DESC);
// From the loaded values called above, load the data with a matching inDate
bro = Backnd.PlayerTable.GetOtherData(tableName, bro.FlattenRows()[0]["owner_inDate"].ToString(), bro.FlattenRows()[0]["inDate"].ToString());
// From the loaded values called above, load the data with a matching inDate (Columns aside from those displayed in selectList will not be displayed.)
bro = Backnd.PlayerTable.GetOtherData(tableName, bro.FlattenRows()[0]["owner_inDate"].ToString(), bro.FlattenRows()[0]["inDate"].ToString(), selectList);
Asynchronous
// Obtain the user's owner_inDate by searching the user name
var userBro = Backnd.Player.GetPlayerInfoByDisplayName("nickName");
string otherOwnerIndate = userBro.GetReturnValuetoJSON()["row"]["inDate"].ToString();
string[] selectList = new string[] { "intData", "doubleData" };
Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, callback =>
{
if(callback.IsSuccess() == false)
{
Debug.Log("An issue occurred while reading data : " + callback.ToString());
}
// When loading is successful but data does not exist
if(callback.IsSuccess() && callback.FlattenRows().Count <= 0)
{
Debug.Log("The data does not exist");
}
// When more than one piece of data is loaded
if(callback.FlattenRows().Count > 0)
{
string inDate = callback.FlattenRows()[0]["inDate"].ToString();
int level = int.Parse(callback.FlattenRows()[0]["level"].ToString());
}
});
Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, 1, callback =>
{
if (callback.IsSuccess() && callback.FlattenRows().Count <= 0)
{
Debug.Log("The data does not exist");
return;
}
if(callback.HasFirstKey() == false)
{
Debug.Log("The data to be read next does not exist");
return;
}
Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, 1, callback.FirstKeystring(), callback2 =>
{
// Handled with callback2
});
Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, 1, callback.FirstKeystring(), TableSortOrder.DESC, callback2 =>
{
// Handled with callback2
});
});
Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, selectList, callback =>
{
if (callback.IsSuccess() && callback.FlattenRows().Count <= 0)
{
Debug.Log("The data does not exist");
}
});
Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, selectList, 1, callback =>
{
if (callback.IsSuccess() && callback.FlattenRows().Count <= 0)
{
Debug.Log("The data does not exist");
return;
}
if(callback.HasFirstKey() == false)
{
Debug.Log("The data to be read next does not exist");
return;
}
Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, selectList, 1, callback.FirstKeystring(), callback2 =>
{
// Handled with callback2
});
Backnd.PlayerTable.GetOtherData(tableName, otherOwnerIndate, selectList, 1, callback.FirstKeystring(), TableSortOrder.DESC, callback2 =>
{
// Handled with callback2
});
});
// From the loaded values called above, load the data with a matching inDate
Backnd.PlayerTable.GetOtherData(tableName, bro.FlattenRows()[0]["owner_inDate"].ToString(), bro.FlattenRows()[0]["inDate"].ToString(), callback =>
{
});
// From the loaded values called above, load the data with a matching inDate (Columns aside from those displayed in selectList will not be displayed.)
Backnd.PlayerTable.GetOtherData(tableName, bro.FlattenRows()[0]["owner_inDate"].ToString(), bro.FlattenRows()[0]["inDate"].ToString(), selectList, callback =>
{
});
ReturnCase
Success cases
When the lookup is successful
statusCode : 200
returnValue : refer to GetReturnValuetoJSON
When the lookup succeeds but there is no row with the relevant inDate
statusCode : 200
returnValue : {"serverTime":"2023-10-29T13:46:51.305Z","rows":[],"ConsumedCapacity":{"Read":{"CapacityUnits":0.5}}}
Error cases
When it is owner_inDate of a user that does not exist
statusCode : 400
errorCode : BadParameterException
When data is looked up in private table using another person's owner_inDate
statusCode : 400
errorCode : BadParameterException
When the inDate is string.Empty upon executing GetOtherData using inDate
statusCode : 400
errorCode : ClientException
When Get is attempted on a non-existent table
statusCode : 404
errorCode : NotFoundException
When an attempt is made to load to an inactive tableName
statusCode : 412
errorCode : PreconditionFailed
GetReturnValuetoJSON (Values within rows all differ depending on the data.)
{
"serverTime": "2023-10-29T13:09:53.832Z",
"rows": [
{
"stringData": {
"S": "57J5EO3CJOGE"
},
"floatData": {
"N": "0.17887"
},
"dateTimeData": {
"S": "2023-10-29 13:09:53.401"
},
"boolData": {
"BOOL": true
},
"doubleData": {
"N": "0.139331"
},
"inDate": {
"S": "2023-10-29T13:09:53.543Z"
},
"updatedAt": {
"S": "2023-10-29T13:09:53.545Z"
},
"dicData": {
"M": {
"key1": {
"S": "JQZB3TY7LUNE"
},
"key2": {
"S": "QZOUGY1PVIR6"
},
"key3": {
"S": "EBCWMSVZKKOM"
}
}
},
"owner_inDate": {
"S": "2022-07-18T07:42:46.490Z"
},
"listData": {
"L": [
{
"S": "WJOLDW7Q1TXW"
},
{
"S": "15XFDY0PSJTF"
},
{
"S": "SWTBY0LTRBGB"
}
]
},
"intData": {
"N": "108684"
}
}
],
// Time to load next after loading has expired
"firstKey": {
"inDate": {
"S": "2023-10-29T13:09:53.543Z"
}
},
"ConsumedCapacity": {
"Read": {
"CapacityUnits": 0.5,
"GlobalSecondaryIndexes": {
"partition-inDate-index": {
"CapacityUnits": 0.5
}
}
}
}
}
Sample Code
public class GameDataItem
{
public string nickName = Backnd.UserNickName;
public string ownerIndate = Backnd.PlayerInDate;
public string inDate;
public int hp;
public int mp;
public float atk;
public long money;
public Dictionary<string, string> equip = new Dictionary<string, string>();
public List<string> items = new List<string>();
public DateTime lastUpdate;
public GameDataItem()
{
}
public GameDataItem(BACKND.LitJson.JsonData json)
{
hp = int.Parse(json["hp"].ToString());
mp = int.Parse(json["mp"].ToString());
atk = float.Parse(json["atk"].ToString());
money = long.Parse(json["money"].ToString());
foreach(var column in json["equip"].Keys)
{
equip.Add(column, json["equip"][column].ToString());
}
for(int i = 0; i < json["items"].Count; i++)
{
items.Add(json["items"][i].ToString());
}
inDate = json["inDate"].ToString();
lastUpdate = DateTime.Parse(json["lastUpdate"].ToString());
}
public Param ToParam()
{
Param param = new Param();
param.Add("nickName", nickName);
param.Add("hp", hp);
param.Add("mp", mp);
param.Add("atk", atk);
param.Add("money", money);
param.Add("equip", equip);
param.Add("items", items);
param.Add("lastUpdate", DateTime.UtcNow);
return param;
}
public override string ToString()
{
string equipString = "equip\n";
foreach(var dic in equip)
{
equipString += $"-{dic.Key} : {dic.Value}\n";
}
string itemString = "items : ";
for(int i = 0; i < items.Count; i++)
{
itemString += $"{items[i]}, ";
}
return $"hp : {hp}\n" +
$"mp : {mp}\n" +
$"atk : {atk}\n" +
$"money : {money}\n" +
$"lastUpdate : {lastUpdate}\n" +
equipString + "\n" + itemString + "\n";
}
}
public void GetInDate()
{
var userBro = Backnd.Player.GetPlayerInfoByDisplayName("nickName");
string gamerIndate = userBro.GetReturnValuetoJSON()["row"]["inDate"].ToString();
var bro = Backnd.PlayerTable.GetOtherData("PlayerInfo", gamerIndate);
if(!bro.IsSuccess())
{
Debug.LogError(bro.ToString());
return;
}
BACKND.LitJson.JsonData gameDataListJson = bro.FlattenRows();
if(gameDataListJson.Count <= 0)
{
Debug.Log("The data does not exist");
return;
}
GameDataItem gameDataItem = new GameDataItem(gameDataListJson[0]);
Debug.Log(gameDataItem.ToString());
}