<commit_before>INSERT INTO customer ( name, username, password, phone_number )
VALUES ( '<NAME>', 'bknowles', 'abacus', 1234567 ),
( '<NAME>', 'sknowles', 'abalone', 2234567 ),
( '<NAME>', 'krowland', 'abandon', 3234567 ),
( '<NAME>', 'mwilliams', 'abashed', 4234567 ),
( '<NAME>', 'bcarter', 'abate', 5234567 ),
( '<NAME>', 'rkaur', 'abbrivated', 6234567 ),
( '<NAME>', 'mjackson', 'moonwalker', 7234567 ),
( '<NAME>', 'bobama', 'renegade', 8234567 ),
( '<NAME>ama', 'mobama', 'renaissance', 9234567 ),
( 'Malia Obama', 'mobama', 'rosebud', 1134567 ),
( 'Sasha Obama', 'sobama', 'radiance', 1334567 );

INSERT INTO address ( street_address, zipcode, apartment_number, city, state )
VALUES
( '1234 Carter St', 55555, 'A', 'New York City', 'NY' ),
( '1234 Carter St', 55554, 'C', 'New York City', 'NY' ),
( '5555 Bankhead St', 24689, '#201', 'Atlanta', 'GA' ),
( '2468 Bobby St', 90100, 'D', 'Los Angeles', 'CA' ),
( '2345 Lovely St', 80122, '#5070', 'Chicago', 'IL' ),
( '3333 Danny St', 67345, '3B', 'Newark', 'NJ' ),
( '4444 Gaskill St', 94602, '#34', 'Oakland','CA' ),
( '1123 Purple Rain St', 55554, 'DX', 'Dallas', 'TX');


INSERT INTO credit_card ( 
  customer_name,
  card_number,
  customer_id,
  billing_address,
  expiration_date,
  card_type 
  )
VALUES
( '<NAME>', '4567390482903889', 1, 1, '1999-01-08', 'Mastercard' ),
( '<NAME>', '1234567891011121', 2, 2, '1999-01-08', 'Visa' ),
( '<NAME>', '4567390482903111', 3, 3, '1999-01-08', 'Visa' ),
( '<NAME>', '4567390482902345', 4, 4, '1999-01-08', 'Mastercard' ),
( '<NAME>', '4567390482902222', 5, 1, '1999-01-08', 'Visa' ),
( '<NAME>', '456739048290333', 6, 5, '1999-01-08', 'Mastercard' ),
( '<NAME>', '4567390482904455', 7, 6, '1999-01-08', 'Visa' ),
( '<NAME>', '4567390482905567', 8, 7, '1999-01-08', 'Mastercard' ),
( '<NAME>', '4567390482906672', 9, 7, '1999-01-08', 'Visa'),
( 'Malia Obama', '4567390482902100', 10, 7, '1999-01-08', 'Mastercard'),
( 'Sasha Obama', '456739048290001', 11, 8, '1999-01-08', 'Visa');

INSERT INTO purchase ( 
  customer_id,
  completed,
  payment_method,
  date_time,
  total 
  )
VALUES
(11, 'true', 'credit_card', '1999-01-08', 18.99 ),
(10, 'false', 'cash', '1999-01-08', 21.99 ),
(7, 'true', 'check', '1999-01-08', 5.99 ),
(5, 'false', 'debit_card', '1999-01-08', 30.99 );

INSERT INTO delivery (
  status,
  delivery_address,
  delivery_person,
  purchase_id,
  price,
  tip
)
-- delivered means order has been completed and customer has food
-- in_progress means order is still being cooked
-- done means that the food has been cooked and is on its way to customer
VALUES
( 'delivered', 7, 'Bob', 1, 23.99, .20 ),
( 'in_progress', 8, 'Bob', 2, 26.99, .15 ),
( 'delivered', 6, 'Tom', 3, 10.99, .10 ),
( 'done', 1, 'Judy', 4, 35.99, .05 );

INSERT INTO drink (
  description,
  manufacturer,
  supplier,
  price
)
VALUES
( 'Pepsi', 'Pepsi Co', 'Pepsi Beverages Company', 2.99 ),
( 'Orange Juice', 'Orange Company', 'Orange Company', 1.99 ),
( 'Sprite', 'Sprite Co', 'Bay Area Beverage Company', 2.99 ),
( 'Coke', 'Coke Co', 'Bay Area Beverage Company', 2.99 );

INSERT INTO drink_purchase (
  purchase_id,
  drink_id,
  quantity
)
VALUES
( 1, 2, 4),
( 1, 3, 2),
( 2, 1, 1),
( 3, 3, 2),
( 4, 4, 2);

INSERT INTO pizza (
  name,
  size,
  type,
  price,
  discount
)
VALUES 
( 'Spinach & Mushroom', 'L', 'thick', 32.80, 0.00 ),
( 'Spinach & Mushroom', 'XL', 'thin', 30.60, 0.00 ),
( 'OG Kush', 'L', 'thin', 21.00, 0.00 ),
( 'White Widow', 'L', 'thin', 27.0, 0.00 ),
( 'Custom', 'S', 'thin', 15.00, 0.00 ),
( 'Custom', 'L', 'thick', 16.80, 0.00 ),
( 'Custom', 'L', 'thin', 15.80, 0.00 ),
( 'Carne', 'M', 'thick', 29.50, 10.00 ),
( 'Carne', 'M', 'thin', 22.50, 0.50  ),
( 'Pizza Blanca', 'S', 'thin', 13.75, 5.00 ),
( 'Spinach & Mushroom', 'M', 'thick', 27.90, 0.00 );<commit_msg>adds seed data for pizza purchase table, insert correctly works<commit_after>INSERT INTO customer ( name, username, password, phone_number )
VALUES ( '<NAME>', 'bknowles', 'abacus', 1234567 ),
( '<NAME>', 'sknowles', 'abalone', 2234567 ),
( '<NAME>', 'krowland', 'abandon', 3234567 ),
( '<NAME>', 'mwilliams', 'abashed', 4234567 ),
( '<NAME>', 'bcarter', 'abate', 5234567 ),
( '<NAME>', 'rkaur', 'abbrivated', 6234567 ),
( '<NAME>', 'mjackson', 'moonwalker', 7234567 ),
( '<NAME>', 'bobama', 'renegade', 8234567 ),
( '<NAME>', 'mobama', 'renaissance', 9234567 ),
( 'Malia Obama', 'mobama', 'rosebud', 1134567 ),
( 'Sasha Obama', 'sobama', 'radiance', 1334567 );

INSERT INTO address ( street_address, zipcode, apartment_number, city, state )
VALUES
( '1234 Carter St', 55555, 'A', 'New York City', 'NY' ),
( '1234 Carter St', 55554, 'C', 'New York City', 'NY' ),
( '5555 Bankhead St', 24689, '#201', 'Atlanta', 'GA' ),
( '2468 Bobby St', 90100, 'D', 'Los Angeles', 'CA' ),
( '2345 Lovely St', 80122, '#5070', 'Chicago', 'IL' ),
( '3333 Danny St', 67345, '3B', 'Newark', 'NJ' ),
( '4444 Gaskill St', 94602, '#34', 'Oakland','CA' ),
( '1123 Purple Rain St', 55554, 'DX', 'Dallas', 'TX');


INSERT INTO credit_card ( 
  customer_name,
  card_number,
  customer_id,
  billing_address,
  expiration_date,
  card_type 
  )
VALUES
( '<NAME>', '4567390482903889', 1, 1, '1999-01-08', 'Mastercard' ),
( '<NAME>', '1234567891011121', 2, 2, '1999-01-08', 'Visa' ),
( '<NAME>', '4567390482903111', 3, 3, '1999-01-08', 'Visa' ),
( '<NAME>', '4567390482902345', 4, 4, '1999-01-08', 'Mastercard' ),
( '<NAME>', '4567390482902222', 5, 1, '1999-01-08', 'Visa' ),
( '<NAME>', '456739048290333', 6, 5, '1999-01-08', 'Mastercard' ),
( '<NAME>', '4567390482904455', 7, 6, '1999-01-08', 'Visa' ),
( '<NAME>', '4567390482905567', 8, 7, '1999-01-08', 'Mastercard' ),
( '<NAME>', '4567390482906672', 9, 7, '1999-01-08', 'Visa'),
( 'Malia Obama', '4567390482902100', 10, 7, '1999-01-08', 'Mastercard'),
( 'Sasha Obama', '456739048290001', 11, 8, '1999-01-08', 'Visa');

INSERT INTO purchase ( 
  customer_id,
  completed,
  payment_method,
  date_time,
  total 
  )
VALUES
(11, 'true', 'credit_card', '1999-01-08', 18.99 ),
(10, 'false', 'cash', '1999-01-08', 21.99 ),
(7, 'true', 'check', '1999-01-08', 5.99 ),
(5, 'false', 'debit_card', '1999-01-08', 30.99 );

INSERT INTO delivery (
  status,
  delivery_address,
  delivery_person,
  purchase_id,
  price,
  tip
)
-- delivered means order has been completed and customer has food
-- in_progress means order is still being cooked
-- done means that the food has been cooked and is on its way to customer
VALUES
( 'delivered', 7, 'Bob', 1, 23.99, .20 ),
( 'in_progress', 8, 'Bob', 2, 26.99, .15 ),
( 'delivered', 6, 'Tom', 3, 10.99, .10 ),
( 'done', 1, 'Judy', 4, 35.99, .05 );

INSERT INTO drink (
  description,
  manufacturer,
  supplier,
  price
)
VALUES
( 'Pepsi', 'Pepsi Co', 'Pepsi Beverages Company', 2.99 ),
( 'Orange Juice', 'Orange Company', 'Orange Company', 1.99 ),
( 'Sprite', 'Sprite Co', 'Bay Area Beverage Company', 2.99 ),
( 'Coke', 'Coke Co', 'Bay Area Beverage Company', 2.99 );

INSERT INTO drink_purchase (
  purchase_id,
  drink_id,
  quantity
)
VALUES
( 1, 2, 4),
( 1, 3, 2),
( 2, 1, 1),
( 3, 3, 2),
( 4, 4, 2);

INSERT INTO pizza (
  name,
  size,
  type,
  price,
  discount
)
VALUES 
( 'Spinach & Mushroom', 'L', 'thick', 32.80, 0.00 ),
( 'Spinach & Mushroom', 'XL', 'thin', 30.60, 0.00 ),
( 'OG Kush', 'L', 'thin', 21.00, 0.00 ),
( 'White Widow', 'L', 'thin', 27.0, 0.00 ),
( 'Custom', 'S', 'thin', 15.00, 0.00 ),
( 'Custom', 'L', 'thick', 16.80, 0.00 ),
( 'Custom', 'L', 'thin', 15.80, 0.00 ),
( 'Carne', 'M', 'thick', 29.50, 10.00 ),
( 'Carne', 'M', 'thin', 22.50, 0.50  ),
( 'Pizza Blanca', 'S', 'thin', 13.75, 5.00 ),
( 'Spinach & Mushroom', 'M', 'thick', 27.90, 0.00 );

INSERT INTO pizza_purchase (
  purchase_id,
  pizza_id,
  quantity
)

VALUES 
( 1, 4, 2),
( 1, 8, 2),
( 2, 7, 1),
( 4, 6, 1),
( 3, 2, 1);
{'fraction_non_alphanumeric': 0.238574748257165, 'fraction_numerical': 0.1656338755486703, 'mean_word_length': 4.342758620689655, 'pattern_counts': {'":': 0, '<': 39, '<?xml version=': 0, '>': 39, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1802899', 'n_tokens_mistral': 4129, 'n_tokens_neox': 3227, 'n_words': 885}