#!/bin/sh ## Feeding CSV as follows: ## user # C123456X DB=${1:-users.sq3} CSV=${2:-rmusers.csv} if [ ! -f $DB ]; then echo "You need to create user-sqlite3 file first" >&2 head $0 >&2; exit fi sqlite3 ${DB} <<-EOF .mode csv CREATE TEMPORARY TABLE rmuser(user); .import $CSV rmuser DELETE FROM rmuser WHERE user LIKE 'user'; -- rm CSV header select * from rmuser; select count(*) from rmuser; PRAGMA foreign_keys=on; SELECT count(user)||'users found' FROM users; DELETE FROM users WHERE user IN (SELECT user FROM rmuser); SELECT count(user)||'users remain' FROM users; EOF