public void CreateViewMappings()
{
Directory.CreateDirectory(Path.Combine(RootDirectory, DatabaseName.FixSpecialCharacters(), "Views"));
var noViewsCreated = true;
var query = $"SELECT TABLE_NAME FROM [{DatabaseName}].information_schema.views";
using (var db = new ADODatabaseContext(ConnectionString))
{
var reader = db.ReadQuery(query);
while (reader.Read())
{
if (_token.IsCancellationRequested)
{
return;
}
// generate any new view mappings
CreateView(reader["TABLE_NAME"].ToString());
noViewsCreated = false;
}
}
if (noViewsCreated)
{
UpdateProjectFileList("Views", "");
}
}
public void CreateStoredProcedureMappings()
{
Directory.CreateDirectory(Path.Combine(RootDirectory, DatabaseName.FixSpecialCharacters(), "StoredProcedures"));
var noStoredProceduresCreated = true;
var query = $"SELECT ROUTINE_NAME, ROUTINE_SCHEMA FROM [{DatabaseName}].information_schema.routines WHERE routine_type = 'PROCEDURE'";
using (var db = new ADODatabaseContext(ConnectionString))
{
var reader = db.ReadQuery(query);
while (reader.Read())
{
if (_token.IsCancellationRequested)
{
return;
}
// generate any new stored procedure mappings
CreateStoredProcedure(reader["ROUTINE_NAME"].ToString(), reader["ROUTINE_SCHEMA"].ToString());
noStoredProceduresCreated = false;
}
}
if (noStoredProceduresCreated)
{
UpdateProjectFileList("StoredProcedures", "");
}
}
private void UpdateProjectFileList(string tableSpView, string name)
{
// delete any existing table mappings first (in case a table was deleted)
var foundIndex = _deletedFiles.IndexOf(Path.Combine(RootDirectory, DatabaseName.FixSpecialCharacters(), tableSpView, name + ".cs"));
if (foundIndex > -1)
{
_deletedFiles.RemoveAt(foundIndex);
}
}
public void CreateFunction(string functionName, string schemaName)
{
using (var file = new StreamWriter(Path.Combine(RootDirectory, DatabaseName.FixSpecialCharacters(), "Functions", functionName + $"_{schemaName}.cs")))
{
var functionMappings = new FunctionMappings(ConnectionString, DatabaseName, functionName, schemaName);
file.Write(functionMappings.EmitCode());
}
TotalCompleted++;
}
public void CreateView(string viewName)
{
using (var file = new StreamWriter(Path.Combine(RootDirectory, DatabaseName.FixSpecialCharacters(), "Views", viewName + ".cs")))
{
var viewMappings = new ViewMappings(ConnectionString, DatabaseName, viewName);
file.Write(viewMappings.EmitCode());
}
UpdateProjectFileList("Views", viewName);
TotalCompleted++;
}
public void CreateStoredProcedure(string storedProcedureName, string schemaName)
{
using (var file = new StreamWriter(Path.Combine(RootDirectory, DatabaseName.FixSpecialCharacters(), "StoredProcedures", storedProcedureName + $"_{schemaName}.cs")))
{
var storedProcedureMappings = new StoredProcedureMappings(ConnectionString, DatabaseName, storedProcedureName, schemaName);
file.Write(storedProcedureMappings.EmitCode());
}
UpdateProjectFileList("StoredProcedures", storedProcedureName);
TotalCompleted++;
}
public void CreateConstraintMappings()
{
Directory.CreateDirectory(Path.Combine(RootDirectory, DatabaseName.FixSpecialCharacters(), "Constraints"));
var constraintMappings = new ConstraintMappings(ConnectionString, DatabaseName);
var @out = new StringBuilder();
var firstTime = true;
using (var db = new ADODatabaseContext(ConnectionString.Replace("master", DatabaseName)))
{
var reader = db.ReadQuery(constraintMappings.ConstraintMappingQueryString);
while (reader.Read())
{
var pkTableName = reader["PKTABLE_NAME"].ToString();
var pkColumnName = reader["PKCOLUMN_NAME"].ToString();
var fkTableName = reader["FKTABLE_NAME"].ToString();
var fkColumnName = reader["FKCOLUMN_NAME"].ToString();
var schemaName = reader["PKTABLE_OWNER"].ToString();
if (!firstTime)
{
@out.AppendLine(",");
}
firstTime = false;
@out.Append("\t\t\tnew ConstraintDefinition { DatabaseName=\"" + DatabaseName + "\", PkTable = \"" + pkTableName + "\", PkField = \"" + pkColumnName + "\", FkTable = \"" + fkTableName + "\", FkField = \"" + fkColumnName + "\", SchemaName = \"" + schemaName + "\" }");
TotalCompleted++;
}
if (!firstTime)
{
@out.AppendLine("");
}
}
var result = constraintMappings.EmitCode(@out.ToString());
using (var file = new StreamWriter(Path.Combine(RootDirectory, DatabaseName.FixSpecialCharacters(), "Constraints", DatabaseName.FixSpecialCharacters() + "Constraints.cs")))
{
file.Write(result);
}
//UpdateProjectFileList("Constraints", DatabaseName + "Constraints");
}
private void CreateFunctionMappings()
{
Directory.CreateDirectory(Path.Combine(RootDirectory, DatabaseName.FixSpecialCharacters(), "Functions"));
var query = $"SELECT ROUTINE_NAME,routine_schema FROM [{DatabaseName}].information_schema.routines WHERE routine_type = 'FUNCTION'";
using (var db = new ADODatabaseContext(ConnectionString))
{
var reader = db.ReadQuery(query);
while (reader.Read())
{
if (_token.IsCancellationRequested)
{
return;
}
// generate any new stored procedure mappings
CreateFunction(reader["ROUTINE_NAME"].ToString(), reader["ROUTINE_SCHEMA"].ToString());
}
}
}
private void CreateTableGeneratorMappings()
{
Directory.CreateDirectory(Path.Combine(RootDirectory, DatabaseName.FixSpecialCharacters(), "TableGeneratorCode"));
var tableDefinitionString = new StringBuilder();
var tableGeneratorMappings = new TableGeneratorMappings(ConnectionString, DatabaseName, _token);
var query = $"SELECT * FROM [{DatabaseName}].INFORMATION_SCHEMA.tables ORDER BY TABLE_SCHEMA,TABLE_NAME";
using (var db = new ADODatabaseContext(ConnectionString))
{
var reader = db.ReadQuery(query);
while (reader.Read())
{
if (_token.IsCancellationRequested)
{
return;
}
tableDefinitionString.Append("\t\t\tnew TableDefinition {");
tableDefinitionString.Append(tableGeneratorMappings.EmitTableGenerateCode(reader["TABLE_NAME"].ToString(), reader["TABLE_SCHEMA"].ToString()));
tableDefinitionString.AppendLine("},");
TotalCompleted++;
}
}
var result = tableGeneratorMappings.EmitCode(tableDefinitionString.ToString());
using (var file = new StreamWriter(Path.Combine(RootDirectory, DatabaseName.FixSpecialCharacters(), "TableGeneratorCode", DatabaseName.FixSpecialCharacters() + "TableGeneratorCode.cs")))
{
file.Write(result);
}
UpdateProjectFileList("TableGeneratorCode", DatabaseName + "TableGeneratorCode");
}
private void Setup()
{
// scan for all the files that currently exist and insert them into DeleteFiles
DirSearch(Path.Combine(RootDirectory, DatabaseName.FixSpecialCharacters()));
}