File: SQL_TODO

package info (click to toggle)
rpm2html 1.7-2
  • links: PTS
  • area: main
  • in suites: woody
  • size: 1,808 kB
  • ctags: 935
  • sloc: ansic: 13,013; sh: 8,491; php: 338; makefile: 204; perl: 122
file content (43 lines) | stat: -rw-r--r-- 1,722 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
   WISH/TOOLS

- import from rsync or mirrors logs
- Check for signatures, add an Authenticate base
- relink mirrorfind with the SQL database support and add a mirror
  checking tool as well as an accuracy level in the mirrors entries

   TODO

- Add Peoples with more fields than purely the fields found
  form the RPM informations (PGP keys, email, URL, ...)
- Add missing fields to the Distribs base (color ...)
- add export functions for config files from the database
- use and propagate distribution informations when browsing
  a subtree.

   DONE

- lookup daemon searching for expired files
  sql check implement the search
- add Requires, again interesting queries like the following work:
  select Packages.Name,Packages.Version,Packages.Release
    from Packages,Requires
    where Requires.Resource='libxml2' and Requires.ID=Packages.ID;
- add Provides
- add functions to delete from the database:
  sql_remove_package() with id or path key, propagating to 
		       Files and Requires
  cleanup of tables
- add cleanup from the sql command line tool
- add import function from RDF files
- added Files, starting to be able to do interesting queries:
  Select Packages.Name,Packages.Version,Packages.Release from
         Packages,Files where Files.Path='/usr/bin/xml-config' and
         Packages.ID=Files.ID and Packages.Version >='2.0.0';
  I was afraid of the speed requirements for the inserts, but
  not it looks Okay.
- added Mirrors base
- added Metadata base
- added capacity to launch rpm2html from the database instead of
  the configuration file 9the DB contains those).
- added automatic import of configuration/distribution informations
- started playing adding a Vendor table filled with RedHat