in src/Modules/SimplCommerce.Module.SampleData/Services/SampleDataService.cs [22:39]
public async Task ResetToSampleData(SampleDataOption model)
{
var usePostgres = _sqlRepository.GetDbConnectionType() == "Npgsql.NpgsqlConnection";
var useSQLite = _sqlRepository.GetDbConnectionType() == "Microsoft.Data.Sqlite.SqliteConnection";
var useMySql = _sqlRepository.GetDbConnectionType().Contains("MySql", System.StringComparison.InvariantCultureIgnoreCase);
var sampleContentFolder = Path.Combine(GlobalConfiguration.ContentRootPath, "Modules", "SimplCommerce.Module.SampleData", "SampleContent", model.Industry);
var filePath =
usePostgres ? Path.Combine(sampleContentFolder, "ResetToSampleData_Postgres.sql") :
useSQLite ? Path.Combine(sampleContentFolder, "ResetToSampleData_SQLite.sql") :
useMySql ? Path.Combine(sampleContentFolder, "ResetToSampleData_MySql.sql") :
Path.Combine(sampleContentFolder, "ResetToSampleData.sql");
var lines = File.ReadLines(filePath);
var commands = usePostgres || useSQLite || useMySql ? _sqlRepository.PostgresCommands(lines) : _sqlRepository.ParseCommand(lines);
_sqlRepository.RunCommands(commands);
await CopyImages(sampleContentFolder);
}