Hello, I'm not a bot and I am not using the AI assistant to write this bid..
I am a Software Engineer and I want to help you.
I can do this exactly as you expect, but pins are wrong, by example, pin1 is 3.3v power pin(Raspberry), so we have to define each room and each pin, it could be done in the same MySQL database, so you can change it anytime. I strongly suggest you to use Raspberry as you are aware it is more suitable for this project and also more powerful to run Python scripts, I can create this system using threads to make sure we can perform parallel actions/checkings.
Anyway, we should discuss more details and create a simple circuit diagram for all the rooms.
I can get this done in a week for you.
If this sounds interesting for you, then contact me.
Waiting for your comments.
Thanks
Martin O.
~
If we decide to work together, your project will be guaranteed to be 100% completed, I have all the skills and tools to achieve it.