me/go-recipe-book
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
go-recipe-book/sample_data/seed.sql
Alessio 5c58c111ac Add recipe sample data
2024-11-17 13:46:33 -08:00

186 lines
18 KiB
SQL
Raw Permalink Blame History

-- ==========
-- Base foods
-- ==========
INSERT INTO foods (name,cals,carbs,protein,fat,sugar,alcohol,water,potassium,sodium,calcium,magnesium,phosphorus,iron,zinc,mass,price,density,cook_ratio) VALUES
('bread',289.0,56.0,12.0,2.0,3.0,0.0,0.0,0.1,0.381,0.151,0.023,0.099,0.0037,0.0007,100.0,44.0,1.0,1.0),
('oats',400.0,67.0,17.0,7.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,33.0,0.44,1.0),
('pasta',360.0,74.0,13.0,1.5,3.0,0.0,0.0,0.22,0.7,0.021,0.053,0.189,0.0013,0.0014,100.0,25.0,1.0,2.0),
('potatoes',97.0,21.0,2.67,0.0,1.0,0.0,0.0,0.535,0.01,0.015,0.028,0.07,0.0011,0.0004,100.0,12.0,1.0,1.0),
('banana',90.0,23.0,1.0,0.3,12.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,101.0,23.0,1.0,1.0),
('rice',365.0,80.0,7.0,1.0,0.0,0.0,0.0,0.187,0.003,0.055,0.027,0.156,0.0013,0.001,100.0,14.0,1.0,1.0),
('whey protein',379.0,7.0,86.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,334.0,0.45,1.0),
('eggs',80.0,1.0,7.0,6.0,0.0,0.0,0.0,0.0625,0.065,0.0265,0.006,0.096,0.0009,0.0006,53.0,29.0,1.0,1.0),
('egg whites',48.0,1.0,11.0,0.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('peanut butter',600.0,20.0,27.0,47.0,7.0,0.0,0.0,0.667,0.007,0.043,0.154,0.358,0.0019,0.0029,100.0,66.0,1.0,1.0),
('almond butter',633.0,20.0,20.0,60.0,0.0,0.0,0.0,0.667,0.011,0.27,0.303,0.523,0.0037,0.003,100.0,242.0,1.0,1.0),
('olive oil',884.0,0.0,0.0,100.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,141.0,1.0,1.0),
('avocado oil',884.0,0.0,0.0,100.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,155.0,1.0,1.0),
('flour',364.0,76.0,10.0,1.3,0.0,0.0,0.0,0.107,0.002,0.015,0.022,0.108,0.0046,0.0007,100.0,24.0,0.53,1.0),
('sugar',400.0,100.0,0.0,0.0,100.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('honey',300.0,85.0,0.0,0.0,80.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,89.0,1.0,1.0),
('tomatoes',20.0,5.0,0.3,0.0,3.0,0.0,0.0,0.32,0.1,0.01,0.011,0.024,0.0003,0.0002,100.0,44.0,1.0,1.0),
('carrots',37.0,9.0,1.0,0.0,4.5,0.0,0.0,0.32,0.069,0.033,0.012,0.035,0.0003,0.0002,100.0,105.0,1.0,1.0),
('peppers',31.0,6.0,1.0,0.3,4.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('avocado',160.0,9.0,2.0,15.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('almonds',576.0,22.0,21.0,49.0,4.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('walnuts',654.0,14.0,15.0,65.0,3.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('pine nuts',720.0,14.0,14.0,68.0,4.0,0.0,0.0,0.597,0.002,0.016,0.251,0.575,0.0055,0.0064,100.0,800.0,1.0,1.0),
('kalamata',167.0,7.0,0.0,13.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,300.0,1.0,1.0),
('sundried tomato',258.0,56.0,14.0,3.0,38.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,290.0,1.0,1.0),
('celery',16.0,3.0,1.0,0.0,2.0,0.0,0.0,0.26,0.08,0.04,0.011,0.024,0.0002,0.0001,100.0,50.0,1.0,1.0),
('ginger',80.0,18.0,2.0,1.0,2.0,0.0,0.0,0.415,0.013,0.016,0.043,0.034,0.0006,0.0003,100.0,66.0,1.0,1.0),
('yellow onion',88.0,20.0,2.0,0.0,9.0,0.0,0.0,0.312,0.008,0.023,0.01,0.029,0.0002,0.0002,220.0,17.0,1.0,0.62),
('red onion',88.0,20.0,2.0,0.0,9.0,0.0,0.0,0.312,0.008,0.023,0.01,0.029,0.0002,0.0002,220.0,36.6,1.0,1.0),
('leeks',61.0,14.0,1.5,0.3,4.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('green onion',32.0,7.0,1.8,0.0,2.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,11.0,18.0,1.0,1.0),
('garlic',149.0,30.0,6.0,0.5,1.0,0.0,0.0,0.4,0.017,0.181,0.025,0.153,0.0017,0.0014,100.0,60.0,1.0,1.0),
('shallots',72.0,17.0,3.0,0.0,8.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('ground beef (medium)',250.0,0.0,19.0,20.0,0.0,0.0,0.0,0.323,0.065,0.0,0.0,0.0,0.0,0.0,100.0,110.0,1.0,0.75),
('ground beef (lean)',215.0,0.0,19.0,15.0,0.0,0.0,0.0,0.323,0.065,0.0,0.0,0.0,0.0,0.0,100.0,100.0,1.0,0.75),
('ground beef (extra lean)',170.0,0.0,21.0,9.0,0.0,0.0,0.0,0.323,0.065,0.0,0.0,0.0,0.0,0.0,100.0,132.0,1.0,1.0),
('top sirloin roast',213.0,1.0,27.0,11.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,88.0,1.0,1.0),
('striploin steak',196.0,0.0,24.0,11.0,0.0,0.0,0.0,0.342,0.055,0.009,0.0,0.212,0.0019,0.0036,100.0,132.0,1.0,0.7),
('prime rib',271.0,0.0,25.0,19.0,0.0,0.0,0.0,0.342,0.055,0.009,0.0,0.212,0.0019,0.0036,100.0,0.0,1.0,1.0),
('flank steak',150.0,0.0,22.0,6.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('beef tenderloin',180.0,0.0,28.0,7.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('filet mignon',205.0,0.0,28.0,11.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('beef chuck',130.0,0.0,21.0,5.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,132.0,1.0,1.0),
('ribeye',207.0,0.0,24.0,12.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('short ribs',261.0,0.0,18.0,21.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,242.0,1.0,1.0),
('beef shanks',182.0,0.0,21.0,10.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,110.0,1.0,1.0),
('oxtail',262.0,0.0,30.0,15.0,0.0,0.0,0.0,0.43,0.047,0.0,0.0,0.0,0.0,0.0,100.0,250.0,1.0,1.0),
('lamb leg',200.0,0.0,22.0,12.0,0.0,0.0,0.0,0.286,0.054,0.012,0.021,0.0,0.002,0.004,100.0,160.0,1.0,1.0),
('ground pork',230.0,1.0,18.0,17.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,88.0,1.0,0.75),
('ground pork (lean)',220.0,1.0,19.0,15.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,88.0,1.0,0.75),
('pancetta',288.0,2.0,16.0,27.0,2.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,449.0,1.0,1.0),
('sausage',380.0,0.0,26.0,32.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,160.0,81.0,1.0,1.0),
('pork shoulder',290.0,0.0,19.0,23.0,0.0,0.0,0.0,0.362,0.073,0.022,0.024,0.0,0.0013,0.0032,100.0,69.0,1.0,1.0),
('ribs',351.0,0.0,23.0,28.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('pork chops',194.0,0.0,20.0,12.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('pork tenderloin',136.0,0.0,21.0,5.5,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,64.0,1.0,1.0),
('black forest ham',140.0,4.0,24.0,4.0,2.0,0.0,0.0,0.649,0.8,0.006,0.021,0.288,0.0007,0.0019,100.0,0.0,1.0,1.0),
('roast turkey',196.0,0.0,29.0,8.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('ground turkey',130.0,0.0,20.0,6.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('shrimp',62.0,0.0,15.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,200.0,1.0,1.0),
('salmon',208.0,0.0,22.0,12.0,0.0,0.0,0.0,0.384,0.061,0.015,0.03,0.252,0.0003,0.0004,100.0,192.0,1.0,1.0),
('chicken breast',165.0,0.0,31.0,4.0,0.0,0.0,0.0,0.259,0.074,0.015,0.029,0.228,0.001,0.001,100.0,220.0,1.0,0.72),
('chicken thighs',177.0,0.0,24.0,8.0,0.0,0.0,0.0,0.27,0.1,0.01,0.024,0.168,0.001,0.0019,100.0,170.0,1.0,0.72),
('chicken thighs (with skin)',230.0,0.0,22.0,15.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('ground chicken',160.0,0.0,18.0,10.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('stuffing',386.0,76.0,11.0,3.4,8.3,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('gravy',50.0,5.0,1.0,3.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('sliced turkey breast',50.0,0.0,11.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('milk (skim)',36.0,4.8,3.6,0.0,4.8,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('milk (1%)',44.0,4.8,3.6,1.0,4.8,0.0,0.0,0.141,0.05,0.113,0.01,0.091,0.0,0.0004,100.0,11.0,1.0,1.0),
('milk (2%)',52.0,4.8,3.6,2.0,4.8,0.0,0.0,0.141,0.05,0.113,0.01,0.091,0.0,0.0004,100.0,11.0,1.0,1.0),
('milk (whole)',64.0,4.8,3.6,3.2,4.8,0.0,0.0,0.141,0.05,0.113,0.01,0.091,0.0,0.0004,100.0,13.0,1.0,1.0),
('kefir',64.0,4.8,3.2,3.2,4.8,0.0,0.0,0.16,0.05,0.225,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('chocolate milk',64.0,11.0,3.0,1.0,10.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('buttermilk',44.0,4.8,3.6,1.0,4.8,0.0,0.0,0.141,0.05,0.113,0.01,0.091,0.0,0.0004,100.0,38.0,1.0,1.0),
('cream',333.0,6.0,2.0,33.0,6.0,0.0,0.0,0.0667,0.027,0.065,0.007,0.062,0.0,0.0002,100.0,70.0,1.0,1.0),
('sour cream',193.0,3.0,2.0,20.0,3.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('butter',714.0,0.0,1.0,81.0,0.0,0.0,0.0,0.02,0.7,0.024,0.002,0.024,0.0,0.0001,100.0,95.0,0.911,1.0),
('yogurt',69.0,3.0,9.0,2.0,2.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,80.0,1.0,1.0),
('chocolate',535.0,59.0,8.0,30.0,52.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('greek yogurt',91.0,3.4,8.6,5.1,3.4,0.0,0.0,0.141,0.04,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('mozzarella (low fat)',233.0,3.0,30.0,13.0,0.0,0.0,0.0,0.076,0.627,0.505,0.02,0.354,0.0004,0.0029,100.0,155.0,1.0,1.0),
('mozzarella',333.0,3.0,23.0,26.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,200.0,1.0,1.0),
('italiano',333.0,3.0,27.0,27.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,175.0,1.0,1.0),
('cheddar',402.0,1.0,25.0,33.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('parmigiano',393.0,0.0,33.0,30.0,0.0,0.0,0.0,0.125,1.529,1.109,0.038,0.729,0.0009,0.0039,100.0,399.0,1.0,1.0),
('asiago',382.0,3.0,29.0,29.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,229.0,1.0,1.0),
('blue cheese',353.0,2.0,21.0,29.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,479.0,1.0,1.0),
('gruyere',413.0,0.4,30.0,32.0,0.4,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,549.0,1.0,1.0),
('feta',300.0,0.0,17.0,27.0,0.0,0.0,0.0,0.062,1.112,0.493,0.019,0.337,0.0007,0.0029,100.0,147.0,1.0,1.0),
('cream cheese',266.0,6.6,6.6,23.0,6.6,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('ricotta',90.0,5.0,5.0,6.0,3.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,55.0,121.0,1.0,1.0),
('jarlsberg',366.0,1.0,27.0,28.0,1.0,0.0,0.0,0.077,0.433,0.791,0.038,0.567,0.0002,0.0044,100.0,190.0,1.0,1.0),
('salami',333.0,0.0,27.0,27.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,333.0,1.0,1.0),
('vincenzos sausage',300.0,0.0,20.0,23.0,0.0,0.0,0.0,0.35,0.71,0.0,0.0,0.0,0.0,0.0,150.0,297.0,1.0,1.0),
('water',0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('orange juice',48.0,11.0,1.0,0.0,10.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('lemon juice',25.0,7.0,0.4,0.3,2.4,0.0,0.0,0.124,0.001,0.007,0.006,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('red wine vinegar',10.0,2.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('maple syrup',367.0,90.0,0.0,0.0,77.0,0.0,0.0,0.333,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('wine',110.0,3.0,0.0,0.0,0.0,14.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('black beans',104.0,18.0,7.0,1.0,1.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,16.0,1.0,1.0),
('red beans (dried)',290.0,30.0,22.0,2.0,2.0,0.0,0.0,1.5,0.0,0.15,0.12,0.2,0.007,0.002,100.0,36.5,1.0,1.0),
('corn',81.0,19.0,3.0,1.0,4.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,25.0,1.0,1.0),
('canned tomatoes',20.0,5.0,0.3,0.0,3.0,0.0,0.0,0.32,0.1,0.01,0.011,0.024,0.0003,0.0002,100.0,14.0,1.0,1.0),
('frozen mixed veggies',71.0,13.0,3.5,0.0,3.5,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,27.0,1.0,1.0),
('canned olives',167.0,7.0,0.0,13.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,150.0,1.0,1.0),
('frozen peas',59.0,14.0,4.7,0.0,4.7,0.0,0.0,0.11,0.072,0.024,0.022,0.077,0.0035,0.0007,100.0,27.5,1.0,1.0),
('ravioli',220.0,23.0,14.0,8.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,119.0,1.0,1.0),
('panko',366.0,77.0,10.0,2.0,7.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('doritos',500.0,57.0,7.0,28.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('pepperoni',90.0,2.0,7.0,7.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,40.0,44.0,1.0,1.0),
('bacon',190.0,1.0,5.0,18.0,0.0,0.0,0.0,0.08,0.24,0.0012,0.005,0.078,0.0002,0.0005,44.0,45.0,1.0,1.0),
('ketchup',133.0,33.0,2.0,0.0,27.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('ranch',467.0,7.0,3.0,53.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('mayo',600.0,0.0,1.0,66.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,0.9,1.0),
('pop',39.0,10.0,0.0,0.0,10.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('rum',329.0,0.0,0.0,0.0,0.0,47.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,479.0,1.0,1.0),
('fries',320.0,41.0,3.4,15.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('salt',0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,40.0,0.0,0.0,0.0,0.0,0.0,100.0,17.0,2.2,1.0),
('KCL',0.0,0.0,0.0,0.0,0.0,0.0,0.0,52.4,0.0,0.0,0.0,0.0,0.0,0.0,100.0,176.0,1.0,1.0),
('black pepper',255.0,65.0,11.0,3.0,1.0,0.0,0.0,1.26,0.044,0.437,0.194,0.173,0.0289,0.0014,100.0,0.0,1.0,1.0),
('oregano',265.0,48.0,9.0,4.3,4.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,162.0,1.0,1.0),
('garlic powder',331.0,68.0,13.0,1.0,2.0,0.0,0.0,1.101,0.026,0.08,0.058,0.417,0.0027,0.0026,100.0,107.0,1.0,1.0),
('onion powder',347.0,75.0,10.0,1.0,35.0,0.0,0.0,0.943,0.053,0.363,0.122,0.34,0.0026,0.0023,100.0,152.0,1.0,1.0),
('chili flakes',307.0,28.0,12.0,16.0,10.0,0.0,0.0,1.9,0.03,0.0,0.0,0.0,0.0,0.0,100.0,300.0,0.357,1.0),
('habanero powder',335.0,66.0,16.0,2.2,42.0,0.0,0.0,2.855,0.055,0.0,0.0,0.0,0.0,0.0,100.0,624.0,1.0,1.0),
('ancho powder',281.0,29.0,12.0,8.0,0.0,0.0,0.0,2.411,0.043,0.0,0.0,0.0,0.0,0.0,100.0,460.0,1.0,1.0),
('paprika',289.0,19.0,15.0,13.0,10.0,0.0,0.0,2.344,0.034,0.0177,0.185,0.345,0.0236,0.0041,100.0,141.0,1.0,1.0),
('chipotle powder',300.0,35.0,13.0,6.0,30.0,0.0,0.0,2.15,0.01,0.0,0.0,0.0,0.0,0.0,100.0,526.0,1.0,1.0),
('thai chilies',40.0,9.0,2.0,0.0,5.0,0.0,0.0,0.322,0.009,0.014,0.023,0.043,0.001,0.0003,100.0,0.0,1.0,1.0),
('basil',251.0,41.0,14.0,4.0,2.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,500.0,1.0,1.0),
('cinnamon',247.0,80.0,4.0,3.0,2.0,0.0,0.0,0.431,0.01,1.002,0.06,0.064,0.0083,0.0018,100.0,110.0,1.0,1.0),
('cocoa powder',228.0,58.0,20.0,14.0,2.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,230.0,1.0,1.0),
('cumin',375.0,33.0,18.0,22.0,2.0,0.0,0.0,1.788,0.168,0.931,0.366,0.499,0.0664,0.0048,100.0,169.0,1.0,1.0),
('coriander',298.0,13.0,12.0,18.0,0.0,0.0,0.0,1.267,0.035,0.0,0.0,0.0,0.0,0.0,100.0,64.0,1.0,1.0),
('sriracha',93.0,18.6,2.0,1.0,15.0,0.0,0.0,0.4,1.5,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('soy sauce (low sodium)',60.0,5.0,11.0,0.0,2.0,0.0,0.0,0.212,2.4,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('soy sauce',60.0,5.0,11.0,0.0,2.0,0.0,0.0,0.212,6.4,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('worcestershire',78.0,19.0,0.0,0.0,10.0,0.0,0.0,0.8,0.98,0.107,0.013,0.06,0.0053,0.0002,100.0,0.0,1.0,1.0),
('vanilla extract',290.0,12.6,0.0,0.0,12.6,35.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('mustard',0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.88,0.0,0.0,0.0,0.0,0.0,100.0,0.0,1.0,1.0),
('fennel',345.0,40.0,16.0,15.0,0.0,0.0,0.0,1.694,0.088,1.196,0.385,0.0,0.019,0.0037,100.0,180.0,1.0,1.0),
('sage',315.0,40.0,11.0,13.0,2.0,0.0,0.0,1.07,0.011,1.652,0.428,0.0,0.028,0.0047,100.0,210.0,1.0,1.0),
('nutmeg',525.0,44.0,6.0,36.0,28.0,0.0,0.0,0.35,0.016,0.184,0.183,0.0,0.003,0.0021,100.0,246.0,1.0,1.0),
('turmeric',354.0,60.0,8.0,10.0,3.0,0.0,0.0,2.525,0.038,0.183,0.193,0.268,0.041,0.0043,100.0,0.0,1.0,1.0),
('cloves',323.0,55.0,6.0,20.0,2.0,0.0,0.0,1.102,0.243,0.646,0.264,0.105,0.0087,0.0011,100.0,0.0,1.0,1.0),
('coffee', 0,0,0,0,0,0,100,0.047,0,0,0.003,0,0,0,100,0,1,1),
('chicken broth', 0,0,0,0,0,0,100,0,0,0,0,0,0,0,100,0,1,1);
-- =======
-- Recipes
-- =======
insert into foods (rowid, name, cals,carbs,protein,fat,sugar,alcohol,water,potassium,sodium,calcium,magnesium,phosphorus,iron,zinc,mass,price,density,cook_ratio) values (10000, 'Chicken parmigiana soup', 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
insert into recipes (rowid, name, blurb, instructions, computed_food_id) values (1, 'Chicken parmigiana soup', 'This is a nice recipe which is basically what it sounds like: chicken parmigiana, but in soup form. It''s easy to make, hard to mess up, and simply delicious.', replace('In large pot, heat butter and oil. Cook onions to 1/2 cooked (translucent and soft, starting to turn golden-brown)\aAdd garlic, cook 1-2 minutes\aadd tomatoes and chicken broth, bring to a simmer\asalt and season the soup, tasting until seasonings are right\acut chicken into bite-sized pieces, add to soup and boil until fully cooked\aadd pasta and boil until it is cooked "al dente"; add more stock as needed\aadd half the cheese and stir it into the soup\asprinkle remaining cheese on top and serve', '\a', char(31)), 10000);
insert into ingredients(food_id, quantity, units, in_recipe_id, list_order) values
(28, 2, 1, 1, 0), -- 2 yellow onions
(78, 0.3, 2, 1, 1), -- 30g butter
(12, 0.3, 2, 1, 2), -- 30g olive oil
(32, 0.4, 2, 1, 3), -- 40g garlic
(105, 8, 5, 1, 4), -- 800mL canned tomatoes,
(62, 4.5, 2, 1, 5), -- 450g chicken breast
(3, 3, 2, 1, 6), -- 300g pasta
(83, 1.5, 2, 1, 7), -- 150g mozzarella
(86, 1.5, 2, 1, 8), -- 150g parmigiano
(120, 0.2, 2, 1, 9), -- 20g salt
(122, 0.02, 2, 1, 10), -- 2g pepper
(126, 0.05, 2, 1, 11), --5g chilis
(149, 10, 5, 1, 12); -- 1000mL chicken stock
insert into foods (rowid, name, cals,carbs,protein,fat,sugar,alcohol,water,potassium,sodium,calcium,magnesium,phosphorus,iron,zinc,mass,price,density,cook_ratio) values (10001, 'Breakfast shake', 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
insert into recipes (rowid, name, blurb, instructions, computed_food_id) values (2, 'Breakfast shake', 'A quick breakfast-in-a-bottle you can have on the go', replace(replace('In shaker bottle, add milk, peanut butter, yogurt, *hot* coffee (in that order). Mix until the peanut butter is melted/dissolved\aKey point of previous step is to get the temperatures right:\n- Hot coffee will melt the shaker bottle or dissolve microplastics, so don''t add it directly\n- without hot coffee, peanut butter won''t dissolve\n- hot coffee will make whey protein curdle, so shake coffee with cold ingredients until it ends up warm-ish, then it''s safe to add whey\aOnce temperature has equilibrated between hot coffee and cold stuff, add whey protein, shake again, and drink', '\a', char(31)), '\n', char(10)), 10001);
insert into ingredients(food_id, quantity, units, in_recipe_id, list_order) values
(10, 0.3, 2, 2, 0), -- 30g peanut butter
(69, 3.5, 5, 2, 1), -- 350mL skim milk
(81, 2.5, 6, 2, 2), -- 1 cup yogurt
(7, 0.4, 2, 2, 3), -- 1 cup yogurt
(148, 2, 5, 2, 4); -- 200 mL coffee
Reference in New Issue View Git Blame Copy Permalink