// update a row
void UpdateRow(string id, string name)
{
// list of data to be updated
List <SQLiteDB.DB_DataPair> dataList = new List <SQLiteDB.DB_DataPair> ();
// data to be updated
SQLiteDB.DB_DataPair data = new SQLiteDB.DB_DataPair();
data.fieldName = "Name";
data.value = name;
dataList.Add(data);
// row to be updated
SQLiteDB.DB_ConditionPair condition = new SQLiteDB.DB_ConditionPair();
condition.fieldName = "Id";
condition.value = id;
condition.condition = SQLiteDB.DB_Condition.EQUAL_TO;
int i = db.Update("Users", dataList, condition);
if (i > 0)
{
Debug.Log(i + " Record Updated!");
_name = "";
_id = "";
Refresh();
}
}
// delete perticular id
void DeleteRow(string id)
{
SQLiteDB.DB_ConditionPair condition = new SQLiteDB.DB_ConditionPair();
// delete from Users where Id = id
condition.fieldName = "Id";
condition.value = id;
condition.condition = SQLiteDB.DB_Condition.EQUAL_TO;
int i = db.DeleteRow("Users", condition);
if (i > 0)
{
Debug.Log(i + " Record Deleted!");
Refresh();
}
}
public bool Delete(string primaryKeyValue)
{
bool successful = false;
SQLiteDB.DB_ConditionPair condition = new SQLiteDB.DB_ConditionPair();
condition.fieldName = _primaryKeyProperty.Name;
condition.value = primaryKeyValue;
condition.condition = SQLiteDB.DB_Condition.EQUAL_TO;
if (_db.DeleteRow(_tableIdentifier, condition) > 0)
{
successful = true;
}
return(successful);
}
public bool Update(T item)
{
bool successful = false;
List <SQLiteDB.DB_DataPair> dataPairList = new List <SQLiteDB.DB_DataPair>();
SQLiteDB.DB_DataPair data = new SQLiteDB.DB_DataPair();
SQLiteDB.DB_ConditionPair condition = new SQLiteDB.DB_ConditionPair();
foreach (var property in _itemProperties)
{
// if the property isn't being ignored
if (property.GetCustomAttributes(typeof(ColumnIgnoreAttribute), false).Length == 0)
{
// if isn't primary key
if (property.GetCustomAttributes(typeof(PrimaryKeyAttribute), false).Length == 0)
{
data.fieldName = property.Name;
data.value = ConvertValueToString(item, property);
dataPairList.Add(data);
}
// else is, it can't be updated but instead used for finding record to update
else
{
condition.fieldName = property.Name;
condition.value = ConvertValueToString(item, property);
condition.condition = SQLiteDB.DB_Condition.EQUAL_TO;
}
}
}
if (_db.Update(_tableIdentifier, dataPairList, condition) > 0)
{
successful = true;
}
return(successful);
}
