Week 6 E-notes Eyanosch - Revision history

Eyanosch at 05:39, 15 October 2015

2015-10-15T05:39:31Z

Eyanosch at 04:46, 15 October 2015

2015-10-15T04:46:23Z

Eyanosch at 03:48, 15 October 2015

2015-10-15T03:48:18Z

Eyanosch at 03:23, 15 October 2015

2015-10-15T03:23:43Z

Eyanosch at 02:47, 15 October 2015

2015-10-15T02:47:56Z

Eyanosch: Working on the hw and documenting my process, using this page as a template to cut and copy code into

2015-10-15T02:30:18Z

Working on the hw and documenting my process, using this page as a template to cut and copy code into

Eyanosch at 00:28, 15 October 2015

2015-10-15T00:28:06Z

Eyanosch: starting week 6 e-notes

2015-10-14T19:39:08Z

starting week 6 e-notes

New page

[[User: Eyanosch | Erich Yanoschik]]

Week 6 E-Notes

{{Template: Pertinent Class Information}}

[[Category: Journal Entry]]

@@ Line 72: / Line 72: @@
 .
 .
 .
+Right now I'm getting errors because I am trying to combine varchars with integers from the different tables, If I change my the table to varchar instead of integer then they will probably be able to communicate
 .

@@ Line 38: / Line 38: @@
 Ran the program in SQL:
   Query returned successfully: one row affected, 4916 ms execution time.
 {{Template: Pertinent Class Information}}
 [[Category: Journal Entry]]

@@ Line 37: / Line 37: @@
 Ran the program in SQL:
+  Query returned successfully: one row affected, 4916 ms execution time.
 {{Template: Pertinent Class Information}}
 [[Category: Journal Entry]]

← Older revision		Revision as of 03:23, 15 October 2015
Line 32:		Line 32:


		+	cat Product.txt \| sed "s/'/\"/g" \| sed "s/ *//g" \| sed "s/\t/ /g" \| sed "s/ /' /g" \| sed "s/. /&'/g" \| sed "s/ /,&/g" \| sed "s/\r$/');/g" \| sed "s/^/&'/g" \| sed "s/''/null/g" \| sed "s/^/insert into product(ApplNo, ProductNo, Form, Dosage, productMktStatus, TECode, ReferenceDrug, drugname, activeingred) values (/g" \| sed "1D" > ~/public_html/Product.sql.txt

		+	Apply the same principle but there were 's within the text so I changed them into " and replaced them with null

		+	Ran the program in SQL:
		+

	{{Template: Pertinent Class Information}}		{{Template: Pertinent Class Information}}

	[[Category: Journal Entry]]		[[Category: Journal Entry]]

← Older revision		Revision as of 02:47, 15 October 2015
Line 23:		Line 23:

	This should give the proper syntax for adding from the database the SQL		This should give the proper syntax for adding from the database the SQL
		+
		+	After Copying the page of code and entering into the SQL file, the results were:
		+
		+	Query returned successfully: one row affected, 2329 ms execution time.
		+
		+
		+	Now onto product

← Older revision		Revision as of 02:30, 15 October 2015
Line 4:		Line 4:

	After downloading the zip files and unzipping them I need to rework the files so they can be loaded into postgreSQL		After downloading the zip files and unzipping them I need to rework the files so they can be loaded into postgreSQL
		+	cat application.txt \| sed"s/^/insert into Applications(ApplNo, ApplType, SponsorApplicant, MostRecentLabelAvailableFlag, CurrentPatentFlag, ActionType, Chemical_Type, Ther_Potential, Orphan_Code) values (/g"
		+
		+	*
		+	sed "s/ */ /g"
		+
		+	eyanosch@ab201:~$ cat application.txt \| sed "s/ *//g" \| sed "s/\t/ /g"
		+
		+	# pulls up information, removes the spaces, and removes the tabs. Adds a space inbetween each column
		+
		+	cat application.txt \| sed "s/. /&,/g"\| sed "s/ *//g" \| sed "s/\t/ /g"
		+
		+	eyanosch@ab201:~$ cat application.txt \| sed "s/ *//g" \| sed "s/\t/ /g" \| sed "s/ /' /g" \| sed "s/. /&'/g" \| sed "s/ /,&/g" \| sed "s/\r$/'/g" \| sed "s/^/&'/g" \| sed "s/''/null/g"
		+
		+	I had to add ' behind and infront of every character and then the empty spaces that were '' I replaced with the word null
		+
		+
		+	cat application.txt \| sed "s/ *//g" \| sed "s/\t/ /g" \| sed "s/ /' /g" \| sed "s/. /&'/g" \| sed "s/ /,&/g" \| sed "s/\r$/');/g" \| sed "s/^/&'/g" \| sed "s/''/null/g" \|sed "s/^/insert into Application(ApplNo, ApplType, SponsorApplicant, MostRecentLabelAvailableFlag, CurrentPatentFlag, ActionType, Chemical_Type, Ther_Potential, Orphan_Code) values (/g" \| sed "1D" > ~/public_html/application.sql.txt
		+
		+	This should give the proper syntax for adding from the database the SQL

← Older revision		Revision as of 00:28, 15 October 2015
Line 3:		Line 3:
	Week 6 E-Notes		Week 6 E-Notes

−		+	After downloading the zip files and unzipping them I need to rework the files so they can be loaded into postgreSQL