aboutsummaryrefslogtreecommitdiff
blob: fab706c6be81f12f5f58da8be2c243caac55ba7d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
import web
import json
import helpers
import config
from config import render, db

class Host(object):

    def GET(self, str_uuid):
        if not helpers.is_uuid(str_uuid):
            return config.notfound()

        uuid = helpers.uuidbin(str_uuid)
        hosts = db.select('HOSTS', vars={'uuid':uuid}, where='UUID=$uuid', what='UUID')
        if len(hosts) == 0:
            return config.notfound()

        host_data = dict()
        host_data['UUID'] = str_uuid

        env = db.select('ENV', vars={'uuid':uuid}, where="UUID=$uuid")
        e = env[0]
        for var in ['PLATFORM', 'LASTSYNC', 'PROFILE', 'ARCH', 'CHOST', 'CFLAGS', 'CXXFLAGS', 'FFLAGS', 'LDFLAGS', 'MAKEOPTS', 'SYNC']:
            host_data[var] = e[var]

        host_data['FEATURES'] = list()
        features = db.query('SELECT FEATURE FROM HOST_FEATURES NATURAL JOIN FEATURES WHERE UUID=$uuid', vars={'uuid':uuid})
        for f in features:
            host_data['FEATURES'].append(f['FEATURE'])

        host_data['ACCEPT_KEYWORDS'] = list()
        keywords = db.query('SELECT KEYWORD FROM GLOBAL_KEYWORDS NATURAL JOIN KEYWORDS WHERE UUID=$uuid', vars={'uuid':uuid})
        for k in keywords:
            host_data['ACCEPT_KEYWORDS'].append(k['KEYWORD'])

        host_data['USE'] = list()
        useflags = db.query('SELECT USEFLAG FROM GLOBAL_USEFLAGS NATURAL JOIN USEFLAGS WHERE UUID=$uuid', vars={'uuid':uuid})
        for u in useflags:
            host_data['USE'].append(u['USEFLAG'])

        host_data['LANG'] = list()
        lang = db.query('SELECT LANG FROM HOST_LANG NATURAL JOIN LANG WHERE UUID=$uuid', vars={'uuid':uuid})
        for l in lang:
            host_data['LANG'].append(l['LANG'])

        host_data['GENTOO_MIRRORS'] = list()
        mirrors = db.query('SELECT MIRROR FROM HOST_MIRRORS NATURAL JOIN GENTOO_MIRRORS WHERE UUID=$uuid', vars={'uuid':uuid})
        for m in mirrors:
            host_data['GENTOO_MIRRORS'].append(m['MIRROR'])

        host_data['PACKAGES'] = dict()
        packages = db.query('SELECT CAT, PKG, VER FROM INSTALLED_PACKAGES NATURAL JOIN PACKAGES WHERE UUID=$uuid ORDER BY CAT, PKG, VER', vars={'uuid':uuid})
        for p in packages:
            cpv = p['CAT'] + '/' + p['PKG'] + '-' + p['VER']
            host_data['PACKAGES'][cpv] = dict()

        if helpers.is_json_request():
            return helpers.serialize(host_data)
        else:
            return render.host(host_data)

    def POST(self, str_uuid):
        post_data = json.JSONDecoder().decode(web.data())

        #TODO: Handle exceptions
        if post_data['PROTOCOL'] != 1:
            return 'Unsupported protocol!'

        if post_data['AUTH']['UUID'] != str_uuid:
            return 'Invalid uuid!'

        uuid = helpers.uuidbin(str_uuid)

        # Insert in hosts
        db_host = db.select('HOSTS', vars={'uuid':uuid}, where='UUID=$uuid')
        if len(db_host):
            if post_data['AUTH']['PASSWD'] != db_host[0]['PASSWD']:
                return 'Wrong password!'
            # This should delete all host entries from all tables
            db.delete('HOSTS', vars={'uuid':uuid}, where='UUID=$uuid')
        db.insert('HOSTS', UUID=uuid, PASSWD=post_data['AUTH']['PASSWD'])

        # Insert in env
        db.insert('ENV', UUID=uuid, ARCH=post_data['ARCH'], CHOST=post_data['CHOST'], CFLAGS=post_data['CFLAGS'],
                CXXFLAGS=post_data['CXXFLAGS'], FFLAGS=post_data['FFLAGS'], LDFLAGS=post_data['LDFLAGS'],
                MAKEOPTS=post_data['MAKEOPTS'], SYNC=post_data['SYNC'], PLATFORM=post_data['PLATFORM'],
                PROFILE=post_data['PROFILE'], LASTSYNC=post_data['LASTSYNC'])

        # Insert in GLOBAL_KEYWORDS
        for keyword in post_data['ACCEPT_KEYWORDS']:
            kwkey = helpers.get_kwkey(db, keyword)
            db.insert('GLOBAL_KEYWORDS', UUID=uuid, KWKEY=kwkey)

        # Insert in HOST_LANG
        for lang in post_data['LANG']:
            lkey = helpers.get_lkey(db, lang)
            db.insert('HOST_LANG', UUID=uuid, LKEY=lkey)

        # Insert in HOST_FEATURES
        for feature in post_data['FEATURES']:
            fkey = helpers.get_fkey(db, feature)
            db.insert('HOST_FEATURES', UUID=uuid, FKEY=fkey)

        # Insert in HOST_MIRRORS
        for mirror in post_data['GENTOO_MIRRORS']:
            mkey = helpers.get_mkey(db, mirror)
            db.insert('HOST_MIRRORS', UUID=uuid, MKEY=mkey)

        # Insert in GLOBAL_USEFLAGS
        for useflag in post_data['USE']:
            ukey = helpers.get_ukey(db, useflag)
            db.insert('GLOBAL_USEFLAGS', UUID=uuid, UKEY=ukey)

        # Handle PACKAGES
        for package in post_data['PACKAGES'].keys():
            pkey = helpers.get_pkey(db, package)
            post_data_pkg = post_data['PACKAGES'][package]
            kwkey = helpers.get_kwkey(db, post_data_pkg['KEYWORD'])
            rkey  = helpers.get_rkey(db, post_data_pkg['REPO'])
            build_time = int(post_data_pkg['BUILD_TIME']) if post_data_pkg['BUILD_TIME'] else None

            # Insert in INSTALLED_PACKAGES
            ipkey = db.insert('INSTALLED_PACKAGES', UUID=uuid, PKEY=pkey, BUILD_TIME=build_time,
                    COUNTER=post_data_pkg['COUNTER'], KWKEY=kwkey, RKEY=rkey, SIZE=post_data_pkg['SIZE'])

            # Insert in PLUS_USEFLAGS
            for useflag in post_data_pkg['USE']['PLUS']:
                ukey = helpers.get_ukey(db, useflag)
                db.insert('PLUS_USEFLAGS', IPKEY=ipkey, UKEY=ukey)

            # Insert in MINUS_USEFLAGS
            for useflag in post_data_pkg['USE']['MINUS']:
                ukey = helpers.get_ukey(db, useflag)
                db.insert('MINUS_USEFLAGS', IPKEY=ipkey, UKEY=ukey)

            # Insert in UNSET_USEFLAGS
            for useflag in post_data_pkg['USE']['UNSET']:
                ukey = helpers.get_ukey(db, useflag)
                db.insert('UNSET_USEFLAGS', IPKEY=ipkey, UKEY=ukey)

        return 'POST for ' + str_uuid + ' successful'