/hydrus/ - Hydrus Network

how did you create a REST API for Hydrus, is it XML or JSON?

>>6675

JSON, i just took data from the db and used the spring framework to create the api,

for example the function getByTags() is mapped to "/api/getByTags/" so that when u go to "serverurl.com/api/getByTags/&tags=tags" it return a json with an array of 10 (by default) hashes

the hash will then be used to get the image or the thumbnail through "/api/media/" and "/api/thumb/"

>>6676

How did you do it?

Because I would like to use Python or JS to make a similar API.

>>6682

I wrote it in Kotlin, which is a language that runs on the Java Virtual Machine, basically it's java with more features.

The api was possible only with the Spring framework, i dont know which framework u can use in python but there surely will be some that let u do the same thing i did, just search for a framework.

I just know Django but i dont know if it's the same thing as Spring.

>>6683

How do you create an API along side Hydrus' source code (which originally does not have one)?

>>6684

I didn't use any code from hydrus source, i just used the databases from the db folder. This is also why u can't run this and hydrus together since they both ask a connection to the databases.

Best thing to do, would be for hydrus to implement directly an api; i think they're working on it.

>>6688

Never, I get this error when searching.

2017-09-05 01:32:44.176  INFO 2872 --- [nio-8080-exec-4] pr0.ves.hydrus.ss.HydrusDB               : Updating table cache
.cache_search_1
2017-09-05 01:32:44.176 ERROR 2872 --- [nio-8080-exec-4] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() fo
r servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is or
g.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: mappings.current_mappings_9)] wit
h root cause

org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such table: mappings.current_mappings_9)
        at org.sqlite.core.DB.newSQLException(DB.java:909) ~[sqlite-jdbc-3.20.0.jar:na]
        at org.sqlite.core.DB.newSQLException(DB.java:921) ~[sqlite-jdbc-3.20.0.jar:na]
        at org.sqlite.core.DB.throwex(DB.java:886) ~[sqlite-jdbc-3.20.0.jar:na]
        at org.sqlite.core.NativeDB.prepare_utf8(Native Method) ~[sqlite-jdbc-3.20.0.jar:na]
        at org.sqlite.core.NativeDB.prepare(NativeDB.java:127) ~[sqlite-jdbc-3.20.0.jar:na]
        at org.sqlite.core.DB.prepare(DB.java:227) ~[sqlite-jdbc-3.20.0.jar:na]
        at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:41) ~[sqlite-jdbc-3.20.0.jar:na]
        at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30) ~[sqlite-jdbc-3.20.0.jar:na]
        at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19) ~[sqlite-jdbc-3.20.0.jar:na]
        at ...

>SQL error or missing database

I don't know why, considering my path in settings.json is correct. "K:\\Hydrus Network\\db\\"

>>6689

the path is fine, it doesn't find the table. i think it's because hydrus names the mappings table dynamically, i used the name that was in my db. I'll have to look into that.

>>6688

if there's no error in the console it means that the api works but it just returns an empty array. Try to go to localhost:8080/api/getByTags/?tags=first_tag+second_tag

Remember to use "_" instead of spaces if there's a space in a tag like "one tag" u'll have to write "one_tag"

>>6690

>>6689

found the problem, hydrus names the mappings table based on the service that creates the maps.

I used current_mappings_9 because the service with id=9 is the one that gets the tag from a remote repository, as seen here https://hydrusnetwork.github.io/hydrus/help/getting_started_tags.html.

Now the problem is for each service that gets the tags hydrus creates a table.

I've just pushed an update, please pull this version and try it, please. Run

gradlew test

first to test the setup. Report any errors.

Thanks for the help.

too many please lol

>>6692

Thanks for looking into it.

It works now, however I don't think I'm getting the right tag search results back.

What determines how many tags I'm supposed to get back, for example?

Anyway I'm not expecting it to be perfectly working anything but its a neat thing to play around with

>>6701

I don't think i understand what you mean.

To test your query, go to:

localhost:8080/api/getByTags/?tags=first_tags+second_tag+-tag_to_exclude

By default this returns the last 10 hashes with those tags.

>>6706

could u pull the new version and try again?

i don't think it will work though.

Other than this i don't know how to recreate your problem on my pc, so i can't resolve the problem.

>>6706

I think i resolved the problem now, could u pull the new version?

It was because i counted only the subtags, which worked fine for normal tags but not with charachter, series, etc… tags