sr / beadmin

Python scripts hacked together to manage bearnaise.net

This URL has Read+Write access

Added database schema (it's maybe useful)
Jordan Bracco (author)
Tue Dec 23 12:37:28 -0800 2008
Simon Rozet (committer)
Tue Dec 23 12:52:28 -0800 2008
commit  df16ade7caa8fa72f01776591a3d3a983d6bbfd7
tree    55f1802dfc287552ada8705e5dadf0a37a082913
parent  212a26ec1b61df3cf78643cc7f79956b7797442f
beadmin / emails-aliases.py
100755 30 lines (24 sloc) 0.701 kb
raw blame history 
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

#!/usr/bin/env python
#-*- coding: utf8 -*-
 
#from dialog import *
import database as db
import dbconf
import os
 
if os.environ.has_key('SUDO_USER'):
	user =  os.environ['SUDO_USER']
else:
	user = 'root'
 
aliases = db.query("""SELECT source as username, name as domain, destination
FROM mailaliases, users, domains
WHERE mailaliases.id_users = users.id
AND mailaliases.domain_id = domains.id
AND users.login = $user
ORDER BY source""", vars=locals())
 
print 'total %s' % len(aliases)
 
for alias in aliases:
	if not alias.username:
		username = '*'
	else:
		username = alias.username
	destinations = alias.destination.split(',')
	print '%s@%s -> %s' % (username, alias.domain, ', '.join(destinations))