[Lsb-messages] /var/www/bzr/lsb/devel/libtodb2 r36: Script to add symbold versions to the db

[Denis Silakov]

------------------------------------------------------------
revno: 36
committer: Denis Silakov <denis.silakov at rosalab.ru>
branch nick: libtodb2
timestamp: Wed 2012-09-19 10:26:54 +0400
message:
  Script to add symbold versions to the db
added:
  add_symbol_versions.sh
-------------- next part --------------
=== added file 'add_symbol_versions.sh'
--- a/add_symbol_versions.sh	1970-01-01 00:00:00 +0000
+++ b/add_symbol_versions.sh	2012-09-19 06:26:54 +0000
@@ -0,0 +1,12 @@
+#!/bin/sh
+
+for f in $@
+do
+    cat "$f" | grep -v ';$' | sed 's/;/ /' | while read name vers
+    do
+	echo "INSERT IGNORE INTO Version (Vid,Vname) VALUES(0,'$vers');"
+	echo "SET @Vid=(SELECT Vid FROM Version WHERE Vname='$vers');"
+	echo "UPDATE Interface JOIN ArchInt ON AIInt=Iid SET AIversion=@Vid WHERE Iname='$name' AND AIversion=0;"
+    done
+done
+