public void SetSettings(string database, string connectionStringName, string dbContextName, TemplateType templateType, GeneratorType generatorType, ForeignKeyNamingStrategy foreignKeyNamingStrategy)
{
var factory = DbProviderFactories.GetFactory("Npgsql");
Assert.IsNotNull(factory);
var builder = new DbConnectionStringBuilder
{
["Server"] = "localhost",
["Port"] = "5432",
["Database"] = database.ToLower(),
["User Id"] = "testuser",
["Password"] = "******"
};
Settings.ForeignKeyNamingStrategy = foreignKeyNamingStrategy;
Settings.TemplateType = templateType;
Settings.GeneratorType = generatorType;
Settings.ConnectionString = builder.ConnectionString;
Settings.DatabaseType = DatabaseType.PostgreSQL;
Settings.ConnectionStringName = connectionStringName;
Settings.DbContextName = dbContextName;
Settings.GenerateSingleDbContext = true;
Settings.MultiContextSettingsPlugin = null;
Settings.Enumerations = null;
Settings.PrependSchemaName = true;
Settings.DisableGeographyTypes = false;
Settings.AddUnitTestingDbContext = true;
FilterSettings.Reset();
FilterSettings.AddDefaults();
FilterSettings.CheckSettings();
}
public void SetUp()
{
FilterSettings.Reset();
FilterSettings.AddDefaults();
FilterSettings.CheckSettings();
_sut = new TestContextFilter();
}
public void SetSettings(string database, string connectionStringName, string dbContextName, TemplateType templateType, GeneratorType generatorType, ForeignKeyNamingStrategy foreignKeyNamingStrategy)
{
var fi = new FileInfo(database);
var builder = new DbConnectionStringBuilder
{
["Data Source"] = fi.FullName
};
Settings.ForeignKeyNamingStrategy = foreignKeyNamingStrategy;
Settings.TemplateType = templateType;
Settings.GeneratorType = generatorType;
Settings.ConnectionString = builder.ConnectionString;
Settings.DatabaseType = DatabaseType.SqlCe;
Settings.ConnectionStringName = connectionStringName;
Settings.DbContextName = dbContextName;
Settings.GenerateSingleDbContext = true;
Settings.MultiContextSettingsPlugin = null;
Settings.Enumerations = null;
Settings.PrependSchemaName = true;
Settings.DisableGeographyTypes = false;
Settings.AddUnitTestingDbContext = true;
FilterSettings.Reset();
FilterSettings.AddDefaults();
FilterSettings.CheckSettings();
}
public void SetupPostgreSQL(string database, string connectionStringName, string dbContextName, TemplateType templateType, GeneratorType generatorType)
{
Settings.TemplateType = templateType;
Settings.GeneratorType = generatorType;
Settings.ConnectionString = $"Server=127.0.0.1;Port=5432;Database={database};User Id=testuser;Password=testtesttest;";
Settings.DatabaseType = DatabaseType.PostgreSQL;
Settings.ConnectionStringName = connectionStringName;
Settings.DbContextName = dbContextName;
Settings.GenerateSingleDbContext = true;
Settings.MultiContextSettingsPlugin = null;
Settings.Enumerations = null;
Settings.PrependSchemaName = true;
Settings.DisableGeographyTypes = false;
Settings.AddUnitTestingDbContext = true;
FilterSettings.Reset();
FilterSettings.AddDefaults();
FilterSettings.CheckSettings();
}
public void SetupSqlCe(string database, string connectionStringName, string dbContextName, TemplateType templateType, GeneratorType generatorType)
{
Settings.TemplateType = templateType;
Settings.GeneratorType = generatorType;
Settings.ConnectionString = @"Data Source=C:\S\Source (open source)\EntityFramework Reverse POCO Code Generator\EntityFramework.Reverse.POCO.Generator\App_Data\" + database;
Settings.DatabaseType = DatabaseType.SqlCe;
Settings.ConnectionStringName = connectionStringName;
Settings.DbContextName = dbContextName;
Settings.GenerateSingleDbContext = true;
Settings.MultiContextSettingsPlugin = null;
Settings.Enumerations = null;
Settings.PrependSchemaName = true;
Settings.DisableGeographyTypes = false;
Settings.AddUnitTestingDbContext = true;
FilterSettings.Reset();
FilterSettings.AddDefaults();
FilterSettings.CheckSettings();
}
public void SetupSqlServer(string database, string connectionStringName, string dbContextName, TemplateType templateType, GeneratorType generatorType)
{
Settings.TemplateType = templateType;
Settings.GeneratorType = generatorType;
Settings.ConnectionString = $"Data Source=(local);Initial Catalog={database};Integrated Security=True;Application Name=Generator";
Settings.DatabaseType = DatabaseType.SqlServer;
Settings.ConnectionStringName = connectionStringName;
Settings.DbContextName = dbContextName;
Settings.GenerateSingleDbContext = true;
Settings.MultiContextSettingsPlugin = null;
Settings.Enumerations = null;
Settings.PrependSchemaName = true;
Settings.DisableGeographyTypes = false;
Settings.AddUnitTestingDbContext = true;
FilterSettings.Reset();
FilterSettings.AddDefaults();
FilterSettings.CheckSettings();
}
public void SetSettings(string database, string connectionStringName, string dbContextName, TemplateType templateType, GeneratorType generatorType, ForeignKeyNamingStrategy foreignKeyNamingStrategy)
{
connectionStringName ??= "Default";
Settings.ForeignKeyNamingStrategy = foreignKeyNamingStrategy;
Settings.TemplateType = templateType;
Settings.GeneratorType = generatorType;
Settings.ConnectionString = ConfigurationExtensions.GetConnectionString(connectionStringName, database);
Settings.DatabaseType = DatabaseType.SqlServer;
Settings.ConnectionStringName = connectionStringName;
Settings.DbContextName = dbContextName;
Settings.GenerateSingleDbContext = true;
Settings.MultiContextSettingsPlugin = null;
Settings.Enumerations = null;
Settings.PrependSchemaName = true;
Settings.DisableGeographyTypes = false;
Settings.AddUnitTestingDbContext = true;
FilterSettings.Reset();
FilterSettings.AddDefaults();
FilterSettings.CheckSettings();
}
protected static void ResetFilters()
{
FilterSettings.Reset();
FilterSettings.AddDefaults();
FilterSettings.CheckSettings();
}
public void Run(string filename, string singleDbContextSubNamespace, Type fileManagerType, string subFolder)
{
Inflector.PluralisationService = new EnglishPluralizationService();
Settings.GenerateSingleDbContext = true;
FilterSettings.Reset();
FilterSettings.AddDefaults();
FilterSettings.CheckSettings();
var path = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
if (!string.IsNullOrEmpty(subFolder))
{
path = Path.Combine(path, subFolder);
}
Settings.Root = path;
var fullPath = Path.Combine(path, $"{filename}_{Settings.DatabaseType}_{Settings.TemplateType}.cs");
// Delete old generated files
if (File.Exists(fullPath))
{
File.Delete(fullPath);
}
if (!string.IsNullOrEmpty(subFolder))
{
foreach (var old in Directory.GetFiles(Settings.Root))
{
File.Delete(old);
}
}
var outer = new GeneratedTextTransformation();
var fileManagement = new FileManagementService(outer);
var generator = GeneratorFactory.Create(fileManagement, fileManagerType, singleDbContextSubNamespace);
// Turn on everything for testing
foreach (var filter in generator.FilterList.GetFilters())
{
filter.Value.IncludeViews = true;
filter.Value.IncludeSynonyms = true;
filter.Value.IncludeStoredProcedures = true;
filter.Value.IncludeTableValuedFunctions = true;
filter.Value.IncludeScalarValuedFunctions = true;
}
var stopwatch = new Stopwatch();
var stopwatchGenerator = new Stopwatch();
stopwatch.Start();
generator.ReadDatabase();
stopwatchGenerator.Start();
generator.GenerateCode();
stopwatchGenerator.Stop();
stopwatch.Stop();
Console.WriteLine("Duration: {0:F1} seconds, Generator {1:F1} seconds", stopwatch.ElapsedMilliseconds / 1000.0, stopwatchGenerator.ElapsedMilliseconds / 1000.0);
Console.WriteLine($"Writing to {fullPath}");
Console.WriteLine();
if (outer.FileData.Length > 0)
{
using (var sw = new StreamWriter(fullPath))
{
sw.Write(outer.FileData.ToString());
}
}
fileManagement.Process(true);
}
public void OneTimeSetUp()
{
FilterSettings.Reset();
FilterSettings.AddDefaults();
FilterSettings.CheckSettings();
}
