public static void Initialize(DanmuContext context, AppSettings appSettings)
{
context.Database.EnsureCreated();
//临时执行，修改以前的数据库
context.Database.ExecuteSqlRaw(
"CREATE TABLE IF NOT EXISTS \"HttpClientCache\" (\"Id\" int4 NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 ),\"Key\" TEXT COLLATE \"pg_catalog\".\"default\" NOT NULL, \"Value\" bytea, \"TimeStamp\" int8 NOT NULL,CONSTRAINT \"PK_HttpClientCache\" PRIMARY KEY ( \"Id\" ) );");
context.Database.ExecuteSqlRaw(
"CREATE INDEX IF NOT EXISTS \"IX_HttpClientCache_Key\" ON \"HttpClientCache\" USING hash ( \"Key\" COLLATE \"pg_catalog\".\"default\" \"pg_catalog\".\"text_ops\" );");
context.Database.ExecuteSqlRaw("DO $$ BEGIN IF EXISTS(SELECT * FROM information_schema.columns WHERE table_name='User' and column_name='UpDateTime') THEN ALTER TABLE \"User\" RENAME COLUMN \"UpDateTime\" TO \"UpdateTime\"; END IF; END $$;");
if (!context.User.Any())
{
var admin = appSettings.Admin;
var salt = new RandomStringBuilder().Create(6);
var user = new UserTable
{
Name = admin.User,
Salt = salt,
PassWord = Md5.GetMd5(Md5.GetMd5(admin.Password), salt),
Role = UserRole.SuperAdmin
};
context.User.AddAsync(user);
context.SaveChanges();
}
}
public static void Initialize(DanmuContext context, AppSettings appSettings)
{
context.Database.EnsureCreated();
if (context.User.Any())
{
return; // DB has been seeded
}
var admin = appSettings.Admin;
var salt = new RandomStringBuilder().Create(6);
var user = new UserTable
{
Name = admin.User,
Salt = salt,
PassWord = Md5.GetMd5(Md5.GetMd5(admin.Password), salt),
Role = UserRole.SuperAdmin
};
context.User.AddAsync(user);
context.SaveChanges();
}
public static void Initialize(DanmuContext context, AppSettings appSettings)
{
context.Database.EnsureCreated();
//临时执行，修改以前的数据库
context.Database.ExecuteSqlRaw("DO $$ BEGIN IF EXISTS(SELECT * FROM information_schema.columns WHERE table_name='User' and column_name='UpDateTime') THEN ALTER TABLE \"User\" RENAME COLUMN \"UpDateTime\" TO \"UpdateTime\"; END IF; END $$;");
if (!context.User.Any())
{
var admin = appSettings.Admin;
var salt = new RandomStringBuilder().Create(6);
var user = new UserTable
{
Name = admin.User,
Salt = salt,
PassWord = Md5.GetMd5(Md5.GetMd5(admin.Password), salt),
Role = UserRole.SuperAdmin
};
context.User.AddAsync(user);
context.SaveChanges();
}
}
public DanmuService(DanmuContext danmuContext) => _danmuContext = danmuContext;
public UserDao(AppConfiguration appConfiguration, DanmuContext context)
{
_admin = appConfiguration.GetAppSetting().Admin;
_context = context;
}
public UserDao(DanmuContext con)
{
_con = con;
}
public CacheDao(DanmuContext con)
{
_con = con;
}
public DanmuDao(DanmuContext con)
{
_con = con;
}
public DanmuDatabaseInitializer(DanmuContext context) => _context = context;
public VideoDao(DanmuContext con)
{
_con = con;
}
