df2SQLite: Store drugbank dataframe into an SQLite database

In yduan004/drugbankR: R package for querying DrugBank database in batch locally

Description

Store specific version of drugbank dataframe into an SQLite database under user's present working directory of R session

Usage

df2SQLite(dbdf, version)

Arguments

dbdf	Drugbank dataframe generated by dbxml2df function.
version	Character(1), version of the input drugbank dataframe generated by dbxml2df function

Value

SQLite database (drugbank_versionNumber.db) stored under user's present working directory of R session

Author(s)

Yuzhu Duan [e-mail]

See Also

dbxml2df

Examples

## Not run: 

# download the original drugbank database (http://www.drugbank.ca/releases/latest) (xml file) 
# to your current R working directory, and rename as drugbank.xml.
# Read in the xml file and convert to a data.frame in R 

drugbank_dataframe = dbxml2df(xmlfile="drugbank.xml", version="5.1.3")

# store the converted drugbank dataframe into SQLite database under user's
present R working direcotry

df2SQLite(dbdf=drugbank_dataframe, version="5.1.3") # set version as version of xml file

## End(Not run)

yduan004/drugbankR documentation built on Aug. 10, 2021, 5:21 p.m.