« Number of assets per item in AgEcon | Main | Handles of items that have been withdrawn from DSPACE Instance of UDC »

Fields in DSPACE eperson table that are empty, fixed or small

Fields in DSPACE eperson table

 dspace_sr=> \d eperson   
                    Table "public.eperson"
       Column        |            Type             | Modifiers 
---------------------+-----------------------------+-----------
 eperson_id          | integer                     | not null
 email               | character varying(64)       | 
 password            | character varying(64)       | 
 firstname           | character varying(64)       | 
 lastname            | character varying(64)       | 
 can_log_in          | boolean                     | 
 require_certificate | boolean                     | 
 self_registered     | boolean                     | 
 last_active         | timestamp without time zone | 
 sub_frequency       | integer                     | 
 phone               | character varying(32)       | 
 netid               | character varying(64)       | 
Indexes:
    "eperson_pkey" primary key, btree (eperson_id)
    "eperson_email_key" unique, btree (email)
    "eperson_email_idx" btree (email)
    "eperson_netid_idx" btree (netid)

SQL to check for empty fields

field: last_active

dspace_sr=> select last_active   from eperson where last_active ~ '.*';
 last_active 
-------------
(0 rows)
last_active is empty

field: netid

dspace_sr=> select netid  from eperson where netid~'.*';
 netid 
-------------
(0 rows)
last_active is netid

field: require_certificate are all false

dspace_sr=> select require_certificate   from eperson where require_certificate = 't';
 require_certificate 
---------------------
(0 rows)

field: can_log_in are all true

dspace_sr=> select can_log_in  from eperson where can_log_in = 'f' ;
 can_log_in 
------------
(0 rows)

field: can_log_in are all true

dspace_sr=> select can_log_in  from eperson where can_log_in = 'f' ;
 can_log_in 
------------
(0 rows)

field: self_registered is a small group

dspace_sr=> select *    from eperson where self_registered = 'f' ;
 eperson_id |       email        |             password             | firstname | lastname | can_log_in | require_certificate | self_registered | last_active | sub_frequency | phone | netid 
------------+--------------------+----------------------------------+-----------+----------+------------+---------------------+-----------------+-------------+---------------+-------+-------
          1 | teale003@umn.edu   | 76419c58730d9f35de7ac538c2fd6737 | Brad      | Teale    | t          | f                   | f               |             |               |       | 
          3 | jkelly@umn.edu     | 1a9bb0d26640ffb18ee06ae398d201ad | Julia     | Kelly    | t          | f                   | f               |             |               |       | 
          5 | skill@umn.edu      | fa483ad4f1d094e0d5aaa31856d618ec | Sharon    | Kill     | t          | f                   | f               |             |               |       | 
         21 | ruddy005@gmail.com | f850f3fb454e369b8b3444ad66fcd469 | Martha    | Ruddy    | t          | f                   | f               |             |               |       | 
          2 | lletnes@umn.edu    | a8113a9b4f61b178cd1fea4efa5bf4c8 | Louise    | Letnes   | t          | f                   | f               |             |               |       | 
         15 | jsilvis@umn.edu    | 7f8b6712b097089167df2fd678ae8133 | Jeff      | Silvis   | t          | f                   | f               |             |               |       | 
(6 rows)

These people were put in by a bash script.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)