Skip to content

Instantly share code, notes, and snippets.

@hiroism007

hiroism007/create_dammies.rb

Last active December 18, 2015 05:29
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save hiroism007/5733430 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save hiroism007/5733430 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. hiroism007 revised this gist Jun 9, 2013. 1 changed file with 49 additions and 8 deletions.
    57 changes: 49 additions & 8 deletions create_dammies.rb
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,5 @@
    class CreateDammies
    require "rubygems"
    require "mysql2"

    @@ -44,7 +44,7 @@ def create_category(numbers)
    def create_project(numbers)
    numbers.times do |index|
    user_id = index + 1
    #いまだけ+5です。DBが5から始まるので。普通は1
    #いまだけ+5です。カテゴリーDBが5から始まるので。普通は1
    category_id = index + 5
    name = "category " + (index+1).to_s
    comment_date = "2013-06-08 00:49:36"
    @@ -56,7 +56,7 @@ def create_project(numbers)

    def create_source(numbers)
    numbers.times do |index|
    #いまだけ+90です。DBが5から始まるので。普通は1
    #いまだけ+90です。projectのDBが90か始まるので。普通は1
    project_id = index + 90
    name = "test_source" + (index + 1).to_s
    @client.query("INSERT INTO source (project_id, name) VALUES ('#{project_id}','#{name}')")
    @@ -66,7 +66,7 @@ def create_source(numbers)
    def create_comment(numbers)
    numbers.times do |index|
    user_id = index +1
    #いまだけ+295です。DBが5から始まるので。普通は1
    #いまだけ+295です。sourceのDBが295から始まるので。普通は1
    source_id = index + 295
    nice_count = index + 10
    @client.query("INSERT INTO comment (user_id, source_id, nice_count) VALUES ('#{user_id}', '#{source_id}', '#{nice_count}')")
    @@ -76,12 +76,49 @@ def create_comment(numbers)
    def create_nice(numbers)
    numbers.times do |index|
    user_id = index + 1;
    #いまだけ+54610です。DBが5から始まるので。普通は1
    comment_id = index + 54610;
    #いまだけ+54515です。コメントのDBが54515から始まるので。普通は1
    comment_id = index + 54515;
    @client.query("INSERT INTO nice (user_id, comment_id) VALUES ('#{user_id}', '#{comment_id}')")
    end
    end

    def create_battle(numbers)
    numbers.times do |index|
    winner_id = index + 1
    loser_id = 100 - index
    @client.query("INSERT INTO battle (winner_id, loser_id) VALUES ('#{winner_id}', '#{loser_id}')")
    end
    end

    def create_collect_badge(numbers)
    numbers.times do |index|
    user_id = +1
    badge_id = get_random_number(100)
    @client.query("INSERT INTO collect_badge (user_id, badge_id) VALUES ('#{user_id}', '#{badge_id}')")
    end
    end

    def create_collect_monster(numbers)
    numbers.times do |index|
    user_id = index +1
    monster_id = get_random_number(100)
    @client.query("INSERT INTO collect_monster (user_id, monster_id) VALUES ('#{user_id}', '#{monster_id}')")
    end
    end

    def create_monster_user(numbers)
    numbers.times do |index|
    user_id = index +1
    monster_id = get_random_number(100)
    @client.query("INSERT INTO monster_user (user_id, monster_id) VALUES ('#{user_id}', '#{monster_id}')")
    end
    end

    private
    def get_random_number(num)
    rand(num) + 1
    end

    end

    client = CreateDammies.new();
    @@ -91,6 +128,10 @@ def create_nice(numbers)
    client.create_monster(numbers)
    client.create_category(numbers)
    client.create_project(numbers)
    client.create_source(numbers)se
    client.create_source(numbers)
    client.create_comment(numbers)
    client.create_nice(numbers)
    client.create_nice(numbers)
    client.create_battle(50)
    client.create_collect_badge(100)
    client.create_collect_monster(100)
    client.create_monster_user(100)
  2. hiroism007 revised this gist Jun 8, 2013. No changes.
  3. hiroism007 revised this gist Jun 8, 2013. 1 changed file with 7 additions and 7 deletions.
    14 changes: 7 additions & 7 deletions create_dammies.rb
    View file
    Original file line number Diff line number Diff line change
    @@ -86,11 +86,11 @@ def create_nice(numbers)

    client = CreateDammies.new();
    numbers = 100
    # client.create_user(numbers)
    # client.create_badge(numbers)
    # client.create_monster(numbers)
    # client.create_category(numbers)
    # client.create_project(numbers)
    # client.create_source(numbers)se
    # client.create_comment(numbers)
    client.create_user(numbers)
    client.create_badge(numbers)
    client.create_monster(numbers)
    client.create_category(numbers)
    client.create_project(numbers)
    client.create_source(numbers)se
    client.create_comment(numbers)
    client.create_nice(numbers)
  4. hiroism007 created this gist Jun 8, 2013.
    96 changes: 96 additions & 0 deletions create_dammies.rb
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,96 @@
    class CreateDammies

    require "rubygems"
    require "mysql2"

    def initialize(host = "localhost", username = "root", password = "", database = "nicomon")
    @client = Mysql2::Client.new(host: host, username: username, password: "", database: database)
    end

    def create_user(numbers)
    numbers.times do |index|
    name = "test_user" + (index + 1).to_s
    passwd = "passwd" + (index + 1).to_s
    @client.query("INSERT INTO user (name, passwd) VALUES ('#{name}','#{passwd}')");
    end
    end

    def create_badge(numbers)
    numbers.times do |index|
    name = "test_badge" + (index + 1).to_s
    text = "text" + (index + 1).to_s
    @client.query("INSERT INTO badge (name, text) VALUES ('#{name}','#{text}')");
    end
    end

    def create_monster(numbers)
    numbers.times do |index|
    name = "test_name_ja" + (index + 1).to_s
    name_en = "test_name_en" + (index + 1).to_s
    max_lv = (index + 11).to_s
    min_lv = (index + 1).to_s
    static_param = index + 1
    @client.query("INSERT INTO monster(name, name_en, max_lv, min_lv, static_param) VALUES ('#{name}','#{name_en}','#{max_lv}','#{min_lv}','#{static_param}')");
    end
    end

    def create_category(numbers)
    numbers.times do |index|
    name = "test_name" + (index + 1).to_s
    @client.query("INSERT INTO category (name) VALUES ('#{name}')")
    end
    end

    def create_project(numbers)
    numbers.times do |index|
    user_id = index + 1
    #いまだけ+5です。DBが5から始まるので。普通は1
    category_id = index + 5
    name = "category " + (index+1).to_s
    comment_date = "2013-06-08 00:49:36"
    iine_count = index
    comment_count = index + 10
    @client.query("INSERT INTO project(user_id, category_id, name, comment_date, iine_count, comment_count) VALUES ('#{user_id}','#{category_id}','#{name}','#{comment_date}','#{iine_count}','#{comment_count}') ");
    end
    end

    def create_source(numbers)
    numbers.times do |index|
    #いまだけ+90です。DBが5から始まるので。普通は1
    project_id = index + 90
    name = "test_source" + (index + 1).to_s
    @client.query("INSERT INTO source (project_id, name) VALUES ('#{project_id}','#{name}')")
    end
    end

    def create_comment(numbers)
    numbers.times do |index|
    user_id = index +1
    #いまだけ+295です。DBが5から始まるので。普通は1
    source_id = index + 295
    nice_count = index + 10
    @client.query("INSERT INTO comment (user_id, source_id, nice_count) VALUES ('#{user_id}', '#{source_id}', '#{nice_count}')")
    end
    end

    def create_nice(numbers)
    numbers.times do |index|
    user_id = index + 1;
    #いまだけ+54610です。DBが5から始まるので。普通は1
    comment_id = index + 54610;
    @client.query("INSERT INTO nice (user_id, comment_id) VALUES ('#{user_id}', '#{comment_id}')")
    end
    end

    end

    client = CreateDammies.new();
    numbers = 100
    # client.create_user(numbers)
    # client.create_badge(numbers)
    # client.create_monster(numbers)
    # client.create_category(numbers)
    # client.create_project(numbers)
    # client.create_source(numbers)se
    # client.create_comment(numbers)
    client.create_nice(numbers)