3 SDNC_DB_USER=${SDNC_DB_USER:-sdnctl}
4 SDNC_DB_PASSWORD=${SDNC_DB_PASSWORD:-gamma}
5 SDNC_DB_DATABASE=${SDNC_DB_DATABASE:-sdnctl}
6 MYSQL_HOST=${MYSQL_HOST:-dbhost}
12 mysql --user=${SDNC_DB_USER} --password=${SDNC_DB_PASSWORD} --host ${MYSQL_HOST} ${SDNC_DB_DATABASE} <<EOF
13 INSERT INTO VLAN_ID_POOL (purpose, status, vlan_id) VALUES('VNI', 'AVAILABLE', $start);
20 while [ $vlanid -le $stop ]
22 mysql --user=${SDNC_DB_USER} --password=${SDNC_DB_PASSWORD} --host ${MYSQL_HOST} ${SDNC_DB_DATABASE} <<EOF
23 INSERT INTO VLAN_ID_POOL (purpose, status, vlan_id) VALUES( 'VNI', 'AVAILABLE', $vlanid);
25 vlanid=$(( vlanid+1 ))
28 echo "Usage: $0 start [stop]"