Skripte
CDs aus Datenbank auslesen
#!/usr/bin/python
print 'Erzeuge HTML-Datei aus CD-Datenbank...'
import MySQLdb
connection = MySQLdb.connect("server", "user, "password", "db")
cursor = connection.cursor()
cursor.execute("SELECT artist, jahr, name, bemerkung FROM cds ORDER BY artist ASC, jahr ASC")
max = 0
for row in cursor:
if len(row[0]) > max:
max = len(row[0])
print '^ Artist ^ Jahr ^ Name ^ Bemerkung ^'
for row in cursor:
# print "%035s %04s %s (%s)" % row
print "| %s | %s | %s | %s |" % (row[0], row[2], row[1], row[3])
Bilder für PR-Contest verkleinern
#!/bin/bash
NUMBER=1
for file in `ls workspace/pr-contest/IMG*`; do
convert "$file" -resize 15% workspace/pr-contest/dr-pain82-GHRB-KW00-$NUMBER.jpg
((NUMBER++))
done
Bilder mit sprechendem Namen kopieren
#!/bin/bash
NUMBER=1
for file in `ls 2014/07/13/*.JPG`; do
b=`printf "Rockharz-2014-Tag4-%02d.jpg" $NUMBER`
cp "$file" "2014-07-10 Rockharz/$b"
((NUMBER++))
done