[sr-dev] git:master: kamctl: db connect - new command for db management subset

[Daniel-Constantin Mierla]

Module: sip-router
Branch: master
Commit: e395c9bb0131d7fce80af67c54cd813532e5f2ed
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=e395c9bb0131d7fce80af67c54cd813532e5f2ed

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date:   Mon Mar  3 18:16:54 2014 +0100

kamctl: db connect - new command for db management subset

- execute to command line client tool and stay connected using the
  attributes from kamctlrc
- handy when kamctlrc is set, to avoid typing all the attributes when
  willing to connect to kamailio database

---

 utils/kamctl/kamctl       |    7 +++++++
 utils/kamctl/kamctl.mysql |    7 +++++++
 2 files changed, 14 insertions(+), 0 deletions(-)

diff --git a/utils/kamctl/kamctl b/utils/kamctl/kamctl
index 519da55..30dddcf 100755
--- a/utils/kamctl/kamctl
+++ b/utils/kamctl/kamctl
@@ -1010,6 +1010,13 @@ db_ops() {
 			QUERY="SELECT * FROM $1 WHERE $2=$3\\G;"
 			$DBROCMD "$QUERY"
 			;;
+		connect)
+			shift
+			if [ -z "$DBCMDCONNECT" ] ; then
+				merr "extension not implemented"
+				exit 1
+			fi
+			$DBCMDCONNECT
 		*)
 			usage_db_ops
 			exit 1
diff --git a/utils/kamctl/kamctl.mysql b/utils/kamctl/kamctl.mysql
index e533e9c..1b25d2a 100644
--- a/utils/kamctl/kamctl.mysql
+++ b/utils/kamctl/kamctl.mysql
@@ -42,7 +42,14 @@ mysql_ro_query() {
 	$MYSQL $2 -h $DBHOST -u $DBROUSER "-p$DBROPW" -e "$1 ;" $DBNAME
 }
 
+mysql_connect() {
+	# if password not yet queried, query it now
+	prompt_pw "MySQL password for user '$DBRWUSER@$DBHOST'"
+	$MYSQL $2 -h $DBHOST -u $DBRWUSER "-p$DBRWPW" $DBNAME
+}
+
 DBCMD=mysql_query
 DBROCMD=mysql_ro_query
 DBRAWPARAMS="-B"
+DBCMDCONNECT=mysql_connect