Method get_foreign_keys

mssqlcli/mssqlcliclient.py:357–364

Yields (parent_schema, parent_table, parent_column, child_schema, child_table, child_column) typles

(self)

                yield (row[0], row[1])

    def get_foreign_keys(self):
        """ Yields (parent_schema, parent_table, parent_column, child_schema, child_table,
            child_column) typles"""
        query = mssqlqueries.get_foreignkeys()
        logger.info(u'Foreign keys query: %s', query)
        for tabular_result in self.execute_query(query):
            for row in tabular_result[0]:
                yield ForeignKey(*row)

    def shutdown(self):
        self.sql_tools_client.shutdown()