[pmg-devel] [PATCH WIP api 06/11] match groups: add functions for database access

[Leo Nunner <l.nunner@proxmox.com>]

Introduce functions to manage match groups in the database. This
includes adding and deleting match groups, as well as the ability to
load all match groups that are associated with one specific rule.

Signed-off-by: Leo Nunner <l.nunner@proxmox.com>
---
 src/PMG/RuleDB.pm | 82 +++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 82 insertions(+)

diff --git a/src/PMG/RuleDB.pm b/src/PMG/RuleDB.pm
index 98beda3..b126d0d 100644
--- a/src/PMG/RuleDB.pm
+++ b/src/PMG/RuleDB.pm
@@ -757,6 +757,70 @@ sub rule_remove_group {
     return 1;
 }
 
+sub rule_add_match_group {
+    my ($self, $ruleid, $gtype_str, $name) = @_;
+
+    defined($ruleid) || die "undefined rule id: ERROR";
+
+    $self->{dbh}->do("INSERT INTO MatchGroup " .
+		     "(RID, Class, Name) " .
+		     "VALUES (?, ?, ?)", undef,
+		     $ruleid, $gtype_str, $name);
+
+    return PMG::Utils::lastid($self->{dbh}, 'matchgroup_id_seq');
+}
+
+sub rule_remove_match_group {
+    my ($self, $ruleid, $groupid) = @_;
+
+    defined($ruleid) || die "undefined rule id: ERROR";
+    defined($groupid) || die "undefined group id: ERROR";
+
+    # first, we check whether there are any objects in this group
+    my $sth = $self->{dbh}->prepare("SELECT COUNT (*) FROM RuleGroup ".
+		     "WHERE Rule_ID = ? and MatchGroup = ?");
+
+    $sth->execute($ruleid, $groupid);
+    my ($count) = $sth->fetchrow_array;
+
+    die "Cannot delete non-empty match group" if $count;
+
+    $self->{dbh}->do("DELETE FROM MatchGroup WHERE " .
+		     "ID = ? and RID = ?", undef,
+		     $groupid, $ruleid);
+}
+
+sub load_match_groups {
+    my ($self, $rule) = @_;
+
+    defined($rule->{id}) || die "undefined rule id: ERROR";
+
+    my $sth = $self->{dbh}->prepare(
+	"SELECT ID, Name, Class " .
+	"FROM MatchGroup " .
+	"WHERE RID = ? " .
+	"ORDER BY Class");
+
+    $sth->execute($rule->{id});
+
+    my $matchgroups = [];
+
+    while (my $ref = $sth->fetchrow_hashref()) {
+	my $mg = {
+	    id => $ref->{id},
+	    class => $ref->{class},
+	    name => $ref->{name},
+	};
+
+	push @$matchgroups, $mg;
+    }
+
+    $sth->finish();
+
+    return $matchgroups;
+}
+
+
 
 sub rule_get_group_settings {
     my ($self, $ruleid, $groupid, $gtype_str) = @_;
@@ -797,6 +861,24 @@ sub rule_set_group_setting_negate {
     return 1;
 }
 
+sub rule_set_group_setting_matchgroup {
+    my ($self, $value, $ruleid, $groupid, $gtype_str) = @_;
+
+    my $gtype = $grouptype_hash->{$gtype_str} //
+	die "unknown group type '$gtype_str'\n";
+
+    defined($ruleid) || die "undefined rule id: ERROR";
+    defined($groupid) || die "undefined group id: ERROR";
+    defined($gtype) || die "undefined group type: ERROR";
+
+    my $sth = $self->{dbh}->prepare("UPDATE RuleGroup SET MatchGroup = ? " .
+		     "WHERE Objectgroup_ID = ? and Rule_ID = ? and Grouptype = ?");
+
+    $sth->execute($value, $groupid, $ruleid, $gtype);
+
+    return 1;
+}
+
 sub load_rule {
     my ($self, $id) = @_;
 
-- 
2.39.2