Advertisement
Guest User

Untitled

a guest
Jun 6th, 2017
299
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.63 KB | None | 0 0
  1. #!/bin/bash
  2. DBNAME="NIMHIX_ADMIN"
  3. DBHOST=localhost;
  4. DBUSER=xxxxx;
  5. DBPASS=xxxxx;
  6. DBTABLE=PAQUETES;
  7. LISTDIR=/home/xxxxx/nlista/lista/;
  8. for i in `ls $LISTDIR`
  9.  do
  10. descline=`cat -n $LISTDIR$i | grep -i Description | awk '{print $1}'`
  11. taskline=`cat -n $LISTDIR$i | grep -i Task: | awk '{print $1}'`
  12. enddesc=$(echo  $taskline-1 | bc)
  13.  
  14.  
  15.   packname=` grep  Package: $LISTDIR$i | awk '{ print $2 }' `
  16.   version=` grep  Version: $LISTDIR$i | awk '{ print $2 }'  `
  17.   maintainer=` grep  ^Maintainer: $LISTDIR$i | cut -d : -f 2 `
  18.   section=` grep  Section: $LISTDIR$i | cut -d : -f 2 `
  19.   priority=` grep  Priority: $LISTDIR$i | cut -d : -f 2 `
  20.   arch=`rgrep Filename: $LISTDIR$i | cut -d ' ' -f 2 | awk -F _ '{print $NF}' | cut -f 1 -d .`
  21.   depends=`rgrep Depends: $LISTDIR$i | cut -d : -f 2 `;
  22.   recommends=`rgrep Recommends: $LISTDIR$i | cut -d : -f 2 `;
  23.   suggests=`rgrep Suggests: $LISTDIR$i | cut -d : -f 2 `;
  24.   conflicts=`rgrep Conflicts: $LISTDIR$i | cut -d : -f 2 `;
  25.   replaces=`rgrep Replaces: $LISTDIR$i | cut -d : -f 2 `;
  26.   description=`sed -n "${descline},${enddesc}p" $LISTDIR$i|sed '/^Homepage:|Bugs:|Origin:|Supported:/d'|sed 's/,//g'|tr "'" " "`
  27. #  description=`echo $description | tr "`" " " | tr "'" " " | tr "," " " `
  28.   echo "INSERT INTO $DBTABLE ("PACKFN","MAINTAINER","SECTION","PRIORITY","PAQUETE","ARCHITECTURE","DEPENDS","RECOMMENDS","SUGGESTS","CONFLICTS","REPLACES","DESCRIPTION") \
  29.         VALUES ('$packname-$version','$maintainer','$section','$priority','$packname','$arch','$depends','$recommends','$suggests','$conflicts','$replaces','$description');" \
  30.          | mysql -uroot -pxxxx -h 192.168.10.44 $DBNAME
  31.  
  32.  done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement