public void GetDatabaseAndDatasource()
{
AjBaseConnection connection = new AjBaseConnection("Database=MyEnterprise;Data Source=MyDataSource");
Assert.AreEqual("MyEnterprise", connection.Database);
Assert.AreEqual("MyDataSource", connection.DataSource);
}
public void ExecuteCreateCommand()
{
int initial = this.table.GetRows().Count;
AjBaseConnection connection = new AjBaseConnection("Database=Sales");
AjBaseCommand command = new AjBaseCommand("create table Customers(Name, Address)", connection);
connection.Open();
// TODO test return
command.ExecuteNonQuery();
connection.Close();
Table table = this.database.GetTable("Customers");
Assert.IsNotNull(table);
}
public void OpenAndCloseExistingDatabase()
{
Engine engine = new Engine();
engine.CreateDatabase("MyEnterprise");
Engine.Current = engine;
AjBaseConnection connection = new AjBaseConnection("Database=MyEnterprise");
connection.Open();
Assert.AreEqual(ConnectionState.Open, connection.State);
connection.Close();
Assert.AreEqual(ConnectionState.Closed, connection.State);
}
public void CreateDatabaseDatabase()
{
Engine engine = new Engine();
Engine.Current = engine;
AjBaseConnection connection = new AjBaseConnection("Database=MyEnterprise;CreateIfNotExists=true");
connection.Open();
Assert.AreEqual(ConnectionState.Open, connection.State);
connection.Close();
Assert.AreEqual(ConnectionState.Closed, connection.State);
Assert.IsNotNull(engine.GetDatabase("MyEnterprise"));
}
public void ExecuteInsertCommand()
{
int initial = this.table.GetRows().Count;
AjBaseConnection connection = new AjBaseConnection("Database=Sales");
AjBaseCommand command = new AjBaseCommand("insert into Employees(FirstName, LastName) values('New First Name', 'New Last Name')", connection);
connection.Open();
int n = command.ExecuteNonQuery();
connection.Close();
Assert.AreEqual(1, n);
Assert.AreEqual(initial + 1, this.table.GetRows().Count());
Row row = this.table.GetRows().Last();
Assert.AreEqual("New First Name", row["FirstName"]);
Assert.AreEqual("New Last Name", row["LastName"]);
}
public AjBaseCommand(string commandText, AjBaseConnection connection)
{
this.commandText = commandText;
this.connection = connection;
}
public AjBaseCommand(string commandText, AjBaseConnection connection)
{
this.commandText = commandText;
this.connection = connection;
}
public void RaiseIfConnectionStringIsEmpty()
{
AjBaseConnection connection = new AjBaseConnection("");
Assert.AreEqual("MyEnterprise", connection.Database);
}
public void GetNullDatasourceIfNotDefined()
{
AjBaseConnection connection = new AjBaseConnection("Database=MyEnterprise");
Assert.IsNull(connection.DataSource);
}
public void GetDatasource()
{
AjBaseConnection connection = new AjBaseConnection("Data Source=MyDataSource");
Assert.AreEqual("MyDataSource", connection.DataSource);
}
public void GetDatabase()
{
AjBaseConnection connection = new AjBaseConnection("Database=MyEnterprise");
Assert.AreEqual("MyEnterprise", connection.Database);
}
public void CreateWithConnectionString()
{
AjBaseConnection connection = new AjBaseConnection("Database=MyEnterprise");
Assert.AreEqual("Database=MyEnterprise", connection.ConnectionString);
}
public void SetConnectionString()
{
AjBaseConnection connection = new AjBaseConnection();
connection.ConnectionString = "Database=MyEnterprise";
Assert.AreEqual("Database=MyEnterprise", connection.ConnectionString);
}
public void RaiseIfDatabaseDoesNotExistWhenOpen()
{
AjBaseConnection connection = new AjBaseConnection("Database=MyEnterprise");
connection.Open();
}
public void RaiseIfDatabaseDefinedTwice()
{
AjBaseConnection connection = new AjBaseConnection("Database=MyEnterprise;Database=OtherEnterprise");
Assert.AreEqual("MyEnterprise", connection.Database);
}