Das deutsche Python-Forum

Code: Alles auswählen

#!/usr/bin/env python
# -*- coding: utf8 -*-

# Module laden

from glob import glob

# Metadaten aus Dateinamen extrahieren

for pfad in glob('/var/www/Aufnahmen/aufnahme_fertig_*.mp3'):
   datei = pfad.lstrip('/var/www/Aufnahmen/aufnahme_fertig_')
   split = datei.index('_')
   alias = datei[0:split]
   jahr = datei[split+1:split+5]
   monat = datei[split+6:split+8]
   tag = datei[split+9:split+11]
   stunde = datei[split+12:split+14]
   minute = datei[split+15:split+17]
   print pfad
   print datei
   print alias
   print jahr
   print monat
   print tag
   print stunde
   print minute
   print "Index: "
   print split
   print ""

Code: Alles auswählen

# ./rb-add-record.py
/var/www/Aufnahmen/aufnahme_fertig_einslive_2015-09-25_20-05.mp3
slive_2015-09-25_20-05.mp3
slive
2015
09
25
20
05
Index: 
5

/var/www/Aufnahmen/aufnahme_fertig_kiraka_2015-09-26_14-05.mp3
kiraka_2015-09-26_14-05.mp3
kiraka
2015
09
26
14
05
Index: 
6

Code: Alles auswählen

datei = os.path.basename(pfad)
_, _, alias, date = datei.split('_', 3)
date = datetime.datetime.strptime(date, '%Y-%m-%d_%H-%M.mp3')

Code: Alles auswählen

#!/usr/bin/env python
# -*- coding: utf8 -*-

# Module laden

import MySQLdb
from glob import glob
import os

# Verbindung zur Datenbank aufbauen

connection = MySQLdb.connect("localhost", "root", "passwortblablabla", "radiobeere")

# Metadaten aus Dateinamen extrahieren

for pfad in glob('/var/www/Aufnahmen/aufnahme_fertig_*.mp3'):
   datei = os.path.basename(pfad)
   verz = os.path.dirname(pfad)
   teil = pfad.split('_')
   alias = teil[2]
   jahr = teil[3]
   monat = teil[4]
   tag = teil[5]
   stunde = teil[6]
   minute = teil[7]
   cursor = connection.cursor()
   cursor.execute("SELECT name FROM sender WHERE alias=%s",(alias))
   for row in cursor:
      sender = "%s" % row

# Datei taggen und umbenennen

   os.system('id3v2 -t'+'"'+sender+', '+tag+'.'+monat+'.'+jahr+', '+stunde+':'+minute+' Uhr'+'"'+' '+pfad)
   os.rename(pfad,verz+'/'+alias+'_'+jahr+'-'+monat+'-'+tag+'_'+stunde+'-'+minute+'.mp3')

Code: Alles auswählen

#!/usr/bin/env python
# -*- coding: utf8 -*-
from __future__ import absolute_import, division, print_function 
import os
from contextlib import closing
from datetime import datetime as DateTime
from glob import glob
from subprocess import call

import MySQLdb

RECORDINGS_FILENAME_PATTERN = '/var/www/Aufnahmen/aufnahme_fertig_*.mp3'
DB_HOST = 'localhost'
DB_USER = 'root'
DB_PASSWORD = 'passwortblablabla'
DB_DATABASE = 'radiobeere'
TIMESTAMP_FORMAT = '%Y-%m-%d_%H-%M'


def extract_metadata(filename):
    filename, extension = os.path.splitext(filename)
    _, station_alias, date, time = filename.rsplit('_', 3)
    timestamp = DateTime.strptime(
        '{0}_{1}'.format(date, time), TIMESTAMP_FORMAT
    )
    return station_alias, timestamp, extension


def get_station_name(connection, alias):
    with closing(connection.cursor()) as cursor:
        cursor.execute(
            'SELECT name FROM sender WHERE alias=%s', (alias,)
        )
        row = cursor.fetchone()
        if not row:
            raise KeyError('no name for alias {0!r}'.format(alias))
        return row[0]


def tag_mp3(path, station_name, timestamp):
    call(
        [
            'id3v2',
            '-t',
            '{0}, {1:%d.%m.%Y, %H:%M} Uhr'.format(station_name, timestamp),
            path
        ]
    )


def main():
    with closing(
        MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE)
    ) as connection:
        for pfad in glob(RECORDINGS_FILENAME_PATTERN):
            verzeichnis, dateiname = os.path.split(pfad)
            sender_alias, zeitstempel, extension = extract_metadata(dateiname)
            sendername = get_station_name(connection, sender_alias)
            tag_mp3(pfad, sendername, zeitstempel)
            os.rename(
                pfad,
                os.path.join(
                    verzeichnis,
                    '{0}_{1:{2}}{3}'.format(
                        sender_alias, zeitstempel, TIMESTAMP_FORMAT, extension
                    )
                )
            )


if __name__ == '__main__':
    main()

Code: Alles auswählen

#!/usr/bin/env python
# -*- coding: utf8 -*-
from __future__ import absolute_import, division, print_function
import os
import sys
from datetime import datetime as DateTime
from glob import glob
from subprocess import call, check_output

from sqlalchemy import create_engine, MetaData, select

RECORDINGS_FILENAME_PATTERN = '/var/www/Aufnahmen/aufnahme_fertig_*.mp3'
DB_URL = 'mysql+mysqldb://root:passwortblablabla@localhost/radiobeere'
TIMESTAMP_FORMAT = '%Y-%m-%d_%H-%M'
ID3V2 = 'id3v2'


def extract_metadata(filename):
    filename, extension = os.path.splitext(filename)
    _, station_alias, date, time = filename.rsplit('_', 3)
    timestamp = DateTime.strptime(
        '{0}_{1}'.format(date, time), TIMESTAMP_FORMAT
    )
    return station_alias, timestamp, extension
 
 
def get_station_name(station_table, alias):
    result = (
        select([station_table.c.name], station_table.c.alias == alias)
            .execute()
            .scalar()
    )
    if result is None:
        raise KeyError('no name for alias {0!r}'.format(alias))
    return result
 
 
def tag_mp3(path, station_name, timestamp):
    call(
        [
            ID3V2,
            '-t',
            '{0}, {1:%d.%m.%Y, %H:%M} Uhr'.format(station_name, timestamp),
            path
        ]
    )
 
 
def main():
    print('Checking for {0}...'.format(ID3V2))
    try:
        id3v2_info = check_output([ID3V2, '--version']).splitlines()[0]
    except EnvironmentError as error:
        print('{0} not callable.\n{1}'.format(ID3V2, error))
        sys.exit(1)
    else:
        print(id3v2_info, 'found.')

    engine = create_engine(DB_URL)
    metadata = MetaData(engine)
    metadata.reflect(only=['sender'])
    sender_table = metadata['sender']

    for pfad in glob(RECORDINGS_FILENAME_PATTERN):
        verzeichnis, dateiname = os.path.split(pfad)
        sender_alias, zeitstempel, extension = extract_metadata(dateiname)
        sendername = get_station_name(sender_table, sender_alias)
        tag_mp3(pfad, sendername, zeitstempel)
        os.rename(
            pfad,
            os.path.join(
                verzeichnis,
                '{0}_{1:{2}}{3}'.format(
                    sender_alias, zeitstempel, TIMESTAMP_FORMAT, extension
                )
            )
        )
 
 
if __name__ == '__main__':
    main()

Code: Alles auswählen

#!/usr/bin/env python
# -*- coding: utf8 -*-

import MySQLdb
import login
from contextlib import closing
from glob import glob
import os
import time
from mutagen.mp3 import MP3
from mutagen.id3 import ID3, TIT2, TPE1, TALB
import datetime


filename_pattern = '/var/www/Aufnahmen/aufnahme_fertig_*.mp3'


def audio_length(filename):

    length = str(datetime.timedelta(seconds = int((MP3(filename)).info.length)))

    return length


def extract_metadata(filename):

    _, _, station_alias, year, month, day, hour, minutes, _ = filename.split('_')
    timestamp = int(time.mktime((int(year), int(month), int(day), int(hour), int(minutes), 0, 0, 0, -1)))

    return station_alias, year, month, day, hour, minutes, timestamp


def get_station_name(connection, station_alias):

    with closing(connection.cursor()) as cursor:
        cursor.execute('SELECT name FROM sender WHERE alias=%s', (station_alias,))
        row = cursor.fetchone()

        if not row:
            raise KeyError('Sender nicht in der Datenbank vorhanden')

        return row[0]


def id3_tag(path, title, artist, album):

    audio = ID3()
    audio.save(path)
    audio = ID3(path)
    audio.add(TIT2(encoding=3, text = u"%s" % title))
    audio.add(TPE1(encoding=3, text = u"%s" % artist))
    audio.add(TALB(encoding=3, text = u"%s" % album))
    audio.save(v2_version=3)


def write_to_db(connection, date, time, station, new_filename, timestamp, length):

    with closing(connection.cursor()) as cursor:

        cursor.execute('INSERT INTO aufnahmen(datum, uhrzeit, sender, datei, zeitstempel, laenge) \
        VALUES (%s,%s,%s,%s,%s,%s)',(date, time, station, new_filename, timestamp, length,))
        connection.commit()


def main():

    with closing \
    (MySQLdb.connect(login.DB_HOST, login.DB_USER, login.DB_PASSWORD, login.DB_DATABASE)) \
    as connection:

        for path in glob(filename_pattern):

            directory = os.path.dirname(path)
            filename, extension = os.path.splitext(os.path.basename(path))

            length = audio_length(path)
            station_alias, year, month, day, hour, minutes, timestamp = extract_metadata(filename)
            station = get_station_name(connection, station_alias)

            date = '{0}-{1}-{2}'.format(year, month, day)
            time = '{0}:{1}'.format(hour, minutes)
            title = '{0}, {1}.{2}.{3}, {4} Uhr'.format(station, day, month, year, time)

            new_filename = '{0}_{1}-{2}-{3}_{4}-{5}{6}'.format \
            (station_alias, year, month, day, hour, minutes, extension)

            id3_tag(path, title, station, date)
            write_to_db(connection, date, time, station, new_filename, timestamp, length)
            os.rename(path, (os.path.join(directory, new_filename)))

if __name__ == '__main__':
    main()

Code: Alles auswählen

audio.add(TIT2(encoding=3, text=u"An example"))

Code: Alles auswählen

def extract_metadata(filename):

    _, _, station_alias, date_time = filename.split('_',3)    
    date_time = datetime.datetime.strptime(date_time, date_time_format)

    return station_alias, date_time

Code: Alles auswählen

date_time_format = '%Y_%m_%d_%H_%M_%S'