<commit_before>import sys
import os

sys.path.append(os.path.dirname(os.path.abspath(__file__)) + '/../../')
from demo import QueryInfo


actors_played_with_nicolas_cage_query = QueryInfo(
    query="""MATCH (n:actor{name:"<NAME>"})-[:act]->(m:movie)<-[:act]-(a:actor)
             RETURN a.name, m.title""",
    description='Which actors played along side Nicolas Cage?',
    max_run_time_ms=3,
    expected_result=[['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind']]
)


find_three_actors_played_with_nicolas_cage_query = QueryInfo(
    query="""MATCH (nicolas:actor {name:"<NAME>"})-[:act]->(m:movie)<-[:act]-(a:actor)
             RETURN a.name, m.title
             LIMIT 3""",
    description='Get 3 actors who have played along side Nicolas Cage?',
    max_run_time_ms=2.5,
    expected_result=[['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind']]
)


actors_played_in_movie_straight_outta_compton_query = QueryInfo(
    query="""MATCH (a:actor)-[:act]->(m:movie {title:"Straight Outta Compton"})
             RETURN a.name""",
    description='Which actors played in the movie Straight Outta Compton?',
    max_run_time_ms=3.5,
    expected_result=[['<NAME>'],
                     ['<NAME>'],
                     ['<NAME>r.'],
                     ['<NAME>.']]
)


actors_over_50_that_played_in_blockbusters_query = QueryInfo(
    query="""MATCH (a:actor)-[:act]->(m:movie)
             WHERE a.age >= 50 AND m.votes > 10000 AND m.rating > 8.2
             RETURN a, m""",
    description='Which actors who are over 50 played in blockbuster movies?',
    max_run_time_ms=3.5,
    expected_result=[['<NAME>', '67.000000', 'Interstellar', '2014.000000', '961763.000000', '8.600000', 'Adventure'],
                     ['<NAME>', '106.000000', 'Vincent', '1982.000000', '18284.000000', '8.400000', 'Short'],
                     ['<NAME>', '85.000000', 'Interstellar', '2014.000000', '961763.000000', '8.600000', 'Adventure'],
                     ['<NAME>', '60.000000', 'Whiplash', '2014.000000', '420586.000000', '8.500000', 'Drama'],
                     ['<NAME>', '75.000000', 'Interstellar', '2014.000000', '961763.000000', '8.600000', 'Adventure'],
                     ['<NAME>', '72.000000', 'Interstellar', '2014.000000', '961763.000000', '8.600000', 'Adventure'],
                     ['<NAME>', '62.000000', 'Whiplash', '2014.000000', '420586.000000', '8.500000', 'Drama',],
                     ['<NAME>', '69.000000', 'Whiplash', '2014.000000', '420586.000000', '8.500000', 'Drama']]
)


actors_played_in_bad_drama_or_comedy_query = QueryInfo(
    query="""MATCH (a:actor)-[:act]->(m:movie)
             WHERE (m.genre = "Drama" OR m.genre = "Comedy")
             AND m.rating < 5.5 AND m.votes > 50000
             RETURN a.name, m
             ORDER BY m.rating""",
    description='Which actors played in bad drama or comedy?',
    max_run_time_ms=4,
    expected_result=[['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000','224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Sex Tape', '2014.000000', '86018.000000', '5.100000', 'Comedy'],
                     ['<NAME>', 'Sex Tape', '2014.000000', '86018.000000', '5.100000', 'Comedy'],
                     ['<NAME>', 'Sex Tape', '2014.000000', '86018.000000', '5.100000', 'Comedy'],
                     ['<NAME>', 'Sex Tape', '2014.000000', '86018.000000', '5.100000', 'Comedy'],
                     ['<NAME>', 'Sex Tape', '2014.000000', '86018.000000', '5.100000', 'Comedy'],
                     ['<NAME>', 'Sex Tape', '2014.000000', '86018.000000', '5.100000', 'Comedy']]
)


young_actors_played_with_cameron_diaz_query = QueryInfo(
    query="""MATCH (Cameron:actor {name:"<NAME>"})-[:act]->(m:movie)<-[:act]-(a:actor)
             WHERE a.age < 35
             RETURN a, m.title""",
    description='Which young actors played along side <NAME>?',
    max_run_time_ms=5,
    expected_result=[['<NAME>', '14.000000', 'Annie'],
                     ['<NAME>', '25.000000', 'The Other Woman']]
)


actors_played_with_cameron_diaz_and_younger_than_her_query = QueryInfo(
    query="""MATCH (Cameron:actor {name:"<NAME>"})-[:act]->(m:movie)<-[:act]-(a:actor)
             WHERE a.age < Cameron.age
             RETURN a, m.title""",
    description='Which actors played along side Camer<NAME>z and are younger then her?',
    max_run_time_ms=7,
    expected_result=[['<NAME>', '37.000000', 'Sex Tape'],
                     ['<NAME>', '37.000000', 'Sex Tape'],
                     ['<NAME>', '14.000000', 'Annie'],
                     ['<NAME>', '38.000000', 'Annie'],
                     ['<NAME>', '25.000000', 'The Other Woman'],
                     ['<NAME>', '35.000000', 'The Other Woman'],
                     ['<NAME>', '36.000000', 'The Other Woman']]
)


sum_and_average_age_of_straight_outta_compton_cast_query = QueryInfo(
    query="""MATCH (a:actor)-[:act]->(m:movie{title:"Straight Outta Compton"})
             RETURN m.title, SUM(a.age), AVG(a.age)""",
    description='What is the sum and average age of the Straight Outta Compton cast?',
    max_run_time_ms=4,
    expected_result=[['Straight Outta Compton', '123.000000', '30.750000']]
)


how_many_movies_cameron_diaz_played_query = QueryInfo(
    query="""MATCH (Cameron:actor{name:"<NAME>"})-[:act]->(m:movie)
             RETURN Cameron.name, COUNT(m.title)""",
    description='In how many movies did <NAME> played?',
    max_run_time_ms=1.2,
    expected_result=[['<NAME>', '3.000000']]
)


find_ten_oldest_actors_query = QueryInfo(
    query="""MATCH (a:actor)
             RETURN DISTINCT a.name, a.age
             ORDER BY a.age DESC
             LIMIT 10""",
    description='10 Oldest actors?',
    max_run_time_ms=4.5,
    expected_result=[['Vincent Price', '106.000000'],
                     ['<NAME>', '92.000000'],
                     ['<NAME>', '91.000000'],
                     ['<NAME>', '87.000000'],
                     ['<NAME>', '87.000000'],
                     ['<NAME>', '86.000000'],
                     ['<NAME>', '86.000000'],
                     ['<NAME>', '85.000000'],
                     ['<NAME>', '84.000000'],
                     ['<NAME>', '83.000000']]
)


queries_info = [
    actors_played_with_nicolas_cage_query,
    find_three_actors_played_with_nicolas_cage_query,
    actors_played_in_movie_straight_outta_compton_query,
    actors_over_50_that_played_in_blockbusters_query,
    actors_played_in_bad_drama_or_comedy_query,
    young_actors_played_with_cameron_diaz_query,
    actors_played_with_cameron_diaz_and_younger_than_her_query,
    sum_and_average_age_of_straight_outta_compton_cast_query,
    how_many_movies_cameron_diaz_played_query,
    find_ten_oldest_actors_query
]
<commit_msg>updated flow test expected results<commit_after>import sys
import os

sys.path.append(os.path.dirname(os.path.abspath(__file__)) + '/../../')
from demo import QueryInfo


actors_played_with_nicolas_cage_query = QueryInfo(
    query="""MATCH (n:actor{name:"Nicolas Cage"})-[:act]->(m:movie)<-[:act]-(a:actor)
             RETURN a.name, m.title""",
    description='Which actors played along side Nicolas Cage?',
    max_run_time_ms=3,
    expected_result=[['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind']]
)


find_three_actors_played_with_nicolas_cage_query = QueryInfo(
    query="""MATCH (nicolas:actor {name:"<NAME>"})-[:act]->(m:movie)<-[:act]-(a:actor)
             RETURN a.name, m.title
             LIMIT 3""",
    description='Get 3 actors who have played along side Nicolas Cage?',
    max_run_time_ms=2.5,
    expected_result=[['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind'],
                     ['<NAME>', 'Left Behind']]
)


actors_played_in_movie_straight_outta_compton_query = QueryInfo(
    query="""MATCH (a:actor)-[:act]->(m:movie {title:"Straight Outta Compton"})
             RETURN a.name""",
    description='Which actors played in the movie Straight Outta Compton?',
    max_run_time_ms=3.5,
    expected_result=[['<NAME>'],
                     ['<NAME>'],
                     ['<NAME> Jr.'],
                     ['<NAME> Jr.']]
)


actors_over_50_that_played_in_blockbusters_query = QueryInfo(
    query="""MATCH (a:actor)-[:act]->(m:movie)
             WHERE a.age >= 50 AND m.votes > 10000 AND m.rating > 8.2
             RETURN a, m""",
    description='Which actors who are over 50 played in blockbuster movies?',
    max_run_time_ms=3.5,
    expected_result=[['<NAME>', '68.000000', 'Interstellar', '2014.000000', '961763.000000', '8.600000', 'Adventure'],
                     ['<NAME>', '107.000000', 'Vincent', '1982.000000', '18284.000000', '8.400000', 'Short'],
                     ['<NAME>', '86.000000', 'Interstellar', '2014.000000', '961763.000000', '8.600000', 'Adventure'],
                     ['<NAME>', '61.000000', 'Whiplash', '2014.000000', '420586.000000', '8.500000', 'Drama'],
                     ['<NAME>', '76.000000', 'Interstellar', '2014.000000', '961763.000000', '8.600000', 'Adventure'],
                     ['<NAME>', '73.000000', 'Interstellar', '2014.000000', '961763.000000', '8.600000', 'Adventure'],
                     ['<NAME>', '63.000000', 'Whiplash', '2014.000000', '420586.000000', '8.500000', 'Drama',],
                     ['<NAME>', '70.000000', 'Whiplash', '2014.000000', '420586.000000', '8.500000', 'Drama'],
                     ['<NAME>', '50.000000', 'Lucifer', '2015.000000', '58703.000000', '8.300000', 'Crime']]
)


actors_played_in_bad_drama_or_comedy_query = QueryInfo(
    query="""MATCH (a:actor)-[:act]->(m:movie)
             WHERE (m.genre = "Drama" OR m.genre = "Comedy")
             AND m.rating < 5.5 AND m.votes > 50000
             RETURN a.name, m
             ORDER BY m.rating""",
    description='Which actors played in bad drama or comedy?',
    max_run_time_ms=4,
    expected_result=[['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000', '224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Fifty Shades of Grey', '2015.000000','224710.000000', '4.100000', 'Drama'],
                     ['<NAME>', 'Sex Tape', '2014.000000', '86018.000000', '5.100000', 'Comedy'],
                     ['<NAME>', 'Sex Tape', '2014.000000', '86018.000000', '5.100000', 'Comedy'],
                     ['<NAME>', 'Sex Tape', '2014.000000', '86018.000000', '5.100000', 'Comedy'],
                     ['<NAME>', 'Sex Tape', '2014.000000', '86018.000000', '5.100000', 'Comedy'],
                     ['<NAME>', 'Sex Tape', '2014.000000', '86018.000000', '5.100000', 'Comedy'],
                     ['<NAME>', 'Sex Tape', '2014.000000', '86018.000000', '5.100000', 'Comedy']]
)


young_actors_played_with_cameron_diaz_query = QueryInfo(
    query="""MATCH (Cameron:actor {name:"<NAME>"})-[:act]->(m:movie)<-[:act]-(a:actor)
             WHERE a.age < 35
             RETURN a, m.title""",
    description='Which young actors played along side Cameron Diaz?',
    max_run_time_ms=5,
    expected_result=[['Nico<NAME>', '15.000000', 'Annie'],
                     ['<NAME>', '26.000000', 'The Other Woman']]
)


actors_played_with_cameron_diaz_and_younger_than_her_query = QueryInfo(
    query="""MATCH (Cameron:actor {name:"<NAME>"})-[:act]->(m:movie)<-[:act]-(a:actor)
             WHERE a.age < Cameron.age
             RETURN a, m.title""",
    description='Which actors played along side Cameron Diaz and are younger then her?',
    max_run_time_ms=7,
    expected_result=[['<NAME>', '38.000000', 'Sex Tape'],
                     ['<NAME>', '38.000000', 'Sex Tape'],
                     ['N<NAME>', '15.000000', 'Annie'],
                     ['<NAME>', '39.000000', 'Annie'],
                     ['<NAME>', '26.000000', 'The Other Woman'],
                     ['<NAME>', '36.000000', 'The Other Woman'],
                     ['<NAME>', '37.000000', 'The Other Woman']]
)


sum_and_average_age_of_straight_outta_compton_cast_query = QueryInfo(
    query="""MATCH (a:actor)-[:act]->(m:movie{title:"Straight Outta Compton"})
             RETURN m.title, SUM(a.age), AVG(a.age)""",
    description='What is the sum and average age of the Straight Outta Compton cast?',
    max_run_time_ms=4,
    expected_result=[['Straight Outta Compton', '127.000000', '31.750000']]
)


how_many_movies_cameron_diaz_played_query = QueryInfo(
    query="""MATCH (Cameron:actor{name:"<NAME>"})-[:act]->(m:movie)
             RETURN Cameron.name, COUNT(m.title)""",
    description='In how many movies did <NAME> played?',
    max_run_time_ms=1.2,
    expected_result=[['<NAME>z', '3.000000']]
)


find_ten_oldest_actors_query = QueryInfo(
    query="""MATCH (a:actor)
             RETURN DISTINCT a.name, a.age
             ORDER BY a.age DESC
             LIMIT 10""",
    description='10 Oldest actors?',
    max_run_time_ms=4.5,
    expected_result=[['<NAME>', '107.000000'],
                     ['<NAME>', '93.000000'],
                     ['<NAME>', '92.000000'],
                     ['<NAME>', '88.000000'],
                     ['<NAME>', '88.000000'],
                     ['<NAME>', '87.000000'],
                     ['<NAME>', '87.000000'],
                     ['<NAME>', '86.000000'],
                     ['<NAME>', '85.000000'],
                     ['<NAME>', '84.000000']]
)


queries_info = [
    actors_played_with_nicolas_cage_query,
    find_three_actors_played_with_nicolas_cage_query,
    actors_played_in_movie_straight_outta_compton_query,
    actors_over_50_that_played_in_blockbusters_query,
    actors_played_in_bad_drama_or_comedy_query,
    young_actors_played_with_cameron_diaz_query,
    actors_played_with_cameron_diaz_and_younger_than_her_query,
    sum_and_average_age_of_straight_outta_compton_cast_query,
    how_many_movies_cameron_diaz_played_query,
    find_ten_oldest_actors_query
]

{'fraction_non_alphanumeric': 0.189255999035331, 'fraction_numerical': 0.11636319787772821, 'mean_word_length': 2.5149396058486966, 'pattern_counts': {'":': 0, '<': 156, '<?xml version=': 0, '>': 168, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3482943', 'n_tokens_mistral': 7042, 'n_tokens_neox': 5395, 'n_words': 1069}