get_deputies_table {sejmRP}

Importing deputies table from a database

Description

Function get_deputies_table imports deputies table from a database.

Usage

get_deputies_table(dbname = 'sejmrp', user = 'reader',
  password = 'qux94874', host = 'services.mini.pw.edu.pl',
  sorted_by_id = TRUE, windows = .Platform$OS.type == 'windows')

Arguments

dbname

name of database; default: 'sejmrp'

user

name of user; default: 'reader'

password

password of database; default: 'qux94874'

host

name of host; default: 'services.mini.pw.edu.pl'

sorted_by_id

information if table should be sorted by id; default: TRUE

windows

information of used operation system; default: .Platform$OS.type == 'windows'

Details

Function get_deputies_table imports deputies table from a database. The result of this function is a data frame with deputies' data. Because of encoding issue on Windows operation system, you need to select if you use Windows.

Value

data frame

Note

Default parameters use privilages of 'reader'. It can only SELECT data from database.

All information is stored in PostgreSQL database.

Author(s)

Piotr Smuda

Examples

## Not run: 
deputies <- get_deputies_table()
dim(deputies)
# [1] 983 3
names(deputies)
# [1] 'id_deputy' 'nr_term_of_office' 'surname_name'
## End(Not run)