Guest User

Untitled

a guest
Oct 6th, 2018
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. Code:
  2. #!/usr/bin/perl
  3.  
  4. use strict;
  5. use warnings;
  6.  
  7. use LWP::Simple;
  8. use DBI;
  9.  
  10. my $symbol = uc($ARGV[0]);
  11. my $host = "localhost";
  12. my $database = "stockanalysis";
  13. my $hostname = "localhost";
  14. my $port = 3306;
  15. my $dbuser = "root";
  16. my $dbpass = "pass";
  17. my $stocktable = "stock";
  18. my $stockdatatable = "stockdata";
  19.  
  20. sub doesStockExist
  21. {
  22. my $symbol = shift;
  23. my $dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";
  24. my $dbh = DBI->connect($dsn, $dbuser, $dbpass);
  25. my $drh = DBI->install_driver("mysql");
  26.  
  27. my $execute;
  28. my $numrows;
  29. my $results;
  30.  
  31.  
  32. my $sth = $dbh->prepare("SELECT * FROM $stocktable WHERE symbol = '$symbol'");
  33. $sth->execute();
  34. $numrows = $sth->rows();
  35.  
  36. print "numrows: $numrows\n";
  37. return 1;
  38. }
  39.  
  40.  
  41. Error:
  42.  
  43. install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /sw64/lib/perl5/darwin-thread-multi-2level /sw64/lib/perl5 /sw64/lib/perl5/darwin /Library/Perl/Updates/5.8.9 /System/Library/Perl/5.8.9/darwin-thread-multi-2level /System/Library/Perl/5.8.9 /Library/Perl/5.8.9/darwin-thread-multi-2level /Library/Perl/5.8.9 /Network/Library/Perl/5.8.9/darwin-thread-multi-2level /Network/Library/Perl/5.8.9 /Network/Library/Perl /System/Library/Perl/Extras/5.8.9/darwin-thread-multi-2level /System/Library/Perl/Extras/5.8.9 /Library/Perl/5.8.8 /Library/Perl/5.8.6 /Library/Perl/5.8.1 .) at (eval 4) line 3.
  44. Perhaps the DBD::mysql perl module hasn't been fully installed,
  45. or perhaps the capitalisation of 'mysql' isn't right.
  46. Available drivers: DBM, ExampleP, File, Gofer, Proxy, SQLite, Sponge.
  47. at ./grabstock line 23
Add Comment
Please, Sign In to add comment