final_project/test-data.sql at development · 301d42/final_project · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81

INSERT INTO users (
	name
) VALUES (
	'Blary Fnorgin'
);

INSERT INTO recipes (
	recipe_name,
	url,
	source,
	image_url,
	servings,
	calories,
	total_fat,
	saturated_fat,
	cholesterol,
	sodium,
	total_carbohydrate,
	dietary_fiber,
	sugars,
	protein,
	potassium,
	user_id) VALUES (
		'Chicken Vesuvio',
		'http://www.seriouseats.com/recipes/2011/12/chicken-vesuvio-recipe.html',
		'Serious Eats',
		'https://www.edamam.com/web-img/e42/e42f9119813e890af34c259785ae1cfb.jpg',
		4,
		1,
		2,
		3,
		4,
		5,
		6,
		7,
		8,
		9,
		10,
		1
	);

INSERT INTO ingredients (
	recipe_id,
	ingredient
) VALUES (
	1,
	'1/2 cup olive oil'
);

INSERT INTO ingredients (
	recipe_id,
	ingredient
) VALUES (
	1,
	'5 cloves garlic, peeled'
);

INSERT INTO ingredients (
	recipe_id,
	ingredient
) VALUES (
	1,
	'2 large russet potatoes, peeled and cut into chunks'
);

INSERT INTO ingredients (
	recipe_id,
	ingredient
) VALUES (
	1,
	'1 3-4 pound chicken, cut into 8 pieces (or 3 pound chicken legs)'
);

INSERT INTO ingredients (
	recipe_id,
	ingredient
) VALUES (
	1,
	'3/4 cup white wine'
);