Fixed importation of standard languages issue introduced in beta.19

1 files changed, 12 insertions, 4 deletions

diff --git a/bazarr/get_languages.py b/bazarr/get_languages.py
index 7aefae41c..a3abf7deb 100644
--- a/bazarr/get_languages.py
+++ b/bazarr/get_languages.py
@@ -12,20 +12,28 @@ def load_language_in_db():
     langs = [[lang.alpha_3, lang.alpha_2, lang.name]
              for lang in pycountry.languages
              if hasattr(lang, 'alpha_2')]
-    
-    # Insert languages in database table
-    CustomLanguage.register(TableSettingsLanguages)
 
+    # Insert standard languages in database table
+    TableSettingsLanguages.insert_many(langs,
+                                       fields=[TableSettingsLanguages.code3, TableSettingsLanguages.code2,
+                                               TableSettingsLanguages.name]) \
+        .on_conflict(action='IGNORE') \
+        .execute()
+
+    # Update standard languages with code3b if available
     langs = [[lang.bibliographic, lang.alpha_3]
              for lang in pycountry.languages
              if hasattr(lang, 'alpha_2') and hasattr(lang, 'bibliographic')]
-    
+
     # Update languages in database table
     for lang in langs:
         TableSettingsLanguages.update({TableSettingsLanguages.code3b: lang[0]}) \
             .where(TableSettingsLanguages.code3 == lang[1]) \
             .execute()
 
+    # Insert custom languages in database table
+    CustomLanguage.register(TableSettingsLanguages)
+
     # Create languages dictionary for faster conversion than calling database
     create_languages_dict()