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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
#!/bin/sh
path=$(readlink -f $0)
path=$(dirname $path)
packages="$path/repository"
repos="main testing"
archs="x86 x86_64 armhf"
db="$path/db/apkindex.db"
csv="$path/csv/apkindex.csv"
turbo_db="/var/www/aports-turbo/db/apkindex.db"
read_line() {
local type=${1%%:*}
local var=${1#*:}
case "$type" in
P) name="\"$var\"" ;;
V) version="\"$var\"" ;;
T) desc="\"$var\"" ;;
U) url="\"$var\"" ;;
L) lic="\"$var\"" ;;
A) parch="\"$var\"" ;;
D) deps="\"$var\"" ;;
C) csum="\"$var\"" ;;
S) size="\"$var\"" ;;
I) install_size="\"$var\"" ;;
p) provides="\"$var\"" ;;
i) install_if="\"$var\"" ;;
o) origin="\"$var\"" ;;
m) maintainer="\"$var\"" ;;
t) build_time="\"$var\"" ;;
c) commit="\"$var\"" ;;
esac
}
reset_vars() {
name= version= desc= url= lic= parch= deps= csum= size= install_size=
provides= install_if= origin= maintainer= build_time= commit=
}
write_line() {
echo "$name,$version,$desc,$url,$lic,$parch,$deps,$csum,$size,$install_size,$provides,$install_if,$origin,$maintainer,$build_time,$commit,$repo"
}
init_db() {
rm -f $db
printf "CREATE TABLE apkindex('name' text, 'version' text, 'desc' text,
'url' text, 'lic' text, 'arch' text, 'deps' text, 'csum' text,
'size' text, 'install_size' text, 'provides' text, 'install_if' text,
'origin' text, 'maintainer' text, 'build_time' integer, 'commit' text,
'repo' text);" | sqlite3 $db
}
write_db() {
printf ".mode csv\n.import $csv apkindex" | sqlite3 $db
printf "CREATE INDEX name on apkindex (name);" | sqlite3 $db
printf "CREATE INDEX arch on apkindex (arch);" | sqlite3 $db
printf "CREATE INDEX provides on apkindex (provides);" | sqlite3 $db
printf "CREATE INDEX deps on apkindex (deps);" | sqlite3 $db
}
mv_db() {
mv $db $turbo_db
}
rm -f $csv
for repo in $repos; do
for arch in $archs; do
rm -f /tmp/APKINDEX
tar -C /tmp -zxf $packages/$repo/$arch/APKINDEX.tar.gz APKINDEX
IFS=$'\n'
while read line; do
if [ "$line" = "" ]; then
write_line >> $csv
reset_vars
fi
read_line "$line"
done</tmp/APKINDEX
unset IFS
done
done
init_db && write_db && mv_db
|