FusqlFS/Backend/MySQL/Users.pm untested

filter: Statementstmt 0.0% 0 / 69 Branchbran 0.0% 0 / 14 Conditioncond 0.0% 0 / 16 MC/DCmcdc 0.0% 0 / 10 Subroutinesub 0.0% 0 / 11 Podpod 0.0% 0 / 7 totaltotal 0.0% 0 / 127 CC 8 SCAR 24.1
CC
8
Cov
0%
get
30.0
create
6.0
drop
6.0
CRAP 11.1
1 use strict;
2 use 5.010;
3  
4 package FusqlFS::Backend::MySQL::Users;
5 use FusqlFS::Version;
6 our $VERSION = $FusqlFS::Version::VERSION;
7 use parent 'FusqlFS::Artifact';
8  
9 our @USER_PRIVILEGES = (
10 'Select' ,
11 'Insert' ,
12 'Update' ,
13 'Delete' ,
14 'Create' ,
15 'Drop' ,
16 'Reload' ,
17 'Shutdown' ,
18 'Process' ,
19 'File' ,
20 'Grant' ,
21 'References' ,
22 'Index' ,
23 'Alter' ,
24 'Show db' ,
25 'Super' ,
26 'Create tmp table' ,
27 'Lock tables' ,
28 'Execute' ,
29 'Repl slave' ,
30 'Repl client' ,
31 'Create view' ,
32 'Show view' ,
33 'Create routine' ,
34 'Alter routine' ,
35 'Create user' ,
36 'Event' ,
37 'Trigger' ,
38 'Create tablespace' ,
39 );
40 our @TABLE_PRIVILEGES = (
41 'Select' ,
42 'Insert' ,
43 'Update' ,
44 'Delete' ,
45 'Create' ,
46 'Drop' ,
47 'Grant' ,
48 'References' ,
49 'Index' ,
50 'Alter' ,
51 'Create view' ,
52 'Show view' ,
53 'Trigger' ,
54 );
55 our @COLUMN_PRIVILEGES = (
56 'Select' ,
57 'Insert' ,
58 'Update' ,
59 'References' ,
60 );
61 our @ROUTINE_PRIVILEGES = (
62 'Execute' ,
63 'Alter routine' ,
64 'Grant' ,
65 );
66  
67 sub init
68 {
69 my $self = shift;
70 $self->{list_expr} = $self->expr("SELECT CONCAT(User, '\@', Host) FROM mysql.user");
71 $self->{get_expr} = $self->expr("SELECT * FROM mysql.user WHERE User = ? AND Host = ?");
72 $self->{create_expr} = q{CREATE USER '%(User)$s'@'%(Host)$s'};
73 $self->{drop_expr} = q{DROP USER '%(User)$s'@'%(Host)$s'};
74 $self->{rename_expr} = q{RENAME USER '%(User)$s'@'%(Host)$s' TO '%(NewUser)$s'@'%(NewHost)$s'};
75 }
76  
77 sub list
78 {
79 my $self = shift;
80 return $self->all_col($self->{list_expr})||[];
81 }
82  
83 sub get
84 {
85 my $self = shift;
86 my ($user, $host) = split(/@/, shift, 2);
87 return unless $user || $host;
88  
89 my $data = $self->one_row($self->{get_expr}, $user, $host);
90 return unless $data;
91  
92 my @privileges = ();
93 my %result = ();
94 while (my ($name, $value) = each %$data) {
95 if ($name =~ /_priv$/) {
96 $name =~ s/_priv$//;
97 $name =~ s/_/ /g;
98 push @privileges, $name if $value == 'Y';
99 } else {
100 $result{$name} = $value;
101 }
102 }
103 $result{privileges} = \@privileges;
104  
105 return $self->dump(\%result);
106 }
107  
108 sub create
109 {
110 my $self = shift;
111 my ($user, $host) = split(/@/, shift, 2);
112 return unless $user || $host;
113  
114 $self->do($self->{create_expr}, {User => $user, Host => $host});
115 }
116  
117 sub drop
118 {
119 my $self = shift;
120 my ($user, $host) = split(/@/, shift, 2);
121 return unless $user || $host;
122  
123 $self->do($self->{drop_expr}, {User => $user, Host => $host});
124 }
125  
126 sub rename
127 {
128 my $self = shift;
129 my ($user, $host) = split(/@/, shift, 2);
130 my ($newuser, $newhost) = split(/@/, shift, 2);
131  
132 $self->do($self->{rename_expr}, {User => $user, Host => $host, NewUser => $newuser, NewHost => $newhost});
133 }
134  
135 sub store
136 {
137 my $self = shift;
138 my ($user, $host) = split(/@/, shift, 2);
139 return unless $user || $host;
140  
141 my $priv_re = join('|', @USER_PRIVILEGES);
142 $priv_re = qr/^$priv_re$/i;
143  
144 my $data = $self->validate(shift, {
145 max_connections => qr/^\d+$/,
146 max_questions => qr/^\d+$/,
147 max_updates => qr/^\d+$/,
148 max_user_connections => qr/^\d+$/,
149 priviledges => ['ARRAY', sub{ [ grep { $_ =~ $priv_re } @$_ ] }],
150 }) or return;
151  
152 $data->{User} = $user;
153 $data->{Host} = $host;
154 $data->{privileges} = join ',', @{$data->{privileges}};
155  
156 $self->do(q{REVOKE ALL ON *.* FROM '%(User)$s'@'%(Host)$s'}, {User => $user, Host => $host});
157 $self->do(q{GRANT %(privileges)$s ON *.* TO '%(User)$s'@'%(Host)$s' WITH MAX_QUERIES_PER_HOUR %(max_questions)$d MAX_UPDATES_PER_HOUR %(max_updates)$d MAX_CONNECTIONS_PER_HOUR %(max_connections)$d MAX_USER_CONNECTIONS %(max_user_connections)$d}, $data);
158 }
159  
160 __END__