summaryrefslogtreecommitdiff
path: root/src/backend/database.py
diff options
context:
space:
mode:
Diffstat (limited to 'src/backend/database.py')
-rw-r--r--src/backend/database.py22
1 files changed, 11 insertions, 11 deletions
diff --git a/src/backend/database.py b/src/backend/database.py
index 21db17e..9eb3bf5 100644
--- a/src/backend/database.py
+++ b/src/backend/database.py
@@ -9,13 +9,13 @@ import sisyphus.csvfiles
import sisyphus.filesystem
def getRemote():
- remotePkgCsv,remoteDescCsv = sisyphus.csvfiles.getURL()
+ remotePackagesCsvURL,remoteDescriptionsCsvURL = sisyphus.csvfiles.getURL()
http = urllib3.PoolManager()
- with http.request('GET', remotePkgCsv, preload_content=False) as tmp_buffer, open(sisyphus.filesystem.remotePkgsDB, 'wb') as output_file:
+ with http.request('GET', remotePackagesCsvURL, preload_content=False) as tmp_buffer, open(sisyphus.filesystem.remotePackagesCsv, 'wb') as output_file:
shutil.copyfileobj(tmp_buffer, output_file)
- with http.request('GET', remoteDescCsv, preload_content=False) as tmp_buffer, open(sisyphus.filesystem.remoteDscsDB, 'wb') as output_file:
+ with http.request('GET', remoteDescriptionsCsvURL, preload_content=False) as tmp_buffer, open(sisyphus.filesystem.remoteDescriptionsCsv, 'wb') as output_file:
shutil.copyfileobj(tmp_buffer, output_file)
def makeLocal():
@@ -24,18 +24,18 @@ def makeLocal():
def syncRemote():
getRemote()
- sisyphusdb = sqlite3.connect(sisyphus.filesystem.sisyphusDB)
+ sisyphusdb = sqlite3.connect(sisyphus.filesystem.localDatabase)
sisyphusdb.cursor().execute('''drop table if exists remote_packages''')
sisyphusdb.cursor().execute('''drop table if exists remote_descriptions''')
sisyphusdb.cursor().execute('''create table remote_packages (category TEXT,name TEXT,version TEXT,slot TEXT)''')
sisyphusdb.cursor().execute('''create table remote_descriptions (category TEXT,name TEXT,description TEXT)''')
- with open(sisyphus.filesystem.remotePkgsDB) as rmtCsv:
- for row in csv.reader(rmtCsv):
+ with open(sisyphus.filesystem.remotePackagesCsv) as input_file:
+ for row in csv.reader(input_file):
sisyphusdb.cursor().execute("insert into remote_packages (category, name, version, slot) values (?, ?, ?, ?);", row)
- with open(sisyphus.filesystem.remoteDscsDB) as rmtCsv:
- for row in csv.reader(rmtCsv):
+ with open(sisyphus.filesystem.remoteDescriptionsCsv) as input_file:
+ for row in csv.reader(input_file):
sisyphusdb.cursor().execute("insert into remote_descriptions (category, name, description) values (?, ?, ?);", row)
sisyphusdb.commit()
@@ -44,12 +44,12 @@ def syncRemote():
def syncLocal():
makeLocal()
- sisyphusdb = sqlite3.connect(sisyphus.filesystem.sisyphusDB)
+ sisyphusdb = sqlite3.connect(sisyphus.filesystem.localDatabase)
sisyphusdb.cursor().execute('''drop table if exists local_packages''')
sisyphusdb.cursor().execute('''create table local_packages (category TEXT,name TEXT,version TEXT,slot TEXT)''')
- with open(sisyphus.filesystem.localPkgsDB) as lclCsv:
- for row in csv.reader(lclCsv):
+ with open(sisyphus.filesystem.localPackagesCsv) as input_file:
+ for row in csv.reader(input_file):
sisyphusdb.cursor().execute("insert into local_packages (category, name, version, slot) values (?, ?, ?, ?);", row)
sisyphusdb.commit()