public void CreateElementTable <T>(string tableName) where T : DatabaseItem, new()
{
T dt = new T();
StringBuilder sbElements = new StringBuilder();
{
bool justCreated = true;
foreach (sqliteBase sElement in dt.values)
{
if (justCreated)
{
justCreated = false;
}
else
{
sbElements.Append(", ");
}
sbElements.Append(sElement.valueName + " " + sElement.dataType);
}
}
string sql_command = "CREATE TABLE " + tableName + " ( " + sbElements.ToString() + ")";
SQLiteCommandsExecuter.executeNonQuery(sql_command, DCore.M_dbConnection);
}
public void DelTable(string tableName)
{
string sql = "DROP TABLE " + tableName;;
SQLiteCommandsExecuter.executeNonQuery(sql, M_dbConnection);
}
public void DelElement(string tableName, sqliteInt rowID)
{
string sql = "DELETE FROM " + tableName + " WHERE " + rowID.valueName + " = " + rowID.value;
SQLiteCommandsExecuter.executeNonQuery(sql, M_dbConnection);
}