diff options
author | B. Watson <yalhcru@gmail.com> | 2021-06-23 17:25:03 -0400 |
---|---|---|
committer | B. Watson <yalhcru@gmail.com> | 2021-06-23 17:25:03 -0400 |
commit | 44be4bb654e313344a427f35a527de3e636f4a61 (patch) | |
tree | e9509375a2063c639e1c518c1813221cb99ee424 /bin | |
parent | 2bbcfce248f12cf570c0e3c3aa706ccc85ef5597 (diff) | |
download | limnoria.slackfacts.plugins-44be4bb654e313344a427f35a527de3e636f4a61.tar.gz |
Add SBoTools plugin (needs a lot more work)
Diffstat (limited to 'bin')
-rwxr-xr-x | bin/sbodb.pl | 123 |
1 files changed, 123 insertions, 0 deletions
diff --git a/bin/sbodb.pl b/bin/sbodb.pl new file mode 100755 index 0000000..bfd997e --- /dev/null +++ b/bin/sbodb.pl @@ -0,0 +1,123 @@ +#!/usr/bin/perl -w + +# create SBo.sqlite3 database for SBo limnoria plugin. +# requires SLACKBUILDS.txt and TAGS.txt from the SBo repo. +# https://slackware.uk/slackbuilds.org/14.2/SLACKBUILDS.TXT +# https://slackware.uk/slackbuilds.org/14.2/TAGS.txt + +print <<EOF; +pragma journal_mode = memory; +begin transaction; + +create table categories ( + id integer primary key not null, + name varchar not null); + +create table builds ( + id integer primary key not null, + name varchar not null, + descrip varchar not null, + category integer not null, + version varchar not null, + foreign key (category) references categories); + +create table deps ( + build_id integer not null, + depends_on integer not null, + foreign key (build_id) references categories, + foreign key (depends_on) references categories); + +create table tags ( + build_id integer not null, + tag varchar not null, + foreign key (build_id) references builds); + +create unique index t_idx on tags(build_id, tag); + +EOF + +$lastcat = 0; +sub get_cat_id { + my $catname = shift; + if(!$catids{$catname}) { + $lastcat++; + print "insert into categories values($lastcat, '$catname');\n"; + $catids{$catname} = $lastcat; + } + return $catids{$catname}; +} + +open $sbtxt, "<" . ($ARGV[0] || "SLACKBUILDS.TXT") or die $!; +{ + local $/ = ''; + while(<$sbtxt>) { + my ($name, $cat, $ver, $deps, $desc,); + $deps = ""; + chomp; + /^SLACKBUILD NAME:\s+(\S+)$/m and $name = $1; + /^SLACKBUILD LOCATION:\s+\.\/([^\/]*)\//m and $cat = $1; + /^SLACKBUILD VERSION:\s+(\S+)$/m and $ver = $1; + /^SLACKBUILD REQUIRES:\s+(\S.+)\n/m and $deps = $1; + /^SLACKBUILD SHORT DESCRIPTION:\s+(.+)$/m and $desc = $1; + + if($desc =~ /^$name \((.+)\)$/) { + $desc = $1; + } + + $desc =~ s/'/''/g; + $catid = get_cat_id($cat); + $buildcat{$name} = $catid; + $buildver{$name} = $ver; + $builddeps{$name} = $deps; + $builddesc{$name} = $desc; + push @builds, $name; + } +} +close $sbtxt; + +print "\n"; + +$buildid = 0; +for(@builds) { + $buildid++; + $buildids{$_} = $buildid; + print <<EOF; +insert into builds values( + $buildid, + '$_', + '$builddesc{$_}', + $buildcat{$_}, + '$buildver{$_}'); + +EOF +} + +for(keys %builddeps) { + my $bid = $buildids{$_}; + my @d = split /\s+/, $builddeps{$_}; + #warn "build $_ id $b, deps " . join(",", @d) . "\n"; + for(@d) { + next if /%README%/; + print <<EOF; +insert into deps values($bid, $buildids{$_}); +EOF + } +} + +open $tagstxt, "<" . ($ARGV[1] || "TAGS.txt") or die $!; +while(<$tagstxt>) { + my ($build, $t, @tags); + chomp; + next if /: No tags found for/; + ($build, $t) = /^([^:]*):\s+(.*)$/; + @tags = split /,/, $t; + for(@tags) { + next if /^\s*$/; + s/'/''/g; + print <<EOF; +insert into tags values($buildids{$build}, '$_'); +EOF + } +} + +print "commit;\n"; |