snipplrCallback({"id":37916,"title":"push-your-git-logs-to-mysql-with-php","source":"
  1. #!\/usr\/bin\/env php<\/div><\/li>
  2. \/**<\/div><\/li>
  3. CREATE TABLE `log` (<\/div><\/li>
  4. `id` int(10) unsigned NOT NULL auto_increment,<\/div><\/li>
  5. `repo` varchar(255) NOT NULL,<\/div><\/li>
  6. `commit` varchar(40) NOT NULL,<\/div><\/li>
  7. `date` datetime NOT NULL,<\/div><\/li>
  8. `message` text NOT NULL,<\/div><\/li>
  9. PRIMARY KEY (`id`),<\/div><\/li>
  10. UNIQUE KEY `commit` (`commit`)<\/div><\/li>
  11. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;<\/div><\/li>
  12. *\/<\/div><\/li>
  13. <?php<\/span><\/div><\/li>
  14. date_default_timezone_set<\/span><\/a>(<\/span>'Europe\/London'<\/span>)<\/span>;<\/span><\/div><\/li>
  15. exec<\/span><\/a>(<\/span>'pwd'<\/span>,<\/span>$pwd<\/span>)<\/span>;<\/span><\/div><\/li>
  16. $repo<\/span> =<\/span> rtrim<\/span><\/a>(<\/span>array_shift<\/span><\/a>(<\/span>$pwd<\/span>)<\/span>,<\/span>'\/'<\/span>)<\/span>;<\/span><\/div><\/li>
  17. $repo<\/span> =<\/span> substr<\/span><\/a>(<\/span>$repo<\/span>,<\/span>strrpos<\/span><\/a>(<\/span>$repo<\/span>,<\/span>'\/'<\/span>)<\/span> +<\/span> 1<\/span>)<\/span>;<\/span><\/div><\/li>
  18. $db<\/span> =<\/span> new<\/span> PDO(<\/span>'mysql:dbname=DB;host=127.0.0.1'<\/span>,<\/span>'USERNAME'<\/span>,<\/span>'PASSWORD'<\/span>)<\/span>;<\/span><\/div><\/li>
  19. exec<\/span><\/a>(<\/span>'git log --all --pretty=format:"%H%n%ct%n%s%n%b%n<><><>"'<\/span>,<\/span>$capture<\/span>,<\/span>$log<\/span>)<\/span>;<\/span><\/div><\/li>
  20. if<\/span> (<\/span>$capture<\/span>)<\/span>{<\/span><\/div><\/li>
  21.     \/\/ preprocess the log<\/span><\/div><\/li>
  22.     $commits<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span><\/div><\/li>
  23.     $current<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span><\/div><\/li>
  24.     foreach<\/span> (<\/span>$capture<\/span> as<\/span> $row<\/span>)<\/span>{<\/span><\/div><\/li>
  25.         if<\/span> (<\/span>trim<\/span><\/a>(<\/span>$row<\/span>)<\/span> ===<\/span> '<><><>'<\/span>)<\/span> {<\/span><\/div><\/li>
  26.             $commits<\/span>[<\/span>]<\/span> =<\/span> $current<\/span>;<\/span><\/div><\/li>
  27.             $current<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span><\/div><\/li>
  28.         }<\/span> else<\/span> {<\/span><\/div><\/li>
  29.             $current<\/span>[<\/span>]<\/span> =<\/span> $row<\/span>;<\/span><\/div><\/li>
  30.         }<\/span><\/div><\/li>
  31.     }<\/span><\/div><\/li>
  32.     $v<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span><\/div><\/li>
  33.     $b<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span><\/div><\/li>
  34.     foreach<\/span> (<\/span>$commits<\/span> as<\/span> $commit<\/span>)<\/span>{<\/span><\/div><\/li>
  35.         $sha<\/span> =<\/span> $commit<\/span>[<\/span>0<\/span>]<\/span>;<\/span><\/div><\/li>
  36.         $m<\/span> =<\/span> $commit<\/span>[<\/span>2<\/span>]<\/span> .<\/span> (<\/span>trim<\/span><\/a>(<\/span>$commit<\/span>[<\/span>3<\/span>]<\/span>)<\/span> ===<\/span> ''<\/span> ? ''<\/span> :<\/span> "\\n<\/span>\\n<\/span>"<\/span> .<\/span> implode<\/span><\/a>(<\/span>"\\n<\/span>"<\/span>,<\/span>array_slice<\/span><\/a>(<\/span>$commit<\/span>,<\/span>3<\/span>)<\/span>)<\/span>)<\/span>;<\/span><\/div><\/li>
  37.         $d<\/span> =<\/span> date<\/span><\/a>(<\/span>'Y-m-d H:i:s'<\/span>,<\/span>$commit<\/span>[<\/span>1<\/span>]<\/span>)<\/span>;<\/span><\/div><\/li>
  38.         $v<\/span>[<\/span>]<\/span> =<\/span> '(?,?,?,?)'<\/span>;<\/span><\/div><\/li>
  39.         $b<\/span>[<\/span>]<\/span> =<\/span> $repo<\/span>;<\/span><\/div><\/li>
  40.         $b<\/span>[<\/span>]<\/span> =<\/span> $sha<\/span>;<\/span><\/div><\/li>
  41.         $b<\/span>[<\/span>]<\/span> =<\/span> $m<\/span>;<\/span><\/div><\/li>
  42.         $b<\/span>[<\/span>]<\/span> =<\/span> $d<\/span>;<\/span><\/div><\/li>
  43.     }<\/span><\/div><\/li>
  44.     $stmt<\/span> =<\/span> $db<\/span>-><\/span>prepare<\/span>(<\/span>'insert ignore into log (repo,commit,message,`date`) values'<\/span> .<\/span> implode<\/span><\/a>(<\/span>','<\/span>,<\/span>$v<\/span>)<\/span>)<\/span>;<\/span><\/div><\/li>
  45.     try {<\/span><\/div><\/li>
  46.         if<\/span> (<\/span>$stmt<\/span>)<\/span> {<\/span><\/div><\/li>
  47.             if<\/span> (<\/span>!<\/span>$stmt<\/span>-><\/span>execute<\/span>(<\/span>$b<\/span>)<\/span>)<\/span> throw<\/span> new<\/span> PDOException;;<\/span><\/div><\/li>
  48.         }<\/span> else<\/span> Throw<\/span> new<\/span> PDOException;<\/span><\/div><\/li>
  49.     }<\/span> catch (<\/span>PDOException $e<\/span>)<\/span> {<\/span><\/div><\/li>
  50.         mail<\/span><\/a>(<\/span>'EMAIL'<\/span>,<\/span>'Commit did not reach db'<\/span>,<\/span>$e<\/span>-><\/span>getMessage<\/span>(<\/span>)<\/span>)<\/span>;<\/span><\/div><\/li>
  51.     }<\/span><\/div><\/li>
  52. }<\/span><\/div><\/li>
  53. ?><\/span><\/div><\/li><\/ol><\/pre>","link":"https:\/\/snipplr.com\/view\/37916\/push-your-git-logs-to-mysql-with-php"});