Getting a list of all spells loaded in the game

[kaibaby]

Hey guys, I'm trying to make a mod that equips a spell through key combinations. ( You press button X, then enter key combination Y, press X again and you get a spell equipped ).

The key combination should get parsed into a query.

First button press in key combination corresponds to school of magic, second button press corresponds to expertise level, and the remaining buttons are used to create a numeric index

I need a data structure that looks like this

{
  "destruction": {
    "novice":[spellRefNum1, ...spellRefNumN], 
    "apprentice": [spellRefNum1, ...spellRefNumN]
   },
  "conjuration": {
   "novice":[spellRefNum1, ...spellRefNumN],
   "apprentice": [spellRefNum1, ...spellRefNumN]
   },
  }
};

I was wondering if theres any way to generate a list of all the spells in the game + their in game references ( bonus points if theres a solution for mods ). I would prefer doing this (getting this data into something persistent & queryable like redis or even a txt file) OUTSIDE of the creation kit / papyrus in python for sanity's sake. then I could just implement the query stuff in python and expose `getSpellRef(int keySequence)` through skse, and call `getSpellRef` in my papyrus script.

 

 

Is this doable at all?