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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
# csvfile.py - plugin to generate a CSV file of visited urls
#
# Copyright (C) 2013 Arthur de Jong
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
#
# The files produced as output from the software do not automatically fall
# under the copyright of the software, unless explicitly stated otherwise.
"""generate a CSV file of visited urls."""
__title__ = 'CSV file'
__author__ = 'Arthur de Jong'
__outputfile__ = 'urls.csv'
import csv
from webcheck.db import Session, Link
from webcheck.output import open_file
def _conv(value):
if value is None:
return ''
if isinstance(value, int):
return str(value)
if isinstance(value, unicode):
return value.encode('utf-8')
if hasattr(value, 'isoformat'):
return value.isoformat()
return value
def generate(crawler):
"""Output a sorted list of URLs."""
session = Session()
links = session.query(Link).order_by(Link.url)
writer = csv.writer(open_file(__outputfile__, is_text=False))
writer.writerow((
'URL', 'Title', 'Depth', 'Internal', 'Fetched', 'Status',
'Size'))
# TODO: add number of parents and number of clildren/embedded
# TODO: add linkproblems and pageproblems
for link in links:
row = (
link.url, link.title, link.depth,
'internal' if link.is_internal else 'external',
link.fetched or link.yanked, link.status, link.size)
writer.writerow([_conv(x) for x in row])
session.close()
|