tkgstrator

      WITH results AS (
        SELECT 
          MAX(golden_ikura_num) AS golden_ikura_num, 
          RANK() OVER(
            ORDER BY 
              MAX(golden_ikura_num) DESC,
			  MAX(golden_ikura_pop_num) DESC
          ):: INT, 
          members, 
          names 

tkgstrator

import requests
import os
import json

def download_results():
  for offset in range(0, 92000, 200):
    url = f"http://localhost:3030/v1/results?offset={offset}&limit=200"
    response = requests.get(url).text
    with open(f"results/{str(offset).zfill(6)}.json", "w") as f:
      f.write(response)

tkgstrator

import sys, datetime, os
import subprocess
from concurrent import futures

def main():
    print(f"Python {sys.version}")
    try:
        fileName = sys.argv[1]
        dirName = os.path.splitext(fileName)[0]
        if not os.path.exists(f"Input_{dirName}"):

tkgstrator

// Swift5

extension String {
    /// 先頭だけ大文字化
    private func capitalize() -> String {
        return prefix(1).capitalized + dropFirst()
    }
    
    /// _で区切って、区切った直後に先頭だけ大文字化
    fileprivate func convertToCamelCase() -> String {

tkgstrator

{
  "topic_id": "nx_data_01003bc0000a0000",
  "service_status": "in_service",
  "na_required": true,
  "required_application_version": 0,
  "directories": [
    {
      "name": "fesdata",
      "mode": "sync",
      "by_country_group": false,

tkgstrator

{
   "analysisReportCommentNo":"2963",
   "artistName":"GARNET CROW",
   "bonusPoint":"802",
   "bonusType":"1",
   "clubDamCardNo":"0060000003019182",
   "contentsName":"夏の幻",
   "dArtistName":"GARNET CROW",
   "dContentsName":"夏の幻",
   "damserial":"AM023056",

tkgstrator

//
//  NullCodable.swift
//  SplatNet2
//
//  Created by tkgstrator on 2021/11/20.
//  Copyright © 2021 Magi, Corporation. All rights reserved.
//

import Foundation

tkgstrator

extension String {
    var convertToCamelCase: String {
        var currentIndex = self.startIndex

        return self.map({
            if currentIndex != startIndex && String(describing: self[index(before: currentIndex)]) == "_" {
                currentIndex = index(after: currentIndex)
                return String(describing: $0).uppercased()
            }
            if String(describing: self[currentIndex]) == "_" {

tkgstrator

//  SFSymbol.swift
//  SwiftyUI
//
//  Created by Shiota Kyotaro on 2021/10/25.
//  
//

import Foundation
import SwiftUI

tkgstrator

/// iOS15.0
// フォント名をすべて取得するコード
// UIFont.familyNames.sorted().flatMap({ Set(UIFont.fontNames(forFamilyName: $0)) })

import Foundation

enum FontStyle: String, CaseIterable {
    case AcademyEngravedLetPlain = "AcademyEngravedLetPlain"
    case AlNile = "AlNile"
    case AlNile_Bold = "AlNile-Bold"