This project is a website to filter anime/video/tv characters based on some character-specific tags and properties.
- TypeScript
- Node.js
- Express.js
- MySQL
- Bulma.css
This project relies heavily on Full-text-search to return ranked queries.
-
Setup the project
git clone https://github.com/lepasq/cosplay-filter.git cd cosplay-filter npm install tsc public/js/script.ts
-
Next you need to set up your MySQL server, fill in your environment variables and run
schema.sql
. As an example, you should have a look at.env
:#.env DB_PORT=3306 PORT=4000 USR=root HOST=localhost DATABASE=Cosplay PASSWORD=12345678 CONNECTION_LIMIT=20
-
Next you need to change the path of your
.csv
files in the filesrc/models/schema.sql
to your local path. -
Finally, start the server
npm start
Example: human strong genre=amine
will query all anime characters with the
tags human
and strong
will query all anime characters with the
tags human
and strong
.
It is also possible to use MySQL query specific
operators,
like +
to indicate that a word must be present in each row, or -
to indicate that a word must not be present in a row.