d7VVcCxF

1#!/bin/bash
2
3DB_DIR="/home/muse/dev/sqltest"
4DB="$DB_DIR/test2.db"
5SHOW_DIR="/home/muse/doujinshi"
6
7#Tags: __Contents__ (separated by \n)
8#Characters: __Characters__ (might not appear on some doujinshi)
9#Artist: __Artist__ (gotta implement this too)
10
11#Catefory: __Categrory__ (always Doujinshi afaik)
12#Language: __Language__ (always English)
13
14sqlite3 $DB "CREATE TABLE IF NOT EXISTS doujinshi (id INT, doujinshi TEXT, filename TEXT, show TEXT, pages INT, tags TEXT, artist TEXT, UNIQUE(id))"
15SHOW_COUNT="$(ls -1 $SHOW_DIR | wc -l)" #number of folders in show dir
16
17for (( i = 1; i < $SHOW_COUNT + 1; i++ )); do #for every show
18    #echo $i
19    FOLDER="$(ls -1 $SHOW_DIR | sed -n "$i p")"
20    #echo $SHOW
21    cd "$SHOW_DIR/$FOLDER"
22    #echo $("pwd")
23    DOUJINSHI_NUMBER="$(ls -1 | wc -l)"
24    #echo "$DOUJINSHI_NUMBER doujinshi"
25    for (( a = 1; a < $DOUJINSHI_NUMBER + 1; a++ )); do #for every doujinshi at folder
26        DOUJINSHI="$(ls -1 | sed -n "$a p")"
27        #echo $a: $DOUJINSHI
28        cd "$DOUJINSHI"
29        R="''"
30        iDOUJINSHI="${DOUJINSHI//\'/$R}"
31        #echo $("pwd")
32        FILENAME="$(ls -1tr | grep -e '-1.jpg')"
33        FILENAME=${FILENAME:0:${#FLINEAME} - 5}
34        PAGES="$(ls -1 | grep $FILENAME | wc -l)"
35        TAGS="$(cat __Contents__| tr "\r\n"  "; " | cut -d  "%" -f 1 | sed -e 's/;[[:space:]]*$//')"
36        ARTIST=$(cat __Artist__ | tr "\r\n" "|" | cut -d "|" -f 1)
37        SHOW=$(cat __Parody__ | tr "\r\n" "|" | cut -d "|" -f 1)
38        ID=$(cat __oid__)
39        #echo "$ID | $iDOUJINSHI | $FILENAME | $SHOW | $PAGES | $TAGS"
40        #DOESNT WORK:
41        #sqlite3 $DB "INSERT INTO [$SHOW] VALUES("[$DOUJINSHI]", "[$FILENAME]", [$PAGES], "[$TAGS]")"
42        #USE THIS INSTEAD:
43        sqlite3 $DB "INSERT INTO doujinshi VALUES ($ID, '$iDOUJINSHI', '$FILENAME', '$SHOW', $PAGES, '$TAGS', '$ARTIST')"
44        cd ..
45    done
46done