// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
ApplicationSettings.ConnectionString =
"Host=localhost;Port=5432;Database=postgres;Username=postgres;Password=12345";
ApiBootstrapper bootstrapper = new ApiBootstrapper();
bootstrapper.Start();
foreach (var service in bootstrapper.Container.ServiceCollection)
{
services.AddTransient(service.ServiceType, service.ImplementationType);
}
services.BuildServiceProvider();
ITableCreator tableCreator = DependencyService.GetService <ITableCreator>();
tableCreator.CreateAllTable <EntityBase>();
var envService = services.FirstOrDefault(v => v.ServiceType == typeof(IHostingEnvironment));
bootstrapper.Container.Register(envService.ServiceType, envService.ImplementationInstance);
// ISeedManager seedManager = DependencyService.GetService<ISeedManager>();
// seedManager.ExecuteAll();
services.AddMvc();
}
public DbSinkCore(DbOptions opt, ITableCreator tableCreator)
{
_opt = opt;
_tableCreator = tableCreator;
Init();
}
public DbSink(int batchPostingLimit, TimeSpan period, DbOptions opt, ITableCreator tableCreator)
: base(batchPostingLimit, period)
{
_db = new DbSinkCore(opt, tableCreator);
_db.DbOpt.Check();
_db.ColumnOptions.FinalizeConfigurationForSinkConstructor();
}
public DatabaseFacade(
ITableNameExtractor tableNameExtractor,
ITableCreator tableCreator,
ITableDropper tableDropper,
IDynamoContextOptionsProvider optionsProvider,
Type contextType)
{
this.options = optionsProvider.GetContextOptions(contextType);
this.tableNameExtractor = tableNameExtractor;
this.tableCreator = tableCreator;
this.tableDropper = tableDropper;
}
public ListByStarCommand(IMovieService movieService, ITableCreator tableCreator)
{
if (movieService == null)
{
throw new ArgumentNullException("Movie service cannot be null.");
}
if (tableCreator == null)
{
throw new ArgumentNullException("Table creator cannot be null.");
}
this.movieService = movieService;
this.tableCreator = tableCreator;
}
/// <summary>
/// Returns the object of the collector tables
/// </summary>
/// <param name="rep">Processed provider</param>
private void GetCreator(Provider rep)
{
if (rep == Provider.MicrosoftSql)
{
_tableCreator = new MsSqlTableCreator();
}
else if (rep == Provider.MySql)
{
_tableCreator = new MySqlTableCreator();
}
else if (rep == Provider.SyBase)
{
_tableCreator = new SyBaseTableCreator();
}
}
public DbAuditSink(DbOptions opt, ITableCreator tableCreator)
{
opt.Check();
var columnOptions = opt.ColumnOptions;
if (columnOptions != null)
{
if (columnOptions.DisableTriggers)
{
throw new NotSupportedException($"The {nameof(ColumnOptions.DisableTriggers)} option is not supported for auditing.");
}
columnOptions.FinalizeConfigurationForSinkConstructor();
}
_db = new DbSinkCore(opt, tableCreator);
}
public GenerateReportCommand(IMovieService movieService, ITableCreator tableCreator)
{
if (movieService == null)
{
throw new ArgumentNullException("Movie service cannot be null.");
}
if (tableCreator == null)
{
throw new ArgumentNullException("Table creator cannot be null.");
}
this.movieService = movieService;
this.tableCreator = tableCreator;
this.listCommand = new ListAllCommand(movieService, tableCreator);
}
public MyDbSinkCore(DbOptions opt, ITableCreator tableCreator) : base(opt, tableCreator)
{
}
static void Main(string[] args)
{
ApplicationSettings.ConnectionString =
"server=superdoctor.cnc1ajzvqewo.eu-central-1.rds.amazonaws.com;database=superdoctor;user id=spadmin;password=spr31415SD;";
SspBootstrapper sspBootstrapper = new SspBootstrapper();
sspBootstrapper.Start();
ITableCreator tableCreator = DependencyService.GetService <ITableCreator>();
tableCreator.CreateAllTable <EntityBase>();
IRepository <SampleEntity> sRepository = DependencyService.GetService <IRepository <SampleEntity> >();
var sample = new SampleEntity();
sample.Emrah = "emrah1";
sample.IsDeleted = true;
sRepository.Create(sample);
var samle = new SampleEntity();
samle.Emrah = "emrah2";
samle.IsDeleted = false;
sRepository.Create(samle);
var list = sRepository.Query().ToList();
//dynamic repository = DependencyService.GetService(typeof(IRepository));
string temp = "";
//IMembershipManager membershipManager = DependencyService.GetService<IMembershipManager>();
//ISeedManager seedManager = DependencyService.GetService<ISeedManager>();
//seedManager.SeedType = SeedType.Dev;
//seedManager.ExecuteAll();
////RelationalDatabaseCreator databaseCreator =
//// (RelationalDatabaseCreator)_context.Database.GetService<IDatabaseCreator>();
//// databaseCreator.CreateTables();
////DbContextFactory<NebulaNpgEntityContext>.Instance.CurrentContext.Database.Migrate();
////string script = DbContextFactory<NebulaNpgEntityContext>.Instance.CurrentContext.Database.GenerateCreateScript();
//var role = new Role();
//role.Key = "UserManagement";
//UserGroup userGroup = new UserGroup();
//userGroup.Name = "Administrator";
//Company company = new Company();
//company.Name = "Medyanet";
//IMembershipManager membershipManager = DependencyService.GetService<IMembershipManager>();
//var users = membershipManager.UserQuery().Include(v => v.UserGroup).Include(v => v.Company).Include(v => v.Manager).ToList();
//string str = "";
//membershipManager.CreateRole(role);
//UserGroupRole ugr = new UserGroupRole();
//ICollection<UserGroupRole> ugrlist = new List<UserGroupRole>();
//ugrlist.Add(ugr);
//ugr.RoleId = role.Id;
//userGroup.UserGroupRoles = ugrlist;
//membershipManager.CreateUserGroup(userGroup);
//membershipManager.CreateCompany(company);
//var user = new Users()
//{
// Email = "*****@*****.**",
// Name = "Fatih",
// Lastname = "Mert",
// Password = "******",
// UserGroupId = userGroup.Id,
// Username = "******",
// CompanyId = company.Id
//};
//membershipManager.CreateUser(user);
//var users = membershipManager.GetAllUsers().Include(v => v.UserGroup).Include(v => v.Company).Include(v => v.Manager).ToList();
////var logss = sampleBusiness.Sample("abc");
////var logs2 = sampleBusiness.Sample("abc");
////var logs3 = sampleBusiness.Sample("abcd");
////var logs4 = sampleBusiness.Sample("abc");
//LogEntity logEntity = new LogEntity()
//{
// JsonMessage = "mesage",
// LogType = "error",
// Message = "error message",
// CreateDate = DateTime.Now,
// UpdateDate = DateTime.Now
//};
//Console.ReadKey();
}
public static LoggerConfiguration Db(this LoggerAuditSinkConfiguration loggerAuditSinkConfiguration, Action <DbOptions> dbAction = null, ITableCreator tableCreator = null, LogEventLevel restrictedToMinimumLevel = LevelAlias.Minimum, IConfigurationSection columnOptionsSection = null)
{
if (loggerAuditSinkConfiguration == null)
{
throw new ArgumentNullException("loggerAuditSinkConfiguration");
}
DbOptions opt = new DbOptions();
dbAction?.Invoke(opt);
opt.ColumnOptions = ApplyMicrosoftExtensionsConfiguration.ConfigureColumnOptions(opt.ColumnOptions, columnOptionsSection);
return(loggerAuditSinkConfiguration.Sink(new DbAuditSink(opt, tableCreator ?? new DefaultTableCreator()), restrictedToMinimumLevel));
}
public static LoggerConfiguration Db(this LoggerSinkConfiguration loggerConfiguration,
Action <DbOptions> dbAction = null, ITableCreator tableCreator = null,
LogEventLevel restrictedToMinimumLevel = LevelAlias.Minimum,
int batchPostingLimit = DbSink.DefaultBatchPostingLimit,
TimeSpan?period = null,
IConfigurationSection columnOptionsSection = null
)
{
if (loggerConfiguration == null)
{
throw new ArgumentNullException("loggerConfiguration");
}
var defaultedPeriod = period ?? DbSink.DefaultPeriod;
DbOptions opt = new DbOptions();
dbAction?.Invoke(opt);
opt.ColumnOptions = ApplyMicrosoftExtensionsConfiguration.ConfigureColumnOptions(opt.ColumnOptions, columnOptionsSection);
return(loggerConfiguration.Sink(new DbSink(batchPostingLimit, defaultedPeriod, opt, tableCreator ?? new DefaultTableCreator()), restrictedToMinimumLevel));
}
// Table
public static Table <THelper> Table <THelper>(this ITableCreator <THelper> creator)
where THelper : BootstrapHelper <THelper>
{
return(new Table <THelper>(creator));
}
