Import torrents from magnetico into bitmagnet DHT crawler

bitmagnet-magnetico-import.md

See bitmagnet's import endpoint documentation for more information.

sqlite3 -json -batch database.sqlite3 "$(cat magnetico-import.sql)" | 
  jq -r --indent 0 '.[]' | 
  curl --verbose -H "Content-Type: application/json" -H "Connection: close" --data-binary @- http://localhost:3333/import

magnetico-import.sql

SELECT
  "magnetico" AS source,
  hex(info_hash) AS infoHash,
  name,
  total_size AS size,
  strftime('%Y-%m-%dT%H:%M:%fZ', DATETIME(discovered_on, 'unixepoch')) AS publishedAt
FROM torrents
ORDER BY info_hash

-- you may want to enable the following line while testing your query
--limit 100