Versions in this module Expand all Collapse all v1 v1.0.1 Apr 1, 2020 v1.0.0 Mar 18, 2020 Changes in this version + const ActivitySQL + const AllActivitiesSQL + const DateFormat + const PermissionActivitiesSQL + const PermissionSQL + const TimeFormat + const TimeFormatMicro + const TimeFormatMicroLocal + var ParseTime = ... + func AddAlarmToUser(ctx context.Context, conn *sql.Conn, userID int64, alarm Alarm) (alarmID int64, err error) + func AddAreaToUnit(ctx context.Context, conn *sql.Conn, unitID int64, area AlarmArea) error + func AlarmHasArea(ctx context.Context, conn *sql.Conn, unitID, areaID int64) bool + func CreateAlarm(ctx context.Context, conn *sql.Conn, alarm Alarm) (alarmID int64, err error) + func CreateAlarmArea(ctx context.Context, conn *sql.Conn, unitID int64, area AlarmArea) (areaID int64, err error) + func CreateAlarmSettings(ctx context.Context, conn *sql.Conn, userID int64) (int64, error) + func CreateAppSettings(ctx context.Context, conn *sql.Conn, groupID int64, settings AppSettings) (int64, error) + func CreateGroup(ctx context.Context, conn *sql.Conn, group *Group) (int64, error) + func CreateGroupMapLayer(ctx context.Context, conn *sql.Conn, groupID int64, layer *LayerForGroup) (layerID int64, err error) + func CreateMapLayer(ctx context.Context, conn *sql.Conn, layer *Layer) (layerID int64, err error) + func CreateProfile(ctx context.Context, conn *sql.Conn, userID int64) (int64, error) + func CreateRole(ctx context.Context, conn *sql.Conn, role *Role) (int64, error) + func CreateRolePermission(ctx context.Context, conn *sql.Conn, roleID, permissionID int64) error + func CreateStrokeArea(ctx context.Context, conn *sql.Conn, area *StrokeArea) (int64, error) + func CreateUser(ctx context.Context, conn *sql.Conn, user *User) (id int64, err error) + func CreateUserLog(log Logging, userID int64) (logID int64, err error) + func DeleteAlarm(ctx context.Context, conn *sql.Conn, alarmID, userID int64) error + func DeleteAlarmByGroupID(ctx context.Context, conn *sql.Conn, alarmID, groupID int64) error + func DeleteGroup(ctx context.Context, conn *sql.Conn, groupID int64) error + func DeleteGroupMapLayer(ctx context.Context, conn *sql.Conn, groupID, layerID int64) error + func DeleteMapLayer(ctx context.Context, conn *sql.Conn, layerID int64) error + func DeleteRole(ctx context.Context, conn *sql.Conn, roleID int64) error + func DeleteRolePermission(ctx context.Context, conn *sql.Conn, roleID, permissionID int64) error + func DeleteUser(ctx context.Context, conn *sql.Conn, userID int64) error + func GeomContainsPoint(g wkt.Geom, point *wkt.Point) bool + func HasAlarm(ctx context.Context, conn *sql.Conn, userID, alarmID int64) bool + func HasAlarmByGroup(ctx context.Context, conn *sql.Conn, groupID, alarmID int64) bool + func LoadActivities(ctx context.Context, conn *sql.Conn, permissionActivities []PermissionActivity) (map[int64]*Activity, error) + func LoadPermissions(ctx context.Context, conn *sql.Conn, rolePermissions []RolePermission, ...) error + func LoadRoles(ctx context.Context, conn *sql.Conn, userRoles []UserRole) (map[int64]*Role, error) + func LoadRolesForUser(ctx context.Context, conn *sql.Conn, userID int64) (*[]Role, error) + func LoadStrokeAreaAsWKT(ctx context.Context, conn *sql.Conn, userID int64) (wkt.Geom, error) + func MultiPolygonContainsPoint(poly *wkt.MultiPolygon, point *wkt.Point) bool + func PolygonContainsPoint(poly *wkt.Polygon, point *wkt.Point) bool + func RemoveAreaFromUnit(ctx context.Context, conn *sql.Conn, unitID, areaID int64) error + func UpdateAlarm(ctx context.Context, conn *sql.Conn, alarm Alarm) (alarmID int64, err error) + func UpdateAlarmArea(ctx context.Context, conn *sql.Conn, area *AlarmArea) (int64, error) + func UpdateAlarmSettings(ctx context.Context, conn *sql.Conn, settings AlarmSettings) (int64, error) + func UpdateAppSettings(ctx context.Context, conn *sql.Conn, groupID int64, settings AppSettings) (int64, error) + func UpdateGroup(ctx context.Context, conn *sql.Conn, group *Group) (int64, error) + func UpdateGroupMapLayer(ctx context.Context, conn *sql.Conn, layer *LayerForGroup) (layerID int64, err error) + func UpdateMapLayer(ctx context.Context, conn *sql.Conn, layer *Layer) (layerID int64, err error) + func UpdateProfile(ctx context.Context, conn *sql.Conn, userID int64, profile *interface{}) error + func UpdateRole(ctx context.Context, conn *sql.Conn, role *Role) (int64, error) + func UpdateStrokeArea(ctx context.Context, conn *sql.Conn, area *StrokeArea) (int64, error) + func UpdateUser(ctx context.Context, conn *sql.Conn, user *User) (int64, error) + type Activity struct + ID int64 + Method string + Name string + URL string + func LoadAllActivities(ctx context.Context, conn *sql.Conn) ([]*Activity, error) + type Alarm struct + Alarm bool + AlarmTimestamp *pgtype.Timestamptz + GroupID int64 + ID int64 + IsExtended bool + IsNotified bool + Name string + func LoadAlarm(ctx context.Context, conn *sql.Conn, unitID int64) (*Alarm, error) + func LoadAlarmByGroup(ctx context.Context, conn *sql.Conn, groupID int64) ([]Alarm, error) + func LoadAlarmByGroupByID(ctx context.Context, conn *sql.Conn, groupID, alarmID int64) ([]Alarm, error) + func LoadAlarms(ctx context.Context, conn *sql.Conn, userID int64) ([]Alarm, error) + type AlarmArea struct + AlarmDuration *int64 + Area *float64 + Center *interface{} + Geom interface{} + ID int64 + Icon *string + InnerRadius *float64 + LastStroke *pgtype.Timestamptz + Radius *float64 + StrokeCounter *int64 + StrokeThreshold *int64 + func LoadAlarmAreaByID(ctx context.Context, conn *sql.Conn, areaID int64) (*AlarmArea, error) + func LoadAlarmAreas(ctx context.Context, conn *sql.Conn, alarmID int64) ([]AlarmArea, error) + type AlarmSettings struct + AlarmTemplateFaxID *int64 + AlarmTemplateMailID *int64 + AlarmTemplateMqttID *int64 + AlarmTemplateSmsID *int64 + Email *string + Fax *string + Friday *bool + ID *int64 + Monday *bool + OnlyLog bool + Phone *string + Saturday *bool + Sms *string + StartDate *pgtype.Timestamptz + StartTime *time.Time + StopDate *pgtype.Timestamptz + StopTime *time.Time + StrokeAsCSV bool + StrokeProtocol bool + Sunday *bool + Thursday *bool + Tuesday *bool + Wednesday *bool + func LoadAlarmSettings(ctx context.Context, conn *sql.Conn, userID int64) (*AlarmSettings, error) + type AppSettings struct + Animation bool + ArchiveDays int64 + ArchiveSince pgtype.Timestamptz + GroupID int64 + ID *int64 + LiveBlids bool + MaxAlarmAreas int64 + MaxAlarmUser int64 + MaxAlarms int64 + MaxDisplayTime *int64 + MaxZoom int64 + MinZoom int64 + Path string + Sound bool + StatisticWindowed bool + func LoadAppSettings(ctx context.Context, conn *sql.Conn, groupID int64) (*AppSettings, error) + type BBox struct + MaxX float64 + MaxY float64 + MinX float64 + MinY float64 + func CalculateBBox(g wkt.Geom) *BBox + func (bb *BBox) Contains(p *wkt.Point) bool + type Date struct + func (d *Date) UnmarshalJSON(data []byte) error + func (d Date) MarshalJSON() ([]byte, error) + type Group struct + AlarmConfigID *int64 + ChangeAlarmConfig bool + DataAreaID *int64 + ID *int64 + MaxAlarmArea *int64 + Name *string + Parent *int64 + RoleID *int64 + ThemeID *int64 + func LoadGroupByID(ctx context.Context, conn *sql.Conn, groupID int64) (*Group, error) + func LoadGroupChildren(ctx context.Context, conn *sql.Conn, groupID int64) ([]*Group, error) + type HostTheme struct + Data *pgtype.JSON + Host *string + ID *int64 + func LoadHostTheme(ctx context.Context, conn *sql.Conn, host string) (*HostTheme, error) + type Layer struct + BaseLayer bool + DefaultName *string + ExternalParameter json.RawMessage + ExternalServer *string + GeoserverName *string + ID int64 + LayerType string + Name *string + Reload bool + SingleTile bool + TickWidth *int64 + TimeLayer bool + func LoadMapLayerByID(ctx context.Context, conn *sql.Conn, layerID int64) (*Layer, error) + func LoadMapLayers(ctx context.Context, conn *sql.Conn) ([]Layer, error) + type LayerForGroup struct + CQLFilter json.RawMessage + CheckOnLogin bool + DisplayName *string + FeatureInfo bool + GroupID int64 + ID int64 + LayerID int64 + Permanent bool + PopupTemplate *string + ReloadTime int64 + ZIndex *int64 + func LoadGroupMapLayerByID(ctx context.Context, conn *sql.Conn, groupID, layerID int64) (*LayerForGroup, error) + func LoadGroupMapLayers(ctx context.Context, conn *sql.Conn, groupID int64) ([]LayerForGroup, error) + func LoadMapLayersUser(ctx context.Context, conn *sql.Conn, userID int64) ([]LayerForGroup, error) + type Logging struct + ID int64 + IP string + Text string + Timestamp *pgtype.Timestamptz + User string + func LoadUserLogs(ctx context.Context, conn *sql.Conn, userID int64) ([]Logging, error) + type PWResetUser struct + User string + type Permission struct + ActivityIDs []int64 + ID int64 + Name string + func LoadPermissionByID(ctx context.Context, conn *sql.Conn, permissionID int64) (*Permission, error) + func LoadPermissionsByRole(ctx context.Context, conn *sql.Conn, roleID int64) ([]*Permission, error) + func LoadUserPermissions(ctx context.Context, conn *sql.Conn, userID int64) ([]*Permission, error) + type PermissionActivity struct + ActivityID int64 + PermissionID int64 + func LoadPermissionActivities(ctx context.Context, conn *sql.Conn, rolePermissions []RolePermission) ([]PermissionActivity, error) + type Profile struct + Data *pgtype.JSON + ID *int64 + func LoadProfileForUser(ctx context.Context, conn *sql.Conn, userID int64) (*Profile, error) + type Role struct + ID int64 + Name *string + Parent *int64 + PermissionIDs []int64 + func LoadRoleByID(ctx context.Context, conn *sql.Conn, roleID int64) (*Role, error) + type RolePermission struct + PermissionID int64 + RoleID int64 + func LoadRolePermissions(ctx context.Context, conn *sql.Conn, roles map[int64]*Role) ([]RolePermission, error) + type Statistic struct + Cloud []StatisticItem + CountCloud int64 + CountNEarth int64 + CountPEarth int64 + CountTotal int64 + NEarth []StatisticItem + PEarth []StatisticItem + func LoadStatistics(ctx context.Context, conn *sql.Conn, start, stop int64, ...) (*Statistic, error) + type StatisticItem struct + Count float64 + Timestamp time.Time + type StrokeArea struct + Geom interface{} + GroupID int64 + ID *int64 + func LoadStrokeArea(ctx context.Context, conn *sql.Conn, userID int64) (*StrokeArea, error) + func LoadStrokeAreaByGroup(ctx context.Context, conn *sql.Conn, groupID int64) (*StrokeArea, error) + type Template struct + AlarmSubject string + AlarmText string + AllClearSubject string + AllClearText string + ID *int64 + func LoadTemplateFax(ctx context.Context, conn *sql.Conn) ([]Template, error) + func LoadTemplateMQTT(ctx context.Context, conn *sql.Conn) ([]Template, error) + func LoadTemplateMail(ctx context.Context, conn *sql.Conn) ([]Template, error) + func LoadTemplatePhone(ctx context.Context, conn *sql.Conn) ([]Template, error) + func LoadTemplateSMS(ctx context.Context, conn *sql.Conn) ([]Template, error) + type Theme struct + Data *pgtype.JSON + ID *int64 + Name *string + func LoadThemeForUser(ctx context.Context, conn *sql.Conn, userID int64) (*Theme, error) + func LoadThemes(ctx context.Context, conn *sql.Conn) ([]Theme, error) + type Time struct + func (t *Time) UnmarshalJSON(data []byte) error + func (t Time) MarshalJSON() ([]byte, error) + type TimeParser []string + func (tg TimeParser) Parse(s string) (time.Time, error) + type User struct + Annotation *string + City *string + Company *string + Division *string + EMail *string + FirstName *string + GroupID *int64 + ID *int64 + LastName *string + MobileNumber *string + Name *string + Password *string + PhoneNumber *string + StartDate *sql.NullTime + StopDate *sql.NullTime + Street *string + ZIP *string + func LoadUser(ctx context.Context, conn *sql.Conn, userID int64) (*User, error) + func LoadUsersByGroup(ctx context.Context, conn *sql.Conn, groupID int64) ([]*User, error) + type UserActivities struct + Activities map[int64]*Activity + Permissions map[int64]*Permission + Roles map[int64]*Role + func LoadActivitiesForUser(ctx context.Context, conn *sql.Conn, userID int64) (*UserActivities, error) + type UserRole struct + RoleID int64 + UserID int64 + func LoadUserRoles(ctx context.Context, conn *sql.Conn, userID int64) ([]UserRole, error)