#!/bin/bash

# Tabelle für Benutzer anlegen
sqlite3 accounts.db <<SQL
  CREATE TABLE users ( 
    uid text, 
    password text, 
    uidNumber integer, 
    gidNumber integer, 
    gecos text, 
    home text, 
    shell text 
  );
SQL

# Benutzer importieren
while IFS=':' read uid password uidNumber gidNumber gecos home shell;   
do
  cat <<SQL
    INSERT INTO users ( uid, password, uidNumber, gidNumber, gecos, home, shell ) 
    VALUES ( '$uid', '$password', '$uidNumber', '$gidNumber', '$gecos', '$home', '$shell' ); 
SQL
done < /etc/passwd | sqlite3 accounts.db

## Tabellen für Gruppen anlegen
sqlite3 accounts.db <<SQL
  CREATE TABLE groups ( gid text, password text, gidNumber integer );
  CREATE TABLE members ( gidNumber integer, uid text );
SQL

## Gruppen importieren
while IFS=':' read gid password gidNumber members;  
do  
  cat <<SQL
    INSERT INTO groups ( gid, password, gidNumber ) 
      VALUES ( '$gid', '$password', '$gidNumber' );
SQL
done < /etc/group | sqlite3 accounts.db 

## Gruppenmitglieder importieren
while IFS=':' read gid password gidNumber members;
do
  for uid in $(echo $members | tr ',' ' ');
  do
    echo "INSERT INTO members ( gidNumber, uid ) VALUES ( '$gidNumber', '$uid' );" 
  done
done < /etc/group | sqlite3 accounts.db