A python script to find average ratings for all movies

movies.py

import sys,os
import MySQLdb
def connect():
	conn = MySQLdb.connect(host = "localhost",user = "root",db = "netflix")
	cursor=conn.cursor()
	return cursor
def getAverage(cursor,id):
	#Take a movieId and find out the average rating for that movie 
	cursor.execute("select avg(rating) from allRatings where movieId="+id)
	return cursor.fetchone()
def getRatings(cursor,id):
	cursor.execute("select count(*) from allRatings where movieId="+id)

cursor = connect()
forMovies = open(sys.argv[1],'w')
for i in range(1,17771):
	avg = getAverage(cursor,i)
	number = getRatings(cursor,i)
	forMovies.write(i+","+avg+","+number+"\n")