Bug 1885718 - Review Request: profile-cleaner - Script to vacuum and reindex sqlite databases used by Firefox and by Chrome
Summary: Review Request: profile-cleaner - Script to vacuum and reindex sqlite databas...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora
Classification: Fedora
Component: Package Review
Version: rawhide
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Andy Mender
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2020-10-06 19:35 UTC by Artem
Modified: 2020-10-23 22:11 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2020-10-12 00:39:39 UTC
Type: ---
Embargoed:
andymenderunix: fedora-review+


Attachments (Terms of Use)

Description Artem 2020-10-06 19:35:45 UTC
Spec URL: https://atim.fedorapeople.org//profile-cleaner.spec
SRPM URL: https://atim.fedorapeople.org//profile-cleaner-2.41-1.fc33.src.rpm

Description:
Use profile-cleaner to reduce the size of browser profiles by organizing their
sqlite databases using sqlite3's vacuum and reindex functions. The term
"browser" is used loosely since profile-cleaner happily works on some email
clients and newsreaders too.

Comment 1 Artem 2020-10-06 19:35:48 UTC
This package built on koji:  https://koji.fedoraproject.org/koji/taskinfo?taskID=52885884

Comment 2 Artem 2020-10-06 19:36:36 UTC
Could be very useful for BTRFS since this is default FS now for Fedora 33.

Comment 3 Andy Mender 2020-10-11 11:57:38 UTC
> %files
> %doc README.md
> %license LICENSE
> %{_bindir}/%{name}
> %{_bindir}/pc
> %dir %{_datadir}/zsh/site-functions/
> %{_datadir}/zsh/site-functions/_pc

Package must own %{_datadir/zsh/ or Requires zsh. I'd recommend the former, since zsh is probably not needed for its functionality.

The rest looks okay. You can fix above on import. Package approved. Full review below:

Package Review
==============

Legend:
[x] = Pass, [!] = Fail, [-] = Not applicable, [?] = Not evaluated
[ ] = Manual review needed



===== MUST items =====

Generic:
[x]: Package successfully compiles and builds into binary rpms on at least
     one supported primary architecture.
     Note: Using prebuilt packages
[x]: Package is licensed with an open-source compatible license and meets
     other legal requirements as defined in the legal section of Packaging
     Guidelines.
[x]: License field in the package spec file matches the actual license.
     Note: Checking patched sources after %prep for licenses. Licenses
     found: "Unknown or generated", "Expat License". 7 files have unknown
     license. Detailed output of licensecheck in
     /home/amender/rpmbuild/SPECS/profile-cleaner/profile-
     cleaner/licensecheck.txt
[x]: Package must own all directories that it creates.
     Note: Directories without known owners: /usr/share/zsh
     Review: Own it or add a Requires on "zsh".
[x]: Package contains no bundled libraries without FPC exception.
[x]: Changelog in prescribed format.
[x]: Sources contain only permissible code or content.
[-]: Package contains desktop file if it is a GUI application.
[-]: Development files must be in a -devel package
[x]: Package uses nothing in %doc for runtime.
[x]: Package consistently uses macros (instead of hard-coded directory
     names).
[x]: Package is named according to the Package Naming Guidelines.
[x]: Package does not generate any conflict.
[x]: Package obeys FHS, except libexecdir and /usr/target.
[-]: If the package is a rename of another package, proper Obsoletes and
     Provides are present.
[x]: Requires correct, justified where necessary.
[x]: Spec file is legible and written in American English.
[-]: Package contains systemd file(s) if in need.
[x]: Package is not known to require an ExcludeArch tag.
[-]: Large documentation must go in a -doc subpackage. Large could be size
     (~1MB) or number of files.
     Note: Documentation size is 10240 bytes in 1 files.
[x]: Package complies to the Packaging Guidelines
[x]: Package installs properly.
[x]: Rpmlint is run on all rpms the build produces.
     Note: There are rpmlint messages (see attachment).
[x]: If (and only if) the source package includes the text of the
     license(s) in its own file, then that file, containing the text of the
     license(s) for the package is included in %license.
[x]: Package requires other packages for directories it uses.
[x]: Package does not own files or directories owned by other packages.
[x]: Package uses either %{buildroot} or $RPM_BUILD_ROOT
[x]: Package does not run rm -rf %{buildroot} (or $RPM_BUILD_ROOT) at the
     beginning of %install.
[x]: Macros in Summary, %description expandable at SRPM build time.
[x]: Dist tag is present.
[x]: Package does not contain duplicates in %files.
[x]: Permissions on files are set properly.
[x]: Package must not depend on deprecated() packages.
[x]: Package use %makeinstall only when make install DESTDIR=... doesn't
     work.
[x]: Package is named using only allowed ASCII characters.
[x]: Package does not use a name that already exists.
[x]: Package is not relocatable.
[x]: Sources used to build the package match the upstream source, as
     provided in the spec URL.
[x]: Spec file name must match the spec package %{name}, in the format
     %{name}.spec.
[x]: File names are valid UTF-8.
[x]: Packages must not store files under /srv, /opt or /usr/local

===== SHOULD items =====

Generic:
[x]: Reviewer should test that the package builds in mock.
[-]: If the source package does not include license text(s) as a separate
     file from upstream, the packager SHOULD query upstream to include it.
[x]: Final provides and requires are sane (see attachments).
[?]: Package functions as described.
[x]: Latest version is packaged.
[x]: Package does not include license text files separate from upstream.
[-]: Sources are verified with gpgverify first in %prep if upstream
     publishes signatures.
     Note: gpgverify is not used.
[-]: Description and summary sections in the package spec file contains
     translations for supported Non-English languages, if available.
[x]: Package should compile and build into binary rpms on all supported
     architectures.
[-]: %check is present and all tests pass.
[x]: Packages should try to preserve timestamps of original installed
     files.
[x]: Buildroot is not present
[x]: Package has no %clean section with rm -rf %{buildroot} (or
     $RPM_BUILD_ROOT)
[x]: No file requires outside of /etc, /bin, /sbin, /usr/bin, /usr/sbin.
[x]: Packager, Vendor, PreReq, Copyright tags should not be in spec file
[x]: Sources can be downloaded from URI in Source: tag
[x]: SourceX is a working URL.
[x]: Spec use %global instead of %define unless justified.

===== EXTRA items =====

Generic:
[x]: Rpmlint is run on all installed packages.
     Note: No rpmlint messages.


Rpmlint
-------
Checking: profile-cleaner-2.41-1.fc34.noarch.rpm
          profile-cleaner-2.41-1.fc34.src.rpm
profile-cleaner.noarch: W: spelling-error Summary(en_US) reindex -> re index, re-index, reindeer
profile-cleaner.noarch: W: spelling-error %description -l en_US reindex -> re index, re-index, reindeer
profile-cleaner.src: W: spelling-error Summary(en_US) reindex -> re index, re-index, reindeer
profile-cleaner.src: W: spelling-error Summary(en_US) sqlite -> sq lite, sq-lite, satellite
profile-cleaner.src: W: spelling-error %description -l en_US sqlite -> sq lite, sq-lite, satellite
profile-cleaner.src: W: spelling-error %description -l en_US reindex -> re index, re-index, reindeer
2 packages and 0 specfiles checked; 0 errors, 6 warnings.




Rpmlint (installed packages)
----------------------------
0 packages and 0 specfiles checked; 0 errors, 0 warnings.
(none): E: no installed packages by name profile-cleaner



Source checksums
----------------
https://github.com/graysky2/profile-cleaner/archive/v2.41/profile-cleaner-2.41.tar.gz :
  CHECKSUM(SHA256) this package     : e1bfa86143db5cde50e90118b2d7ade7b58bea155a85ebceffec57e7d79795da
  CHECKSUM(SHA256) upstream package : e1bfa86143db5cde50e90118b2d7ade7b58bea155a85ebceffec57e7d79795da


Requires
--------
profile-cleaner (rpmlib, GLIBC filtered):
    /usr/bin/bash
    bc
    findutils
    parallel
    sqlite



Provides
--------
profile-cleaner:
    profile-cleaner

Comment 4 Gwyn Ciesla 2020-10-11 19:02:06 UTC
(fedscm-admin):  The Pagure repository was created at https://src.fedoraproject.org/rpms/profile-cleaner

Comment 5 Fedora Update System 2020-10-11 19:36:08 UTC
FEDORA-2020-eb8e35a122 has been submitted as an update to Fedora 33. https://bodhi.fedoraproject.org/updates/FEDORA-2020-eb8e35a122

Comment 6 Fedora Update System 2020-10-11 19:44:30 UTC
FEDORA-2020-5702ae59d9 has been submitted as an update to Fedora 32. https://bodhi.fedoraproject.org/updates/FEDORA-2020-5702ae59d9

Comment 7 Fedora Update System 2020-10-11 19:50:03 UTC
FEDORA-2020-5a0d7aa9d1 has been submitted as an update to Fedora 31. https://bodhi.fedoraproject.org/updates/FEDORA-2020-5a0d7aa9d1

Comment 8 Artem 2020-10-11 19:59:24 UTC
Thanks. Fixed and pushed to testing.

Comment 9 Fedora Update System 2020-10-11 22:32:11 UTC
FEDORA-2020-eb8e35a122 has been pushed to the Fedora 33 testing repository.
In short time you'll be able to install the update with the following command:
`sudo dnf install --enablerepo=updates-testing --advisory=FEDORA-2020-eb8e35a122 \*`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2020-eb8e35a122

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 10 Fedora Update System 2020-10-12 00:39:39 UTC
FEDORA-2020-5702ae59d9 has been pushed to the Fedora 32 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 11 Fedora Update System 2020-10-12 01:04:02 UTC
FEDORA-2020-5a0d7aa9d1 has been pushed to the Fedora 31 testing repository.
In short time you'll be able to install the update with the following command:
`sudo dnf install --enablerepo=updates-testing --advisory=FEDORA-2020-5a0d7aa9d1 \*`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2020-5a0d7aa9d1

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 12 Fedora Update System 2020-10-19 17:03:51 UTC
FEDORA-2020-5a0d7aa9d1 has been pushed to the Fedora 31 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 13 Fedora Update System 2020-10-23 22:11:51 UTC
FEDORA-2020-eb8e35a122 has been pushed to the Fedora 33 stable repository.
If problem still persists, please make note of it in this bug report.


Note You need to log in before you can comment on or make changes to this bug.