public void ReturnTrueIfModelTableFieldsAreCorrect() { List <string> UserModelFields = MySQLDBStateless.ModelFieldNames(typeof(UserModel)); StringBuilder StringBuilder = new StringBuilder(); foreach (string userModelField in UserModelFields) { StringBuilder.Append(StringBuilder.Length == 0 ? $"{userModelField}" : $", {userModelField}"); } Assert.AreEqual("usrID, usrUID, usrFirstName, usrLastName, usrEmailAddress", StringBuilder.ToString()); }
public void ReturnTrueIfStandardInsertStatementisCorrect() { UserModel UserModel = new UserModel() { ID = 1, UID = "Testert1", FirstName = "Test", LastName = "Tester", EmailAddress = "*****@*****.**" }; string UserInsertStatement = MySQLDBStateless.GenerateStandardInsertStatement(UserModel); Assert.AreEqual($"INSERT INTO {UserModel.TableName()} (usrUID, usrFirstName, usrLastName, usrEmailAddress) VALUES ('Testert1', 'Test', 'Tester', '*****@*****.**')", UserInsertStatement); }
public void ReturnTrueIfDeleteStatementIsCorrect() { UserModel UserModel = new UserModel() { ID = 1, UID = "Testert1", FirstName = "Test", LastName = "Tester", EmailAddress = "*****@*****.**" }; string UserDeleteStatement = MySQLDBStateless.GenerateStandardDeleteStatement(UserModel, nameof(UserModel.ID), UserModel.ID); Assert.AreEqual($"DELETE FROM {UserModel.TableName()} WHERE usrID = 1", UserDeleteStatement); }
public void ReturnTrueIfUpdateStatementIsCorrect() { UserModel UserModel = new UserModel() { ID = 1, UID = "Testert1", FirstName = "Test", LastName = "Tester", EmailAddress = "*****@*****.**" }; string UserUpdateStatement = MySQLDBStateless.GenerateStandardUpdateStatement(UserModel, nameof(UserModel.ID), UserModel.ID); Assert.AreEqual($"UPDATE {UserModel.TableName()} SET usrUID = 'Testert1', usrFirstName = 'Test', usrLastName = 'Tester', usrEmailAddress = '*****@*****.**' WHERE usrID = 1", UserUpdateStatement); }
public void ReturnTrueIfUpdateFieldsAreCorrect() { UserModel UserModel = new UserModel() { ID = 1, UID = "Testert1", FirstName = "Test", LastName = "Tester", EmailAddress = "*****@*****.**" }; string UserUpdateFields = MySQLDBStateless.GenerateUpdateFields(UserModel); Assert.AreEqual("usrUID = 'Testert1', usrFirstName = 'Test', usrLastName = 'Tester', usrEmailAddress = '*****@*****.**'", UserUpdateFields); Assert.AreEqual($"UPDATE {UserModel.TableName()} SET usrUID = 'Testert1', usrFirstName = 'Test', usrLastName = 'Tester', usrEmailAddress = '*****@*****.**' WHERE usrID = 1", $"UPDATE {UserModel.TableName()} SET {UserUpdateFields} WHERE usrID = 1"); }
public void ReturnTrueIfModelValuesAreCorrect() { UserModel UserModel = new UserModel() { ID = 1, UID = "Testert1", FirstName = "Test", LastName = "Tester", EmailAddress = "*****@*****.**" }; List <object> UserModelFields = MySQLDBStateless.ModelFieldValues(UserModel); StringBuilder StringBuilder = new StringBuilder(); foreach (object userModelField in UserModelFields) { StringBuilder.Append(StringBuilder.Length == 0 ? $"{userModelField}" : $", {userModelField}"); } Assert.AreEqual("1, 'Testert1', 'Test', 'Tester', '*****@*****.**'", StringBuilder.ToString()); }
private object GetDatabaseTableFieldName(DataRow dataRow, string fieldName) => dataRow[MySQLDBStateless.GetDatabaseTableFieldName(this, fieldName)];
public UserModel(int id) : base(MySqlConnectionString.ConnectionString) { DataTable DataTable = _MySQLDBStateless.ExecDataTable($"SELECT * FROM {this.TableName()} WHERE {MySQLDBStateless.GetDatabaseTableFieldName(this, nameof(this.ID))} = {MySQLDBCommon.SetValueForSql(id)}"); if (DataTable.Rows.Count == 1) { LoadByUserModelDataRow(DataTable.Rows[0]); } }
public void Delete() { _MySQLDBStateless.ExecNonQuery(MySQLDBStateless.GenerateStandardDeleteStatement(this, nameof(this.ID), this.ID)); }
private void Update() { _MySQLDBStateless.ExecNonQuery(MySQLDBStateless.GenerateStandardUpdateStatement(this, nameof(this.ID), this.ID)); }
private void Insert() { this.ID = (int)_MySQLDBStateless.ExecInsertNonQueryReturnID(MySQLDBStateless.GenerateStandardInsertStatement(this)); }