search

ncats / RDAS

5 stars 7 forks source link

Convert isEpi to boolean #2

Closed wzkariampuzha closed 2 years ago

wzkariampuzha commented 2 years ago

Currently isEpi is a property of article node that is either string 'Y' or empty. Convert it to a Boolean and rewrite the example Cypher query

wzkariampuzha commented 2 years ago

Also run this/future ones through the API

wzkariampuzha commented 2 years ago

The existing DB can be modified using:

MATCH (n:Article) WHERE n.isEpi = "Y"
SET n.isEpi = True
RETURN n

and

MATCH (n:Article) WHERE n.isEpi IS NULL AND n.abstractText IS NOT NULL
SET n.isEpi = False
RETURN n

The article nodes without abstract text will be left as null