public void PullTest(string valueName, GameObject itemManagerGO)
{
SQLbutn itemManager = itemManagerGO.GetComponent <SQLbutn>();
foreach (testTable row in connection.Query <testTable>("SELECT * FROM testTable WHERE name=?", valueName))
{
// itemManager.ID = row.ID;
itemManager.test1 = row.test1;
itemManager.test2 = row.test2;
}
}
public void PushTest(string valueName, GameObject itemManagerGO)
{
SQLbutn itemManager = itemManagerGO.GetComponent <SQLbutn>();
// Debug.Log("????Data PushValuesItem????" + valueName + " " + itemManagerGO.name);
connection.Execute("DELETE FROM testTable WHERE name=?", valueName);
connection.InsertOrReplace(new testTable
{
// ID = itemManager.ID,
name = valueName,
test1 = itemManager.test1,
test2 = itemManager.test2
});
}
