public static void CreateTables(VideoDbContext dbContext) { if (!dbContext.Database.TableExists("plugin.VideoWidget")) { dbContext.Database.ExecuteSqlCommand(@" CREATE TABLE [plugin].[VideoWidget]( [Id] [nvarchar](50) NOT NULL, [Title] [nvarchar](500) NULL, [VideoSourceType] [nvarchar](500) NULL, [VideoId] [nvarchar](500) NULL, [VideoUrl] [nvarchar](500) NULL, CONSTRAINT [PK_VideoLink] PRIMARY KEY CLUSTERED ([Id] ASC) ) "); } if (!dbContext.Database.TableExists("plugin.VideoStreamLink")) { dbContext.Database.ExecuteSqlCommand(@" CREATE TABLE [plugin].[VideoStreamLink]( [Id] [nvarchar](50) NOT NULL, [ClientId] [nvarchar](50) NULL, [Title] [nvarchar](500) NULL, [Path] [nvarchar](500) NULL, CONSTRAINT [PK_VideoLinkSource] PRIMARY KEY CLUSTERED ([Id] ASC) ) "); } }
public static void CreateSchemas(VideoDbContext dbContext) { dbContext.Database.ExecuteSqlCommand(@" IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'plugin') BEGIN EXEC('CREATE SCHEMA plugin') END "); }
public P710000_CreateInitialVideoTables(VideoDbContext dbContext) { _dbContext = dbContext; }
public static void InsertSeedData(VideoDbContext dbContext) { var clientId = "MyCompany"; if (dbContext.VideoStreamLinks.Count() == 0) { dbContext.VideoStreamLinks.Add(new Models.VideoStreamLink() { Id = Guid.NewGuid().ToString("N"), Title = "Video 1 - Whitley Elementary", Path = "http://mcpss.tv/Clients/7e26f301-1c4d-4cb9-b8fa-05df81b54e3d2015%20Show%201%20Whitley%20Elementary-m3u8-aapl.ism/manifest(format=m3u8-aapl).m3u8", ClientId = clientId }); dbContext.VideoStreamLinks.Add(new Models.VideoStreamLink() { Id = Guid.NewGuid().ToString("N"), Title = "Video 2 - Denisha Mckenzie", Path = "http://mcpss.tv/Clients/028436e4-7fe2-4ead-bb37-e06193500a64Denisha%20Mckenzie%20final-m3u8-aapl.ism/manifest(format=m3u8-aapl).m3u8", ClientId = clientId }); dbContext.VideoStreamLinks.Add(new Models.VideoStreamLink() { Id = Guid.NewGuid().ToString("N"), Title = "Video 3 - Live Feed", Path = "http://216.66.22.75:1935/live/mpegts.stream/playlist.m3u8", ClientId = clientId }); dbContext.VideoStreamLinks.Add(new Models.VideoStreamLink() { Id = Guid.NewGuid().ToString("N"), Title = "Cute Kittens", Path = "http://youtube.com/watch?v=w6DW4i-mfbA", ClientId = clientId }); dbContext.VideoStreamLinks.Add(new Models.VideoStreamLink() { Id = Guid.NewGuid().ToString("N"), Title = "Cute Puppies", Path = "http://youtube.com/watch?v=mRf3-JkwqfU", ClientId = clientId }); dbContext.VideoStreamLinks.Add(new Models.VideoStreamLink() { Id = Guid.NewGuid().ToString("N"), Title = "Battle Bots", Path = "http://youtube.com/watch?v=2ixB9k6aijw", ClientId = clientId }); dbContext.VideoStreamLinks.Add(new Models.VideoStreamLink() { Id = Guid.NewGuid().ToString("N"), Title = "Low Flying and Sonic Boom Jets", Path = "http://youtube.com/watch?v=9f2wBmFC3Rk", ClientId = clientId }); dbContext.VideoStreamLinks.Add(new Models.VideoStreamLink() { Id = Guid.NewGuid().ToString("N"), Title = "The Office Best Moments", Path = "http://youtube.com/watch?v=3OYtjXVilsA", ClientId = clientId }); dbContext.SaveChanges(); } }
public P710005_CreateVideoBackgroundTable(VideoDbContext dbContext) { _dbContext = dbContext; }