public void GenerateInsertQuery_NoPrimaryKey_Valid() { // Arrange var generator = new MySqlQueryGenerator <HeapEntity>("Users"); // Act var insertQuery = generator.GenerateInsertQuery(new HeapEntity()); // Assert Assert.Equal(@"INSERT INTO Users (Username, Password) VALUES (@Username, @Password); SELECT Users.Username, Users.Password FROM Users WHERE Users.Username = @Username AND Users.Password = @Password;", insertQuery); }
public void GenerateInsertQuery_CustomColumnNames_Valid() { // Arrange var generator = new MySqlQueryGenerator <CustomColumnNamesEntity>("Orders"); // Act var insertQuery = generator.GenerateInsertQuery(new CustomColumnNamesEntity()); // Assert Assert.Equal(@"INSERT INTO Orders (DateCreated) VALUES (@Date); SELECT Orders.OrderId AS Id, Orders.DateCreated AS Date FROM Orders WHERE Orders.OrderId = LAST_INSERT_ID();", insertQuery); }
public void GenerateInsertQuery_MissingColumnValue_ContainsColumn() { // Arrange var generator = new MySqlQueryGenerator <CompositePrimaryKeyEntity>("Users"); // Act var insertQuery = generator.GenerateInsertQuery(new CompositePrimaryKeyEntity()); // Assert Assert.Equal(@"INSERT INTO Users (Username, Password, DateCreated) VALUES (@Username, @Password, @DateCreated); SELECT Users.Username, Users.Password, Users.DateCreated FROM Users WHERE Users.Username = @Username AND Users.Password = @Password;", insertQuery); }
public void GenerateInsertQuery_IdentityValuePrimaryKey_Valid() { // Arrange var generator = new MySqlQueryGenerator <SinglePrimaryKeyEntity>("Users"); // Act var insertQuery = generator.GenerateInsertQuery(new SinglePrimaryKeyEntity()); // Assert Assert.Equal(@"INSERT INTO Users (Username, Password) VALUES (@Username, @Password); SELECT Users.Id, Users.Username, Users.Password FROM Users WHERE Users.Id = LAST_INSERT_ID();", insertQuery); }
public void GenerateInsertQuery_ColumnHasDefaultConstraintAndDefaultValue_Valid() { // Arrange var generator = new MySqlQueryGenerator <HasDefaultConstraintEntity>("Users"); // Actj var query = generator.GenerateInsertQuery(new HasDefaultConstraintEntity()); // Assert Assert.Equal(@"INSERT INTO Users (Id) VALUES (@Id); SELECT Users.Id, Users.DateCreated FROM Users WHERE Users.Id = @Id;", query); }
public void GenerateInsertQuery_ColumnHasDefaultConstraintAndNonDefaultValue_Valid() { // Arrange var generator = new MySqlQueryGenerator <HasDefaultConstraintEntity>("Users"); var record = new HasDefaultConstraintEntity { Id = 42, DateCreated = DateTime.Now }; // Act var query = generator.GenerateInsertQuery(record); // Assert Assert.Equal(@"INSERT INTO Users (Id, DateCreated) VALUES (@Id, @DateCreated); SELECT Users.Id, Users.DateCreated FROM Users WHERE Users.Id = @Id;", query); }