some misc procedures for creating test/dummy data in mysql

mysql_dummydata.sql

/* quickly/hackily create randomish string data with md5 */

DELIMITER $$
DROP PROCEDURE IF EXISTS user_promos;

CREATE PROCEDURE user_promos()
BEGIN
  DECLARE i INT DEFAULT 1;

  WHILE i < 5000 DO
    INSERT INTO promotions2 (opener_id, message, url, created_at, updated_at, ptype, client) VALUES (127527, md5(i + "foo"), concat("https://", md5(i), ".com/", md5(i-1)), now(), now(), "sf", "web");
    SET i = i + 1;
END WHILE;
END$$
DELIMITER ;





/* randomly flip between 1 and 2 for integer values */

DELIMITER $$
DROP PROCEDURE IF EXISTS promo_nets;

CREATE PROCEDURE promo_nets()
BEGIN
  DECLARE i INT DEFAULT 300;

  WHILE i < 1609106 DO
    INSERT INTO promotion_networks (promotion_id, network_id) VALUES (i, ceil(rand() * 2));
    SET i = i + 1;
END WHILE;
END$$
DELIMITER ;