Given an rpm package name, query the yum database for updates
I was imagining a 3-line Python script to do this but the yum Python API is impenetrable. Is this even possible?
Is writing a wrapper for 'yum list package-name' the only way to do this?
Asked by: Alberta480 | Posted: 30-11-2021
and there are many examples of the yum api and some guides to getting started with it here:
As Seth points out, you can use the updates APIs to ask if something is available as an update. For something that's close to what the "yum list" does you probably want to use the doPackageLists(). Eg.
Answered by: Andrew712 | Posted: 01-01-2022
import os, sys import yum yb = yum.YumBase() yb.conf.cache = os.geteuid() != 1 pl = yb.doPackageLists(patterns=sys.argv[1:]) if pl.installed: print "Installed Packages" for pkg in sorted(pl.installed): print pkg if pl.available: print "Available Packages" for pkg in sorted(pl.available): print pkg, pkg.repo if pl.reinstall_available: print "Re-install Available Packages" for pkg in sorted(pl.reinstall_available): print pkg, pkg.repo
mysql - How to make a python package public if it relies on a SQL database I used?
So my data is stored in a mySQL database (on a local server). Im wondering what are the steps I need to complete in order to make the package available to other users? Like from GitHub? Since the package relies on the database content, I assume public users wouldn't be able to use the package. Or would they? Sorry I'm really new to this, so I am really unsure of the procedures.
python - How do I package an Sqlite3 database with my Python3 fbs package?
I am building a Python app using FBS, but part of it relies on an SQLite3 database. I have code to create this database if it doesn't find this, using a try-catch block. When I try to run it after compiling, it not only can not find the preexisting SQLite3 file, but also won't create it. It does not display any error messages. I have tried creating the file if it doesn't exist using this code:
python - Fetch data from sql database using Pyodbc package
I have a streamlit app that retrieve data from sql server database where i am using pyodbc. I have an select query where i try to select data based on user input using wild card inside the sql query. The problem is that when the user search on any field beside the ID it does not return anything. Database : CREATE TABLE [dbo].[t1]( [ID] [int] IDENTITY(1,1) NOT NULL...
database - Problem opening berkeley db in python
I have problems opening a berkeley db in python using bdtables. As bdtables is used by the library I am using to access the database, I need it to work. The problem seems to be that the db environment I am trying to open (I got a copy of the database to open), is version 4.4 while libdb is version 4.6. I get the following error using bsddb.dbtables.bsdTableDB([dbname],[folder]): (-30972, "DB_VERSION...
database - Store simple user settings in Python
I am programming a website in which users will have a number of settings, such as their choice of colour scheme, etc. I'm happy to store these as plain text files, and security is not an issue. The way I currently see it is: there is a dictionary, where all the keys are users and the values are dictionaries with the users' settings in them. For example, userdb["bob"]["colour_scheme"] would have the value "b...
python - Sometimes can't delete an Oracle database row using Django
I have a unit test which contains the following line of code Site.objects.get(name="UnitTest").delete() and this has worked just fine until now. However, that statement is currently hanging. It'll sit there forever trying to execute the delete. If I just say print Site.objects.get(name="UnitTest") then it works, so I know that it can retrieve the site. ...
python - How do I test a django database schema?
I want to write tests that can show whether or not the database is in sync with my models.py file. Actually I have already written them, only to find out that django creates a new database each time the tests are run based on the models.py file. Is there any way I can make the models.py test use the existing database schema? The one that's in mysql/postgresql, and not the one that's in /myapp/models.py ?
python - Using user input to find information in a Mysql database
I need to design a program using python that will ask the user for a barcode. Then, using this barcode, it will search a mysql to find its corresponding product. I am a bit stuck on how to get started. Does anyone have any tips for me?
python - Import XML into SQL database
I'm working with a 20 gig XML file that I would like to import into a SQL database (preferably MySQL, since that is what I am familiar with). This seems like it would be a common task, but after Googling around a bit I haven't been able to figure out how to do it. What is the best way to do this? I know this ability is built into MySQL 6.0, but that is not an option right now because it is an alpha development rel...
python - Using 'old' database with django
I'm using a hand built (Postgres) database with Django. With "inspectdb" I was able to automatically create a model for it. The problem is that some tables have multiple primary keys (for many-to-many relations) and they are not accessible via Django. What's the best way to access these tables?
python - How do I notify a process of an SQLite database change done in a different process?
Let's say I have two or more processes dealing with an SQLite database - a "player" process and many "editor" processes. The "player" process reads the database and updates a view - in my case it would be a waveform being mixed to the soundcard depending on events stored in the database. An "editor" process is any editor for that database: it changes the database constantly. Now I want the player t...
database - python orm
This is a newbie theory question - I'm just starting to use Python and looking into Django and orm. Question: If I develop my objects and through additional development modify the base object structures, inheritance, etc. - would Django's ORM solution modify the database automatically OR do I need to perform a conversion (if the app is live)? So, I start with a basic Phone app Object person: name, address, city, s...
python - Large Sqlite database search
How is it possible to implement an efficient large Sqlite db search (more than 90000 entries)? I'm using Python and SQLObject ORM: import re ... def search1(): cr = re.compile(ur'foo') for item in Item.select(): if cr.search(item.name) or cr.search(item.skim): print item.name This function runs in more than 30 seconds. How sh...