-- USAGE:
--   php mock-orders.php | mysql -u root -p wp_dev
DELETE FROM wp_wallets_orders;
INSERT INTO wp_wallets_orders(order_id,blog_id,direction,amount,base_symbol,quote_symbol,filled,rate,account,created_time,updated_time,status)
VALUES
<?php
$created_time = strtotime('-10 weeks');
$rate = 0.00000040;
while ( $created_time < time() ): ?>
	('<?php echo uniqid('O'); ?>',1,'<?php echo rand(0,1) > 0.5?'bid':'ask'; ?>',<?php echo $a = rand(1,1000); ?>,'BTC','DOGE', <?php echo $a; ?>, <?php echo number_format($rate,8); ?>,<?php echo rand(1,3); ?>,'<?php echo date('Y-m-d H:i:s',$created_time); ?>','<?php echo date('Y-m-d H:i:s',$created_time); ?>','filled'),
<?php
$created_time += rand(30,3600);
$rate += rand(-2,2) * 0.00000001;
$rate = abs( floatval( number_format( $rate, 8 ) ) );
endwhile;
?>
('<?php echo uniqid('O'); ?>',1,'<?php echo rand(0,1) > 0.5?'bid':'ask'; ?>',<?php echo $a = rand(1,1000); ?>,'BTC','DOGE', <?php echo $a; ?>, <?php echo number_format($rate,8); ?>,<?php echo rand(1,3); ?>,'<?php echo date('Y-m-d H:i:s',$created_time); ?>','<?php echo date('Y-m-d H:i:s',$created_time); ?>','filled');