hell and sqlite - Shell Programming and Scripting

ogoy · #1 (**permalink**) 05-20-2008

Hi everyone,

I have a requirement that requires me to fill an sqlite database with 100,000 entries (no duplicates).

I will start out by giving the command that will insert the values necessary to populate the database:

# sqlite /var/local/database/dblist "insert into list (owner_id,behavior,entry)

values(0,0,'newblacklistentry.com') "

The challenge would be to get a different output for the entry value 100,000 times!

We can start with newurl.com and maybe append a numerical character to the string e.g.

newurl1.com
newurl2.com
newurl3.com

* I'm running on Linux

Your thoughts?

Thanks for looking

Carlo

scarfake · #2 (**permalink**) 05-20-2008

try this:

Code:

#!/bin/sh
i=1
while [ $i -le 50 ]
do

sqlite /var/local/database/dblist "insert into list (owner_id,behavior,entry) values(0,0,'newblacklistentry$i.com') "

  i=`expr $i + 1`
done

if it works turn the value "50" to "100000" and let it roll

ogoy · #3 (**permalink**) 05-20-2008

Awesome! Works

Thanks scarfake

That's how we roll!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Perl - SQLite question	garric	Shell Programming and Scripting	4	04-09-2008 05:51 AM
sqlite database in HP-UX vs Linux	perlprg	HP-UX	1	05-08-2007 11:56 PM
sqlite issue?	brandan	UNIX for Dummies Questions & Answers	0	07-23-2004 07:44 PM
rpm hell!	knmwt15000	UNIX for Dummies Questions & Answers	7	03-27-2002 02:06 AM
negative UID/GID?!! I can see 'em but what the hell do they mean?!	hellz	UNIX for Dummies Questions & Answers	2	09-07-2001 12:18 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode