$4\mathrm{.}7\mathrm{.}1$: Database programming with Python.

$546386\mathrm{.}3959570.$qx$3$zqy$7$

from mysql import connector # load connector functions

connection $=$ connector.$\_\_\_\_\_($A$)\_\_\_\_\_($

user$=$'Blaise',

password$=$'Pascal',

host$=$'localhost',

database$=$'college'

$)$

rowcursor $=$ connection.$\_\_\_\_\_($B$)\_\_\_\_\_()$

query $=$ 'SELECT $*$ FROM Room'

$\_\_\_\_\_($C$)\_\_\_\_\_.\_\_\_\_\_($D$)\_\_\_\_\_($query$)$

for row in rowcursor.$\_\_\_\_\_($E$)\_\_\_\_\_()$: print$($row$)$

$\_\_\_\_\_($F$)\_\_\_\_\_.$close$()$

$\_\_\_\_\_($G$)\_\_\_\_\_.$close$()$The Python code below prints out the names and capacities of all the rooms in the database. Fill in the missing keywords.$($A$)($B$)($C$)($D$)($E$)($F$)($G$)$

connect

cursor

$1$