mAirListScript

Unit DBTypes

Description
Uses
Classes, Interfaces, Objects and Records
Functions and Procedures
Types
Constants
Variables

Description

 

Overview

Classes, Interfaces, Objects and Records

Name Description
Class EStorageNotFound  
Class EAccessDenied  
Class EInvalidRequest  
Class ERequestError  
Class EFileExists  
Record TDBAuthData  
Record TSoftAttributeFilterValue  
Record TSoftAttributeFilter  

Types

TDBPlaylistImporterCapability = (...);
TDBPlaylistImporterCapabilities = set of TDBPlaylistImporterCapability;
TDBUserLevel = (...);
TDBUserLevels = set of TDBUserLevel;
TDBSQLServerType = (...);
TDBSQLServerTypes = set of TDBSQLServerType;
TDBAuthenticationMethod = (...);
TDBOption = (...);
TDBOptions = set of TDBOption;
TDBSchedulerOption = (...);
TDBSchedulerOptions = set of TDBSchedulerOption;
TDBTemplateOption = (...);
TDBTemplateOptions = set of TDBTemplateOption;
TDBTemplateItemDurationType = (...);
TDBTemplateItemStatusFlag = (...);
TDBTemplateItemStatusFlags = set of TDBTemplateItemStatusFlag;
TDBTemplateItemCapability = (...);
TDBTemplateItemCapabilities = set of TDBTemplateItemCapability;
TDBTemplateItemOption = (...);
TDBTemplateItemOptions = set of TDBTemplateItemOption;
TDBMusicSource = (...);
TDBMusicTemplateKinds = set of TDBMusicSource;
TDBMusicBlockMode = (...);
TDBMusicTemplateModes = set of TDBMusicBlockMode;
TDBBlockType = (...);
TDBMusicBlockConfigItemMode = (...);
TDBOverwritePolicy = (...);
TDBOverwritePolicies = set of TDBOverwritePolicy;
TDBGeneralPermission = (...);
TDBGeneralPermissions = set of TDBGeneralPermission;
TDBLibraryPermission = (...);
TDBLibraryPermissions = set of TDBLibraryPermission;
TDBTemplateAssignmentCondition = (...);
TDBTemplateAssignmentConditions = set of TDBTemplateAssignmentCondition;
TDBTemplateKind = (...);
TDBTemplateKinds = set of TDBTemplateKind;
TSoftAttributeFilterValueArray = array of TSoftAttributeFilterValue;
TSoftAttributeFilterArray = array of TSoftAttributeFilter;

Constants

MAX_DB_PLAYLIST_BLOCK = 16;
MAX_DB_AD_BLOCK = 128;
MAX_SOFT_ATTRIBUTE_WEIGHT = 100;
DB_ADMIN_USER = 'admin';
DB_ADMIN_PASSWORD = 'admin';
DB_ADMIN_PASSWORD_CONFIGKEY = 'adminpassword';
DBSchemaVersion = 25;
MinDBSchemaVersion = 24;
MinDBSchemaVersion_Auth = 25;
DBAPIVersion = 1;
MinDBAPIVersion = 1;
DBDefaultWeekRef = 42737;
cdDBStation = 1;
cdDBStorages = 2;
ccDB = 'mAirListDB';
DefaultArtistSeparation = 2;
DefaultArtistSeparationPenalty = 1;
DefaultTitleSeparation = 3;
DefaultTitleSeparationPenalty = 1;
DefaultTrackSeparation = 3;
DefaultTrackSeparationPenalty = 2;
DefaultMaxPenalty = 0;
DefaultAdBlockCount = 4;
NetworkSQLServerTypes = [ stPG, stOldPG, stMSSQL, stMySQL, stOldMySQL ];
DefaultDBOptions = [ dboDatabaseButtonInPlayoutWindow, dboTemplatesMenu, dboStationsAlphaSort, dboImportVoiceTracks, dboDisableLoggingOffAir ];
DefaultDBSchedulerOptions = [ ];
AllDBGeneralPermissions = [ gpDownloadFiles, gpDeleteFiles ];
DB_MAX_SUBPLAYLIST = 64;

Description

Types

TDBPlaylistImporterCapability = (...);
 
Values
  • picMultiFile
TDBPlaylistImporterCapabilities = set of TDBPlaylistImporterCapability;
 
TDBUserLevel = (...);
 
Attributes
EnumPrefix('ul')
EnumCaption('read-only')
EnumCaption('Studio')
EnumCaption('DJ')
EnumCaption('VT DJ')
EnumCaption('Folder Manager')
EnumCaption('Manager')
EnumCaption('Administrator')
Values
  • ulReadOnly
  • ulStudio
  • ulDJ
  • ulVTDJ
  • ulFolderManager
  • ulManager
  • ulAdmin
TDBUserLevels = set of TDBUserLevel;
 
TDBSQLServerType = (...);
 
Attributes
EnumPrefix('st')
EnumCaption('PostgreSQL >= 9.4')
EnumCaption('PostgreSQL <= 9.3')
EnumCaption('Microsoft SQL Server')
EnumCaption('MySQL 5.7.22+/MariaDB 10.5+')
EnumCaption('MySQL/MariaDB (older version)')
EnumCaption('SQLite')
Values
  • stPG
  • stOldPG
  • stMSSQL
  • stMySQL
  • stOldMySQL
  • stSQLite: it is important that stSQLite comes last because of some hacks in TNetworkSQLDBConnectionConfigForm that use filtered captions etc.
TDBSQLServerTypes = set of TDBSQLServerType;
 
TDBAuthenticationMethod = (...);
 
Values
  • amCredentials
  • amToken
TDBOption = (...);
 
Attributes
EnumPrefix('dbo')
EnumCaption('Management software requires login')
EnumCaption('Internet Server requires login')
EnumCaption('Auto Importer requires login')
EnumCaption('Show Database button in playout window')
EnumCaption('Show templates in popup/dropdown menus')
EnumCaption('Sort stations alphabetically')
EnumCaption('Use external IDs for import and export')
EnumCaption('Disable internal logging')
EnumCaption('Disable internal logging when OFF AIR')
EnumCaption('Disable Scheduling tab in Properties dialog')
EnumCaption('Disable History tab in Properties dialog')
EnumCaption('Import new voice tracks recorded in the playlist editor')
EnumCaption('Import new voice tracks recorded in the playout window')
EnumCaption('Refuse advertising update when new block has errors')
EnumCaption('Compatibility mode (allow connections to older databases)')
Values
  • dboManagementLogin
  • dboDBServerLogin
  • dboAutoImporterLogin
  • dboDatabaseButtonInPlayoutWindow
  • dboTemplatesMenu
  • dboStationsAlphaSort
  • dboUseExternalIDs
  • dboDisableInternalLogging
  • dboDisableLoggingOffAir
  • dboDisableSchedulingTab
  • dboDisableHistoryTab
  • dboImportVoiceTracks
  • dboImportVoiceTracksPlayout
  • dboUpdateAdvertisingRefuseOnError
  • dboCompatibilityMode
TDBOptions = set of TDBOption;
 
TDBSchedulerOption = (...);
 
Attributes
EnumPrefix('dbso')
Values
  • dbsoDummy
TDBSchedulerOptions = set of TDBSchedulerOption;
 
TDBTemplateOption = (...);
 
Attributes
EnumPrefix('to')
EnumCaption('Perform auto float after scheduling')
Values
  • toAutoFloat
TDBTemplateOptions = set of TDBTemplateOption;
 
TDBTemplateItemDurationType = (...);
 
Values
  • tidtOffset
  • tidtDuration
  • tidtUnderrun
TDBTemplateItemStatusFlag = (...);
 
Values
  • tisfFixedStart
  • tisfInfinite
  • tisfOverflow
TDBTemplateItemStatusFlags = set of TDBTemplateItemStatusFlag;
 
TDBTemplateItemCapability = (...);
 
Values
  • ticTiming
  • ticOpenerCloser
TDBTemplateItemCapabilities = set of TDBTemplateItemCapability;
 
TDBTemplateItemOption = (...);
 
Attributes
EnumPrefix('tio')
EnumCaption('Create a container if more than one item')
EnumCaption('Always create a container')
EnumCaption('Prevent auto float around this item')
EnumCaption('Reset timing to Normal after scheduling')
Values
  • tioContainerIfMany
  • tioContainerAlways
  • tioPreventFloat
  • tioResetTiming
TDBTemplateItemOptions = set of TDBTemplateItemOption;
 
TDBMusicSource = (...);
 
Attributes
EnumPrefix('ms')
EnumCaption('Internal scheduler (use Folder Selection)')
EnumCaption('External scheduler (import from file or external source)')
EnumCaption('Hybrid (try import first, fallback to internal scheduler)')
Values
  • msInternal
  • msExternal
  • msHybrid
TDBMusicTemplateKinds = set of TDBMusicSource;
 
TDBMusicBlockMode = (...);
 
Attributes
EnumPrefix('mbm')
EnumCaption('Randomly pick from the list of folders/items')
EnumCaption('Use exact order')
EnumCaption('Use exact order, repeat if necessary')
EnumCaption('Maintain order, allow random selection')
EnumCaption('Maintain order, allow random selection, repeat if necessary')
Values
  • mbmRandom
  • mbmExact
  • mbmExactRepeat
  • mbmOrderRandom
  • mbmOrderRandomRepeat
TDBMusicTemplateModes = set of TDBMusicBlockMode;
 
TDBBlockType = (...);
 
Attributes
EnumPrefix('bt')
EnumCaption('Internal')
EnumCaption('External (import from external scheduler)')
Values
  • btInternal
  • btExternal
TDBMusicBlockConfigItemMode = (...);
 
Attributes
EnumPrefix('im')
EnumCaption('Random item from folder')
EnumCaption('Specific item')
Values
  • imFolder
  • imSpecificItem
TDBOverwritePolicy = (...);
 
Attributes
EnumPrefix('op')
EnumCaption('Rename new file')
EnumCaption('Replace old file')
EnumCaption('Skip')
Values
  • opRename
  • opReplace
  • opSkip
TDBOverwritePolicies = set of TDBOverwritePolicy;
 
TDBGeneralPermission = (...);
 
Attributes
EnumPrefix('gp')
EnumCaption('Export/download audio files')
EnumCaption('Delete audio files')
Values
  • gpDownloadFiles
  • gpDeleteFiles
TDBGeneralPermissions = set of TDBGeneralPermission;
 
TDBLibraryPermission = (...);
 
Attributes
EnumPrefix('lp')
EnumCaption('Add items')
EnumCaption('Edit items')
EnumCaption('Delete items')
EnumCaption('Move items')
EnumCaption('Add folders')
EnumCaption('Edit folders')
EnumCaption('Delete folders')
EnumCaption('Move folders')
Values
  • lpAddItems
  • lpEditItems
  • lpDeleteItems
  • lpMoveItems
  • lpAddFolders
  • lpEditFolders
  • lpDeleteFolders
  • lpMoveFolders
TDBLibraryPermissions = set of TDBLibraryPermission;
 
TDBTemplateAssignmentCondition = (...);
 
Attributes
EnumPrefix('tac')
EnumCaption('Default')
EnumCaption('Even week')
EnumCaption('Odd week')
EnumCaption('1st in month')
EnumCaption('2nd in month')
EnumCaption('3rd in month')
EnumCaption('4th in month')
EnumCaption('5th in month')
EnumCaption('Week 1 of 2')
EnumCaption('Week 2 of 2')
EnumCaption('Week 1 of 3')
EnumCaption('Week 2 of 3')
EnumCaption('Week 3 of 3')
EnumCaption('Week 1 of 4')
EnumCaption('Week 2 of 4')
EnumCaption('Week 3 of 4')
EnumCaption('Week 4 of 4')
EnumCaption('Week 1 of 5')
EnumCaption('Week 2 of 5')
EnumCaption('Week 3 of 5')
EnumCaption('Week 4 of 5')
EnumCaption('Week 5 of 5')
EnumCaption('Week 1 of 6')
EnumCaption('Week 2 of 6')
EnumCaption('Week 3 of 6')
EnumCaption('Week 4 of 6')
EnumCaption('Week 5 of 6')
EnumCaption('Week 6 of 6')
EnumCaption('Special')
Values
  • tacDefault
  • tacEvenWeekNumber
  • tacOddWeekNumber
  • tacWeekday1
  • tacWeekday2
  • tacWeekday3
  • tacWeekday4
  • tacWeekday5
  • tacWeek1of2
  • tacWeek2of2
  • tacWeek1of3
  • tacWeek2of3
  • tacWeek3of3
  • tacWeek1of4
  • tacWeek2of4
  • tacWeek3of4
  • tacWeek4of4
  • tacWeek1of5
  • tacWeek2of5
  • tacWeek3of5
  • tacWeek4of5
  • tacWeek5of5
  • tacWeek1of6
  • tacWeek2of6
  • tacWeek3of6
  • tacWeek4of6
  • tacWeek5of6
  • tacWeek6of6
  • tacSpecial
TDBTemplateAssignmentConditions = set of TDBTemplateAssignmentCondition;
 
TDBTemplateKind = (...);
 
Attributes
EnumPrefix('tk')
EnumCaption('Hour Templates')
EnumCaption('Music Templates')
EnumCaption('Transition Templates')
Values
  • tkHour
  • tkMusic
  • tkTransitions
TDBTemplateKinds = set of TDBTemplateKind;
 
TSoftAttributeFilterValueArray = array of TSoftAttributeFilterValue;
 
TSoftAttributeFilterArray = array of TSoftAttributeFilter;
 

Constants

MAX_DB_PLAYLIST_BLOCK = 16;
 
MAX_DB_AD_BLOCK = 128;
 
MAX_SOFT_ATTRIBUTE_WEIGHT = 100;
 
DB_ADMIN_USER = 'admin';
 
DB_ADMIN_PASSWORD = 'admin';
 
DB_ADMIN_PASSWORD_CONFIGKEY = 'adminpassword';
 
DBSchemaVersion = 25;
 
MinDBSchemaVersion = 24;
 
MinDBSchemaVersion_Auth = 25;

In compatibility mode

DBAPIVersion = 1;
 
MinDBAPIVersion = 1;
 
DBDefaultWeekRef = 42737;
 
cdDBStation = 1;

2017-01-02

cdDBStorages = 2;
 
ccDB = 'mAirListDB';
 
DefaultArtistSeparation = 2;
 
DefaultArtistSeparationPenalty = 1;
 
DefaultTitleSeparation = 3;
 
DefaultTitleSeparationPenalty = 1;
 
DefaultTrackSeparation = 3;
 
DefaultTrackSeparationPenalty = 2;
 
DefaultMaxPenalty = 0;
 
DefaultAdBlockCount = 4;
 
NetworkSQLServerTypes = [ stPG, stOldPG, stMSSQL, stMySQL, stOldMySQL ];
 
DefaultDBOptions = [ dboDatabaseButtonInPlayoutWindow, dboTemplatesMenu, dboStationsAlphaSort, dboImportVoiceTracks, dboDisableLoggingOffAir ];
 
DefaultDBSchedulerOptions = [ ];
 
AllDBGeneralPermissions = [ gpDownloadFiles, gpDeleteFiles ];
 
DB_MAX_SUBPLAYLIST = 64;
 
Generated by PasDoc 0.16.0.