connorshea

https://wormhole.app/MBKn6#nztdHM323zzWZ5Iapf1u3g

connorshea

ANIME_SPECIFIC_PROPERTIES = [
  'P1811', # list of episodes
  'P1113', # number of episodes
  'P364', # original language of film or TV show
  'P449', # original broadcaster
  'P2047', # duration
  'P86', # composer
  'P57', # director

connorshea

require 'json'

gdq_schedule = JSON.parse(File.read('gdq.json'))

total_entries = gdq_schedule.count
puts "Total entries: #{total_entries}"
game_only_entries = gdq_schedule.filter { |entry| !entry['non_game'] }.count
puts "Game-only entries: #{game_only_entries}"
entries_with_vglist_ids = gdq_schedule.filter { |entry| !entry['vglist_id'].nil? }.count
puts "Entries with vglist IDs: #{entries_with_vglist_ids} (#{(entries_with_vglist_ids.fdiv(game_only_entries) * 100).round(2)}%)"

connorshea

connorshea

JSON array of games on vglist that have a Wikidata ID but the Wikidata item has no vglist ID property. These aren't added automatically because the names on vglist and Wikidata differ. Someone should go through each of these (possibly with a simple script that'll automatically open each item in your browser) and let you decide whether they match, but not me because I'm lazy.

connorshea

=> Booting Puma
=> Rails 6.0.3 application starting in development 
=> Run `rails server --help` for more startup options
Puma starting in single mode...
* Version 4.3.3 (ruby 2.6.5-p114), codename: Mysterious Traveller
* Min threads: 5, max threads: 5
* Environment: development
* Listening on tcp://127.0.0.1:3000
* Listening on tcp://[::1]:3000
Use Ctrl-C to stop

connorshea

[
  {
    "name": "Civilization",
    "wikidata_id": "Q368286",
    "mobygames_ids": [
      "civilization",
      "sid-meiers-civilization"
    ],
    "pcgw_id": "Civilization"
  },

connorshea

faker.rbi generation:

• bundle exec sord faker.rbi --no-sord-comments --replace-errors-with-untyped --replace-unresolved-with-untyped --skip-constants
• Replace all NOT_GIVEN with T.unsafe(nil).
  • This constant doesn't exist because we skipped generating constants, so we have to get rid of it.
• Replace the line def self.negative(legacy_from = T.unsafe(nil), legacy_to = T.unsafe(nil), from: -5000.00,, to: -1.00)); end with def self.negative(legacy_from = T.unsafe(nil), legacy_to = T.unsafe(nil), from: -5000.00, to: -1.00); end
  • This line is butchered because of a bug in YARD with negative numbers as default values.
• Replace all instances of String with ::String
  • These have to be done because otherwise Sorbet will thing we mean Faker::String >.>
  • Replace all returns(String) with returns(::String).
• Replace all T.nilable(String) with T.nilable(::String).

connorshea

This script is meant to be used to transfer a game library from Grouvee to vglist. :)

Import instructions:

1. Save grouvee_to_vglist_importer.rb locally.
2. Export your Grouvee library to a CSV file and save it as grouvee.csv in the same directory as grouvee-to-vglist-import.rb.
3. Create an account on vglist.co if you haven't already.
4. In your vglist settings, click "Developer" in the left sidebar.
5. Click "View Token" and copy the token shown.
6. Check your Ruby version (ruby -v).

connorshea

# typed: strong
# test_via: ../subscriptions.rb
module GraphQL
  ID_TYPE = T.let(GraphQL::Types::ID.graphql_definition, T.untyped)
  VERSION = T.let("1.10.0.pre1", T.untyped)
  INT_TYPE = T.let(GraphQL::Types::Int.graphql_definition, T.untyped)
  FLOAT_TYPE = T.let(GraphQL::Types::Float.graphql_definition, T.untyped)
  STRING_TYPE = T.let(GraphQL::Types::String.graphql_definition, T.untyped)
  BOOLEAN_TYPE = T.let(GraphQL::Types::Boolean.graphql_definition, T.untyped)