public void CreateStoredProcedures()
{
foreach (var sp in DatabaseDefinition.StoredProcedures)
{
var sql = Executer.Generator.CreateStoredProcedure(sp);
Executer.ExecuteNonQuery(sql);
}
}
public void CreateIndexes(SqlTable table)
{
var sql = Executer.Generator.CreateIndexes(table);
if (!string.IsNullOrEmpty(sql))
{
Executer.ExecuteNonQuery(sql);
}
}
public void CreateUniqueConstraints(SqlTable table)
{
var sql = Executer.Generator.CreateUniqueConstrainsts(table);
if (!string.IsNullOrEmpty(sql))
{
Executer.ExecuteNonQuery(sql);
}
}
public void DropAllSchemas()
{
var schemaNames = DatabaseDefinition
.GetSchemaNames()
.ToList();
var sql = Executer.Generator.DropSchemas(schemaNames);
Executer.ExecuteNonQuery(sql);
}
private void CreateSchemas(DatabaseDefinition databaseDefinition)
{
foreach (var schemaName in databaseDefinition.GetSchemaNames())
{
if (schemaName == Executer.Generator.Context.Settings.SqlVersionSpecificSettings.GetAs <string>("DefaultSchema", null))
{
continue;
}
var sql = Executer.Generator.CreateSchema(schemaName);
Executer.ExecuteNonQuery(sql);
}
}
public void deleteById(int id)
{
try
{
string query = "DELETE FROM person WHERE ID=@Id";
MySqlParameter[] parameters = { new MySqlParameter("@Id", id) };
Executer.ExecuteNonQuery(query, parameters);
}
catch (Exception)
{
throw;
}
}
public void create(Person entity)
{
try
{
string query = "INSERT @Name INTO person";
MySqlParameter[] parameters = { new MySqlParameter("@Name", entity.Name) };
Executer.ExecuteNonQuery(query, parameters);
}
catch (Exception)
{
throw;
}
}
public void update(Person entity)
{
try
{
string query = "UPDATE person SET Name=@Name WHERE ID=@Id";
MySqlParameter[] parameters = { new MySqlParameter("@Name", entity.Name), new MySqlParameter("@Id", entity.Id) };
Executer.ExecuteNonQuery(query, parameters);
}
catch (Exception)
{
throw;
}
}
public void CreateDbDescriptions(SqlTable table)
{
var sqlStatementWithParameters = Executer.Generator.CreateDbTableDescription(table);
if (sqlStatementWithParameters != null)
{
Executer.ExecuteNonQuery(sqlStatementWithParameters);
}
foreach (var column in table.Columns)
{
sqlStatementWithParameters = Executer.Generator.CreateDbColumnDescription(column);
if (sqlStatementWithParameters != null)
{
Executer.ExecuteNonQuery(sqlStatementWithParameters);
}
}
}
public void NewTable(TableNew tableNew)
{
var sql = MigrationGenerator.CreateTable(tableNew);
Executer.ExecuteNonQuery(sql);
}
public void NewForeignKey(ForeignKeyNew foreignKeyNew)
{
var sql = MigrationGenerator.Generator.CreateForeignKey(foreignKeyNew.ForeignKey);
Executer.ExecuteNonQuery(sql);
}
public void NewPrimaryKey(PrimaryKeyNew primaryKeyNew)
{
var sql = MigrationGenerator.CreatePrimaryKey(primaryKeyNew);
Executer.ExecuteNonQuery(sql);
}
public void ChangeColumns(params ColumnChange[] columnChanges)
{
var sql = MigrationGenerator.ChangeColumns(columnChanges);
Executer.ExecuteNonQuery(sql);
}
public void CreateColumns(params ColumnNew[] columnNews)
{
var sql = MigrationGenerator.CreateColumns(columnNews);
Executer.ExecuteNonQuery(sql);
}
public void DeleteColumns(params ColumnDelete[] columnDeletes)
{
var sql = MigrationGenerator.DropColumns(columnDeletes);
Executer.ExecuteNonQuery(sql);
}
public void DeleteTable(TableDelete tableDelete)
{
var sql = MigrationGenerator.DropTable(tableDelete);
Executer.ExecuteNonQuery(sql);
}
public void DropAllForeignKeys()
{
var sql = Executer.Generator.DropAllForeignKeys();
Executer.ExecuteNonQuery(sql);
}
public void CreateTable(SqlTable table)
{
var sql = Executer.Generator.CreateTable(table);
Executer.ExecuteNonQuery(sql);
}
public void DropAllTables()
{
var sql = Executer.Generator.DropAllTables();
Executer.ExecuteNonQuery(sql);
}
