Changeset 71de5a9f4a4ecbedfd441ffb2fe546714d77239e

Timestamp:

04/30/09 16:13:55 (3 years ago)

Author:

Neutron Soutmun <neo.neutron@…>

Children:

15110c771604f44d1b149a66b2d4f09f00fb585c

Parents:

58a7596ffa8e80a6c8db834191f7ce1f45fd44f9

git-committer:

Neutron Soutmun <neo.neutron@…> (04/30/09 16:13:55)

Message:

Add the updating table nas in database

2009-04-30 Neutron Soutmun <neo.neutron@…>

• tools/weblogin-config-update.sh.in: Add the updating table nas in database.

Files:

• ChangeLog (modified) (1 diff)
• tools/weblogin-config-update.sh.in (modified) (3 diffs)

ChangeLog

@@ +1 @@
+2009-04-30  Neutron Soutmun <neo.neutron@gmail.com>
+
+        * tools/weblogin-config-update.sh.in: Add the updating table nas in database.
+
 2009-04-30  Neutron Soutmun <neo.neutron@gmail.com>
 

tools/weblogin-config-update.sh.in

@@ -21 +21 @@
 # Main
 MAIN_CONF_DIR=`get_config_value main conf_dir $RAHUNAS_CONFIG`
+
+# DB
+RAHUNAS_DB=/etc/rahunas/rahunas.db
+SQLITE3=/usr/bin/sqlite3
 
 generate_config() {
@@ -68 +72 @@
 }
 
+update_db () {
+  file=$1
+
+  SETNAME=`get_section_name $file`
+  VSERVER_ID=`get_config_value $SETNAME vserver_id $file`
+  NAS_IDENTIFIER=`get_config_value $SETNAME nas_identifier $file`
+
+  SQL="REPLACE INTO nas VALUES ('$VSERVER_ID','$NAS_IDENTIFIER')"
+  $SQLITE3 $RAHUNAS_DB "$SQL"
+}
+
+clear_nas_db () {
+  SQL="DELETE FROM nas"
+  $SQLITE3 $RAHUNAS_DB "$SQL"
+}
+
 destfile="@sysconfdir@/rahunas/config.php"
 if [ "$1" != "" ]; then
@@ -80 +100 @@
   generate_config $file 
 done >> $destfile
+
+clear_nas_db
+for file in `find $MAIN_CONF_DIR -name '*.conf'`;
+do
+  update_db $file
+done