100 lines
2.8 KiB
SQL
100 lines
2.8 KiB
SQL
INSERT OR REPLACE INTO "CONFIG_RSS_PARSER" ("ID", "NAME", "TYPE", "FORMAT", "PARAMS", "NOTE", "SYSDEF") VALUES ('1', '通用', 'XML', '{
|
|
"list": "//channel/item",
|
|
"item": {
|
|
"title": {
|
|
"path": ".//title/text()"
|
|
},
|
|
"enclosure": {
|
|
"path": ".//enclosure[@type=''application/x-bittorrent'']/@url"
|
|
},
|
|
"link": {
|
|
"path": ".//link/text()"
|
|
},
|
|
"date": {
|
|
"path": ".//pubDate/text()"
|
|
},
|
|
"description": {
|
|
"path": ".//description/text()"
|
|
},
|
|
"size": {
|
|
"path": ".//link/@length"
|
|
}
|
|
}
|
|
}', '', '', 'Y');
|
|
INSERT OR REPLACE INTO "CONFIG_RSS_PARSER" ("ID", "NAME", "TYPE", "FORMAT", "PARAMS", "NOTE", "SYSDEF") VALUES ('2', '蜜柑计划', 'XML', '{
|
|
"list": "//channel/item",
|
|
"item": {
|
|
"title": {
|
|
"path": ".//title/text()"
|
|
},
|
|
"enclosure": {
|
|
"path": ".//enclosure[@type=''application/x-bittorrent'']/@url"
|
|
},
|
|
"link": {
|
|
"path": "link/text()",
|
|
"namespaces": "https://mikanani.me/0.1/"
|
|
},
|
|
"date": {
|
|
"path": "pubDate/text()",
|
|
"namespaces": "https://mikanani.me/0.1/"
|
|
},
|
|
"description": {
|
|
"path": ".//description/text()"
|
|
},
|
|
"size": {
|
|
"path": ".//enclosure[@type=''application/x-bittorrent'']/@length"
|
|
}
|
|
}
|
|
}', '', '', 'Y');
|
|
INSERT OR REPLACE INTO "CONFIG_RSS_PARSER" ("ID", "NAME", "TYPE", "FORMAT", "PARAMS", "NOTE", "SYSDEF") VALUES ('3', 'TMDB电影片单', 'JSON', '{
|
|
"list": "$.items",
|
|
"item": {
|
|
"title": {
|
|
"path": "title"
|
|
},
|
|
"year": {
|
|
"path": "release_date"
|
|
},
|
|
"type": {
|
|
"value": "movie"
|
|
}
|
|
}
|
|
}', 'api_key={TMDBKEY}&language=zh-CN', '', 'Y');
|
|
INSERT OR REPLACE INTO "CONFIG_RSS_PARSER" ("ID", "NAME", "TYPE", "FORMAT", "PARAMS", "NOTE", "SYSDEF") VALUES ('4', 'TMDB电视剧片单', 'JSON', '{
|
|
"list": "$.items",
|
|
"item": {
|
|
"title": {
|
|
"path": "name"
|
|
},
|
|
"year": {
|
|
"path": "first_air_date"
|
|
},
|
|
"type": {
|
|
"value": "tv"
|
|
}
|
|
}
|
|
}', 'api_key={TMDBKEY}&language=zh-CN', '', 'Y');
|
|
INSERT OR REPLACE INTO "CONFIG_RSS_PARSER" ("ID", "NAME", "TYPE", "FORMAT", "PARAMS", "NOTE", "SYSDEF") VALUES ('5', 'Nyaa', 'XML', '{
|
|
"list": "//channel/item",
|
|
"item": {
|
|
"title": {
|
|
"path": ".//title/text()"
|
|
},
|
|
"enclosure": {
|
|
"path": ".//link/text()"
|
|
},
|
|
"link": {
|
|
"path": ".//guid/text()"
|
|
},
|
|
"date": {
|
|
"path": ".//pubDate/text()"
|
|
},
|
|
"description": {
|
|
"path": ".//description/text()"
|
|
},
|
|
"size": {
|
|
"path": "size/text()",
|
|
"namespaces": "https://nyaa.si/xmlns/nyaa"
|
|
}
|
|
}
|
|
}', '', '', 'Y'); |