DBFILE=linuxusers.db
PASSWDFILE=/etc/passwd
TABLENAME="USERS"

if ! [ -r "$PASSWDFILE" ]
then
	echo "Could not read $PASSWDFILE. Exiting..."
	exit 1
fi

echo "Preparing database file $DBFILE now..."
sqlite3 "$DBFILE" "DROP TABLE IF EXISTS $TABLENAME;"
sqlite3 "$DBFILE" "CREATE TABLE $TABLENAME (username not null, uid integer not null, gid integer not null, homedir text not null)"
echo "Database prepared, filling..."

ALL="$(grep -E "^([a-z0-9]*tux)|(vm[a-z0-9]*)|(root):" testpasswd | cut -d':' -f 1,3,4,6)"

echo "$ALL" | while read line
do
	_USER="$(echo "$line" | cut -d':' -f1)"
	_UID="$(echo "$line" | cut -d':' -f2)"
	_GID="$(echo "$line" | cut -d':' -f3)"
	_HOMEDIR="$(echo "$line" | cut -d':' -f4)"
	sqlite3 "$DBFILE" "INSERT INTO $TABLENAME VALUES ('$_USER', $_UID, $_GID, '$_HOMEDIR');"
done

echo "Database filled. Printing results:"
sqlite3 -header "$DBFILE" "SELECT username, gid, uid, homedir FROM USERS";