Python-сообщество

 import mysql.connector as sql
def copy_to_other_db():
    try:
        connection = sql.connect(host='127.0.0.1',
                                 database='employees',
                                 user ="yurapc",
                                 password='Mysqlpassword1!')
        cursor = connection.cursor()
        cursor.execute("SELECT * FROM titles")
        query = cursor.fetchall()
    except sql.Error as error:
        print("Failed to select all rows from MySQL table {}".format(error))
    try:
        connection_2 = sql.connect(host='127.0.0.1',
                                 database='employees_2',
                                 user ="yurapc",
                                 password='Mysqlpassword1!')
        cursor_2 = connection_2.cursor()
        cursor_2.executemany("INSERT IGNORE INTO titles (emp_no, title, from_date, to_date) VALUES (%s, %s, %s, %s);", query)
        connection_2.commit()
        print("Record inserted successfully into titles table")
    except sql.Error as error_2:
        print("Failed to insert into MySQL table {}".format(error_2))
    finally:
        if connection.is_connected() and connection_2.is_connected():
            cursor.reset()
            cursor_2.reset()
            connection.close()
            connection_2.close()
            print("Connection is closed")
copy_to_other_db()

 def calculate_random_squares(n: int) -> List[int]:
     return [random.randint(1, 100) ** 2 for i in range(n)]

   
@pytest.mark.parametrize("rnd,ln, res", [(2, 2, [4, 4]), (-3, 5, [9, 9, 9, 9, 9]), (1, 0, [])])
def test_calc(rnd, ln, res):
    with patch("random.randint", return_value=rnd):
        assert calculate_random_squares(ln) == res