A simple game development spreadsheet conversion tool.
Often, working in the game industry requires that the game designer take edit of the game configuration.
However, the difficulty of facing various data table-read associations was the reason for the creation of this tool.
If you have a table like it.
| Field1 | Field2 | Field3 |
|---|---|---|
| 1 | 2 | 3 |
Define the class.
public class TestConfig1
{
public int Field1;
public string Field2;
public float Field3;
}Query from database.
var db = new Regulus.RelationalTables.Database(new IRowProvidable[] { /*Data source ...*/ });
var config = db.Query<TestConfig1>().First();
// config.Field1 == 1
// config.Field2 == "2"
// config.Field3 == 3fSeparate tables.
| Field1 | Field2 | Field3 |
|---|---|---|
| 1 | 2 | 3 |
public class TestConfig1
{
public int Field1;
public string Field2;
public float Field3;
}Array field.
| Field1 | Field2 | Field3 |
|---|---|---|
| 1 | 2 | 3 |
public class TestConfig1
{
[Regulus.RelationalTables.Attributes.Merge("Field1","Field2","Field3")]
public int[] Field;
}Related Table
Table A
| Field1 | Field2 | Field3 |
|---|---|---|
| 1 | 2 | 3 |
Table B
| Field1 | Field2 |
|---|---|
| 1 | 1 |
public class TableA : Regulus.RelationalTables.IRelatable
{
public int Field1;
public string Field2;
public float Field3;
bool IRelatable.Compare(string val)
{
int outVal;
if (int.TryParse(val, out outVal))
{
return outVal == Field1;
}
return false;
}
}
public class TableB
{
public int Field1;
public TestConfig1 Field2;
}Inversely related
Table A
| Table2s |
|---|
| 1 |
Table B
| Owner | Data |
|---|---|
| 1 | 1 |
| 1 | 2 |
class TableA
{
[Attributes.InverselyRelated]
public TableB[] Table2s;
}
class TableB : IRelatable
{
public int Owner;
public int Data;
bool IRelatable.Compare(string val)
{
int owner;
if (int.TryParse(val , out owner))
{
return owner == Owner;
}
return false;
}
}Inversely related by column
Table A
| Id |
|---|
| 1 |
Table B
| Owner | Data |
|---|---|
| 1 | 1 |
| 1 | 2 |
class TableA
{
[Attributes.InverselyRelatedByColumn("Id")]
public TableB[] Table2s;
}
class TableB : IRelatable
{
public int Owner;
public int Data;
bool IRelatable.Compare(string val)
{
int owner;
if (int.TryParse(val , out owner))
{
return owner == Owner;
}
return false;
}
}Custom Parser
public class CustomFieldParser : Regulus.RelationalTables.Attributes.FieldParser
{
public override object Parse(FieldInfo field, IEnumerable<Column> row, ITableable table)
{
//todo : Implement your method...
}
}
public class Table
{
[CustomFieldParser()]
public int Field1;
}Whether you are using Excel, CSV, Google Sheet, or another spreadsheet source, you just need to implement the following interface...
Row provider
namespace Regulus.RelationalTables.Raw
{
public interface IRowProvidable
{
Type GetTableType();
IEnumerable<IColumnProvidable> GetRows();
}
}Column provider
namespace Regulus.RelationalTables.Raw
{
public interface IColumnProvidable
{
IEnumerable<Column> GetColumns();
}
}New a database
var db = new Regulus.RelationalTables.Database(/* IRowProvidable */);Because it takes time to set up the database, it is recommended that the tables be serialized at edit time for runtime use.
Write to stream
var stream = // file stream.
var db = new Regulus.RelationalTables.Database(/* IRowProvidable */);
var converter = new Regulus.RelationalTables.Serialization.BinaryConverter();
converter.WriteToStream(db.Tables, stream , /* ITypeProviable */);Read from stream
var stream = // file stream.
var converter = new Regulus.RelationalTables.Serialization.BinaryConverter();
var tables = converter.ReadFromStream(stream, /* ITypeProviable */);
var db = new Regulus.RelationalTables.Database(tables);ITypeProviable
Need to implement ITypeProviable to provide type information.