update_projects_host.py

#!/usr/bin/env python

import sys
import socket

hostname = socket.gethostname()
if hostname == 'Pumukel-GNU-Tablet':
    sys.path[0:0] = [
        '/usr/local/Plone/redmine.buildout/src/python-redmine',
        '/usr/local/Plone/buildout-cache/eggs/ipython-1.2.1-py2.7.egg',
        '/usr/local/Plone/buildout-cache/eggs/ipdb-0.8-py2.7.egg',
        '/usr/local/Plone/buildout-cache/eggs/requests-2.3.0-py2.7.egg',
    ]
elif hostname == 'redmine1':
    sys.path[0:0] = [
        '/data/redmine.buildout/src/python-redmine',
        '/data/redmine.buildout/eggs/ipython-1.2.1-py2.6.egg',
        '/data/redmine.buildout/eggs/ipdb-0.8-py2.6.egg',
        '/data/redmine.buildout/eggs/requests-2.3.0-py2.6.egg',
    ]

from redmine import Redmine
from redmine.exceptions import ResourceNotFoundError

import ipdb
from pprint import pprint


def update_projects():

    redmine = Redmine(
        #'https://www.scm.verwaltung.uni-muenchen.de/internetdienste/',
        'https://localhost/internetdienste/',
        username='admin',
        password='admin',
        requests={'verify': False})

    custom_fields = redmine.custom_field.all()
    cf_host_id = None
    cf_hostname_id = None

    for cf in custom_fields:
        if cf.name == "Host":
            cf_host_id = cf.id
        elif cf.name == "Hostname":
            cf_hostname_id = cf.id

    _all_projects = redmine.project.all()

    for project in _all_projects:
        _fields = project.custom_fields
        fields = {}
        for field in _fields:
            fields[field.name] = field

        #ipdb.set_trace()

        if fields['Host'].value == 'Intern':
            print 'Project {id} has declared HOST: Intern'.format(id=project.identifier)

        if fields['Host'].value == 'Intern' and fields['Hostname'].value == '':
            project.custom_fields = [{'id': cf_hostname_id, 'value': 'lmu-de.verwaltung.uni-muenchen.de (141.84.149.211)'}]

            project.save()
            print 'Update Project: {id}'.format(id=project.identifier)

        try:
            wegweiser = redmine.wiki_page.get('Wegweiser', project_id=project.id)
        except ResourceNotFoundError as e:
            wegweiser = redmine.wiki_page.create(project_id=project.id,
                title='Wegweiser',
                text="""bitte [[wegweiser]] anlegen.""",
                comments="Initiales Anlegen durch Update-Script")
            print 'Write Wiki Page Wegweiser to Project {id}'.format(id=project.identifier)

if __name__ == "__main__":
    update_projects()