public void Dispose()
{
using (var context = new PostgreSqlContext(_options, LoggerFactory))
{
context.Database.EnsureDeleted();
}
}
public BaseDbTestCase()
{
var config = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json")
.Build();
if (config == null)
{
throw new Exception("File config not found");
}
_options = new DbContextOptionsBuilder <PostgreSqlContext>()
.UseNpgsql(
config.GetConnectionString("PostgreSqlConnection"),
b => b.MigrationsAssembly(typeof(Startup).Assembly.GetName().Name)
)
.Options;
LoggerFactory = new LoggerFactory();
Context = new PostgreSqlContext(_options, LoggerFactory);
Context.Database.Migrate();
var logger = LoggerFactory.CreateLogger <BaseDbTestCase>();
Logger = logger;
Registry = Context.Db;
}
//TODO Transactional?
public static void Initialize(IServiceProvider services)
{
using (var context = new PostgreSqlContext(
services.GetRequiredService <
DbContextOptions <PostgreSqlContext> >()))
{
// Get a logger
var logger = services.GetRequiredService <ILogger <DbInitializer> >();
IDataAccessProvider dbProvider = services.GetRequiredService <IDataAccessProvider>();
if (context.monkeys.Any())
{
logger.LogInformation("DB not empty");
return;
}
logger.LogInformation("Start seeding DB...");
string MonkeyJson = File.ReadAllText("monkeycollection.json");
var options = new JsonSerializerOptions {
AllowTrailingCommas = true,
PropertyNameCaseInsensitive = true
};
options.Converters.Add(new JsonDateTimeConverter());
List <Monkey> MonkeyList = JsonSerializer.Deserialize <List <Monkey> >(MonkeyJson, options);
MonkeyList.ForEach((monkey) => dbProvider.AddMonkeyRecord(monkey));
logger.LogInformation("Finished seeding DB.");
}
}
public ProductModel GetProduct(Guid id)
{
using (var context = new PostgreSqlContext())
{
var test = context.Product.Where(x => x.Id == id).FirstOrDefault();
return(context.Product.Where(x => x.Id == id).FirstOrDefault());
}
}
public IEnumerable <ProductModel> GetProducts()
{
using (var context = new PostgreSqlContext())
{
var test = context.Product.ToListAsync().Result;
return(context.Product.ToListAsync().Result);
}
}
public ScraperThread(
PostgreSqlContext context,
EntityManager entityManager
)
{
_context = context;
_entityManager = entityManager;
}
public HomeController(IHubContext <LoggerHub> hub,
PostgreSqlContext postgreSqlContext,
MongoDbContext mongoDbContext)
{
_hub = hub;
_postgreSqlContext = postgreSqlContext;
_mongoDbContext = mongoDbContext;
}
public WikipediaCsNounProposeStrategy(
PostgreSqlContext context,
EntityManager entityManager
)
{
_context = context;
_entityManager = entityManager;
}
public BasicAuthenticationHandler(
IOptionsMonitor <AuthenticationSchemeOptions> options,
ILoggerFactory logger,
UrlEncoder encoder,
ISystemClock clock,
PostgreSqlContext context) : base(options, logger, encoder, clock)
{
_context = context;
}
public ProductModel InserProduct(ProductModel product)
{
using (var context = new PostgreSqlContext())
{
context.Product.Add(product);
context.SaveChanges();
return(product);
}
}
public TodoController(UserManager <AppUser> userManager,
PostgreSqlContext context,
IMapper mapper,
ILogger <TodoController> logger)
{
_userManager = userManager;
_context = context;
_mapper = mapper;
_logger = logger;
}
public CrawlerThread(
ILogger logger,
SimpleDownloadStrategy downloadStrategy,
PostgreSqlContext context,
EntityManager entityManager
)
{
_logger = logger;
_downloadStrategy = downloadStrategy;
_context = context;
_entityManager = entityManager;
_waitingWebsites = context.CrawlerWebsites.Where(website => !website.Crawled);
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.AddControllers();
services.AddSwaggerGen(options =>
{
options.SwaggerDoc("v2", new Microsoft.OpenApi.Models.OpenApiInfo
{
Title = "Place Info Service API",
Version = "v2",
Description = "Sample service for Learner",
});
});
// services.AddDbContext<PostgreSqlContext>(options =>
// options.UseNpgsql(Configuration.GetConnectionString("DefaultConnection")));
services.AddDbContext <PostgreSqlContext>(options => options.UseInMemoryDatabase(databaseName: "postgres"));
var options = new DbContextOptionsBuilder <PostgreSqlContext>()
.UseInMemoryDatabase(databaseName: "Test")
.Options;
using (var context = new PostgreSqlContext(options))
{
for (int i = 1; i < 10; i++)
{
var testStatement1 = new Statement
{
Id = i,
Description = "description " + i,
Img = "http://1 " + i,
Phone = $"{i}{i * 2}{i * 3}{i * 4}{i * 5}{i * 6}",
Title = "test" + i
};
context.Statement.Add(testStatement1);
}
context.SaveChanges();
}
services.AddMvc();
services.AddScoped <PostgreSqlContext>();
services.AddScoped <IRepository <Statement>, Repository <Statement> >();
services.AddScoped <IStatementService, StatementService>();
}
private static void _verifyMigrate(PostgreSqlContext context)
{
var pendingMigrations = context.Database.GetPendingMigrations();
var migrations = pendingMigrations as IList <string> ?? pendingMigrations.ToList();
if (!migrations.Any())
{
Console.WriteLine("No pending migratons");
Environment.Exit(0);
}
Console.WriteLine("Pending migratons {0}", migrations.Count());
foreach (var migration in migrations)
{
Console.WriteLine($"\t{migration}");
}
}
public static void AddTestData(PostgreSqlContext context)
{
for (int i = 1; i < 10; i++)
{
var testStatement1 = new Statement
{
Id = i,
Description = "description " + i,
Img = "http://1 " + i,
Phone = $"{i}{i * 2}{i * 3}{i * 4}{i * 5}{i * 6}",
Title = "test" + i
};
context.Statement.Add(testStatement1);
}
context.SaveChanges();
}
public ProductModel UpdateProduct(ProductModel product)
{
using (var context = new PostgreSqlContext())
{
var oryginalProduct = context.Product.Where(x => x.Id == product.Id).FirstOrDefault();
if (oryginalProduct != null)
{
context.Entry(oryginalProduct).CurrentValues.SetValues(product);
context.SaveChanges();
return(product);
}
else
{
return(null);
}
}
}
public bool DeleteProduct(Guid id)
{
using (var context = new PostgreSqlContext())
{
var itemToDelete = context.Product.Where(x => x.Id == id).FirstOrDefault();
if (itemToDelete != null)
{
context.Product.Remove(itemToDelete);
context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
private SampleAppBaseContext ResolveDbContext(IServiceProvider provider)
{
var tenantSettingsList = TenantHelper.GetTenantAppSettingsList(_sampleAppSettings, TenantHelper.GetCurrentTenantId(_sampleAppSettings));
if (tenantSettingsList.NotAssigned() || ((JArray)tenantSettingsList).Count == 0)
{
throw new Exception($"Belirtilen kiracı için uygulama ayarları yapılmamıştır: { HttpContextExtensions.GetCurrentContextId()}");
}
SampleAppBaseContext dbContext = new SampleAppBaseContext();
var tenantAppSettings = ((JArray)tenantSettingsList)[0];
string serverAddr = tenantAppSettings["ServerAddress"].ToString();
int dbType = tenantAppSettings["DBType"].ToInt();
string dbName = tenantAppSettings["DBName"].ToString();
int? port = tenantAppSettings["Port"].ToInt();
string serverUsername = tenantAppSettings["ServerUsername"].ToString();
string serverPassword = tenantAppSettings["ServerPassword"].ToString();
string schemaName = tenantAppSettings["SchemaName"].ToString();
if (dbType == (int)DBTypes.MSSQL)
{
DbContextOptionsBuilder <MsSqlContext> sqlOptionsBuilder = new DbContextOptionsBuilder <MsSqlContext>();
GetDbContextOptions(sqlOptionsBuilder, $"Data Source={serverAddr},{port};Initial Catalog={dbName};User Id={serverUsername};Password={serverPassword};", dbType, schemaName);
dbContext = new MsSqlContext(sqlOptionsBuilder.Options);
}
else if (dbType == (int)DBTypes.PostGreSQL)
{
DbContextOptionsBuilder <PostgreSqlContext> sqlOptionsBuilder = new DbContextOptionsBuilder <PostgreSqlContext>();
GetDbContextOptions(sqlOptionsBuilder, $"Host = {serverAddr}; Database = {dbName}; User ID = {serverUsername}; Password = {serverPassword}; Port = {port};Pooling = true;", dbType, schemaName);
dbContext = new PostgreSqlContext(sqlOptionsBuilder.Options);
}
dbContext.SchemaName = schemaName;
dbContext.DbType = (DBTypes)dbType;
var dbInitializer = new DbInitializer(dbContext);
dbInitializer.Initialize();
return(dbContext);
}
public TableController(PostgreSqlContext context)
{
_context = context;
}
public PostgreSqlActionTypeDal(PostgreSqlContext context) : base(context)
{
}
public UsersUnitOfWork(PostgreSqlContext context)
{
_context = context;
}
public WorkflowController()
{
factory = new DesignTimeDbContextFactory();
context = factory.CreateDbContext(new string[0]);
}
public PostgreSqlUserDal(PostgreSqlContext context) : base(context)
{
}
public UserRepository(PostgreSqlContext context) : base(context)
{
}
public MainCourseController(PostgreSqlContext context)
{
_context = context;
}
public PostgreSqlVehicleTypeDal(PostgreSqlContext context) : base(context)
{
}
public NoteRepository(PostgreSqlContext context, ILoggerFactory loggerFactory) : base(context, loggerFactory)
{
}
public Repository(PostgreSqlContext dataContext)
{
_context = dataContext;
DbSet = dataContext.Set <T>();
}
public RestaurantController(PostgreSqlContext context)
{
_context = context;
}
public CallGuideRepository(PostgreSqlContext _postgreSqlContext)
{
postgreSqlContext = _postgreSqlContext ?? throw new ArgumentNullException(nameof(_postgreSqlContext));
}
