« November 2011 | Main | February 2012 »

December 16, 2011

Handles of items that have been withdrawn from DSPACE Instance of UDC

dspace_ir=> select handle  from item,handle   where resource_id=item_id AND resource_type_id =2 AND withdrawn='t';
 handle 
--------
 59457
 59456
 91897
 59624
 52302
 52304
 1417
 59224
 1564
 1556
 1597
 59696
 52294
 52295
 54922
 1635
 1652
 1641
 1642
 1634
 1654
 1643
 1640
 1638
 1650
 1648
 1639
 1637
 1636
 1631
 1632
 47185
 1693
 1657
 1700
 1656
 1667
 1699
 1666
 57139
 56283
 1714
 1713
 53967
 1962
 1959
 1924
 1941
 1917
 1921
 1956
 1945
 235
 52291
 52301
 52293
 52303
 52305
 52306
 2140
 4308
 2255
 4071
 52308
 2342
 4252
 2421
 2411
 2424
 2420
 2423
 4396
 47036
 3992
 4122
 2610
 2599
 2614
 46794
 2779
 2870
 2851
 2880
 5763
 56296
 3226
 3393
 3391
 3394
 3422
 48945
 3468
 4948
 5022
 5027
 1056
 1149
 1072
 56320
 54792
 59699
 4183
 47738
 4459
 4468
 57299
 4489
 4576
 57302
 92517
 45722
 4779
 4842
 4781
 53859
 4862
 4886
 4848
 4429
 50922
 56358
 103371
 5866
 4997
 57063
 53867
 5141
 57052
 104500
 57199
 57141
 107249
 109941
 100004
 97262
 98554
 50549
 48018
 104356
(139 rows)

December 15, 2011

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.