1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
# myal - My Anime Library
## Overview
My Anime Library is a cli-tool written in C to manage an anime and manga list.
I used to track which anime I have watched and what episode I'm on by writing in
a text file, which got annoying after a while.
This is why I created this tool to keep anime and manga organized in a sqlite3
database.
Is it a complete overkill to write this in C? Yes
But why not? I wanted some practice with C, so if you see any glaring errors or
unsafe code feel free to point it out and roast me.
## Quickstart
You need a database with tables `anime` and `manga`. Attached in this repo
is a setup script for the database. Simply execute
```
sqlite3 library.db <db-setup.sql
```
This will create the following tables:
anime(ID integer pk, NAME text, EPISODE text, STATUS text)
manga(ID integer pk, NAME text, CHAPTER text, STATUS text)
Chapters and episodes are stored as text, because sometimes the chapter isn't
just a number but rather in the form "Volume 6 Chapter 4", shortened to "V6CH4".
When I'm done with an anime or manga, I set the episode or chapter to 0 and set
the status to "done".
You need to set the filepath to your db-file in the main.c, but everything else
should work out of the box.
The Makefile uses clang, because that's what I prefer, but you can change it
to gcc in the second line. Or you could simply do
```
gcc -o myal main.c -lsqlite3
```
## Usage
Currently there are 4 modes:
- get, which retrieves an anime or manga by the given name argument
- set, which updates the episode or chapter of a given entry
- status, which updates the status of a given entry
- add, which adds a new entry to a given table
Here are examples for each mode:
```
myal get anime jojo
```
Assuming the database contains "JoJo's Bizarre Adventure" and "JoJo's Bizarre
Adventure - Stardust Crusaders", both will be retrieved.
```
myal set manga "Nikubami Honegishimi" 3
```
This will set the chapter of the entry "Nikubami Honegishimi" to 3. The qoutes
are needed because of the whitespace in the name.
```
myal status anime Jigokuraku done
```
This will set the status of the entry "Jigokuraku" to "done".
```
myal add anime "Detective Conan" 1 "not started"
```
This will add the entry "Detective Conan" with the episode 1 set to the status
"not started" to the anime table.
|
