public void UpdateAll <T>(T[] objects)
{
var desc = Registory.GetClassDesc <T>();
foreach (T obj in objects)
{
string update = SQLMaker.GenerateUpdateSQL(desc, obj);
database.ExecuteNonQuery(update);
}
}
public void UpdateOrInsert <T>(T obj)
{
var desc = Registory.GetClassDesc <T>();
string queryData = SQLMaker.GenerateSelectSQL <T> (desc, obj);
try{
DataTable queryResult = database.ExecuteQuery(queryData);
if (queryResult.Rows.Count > 0)
{
// Debug.Log(":: Update Data");
string update = SQLMaker.GenerateUpdateSQL(desc, obj);
database.ExecuteNonQuery(update);
}
else
{
// Debug.Log(":: Insert Data");
string insert = SQLMaker.GenerateInsertSQL(desc, obj);
database.ExecuteNonQuery(insert);
}
}catch (SqliteException e) {
Debug.Log("Fail! err: " + e.ErrorCode + " - " + e.Message);
}
}