Return to SQL_TODO CVS log

Up to [Public] / rpm2html

Annotation of rpm2html/SQL_TODO, revision 1.4

1.1       veillard    1:    WISH/TOOLS
                      2: 
                      3: - import from rsync or mirrors logs
                      4: - Check for signatures, add an Authenticate base
1.4     ! veillard    5: - relink mirrorfind with the SQL database support and add a mirror
        !             6:   checking tool as well as an accuracy level in the mirrors entries
1.1       veillard    7: 
                      8:    TODO
                      9: 
                     10: - Add Peoples with more fields than purely the fields found
                     11:   form the RPM informations (PGP keys, email, URL, ...)
                     12: - Add missing fields to the Distribs base (color ...)
1.3       veillard   13: - add export functions for config files from the database
                     14: - use and propagate distribution informations when browsing
                     15:   a subtree.
                     16: 
                     17:    DONE
                     18: 
                     19: - lookup daemon searching for expired files
                     20:   sql check implement the search
                     21: - add Requires, again interesting queries like the following work:
                     22:   select Packages.Name,Packages.Version,Packages.Release
                     23:     from Packages,Requires
                     24:     where Requires.Resource='libxml2' and Requires.ID=Packages.ID;
1.1       veillard   25: - add Provides
                     26: - add functions to delete from the database:
                     27:   sql_remove_package() with id or path key, propagating to 
                     28:                       Files and Requires
                     29:   cleanup of tables
                     30: - add cleanup from the sql command line tool
1.2       veillard   31: - add import function from RDF files
1.1       veillard   32: - added Files, starting to be able to do interesting queries:
                     33:   Select Packages.Name,Packages.Version,Packages.Release from
                     34:          Packages,Files where Files.Path='/usr/bin/xml-config' and
                     35:          Packages.ID=Files.ID and Packages.Version >='2.0.0';
                     36:   I was afraid of the speed requirements for the inserts, but
                     37:   not it looks Okay.
                     38: - added Mirrors base
                     39: - added Metadata base
                     40: - added capacity to launch rpm2html from the database instead of
                     41:   the configuration file 9the DB contains those).
                     42: - added automatic import of configuration/distribution informations
                     43: - started playing adding a Vendor table filled with RedHat