GitLab

Rationalized some file names: site_*.urls -> *_cases.urls; *normal* become *show* .

Comment out an assert that has no purpose than to incorrectly trigger
on OpenBSD.

correctly now.

* install/dump-descriptors <filename> will write out a set of insert
  statements for the images and os_info table, slightly munged. In
  fact, what I do is create temporary tables called temp_images and
  temp_os_info, clean them a bit, and then write out the insert
  statements to load them into new tables of the same name.

  There are some arrays at the top of this script that says what images and
  osids to write out.

* install/load-descriptors <filename> takes the output of
  dump-descriptors, creates the two temporary tables and loads the
  data into them. Then it (optionally) updates those tables with the
  local indicies of elabman and the emulab-ops project and group.

  Then it computes an osidtoimageid table for all class='pc' types. On a
  new testbed this is a reasonable approach, in my opinion.

  Next it takes the contents of the two temp tables and moves them across
  to the actual tables.

* install/descriptors.sql is the current data set which has everything
  contained in sql/database-fill-supplemental.sql and install/images/*

will get printed out before execution.

importantly, fix several places where inserts were using %d as argument
placeholders in queries.  When using the MySQLdb module in python, you
can only use %s as a placeholder in "prepared" queries---the module looks
at the types of the values to see how to format them in the query.  This
behavior is insidious and contrary to the python standard DB interface
documentation, but that's how it is.

happening when I moved the email generation from the web interface to the
backend.

that happened in a dream.

Actually, you can still use pid and gid, but the new format for all
scripts will be to use either idx, pid,gid (pid,eid), or pid/gid
(pid/eid). Consistency is good.

Lbs

indexed by exptidx. I also got the last of the pid and pid,gid tables.

It sets project_root trust for the project leader on the default group
of the project.  approveproject will eventually call mkproj, and that
calls modgroups to add the project leader trust.

@ Berkeley.