PG Gem

Question 1

Ruby PG Gem

create a new PG:Connection object

Answer 1

PG.connect(dbname: “a_database”)

Question 2

Ruby PG Gem

execute a SQL query and return a PG::Result object

Answer 2

connection.exec(“SELECT * FROM…”)

Question 3

Ruby PG Gem

return an array of arrays containing values for each row in result

Answer 3

result.values

Question 4

Ruby PG Gem

return the names of columns as an array of strings

Answer 4

result.fields

Question 5

Ruby PG Gem

return the number of rows in result

Answer 5

result.ntuples

Question 6

Ruby PG Gem

yield a hash of column names and values to the block for each row in result

Answer 6

result.each(&block)

Question 7

Ruby PG Gem

yield an array of values to the block for each row in result

Answer 7

result.each_row(&block)

Question 8

Ruby PG Gem

return a hash of values for row at index in result

Answer 8

result[index]

Question 9

Ruby PG Gem

return an array of values for column, one for each row in result

Answer 9

result.field_values(column)

Question 10

Ruby PG Gem

return an array of values for column at index, one for each row in result

Answer 10

result.column_values(index)

Question 11

Ruby PG Gem

PG.connect(dbname: “a_database”)

Answer 11

create a new PG:Connection object

Question 12

Ruby PG Gem

connection.exec(“SELECT * FROM…”)

Answer 12

execute a SQL query and return a PG::Result object

Question 13

Ruby PG Gem

result.values

Answer 13

return an array of arrays containing values for each row in result

Question 14

Ruby PG Gem

result.fields

Answer 14

return the names of columns as an array of strings

Question 15

Ruby PG Gem

result.ntuples

Answer 15

return the number of rows in result

Question 16

Ruby PG Gem

result.each(&block)

Answer 16

yield a hash of column names and values to the block for each row in result

Question 17

Ruby PG Gem

result.each_row(&block)

Answer 17

yield an array of values to the block for each row in result

Question 18

Ruby PG Gem

result[index]

Answer 18

return a hash of values for row at index in result

Question 19

Ruby PG Gem

result.field_values(column)

Answer 19

return an array of values for column, one for each row in result

Question 20

Ruby PG Gem

result.column_values(index)

Answer 20

return an array of values for column at index, one for each row in result