static void Main(string[] args)
{
var ef = new EfHelper();
//ef.GetCustomers();
ef.GetCustomers2();
Console.ReadLine();
}
private void ResetDatabase()
{
if (_manager.Exists(DB))
{
_manager.ClearDatabase(DB);
}
else
{
_manager.CreateDatabase(DB, EfHelper.GetSchema(), null);
}
}
public Task Run()
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("SEED DATABASE\n");
Console.ResetColor();
Console.WriteLine(
$"Input: {_database}\n" +
$"Count: {_count}\n" +
$"Entities: {_entities ?? "all"}");
// create database if not exists
string connection = string.Format(CultureInfo.InvariantCulture,
_config.GetConnectionString("Default"),
_database);
MySqlDbManager manager = new MySqlDbManager(connection);
if (!manager.Exists(_database))
{
Console.WriteLine("Creating database...");
Serilog.Log.Information($"Creating database {_database}...");
manager.CreateDatabase(_database, EfHelper.GetSchema(), null);
Console.WriteLine("Database created.");
Serilog.Log.Information("Database created.");
}
Console.Write("Seeding...");
IBiblioRepository repository =
new EfBiblioRepository(connection, "mysql");
BiblioSeeder seeder = new BiblioSeeder(repository);
seeder.Seed(_count, _entities);
Console.WriteLine(" completed");
return(Task.CompletedTask);
}
private static async Task CreateBiblioAsync(IServiceProvider serviceProvider)
{
await Policy.Handle <DbException>()
.WaitAndRetry(new[]
{
TimeSpan.FromSeconds(10),
TimeSpan.FromSeconds(30),
TimeSpan.FromSeconds(60)
}, (exception, timeSpan, _) =>
{
// in case of DbException we must retry
ILogger logger = serviceProvider
.GetService <ILoggerFactory>()
.CreateLogger(typeof(BiblioHostSeedExtensions));
string message = "Unable to connect to DB" +
$" (sleep {timeSpan}): {exception.Message}";
Console.WriteLine(message);
logger.LogError(exception, message);
}).Execute(async() =>
{
IConfiguration config =
serviceProvider.GetService <IConfiguration>();
ILogger logger = serviceProvider
.GetService <ILoggerFactory>()
.CreateLogger(typeof(BiblioHostSeedExtensions));
// delay if requested, to allow DB start
int delay = config.GetValue <int>("Seed:BiblioDelay");
if (delay > 0)
{
Console.WriteLine($"Waiting for {delay} seconds...");
Thread.Sleep(delay * 1000);
}
else
{
Console.WriteLine("No delay for seeding");
}
// if the DB does not exist, create and seed it
string dbName = config.GetValue <string>("DatabaseNames:Biblio");
string cs = string.Format(
CultureInfo.InvariantCulture,
config.GetConnectionString("Biblio"),
dbName);
Console.WriteLine($"Checking for database {dbName}...");
Serilog.Log.Information($"Checking for database {dbName}...");
MySqlDbManager manager = new MySqlDbManager(cs);
if (!manager.Exists(dbName))
{
// create
Console.WriteLine("Creating database...");
Serilog.Log.Information($"Creating database {dbName}...");
manager.CreateDatabase(dbName, EfHelper.GetSchema(), null);
Console.WriteLine("Database created.");
Serilog.Log.Information("Database created.");
// seed
Console.WriteLine("Seeding database...");
Serilog.Log.Information("Seeding database...");
await SeedBiblioAsync(serviceProvider);
Console.WriteLine("Seeding completed.");
Serilog.Log.Information("Seeding completed.");
}
});
}
public static void Migrate(string target, bool isDowngrade)
{
EfHelper.Migrate(target, isDowngrade);
}
public static Tuple <IEnumerable <string>, IEnumerable <string>, IEnumerable <string> > GetMigrationsInfo()
{
return(EfHelper.GetMigrationsInfo());
}
/// <summary> /// 查询角色； /// </summary> /// <param name="roleName">角色名称</param> /// <returns>角色</returns> public Role Select(string roleName) => EfHelper.SelectOne <Role>(r => r.Name == roleName);
