summaryrefslogtreecommitdiffhomepage
path: root/get_sonarr_settings.py
blob: 3877950748523024a90b83e1d340f076470c1a44 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
import sqlite3
import os
import ast

# Open database connection
db = sqlite3.connect('bazarr.db')
c = db.cursor()

# Get Sonarr API URL from database config table
c.execute('''SELECT * FROM table_settings_sonarr''')
config_sonarr = c.fetchone()

# Close database connection
db.close()

# Build Sonarr URL
ip_sonarr = config_sonarr[0]
port_sonarr = str(config_sonarr[1])
baseurl_sonarr = config_sonarr[2]
ssl_sonarr = config_sonarr[3]
apikey_sonarr = config_sonarr[4]

if ssl_sonarr == 1:
    protocol_sonarr = "https"
else:
    protocol_sonarr = "http"
if baseurl_sonarr == "":
    base_url_sonarr = ""
else:
    base_url_sonarr = "/" + baseurl_sonarr.strip("/")

url_sonarr = protocol_sonarr + "://" + ip_sonarr + ":" + port_sonarr + base_url_sonarr
url_sonarr_short = protocol_sonarr + "://" + ip_sonarr + ":" + port_sonarr