Hello,
I am trying to clean and tidy up radiobrowser database, locally on my computer.
After removing lots of stream url duplicates, and other records,
I would like to get up-to-the-date records listings, including station counts and working (not broken) station counts.
It appears these records come from LanguageCache & TagCache Tables.
My question is: Of course, if this is not a major trade secret, What is the query or function to generate both of LanguageCache & TagCache Tables?
I was browsing git repository, but I was unsuccessful to find corresponding queries/functions to re-generate updated LanguageCache & TagCache Tables.
My sql skills are too limited to create such queries on my own, thus I am asking for assistance here.
Sincerely,
Z-N
Zenith-Nadir
commented
4 years ago
Hello, I am trying to clean and tidy up radiobrowser database, locally on my computer. After removing lots of stream url duplicates, and other records, I would like to get up-to-the-date records listings, including station counts and working (not broken) station counts. It appears these records come from LanguageCache & TagCache Tables. My question is: Of course, if this is not a major trade secret, What is the query or function to generate both of LanguageCache & TagCache Tables? I was browsing git repository, but I was unsuccessful to find corresponding queries/functions to re-generate updated LanguageCache & TagCache Tables. My sql skills are too limited to create such queries on my own, thus I am asking for assistance here. Sincerely, Z-N