DataPublicPoC < CF

CF Web>DataPublicPoC (2015-04-29, BillInce) (raw view)

---+ CSCF Data -- Point of Contact

The data describing the [[https://cs.uwaterloo.ca/cscf/about/contact][CSCF Points of Contact]]
is maintained in three places.

---++ Research
For research, the data  resides in the [[https://odyssey.uwaterloo.ca/sub/][Research Subscriptions]] system.
It's unlikely it will reside elsewhere.

---++ Staff
For staff, the data resides in the [[https://cs.uwaterloo.ca/cscf/about/contact][CSCF Points of Contact]] WWW page.
We can imagine it moving into the same database as the Teaching data (below).

---++ Teaching (courses)
For course support, the data resides in the postgres.cs database.
Is it accessible via:
<blockquote>
<br>Host: postgres.cs
<br>Database: postgres
<br>User: _cscf_web

<pre>
                                                Table "_cscf.point_of_contact"
 Column |    Type     | Modifiers | Storage  |                                  Description
--------+-------------+-----------+----------+--------------------------------------------------------------------------------
 userid | text        | not null  | extended | the WatIam userid (8 characters) of the person who is a Point of Contact (PoC)
 type   | client_type | not null  | plain    | who or what the "client" is
 client | text        | not null  | extended | who or what "userid" is the PoC for.
Indexes:
    "point_of_contact_pkey" PRIMARY KEY, btree (userid, type, client)


 Schema |    Name     | Internal name | Size | Elements |                                   Description
--------+-------------+---------------+------+----------+----------------------------------------------------------------------------------
 _cscf  | client_type | client_type   | 4    | course  +| the client, group of clients, or activity that one can be a Point of Contact for
        |             |               |      | userid   |

</pre></blockquote>

An example of the data:
<blockquote><pre>
postgres=> select * from _cscf.point_of_contact order by client limit 4;
  userid  |  type  | client 
----------+--------+--------
 echrzano | course | CS100
 echrzano | course | CS115
 echrzano | course | CS116
 echrzano | course | CS135
</pre></blockquote>

An example of adding to the data:
<blockquote><pre>
% psql -h postgres.cs -d postgres 
psql (9.3.5, server 9.2.6)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.

postgres=> set role to _cscf_root; 
SET
postgres=> set search_path to _cscf, public; 
SET
postgres=> insert into point_of_contact (userid, type, client) values ('omnafees', 'course', 'CS492');
INSERT 0 1
postgres=> insert into point_of_contact (userid, type, client) values ('omnafees', 'course', 'CS692');
INSERT 0 1
postgres=> \q
</pre></blockquote>

An example of updating the data:
<blockquote><pre>
% psql -h postgres.cs -d postgres 
psql (9.3.5, server 9.2.6)
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
Type "help" for help.

postgres=> set role to _cscf_root; 
SET
postgres=> set search_path to _cscf, public; 
SET
postgres=> update point_of_contact set userid = 'omnafees' where client = 'CS137';
UPDATE 1
postgres=> update point_of_contact set userid = 'fhgunn' where client = 'CS492';
UPDATE 1
postgres=> \q
</pre></blockquote>

The above examples assume the invoker can assume the <tt>_cscf_root</tt> role.

The [[https://cs.uwaterloo.ca/cscf/teaching/contact][course points of contact WWW page]]
uses userid "cscf-dat" to control access to the "_cscf_web" password
which is needed to read the data,
as described in the [[https://cs.uwaterloo.ca/twiki/view/CF/DataPublicAccess][general approach to access of public data]].

Topic revision: r4 - 2015-04-29 - BillInce

Information in this area is meant for use by CSCF staff and is not official documentation, but anybody who is interested is welcome to use it if they find it useful.

Other Webs

My links
- People
- CERAS
- WatForm
- Tetherless lab
- Ubuntu Main.HowTo
- eDocs
- RGG NE notes
- RGG
- CS infrastructure
- Grad images

Edit