automate choosing the next tapes

It's been a while that I already started to write a small script to help 
me and a customer to improve our weekly change of tapes:

they use a small tape library with 8 slots, with their schedule etc we 
roughly change tapes each week or so.

To choose the tapes to remove and which ones to supply I look at bacularis.

The default "algorithm" is something like:

- look at the Volumes for the default Pool "Daily"

- sort them by LastWritten

- only the Enabled ones.

- Retentiontime over

- Status Full, Recycle, Append ...

- not in changer

I do that "manually" by looking and filtering in my head  more or less ;-)


Now I'd like to give it another try and wrap that into a python script.

There should be a cronjob that tells us which tapes to remove from and 
which to put into the changer (for the standard schedule).

Do you guys see something missing in my approach above?

With a bit of LLM I came up with this so far:

--- code ---

#!/usr/bin/env python3

import psycopg2
import sys


from datetime import datetime, timedelta

DB_CONFIG = {
     "host": "localhost",
     "dbname": "bacula",
     "user": "bacula",
     "password": "somepass"
}

POOL_NAME = "Daily"
USABLE_STATUS = ("Append", "Recycle", "Full")

RETENTION_DAYS = 30

QUERY = """
SELECT
     m.mediaid,
     m.volumename,
     m.volstatus,
     m.lastwritten,
     m.inchanger
FROM media m
JOIN pool p ON m.poolid = p.poolid
WHERE
     p.name = %s
     AND m.volstatus IN %s
     AND m.lastwritten IS NOT NULL
ORDER BY
     m.lastwritten,
     m.mediaid
LIMIT 8;
"""

def main():
     # Verbindung zur DB herstellen
     conn = psycopg2.connect(**DB_CONFIG)
     cur = conn.cursor()

     # Abfrage ausführen
     cur.execute(QUERY, (POOL_NAME, USABLE_STATUS))
     rows = cur.fetchall()

     if not rows:
         print(f"CRITICAL: Keine verwendbaren Tapes im Pool '{POOL_NAME}'")
         sys.exit(2)

     print(f"Nächste 8 Tapes mit abgelaufener Retention im Pool 
'{POOL_NAME}':\n")

     now = datetime.now()

     for volid, volume, status, lastwritten, inchanger in rows:

     lastwritten_str = lastwritten if lastwritten else "Noch nie verwendet"

         if lastwritten:
             lastwritten_date = lastwritten
         else:
             lastwritten_date = datetime.min  # Wenn nie benutzt, setze 
auf minimalen Wert

         expiration_date = lastwritten_date + timedelta(days=RETENTION_DAYS)

         if expiration_date <= now:
             retention_status = "Abgelaufen"
         else:
             retention_status = f"Verbleibend: {expiration_date - now}"

         # Changer-Status anzeigen
         changer_status = "Im Changer" if inchanger else "Nicht im Changer"

         # Ausgabe
         print(f"{volume:15} {status:8} {lastwritten_str} 
{retention_status:30} {changer_status}")

     # Verbindung schließen
     cur.close()
     conn.close()

if __name__ == "__main__":
     main()

--- code end ---

(forgive the german parts)


Anyone interested in working on such a script?
Any obvious flaws in my approach?

Thanks, regards, Stefan










_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users