th3-z/malgo

:floppy_disk: MyAnimeList XML to SQLite migration utility and Go library — command line tool also available

Malgo

A MyAnimeList SQL migration utility and Go library.

Cli exporter usage

• Export your list from MyAnimeList
• Run malgo -o anime.sqlite yourAnimeList.xml
• Receieve SQLite database ./anime.sqlite

Databases

Malgo has so far been tested with the following databases. Let me know if you have success with any of the other database drivers.

• Sqlite3

Golang examples

The golang module provides structs and functions for reading and editing the migrated database.

Migrate directly from an exported anime list and retrieve series.

malgo.storage.CreateSchema(someDb)
malgo.MigrateFile(someDb, "sample.xml")

user := malgo.models.SearchUser(someDb, "th3-z")
for _, review := range user.Reviews {
    print(review.Series.Name)
    print("\n")
}

Datatables example

A more complex example can be seen on my public website's repo. It produces the following table.

Building

Run make build to create a release for the CLI tool in ./bin.

Requirements

• Golang 1.13.x
• make
• gcc