sql - How can I increase the port value when I get "already allocated port number" -


in script set unique constraint port field. if once enter assigned port number new row value not insert. want increase port number when enter assigned port number. please me

#!/bin/bash  echo " --- enter database name ---" #name of database read databasename  echo " --- enter table name --- " #name of table read table_name  sqlite3 $databasename.db $table_name;  sqlite3 $databasename.db  "create table if not exists $table_name(cus_id integer primary key autoincrement unique,cus_name text not null unique ,cus_domain text unique,created_on default current_date,cus_status text not null,port integer not null unique);" #table creation  sqlite3 $databasename.db "select * $table_name;"  echo " --- enter total number of customer records want ---" read cus_count # number of rows value  echo "enter following details 1 one"  red='\033[0;31m' nc='\033[0m'  echo "---enter initial port number---" echo "!!!before enter port number please verify table!!!" read port  port_num=$port declare -a customer  for((i=1;i<=cus_count;i++)) echo "enter $i customer details"  echo "---enter customer name---" read c_name  d_name=${c_name,,} #echo $d_name  customer=$(sqlite3 $databasename.db "select cus_domain $table_name cus_domain '$d_name';")  cus in "${customer[@]}"  if [[ $d_name != $customer ]];      echo "---enter status(active/inactive)---"      read c_status    #sqlite3 $databasename.db "create unique index on $table_name(port) cus_status = 'active';"  if [[ "$port_num" == "$port_num" ]];        port_num=$(($port_num + 1))  c_domain="$c_name"     sqlite3 $databasename.db "insert or ignore $table_name (cus_name,cus_domain,cus_status, port) values(\"$c_name\",\"${c_domain,,}\",\"$c_status\",\"$port_num\") ;"  fi   else     echo -e "${red}!!!oops entered customer name  domain name assigned!!!${nc}"     echo -e "${red}please enter new customer name${nc}"  i=$(($i - 1))  fi done done  echo " --- records $table_name ---"  sqlite3 $databasename.db "select * $table_name;" 

for example table has following values:

1|ajax|ajax|2017-08-21|active|8062  2|vvcoe|vvcoe|2017-08-21|active|8063 

now enter new row values insert

3|vvm|vvm|2017-08-21|active|8063 

here 8063 assigned port number

so want increase port value 8064.

how can modify this..?


Comments

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

php - How can i create a user dashboard -

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -