Guest User

shop_orderitem

a guest
Apr 2nd, 2022
18
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. WITH DataCTE AS (
  2.     SELECT
  3.         generate_series(1, 5000000) as id,
  4.         FLOOR(RANDOM()*(20 - 1) + 1)::int as quantity,
  5.         FLOOR(RANDOM()*(4000000 - 1) + 1)::int as item_id,
  6.         FLOOR(RANDOM()*(5000000 - 1) + 1)::int as order_id
  7. )
  8. INSERT INTO shop_orderitem
  9. SELECT
  10.     DataCTE.id,
  11.     DataCTE.quantity,
  12.     DataCTE.item_id,
  13.     DataCTE.order_id
  14. FROM DataCTE
  15. WHERE NEXTVAL('query_progress') != 0;
Advertisement
Add Comment
Please, Sign In to add comment