Merge pull request morenoh149#14 from jakubiszon/master

morenoh149 · web-flow · commit 2bdc95397620 · 2023-09-20T10:15:44.000-04:00
remove manual inserts in Adventureworks install.sql
diff --git a/adventureworks/data/ProductReview.csv b/adventureworks/data/ProductReview.csv
@@ -1,15 +1,15 @@
-1	709	John Smith	2013-09-18 00:00:00	john@fourthcoffee.com	5	I can't believe I'm singing the praises of a pair of socks, but I just came back from a grueling
+1	709	John Smith	2013-09-18 00:00:00	john@fourthcoffee.com	5	"I can't believe I'm singing the praises of a pair of socks, but I just came back from a grueling
 3-day ride and these socks really helped make the trip a blast. They're lightweight yet really cushioned my feet all day. 
 The reinforced toe is nearly bullet-proof and I didn't experience any problems with rubbing or blisters like I have with
 other brands. I know it sounds silly, but it's always the little stuff (like comfortable feet) that makes or breaks a long trip.
-I won't go on another trip without them!	2013-09-18 00:00:00
-2	937	David	2013-11-13 00:00:00	david@graphicdesigninstitute.com	4	A little on the heavy side, but overall the entry/exit is easy in all conditions. I've used these pedals for 
+I won't go on another trip without them!"	2013-09-18 00:00:00
+2	937	David	2013-11-13 00:00:00	david@graphicdesigninstitute.com	4	"A little on the heavy side, but overall the entry/exit is easy in all conditions. I've used these pedals for 
 more than 3 years and I've never had a problem. Cleanup is easy. Mud and sand don't get trapped. I would like 
-them even better if there was a weight reduction. Maybe in the next design. Still, I would recommend them to a friend.	2013-11-13 00:00:00
-3	937	Jill	2013-11-15 00:00:00	jill@margiestravel.com	2	Maybe it's just because I'm new to mountain biking, but I had a terrible time getting use
+them even better if there was a weight reduction. Maybe in the next design. Still, I would recommend them to a friend."	2013-11-13 00:00:00
+3	937	Jill	2013-11-15 00:00:00	jill@margiestravel.com	2	"Maybe it's just because I'm new to mountain biking, but I had a terrible time getting use
 to these pedals. In my first outing, I wiped out trying to release my foot. Any suggestions on
-ways I can adjust the pedals, or is it just a learning curve thing?	2013-11-15 00:00:00
-4	798	Laura Norman	2013-11-15 00:00:00	laura@treyresearch.net	5	The Road-550-W from Adventure Works Cycles is everything it's advertised to be. Finally, a quality bike that
+ways I can adjust the pedals, or is it just a learning curve thing?"	2013-11-15 00:00:00
+4	798	Laura Norman	2013-11-15 00:00:00	laura@treyresearch.net	5	"The Road-550-W from Adventure Works Cycles is everything it's advertised to be. Finally, a quality bike that
 is actually built for a woman and provides control and comfort in one neat package. The top tube is shorter, the suspension is weight-tuned and there's a much shorter reach to the brake
 levers. All this adds up to a great mountain bike that is sure to accommodate any woman's anatomy. In addition to getting the size right, the saddle is incredibly comfortable. 
 Attention to detail is apparent in every aspect from the frame finish to the careful design of each component. Each component is a solid performer without any fluff. 
@@ -31,4 +31,4 @@ while out on the road!
 
 The Road-550-W frame is available in a variety of sizes and colors and has the same durable, high-quality aluminum that AWC is known for. At a MSRP of just under $1125.00, it's comparable in price to its closest competitors and
 we think that after a test drive you'l find the quality and performance above and beyond . You'll have a grin on your face and be itching to get out on the road for more. While designed for serious road racing, the Road-550-W would be an excellent choice for just about any terrain and 
-any level of experience. It's a huge step in the right direction for female cyclists and well worth your consideration and hard-earned money.	2013-11-15 00:00:00
+any level of experience. It's a huge step in the right direction for female cyclists and well worth your consideration and hard-earned money."	2013-11-15 00:00:00
diff --git a/adventureworks/install.sql b/adventureworks/install.sql
@@ -662,51 +662,8 @@ SELECT 'Copying data into Production.ProductPhoto';
 \copy Production.ProductPhoto FROM './data/ProductPhoto.csv' DELIMITER E'\t' CSV;
 SELECT 'Copying data into Production.ProductProductPhoto';
 \copy Production.ProductProductPhoto FROM './data/ProductProductPhoto.csv' DELIMITER E'\t' CSV;
-
--- This doesn't work:
--- SELECT 'Copying data into Production.ProductReview';
--- \copy Production.ProductReview FROM 'ProductReview.csv' DELIMITER '  ' CSV;
-
--- so instead ...
-INSERT INTO Production.ProductReview (ProductReviewID, ProductID, ReviewerName, ReviewDate, EmailAddress, Rating, Comments, ModifiedDate) VALUES
- (1, 709, 'John Smith', '2013-09-18 00:00:00', 'john@fourthcoffee.com', 5, 'I can''t believe I''m singing the praises of a pair of socks, but I just came back from a grueling
-3-day ride and these socks really helped make the trip a blast. They''re lightweight yet really cushioned my feet all day. 
-The reinforced toe is nearly bullet-proof and I didn''t experience any problems with rubbing or blisters like I have with
-other brands. I know it sounds silly, but it''s always the little stuff (like comfortable feet) that makes or breaks a long trip.
-I won''t go on another trip without them!', '2013-09-18 00:00:00'),
-
- (2, 937, 'David', '2013-11-13 00:00:00', 'david@graphicdesigninstitute.com', 4, 'A little on the heavy side, but overall the entry/exit is easy in all conditions. I''ve used these pedals for 
-more than 3 years and I''ve never had a problem. Cleanup is easy. Mud and sand don''t get trapped. I would like 
-them even better if there was a weight reduction. Maybe in the next design. Still, I would recommend them to a friend.', '2013-11-13 00:00:00'),
-
- (3, 937, 'Jill', '2013-11-15 00:00:00', 'jill@margiestravel.com', 2, 'Maybe it''s just because I''m new to mountain biking, but I had a terrible time getting use
-to these pedals. In my first outing, I wiped out trying to release my foot. Any suggestions on
-ways I can adjust the pedals, or is it just a learning curve thing?', '2013-11-15 00:00:00'),
-
- (4, 798, 'Laura Norman', '2013-11-15 00:00:00', 'laura@treyresearch.net', 5, 'The Road-550-W from Adventure Works Cycles is everything it''s advertised to be. Finally, a quality bike that
-is actually built for a woman and provides control and comfort in one neat package. The top tube is shorter, the suspension is weight-tuned and there''s a much shorter reach to the brake
-levers. All this adds up to a great mountain bike that is sure to accommodate any woman''s anatomy. In addition to getting the size right, the saddle is incredibly comfortable. 
-Attention to detail is apparent in every aspect from the frame finish to the careful design of each component. Each component is a solid performer without any fluff. 
-The designers clearly did their homework and thought about size, weight, and funtionality throughout. And at less than 19 pounds, the bike is manageable for even the most petite cyclist.
-
-We had 5 riders take the bike out for a spin and really put it to the test. The results were consistent and very positive. Our testers loved the manuverability 
-and control they had with the redesigned frame on the 550-W. A definite improvement over the 2012 design. Four out of five testers listed quick handling
-and responsivness were the key elements they noticed. Technical climbing and on the flats, the bike just cruises through the rough. Tight corners and obstacles were handled effortlessly. The fifth tester was more impressed with the smooth ride. The heavy-duty shocks absorbed even the worst bumps and provided a soft ride on all but the 
-nastiest trails and biggest drops. The shifting was rated superb and typical of what we''ve come to expect from Adventure Works Cycles. On descents, the bike handled flawlessly and tracked very well. The bike is well balanced front-to-rear and frame flex was minimal. In particular, the testers
-noted that the brake system had a unique combination of power and modulation.  While some brake setups can be overly touchy, these brakes had a good
-amount of power, but also a good feel that allows you to apply as little or as much braking power as is needed. Second is their short break-in period. We found that they tend to break-in well before
-the end of the first ride; while others take two to three rides (or more) to come to full power. 
-
-On the negative side, the pedals were not quite up to our tester''s standards. 
-Just for fun, we experimented with routine maintenance tasks. Overall we found most operations to be straight forward and easy to complete. The only exception was replacing the front wheel. The maintenance manual that comes
-with the bike say to install the front wheel with the axle quick release or bolt, then compress the fork a few times before fastening and tightening the two quick-release mechanisms on the bottom of the dropouts. This is to seat the axle in the dropouts, and if you do not
-do this, the axle will become seated after you tightened the two bottom quick releases, which will then become loose. It''s better to test the tightness carefully or you may notice that the two bottom quick releases have come loose enough to fall completely open. And that''s something you don''t want to experience
-while out on the road! 
-
-The Road-550-W frame is available in a variety of sizes and colors and has the same durable, high-quality aluminum that AWC is known for. At a MSRP of just under $1125.00, it''s comparable in price to its closest competitors and
-we think that after a test drive you''l find the quality and performance above and beyond . You''ll have a grin on your face and be itching to get out on the road for more. While designed for serious road racing, the Road-550-W would be an excellent choice for just about any terrain and 
-any level of experience. It''s a huge step in the right direction for female cyclists and well worth your consideration and hard-earned money.', '2013-11-15 00:00:00');
-
+SELECT 'Copying data into Production.ProductReview';
+\copy Production.ProductReview FROM './data/ProductReview.csv' DELIMITER E'\t' CSV;
 SELECT 'Copying data into Production.ScrapReason';
 \copy Production.ScrapReason FROM './data/ScrapReason.csv' DELIMITER E'\t' CSV;
 SELECT 'Copying data into Production.TransactionHistory';
