Return to SQL_TODO CVS log

Up to [Public] / rpm2html

Annotation of rpm2html/SQL_TODO, revision 1.1

1.1     ! veillard    1:    WISH/TOOLS
        !             2: 
        !             3: - lookup daemon searching for expired files
        !             4: - import from rsync or mirrors logs
        !             5: - Check for signatures, add an Authenticate base
        !             6: 
        !             7:    TODO
        !             8: 
        !             9: - Add Peoples with more fields than purely the fields found
        !            10:   form the RPM informations (PGP keys, email, URL, ...)
        !            11: - Add missing fields to the Distribs base (color ...)
        !            12: - add Requires
        !            13: - add Provides
        !            14: - add functions to delete from the database:
        !            15:   sql_remove_package() with id or path key, propagating to 
        !            16:                       Files and Requires
        !            17:   cleanup of tables
        !            18: - add cleanup from the sql command line tool
        !            19: - add export functions for config files from the database
        !            20: 
        !            21:    DONE
        !            22: 
        !            23: - added Files, starting to be able to do interesting queries:
        !            24:   Select Packages.Name,Packages.Version,Packages.Release from
        !            25:          Packages,Files where Files.Path='/usr/bin/xml-config' and
        !            26:          Packages.ID=Files.ID and Packages.Version >='2.0.0';
        !            27:   I was afraid of the speed requirements for the inserts, but
        !            28:   not it looks Okay.
        !            29: - added Mirrors base
        !            30: - added Metadata base
        !            31: - added capacity to launch rpm2html from the database instead of
        !            32:   the configuration file 9the DB contains those).
        !            33: - added automatic import of configuration/distribution informations
        !            34: - started playing adding a Vendor table filled with RedHat