/usr/bin/samizdat-role is in samizdat 0.7.0-1.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
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 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 | #!/usr/bin/env ruby
#
# Samizdat role management
#
# Copyright (c) 2002-2011 Dmitry Borodaenko <angdraug@debian.org>
#
# This program is free software.
# You can distribute/modify this program under the terms of
# the GNU General Public License version 3 or later.
#
# vim: et sw=2 sts=2 ts=8 tw=0
require 'samizdat'
require 'getoptlong'
class SamizdatRole
def initialize
opts = GetoptLong.new(
[ '--help', '-h', GetoptLong::NO_ARGUMENT ],
[ '--site', '-s', GetoptLong::REQUIRED_ARGUMENT ],
[ '--role', GetoptLong::REQUIRED_ARGUMENT ],
[ '--list', '-l', GetoptLong::NO_ARGUMENT ],
[ '--grant', '-g', GetoptLong::REQUIRED_ARGUMENT ],
[ '--revoke', '-r', GetoptLong::REQUIRED_ARGUMENT ]
)
@role = 'moderator'
@list = nil
@grant = nil
@revoke = nil
@member = nil
opts.each do |opt, arg|
case opt
when '--help'
usage
when '--site'
ENV['SAMIZDAT_SITE'] = arg
when '--role'
@role = arg
when '--list'
@list = true
when '--grant'
@grant = true
@member = arg
when '--revoke'
@revoke = true
@member = arg
end
end
unless @list or @grant or @revoke
usage
end
unless ENV['SAMIZDAT_SITE']
raise "Samizdat site must be defined in either --site option or SAMIZDAT_SITE environment variable"
end
if @grant or @revoke
set_id
set_dbroot
end
end
def run
if @grant or @revoke
@dbroot.transaction do
grant if @grant
revoke if @revoke
end
end
list if @list
end
private
def usage
puts %q{
Usage:
samizdat-role --help
display this message
samizdat-role [ OPTIONS ] --list
list members who have ROLE priviledges
samizdat-role [ OPTIONS ] --grant MEMBER
grant ROLE priviledges to MEMBER
samizdat-role [ OPTIONS ] --revoke MEMBER
revoke ROLE priviledges from MEMBER
Options:
--site SITE
name of the Samizdat site (overrides SAMIZDAT_SITE environment variable)
--role ROLE
name of a role, default is 'moderator'
--grant MEMBER, --revoke MEMBER
id or login of a member
NB: To grant or revoke priviledges using this command, you must use
database superuser priviledges (in PostgreSQL, this is 'postgres').
Example:
su postgres -c 'samizdat-role --site s1 --grant joe --role moderator --list'
Grant moderator priviledges to the member 'joe' of site 's1' and list all
moderators.
}
exit
end
def set_id
if @member.to_i > 0
@id = member.to_i
else
@id, = db.select_one(%q{SELECT id FROM Member WHERE login = ?}, @member)
@id or raise "Member #{@member} not found."
end
end
def set_dbroot
adapter = config['db']['adapter']
case adapter
when 'postgres'
@dbroot = Sequel.connect(
:adapter => adapter,
:host => config['db']['host'],
:database => config['db']['database'],
:user => 'postgres'
)
when 'sqlite'
@dbroot = db
else
raise "Database driver #{db.driver_name} is not supported by this command."
end
end
def list
puts "Members of the site #{ENV['SAMIZDAT_SITE']} with #{@role} priviledges:"
puts db.fetch(
%q{SELECT DISTINCT m.login
FROM role r
INNER JOIN member m ON r.member = m.id
WHERE r.role = ?
ORDER BY m.login}, @role
).all.map {|r| r[:login] }.join("\n")
end
def grant
data = {
:member => @id,
:role => @role
}
@dbroot[:role].filter(data).empty? or raise "Member #{@member} already has #{@role} priviledges."
@dbroot[:role].insert(data)
end
def revoke
@dbroot[:role].filter(:member => @id, :role => @role).delete
end
end
begin
SamizdatRole.new.run
rescue RuntimeError => e
puts "ERROR: " + e.message
exit 1
end
|