[racktables-users] Re: Mass object creation

  • From: Wawrzek Niewodniczanski <wawrzek.niewodniczanski@xxxxxxxxxx>
  • To: <racktables-users@xxxxxxxxxxxxx>
  • Date: Fri, 2 Sep 2011 10:24:09 +0100

On 09/01/11 14:20, Robert Parten wrote:
I have about 200 objects of the same type to create so I am wondering if there is any way to do this as a "one liner" script that creates objects "server" with names server{001-150}

You can try following shell script to create a SQL batch file you can later import to your Rackables database.

for ((i=1;i<=150;i++))
printf "INSERT INTO RackObject (name, objtype_id) SELECT '%03d', 4 \n" $i


Wawrzyniec (Wawrzek) Niewodniczański - 01223 435603 (35603) - wawrzekn
System Administrator - Engineering Services Team (XenServer)
Citrix Systems, Building 101, Cambridge Science Park, CB4 0FY, Cambridge
PhD in Quantum Chemistry, MSc in Molecular Engineering

Other related posts: