{'Channel': 'VARCHAR(255) NOT NULL', 'Url': 'VARCHAR(512)', 'Description': 'TEXT', 'Package': 'VARCHAR(255)', 'Module': 'VARCHAR(255)', 'PRIMARY_KEY': 'Channel'}
{'Channel': 'VARCHAR(255)', 'Title': 'VARCHAR(255)', 'Link': 'VARCHAR(512)', 'Description': 'TEXT', 'Guid': 'VARCHAR(255) NOT NULL', 'PubDate': 'DATETIME', 'RssLink': 'VARCHAR(512) NOT NULL', 'CreateDate': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'LocalGuid': 'VARCHAR(64)', 'Package': 'VARCHAR(255)', 'Module': 'VARCHAR(255)', 'PRIMARY_KEY': 'Guid, RssLink'}
INSERT INTO def_rss
(Channel, Url, Description, Package, Module)
VALUES
('{channel}', '{url}', '{description}',
'{package}', 'ObjServiceRss')
ON DUPLICATE KEY UPDATE
Url = VALUES(Url),
Description = VALUES(Description)
INSERT IGNORE INTO data_rssitem
(Channel, Title, Link, Description, Guid,
PubDate, RssLink, CreateDate, LocalGuid,
Package, Module)
VALUES
('{channel}', '{title}', '{link}',
'{description}', '{guid}',
'{pubdate}', '{rss_link}', NOW(),
'{local_guid}', '{package}',
'ObjServiceRss')
SELECT Guid FROM data_rssitem WHERE RssLink = '{rss_link}'
AND Guid = '{guid}'
SELECT Channel, Url, Description FROM def_rss WHERE Package = '{package}'
OR Package IS NULL
ORDER BY Channel
SELECT LocalGuid, Channel, Title, Link,
Description, PubDate, CreateDate
FROM data_rssitem WHERE Channel LIKE '{channel}%'
AND (Package = '{package}' OR Package IS NULL)
ORDER BY PubDate DESC LIMIT {limit}
SELECT LocalGuid, Channel, Title, Link,
PubDate
FROM data_rssitem WHERE Package = '{package}'
OR Package IS NULL
ORDER BY PubDate DESC LIMIT {limit}
SELECT * FROM data_rssitem WHERE LocalGuid = '{local_guid}'