Should create a procedure called deleteme that returns two result sets, first the number of rows in booze then "name from booze"
(self, cur)
| 161 | pass # performed in test_MySQL_capabilities |
| 162 | |
| 163 | def help_nextset_setUp(self, cur): |
| 164 | """ |
| 165 | Should create a procedure called deleteme |
| 166 | that returns two result sets, first the |
| 167 | number of rows in booze then "name from booze" |
| 168 | """ |
| 169 | sql = """ |
| 170 | create procedure deleteme() |
| 171 | begin |
| 172 | select count(*) from %(tp)sbooze; |
| 173 | select name from %(tp)sbooze; |
| 174 | end |
| 175 | """ % dict( |
| 176 | tp=self.table_prefix |
| 177 | ) |
| 178 | cur.execute(sql) |
| 179 | |
| 180 | def help_nextset_tearDown(self, cur): |
| 181 | "If cleaning up is needed after nextSetTest" |