summaryrefslogtreecommitdiff
path: root/src/backend/syncDatabase.py
diff options
context:
space:
mode:
authorV3n3RiX <venerix@koprulu.sector>2022-10-30 15:14:09 +0000
committerV3n3RiX <venerix@koprulu.sector>2022-10-30 15:14:09 +0000
commitaaf45e0a3c06c7affeae2b412bb8db99e9ce3d86 (patch)
treefad75c483afa128e43644a9e90387d52e693aaf1 /src/backend/syncDatabase.py
parentfafff14908697a1e1d45cd8db1be2fe5cf8a4153 (diff)
move syncDatabase -> syncdb
Diffstat (limited to 'src/backend/syncDatabase.py')
-rw-r--r--src/backend/syncDatabase.py57
1 files changed, 0 insertions, 57 deletions
diff --git a/src/backend/syncDatabase.py b/src/backend/syncDatabase.py
deleted file mode 100644
index b5d86ae..0000000
--- a/src/backend/syncDatabase.py
+++ /dev/null
@@ -1,57 +0,0 @@
-#!/usr/bin/python3
-
-import csv
-import shutil
-import urllib3
-import sqlite3
-import subprocess
-import sisyphus.getenv
-import sisyphus.getfs
-
-def remoteCSV():
- packagesCsvURL,descriptionsCsvURL = sisyphus.getenv.csvURL()
- http = urllib3.PoolManager()
-
- with http.request('GET', packagesCsvURL, preload_content=False) as tmp_buffer, open(sisyphus.getfs.remotePackagesCsv, 'wb') as output_file:
- shutil.copyfileobj(tmp_buffer, output_file)
-
- with http.request('GET', descriptionsCsvURL, preload_content=False) as tmp_buffer, open(sisyphus.getfs.remoteDescriptionsCsv, 'wb') as output_file:
- shutil.copyfileobj(tmp_buffer, output_file)
-
-def localCSV():
- subprocess.call(['/usr/share/sisyphus/helpers/make_local_csv'])
-
-def remoteTable():
- remoteCSV()
-
- sisyphusdb = sqlite3.connect(sisyphus.getfs.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.getfs.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.getfs.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()
- sisyphusdb.close()
-
-def localTable():
- localCSV()
-
- sisyphusdb = sqlite3.connect(sisyphus.getfs.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.getfs.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()
- sisyphusdb.close()
-