yukihirai0505

USE [DATABASE NAME];
DROP procedure IF EXISTS `[PROCEDURES NAME]`;

DELIMITER $$
USE [TABLE NAME]$$

CREATE DEFINER=`[USER NAME]`@`[HOST NAME]` PROCEDURE `[PROCEDURES NAME]`(IN targetDate date)
BEGIN

  /* VARIABLE FOR CURSOR */

yukihirai0505

  // dtoSeqを5000で分割して、それぞれに別々のトークンを付与する
  protected def mapToken[T](dtoSeq: Seq[InstagramDto[T]], tokens: Seq[String]): Seq[InstagramDto[T]] = {
    dtoSeq.grouped(5000).toSeq.zipWithIndex.flatMap {
      case (d, i) => d.map { s =>
        def getIndex(index: Int): Int = {
          if (index < tokens.length) index
          else getIndex(index - tokens.length)
        }

yukihirai0505

# 全投稿view数順

SELECT
p.post_title,
pm.meta_value,
p.guid
FROM wp_posts p
INNER JOIN wp_postmeta pm
ON p.id = pm.post_id
AND pm.meta_key = "post_views_count"

yukihirai0505

var BK = SpreadsheetApp.getActiveSpreadsheet(),
  SHEET = BK.getSheetByName('portfolio');

function onOpen() {
  function showMenu() {
    var menu = [
      {name: "Get Crypto Currency Data", functionName: "setData"}
    ];
    BK.addMenu("Custom Management", menu);
  }

yukihirai0505

var BK = SpreadsheetApp.getActiveSpreadsheet(),
  SHEET = BK.getSheetByName('portfolio'),
  BTC_SYMBOL = 'BTC';

function onOpen() {
  function showMenu() {
    var menu = [
      {name: "Get Crypto Currency Data", functionName: "setData"}
    ];
    BK.addMenu("Custom Management", menu);

yukihirai0505

var BK = SpreadsheetApp.getActiveSpreadsheet(),
  SHEET = BK.getSheetByName('portfolio');

function onOpen() {
  function showMenu() {
    var menu = [
      {name: "Get Crypto Currency Data", functionName: "setData"}
    ];
    BK.addMenu("Custom Management", menu);
  }

yukihirai0505

1. フォロワーIDを取得する => 5,000*15で15分で75,000フォロワー取得可能
2. IDからユーザーを検索 => 100*900で15分で90,000分のユーザー情報取得可能

yukihirai0505

var BK = SpreadsheetApp.getActiveSpreadsheet(),
  SHEET = BK.getSheetByName('portfolio'),
  QUERY_STRING = Math.random(),
  BTC_SYMBOL = 'BTC';

function onOpen() {
  function showMenu() {
    var menu = [
      {name: "Get Crypto Currency Data", functionName: "setData"}
    ];

yukihirai0505

version: '2'
services:
  db:
    image: mysql:5.7
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: {root-pass}
      MYSQL_DATABASE: {db-name}
      MYSQL_USER: {user-name}
      MYSQL_PASSWORD: {user-password}

yukihirai0505

curl "https://www.google.co.jp/complete/search?hl=ja&output=toolbar&ie=utf-8&oe=utf-8&client=firefox&q=旦那"