/// <summary>
/// Populate a list with a link to another table or a link within the same table.
/// </summary>
/// <param name="columnToShow"></param>
/// <param name="linkedColumn"></param>
/// <param name="linkedId"></param>
/// <param name="isJObject"></param>
/// <param name="otherTable"></param>
/// <returns></returns>
public Dictionary <uint, string> PopulateWithLink(string columnToShow, string linkedColumn, uint linkedId,
out bool isJObject, string otherTable = "")
{
// Find the other binary if we need to show the string that is inside that table.
// If not that means the linked column is in the same table.
TableBinary tableBinary = otherTable != String.Empty ? TableDatabase.Get.GetBinary(otherTable) : this;
// Populate the <number, string value>
Dictionary <uint, string> newList = tableBinary.Populate(columnToShow, out isJObject);
// Get the index of the linked column
uint uiLinkedID = linkedColumn != "" ? tableBinary.GetColumnID(linkedColumn) : uint.MaxValue;
// Debug.Log($"otherTable: {otherTable}");
// Debug.Log($"linkedColumn: {linkedColumn}");
// Debug.Log($"linkId: {linkedId}");
// Debug.Log($"index linkedID: {uiLinkedID}");
// Remove if not linked
// Remove if not linked
if (uiLinkedID != uint.MaxValue && linkedColumn != "")
{
List <uint> keys = new List <uint>(newList.Keys);
foreach (uint key in keys)
{
TableField currentField = GetField(_tableName, uiLinkedID, key);
if (currentField != null)
{
if (currentField.Data != null)
{
uint id = (uint)currentField.Data;
TableField otherfield = GetField(tableBinary._tableName, columnToShow, id);
if (otherfield != null)
{
string d = "";
if (otherfield.Data is JObject)
{
d += $"[{key}] {otherfield.Data["en"]}";
}
else
{
d += $"[{key}] {otherfield.Data}";
}
newList[key] = d;
}
}
}
// memcpy(&d, Field.Data.Get(), Field.Size);
// if ((uint) d != linkedId && otherTable == String.Empty) newList.Remove(key);
}
// NewList.Compact();
}
return(newList);
}
public TableField GetField(string tableName, uint columnID, uint entityID)
{
string destination = $"{m_ConfigFile.dataPath}/{tableName}.json";
if (!File.Exists(destination))
{
throw new ArgumentException($"{tableName} couldn't be found!");
}
string jsonString = GetStream(destination);
JToken tableData = GetTableData(jsonString);
// The key-value data
JArray arr = tableData["data"].Value <JArray>();
TableField result = new TableField();
// Invalid ID
if (entityID >= arr.Count)
{
return(new TableField());
}
var rowProperties = arr[(int)entityID].Children <JProperty>();
uint i = 0;
foreach (var entity in rowProperties)
{
if (i != columnID)
{
continue;
}
switch (entity.Value.Type)
{
case JTokenType.Boolean:
result.Data = entity.Value.ToObject <bool>();
break;
case JTokenType.Integer:
result.Data = entity.Value.ToObject <double>();
break;
case JTokenType.String:
result.Data = entity.Value.ToObject <string>();
break;
case JTokenType.Object:
result.Data = entity.Value.ToObject <JObject>();
break;
}
i++;
}
return(result);
}
/// <summary>
/// The table data is read from the JSON token and then inserted
/// in the table struct.
/// </summary>
/// <param name="tableData"></param>
/// <param name="tableStruct"></param>
/// <returns></returns>
private static Table ParseData(JToken tableData, ref TableStruct tableStruct)
{
tableStruct.Table.id = tableData["id"]?.ToObject <string>();
tableStruct.Table.metadata = tableData["metadata"]?.ToObject <TableMetaData>();
JArray entities = tableData["data"].Value <JArray>();
// set the count of the amount of entities in the json
tableStruct.Ujson.EntityCount = (uint)entities.Count;
uint i = 0;
// add ID if we dont have one
// Debug.Log(rowProperties["id"]);
// Debug.Log(rowProperties["id"] == null);
// if (rowProperties["id"] == null)
// {
// result.Fields.Add(new TableRowInfo{ ColumnName = "id", ColumnID = i }, new TableField
// {
// Data = entityID
// });
// i++;
// }
// Loop through all the entities
foreach (var el in entities)
{
var rowParameters = el.Children <JProperty>();
TableRow tblRow = new TableRow
{
RowId = i
};
if (i == 0)
{
// Set the amount of columns existing in all the entities
tableStruct.Ujson.ColumnCount = (uint)rowParameters.Count();
// We need to story all the data in one large array
// _ujson.JsonColumnEntries.Capacity = (int)(_ujson.ColumnCount * _ujson.EntityCount);
}
uint j = 0;
foreach (var entity in rowParameters)
{
TableField field = new TableField();
switch (entity.Value.Type)
{
case JTokenType.Boolean:
field.Data = entity.ToObject <bool>();
// Debug.Log("Bool");
break;
case JTokenType.Integer:
field.Data = entity.Value.ToObject <double>();
// Debug.Log("Number");
break;
case JTokenType.String:
field.Data = entity.Value.ToObject <string>();
// Debug.Log("String");
break;
case JTokenType.Object:
field.Data = entity.Value.ToObject <JObject>();
// Debug.Log(field.Data.ToString());
break;
}
// From there we need store the entries
JsonEntry entry = new JsonEntry {
Name = entity.Name, Type = entity.Value.Type
};
tableStruct.Ujson.JsonColumnEntries.Add(entry);
tableStruct.Data.Add(field);
// Add the field to the table row as well.
tblRow.Fields.Add(new TableRowInfo {
ColumnName = entity.Name, ColumnID = j
}, field);
j++;
}
tableStruct.Table.Rows.Add(i, tblRow);
i++;
}
return(tableStruct.Table);
}
/// <summary>
/// Import the JSON data and read from it.
/// </summary>
/// <param name="jsonTableData"></param>
public void Import(JToken jsonTableData)
{
_listUpdated = true;
// Get highest ID
uint highestID = 0;
if (jsonTableData["id"] == null || jsonTableData["data"] == null || jsonTableData["metadata"] == null)
{
throw new ArgumentException("JSON does not contains the property id, data or metadata");
}
if (m_ConfigFile == null)
{
throw new ArgumentException("Database Config file could not be found");
}
// The key-value data
JObject entries = jsonTableData["data"].Value <JObject>();
// The metadata from the json stream
JObject metaData = jsonTableData["metadata"].Value <JObject>();
// set the count of the amount of entities in the json
_ujson.EntityCount = (uint)entries.Count;
// {"Sellable":true,"created_at":1594979553,"deleted":false,"effectPrimaryValue":0,"effectTypeId":0,"name":"","sellValue":0,"updated_at":1594979553}
// Check change in column
// _UJSON.Entries = new List<JSONEntry>((int)_UJSON.EntityCount);
JArray children = new JArray();
int i = 0;
foreach (var row in entries)
{
JObject entity = row.Value.ToObject <JObject>();
// UInt32 j = UInt32.Parse(r.Key) * _UJSON.ColumnCount;
highestID = (uint)Mathf.Max(highestID, uint.Parse(row.Key));
foreach (var column in entity)
{
TableField field = new TableField();
switch (column.Value.Type)
{
case JTokenType.Boolean:
field.Data = column.Value.ToObject <bool>();
// Debug.Log("Bool");
break;
case JTokenType.Integer:
field.Data = column.Value.ToObject <double>();
// Debug.Log("Number");
break;
case JTokenType.String:
field.Data = column.Value.ToObject <string>();
// Debug.Log("String");
break;
case JTokenType.Object:
field.Data = column.Value.ToObject <JObject>();
break;
}
if (i == 0)
{
// Set the amount of columns existing in all the entities
_ujson.ColumnCount = (uint)entity.Count;
JsonEntry entry = new JsonEntry {
Name = column.Key, Type = column.Value.Type
};
_ujson.JsonColumnEntries.Add(entry);
// We need to story all the data in one large array
// _ujson.JsonColumnEntries.Capacity = (int)(_ujson.ColumnCount * _ujson.EntityCount);
}
}
children.Add(row.Value);
i++;
}
// Set data
_ujson.EntityCount = (uint)Mathf.Max(
_ujson.EntityCount,
Mathf.Max((uint)entries.Count, highestID + 1)
);
Export(JObject.FromObject(new
{
id = jsonTableData["id"],
metadata = metaData,
data = children,
}));
}
public static TableRow GetRow(string tableName, uint entityID)
{
DatabaseConfig config = Fetch();
TableRow result = new TableRow
{
RowId = entityID
};
if (config == null)
{
#if UNITY_EDITOR
Debug.LogWarning("Config file not found. Have you created the database config file?");
#else
throw new ArgumentException($"{tableName} couldn't be found!");
#endif
return(result);
}
string destination = $"{config.dataPath}/{tableName}.json";
if (!File.Exists(destination))
#if UNITY_EDITOR
{ Debug.LogWarning($"{tableName} couldn't be found!"); }
#else
{ throw new ArgumentException($"{tableName} couldn't be found!"); }
#endif
if (!File.Exists(destination))
{
throw new ArgumentException($"{tableName} couldn't be found!");
}
string jsonString = GetStream(destination);
JToken tableData = GetTableData(jsonString);
// The key-value data
JArray arr = tableData["data"].Value <JArray>();
// Invalid ID
if (entityID >= arr.Count)
{
Debug.LogWarning($"{tableName}: EntityID: {entityID} does not exist!");
return(new TableRow());
}
var rowProperties = arr[(int)entityID].Children <JProperty>();
uint i = 0;
foreach (var entity in rowProperties)
{
TableField field = new TableField();
switch (entity.Value.Type)
{
case JTokenType.Boolean:
field.Data = entity.Value.ToObject <bool>();
// Debug.Log("Bool");
break;
case JTokenType.Integer:
field.Data = entity.Value.ToObject <double>();
// Debug.Log("Number");
break;
case JTokenType.String:
field.Data = entity.Value.ToObject <string>();
// Debug.Log("String");
break;
case JTokenType.Object:
field.Data = entity.Value.ToObject <JObject>();
break;
}
result.Fields.Add(new TableRowInfo {
ColumnName = entity.Name, ColumnID = i
}, field);
i++;
}
return(result);
}
