database

README

banners.database

Support repository for Go and Echo experimentation

Documentation

Index

• Variables
• func GetBannersByZoneId(banners []domain.Banner, zoneId int) []domain.Banner
• func GetZonesIdsFromBanners(banners []domain.Banner) []int
• func InitializeTables(connection sqlx.DB)
• func PopulateBanners(connection sqlx.DB)
• func PopulateZones(connection sqlx.DB)
• func Seed()
• func SelectBanners(language string, pageId int, deviceId int) []domain.Banner
• func SelectZone(zoneId int) domain.Zone
• func SelectZones(banners []domain.Banner) []domain.Zone

Variables

var BannersSchema = "" /* 320-byte string literal not displayed */

var ConnectionString = "Server=SERVER_NAME;Database=DATABASE_NAME;Trusted_Connection=True;"

var DestroyBannerTable = "IF OBJECT_ID('dbo.banners', 'U') IS NOT NULL DROP TABLE dbo.banners"

var DestroyZonesTable = "IF OBJECT_ID('dbo.zones', 'U') IS NOT NULL DROP TABLE dbo.zones"

var ExecuteStoreProcedure = "EXEC cms.spGetBanners @LanguageCode, @PageId, @DeviceTypeId, @ErrorMessage OUTPUT;"

var StoredProcedureQuery = `` /* 763-byte string literal not displayed */

var ZonesSchema = "CREATE TABLE zones(id INT, deviceId INT, pageId INT, languageCode NVARCHAR(50), width INT, height INT)"

Functions

func GetBannersByZoneId

func GetBannersByZoneId(banners []domain.Banner, zoneId int) []domain.Banner

func GetZonesIdsFromBanners

func GetZonesIdsFromBanners(banners []domain.Banner) []int

func InitializeTables

func InitializeTables(connection sqlx.DB)

func PopulateBanners

func PopulateBanners(connection sqlx.DB)

func PopulateZones

func PopulateZones(connection sqlx.DB)

func Seed

func Seed()

func SelectBanners

func SelectBanners(language string, pageId int, deviceId int) []domain.Banner

func SelectZone

func SelectZone(zoneId int) domain.Zone

func SelectZones

func SelectZones(banners []domain.Banner) []domain.Zone