def test_50_metadata(): mocker = Mocker() connect = mocker.replace('MySQLdb.connect') link = connect(ARGS, KWARGS) mocker.result(link) link.get_server_info() mocker.result('5.0.87') cursor = link.cursor() cursor.execute('SHOW TABLE STATUS FROM `mysql`') cursor.description fields = [('name', ), ('engine', ), ('data_length', ), ('index_length', )] mocker.result(fields) iter(cursor) results = [ ('user', 'myisam', 1024, 1024), ('db', 'myisam', 1024, 1024), ] mocker.generate(results) cursor.close() mocker.replay() try: client = MySQLClient(read_default_file='/etc/my.cnf') expected_metadata = [ { 'database': 'mysql', 'name': 'user', 'engine': 'myisam', 'data_size': 1024, 'index_size': 1024, 'is_transactional': False }, { 'database': 'mysql', 'name': 'db', 'engine': 'myisam', 'data_size': 1024, 'index_size': 1024, 'is_transactional': False }, ] md = client.show_table_metadata('mysql') assert_equals(md, expected_metadata) mocker.verify() finally: mocker.restore()
def test_show_tables(): mocker = Mocker() connect = mocker.replace('MySQLdb.connect') link = connect(ARGS, KWARGS) mocker.result(link) cursor = link.cursor() cursor.execute('SHOW TABLES FROM `mysql`') iter(cursor) mocker.generate(['user', 'db']) cursor.close() mocker.replay() try: client = MySQLClient() tables = client.show_tables('mysql') assert_equals(tables, ['user', 'db']) finally: mocker.restore()
def test_show_tables(): mocker = Mocker() connect = mocker.replace('MySQLdb.connect') link = connect(ARGS, KWARGS) mocker.result(link) cursor = link.cursor() cursor.execute('SHOW TABLES FROM `mysql`') iter(cursor) mocker.generate(['user', 'db']) cursor.close() mocker.replay() try: client = MySQLClient() tables = client.show_tables('mysql') assert_equals(tables, ['user', 'db']) finally: mocker.restore()
def test_50_metadata(): mocker = Mocker() connect = mocker.replace('MySQLdb.connect') link = connect(ARGS, KWARGS) mocker.result(link) link.get_server_info() mocker.result('5.0.87') cursor = link.cursor() cursor.execute('SHOW TABLE STATUS FROM `mysql`') cursor.description fields = [('name',),('engine',),('data_length',),('index_length',)] mocker.result(fields) iter(cursor) results = [ ('user', 'myisam',1024,1024), ('db', 'myisam', 1024, 1024), ] mocker.generate(results) cursor.close() mocker.replay() try: client = MySQLClient(read_default_file='/etc/my.cnf') expected_metadata = [ { 'database' : 'mysql', 'name' : 'user', 'engine' : 'myisam', 'data_size' : 1024, 'index_size' : 1024, 'is_transactional' : False }, { 'database' : 'mysql', 'name' : 'db', 'engine' : 'myisam', 'data_size' : 1024, 'index_size' : 1024, 'is_transactional' : False }, ] md = client.show_table_metadata('mysql') assert_equals(md, expected_metadata) mocker.verify() finally: mocker.restore()