Kevin Wyllie Week 6 - Revision history

Kwyllie: Typo fix.

2015-10-14T06:13:11Z

Typo fix.

Kwyllie: Formatting fix.

2015-10-14T06:12:27Z

Formatting fix.

Kwyllie: Fixed template syntax.

2015-10-14T06:12:08Z

Fixed template syntax.

Kwyllie: Added the "good practice" stuff.

2015-10-14T06:11:28Z

Added the "good practice" stuff.

Kwyllie: Formatting fix.

2015-10-14T06:09:41Z

Formatting fix.

Kwyllie: /* Protocol - Product.txt */

2015-10-14T06:08:41Z

‎Protocol - Product.txt

Kwyllie: Finished the questions!!!!!!

2015-10-14T06:07:05Z

Finished the questions!!!!!!

Kwyllie: Just saving in case of network timeout.

2015-10-14T05:59:35Z

Just saving in case of network timeout.

Kwyllie: Just saving in case of network timeout.

2015-10-14T05:45:18Z

Just saving in case of network timeout.

@@ Line 29: / Line 29: @@
 # '''What are the names of the drug products whose active ingredient (activeingred) is ATROPINE?'''
 #* <code>select drugname from product where activeingredient = 'ATROPINE'</code>
-#** ''Note, the column name in my table is <code>activeingrident</code> instead of <code>activeingred</code>.
+#** ''Note, the column name in my table is <code>activeingredient</code> instead of <code>activeingred</code>.
 #* ATROPINE and ATROPEN.
 # '''In what forms and dosages can the drug product named BENADRYL be administered?

@@ Line 158: / Line 158: @@
 #* Paste the body of text into the SQL window as done before.
-===Links===
+==Links==
 {{Template:KwyllieJournalLinks}}
 [[Category: Journal Entry]]

@@ Line 160: / Line 160: @@
 ===Links===
-{{template:kwylliejournallinks}}
+{{Template:KwyllieJournalLinks}}
 [[Category: Journal Entry]]

← Older revision		Revision as of 06:11, 14 October 2015
Line 157:		Line 157:
	#* <code>sed "s/^/insert into Product (ApplNo,ProductNo,Form,Dosage,ProductMktStatus,TEcode,ReferenceDrug,drugname,activeingredient) values(/g" \| sed "s/$/);/g" > ~/public_html/Product.sql.txt</code>		#* <code>sed "s/^/insert into Product (ApplNo,ProductNo,Form,Dosage,ProductMktStatus,TEcode,ReferenceDrug,drugname,activeingredient) values(/g" \| sed "s/$/);/g" > ~/public_html/Product.sql.txt</code>
	#* Paste the body of text into the SQL window as done before.		#* Paste the body of text into the SQL window as done before.
		+
		+	===Links===
		+
		+	{{template:kwylliejournallinks}}
		+	[[Category: Journal Entry]]

@@ Line 45: / Line 45: @@
 # '''What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK?'''
 #* <code>select drugname from product inner join application on (product.ApplNo = application.ApplNo) where SponsorApplicant = 'MERCK' group by drugname</code>
-#* "DECADRON", "HUMORSOL", "NEO-HYDELTRASOL", "PRINIVIL", "MAXALT-MLT", "HYDROCORTONE", "PERIACTIN", "PROPECIA", "PROSCAR", "CLINORIL", "PRINZIDE", "ELSPAR", "ALDOMET", "ALDORIL D30", "EMEND", "DIUPRES-500", "NEODECADRON", "ALDOCLOR-250", "MEFOXIN IN DEXTROSE 5% IN PLASTIC CONTAINER", "ARAMINE", "TIAMATE", "BLOCADREN", "CANCIDAS", "CHIBROXIN", "CORTONE", "PEPCID", "TRUSOPT", "REDISOL", "VIOXX", "FLOROPRYL", "ALPHAREDISOL", "DECADRON-LA", "MEFOXIN IN SODIUM CHLORIDE 0.9% IN PLASTIC CONTAINER", "PEPCID RPD", "NOROXIN", "ZOCOR", "LERITINE", "DECADERM", "DOLOBID", "MANNITOL 25%", "DECADRON W/ XYLOCAINE", "ALDORIL D50", "TIMOLIDE 10-25", "CYCLAINE"
+#* "DECADRON", "HUMORSOL", "NEO-HYDELTRASOL", "PRINIVIL", "MAXALT-MLT", "HYDROCORTONE", "PERIACTIN", "PROPECIA", "PROSCAR", "CLINORIL", "PRINZIDE", "ELSPAR", "ALDOMET", "ALDORIL D30", "EMEND", "DIUPRES-500", "NEODECADRON", "ALDOCLOR-250", "MEFOXIN IN DEXTROSE 5% IN PLASTIC CONTAINER", "ARAMINE", "TIAMATE", "BLOCADREN", "CANCIDAS", "CHIBROXIN", "CORTONE", "PEPCID", "TRUSOPT", "REDISOL", "VIOXX", "FLOROPRYL", "ALPHAREDISOL", "DECADRON-LA", "MEFOXIN IN SODIUM CHLORIDE 0.9% IN PLASTIC CONTAINER", "PEPCID RPD", "NOROXIN", "ZOCOR", "LERITINE", "DECADERM", "DOLOBID", "MANNITOL 25%", "DECADRON W/ XYLOCAINE", "ALDORIL D50", "TIMOLIDE 10-25", "CYCLAINE", "HYDROPRES 25", "AMINOHIPPURATE SODIUM", "MEVACOR", "MODURETIC 5-50", "ALDORIL 25", "SINGULAIR", "COLBENEMID", "DIUPRES-250", "HYDELTRA-TBA", "PRIMAXIN", "BENEMID", "MAXALT", "FOSAMAX PLUS D", "HYDRODIURIL", "HYDELTRASOL", "HYDROPRES 50", "ZOLINZA", "ALDORIL 15", "FOSAMAX", "DECASPRAY", "COGENTIN", "ALDOCLOR-150", "PEPCID PRESERVATIVE FREE"
 "HYDROPRES 25", "AMINOHIPPURATE SODIUM", "MEVACOR", "MODURETIC 5-50", "ALDORIL 25", "SINGULAIR", "COLBENEMID", "DIUPRES-250", "HYDELTRA-TBA", "PRIMAXIN", "BENEMID", "MAXALT", "FOSAMAX PLUS D", "HYDRODIURIL", "HYDELTRASOL", "HYDROPRES 50", "ZOLINZA", "ALDORIL 15", "FOSAMAX", "DECASPRAY", "COGENTIN", "ALDOCLOR-150", "PEPCID PRESERVATIVE FREE"
 # '''Which sponsor applicant companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE'''
 #* <code>select SponsorApplicant,  from application inner join product on (application.ApplNo = product.ApplNo) where SponsorApplicant like '%LABS%' and activeingredient like '%ASPIRIN%' and activeingredient like '%CAFFEINE%' group by SponsorApplicant</code>

@@ Line 141: / Line 141: @@
 # A grep search of the file returned no tildes, so again, that's a candidate for (temporarily) separating lines.
 #* <code>sed "s/\t/~/g"</code>
 # [[file:kw_week6_Screenshot5.png|right|thumb]]A quick visual scan of the original file reveals that there are several different intervening notices throughout. They all appear to begin with the pattern <code>Federal</code> so a grep search for this pattern revealed two variations of these notices (shown on right). These can/should be removed.
 #* <code>sed "s/\*\*Federal Register determination that product was not discontinued or withdrawn for safety or efficacy reasons\*\*//g"</code>

@@ Line 43: / Line 43: @@
 #* <code>select chemical_type, count (*) from application where chemical_type >=0 or chemical_type <0 group by chemical_type</code>
 #* [[file:kw_week6_Screenshot9.png|center|thumb]]
 ==Protocol==

@@ Line 34: / Line 34: @@
 #* <code>select form, dosage from Product where drugname = 'BENADRYL'</code>
 #* [[file:kw_week6_Screenshot7.png|thumb|center]]
 ==Protocol==