CUPID

From Informatics

Jump to: navigation, search

CUPID project includes two parts:

  1. CUPID servlet. This is a simple servlet that channels the query to the CUPIC database and returns the result as a plain text table.
    The source code is in C2B2 CVS as of September 2011.
  2. CUPID component in geWorkbench. It has a simple GUI to connect to the servlet. The code is part of geWorkbench code repository.

Link to the ISCRE wiki about CUPID

geWorkbench component implementation

  • this is a simple GUI that communicates with the servlet. The host name where the servlet is deployed is set in application.properties

database:

  • database name: cupid; table name: cupid, user name: cupid_ro
  • development db: afdev:3306; production db: mysql.c2b2.columbia.edu:3306
  • user cupid_ro's passwords: on record

Servlet Deployment:

  • The development version is deployed on afdev. (I tested with geWorkbench today (9/23/2013) and it is responding properly.)
  • The production is going to be deployed on the same tomcat as CNKB servlet is deployed on because it is readily open to public.

Test cases:

  • in geWorkbench's CUPID interface, choose Query Type "RefSeq ID", and enter Query Value "NM_000034", click on "Submit" and you will get a result of about 200 rows.

Servlet Implementation:

  • the entire implemenation is only one class called CupidServlet that extends Servlet, and one jar file to support mysql connection
  • Code repository:
    • CVS at login.c2b2.columbia.edu:/cvs/magnet/geworkbench/CupidServlet
Retrieved from "http://wiki.c2b2.columbia.edu/informatics/index.php/CUPID"
Personal tools