/// <summary> /// Delete all record then insert. /// /// </summary> /// <param name='objects'> /// Objects. /// </param> /// <typeparam name='T'> /// The 1st type parameter. /// </typeparam> public void ReplaceAll <T>(T[] objects) { var desc = Registory.GetClassDesc <T>(); string delete = SQLMaker.GenerateDeleteAllSQL <T>(desc); database.ExecuteNonQuery(delete); foreach (T obj in objects) { string insert = SQLMaker.GenerateInsertSQL(desc, obj); database.ExecuteNonQuery(insert); } }
public void InsertAll <T>(T[] objects) { var desc = Registory.GetClassDesc <T>(); foreach (T obj in objects) { string insert = SQLMaker.GenerateInsertSQL(desc, obj); database.ExecuteNonQuery(insert); } }
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); } }