def get_stackoverflow_tags_count()

in perf_dashboard/posts_stats.py [0:0]

• 5 lines of code
• 2 McCabe index (conditional complexity)

def get_stackoverflow_tags_count():
    """Get all the tags contains python and cloud key words"""
    query = """
            SELECT
                SPLIT(tags, '|') tags
            FROM
                `bigquery-public-data.stackoverflow.posts_questions`
            WHERE
                tags LIKE '%python%'
            AND (tags LIKE '%google-cloud-platform%' OR tags LIKE '%gcp%')
        """

    results = bq_utils.execute_query(query)

    rows = [row[0] for row in results]

    return rows