Return to SQL_TODO CVS log

Up to [Public] / rpm2html

Annotation of rpm2html/SQL_TODO, revision 1.2

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
1.2     ! veillard   20: - add import function from RDF files
1.1       veillard   21: 
                     22:    DONE
                     23: 
                     24: - added Files, starting to be able to do interesting queries:
                     25:   Select Packages.Name,Packages.Version,Packages.Release from
                     26:          Packages,Files where Files.Path='/usr/bin/xml-config' and
                     27:          Packages.ID=Files.ID and Packages.Version >='2.0.0';
                     28:   I was afraid of the speed requirements for the inserts, but
                     29:   not it looks Okay.
                     30: - added Mirrors base
                     31: - added Metadata base
                     32: - added capacity to launch rpm2html from the database instead of
                     33:   the configuration file 9the DB contains those).
                     34: - added automatic import of configuration/distribution informations
                     35: - started playing adding a Vendor table filled with RedHat