Q, please do, I am. The only one I know about the Spanish fighting the French is El paso del Ebro that was later adapted and sung during the Civil War and I love it.
About the translation to the last line of the verse about the cucaracha's death "... y un ratón de sacristán" : "de" there doesn't means "of", it means "haciendo de" = "acting as" so it means "and a mouse as the sexton" and not "the sexton's mouse"