Package de.uplanet.lucy.server.newsagent
package de.uplanet.lucy.server.newsagent
Used to create and manage persistent Intrexx messages.
Overview
Documentation
The classes operate on the tablesLCMESSAGES
and LCRECIPIENTS
:
CREATE TABLE LCMESSAGES
(
GUIDMESSAGE VARCHAR(40) NOT NULL,
GUIDSENDER VARCHAR(40),
STRAPPGUID VARCHAR(40),
STRTARGETGUID VARCHAR(40),
INTRECID INTEGER NOT NULL,
DTCREATED DATETIME NOT NULL,
DTEXPIRE DATETIME,
STRSUBJECT VARCHAR(255),
TXTBODY TEXT
PRIMARY KEY (GUIDMESSAGE)
)
CREATE INDEX IX_LCMESSAGES0 ON LCMESSAGES(GUIDMESSAGE)
CREATE TABLE LCRECIPIENTS
(
GUIDMESSAGE VARCHAR(40) NOT NULL,
GUIDRECIPIENT VARCHAR(40) NOT NULL,
INTVISITED INTEGER NOT NULL,
INTDELETED INTEGER NOT NULL
PRIMARY KEY (GUIDMESSAGE, GUIDRECIPIENT),
FOREIGN KEY (GUIDMESSAGE) REFERENCES LCMESSAGES(GUIDMESSAGE)
)
CREATE INDEX IX_LCRECIPIENTS0 ON LCRECIPIENTS(GUIDRECIPIENT)
CREATE TABLE LCMAPAPP
(
STRAPPGUID VARCHAR(40),
STRTARGETGUID VARCHAR(40)
PRIMARY KEY (STRAPPGUID)
)
(
GUIDMESSAGE VARCHAR(40) NOT NULL,
GUIDSENDER VARCHAR(40),
STRAPPGUID VARCHAR(40),
STRTARGETGUID VARCHAR(40),
INTRECID INTEGER NOT NULL,
DTCREATED DATETIME NOT NULL,
DTEXPIRE DATETIME,
STRSUBJECT VARCHAR(255),
TXTBODY TEXT
PRIMARY KEY (GUIDMESSAGE)
)
CREATE INDEX IX_LCMESSAGES0 ON LCMESSAGES(GUIDMESSAGE)
CREATE TABLE LCRECIPIENTS
(
GUIDMESSAGE VARCHAR(40) NOT NULL,
GUIDRECIPIENT VARCHAR(40) NOT NULL,
INTVISITED INTEGER NOT NULL,
INTDELETED INTEGER NOT NULL
PRIMARY KEY (GUIDMESSAGE, GUIDRECIPIENT),
FOREIGN KEY (GUIDMESSAGE) REFERENCES LCMESSAGES(GUIDMESSAGE)
)
CREATE INDEX IX_LCRECIPIENTS0 ON LCRECIPIENTS(GUIDRECIPIENT)
CREATE TABLE LCMAPAPP
(
STRAPPGUID VARCHAR(40),
STRTARGETGUID VARCHAR(40)
PRIMARY KEY (STRAPPGUID)
)
-
ClassDescriptionBase class for filters that implements some default behaviour.Filter by applications by GUIDs.A filter for messages that belong or do not belong to an application.Deprecated.Deprecated.Use
AppGuidNullFilter
instead.Order messages by application GUID and creation time.Order messages by their creation timestamp.This filter actually performs no filtering.Used for news filtering on collection and / or database level.Handles messages that exist beyond application scope.Filters messages that have not expired yet.Filter by application GUID.Deprecated.UseSingleAppGuidFilter
instead.
AppGuidFilter
instead.