getInfoAboutMusician: Send queries to Postgres database to get relations
In aqlina/musicBox: musicBox runs Shiny App based on Postgres database

getInfoAboutMusician

R Documentation

Send queries to Postgres database to get relations

Description

Send queries to Postgres database to get relations between bands and musicians

Usage

getInfoAboutMusician(name, dbConnection)

Arguments

`name`	A `character` which is the full name of musician
`dbConnection`	A connection to Postgres database

Details

This function sends the queries to database to get musician-bands and musician-musicians relations

Value

A list of two data.frame with the relations; the first data.frame consists of one column 'band' and describes the musician-bands relation; the second data.frame consists of two 'name' and 'surname' columns and describe musician-musicians relation;