summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xrhimport12
-rw-r--r--rhimport.pm70
2 files changed, 60 insertions, 22 deletions
diff --git a/rhimport b/rhimport
index 49d981d..0ccfa0e 100755
--- a/rhimport
+++ b/rhimport
@@ -32,8 +32,8 @@ use lib '/usr/share/perl5/rhimport/';
use rhimport;
my $DBHOST = "airplay";
-my $DBUSER = "rivendellro";
-my $DBPW = "lldrivenro";
+my $DBUSER = "rivendell";
+my $DBPW = "lldriven";
my $DB = "rivendell";
my $HELP = 0;
my $FILE = "";
@@ -371,4 +371,10 @@ if($POOL) {
}
$dbh->disconnect();
-exit $ret;
+
+if($ret ne "") {
+ print STDERR $ret;
+ exit 1;
+}
+
+exit 0;
diff --git a/rhimport.pm b/rhimport.pm
index d4c5ab8..264119d 100644
--- a/rhimport.pm
+++ b/rhimport.pm
@@ -27,11 +27,13 @@ package rhimport;
use IO::Handle;
use IPC::Open3;
+use File::Spec;
my $ssh_host = "airplay";
my $ssh_user = "rhimport";
my $ssh_key_file = "id_dsa";
-my $ssh_dir = "~/.rhimport/";
+my $ssh_dir = "/programm/.rhimport";
+my $rdimport_wrapper = "/usr/local/bin/dropbox_newfile.pl";
sub get_dropboxes
{
@@ -118,16 +120,16 @@ sub clear_carts
}
$sth->finish();
-# my $sql = qq{delete from CUTS where CART_NUMBER='$cart';};
-# my $sth = $dbh->prepare($sql);
-# $sth->execute();
-# $sth->finish();
-
-# my $sql = qq{delete from CARTS where NUMBER='$cart';};
-# my $sth = $dbh->prepare($sql);
-# $sth->execute();
-# $sth->finish();
-
+ $sql = qq{delete from CUTS where CART_NUMBER='$cart';};
+ $sth = $dbh->prepare($sql);
+ $sth->execute();
+ $sth->finish();
+
+ $sql = qq{delete from CART where NUMBER='$cart';};
+ $sth = $dbh->prepare($sql);
+ $sth->execute();
+ $sth->finish();
+
$cart++;
}
}
@@ -157,7 +159,7 @@ sub import_playlist
}
$ret = import_file($entry, $dropbox);
- last if($ret != 0);
+ last if($ret ne "");
$cnt++;
}
@@ -186,7 +188,7 @@ sub import_single
sub scp_put_file {
my ($file) = @_;
- my @cmd = ( 'scp', '-prqB' , '-i', $ssh_key_file, $file, "$ssh_user\@$ssh_host:$ssh_dir" );
+ my @cmd = ( 'scp', '-prqB' , '-i', $ssh_key_file, $file, "$ssh_user\@$ssh_host:$ssh_dir/" );
my ($reader, $writer, $error ) = ( new IO::Handle, new IO::Handle, new IO::Handle );
$writer->autoflush(1);
local $SIG{CHLD} = 'DEFAULT';
@@ -194,11 +196,27 @@ sub scp_put_file {
waitpid $pid, 0;
my $errstr = "";
if ( $? >> 8 ) {
- my $errstr = join('', <$error>);
+ $errstr = join('', <$error>);
}
return $errstr;
}
+sub ssh_exec_command {
+ my ($command) = @_;
+ my @cmd = ( 'ssh', '-q' , '-i', $ssh_key_file, "$ssh_user\@$ssh_host" , $command );
+ my ($reader, $writer, $error ) = ( new IO::Handle, new IO::Handle, new IO::Handle );
+ $writer->autoflush(1);
+ local $SIG{CHLD} = 'DEFAULT';
+ my $pid = open3($writer, $reader, $error, @cmd);
+ waitpid $pid, 0;
+ my $out = join('', <$reader>);
+ my $errstr = "";
+ if ( $? >> 8 ) {
+ $errstr = join('', <$error>);
+ }
+ return ($out, $errstr);
+}
+
sub import_file
{
my ($file, $dropbox) = @_;
@@ -208,13 +226,23 @@ sub import_file
### copy file to master server and
my $err = scp_put_file($file);
- die $err unless $err eq "";
+ if($err ne "") {
+ print "Transfer Error\n";
+ return $err;
+ }
+ print "transferred .. ";
### remotly call rdimport
+ my ($volume, $directories, $remote_file) = File::Spec->splitpath($file);
+ $remote_file = "$ssh_dir/$remote_file";
+ my ($out ,$error) = ssh_exec_command("$rdimport_wrapper --path \"$dropbox\" --file \"$remote_file\"");
+ if($error ne "") {
+ print "Import Error\n";
+ return $error;
+ }
- print "Ok\n";
-
- return 0;
+ print "imported OK\n";
+ return "";
}
sub delete_file
@@ -222,7 +250,11 @@ sub delete_file
my ($filename) = @_;
print " - deleting $filename\n";
- ### call unlink on remote machine (master server)
+ my ($out ,$err) = ssh_exec_command("rm \"$filename\"");
+ if($err ne "") {
+ return 1;
+ }
+ return 0;
}
1;