diff options
author | V3n3RiX <venerix@koprulu.sector> | 2022-10-30 15:14:09 +0000 |
---|---|---|
committer | V3n3RiX <venerix@koprulu.sector> | 2022-10-30 15:14:09 +0000 |
commit | aaf45e0a3c06c7affeae2b412bb8db99e9ce3d86 (patch) | |
tree | fad75c483afa128e43644a9e90387d52e693aaf1 /src/backend/syncDatabase.py | |
parent | fafff14908697a1e1d45cd8db1be2fe5cf8a4153 (diff) |
move syncDatabase -> syncdb
Diffstat (limited to 'src/backend/syncDatabase.py')
-rw-r--r-- | src/backend/syncDatabase.py | 57 |
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() - |