summaryrefslogtreecommitdiff
path: root/lib/VNDB/Util/DB.pm
diff options
context:
space:
mode:
authoryorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b>2008-04-24 17:48:59 +0000
committeryorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b>2008-04-24 17:48:59 +0000
commitd2efb163c11a11e02abd7251fdfde3cb54c710ef (patch)
tree848de5db61c434d38adc8871f4999ea344b196fe /lib/VNDB/Util/DB.pm
parent491d871612f7e4d351d533d30fe942332132ea41 (diff)
See the diff for lib/ChangeLog...
git-svn-id: svn://vndb.org/vndb@4 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
Diffstat (limited to 'lib/VNDB/Util/DB.pm')
-rw-r--r--lib/VNDB/Util/DB.pm20
1 files changed, 11 insertions, 9 deletions
diff --git a/lib/VNDB/Util/DB.pm b/lib/VNDB/Util/DB.pm
index 59088387..c93e0997 100644
--- a/lib/VNDB/Util/DB.pm
+++ b/lib/VNDB/Util/DB.pm
@@ -16,7 +16,7 @@ $VERSION = $VNDB::VERSION;
DBGetUser DBAddUser DBUpdateUser
DBGetVotes DBVoteStats DBAddVote DBDelVote
DBGetVNList DBVNListStats DBAddVNList DBEditVNList DBDelVNList
- DBGetVN DBAddVN DBEditVN DBDelVN DBHideVN
+ DBGetVN DBAddVN DBEditVN DBDelVN DBHideVN DBUndefRG
DBGetRelease DBAddRelease DBEditRelease DBDelRelease DBHideRelease
DBGetProducer DBGetProducerVN DBAddProducer DBEditProducer DBDelProducer DBHideProducer
DBExec DBRow DBAll DBLastId
@@ -35,7 +35,7 @@ sub new {
my $me = shift;
my $type = ref($me) || $me;
- $me = bless { @_ }, $type;
+ $me = bless { o => \@_ }, $type;
$me->DBInit();
@@ -47,13 +47,7 @@ sub DBInit {
my $self = shift;
my $info = $self->{_DB} || $self;
- my $settings;
- $settings .= "host=$info->{host};" if $info->{host};
- $settings .= "port=$info->{port};" if $info->{port};
- $settings .= "dbname=$info->{database}";
-
- $info->{sql} = DBI->connect("dbi:Pg:$settings",
- $info->{user}, $info->{passwd}, {
+ $info->{sql} = DBI->connect(@{$self->{o}}, {
PrintError => 0, RaiseError => 1,
AutoCommit => 0, pg_enable_utf8 => 1,
}
@@ -802,6 +796,14 @@ sub DBHideVN { # id, hidden
}
+sub DBUndefRG { # ids
+ my($s, @id) = @_;
+ $s->DBExec(q|
+ UPDATE vn
+ SET rgraph = 0
+ WHERE id IN(!l)|,
+ \@id);
+}
#-----------------------------------------------------------------------------#