test.py

# from flask import Flask, jsonify
# import pymysql

# app = Flask(__name__)

# # Database connection
# def get_db_connection():
#     return pymysql.connect(
#         host='localhost',
#         user='root',
#         password='arnav123456',
#         database='movies_db_main'
#     )

# @app.route('/')
# def index():
#     conn = get_db_connection()
#     cursor = conn.cursor()

#     # Fetch movies
#     cursor.execute("SELECT * FROM movies_db.movies LIMIT 10")
#     movies = cursor.fetchall()

#     # Fetch genres
#     # cursor.execute("SELECT * FROM genres LIMIT 10")
#     # genres = cursor.fetchall()

#     # Fetch movie-genre relationships
#     # cursor.execute('''
#     #     SELECT m.title, g.name 
#     #     FROM movies m
#     #     JOIN movie_genres mg ON m.movie_id = mg.movie_id
#     #     JOIN genres g ON mg.genre_id = g.id
#     #     LIMIT 10
#     # ''')
#     movie_genres = cursor.fetchall()

#     # Close the connection
#     cursor.close()
#     conn.close()

#     # Format results as JSON
#     response = {
#         "movies": [{"id": row[0],"movie_id": row[1], "title": row[2], "release_date": row[3], "overview": row[4], "posterpath": row[5], "budget": row[6], "revenue": row[7], "popularity": row[8], "vote_average": row[9], "vote_count": row[10]} for row in movies],
#         # "genres": [{"genre_id": row[0], "name": row[1]} for row in genres],
#         "movie_genres": [{"movie_title": row[0], "genre_name": row[1]} for row in movie_genres]
#     }

#     return jsonify(response)

# if __name__ == '__main__':
#     app.run(debug=True)