-
Notifications
You must be signed in to change notification settings - Fork 0
/
README
29 lines (22 loc) · 1.42 KB
/
README
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
This python script takes a list of tv shows, scrapes thetvdb.com and the xbmc mysql db, and creates a list of missing episodes.
It then uses BeautifulSoup to search various sitesfor these episodes, and adds them to deluge via the deluge rpc interface.
Spiderbro can be configured to use either an xbmc sqlite db or an xbmc mysql db - future versions may use the xbmc rpc interface
As of V 1.2.0, spiderbro uses an internal sqlite db with the following schema:
The schema has two tables, urls_seen and shows
urls_seen takes the form:
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| showname | varchar(64) | NO | | NULL | |
| episode | integer | NO | | NULL | |
| season | integer | NO | | NULL | |
| url | varchar(64) | NO | | NULL | |
+----------+-------------+------+-----+---------+-------+
shows takes the form:
+-----------+--------------+------+-----+---------+--------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+--------+
| series_id | integer | NO | X | NULL | |
| showname | varchar(64) | NO | | NULL | unique |
| finished | integer | NO | | NULL | |
+-----------+--------------+------+-----+---------+--------+