abdurrafey

pdf generation added. now theres a button that you can click which generates a pdf with the questions you want (by filtering them) and it also generates a pdf of the markschemes of the questions. for now its only adding pictures of questions i've uploaded myself and thats why they look rough but i'll try to find a better way to make them afterwards. now i need to work on the ui and also add some better way to download the files instead of it just auto downloading both files like maybe 2 separate buttons for questions and markscheme.

added filtering by paper numbers and years. years are checkboxes for now. first used a box to get the paper number but now ive made it that it fetches paper numbers from the database and a dropdown only has the paper number options that are available for that one specific subject to ensure that it doesn't give the option to choose a paper that doesn't exist for that subject.

fixed the duplication problem for now by adding duplication checks when adding data. made a function that first checks if the things exist and only adds if they dont. so the problem of multiple ids of same exam board/topic/subject isnt happening anymore. made the basic frontend form ui. its working and showing questions. added test data to check that. now i have to refine backend a bit maybe and work on the actual frontend ui and make the pdf generation system aswell. (took help from chatgpt for the frontend as react is VERY confusing for me and that is why its taking me way longer for the frontend things)

Worked on the backend functionality mostly. linked the databases and added stuff like exam board and year queries. added QuestionList.jsx which shows questions after filtering. now i can also filter by paper number and year when getting questions. also worked a bit on the frontend, some very basic dropdown menu that shows questions but not working on it for now until the backend is done. also a logical error i think that a new exam board gets added everytime and a new topic aswell even if the topic is already there it adds a new one with a different id which basically makes the whole filtering useless so i have to fix this now. this is taking me way too long as i havent worked with these things before.

Made the basic flask app. made the tables in the database and initialised them with test data. (took help from chatgpt for the initialisation)