This Movie that was about Books?

When i was younger there was this movie about a young boy. and he got like overtaken by Paint in a library and was made into animation, then he went on an adventure with books that had personalities of differant stories, like there was a total fradycat book that was supposed to be a horror novel. And there was a pirate who was the adventure novel and a fary who was fantasy. In the end he has to fight this big dragon thing and then he wakes up and is in reality again. whats the name of it?