FEED Validator

Congratulations!

This is a valid Atom 1.0 feed.

Recommendations

This feed is valid, but interoperability with the widest range of feed readers could be improved by implementing the following recommendations.

• line 1, column 118: Use of unknown namespace: http://schemas.google.com/blogger/2008 [help]

  ... r.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2 ...
                                               ^

• line 1, column 118: Unable to validate namespace: http://schemas.google.com/g/2005. See the Google Data specification at https://developers.google.com/gdata/docs/1.0/elements [help]

  ... r.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2 ...
                                               ^

• line 1, column 977: subtitle should not be blank [help]

  ...  Resources</title><subtitle type='html'></subtitle><link rel='http://sch ...
                                               ^

• line 1, column 1240: Self reference doesn't match document location [help]

  ... eds/1083017836179388179/posts/default'/><link rel='alternate' type='text ...
                                               ^

• line 67, column 1441: title should not be blank [help]

  ... /ns#" term="ITC220"/><title type='text'></title><content type='html'>&lt ...
                                               ^

• line 79, column 728: The title attribute of link should not be blank [help]

  ... -sauce-crust-sides-size.html' title=''/><author><name>spconger</name><ur ...
                                               ^

• line 747, column 0: content should not contain imageanchor attribute (5 occurrences) [help]

  </content><link rel='replies' type='application/atom+xml' href='http://conge ...
  

• line 747, column 0: content should not contain data-original-width attribute (5 occurrences) [help]

  </content><link rel='replies' type='application/atom+xml' href='http://conge ...
  

• line 747, column 0: content should not contain data-original-height attribute (5 occurrences) [help]

  </content><link rel='replies' type='application/atom+xml' href='http://conge ...
  

Source: http://congeritc.blogspot.com/feeds/posts/default

1. <?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-1083017836179388179</id><updated>2024-03-19T04:10:30.001-07:00</updated><category term="ITC222"/><category term="ITC110"/><category term="ITC220"/><category term="ITC172"/><category term="ITC255"/><category term="ITC224"/><category term="ITC115"/><category term="ITC226"/><category term="ITC162"/><category term="Java"/><category term="ITC 172"/><category term="ITC285"/><category term="Trends"/><category term="Android"/><category term="IT 225"/><category term="ITC299"/><title type='text'>ITC Resources</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default?start-index=26&amp;max-results=25'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>913</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-877370385240361314</id><published>2020-08-09T10:41:00.003-07:00</published><updated>2020-08-09T10:41:36.893-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="IT 225"/><title type='text'>Code from Testing Video</title><content type='html'>&lt;p&gt;Here is the customer class code:&lt;/p&gt;
2. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">Customer</span>():
3.    <span style="color: #888888">#constructor</span>
4.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">__init__</span>(<span style="color: #007020">self</span>, <span style="color: #007020">id</span>, name, email, rewards):
5.        <span style="color: #007020">self</span><span style="color: #333333">.</span>id<span style="color: #333333">=</span><span style="color: #007020">id</span>
6.        <span style="color: #007020">self</span><span style="color: #333333">.</span>name<span style="color: #333333">=</span>name
7.        <span style="color: #007020">self</span><span style="color: #333333">.</span>email<span style="color: #333333">=</span>email
8.        <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards<span style="color: #333333">=</span>rewards
9.    
10.    <span style="color: #888888">#gets for fields</span>
11.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getId</span>(<span style="color: #007020">self</span>):
12.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>id
13.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getName</span>(<span style="color: #007020">self</span>):
14.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>name
15.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getEmail</span>(<span style="color: #007020">self</span>):
16.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>email
17.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getRewards</span>(<span style="color: #007020">self</span>):
18.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards
19.    
20.    <span style="color: #888888">#methods to add or use rewards</span>
21.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">addReward</span>(<span style="color: #007020">self</span>, points):
22.        <span style="color: #888888">#make sure points is an integer</span>
23.        points<span style="color: #333333">=</span><span style="color: #007020">int</span>(points)
24.        <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards <span style="color: #333333">+=</span> points
25.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">useRewards</span>(<span style="color: #007020">self</span>, points):
26.        points<span style="color: #333333">=</span><span style="color: #007020">int</span>(points)
27.        <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards <span style="color: #333333">=</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards <span style="color: #333333">-</span> points
28.    
29.  
30.    <span style="color: #888888"># class string method</span>
31.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">__str__</span>(<span style="color: #007020">self</span>):
32.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>name <span style="color: #333333">+</span> <span style="background-color: #fff0f0">' '</span> <span style="color: #333333">+</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>email
33. </pre></div>
34. <p>Here is the code for the test.py:</p>
35. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #008800; font-weight: bold">import</span> <span style="color: #0e84b5; font-weight: bold">unittest</span>
36. <span style="color: #008800; font-weight: bold">from</span> <span style="color: #0e84b5; font-weight: bold">customer</span> <span style="color: #008800; font-weight: bold">import</span> Customer
37.  
38. <span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">TestCustomer</span>(unittest<span style="color: #333333">.</span>TestCase):
39.    <span style="color: #888888">#set up an instance of the class</span>
40.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">setUp</span>(<span style="color: #007020">self</span>):
41.        <span style="color: #007020">self</span><span style="color: #333333">.</span>c<span style="color: #333333">=</span>Customer(<span style="color: #0000DD; font-weight: bold">123</span>,<span style="background-color: #fff0f0">'Bret Brown'</span>, <span style="background-color: #fff0f0">'bb@gmail.com'</span>, <span style="color: #0000DD; font-weight: bold">100</span>)
42.    <span style="color: #888888">#test the get methods</span>
43.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_Id</span>(<span style="color: #007020">self</span>):
44.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">self</span><span style="color: #333333">.</span>c<span style="color: #333333">.</span>getId(), <span style="color: #0000DD; font-weight: bold">123</span>)
45.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_name</span>(<span style="color: #007020">self</span>):
46.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">self</span><span style="color: #333333">.</span>c<span style="color: #333333">.</span>getName(),<span style="background-color: #fff0f0">'Bret Brown'</span> )
47.    <span style="color: #888888"># test the rewards</span>
48.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_AddReward</span>(<span style="color: #007020">self</span>):
49.        <span style="color: #007020">self</span><span style="color: #333333">.</span>c<span style="color: #333333">.</span>addReward(<span style="color: #0000DD; font-weight: bold">50</span>)
50.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">self</span><span style="color: #333333">.</span>c<span style="color: #333333">.</span>getRewards(), <span style="color: #0000DD; font-weight: bold">150</span>)
51.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_UseReward</span>(<span style="color: #007020">self</span>):
52.        <span style="color: #007020">self</span><span style="color: #333333">.</span>c<span style="color: #333333">.</span>useRewards(<span style="color: #0000DD; font-weight: bold">50</span>)
53.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">self</span><span style="color: #333333">.</span>c<span style="color: #333333">.</span>getRewards(), <span style="color: #0000DD; font-weight: bold">50</span>)
54.    <span style="color: #888888">#other tests</span>
55.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_Addreward2</span>(<span style="color: #007020">self</span>):
56.        <span style="color: #007020">self</span><span style="color: #333333">.</span>c<span style="color: #333333">.</span>addReward(<span style="color: #0000DD; font-weight: bold">50</span>)
57.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertGreater(<span style="color: #007020">self</span><span style="color: #333333">.</span>c<span style="color: #333333">.</span>getRewards(), <span style="color: #0000DD; font-weight: bold">100</span>)
58.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_addRewards3</span>(<span style="color: #007020">self</span>):
59.        <span style="color: #007020">self</span><span style="color: #333333">.</span>c<span style="color: #333333">.</span>addReward(<span style="color: #6600EE; font-weight: bold">50.5</span>)
60.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">self</span><span style="color: #333333">.</span>c<span style="color: #333333">.</span>getRewards(), <span style="color: #0000DD; font-weight: bold">150</span>)
61.    <span style="color: #888888"># test class string method</span>
62.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_ToString</span>(<span style="color: #007020">self</span>):
63.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">str</span>(<span style="color: #007020">self</span><span style="color: #333333">.</span>c), <span style="background-color: #fff0f0">'Bret Brown bb@gmail.com'</span>)
64.  
65.    
66. </pre></div>
67. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/877370385240361314/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2020/08/code-from-testing-video.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/877370385240361314'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/877370385240361314'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2020/08/code-from-testing-video.html' title='Code from Testing Video'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-1336463177424312350</id><published>2020-01-08T11:46:00.001-08:00</published><updated>2020-01-08T11:46:12.014-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC220"/><title type='text'></title><content type='html'>&lt;pre&gt;
68. toppings, sauce, crust, sides, size,
69. customer, price, drinks, employees (not whole human resource),
70. delivery methods, (office space leasing)
71. Customer name, address, payment method, phone, email,
72. order (ovens) (monthly sales) SaleDates,
73. Inventory, boxes, promotions discounts, nutrition,
74. employee number, schedule, tips, opening closing times,location,
75. products, customer Loyality points, Vendors, equipment
76. maintenance and schedules.
77. wastage--menu--uniforms
78.  
79. &lt;/pre&gt;</content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/1336463177424312350/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2020/01/toppings-sauce-crust-sides-size.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/1336463177424312350'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/1336463177424312350'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2020/01/toppings-sauce-crust-sides-size.html' title=''/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-967638393225220583</id><published>2019-11-25T13:23:00.000-08:00</published><updated>2019-11-25T13:24:03.490-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC220"/><title type='text'>Security Login, Posgresql</title><content type='html'>&lt;!-- HTML generated using hilite.me --&gt;&lt;div style=&quot;background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;&quot;&gt;&lt;pre style=&quot;margin: 0; line-height: 125%&quot;&gt;&lt;span style=&quot;color: #888888&quot;&gt;/*&lt;/span&gt;
80. <span style="color: #888888">Permision consist of SQL commands--</span>
81. <span style="color: #888888">SELECT, INSERT, UPDATE, EXCECUTE, DELETE, DROP. CREATE, ALTER</span>
82. <span style="color: #888888">Anything that is not granted is denied</span>
83. <span style="color: #888888">A user should be given all the permissions necessary</span>
84. <span style="color: #888888">to do what they need to do in the database</span>
85. <span style="color: #888888">But no more.</span>
86. <span style="color: #888888">*/</span>
87. <span style="color: #008800; font-weight: bold">Create</span> <span style="color: #008800; font-weight: bold">role</span> tenantrole;
88. <span style="color: #008800; font-weight: bold">Grant</span> <span style="color: #008800; font-weight: bold">SELECT</span> <span style="color: #008800; font-weight: bold">on</span> <span style="color: #AA6600">"Apartment"</span> <span style="color: #008800; font-weight: bold">to</span> tenantrole;
89. <span style="color: #008800; font-weight: bold">Grant</span> <span style="color: #008800; font-weight: bold">SELECT</span> <span style="color: #008800; font-weight: bold">on</span> <span style="color: #AA6600">"Lease"</span> <span style="color: #008800; font-weight: bold">to</span> tenantrole;
90. <span style="color: #008800; font-weight: bold">Grant</span> <span style="color: #008800; font-weight: bold">UPDATE</span> <span style="color: #008800; font-weight: bold">on</span> <span style="color: #AA6600">"Tenant"</span> <span style="color: #008800; font-weight: bold">to</span> Tenantrole;
91. <span style="color: #008800; font-weight: bold">Grant</span> <span style="color: #008800; font-weight: bold">SELECT</span> <span style="color: #008800; font-weight: bold">on</span> <span style="color: #AA6600">"Tenant"</span> <span style="color: #008800; font-weight: bold">to</span> tenantrole;
92.  
93. <span style="color: #008800; font-weight: bold">Create</span> <span style="color: #008800; font-weight: bold">role</span> johnsmith <span style="color: #008800; font-weight: bold">with</span> password <span style="background-color: #fff0f0">'password'</span>;
94. <span style="color: #008800; font-weight: bold">Grant</span> tenantrole <span style="color: #008800; font-weight: bold">to</span> johnsmith;
95. <span style="color: #008800; font-weight: bold">Alter</span> <span style="color: #008800; font-weight: bold">role</span> johnsmith <span style="color: #008800; font-weight: bold">with</span> login;
96. </pre></div>
97. <p>The test after logging in as johnsmith</p>
98. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> <span style="color: #AA6600">"Apartment"</span>;
99. <span style="color: #008800; font-weight: bold">Update</span> <span style="color: #AA6600">"Apartment"</span>
100. <span style="color: #008800; font-weight: bold">SET</span> <span style="color: #AA6600">"Bedrooms"</span><span style="color: #333333">=</span><span style="color: #0000DD; font-weight: bold">3</span>
101. <span style="color: #008800; font-weight: bold">WHERE</span> <span style="color: #AA6600">"ApartmentNumber"</span><span style="color: #333333">=</span><span style="color: #0000DD; font-weight: bold">102</span>;
102. </pre></div>
103. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/967638393225220583/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/11/security-login-posgresql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/967638393225220583'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/967638393225220583'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/11/security-login-posgresql.html' title='Security Login, Posgresql'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-7345036583756536270</id><published>2019-11-23T12:21:00.001-08:00</published><updated>2019-11-23T12:21:15.868-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC220"/><title type='text'>SQL for Postgresql</title><content type='html'>&lt;!-- HTML generated using hilite.me --&gt;&lt;div style=&quot;background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;&quot;&gt;&lt;pre style=&quot;margin: 0; line-height: 125%&quot;&gt;&lt;span style=&quot;color: #888888&quot;&gt;/*&lt;/span&gt;
104. <span style="color: #888888">List all the tenants.</span>
105. <span style="color: #888888">List all the current maintenance requests.</span>
106. <span style="color: #888888">Which apartments are currently occupied? join apartment and lease</span>
107. <span style="color: #888888">Which apartments are empty? Left outer join with Apartment and Lease</span>
108. <span style="color: #888888">Update maintenance request 2 to give it a completion date of today.</span>
109. <span style="color: #888888">Insert a new tenant: Tammy Benedict, tbenedict@gmail.com, phone: 2065551200. She has no sub tenants</span>
110. <span style="color: #888888">Add a new 6 month lease starting today on apartment 205, standard deposit, no pets</span>
111. <span style="color: #888888">Record her first rent payment</span>
112. <span style="color: #888888">Turn in the SQL and screenshots of the the answers</span>
113. <span style="color: #888888">You may have to put the column and table names in double quotes if you made your database</span>
114. <span style="color: #888888">from lucidcharts</span>
115. <span style="color: #888888">*/</span>
116. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> <span style="color: #AA6600">"person"</span>;
117. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> donation;
118. <span style="color: #008800; font-weight: bold">Select</span> personlastname, personfirstname, personaddressStreet, personaddressCity
119. <span style="color: #008800; font-weight: bold">From</span> person
120. <span style="color: #008800; font-weight: bold">inner</span> <span style="color: #008800; font-weight: bold">join</span> personaddress
121. <span style="color: #008800; font-weight: bold">on</span> person.personkey<span style="color: #333333">=</span>personaddress.personkey;
122.  
123. <span style="color: #888888">--outer join</span>
124. <span style="color: #008800; font-weight: bold">Select</span> granttypename, grantapplication.granttypekey
125. <span style="color: #008800; font-weight: bold">From</span> granttype
126. <span style="color: #008800; font-weight: bold">Left</span> <span style="color: #008800; font-weight: bold">outer</span> <span style="color: #008800; font-weight: bold">join</span> grantapplication
127. <span style="color: #008800; font-weight: bold">On</span> granttype.granttypekey<span style="color: #333333">=</span>grantapplication.grantTypekey
128. <span style="color: #008800; font-weight: bold">Where</span> grantapplication.granttypekey <span style="color: #008800; font-weight: bold">is</span> <span style="color: #008800; font-weight: bold">null</span>;
129.  
130. <span style="color: #888888">--updates are to change existing records</span>
131. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> person <span style="color: #008800; font-weight: bold">where</span> personkey<span style="color: #333333">=</span><span style="color: #0000DD; font-weight: bold">2</span>;
132. <span style="color: #008800; font-weight: bold">Update</span> person
133. <span style="color: #008800; font-weight: bold">Set</span> Personlastname<span style="color: #333333">=</span><span style="background-color: #fff0f0">'Caroll'</span>,
134. personemail<span style="color: #333333">=</span><span style="background-color: #fff0f0">'lindaCaroll@gmail.com'</span>
135. <span style="color: #008800; font-weight: bold">WHERE</span> personkey<span style="color: #333333">=</span><span style="color: #0000DD; font-weight: bold">2</span>;
136.  
137. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> person(personlastname, personfirstname, personemail, personprimaryphone, persondateadded)
138. <span style="color: #008800; font-weight: bold">Values</span>(<span style="background-color: #fff0f0">'Nelson'</span>,<span style="background-color: #fff0f0">'Tom'</span>, <span style="background-color: #fff0f0">'tom.nelson@msn.com'</span>, <span style="background-color: #fff0f0">'2065553233'</span>, <span style="color: #008800; font-weight: bold">current_date</span>);
139.  
140. <span style="color: #008800; font-weight: bold">select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> person <span style="color: #008800; font-weight: bold">where</span> personlastname<span style="color: #333333">=</span><span style="background-color: #fff0f0">'Nelson'</span>;
141.  
142. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> Donation(personkey, donationamount, donationDate)
143. <span style="color: #008800; font-weight: bold">Values</span>(<span style="color: #0000DD; font-weight: bold">134</span>, <span style="color: #0000DD; font-weight: bold">500</span>.<span style="color: #0000DD; font-weight: bold">00</span>, <span style="color: #008800; font-weight: bold">current_date</span>);
144. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> donation <span style="color: #008800; font-weight: bold">where</span> personkey <span style="color: #333333">=</span><span style="color: #0000DD; font-weight: bold">134</span>;
145. </pre></div>
146. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/7345036583756536270/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/11/sql-for-postgresql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/7345036583756536270'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/7345036583756536270'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/11/sql-for-postgresql.html' title='SQL for Postgresql'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-4519191640354680274</id><published>2019-11-16T14:47:00.000-08:00</published><updated>2019-11-16T14:47:01.318-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC110"/><title type='text'>Code for Assignment 8 Video</title><content type='html'>&lt;p&gt;Customer Class&lt;/p&gt;
147. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #DD4422">'''</span>
148. <span style="color: #DD4422">Class called Customer</span>
149. <span style="color: #DD4422">Every customer has a name,</span>
150. <span style="color: #DD4422">number, email, phone and they</span>
151. <span style="color: #DD4422">can collect rewards points</span>
152. <span style="color: #DD4422">An object is collection of related</span>
153. <span style="color: #DD4422">functions. They all relate</span>
154. <span style="color: #DD4422">to one topic like customer.</span>
155. <span style="color: #DD4422">The idea is to make it easier</span>
156. <span style="color: #DD4422">to manage complex code</span>
157. <span style="color: #DD4422">by breaking it into the kinds</span>
158. <span style="color: #DD4422">of objects that actually make up</span>
159. <span style="color: #DD4422">the contents of the program</span>
160. <span style="color: #DD4422">abstraction</span>
161. <span style="color: #DD4422">encapsulation</span>
162. <span style="color: #DD4422">inheritance</span>
163. <span style="color: #DD4422">polymorphism</span>
164. <span style="color: #DD4422">'''</span>
165. <span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">Customer</span>():
166.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">__init__</span>(<span style="color: #007020">self</span>, number, name, phone, email, rewards):
167.        <span style="color: #007020">self</span><span style="color: #333333">.</span>number<span style="color: #333333">=</span>number
168.        <span style="color: #007020">self</span><span style="color: #333333">.</span>name<span style="color: #333333">=</span>name
169.        <span style="color: #007020">self</span><span style="color: #333333">.</span>phone<span style="color: #333333">=</span>phone
170.        <span style="color: #007020">self</span><span style="color: #333333">.</span>email<span style="color: #333333">=</span>email
171.        <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards<span style="color: #333333">=</span>rewards
172.  
173.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">setPhone</span>(<span style="color: #007020">self</span>, phone):
174.        <span style="color: #007020">self</span><span style="color: #333333">.</span>phone<span style="color: #333333">=</span>phone
175.  
176.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getPhone</span>(<span style="color: #007020">self</span>):
177.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>phone
178.  
179.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getName</span>(<span style="color: #007020">self</span>):
180.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>name
181.  
182.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getEmail</span>(<span style="color: #007020">self</span>):
183.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>email
184.  
185.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getRewards</span>(<span style="color: #007020">self</span>):
186.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards
187.  
188.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">addRewards</span>(<span style="color: #007020">self</span>, points):
189.        <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards <span style="color: #333333">+=</span> points
190.  
191.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">useRewards</span>(<span style="color: #007020">self</span>, points):
192.        <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards <span style="color: #333333">=</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards<span style="color: #333333">-</span>points
193.  
194.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">__str__</span>(<span style="color: #007020">self</span>):
195.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">str</span>(<span style="color: #007020">self</span><span style="color: #333333">.</span>number) <span style="color: #333333">+</span> <span style="background-color: #fff0f0">", "</span> <span style="color: #333333">+</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>name
196.    
197. </pre></div>
198. <p>Item Class</p>
199. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #DD4422">'''</span>
200. <span style="color: #DD4422">class item</span>
201. <span style="color: #DD4422">It will represent an item to purchase</span>
202. <span style="color: #DD4422">It will have a number, a name and a price</span>
203. <span style="color: #DD4422">'''</span>
204. <span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">Item</span>():
205.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">__init__</span>(<span style="color: #007020">self</span>, number, name, price):
206.        <span style="color: #007020">self</span><span style="color: #333333">.</span>number<span style="color: #333333">=</span>number
207.        <span style="color: #007020">self</span><span style="color: #333333">.</span>name<span style="color: #333333">=</span>name
208.        <span style="color: #007020">self</span><span style="color: #333333">.</span>price<span style="color: #333333">=</span>price
209.  
210.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getNumber</span>(<span style="color: #007020">self</span>):
211.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>number
212.  
213.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getName</span>(<span style="color: #007020">self</span>):
214.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>name
215.  
216.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getPrice</span>(<span style="color: #007020">self</span>):
217.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>price
218.    
219. </pre></div>
220. <p>Purchase Class</p>
221. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #DD4422">'''</span>
222. <span style="color: #DD4422">Purchase class</span>
223. <span style="color: #DD4422">to show purchase of an item</span>
224. <span style="color: #DD4422">it will have a list of items</span>
225. <span style="color: #DD4422">and methods for</span>
226. <span style="color: #DD4422">Totaling the purchase</span>
227. <span style="color: #DD4422">and totaling the points</span>
228. <span style="color: #DD4422">str method that outputs</span>
229. <span style="color: #DD4422">basically a receipt</span>
230. <span style="color: #DD4422">'''</span>
231. <span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">Purchase</span>():
232.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">__init__</span>(<span style="color: #007020">self</span>):
233.        <span style="color: #007020">self</span><span style="color: #333333">.</span>items<span style="color: #333333">=</span>[]
234.  
235.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">addItem</span>(<span style="color: #007020">self</span>, item):
236.        <span style="color: #007020">self</span><span style="color: #333333">.</span>items<span style="color: #333333">.</span>append(item)
237.  
238.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">totalItems</span>(<span style="color: #007020">self</span>):
239.        total<span style="color: #333333">=</span><span style="color: #0000DD; font-weight: bold">0</span>
240.        <span style="color: #008800; font-weight: bold">for</span> item <span style="color: #000000; font-weight: bold">in</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>items:
241.            total <span style="color: #333333">+=</span> item<span style="color: #333333">.</span>price
242.        <span style="color: #008800; font-weight: bold">return</span> total
243.  
244.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">totalPoints</span>(<span style="color: #007020">self</span>):
245.        total<span style="color: #333333">=</span><span style="color: #007020">self</span><span style="color: #333333">.</span>totalItems()
246.        points<span style="color: #333333">=</span><span style="color: #007020">int</span>(total)
247.        <span style="color: #008800; font-weight: bold">return</span> points
248.  
249.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">__str__</span>(<span style="color: #007020">self</span>):
250.        receipt<span style="color: #333333">=</span><span style="background-color: #fff0f0">""</span>
251.        <span style="color: #008800; font-weight: bold">for</span> item <span style="color: #000000; font-weight: bold">in</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>items:
252.            receipt <span style="color: #333333">=</span>receipt <span style="color: #333333">+</span> item<span style="color: #333333">.</span>name <span style="color: #333333">+</span><span style="background-color: #fff0f0">"</span><span style="color: #666666; font-weight: bold; background-color: #fff0f0">\t\t</span><span style="background-color: #fff0f0">"</span> <span style="color: #333333">+</span> <span style="color: #007020">str</span>(item<span style="color: #333333">.</span>price) <span style="color: #333333">+</span> <span style="background-color: #fff0f0">"</span><span style="color: #666666; font-weight: bold; background-color: #fff0f0">\n</span><span style="background-color: #fff0f0">"</span>
253.        total <span style="color: #333333">=</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>totalItems()
254.        receipt<span style="color: #333333">=</span>receipt <span style="color: #333333">+</span> <span style="background-color: #fff0f0">"</span><span style="color: #666666; font-weight: bold; background-color: #fff0f0">\t\t</span><span style="background-color: #fff0f0">"</span> <span style="color: #333333">+</span> <span style="color: #007020">str</span>(total)
255.        <span style="color: #008800; font-weight: bold">return</span> receipt
256.    
257.    
258. </pre></div>
259. <p>Main</p>
260. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #008800; font-weight: bold">from</span> <span style="color: #0e84b5; font-weight: bold">customer</span> <span style="color: #008800; font-weight: bold">import</span> Customer
261. <span style="color: #008800; font-weight: bold">from</span> <span style="color: #0e84b5; font-weight: bold">item</span> <span style="color: #008800; font-weight: bold">import</span> Item
262. <span style="color: #008800; font-weight: bold">from</span> <span style="color: #0e84b5; font-weight: bold">purchase</span> <span style="color: #008800; font-weight: bold">import</span> Purchase
263.  
264. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">main</span>():
265.    cust<span style="color: #333333">=</span>Customer(<span style="color: #0000DD; font-weight: bold">123</span>, <span style="background-color: #fff0f0">'Steve'</span>, <span style="background-color: #fff0f0">'steve@spconger.com'</span>, <span style="background-color: #fff0f0">'2065551234'</span>, <span style="color: #0000DD; font-weight: bold">0</span>)
266.    purch <span style="color: #333333">=</span> Purchase()
267.    cont<span style="color: #333333">=</span><span style="background-color: #fff0f0">'y'</span>
268.    <span style="color: #008800; font-weight: bold">while</span> cont<span style="color: #333333">==</span><span style="background-color: #fff0f0">'y'</span>:
269.        itemNumber<span style="color: #333333">=</span><span style="color: #007020">int</span>(<span style="color: #007020">input</span>(<span style="background-color: #fff0f0">'Enter item Number. '</span>))
270.        itemName<span style="color: #333333">=</span><span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"Enter item name "</span>)
271.        itemPrice<span style="color: #333333">=</span><span style="color: #007020">float</span>(<span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"Enter item price "</span>))
272.        item<span style="color: #333333">=</span>Item(itemNumber, itemName, itemPrice)
273.        purch<span style="color: #333333">.</span>addItem(item)
274.        cont<span style="color: #333333">=</span><span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"Add another item? y to continue. "</span> )
275.        cont<span style="color: #333333">=</span>cont<span style="color: #333333">.</span>lower()
276.    <span style="color: #007020">print</span>(purch)
277.    cust<span style="color: #333333">.</span>addRewards(purch<span style="color: #333333">.</span>totalPoints())
278.    <span style="color: #007020">print</span> (<span style="background-color: #fff0f0">"your total rewards are"</span>, cust<span style="color: #333333">.</span>getRewards())
279.  
280. main()
281.                            
282. </pre></div>
283.  
284.  
285. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/4519191640354680274/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/11/code-for-assignment-8-video.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/4519191640354680274'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/4519191640354680274'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/11/code-for-assignment-8-video.html' title='Code for Assignment 8 Video'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-2560684087430995109</id><published>2019-11-10T12:28:00.003-08:00</published><updated>2019-11-10T12:28:56.849-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC110"/><title type='text'>Customer and customer test code from peer 8 video</title><content type='html'>&lt;!-- HTML generated using hilite.me --&gt;&lt;div style=&quot;background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;&quot;&gt;&lt;pre style=&quot;margin: 0; line-height: 125%&quot;&gt;&lt;span style=&quot;color: #DD4422&quot;&gt;&amp;#39;&amp;#39;&amp;#39;&lt;/span&gt;
286. <span style="color: #DD4422">Class called Customer</span>
287. <span style="color: #DD4422">Every customer has a name,</span>
288. <span style="color: #DD4422">number, email, phone and they</span>
289. <span style="color: #DD4422">can collect rewards points</span>
290. <span style="color: #DD4422">An object is collection of related</span>
291. <span style="color: #DD4422">functions. They all relate</span>
292. <span style="color: #DD4422">to one topic like customer.</span>
293. <span style="color: #DD4422">The idea is to make it easier</span>
294. <span style="color: #DD4422">to manage complex code</span>
295. <span style="color: #DD4422">by breaking it into the kinds</span>
296. <span style="color: #DD4422">of objects that actually make up</span>
297. <span style="color: #DD4422">the contents of the program</span>
298. <span style="color: #DD4422">abstraction</span>
299. <span style="color: #DD4422">encapsulation</span>
300. <span style="color: #DD4422">inheritance</span>
301. <span style="color: #DD4422">polymorphism</span>
302. <span style="color: #DD4422">'''</span>
303. <span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">Customer</span>():
304.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">__init__</span>(<span style="color: #007020">self</span>, number, name, phone, email, rewards):
305.        <span style="color: #007020">self</span><span style="color: #333333">.</span>number<span style="color: #333333">=</span>number
306.        <span style="color: #007020">self</span><span style="color: #333333">.</span>name<span style="color: #333333">=</span>name
307.        <span style="color: #007020">self</span><span style="color: #333333">.</span>phone<span style="color: #333333">=</span>phone
308.        <span style="color: #007020">self</span><span style="color: #333333">.</span>email<span style="color: #333333">=</span>email
309.        <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards<span style="color: #333333">=</span>rewards
310.  
311.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">setPhone</span>(<span style="color: #007020">self</span>, phone):
312.        <span style="color: #007020">self</span><span style="color: #333333">.</span>phone<span style="color: #333333">=</span>phone
313.  
314.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getPhone</span>(<span style="color: #007020">self</span>):
315.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>phone
316.  
317.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getName</span>(<span style="color: #007020">self</span>):
318.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>name
319.  
320.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getEmail</span>(<span style="color: #007020">self</span>):
321.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>email
322.  
323.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getRewards</span>(<span style="color: #007020">self</span>):
324.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards
325.  
326.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">addRewards</span>(<span style="color: #007020">self</span>, points):
327.        <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards <span style="color: #333333">+=</span> points
328.  
329.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">useRewards</span>(<span style="color: #007020">self</span>, points):
330.        <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards <span style="color: #333333">=</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>rewards<span style="color: #333333">-</span>points
331.  
332.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">__str__</span>(<span style="color: #007020">self</span>):
333.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">str</span>(<span style="color: #007020">self</span><span style="color: #333333">.</span>number) <span style="color: #333333">+</span> <span style="background-color: #fff0f0">", "</span> <span style="color: #333333">+</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>name
334.    
335. </pre></div>
336.  
337. <p>Customer test</p>
338. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #008800; font-weight: bold">from</span> <span style="color: #0e84b5; font-weight: bold">customer</span> <span style="color: #008800; font-weight: bold">import</span> Customer
339.  
340. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">main</span>():
341.    c1 <span style="color: #333333">=</span> Customer(<span style="color: #0000DD; font-weight: bold">123</span>, <span style="background-color: #fff0f0">'Joe Smith'</span>, <span style="background-color: #fff0f0">'2065551234'</span>, <span style="background-color: #fff0f0">'js@gmail.com'</span>, <span style="color: #0000DD; font-weight: bold">10</span>)
342.    <span style="color: #007020">print</span>(c1)
343.    c1<span style="color: #333333">.</span>addRewards(<span style="color: #0000DD; font-weight: bold">20</span>)
344.    <span style="color: #007020">print</span>(c1<span style="color: #333333">.</span>getRewards())
345.    c1<span style="color: #333333">.</span>useRewards(<span style="color: #0000DD; font-weight: bold">13</span>)
346.    <span style="color: #007020">print</span>(c1<span style="color: #333333">.</span>getRewards())
347.    <span style="color: #007020">print</span>(c1<span style="color: #333333">.</span>getEmail())
348.    c2<span style="color: #333333">=</span>Customer(<span style="color: #0000DD; font-weight: bold">234</span>, <span style="background-color: #fff0f0">'Lynn Jones'</span>, <span style="background-color: #fff0f0">'2065553456'</span>, <span style="background-color: #fff0f0">'Lynn@gamail.com'</span>,<span style="color: #0000DD; font-weight: bold">100</span>)
349.    <span style="color: #007020">print</span>(<span style="background-color: #fff0f0">"******************"</span>)
350.    <span style="color: #007020">print</span>(c1)
351.    <span style="color: #007020">print</span>()
352.    <span style="color: #007020">print</span>(c2)
353.  
354. main()
355. </pre></div>
356.  
357. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/2560684087430995109/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/11/customer-and-customer-test-code-from.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/2560684087430995109'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/2560684087430995109'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/11/customer-and-customer-test-code-from.html' title='Customer and customer test code from peer 8 video'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-4092533452942129338</id><published>2019-10-28T14:40:00.002-07:00</published><updated>2019-10-28T14:40:54.846-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC220"/><title type='text'>Intro to MySQL SQL</title><content type='html'>&lt;!-- HTML generated using hilite.me --&gt;&lt;div style=&quot;background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;&quot;&gt;&lt;pre style=&quot;margin: 0; line-height: 125%&quot;&gt;Use Sakila;
358. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> actor;
359. <span style="color: #008800; font-weight: bold">Select</span> first_name, last_name <span style="color: #008800; font-weight: bold">from</span> actor;
360. <span style="color: #008800; font-weight: bold">Select</span> last_name, first_name <span style="color: #008800; font-weight: bold">from</span> actor
361. <span style="color: #008800; font-weight: bold">order</span> <span style="color: #008800; font-weight: bold">by</span> last_name;
362. <span style="color: #008800; font-weight: bold">Select</span> last_name, first_name <span style="color: #008800; font-weight: bold">from</span> actor
363. <span style="color: #008800; font-weight: bold">order</span> <span style="color: #008800; font-weight: bold">by</span> last_name <span style="color: #008800; font-weight: bold">Desc</span>;
364. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> Address;
365. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> Address <span style="color: #008800; font-weight: bold">where</span> district <span style="color: #333333">=</span> <span style="background-color: #fff0f0">'California'</span>;
366. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> Customer;
367. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> Customer <span style="color: #008800; font-weight: bold">where</span>  Create_date <span style="color: #333333">></span><span style="background-color: #fff0f0">'2006-02-14'</span>;
368. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> payment;
369. <span style="color: #008800; font-weight: bold">Select</span> rental_id, amount <span style="color: #008800; font-weight: bold">from</span> payment
370. <span style="color: #008800; font-weight: bold">where</span> amount <span style="color: #333333">></span> <span style="color: #0000DD; font-weight: bold">5</span>;
371. <span style="color: #888888">/*join tables */</span>
372. <span style="color: #008800; font-weight: bold">Select</span> first_name, Last_name, Address, district
373. <span style="color: #008800; font-weight: bold">from</span> customer
374. <span style="color: #008800; font-weight: bold">inner</span> <span style="color: #008800; font-weight: bold">join</span> address
375. <span style="color: #008800; font-weight: bold">on</span> customer.address_id<span style="color: #333333">=</span>address.address_id
376. <span style="color: #008800; font-weight: bold">where</span> district<span style="color: #333333">=</span><span style="background-color: #fff0f0">'California'</span>;
377.  
378. <span style="color: #008800; font-weight: bold">Select</span> first_name, Last_name, Address, city, district
379. <span style="color: #008800; font-weight: bold">from</span> customer
380. <span style="color: #008800; font-weight: bold">inner</span> <span style="color: #008800; font-weight: bold">join</span> address
381. <span style="color: #008800; font-weight: bold">on</span> customer.address_id<span style="color: #333333">=</span>address.address_id
382. <span style="color: #008800; font-weight: bold">inner</span> <span style="color: #008800; font-weight: bold">join</span> City
383. <span style="color: #008800; font-weight: bold">on</span> city.city_id <span style="color: #333333">=</span> address.city_id
384. <span style="color: #008800; font-weight: bold">where</span> district<span style="color: #333333">=</span><span style="background-color: #fff0f0">'California'</span>;
385.  
386. <span style="color: #888888">/*insert new records */</span>
387. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> store;
388. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> customer(store_id, first_name, last_name,
389. address_id, active, create_date, last_update)
390. <span style="color: #008800; font-weight: bold">Values</span>(<span style="color: #0000DD; font-weight: bold">1</span>,<span style="background-color: #fff0f0">'Jennifer'</span>, <span style="background-color: #fff0f0">'Juniper'</span>, <span style="color: #0000DD; font-weight: bold">1</span>,<span style="color: #0000DD; font-weight: bold">1</span>, <span style="color: #008800; font-weight: bold">current_timestamp</span>, <span style="color: #008800; font-weight: bold">current_timestamp</span>);
391. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> staff;
392. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> customer;
393. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> rental(rental_date, Inventory_id, Customer_id, staff_id, last_update)
394. <span style="color: #008800; font-weight: bold">Values</span>(<span style="color: #008800; font-weight: bold">current_timestamp</span>, <span style="color: #0000DD; font-weight: bold">100</span>, <span style="color: #0000DD; font-weight: bold">600</span>, <span style="color: #0000DD; font-weight: bold">2</span>, <span style="color: #008800; font-weight: bold">current_timestamp</span>);
395. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> Rental <span style="color: #008800; font-weight: bold">ORDER</span> <span style="color: #008800; font-weight: bold">by</span> rental_id <span style="color: #008800; font-weight: bold">desc</span>;
396. </pre></div>
397. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/4092533452942129338/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/10/intro-to-mysql-sql.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/4092533452942129338'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/4092533452942129338'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/10/intro-to-mysql-sql.html' title='Intro to MySQL SQL'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-1764283062320320611</id><published>2019-10-28T13:58:00.001-07:00</published><updated>2019-10-28T13:58:18.683-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC110"/><title type='text'>if and while blocks</title><content type='html'>&lt;!-- HTML generated using hilite.me --&gt;&lt;div style=&quot;background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;&quot;&gt;&lt;pre style=&quot;margin: 0; line-height: 125%&quot;&gt;&lt;span style=&quot;color: #DD4422&quot;&gt;&amp;#39;&amp;#39;&amp;#39;&lt;/span&gt;
398. <span style="color: #DD4422">a=5</span>
399. <span style="color: #DD4422">b=10</span>
400. <span style="color: #DD4422">if a < b:</span>
401. <span style="color: #DD4422">    print(a, "is smaller thant", b)</span>
402. <span style="color: #DD4422">elif a > b:</span>
403. <span style="color: #DD4422">    print (a, " is bigger than ", b)</span>
404. <span style="color: #DD4422">else:</span>
405. <span style="color: #DD4422">    print (a, "is equal to ",b)</span>
406. <span style="color: #DD4422">'''</span>
407.  
408. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getGrade</span>():
409.    grade<span style="color: #333333">=-</span><span style="color: #0000DD; font-weight: bold">1</span>
410.    <span style="color: #008800; font-weight: bold">while</span> grade <span style="color: #333333"><</span> <span style="color: #0000DD; font-weight: bold">0</span> <span style="color: #000000; font-weight: bold">or</span> grade <span style="color: #333333">></span> <span style="color: #0000DD; font-weight: bold">100</span>:
411.        grade<span style="color: #333333">=</span><span style="color: #007020">int</span>(<span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"Enter a grade between 0 and 100 "</span>))
412.    <span style="color: #888888">#if grade < 0 or grade > 100:</span>
413.        <span style="color: #888888">#grade=-1       </span>
414.    <span style="color: #008800; font-weight: bold">return</span> grade
415.                    
416. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">evaluateGrade</span>():
417.    g <span style="color: #333333">=</span> getGrade()
418.    <span style="color: #888888">#if g == -1:</span>
419.        <span style="color: #888888">#print ("Invalid Grade")</span>
420.        <span style="color: #888888">#return</span>
421.      
422.    <span style="color: #008800; font-weight: bold">if</span> g <span style="color: #333333">></span> <span style="color: #0000DD; font-weight: bold">90</span>:
423.        <span style="color: #007020">print</span>(<span style="background-color: #fff0f0">"you did great"</span>)
424.    <span style="color: #008800; font-weight: bold">elif</span> g <span style="color: #333333">></span> <span style="color: #0000DD; font-weight: bold">80</span>:
425.        <span style="color: #007020">print</span>(<span style="background-color: #fff0f0">" you did good"</span>)
426.    <span style="color: #008800; font-weight: bold">elif</span> g <span style="color: #333333">></span> <span style="color: #0000DD; font-weight: bold">70</span>:
427.        <span style="color: #007020">print</span>(<span style="background-color: #fff0f0">"you passed"</span>)
428.    <span style="color: #008800; font-weight: bold">else</span>:
429.        <span style="color: #007020">print</span>(<span style="background-color: #fff0f0">"Sorry, you failed."</span>)
430.  
431. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">main</span>():
432.    choice<span style="color: #333333">=</span><span style="background-color: #fff0f0">'y'</span>
433.    <span style="color: #008800; font-weight: bold">while</span> choice <span style="color: #333333">==</span> <span style="background-color: #fff0f0">'y'</span>:
434.        evaluateGrade()
435.        choice<span style="color: #333333">=</span><span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"y to continue"</span>)
436.        choice<span style="color: #333333">.</span>lower()
437.  
438. main()
439. </pre></div>
440. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/1764283062320320611/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/10/if-and-while-blocks.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/1764283062320320611'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/1764283062320320611'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/10/if-and-while-blocks.html' title='if and while blocks'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-2515226086869795676</id><published>2019-10-08T13:51:00.001-07:00</published><updated>2019-10-08T13:51:26.706-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC110"/><title type='text'>Code from chapter 6 video</title><content type='html'>&lt;!-- HTML generated using hilite.me --&gt;&lt;div style=&quot;background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;&quot;&gt;&lt;pre style=&quot;margin: 0; line-height: 125%&quot;&gt;&lt;span style=&quot;color: #DD4422&quot;&gt;&amp;#39;&amp;#39;&amp;#39;&lt;/span&gt;
441. <span style="color: #DD4422">Functions divide code into blocks.</span>
442. <span style="color: #DD4422">Each function should do one thing.</span>
443. <span style="color: #DD4422">Functions make it easier to debug and manage</span>
444. <span style="color: #DD4422">program flow.</span>
445. <span style="color: #DD4422">A function can just execute its code and be done.</span>
446. <span style="color: #DD4422">A function can take in parameters to work with.</span>
447. <span style="color: #DD4422">A function can return a value.</span>
448. <span style="color: #DD4422">We are going to do a very simple program to calculate area</span>
449. <span style="color: #DD4422">this requires the following steps</span>
450. <span style="color: #DD4422">1. print out of what the program does</span>
451. <span style="color: #DD4422">2. get the length and width of the area in feet</span>
452. <span style="color: #DD4422">3. calculate the area</span>
453. <span style="color: #DD4422">4. Output the results</span>
454. <span style="color: #DD4422">Each step will be a separate function.</span>
455. <span style="color: #DD4422">'''</span>
456. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">intro</span>():
457.    <span style="color: #007020">print</span>(<span style="background-color: #fff0f0">"This program calculates area"</span>)
458.  
459. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getLength</span>():
460.    length<span style="color: #333333">=</span><span style="color: #007020">eval</span>(<span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"enter the length: "</span>))
461.    <span style="color: #008800; font-weight: bold">return</span> length
462.  
463. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getWidth</span>():
464.    width<span style="color: #333333">=</span><span style="color: #007020">eval</span>(<span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"Enter the width: "</span>))
465.    <span style="color: #008800; font-weight: bold">return</span> width
466.  
467. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">calculateArea</span>():
468.    l<span style="color: #333333">=</span>getLength()
469.    w<span style="color: #333333">=</span>getWidth()
470.    a<span style="color: #333333">=</span>l <span style="color: #333333">*</span> w
471.    outputArea(a)
472.  
473. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">outputArea</span>(area):
474.    <span style="color: #007020">print</span>(<span style="background-color: #fff0f0">"the area is"</span>, area)
475.  
476. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">main</span>():
477.    intro()
478.    calculateArea()
479.  
480. main()
481.  
482.  
483.    
484. </pre></div>
485. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/2515226086869795676/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/10/code-from-chapter-6-video.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/2515226086869795676'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/2515226086869795676'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/10/code-from-chapter-6-video.html' title='Code from chapter 6 video'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-8824853103583692640</id><published>2019-10-08T12:10:00.002-07:00</published><updated>2019-10-08T12:10:32.033-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC110"/><title type='text'>Code from chapter 5 Video</title><content type='html'>&lt;p&gt;Here is the console interactive session &lt;/p&gt;
486. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #888888">Python 3.6.0 (v3.6.0:41df79263a11, Dec 23 2016, 08:06:12) [MSC v.1900 64 bit (AMD64)] on win32</span>
487. <span style="color: #888888">Type "copyright", "credits" or "license()" for more information.</span>
488. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #888888">#Chapter 5 take IV</span>
489. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #888888">#strings</span>
490. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #888888">#lists of characters</span>
491. <span style="color: #c65d09; font-weight: bold">>>> </span>greeting<span style="color: #333333">=</span><span style="background-color: #fff0f0">"Hello"</span>
492. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #007020">type</span>(greeting)
493. <span style="color: #888888"><class 'str'></span>
494. <span style="color: #c65d09; font-weight: bold">>>> </span>number<span style="color: #333333">=</span><span style="background-color: #fff0f0">'17'</span>
495. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #007020">type</span>(number)
496. <span style="color: #888888"><class 'str'></span>
497. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>[greeting[<span style="color: #0000DD; font-weight: bold">0</span>])
498. <span style="color: #888888">SyntaxError: invalid syntax</span>
499. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(greeting[<span style="color: #0000DD; font-weight: bold">0</span>])
500. <span style="color: #888888">H</span>
501. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(greeting[<span style="color: #0000DD; font-weight: bold">4</span>])
502. <span style="color: #888888">o</span>
503. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(greeting[<span style="color: #0000DD; font-weight: bold">2</span>:<span style="color: #0000DD; font-weight: bold">3</span>])
504. <span style="color: #888888">l</span>
505. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(greeting[<span style="color: #0000DD; font-weight: bold">2</span>:<span style="color: #0000DD; font-weight: bold">4</span>})
506. <span style="color: #888888">SyntaxError: invalid syntax</span>
507. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(greeting[<span style="color: #0000DD; font-weight: bold">2</span>:<span style="color: #0000DD; font-weight: bold">4</span>])
508. <span style="color: #888888">ll</span>
509. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(greeting[:<span style="color: #0000DD; font-weight: bold">4</span>])
510. <span style="color: #888888">Hell</span>
511. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #007020">len</span>(greeting)
512. <span style="color: #888888">5</span>
513. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">for</span> ch <span style="color: #000000; font-weight: bold">in</span> greeting:
514. <span style="color: #888888"> print(ch)</span>
515.  
516. <span style="color: #888888">H</span>
517. <span style="color: #888888">e</span>
518. <span style="color: #888888">l</span>
519. <span style="color: #888888">l</span>
520. <span style="color: #888888">o</span>
521. <span style="color: #c65d09; font-weight: bold">>>> </span>
522. <span style="color: #888888">====== RESTART: C:/Users/SteveConger/Documents/PythonFiles/username.py ======</span>
523. <span style="color: #888888">This program generates user names</span>
524. <span style="color: #888888">enter your first name: Steve</span>
525. <span style="color: #888888">enter your last name: Conger</span>
526. <span style="color: #888888">Your user name is SConger</span>
527. <span style="color: #c65d09; font-weight: bold">>>> </span>
528. <span style="color: #888888">====== RESTART: C:/Users/SteveConger/Documents/PythonFiles/username.py ======</span>
529. <span style="color: #888888">This program generates user names</span>
530. <span style="color: #888888">enter your first name: Steve</span>
531. <span style="color: #888888">enter your last name: Robertson</span>
532. <span style="color: #888888">Your user name is sroberts</span>
533. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #888888">#page 148 string functons</span>
534. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #007020">ord</span>(a)
535. <span style="color: #0044DD">Traceback (most recent call last):</span>
536.  File <span style="color: #007020">"<pyshell#19>"</span>, line <span style="color: #6600EE; font-weight: bold">1</span>, in <module>
537.    <span style="color: #007020">ord</span>(a)
538. <span style="color: #FF0000">NameError</span>: name 'a' is not defined
539. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #007020">ord</span>(<span style="background-color: #fff0f0">"a"</span>)
540. <span style="color: #888888">97</span>
541. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #007020">ord</span>(<span style="background-color: #fff0f0">"A"</span>)
542. <span style="color: #888888">65</span>
543. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #007020">chr</span>(<span style="color: #0000DD; font-weight: bold">97</span>)
544. <span style="color: #888888">'a'</span>
545. <span style="color: #c65d09; font-weight: bold">>>> </span>weekdays<span style="color: #333333">=</span>[<span style="background-color: #fff0f0">"Mon"</span>, <span style="background-color: #fff0f0">"Tue"</span>, <span style="background-color: #fff0f0">"Wed"</span>, <span style="background-color: #fff0f0">"Thu"</span>, <span style="background-color: #fff0f0">"Fri"</span>, <span style="background-color: #fff0f0">"Sat"</span>, <span style="background-color: #fff0f0">"Sun"</span>]
546. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(weekdays[<span style="color: #0000DD; font-weight: bold">3</span>])
547. <span style="color: #888888">Thu</span>
548. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(weekends[<span style="color: #0000DD; font-weight: bold">3</span><span style="color: #333333">-</span><span style="color: #0000DD; font-weight: bold">1</span>])
549. <span style="color: #0044DD">Traceback (most recent call last):</span>
550.  File <span style="color: #007020">"<pyshell#25>"</span>, line <span style="color: #6600EE; font-weight: bold">1</span>, in <module>
551.    <span style="color: #008800; font-weight: bold">print</span>(weekends[<span style="color: #0000DD; font-weight: bold">3</span><span style="color: #333333">-</span><span style="color: #0000DD; font-weight: bold">1</span>])
552. <span style="color: #FF0000">NameError</span>: name 'weekends' is not defined
553. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span> (weekdays[<span style="color: #0000DD; font-weight: bold">3</span><span style="color: #333333">-</span><span style="color: #0000DD; font-weight: bold">1</span>])
554. <span style="color: #888888">Wed</span>
555. <span style="color: #c65d09; font-weight: bold">>>> </span>num<span style="color: #333333">=</span><span style="color: #6600EE; font-weight: bold">1234.33939020229202</span>
556. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(<span style="background-color: #fff0f0">"the formatted value = {0000.2f}"</span><span style="color: #333333">.</span>format(num))
557. <span style="color: #0044DD">Traceback (most recent call last):</span>
558.  File <span style="color: #007020">"<pyshell#28>"</span>, line <span style="color: #6600EE; font-weight: bold">1</span>, in <module>
559.    <span style="color: #008800; font-weight: bold">print</span>(<span style="background-color: #fff0f0">"the formatted value = {0000.2f}"</span><span style="color: #333333">.</span>format(num))
560. <span style="color: #FF0000">AttributeError</span>: 'float' object has no attribute '2f'
561. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(<span style="background-color: #fff0f0">"the formatted value={0:0.2f}"</span><span style="color: #333333">.</span>format(num))
562. <span style="color: #888888">the formatted value=1234.34</span>
563. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(<span style="background-color: #fff0f0">"The formatted value=${0.0.2f}"</span><span style="color: #333333">.</span>format(num))
564. <span style="color: #0044DD">Traceback (most recent call last):</span>
565.  File <span style="color: #007020">"<pyshell#30>"</span>, line <span style="color: #6600EE; font-weight: bold">1</span>, in <module>
566.    <span style="color: #008800; font-weight: bold">print</span>(<span style="background-color: #fff0f0">"The formatted value=${0.0.2f}"</span><span style="color: #333333">.</span>format(num))
567. <span style="color: #FF0000">AttributeError</span>: 'float' object has no attribute '0'
568. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(<span style="background-color: #fff0f0">"the formatted value=${0:0.2f}"</span>,format(num))
569. <span style="color: #888888">the formatted value=${0:0.2f} 1234.339390202292</span>
570. <span style="color: #c65d09; font-weight: bold">>>> </span><span style="color: #008800; font-weight: bold">print</span>(<span style="background-color: #fff0f0">"the formatted value=${0:0.2f}"</span><span style="color: #333333">.</span>format(num))
571. <span style="color: #888888">the formatted value=$1234.34</span>
572. <span style="color: #c65d09; font-weight: bold">>>> </span>
573. <span style="color: #888888">====== RESTART: C:/Users/SteveConger/Documents/PythonFiles/userfile.py ======</span>
574. <span style="color: #888888">this program creates a file of usernames in batch mode</span>
575. <span style="color: #888888">from a file of names</span>
576. <span style="color: #888888">Enter the file name with the names: name.txt</span>
577. <span style="color: #888888">Enter the name of the output file: unames.txt</span>
578. <span style="color: #0044DD">Traceback (most recent call last):</span>
579.  File <span style="color: #007020">"C:/Users/SteveConger/Documents/PythonFiles/userfile.py"</span>, line <span style="color: #6600EE; font-weight: bold">26</span>, in <module>
580.    main()
581.  File <span style="color: #007020">"C:/Users/SteveConger/Documents/PythonFiles/userfile.py"</span>, line <span style="color: #6600EE; font-weight: bold">12</span>, in main
582.    infile<span style="color: #333333">=</span><span style="color: #007020">open</span>(infileName, <span style="background-color: #fff0f0">"r"</span>)
583. <span style="color: #FF0000">FileNotFoundError</span>: [Errno 2] No such file or directory: 'name.txt'
584. <span style="color: #c65d09; font-weight: bold">>>> </span>
585. <span style="color: #888888">====== RESTART: C:/Users/SteveConger/Documents/PythonFiles/userfile.py ======</span>
586. <span style="color: #888888">this program creates a file of usernames in batch mode</span>
587. <span style="color: #888888">from a file of names</span>
588. <span style="color: #888888">Enter the file name with the names: names.txt</span>
589. <span style="color: #888888">Enter the name of the output file: unames.txt</span>
590. <span style="color: #0044DD">Traceback (most recent call last):</span>
591.  File <span style="color: #007020">"C:/Users/SteveConger/Documents/PythonFiles/userfile.py"</span>, line <span style="color: #6600EE; font-weight: bold">26</span>, in <module>
592.    main()
593.  File <span style="color: #007020">"C:/Users/SteveConger/Documents/PythonFiles/userfile.py"</span>, line <span style="color: #6600EE; font-weight: bold">19</span>, in main
594.    <span style="color: #008800; font-weight: bold">print</span>(username, <span style="color: #007020">file</span><span style="color: #333333">=</span>outfile)
595. <span style="color: #FF0000">NameError</span>: name 'outfile' is not defined
596. <span style="color: #c65d09; font-weight: bold">>>> </span>
597. <span style="color: #888888">====== RESTART: C:/Users/SteveConger/Documents/PythonFiles/userfile.py ======</span>
598. <span style="color: #888888">this program creates a file of usernames in batch mode</span>
599. <span style="color: #888888">from a file of names</span>
600. <span style="color: #888888">Enter the file name with the names: names.txt</span>
601. <span style="color: #888888">Enter the name of the output file: unames.txt</span>
602. <span style="color: #888888">the user names have been written to unames.txt</span>
603. <span style="color: #c65d09; font-weight: bold">>>> </span>
604. </pre></div>
605. <p>Here is the first version of the Username program</p>
606. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #888888">#username.py</span>
607. <span style="color: #888888">#Steve Conger</span>
608. <span style="color: #888888">#10/8/2019</span>
609.  
610. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">main</span>():
611.    <span style="color: #007020">print</span>(<span style="background-color: #fff0f0">"This program generates user names"</span>)
612.  
613.    <span style="color: #888888">#get user first and last names</span>
614.    first<span style="color: #333333">=</span><span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"enter your first name: "</span>)
615.    last<span style="color: #333333">=</span><span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"enter your last name: "</span>)
616.  
617.    <span style="color: #888888">#concatinate user name first letter of first name</span>
618.    <span style="color: #888888">#first 7 letters of the last name</span>
619.    username<span style="color: #333333">=</span>first[<span style="color: #0000DD; font-weight: bold">0</span>] <span style="color: #333333">+</span> last[:<span style="color: #0000DD; font-weight: bold">7</span>]
620.    <span style="color: #007020">print</span>(<span style="background-color: #fff0f0">"Your user name is"</span>,username<span style="color: #333333">.</span>lower())
621.  
622. main()
623. </pre></div>
624. <p>Here is the file version</p>
625. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #888888">#create a file of usernames</span>
626. <span style="color: #888888">#read the file</span>
627.  
628. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">main</span>():
629.    <span style="color: #007020">print</span>(<span style="background-color: #fff0f0">"this program creates a file of usernames in batch mode"</span>)
630.    <span style="color: #007020">print</span>(<span style="background-color: #fff0f0">"from a file of names"</span>)
631.  
632.    <span style="color: #888888"># get file names</span>
633.    infileName<span style="color: #333333">=</span><span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"Enter the file name with the names: "</span>)
634.    outfileName<span style="color: #333333">=</span><span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"Enter the name of the output file: "</span>)
635.  
636.    infile<span style="color: #333333">=</span><span style="color: #007020">open</span>(infileName, <span style="background-color: #fff0f0">"r"</span>)
637.    outfile<span style="color: #333333">=</span><span style="color: #007020">open</span>(outfileName, <span style="background-color: #fff0f0">"w"</span>)
638.  
639.    <span style="color: #888888"># loop through the file, process and write</span>
640.    <span style="color: #008800; font-weight: bold">for</span> line <span style="color: #000000; font-weight: bold">in</span> infile:
641.        first, last <span style="color: #333333">=</span> line<span style="color: #333333">.</span>split()
642.        username<span style="color: #333333">=</span>(first[<span style="color: #0000DD; font-weight: bold">0</span>] <span style="color: #333333">+</span> last[:<span style="color: #0000DD; font-weight: bold">7</span>])<span style="color: #333333">.</span>lower()
643.        <span style="color: #007020">print</span>(username, file<span style="color: #333333">=</span>outfile)
644.  
645.    infile<span style="color: #333333">.</span>close()
646.    outfile<span style="color: #333333">.</span>close()
647.  
648.    <span style="color: #007020">print</span> (<span style="background-color: #fff0f0">"the user names have been written to"</span>, outfileName)
649.  
650. main()
651.  
652.        
653. </pre></div>
654. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/8824853103583692640/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/10/code-from-chapter-5-video.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/8824853103583692640'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/8824853103583692640'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/10/code-from-chapter-5-video.html' title='Code from chapter 5 Video'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-794289962133737763</id><published>2019-10-07T20:15:00.001-07:00</published><updated>2019-10-07T20:15:29.697-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC220"/><title type='text'>SQL From video on Data And Entities</title><content type='html'>&lt;!-- HTML generated using hilite.me --&gt;&lt;div style=&quot;background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;&quot;&gt;&lt;pre style=&quot;margin: 0; line-height: 125%&quot;&gt;&lt;span style=&quot;color: #008800; font-weight: bold&quot;&gt;Create&lt;/span&gt; &lt;span style=&quot;color: #008800; font-weight: bold&quot;&gt;table&lt;/span&gt; topping
655. (
656. toppingID <span style="color: #007020">serial</span> <span style="color: #008800; font-weight: bold">primary</span> <span style="color: #008800; font-weight: bold">key</span>,
657.    toppingName <span style="color: #007020">text</span>,
658. toppingPrice <span style="color: #007020">decimal</span>(<span style="color: #0000DD; font-weight: bold">5</span>,<span style="color: #0000DD; font-weight: bold">2</span>)
659. );
660.  
661. <span style="color: #008800; font-weight: bold">Create</span> <span style="color: #008800; font-weight: bold">table</span> crust
662. (
663. crustID <span style="color: #007020">serial</span> <span style="color: #008800; font-weight: bold">primary</span> <span style="color: #008800; font-weight: bold">key</span>,
664. crustName <span style="color: #007020">text</span>,
665.    crustPrice <span style="color: #007020">Decimal</span>(<span style="color: #0000DD; font-weight: bold">5</span>,<span style="color: #0000DD; font-weight: bold">2</span>)
666. );
667.  
668. <span style="color: #008800; font-weight: bold">Create</span> <span style="color: #008800; font-weight: bold">table</span> pizzasize
669. (
670. sizeID <span style="color: #007020">serial</span> <span style="color: #008800; font-weight: bold">primary</span> <span style="color: #008800; font-weight: bold">key</span>,
671.    sizeName <span style="color: #007020">text</span>,
672.    sizeBasePrice <span style="color: #007020">decimal</span>(<span style="color: #0000DD; font-weight: bold">5</span>,<span style="color: #0000DD; font-weight: bold">2</span>)
673. );
674.  
675. <span style="color: #008800; font-weight: bold">Create</span> <span style="color: #008800; font-weight: bold">table</span> pizza
676. (
677. pizzaID <span style="color: #007020">serial</span> <span style="color: #008800; font-weight: bold">primary</span> <span style="color: #008800; font-weight: bold">key</span>,
678. crustID <span style="color: #007020">integer</span> <span style="color: #008800; font-weight: bold">references</span> crust(crustID),
679. sizeID <span style="color: #007020">integer</span> <span style="color: #008800; font-weight: bold">references</span> pizzasize(sizeID)
680. );
681.  
682. <span style="color: #008800; font-weight: bold">create</span> <span style="color: #008800; font-weight: bold">table</span> pizzatopping
683. (
684. pizzaID <span style="color: #007020">integer</span> <span style="color: #008800; font-weight: bold">references</span> pizza(pizzaID),
685. toppingID <span style="color: #007020">integer</span> <span style="color: #008800; font-weight: bold">references</span> topping(toppingID),
686. <span style="color: #008800; font-weight: bold">primary</span> <span style="color: #008800; font-weight: bold">key</span> (pizzaID, toppingID)
687. );
688.  
689. <span style="color: #008800; font-weight: bold">create</span> <span style="color: #008800; font-weight: bold">table</span> <span style="color: #AA6600">"order"</span>
690. (
691. orderID <span style="color: #007020">serial</span> <span style="color: #008800; font-weight: bold">primary</span> <span style="color: #008800; font-weight: bold">key</span>,
692. orderdate <span style="color: #008800; font-weight: bold">timestamp</span> <span style="color: #008800; font-weight: bold">default</span> <span style="color: #008800; font-weight: bold">current_timestamp</span>
693. );
694.  
695. <span style="color: #008800; font-weight: bold">Create</span> <span style="color: #008800; font-weight: bold">table</span> orderPizza
696. (
697.   orderID <span style="color: #007020">integer</span> <span style="color: #008800; font-weight: bold">references</span> <span style="color: #AA6600">"order"</span>(orderID),
698.   pizzaID <span style="color: #007020">integer</span> <span style="color: #008800; font-weight: bold">references</span> pizza(pizzaID),
699.   <span style="color: #008800; font-weight: bold">primary</span> <span style="color: #008800; font-weight: bold">key</span> (orderID, pizzaID)
701. );
702.  
703. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> topping(toppingname, toppingprice)
704. <span style="color: #008800; font-weight: bold">Values</span>(<span style="background-color: #fff0f0">'pepperoni'</span>, .<span style="color: #0000DD; font-weight: bold">50</span>),
705. (<span style="background-color: #fff0f0">'olives'</span>, .<span style="color: #0000DD; font-weight: bold">50</span>),
706. (<span style="background-color: #fff0f0">'pinapple'</span>, .<span style="color: #0000DD; font-weight: bold">50</span>),
707. (<span style="background-color: #fff0f0">'tomatoes'</span>, .<span style="color: #0000DD; font-weight: bold">30</span>),
708. (<span style="background-color: #fff0f0">'sausage'</span>, .<span style="color: #0000DD; font-weight: bold">50</span>);
709.  
710. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> pizzasize(sizename, sizebaseprice)
711. <span style="color: #008800; font-weight: bold">values</span>(<span style="background-color: #fff0f0">'large'</span>, <span style="color: #0000DD; font-weight: bold">15</span>.<span style="color: #0000DD; font-weight: bold">00</span>),
712. (<span style="background-color: #fff0f0">'medium'</span>, <span style="color: #0000DD; font-weight: bold">13</span>.<span style="color: #0000DD; font-weight: bold">00</span>),
713. (<span style="background-color: #fff0f0">'small'</span>, <span style="color: #0000DD; font-weight: bold">10</span>.<span style="color: #0000DD; font-weight: bold">00</span>),
714. (<span style="background-color: #fff0f0">'personal'</span>, <span style="color: #0000DD; font-weight: bold">9</span>.<span style="color: #0000DD; font-weight: bold">00</span>);
715.  
716. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> crust(crustname, crustprice)
717. <span style="color: #008800; font-weight: bold">values</span>(<span style="background-color: #fff0f0">'regular'</span>, <span style="color: #0000DD; font-weight: bold">0</span>.<span style="color: #0000DD; font-weight: bold">00</span>),
718. (<span style="background-color: #fff0f0">'deep dish'</span>, <span style="color: #0000DD; font-weight: bold">1</span>.<span style="color: #0000DD; font-weight: bold">00</span>),
719. (<span style="background-color: #fff0f0">'cheese stuffed'</span>, <span style="color: #0000DD; font-weight: bold">2</span>.<span style="color: #0000DD; font-weight: bold">00</span>);
720.  
721. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> Pizza(crustID, sizeID)
722. <span style="color: #008800; font-weight: bold">Values</span>(<span style="color: #0000DD; font-weight: bold">1</span>,<span style="color: #0000DD; font-weight: bold">2</span>),
723. (<span style="color: #0000DD; font-weight: bold">2</span>,<span style="color: #0000DD; font-weight: bold">2</span>);
724.  
725. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> pizzatopping(pizzaid, toppingid)
726. <span style="color: #008800; font-weight: bold">values</span>(<span style="color: #0000DD; font-weight: bold">1</span>, <span style="color: #0000DD; font-weight: bold">1</span>),
727. (<span style="color: #0000DD; font-weight: bold">1</span>,<span style="color: #0000DD; font-weight: bold">5</span>),
728. (<span style="color: #0000DD; font-weight: bold">2</span>, <span style="color: #0000DD; font-weight: bold">2</span>),
729. (<span style="color: #0000DD; font-weight: bold">2</span>,<span style="color: #0000DD; font-weight: bold">3</span>),
730. (<span style="color: #0000DD; font-weight: bold">2</span>,<span style="color: #0000DD; font-weight: bold">4</span>);
731.  
732. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> <span style="color: #AA6600">"order"</span>(orderdate)
733. <span style="color: #008800; font-weight: bold">values</span>(<span style="background-color: #fff0f0">'2019-10-07'</span>);
734.  
735. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> OrderPizza(orderID, PizzaID)
736. <span style="color: #008800; font-weight: bold">Values</span>(<span style="color: #0000DD; font-weight: bold">1</span>, <span style="color: #0000DD; font-weight: bold">1</span>),
737. (<span style="color: #0000DD; font-weight: bold">1</span>,<span style="color: #0000DD; font-weight: bold">2</span>);
738.  
739. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> Topping;
740. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> Crust;
741. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> PizzaSize;
742. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> Pizza;
743. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> PizzaTopping;
744. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> <span style="color: #AA6600">"order"</span>;
745. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> Orderpizza;
746. </pre></div>
747. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/794289962133737763/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/10/sql-from-video-on-data-and-entities.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/794289962133737763'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/794289962133737763'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/10/sql-from-video-on-data-and-entities.html' title='SQL From video on Data And Entities'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-6806726936326987359</id><published>2019-10-02T15:10:00.001-07:00</published><updated>2019-10-02T15:10:04.520-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC220"/><title type='text'>ERD for Car Shop Afternoon Class</title><content type='html'>&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi57CCY8LyQi4rJA51wBe4wQSzGZdGfSHFc2Zft-G0fyx-o8WQrYyaxpdcMzyZ3gqLzOUrbpkhjeD8CbxQNRptxfdPzRjU5kbqs-Bg9zKw2InotnTfrOgJBKPnRbP1_1h-SADwbSB3IGgdz/s1600/jiffy2.png&quot; imageanchor=&quot;1&quot; &gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi57CCY8LyQi4rJA51wBe4wQSzGZdGfSHFc2Zft-G0fyx-o8WQrYyaxpdcMzyZ3gqLzOUrbpkhjeD8CbxQNRptxfdPzRjU5kbqs-Bg9zKw2InotnTfrOgJBKPnRbP1_1h-SADwbSB3IGgdz/s400/jiffy2.png&quot; width=&quot;400&quot; height=&quot;240&quot; data-original-width=&quot;1264&quot; data-original-height=&quot;758&quot; /&gt;&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/6806726936326987359/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/10/erd-for-car-shop-afternoon-class.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/6806726936326987359'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/6806726936326987359'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/10/erd-for-car-shop-afternoon-class.html' title='ERD for Car Shop Afternoon Class'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi57CCY8LyQi4rJA51wBe4wQSzGZdGfSHFc2Zft-G0fyx-o8WQrYyaxpdcMzyZ3gqLzOUrbpkhjeD8CbxQNRptxfdPzRjU5kbqs-Bg9zKw2InotnTfrOgJBKPnRbP1_1h-SADwbSB3IGgdz/s72-c/jiffy2.png" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-7032088807875464157</id><published>2019-10-02T11:51:00.002-07:00</published><updated>2019-10-02T11:51:41.739-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC220"/><title type='text'>In_Class ERD for Oil Change Shop</title><content type='html'>&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_yuDBOZUm7yjScI_Buc8yX_sKQ2T9nnRJRNOq1pkZxasDjQ3R7_XNN9OIykRrz1odvQNWFkW8IJcS5pa5lGaq0bBLrQxKm81JUdPFYdt7wgihuMqTM9Q6oP9XK5zJiDqocnsIQuTaUJyw/s1600/jifflubeERD.png&quot; imageanchor=&quot;1&quot; &gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_yuDBOZUm7yjScI_Buc8yX_sKQ2T9nnRJRNOq1pkZxasDjQ3R7_XNN9OIykRrz1odvQNWFkW8IJcS5pa5lGaq0bBLrQxKm81JUdPFYdt7wgihuMqTM9Q6oP9XK5zJiDqocnsIQuTaUJyw/s400/jifflubeERD.png&quot; width=&quot;400&quot; height=&quot;307&quot; data-original-width=&quot;940&quot; data-original-height=&quot;721&quot; /&gt;&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/7032088807875464157/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/10/inclass-erd-for-oil-change-shop.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/7032088807875464157'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/7032088807875464157'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/10/inclass-erd-for-oil-change-shop.html' title='In_Class ERD for Oil Change Shop'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_yuDBOZUm7yjScI_Buc8yX_sKQ2T9nnRJRNOq1pkZxasDjQ3R7_XNN9OIykRrz1odvQNWFkW8IJcS5pa5lGaq0bBLrQxKm81JUdPFYdt7wgihuMqTM9Q6oP9XK5zJiDqocnsIQuTaUJyw/s72-c/jifflubeERD.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-3531900783145113542</id><published>2019-09-26T12:04:00.002-07:00</published><updated>2019-09-26T12:04:52.027-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC110"/><title type='text'>Python from First Class</title><content type='html'>&lt;p&gt;First Program&lt;/p&gt;
748. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #DD4422">'''</span>
749. <span style="color: #DD4422">This is a python program</span>
750. <span style="color: #DD4422">showing some basic elements</span>
751. <span style="color: #DD4422">Steve 9-26-2019</span>
752. <span style="color: #DD4422">'''</span>
753.  
754. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">main</span>():
755.    <span style="color: #888888">#variables and assignments</span>
756.    number1 <span style="color: #333333">=</span> <span style="color: #0000DD; font-weight: bold">7</span>
757.    number2 <span style="color: #333333">=</span> <span style="color: #0000DD; font-weight: bold">12</span>
758.  
759.    <span style="color: #888888">#print results</span>
760.    <span style="color: #008800; font-weight: bold">print</span>(number1<span style="color: #333333">+</span>number2)
761.  
762. main()
763.    
764. </pre></div>
765.  
766.  
767.  
768. <p>Math Operators</p>
769. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #DD4422">'''</span>
770. <span style="color: #DD4422">This program will ouput some</span>
771. <span style="color: #DD4422">math based on user inputs</span>
772. <span style="color: #DD4422">Steve Conger 9-26-2019</span>
773. <span style="color: #DD4422">'''</span>
774. <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">mathOperators</span>():
775.    <span style="color: #888888">#getting input</span>
776.    nameOfUser<span style="color: #333333">=</span><span style="color: #007020">input</span>(<span style="background-color: #fff0f0">'Enter your name: '</span>)
777.    number1, number2 <span style="color: #333333">=</span> <span style="color: #007020">eval</span>(<span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"Please enter two numbers divided with a comma: "</span>))
778.    
779.    addition <span style="color: #333333">=</span>number1 <span style="color: #333333">+</span> number2
780.    subtraction<span style="color: #333333">=</span>number1 <span style="color: #333333">-</span> number2
781.    mult <span style="color: #333333">=</span> number1 <span style="color: #333333">*</span> number2
782.    division <span style="color: #333333">=</span> number1 <span style="color: #333333">/</span> number2
783.    intdivision <span style="color: #333333">=</span> number1 <span style="color: #333333">//</span> number2
784.    remainder <span style="color: #333333">=</span> number1 <span style="color: #333333">%</span> number2 <span style="color: #888888">#modulus</span>
785.  
786.    <span style="color: #008800; font-weight: bold">print</span> (<span style="background-color: #fff0f0">"sum"</span>,addition)
787.    <span style="color: #008800; font-weight: bold">print</span> (<span style="background-color: #fff0f0">"difference"</span>,subtraction)
788.    <span style="color: #008800; font-weight: bold">print</span> (<span style="background-color: #fff0f0">"product"</span>, mult)
789.    <span style="color: #008800; font-weight: bold">print</span>(<span style="background-color: #fff0f0">"Quotient"</span>, division)
790.    <span style="color: #008800; font-weight: bold">print</span>(<span style="background-color: #fff0f0">"integer"</span>,intdivision)
791.    <span style="color: #008800; font-weight: bold">print</span>(<span style="background-color: #fff0f0">"remainder"</span>, remainder)
792.    <span style="color: #008800; font-weight: bold">print</span>(nameOfUser)
793.  
794.  
795. mathOperators()
796. </pre></div>
797.  
798. <p>Loop</p>
799. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">main</span>():
800.    word <span style="color: #333333">=</span> <span style="color: #007020">input</span>(<span style="background-color: #fff0f0">"Enter a word"</span>)
801.    <span style="color: #008800; font-weight: bold">for</span> i <span style="color: #000000; font-weight: bold">in</span> <span style="color: #007020">range</span>(<span style="color: #0000DD; font-weight: bold">10</span>):
802.        <span style="color: #008800; font-weight: bold">print</span>(i, word)
803.  
804. main()
805. </pre></div>
806.  
807. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/3531900783145113542/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/09/python-from-first-class.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/3531900783145113542'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/3531900783145113542'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/09/python-from-first-class.html' title='Python from First Class'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-1876617785046882222</id><published>2019-09-25T14:56:00.002-07:00</published><updated>2019-09-25T14:56:25.713-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC220"/><title type='text'>Brainstorming arranging Aftrernoon</title><content type='html'>&lt;pre&gt;
808. Different types pizza sizes crusts toppings sauces cheeses
809. side (bread sticks)
810. beverages
811. Desert
812. Customer address
813. price
814. supplies (ingredients) inventory boxes
815. locations
816. employees
817. rent mortgage taxes ()
818. orders refunds  Payment types
819. specials
820. Security
821. Future promotions--merchandise
822. Delivery method take out, in house, delivery
823. inventory orders
824.  
825. --organize it
826.  
827. Pizza
828. price
829. crust
830. sauce
831. toppings
832. cheese
833. ingredients?
834.  
835. Supplies supplyType Quantity priceperUnit
836. flour  flour  26lbs  1.99
837. eggs  eggs
838. cups
839. plates
840. boxes
841. spoons
842.  
843. Customer
844. name
845. address
846. usual
847. phonenumber
848. email
849. blacklist
850.  
851. Order
852. payment type
853.  
854. </pre>
855.  
856.  
857. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/1876617785046882222/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/09/brainstorming-arranging-aftrernoon.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/1876617785046882222'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/1876617785046882222'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/09/brainstorming-arranging-aftrernoon.html' title='Brainstorming arranging Aftrernoon'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-6839664396470302668</id><published>2019-09-25T12:04:00.000-07:00</published><updated>2019-09-25T12:04:14.072-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC220"/><title type='text'>Brainstorming First organization</title><content type='html'>&lt;pre&gt;
858. Customer name email address
859. ingredients
860. no food supplies
861. overhead charges, advertisements
862. employees, orders, delivery, on-line,
863. Pizzas, sides, drinks, toppings,
864. specials
865. alchohol, crusts,
866.  
867.  
868. 2nd Part organizing:
869.  
870. Pizza  Customer
871. crust  name
872. toppings email
873. price  address
874. size  phone
875.  
876. Orders
877. pizza(s)-sizes
878. toppings
879. sides
880. drinks
881. carry-out -delivery--eat in
882. customer
883. employee
884. date time
885. cooking time
886. delivery time
887.  
888. Employee
889. name
890. position
891. schedule
892.  
893. Inventory
894.  
895. </pre>
896.  
897. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/6839664396470302668/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/09/brainstorming-first-organization.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/6839664396470302668'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/6839664396470302668'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/09/brainstorming-first-organization.html' title='Brainstorming First organization'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-6494364305464703084</id><published>2019-08-04T12:02:00.000-07:00</published><updated>2019-08-04T12:02:08.103-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC255"/><title type='text'>Classes and tests Code Testing video</title><content type='html'>&lt;p&gt;lock.py&lt;/p&gt;
898. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">Lock</span>():
899.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">__init__</span>(<span style="color: #007020">self</span>, door, location,securitylevel):
900.        <span style="color: #007020">self</span><span style="color: #333333">.</span>door<span style="color: #333333">=</span>door
901.        <span style="color: #007020">self</span><span style="color: #333333">.</span>location<span style="color: #333333">=</span>location
902.        <span style="color: #007020">self</span><span style="color: #333333">.</span>securitylevel<span style="color: #333333">=</span>securitylevel
903.        <span style="color: #007020">self</span><span style="color: #333333">.</span>status<span style="color: #333333">=</span><span style="background-color: #fff0f0">'locked'</span>
904.  
905.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">setStatus</span>(<span style="color: #007020">self</span>, status):
906.        <span style="color: #007020">self</span><span style="color: #333333">.</span>status<span style="color: #333333">=</span>status
907.  
908.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getStatus</span>(<span style="color: #007020">self</span>):
909.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>status
910.  
911.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getDoor</span>(<span style="color: #007020">self</span>):
912.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>door
913.  
914.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getLoction</span>(<span style="color: #007020">self</span>):
915.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>location
916.  
917.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getSecurityLevel</span>(<span style="color: #007020">self</span>):
918.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>securitylevel
919.  
920.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">__str__</span>(<span style="color: #007020">self</span>):
921.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">str</span>(<span style="color: #007020">self</span><span style="color: #333333">.</span>door) <span style="color: #333333">+</span> <span style="background-color: #fff0f0">" "</span> <span style="color: #333333">+</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>status
922. </pre></div>
923. <p>scan.py</p>
924. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #008800; font-weight: bold">from</span> <span style="color: #0e84b5; font-weight: bold">lock</span> <span style="color: #008800; font-weight: bold">import</span> Lock
925. <span style="color: #008800; font-weight: bold">import</span> <span style="color: #0e84b5; font-weight: bold">datetime</span>
926.  
927. <span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">Scan</span>():
928.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">__init__</span>(<span style="color: #007020">self</span>, door, location, securitylevel, card):
929.        <span style="color: #007020">self</span><span style="color: #333333">.</span>lock<span style="color: #333333">=</span>Lock(door,location,securitylevel)
930.        <span style="color: #007020">self</span><span style="color: #333333">.</span>card<span style="color: #333333">=</span>card
931.        <span style="color: #007020">self</span><span style="color: #333333">.</span>scantime<span style="color: #333333">=</span>datetime<span style="color: #333333">.</span>datetime<span style="color: #333333">.</span>now()
932.    
933.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getLock</span>(<span style="color: #007020">self</span>):
934.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>lock
935.    
936.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getCard</span>(<span style="color: #007020">self</span>):
937.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>card
938.  
939.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">getScanTime</span>(<span style="color: #007020">self</span>):
940.        <span style="color: #008800; font-weight: bold">return</span> <span style="color: #007020">self</span><span style="color: #333333">.</span>scantime
941. </pre></div>
942. <p>The Tests: test.py</p>
943. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #008800; font-weight: bold">import</span> <span style="color: #0e84b5; font-weight: bold">unittest</span>
944. <span style="color: #008800; font-weight: bold">from</span> <span style="color: #0e84b5; font-weight: bold">lock</span> <span style="color: #008800; font-weight: bold">import</span> Lock
945. <span style="color: #008800; font-weight: bold">from</span> <span style="color: #0e84b5; font-weight: bold">scan</span> <span style="color: #008800; font-weight: bold">import</span> Scan
946.  
947. <span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">LockTest</span>(unittest<span style="color: #333333">.</span>TestCase):
948.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">setUp</span>(<span style="color: #007020">self</span>):
949.        <span style="color: #007020">self</span><span style="color: #333333">.</span>lock<span style="color: #333333">=</span>Lock(<span style="background-color: #fff0f0">'3176'</span>,<span style="background-color: #fff0f0">'BE'</span>, <span style="background-color: #fff0f0">'normal'</span>)
950.  
951.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_lockstring</span>(<span style="color: #007020">self</span>):
952.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">str</span>(<span style="color: #007020">self</span><span style="color: #333333">.</span>lock), <span style="background-color: #fff0f0">'3176 locked'</span>)
953.  
954.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_getStatus</span>(<span style="color: #007020">self</span>):
955.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">self</span><span style="color: #333333">.</span>lock<span style="color: #333333">.</span>getStatus(), <span style="background-color: #fff0f0">'locked'</span>)
956.  
957.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_setStatus</span>(<span style="color: #007020">self</span>):
958.        <span style="color: #007020">self</span><span style="color: #333333">.</span>lock<span style="color: #333333">.</span>setStatus(<span style="background-color: #fff0f0">'unlocked'</span>)
959.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">self</span><span style="color: #333333">.</span>lock<span style="color: #333333">.</span>getStatus(), <span style="background-color: #fff0f0">'unlocked'</span>)
960.    
961.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_GetDoor</span>(<span style="color: #007020">self</span>):
962.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">self</span><span style="color: #333333">.</span>lock<span style="color: #333333">.</span>getDoor(), <span style="background-color: #fff0f0">'3176'</span>)
963.  
964. <span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">ScanTest</span>(unittest<span style="color: #333333">.</span>TestCase):
965.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">setUp</span>(<span style="color: #007020">self</span>):
966.        <span style="color: #007020">self</span><span style="color: #333333">.</span>scan<span style="color: #333333">=</span>Scan(<span style="background-color: #fff0f0">'3176'</span>, <span style="background-color: #fff0f0">'BE'</span>, <span style="background-color: #fff0f0">'normal'</span>, <span style="color: #0000DD; font-weight: bold">315643</span>)
967.  
968.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_GetCard</span>(<span style="color: #007020">self</span>):
969.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">self</span><span style="color: #333333">.</span>scan<span style="color: #333333">.</span>getCard(), <span style="color: #0000DD; font-weight: bold">315643</span>)
970. </pre></div>
971.  
972. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/6494364305464703084/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/08/classes-and-tests-code-testing-video.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/6494364305464703084'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/6494364305464703084'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/08/classes-and-tests-code-testing-video.html' title='Classes and tests Code Testing video'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-2280120356938923287</id><published>2019-07-10T14:13:00.000-07:00</published><updated>2019-07-10T14:13:28.792-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC226"/><title type='text'>System Queries</title><content type='html'>&lt;!-- HTML generated using hilite.me --&gt;&lt;div style=&quot;background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;&quot;&gt;&lt;pre style=&quot;margin: 0; line-height: 125%&quot;&gt;&lt;span style=&quot;color: #008800; font-weight: bold&quot;&gt;Select&lt;/span&gt; &lt;span style=&quot;color: #333333&quot;&gt;*&lt;/span&gt; &lt;span style=&quot;color: #008800; font-weight: bold&quot;&gt;from&lt;/span&gt; information_schema.tables;
973. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #008800; font-weight: bold">Table_name</span> <span style="color: #008800; font-weight: bold">from</span> information_schema.tables
974. <span style="color: #008800; font-weight: bold">Where</span> table_schema<span style="color: #333333">=</span><span style="background-color: #fff0f0">'public'</span>;
975. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> information_schema.columns;
976. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #008800; font-weight: bold">column_name</span>, data_type <span style="color: #008800; font-weight: bold">from</span> information_schema.columns
977. <span style="color: #008800; font-weight: bold">where</span> <span style="color: #008800; font-weight: bold">table_name</span><span style="color: #333333">=</span><span style="background-color: #fff0f0">'grantapplication'</span>;
978. <span style="color: #008800; font-weight: bold">Select</span> sequence_name <span style="color: #008800; font-weight: bold">from</span> information_schema.sequences;
979.  
980. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #008800; font-weight: bold">column_name</span>, data_type, <span style="color: #008800; font-weight: bold">constraint_name</span>, constraint_Type
981. <span style="color: #008800; font-weight: bold">From</span> information_schema.columns
982. <span style="color: #008800; font-weight: bold">Join</span> information_schema.table_constraints
983. <span style="color: #008800; font-weight: bold">on</span> information_schema.columns.<span style="color: #008800; font-weight: bold">table_name</span><span style="color: #333333">=</span>information_schema.table_constraints.<span style="color: #008800; font-weight: bold">table_name</span>
984. <span style="color: #008800; font-weight: bold">where</span> information_schema.columns.<span style="color: #008800; font-weight: bold">table_name</span><span style="color: #333333">=</span><span style="background-color: #fff0f0">'grantapplication'</span>
985. <span style="color: #008800; font-weight: bold">Order</span> <span style="color: #008800; font-weight: bold">by</span> <span style="color: #008800; font-weight: bold">column_name</span>;
986.  
987. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> pg_catalog.pg_tablespace;
988. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> pg_catalog.pg_extension;
989. </pre></div>
990. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/2280120356938923287/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/07/system-queries.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/2280120356938923287'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/2280120356938923287'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/07/system-queries.html' title='System Queries'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-8538637876236613827</id><published>2019-07-07T11:52:00.001-07:00</published><updated>2019-07-07T11:52:51.205-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC226"/><title type='text'>Advanced Query code</title><content type='html'>&lt;!-- HTML generated using hilite.me --&gt;&lt;div style=&quot;background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;&quot;&gt;&lt;pre style=&quot;margin: 0; line-height: 125%&quot;&gt;&lt;span style=&quot;color: #888888&quot;&gt;/******************************&lt;/span&gt;
991. <span style="color: #888888">* Set Operations</span>
992. <span style="color: #888888">******************************/</span>
993. <span style="color: #008800; font-weight: bold">CREATE</span> TEMP <span style="color: #008800; font-weight: bold">TABLE</span> email
994. (firstname <span style="color: #007020">text</span>,
995. lastname <span style="color: #007020">text</span>,
996. email <span style="color: #007020">text</span>);
997.  
998. <span style="color: #008800; font-weight: bold">INSERT</span> <span style="color: #008800; font-weight: bold">INTO</span> email(firstname, lastname, email)
999. <span style="color: #008800; font-weight: bold">values</span>(<span style="background-color: #fff0f0">'Jordan'</span>, <span style="background-color: #fff0f0">'Lawrence'</span>, <span style="background-color: #fff0f0">'jordanl@gmail.com'</span>),
1000. (<span style="background-color: #fff0f0">'Tammy'</span>, <span style="background-color: #fff0f0">'Standish'</span>, <span style="background-color: #fff0f0">'tstandish@msn.com'</span>),
1001. (<span style="background-color: #fff0f0">'Lester'</span>, <span style="background-color: #fff0f0">'Roberts'</span>, <span style="background-color: #fff0f0">'lr@yahoo.com'</span>),
1002. (<span style="background-color: #fff0f0">'Lynn'</span>, <span style="background-color: #fff0f0">'Kellerman'</span>, <span style="background-color: #fff0f0">'kellerman@gmail.com'</span>);
1003.  
1004. <span style="color: #008800; font-weight: bold">SELECT</span> lastname, firstname, email, <span style="background-color: #fff0f0">'temptable'</span> <span style="color: #008800; font-weight: bold">as</span> tblSource <span style="color: #008800; font-weight: bold">from</span> email
1005. <span style="color: #008800; font-weight: bold">UNION</span>
1006. <span style="color: #008800; font-weight: bold">SELECT</span> PersonLastname, personfirstname, personemail, <span style="background-color: #fff0f0">'Persontable'</span>
1007. <span style="color: #008800; font-weight: bold">FROM</span> person
1008. <span style="color: #008800; font-weight: bold">JOIN</span> personaddress
1009. <span style="color: #008800; font-weight: bold">USING</span> (personkey)
1010. <span style="color: #008800; font-weight: bold">WHERE</span> personaddressCity<span style="color: #333333">=</span><span style="background-color: #fff0f0">'Bellevue'</span>;
1011.  
1012. <span style="color: #008800; font-weight: bold">SELECT</span> Personlastname lastname,
1013. personfirstname firstname,
1014. personemail email,
1015. <span style="background-color: #fff0f0">'donor'</span> <span style="color: #AA6600">"role"</span>
1016. <span style="color: #008800; font-weight: bold">FROM</span> person
1017. <span style="color: #008800; font-weight: bold">JOIN</span> donation <span style="color: #008800; font-weight: bold">USING</span>(personkey)
1018. <span style="color: #008800; font-weight: bold">Where</span> donationamount <span style="color: #333333">>=</span><span style="color: #0000DD; font-weight: bold">2000</span>
1019. <span style="color: #008800; font-weight: bold">UNION</span>
1020. <span style="color: #008800; font-weight: bold">SELECT</span> Personlastname lastname,
1021. personfirstname firstname,
1022. personemail email,
1023. <span style="background-color: #fff0f0">'client'</span>
1024. <span style="color: #008800; font-weight: bold">FROM</span> person
1025. <span style="color: #008800; font-weight: bold">JOIN</span> grantapplication <span style="color: #008800; font-weight: bold">USING</span>(personkey)
1026. <span style="color: #008800; font-weight: bold">WHERE</span> granttypekey<span style="color: #333333">=</span><span style="color: #0000DD; font-weight: bold">2</span>;
1027.  
1028. <span style="color: #008800; font-weight: bold">SELECT</span> personkey, personlastname, personfirstname
1029. <span style="color: #008800; font-weight: bold">FROM</span> person
1030. <span style="color: #008800; font-weight: bold">JOIN</span> donation <span style="color: #008800; font-weight: bold">USING</span>(personkey)
1031. <span style="color: #008800; font-weight: bold">INTERSECT</span>
1032. <span style="color: #008800; font-weight: bold">SELECT</span> personkey, personlastname, personfirstname
1033. <span style="color: #008800; font-weight: bold">FROM</span> person
1034. <span style="color: #008800; font-weight: bold">JOIN</span> grantapplication <span style="color: #008800; font-weight: bold">USING</span>(personkey);
1035.  
1036. <span style="color: #008800; font-weight: bold">SELECT</span> personaddresscity
1037. <span style="color: #008800; font-weight: bold">FROM</span> personaddress
1038. <span style="color: #008800; font-weight: bold">JOIN</span> person <span style="color: #008800; font-weight: bold">USING</span> (personkey)
1039. <span style="color: #008800; font-weight: bold">JOIN</span> donation <span style="color: #008800; font-weight: bold">USING</span> (personkey)
1040. <span style="color: #008800; font-weight: bold">INTERSECT</span>
1041. <span style="color: #008800; font-weight: bold">SELECT</span> personaddresscity
1042. <span style="color: #008800; font-weight: bold">FROM</span> personaddress
1043. <span style="color: #008800; font-weight: bold">JOIN</span> person <span style="color: #008800; font-weight: bold">USING</span> (personkey)
1044. <span style="color: #008800; font-weight: bold">JOIN</span> grantapplication <span style="color: #008800; font-weight: bold">USING</span> (personkey);
1045.  
1046. <span style="color: #008800; font-weight: bold">SELECT</span> personaddresscity
1047. <span style="color: #008800; font-weight: bold">FROM</span> personaddress
1048. <span style="color: #008800; font-weight: bold">JOIN</span> person <span style="color: #008800; font-weight: bold">USING</span> (personkey)
1049. <span style="color: #008800; font-weight: bold">JOIN</span> donation <span style="color: #008800; font-weight: bold">USING</span> (personkey)
1050. <span style="color: #008800; font-weight: bold">EXCEPT</span>
1051. <span style="color: #008800; font-weight: bold">SELECT</span> personaddresscity
1052. <span style="color: #008800; font-weight: bold">FROM</span> personaddress
1053. <span style="color: #008800; font-weight: bold">JOIN</span> person <span style="color: #008800; font-weight: bold">USING</span> (personkey)
1054. <span style="color: #008800; font-weight: bold">JOIN</span> grantapplication <span style="color: #008800; font-weight: bold">USING</span> (personkey);
1055.  
1056. <span style="color: #008800; font-weight: bold">SELECT</span> granttypename <span style="color: #008800; font-weight: bold">FROM</span> granttype
1057. <span style="color: #008800; font-weight: bold">EXCEPT</span>
1058. <span style="color: #008800; font-weight: bold">SELECT</span> granttypename <span style="color: #008800; font-weight: bold">FROM</span> grantapplication
1059. <span style="color: #008800; font-weight: bold">JOIN</span> granttype <span style="color: #008800; font-weight: bold">USING</span> (granttypekey);
1060. <span style="color: #888888">/*****************************</span>
1061. <span style="color: #888888">* Windows Functions</span>
1062. <span style="color: #888888">*****************************/</span>
1063.  
1064. <span style="color: #008800; font-weight: bold">SELECT</span> granttypename, grantapplicationkey, grantapplicationamount,
1065. RANK() OVER (PARTITION <span style="color: #008800; font-weight: bold">BY</span> granttypeName <span style="color: #008800; font-weight: bold">ORDER</span> <span style="color: #008800; font-weight: bold">BY</span> Grantapplicationamount <span style="color: #008800; font-weight: bold">DESC</span>)
1066. <span style="color: #008800; font-weight: bold">FROM</span> grantapplication
1067. <span style="color: #008800; font-weight: bold">JOIN</span> granttype <span style="color: #008800; font-weight: bold">ON</span> granttype.granttypekey<span style="color: #333333">=</span>grantapplication.granttypekey
1068. <span style="color: #008800; font-weight: bold">WHERE</span> granttypename<span style="color: #333333">=</span><span style="background-color: #fff0f0">'Food'</span>;
1069.  
1070. <span style="color: #008800; font-weight: bold">SELECT</span> granttypename, grantapplicationkey, grantapplicationamount,
1071. DENSE_RANK() OVER (PARTITION <span style="color: #008800; font-weight: bold">BY</span> granttypeName <span style="color: #008800; font-weight: bold">ORDER</span> <span style="color: #008800; font-weight: bold">BY</span> Grantapplicationamount
1072. <span style="color: #008800; font-weight: bold">DESC</span>)
1073. <span style="color: #008800; font-weight: bold">FROM</span> grantapplication
1074. <span style="color: #008800; font-weight: bold">JOIN</span> granttype <span style="color: #008800; font-weight: bold">ON</span> granttype.granttypekey<span style="color: #333333">=</span>grantapplication.granttypekey
1075. <span style="color: #008800; font-weight: bold">WHERE</span> granttypename<span style="color: #333333">=</span><span style="background-color: #fff0f0">'Food'</span>;
1076.  
1077. <span style="color: #008800; font-weight: bold">SELECT</span> grantapplicationkey, granttypename, grantapplicationamount,
1078. ROW_NUMBER() OVER(<span style="color: #008800; font-weight: bold">ORDER</span> <span style="color: #008800; font-weight: bold">BY</span> grantapplicationkey)
1079. <span style="color: #008800; font-weight: bold">FROM</span> grantapplication
1080. <span style="color: #008800; font-weight: bold">JOIN</span> granttype <span style="color: #008800; font-weight: bold">using</span>(granttypekey);
1081.  
1082. <span style="color: #008800; font-weight: bold">SELECT</span> grantapplicationkey, granttypename, grantapplicationamount,
1083. ROW_NUMBER() OVER(<span style="color: #008800; font-weight: bold">ORDER</span> <span style="color: #008800; font-weight: bold">BY</span> grantapplicationamount)
1084. <span style="color: #008800; font-weight: bold">FROM</span> grantapplication
1085. <span style="color: #008800; font-weight: bold">JOIN</span> granttype <span style="color: #008800; font-weight: bold">using</span>(granttypekey);
1086.  
1087. <span style="color: #008800; font-weight: bold">SELECT</span> <span style="color: #333333">*</span>
1088. <span style="color: #008800; font-weight: bold">FROM</span>
1089. (<span style="color: #008800; font-weight: bold">SELECT</span> grantapplicationkey, granttypename, grantapplicationamount,
1090. ROW_NUMBER() OVER(<span style="color: #008800; font-weight: bold">ORDER</span> <span style="color: #008800; font-weight: bold">BY</span> grantapplicationamount)
1091. <span style="color: #008800; font-weight: bold">FROM</span> grantapplication
1092. <span style="color: #008800; font-weight: bold">JOIN</span> granttype <span style="color: #008800; font-weight: bold">using</span>(granttypekey))grants
1093. <span style="color: #008800; font-weight: bold">WHERE</span> ROW_NUMBER <span style="color: #008800; font-weight: bold">BETWEEN</span> <span style="color: #0000DD; font-weight: bold">20</span> <span style="color: #008800; font-weight: bold">and</span> <span style="color: #0000DD; font-weight: bold">30</span>;
1094.  
1095. <span style="color: #008800; font-weight: bold">SELECT</span> <span style="color: #333333">*</span>
1096. <span style="color: #008800; font-weight: bold">FROM</span>
1097. (<span style="color: #008800; font-weight: bold">SELECT</span> grantapplicationkey, granttypename, grantapplicationamount,
1098. ROW_NUMBER() OVER(<span style="color: #008800; font-weight: bold">ORDER</span> <span style="color: #008800; font-weight: bold">BY</span> grantapplicationamount)
1099. <span style="color: #008800; font-weight: bold">FROM</span> grantapplication
1100. <span style="color: #008800; font-weight: bold">JOIN</span> granttype <span style="color: #008800; font-weight: bold">using</span>(granttypekey))grants
1101. <span style="color: #008800; font-weight: bold">WHERE</span> ROW_NUMBER <span style="color: #008800; font-weight: bold">BETWEEN</span> <span style="color: #0000DD; font-weight: bold">20</span> <span style="color: #008800; font-weight: bold">and</span> <span style="color: #0000DD; font-weight: bold">30</span>;
1102.  
1103. <span style="color: #008800; font-weight: bold">SELECT</span> granttypename, grantapplicationamount,
1104. LAST_VALUE(grantapplicationamount) OVER
1105. (PARTITION <span style="color: #008800; font-weight: bold">BY</span> granttypekey <span style="color: #008800; font-weight: bold">ORDER</span> <span style="color: #008800; font-weight: bold">BY</span> Grantapplicationamount
1106. RANGE <span style="color: #008800; font-weight: bold">BETWEEN</span> UNBOUNDED PRECEDING <span style="color: #008800; font-weight: bold">AND</span> UNBOUNDED FOLLOWING)
1107. <span style="color: #008800; font-weight: bold">FROM</span> grantapplication
1108. <span style="color: #008800; font-weight: bold">JOIN</span> granttype <span style="color: #008800; font-weight: bold">using</span>(granttypekey);
1109.  
1110. <span style="color: #888888">/**************************************</span>
1111. <span style="color: #888888">* Pivot table with CROSSTAB</span>
1112. <span style="color: #888888">*************************************/</span>
1113.  
1114. <span style="color: #008800; font-weight: bold">CREATE</span> TEMP <span style="color: #008800; font-weight: bold">TABLE</span> applications2018
1115. (
1116. GranttypeName <span style="color: #007020">TEXT</span>,
1117. applicationdate <span style="color: #007020">DATE</span>,
1118. applciationamount <span style="color: #007020">NUMERIC</span>
1119. );
1120.  
1121.  
1122.  
1123. <span style="color: #008800; font-weight: bold">INSERT</span> <span style="color: #008800; font-weight: bold">INTO</span> applications2018
1124. <span style="color: #008800; font-weight: bold">SELECT</span> Granttypename, grantapplicationDate, grantapplicationamount
1125. <span style="color: #008800; font-weight: bold">FROM</span> grantapplication
1126. <span style="color: #008800; font-weight: bold">JOIN</span> granttype <span style="color: #008800; font-weight: bold">ON</span> granttype.granttypekey <span style="color: #333333">=</span> grantapplication.granttypekey
1127. <span style="color: #008800; font-weight: bold">WHERE</span> <span style="color: #008800; font-weight: bold">EXTRACT</span> (<span style="color: #008800; font-weight: bold">YEAR</span> <span style="color: #008800; font-weight: bold">FROM</span> grantapplicationdate)<span style="color: #333333">=</span><span style="color: #0000DD; font-weight: bold">2018</span>;
1128.  
1129. <span style="color: #008800; font-weight: bold">SELECT</span> <span style="color: #333333">*</span>
1130. <span style="color: #008800; font-weight: bold">FROM</span> CROSSTAB(<span style="background-color: #fff0f0">'SELECT EXTRACT(MONTH FROM applicationdate)::INTEGER,</span>
1131. <span style="background-color: #fff0f0">granttypename, SUM(applciationamount)</span>
1132. <span style="background-color: #fff0f0">FROM applications2018</span>
1133. <span style="background-color: #fff0f0">GROUP BY 1,2 ORDER BY 1, 2'</span>)
1134. FINAL_RESULT(<span style="color: #008800; font-weight: bold">Month</span> <span style="color: #007020">INTEGER</span>, Food <span style="color: #007020">NUMERIC</span>, Rent <span style="color: #007020">NUMERIC</span>, School <span style="color: #007020">NUMERIC</span>,
1135. Dental <span style="color: #007020">NUMERIC</span>, Medical <span style="color: #007020">NUMERIC</span>, Childcare <span style="color: #007020">NUMERIC</span> ,Misc <span style="color: #007020">NUMERIC</span> );
1136.  
1137. <span style="color: #008800; font-weight: bold">CREATE</span> TEMP <span style="color: #008800; font-weight: bold">TABLE</span> citydonations
1138. (
1139. <span style="color: #AA6600">"Month"</span> <span style="color: #007020">Integer</span>,
1140. city <span style="color: #007020">text</span>,
1141. amount <span style="color: #007020">numeric</span>
1142. );
1143.  
1144. <span style="color: #008800; font-weight: bold">CREATE</span> TEMP <span style="color: #008800; font-weight: bold">TABLE</span> citydonations
1145. (
1146. <span style="color: #AA6600">"Month"</span> <span style="color: #007020">Integer</span>,
1147. city <span style="color: #007020">text</span>,
1148. amount <span style="color: #007020">numeric</span>
1149. );
1150.  
1151. <span style="color: #008800; font-weight: bold">INSERT</span> <span style="color: #008800; font-weight: bold">INTO</span> citydonations
1152. <span style="color: #008800; font-weight: bold">SELECT</span> <span style="color: #008800; font-weight: bold">EXTRACT</span>(<span style="color: #008800; font-weight: bold">MONTH</span> <span style="color: #008800; font-weight: bold">FROM</span> Donationdate), PersonaddressCity, donationamount
1153. <span style="color: #008800; font-weight: bold">FROM</span> (
1154. <span style="color: #008800; font-weight: bold">SELECT</span> DINSTINCT <span style="color: #008800; font-weight: bold">ON</span>(donationkey)
1155. donationkey,
1156. donationdate,
1157. personaddresscity,
1158. donationamount
1159. <span style="color: #008800; font-weight: bold">FROM</span> donation
1160. <span style="color: #008800; font-weight: bold">JOIN</span> personaddress
1161. <span style="color: #008800; font-weight: bold">USING</span> (personkey)
1162. ) donations;
1163.  
1164.  
1165. <span style="color: #008800; font-weight: bold">SELECT</span> <span style="color: #333333">*</span>
1166. <span style="color: #008800; font-weight: bold">FROM</span> CROSSTAB(<span style="background-color: #fff0f0">'SELECT "Month" :: INTEGER,</span>
1167.  
1168. <span style="background-color: #fff0f0">City, SUM(amount) FROM citydonations</span>
1169. <span style="background-color: #fff0f0">GROUP BY 1,2</span>
1170. <span style="background-color: #fff0f0">ORDER BY 1, 2'</span>)
1171. FINAL_RESULT(<span style="color: #008800; font-weight: bold">Month</span> <span style="color: #007020">INTEGER</span>,
1172. Seattle <span style="color: #007020">NUMERIC</span>,
1173. Redmond <span style="color: #007020">NUMERIC</span>,
1174. <span style="color: #AA6600">"New York"</span> <span style="color: #007020">NUMERIC</span>,
1175. Bellevue <span style="color: #007020">NUMERIC</span>,
1176. Tukwilla <span style="color: #007020">NUMERIC</span>,
1177. Kent <span style="color: #007020">NUMERIC</span>);
1178. </pre></div>
1179. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/8538637876236613827/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/07/advanced-query-code.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/8538637876236613827'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/8538637876236613827'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/07/advanced-query-code.html' title='Advanced Query code'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-2030853072899228750</id><published>2019-06-28T13:24:00.003-07:00</published><updated>2019-06-28T13:24:44.269-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC255"/><title type='text'>Diagram from the Use Case Video</title><content type='html'>&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRCjcwcWqNp6j39bb1RlYikxnBZy63LEvGm6rsMNN8sgcGFatpq7F8ocL124zKKxEUoxhDAkolJU2CMTpjUZsl18fxf9vKidvNKBf4bDMRZNeR23jHLK8k5hHS4cyDUbbDBhPxACPM4WzU/s1600/Screenshot+from+2019-06-28+13-22-06.png&quot; imageanchor=&quot;1&quot; &gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRCjcwcWqNp6j39bb1RlYikxnBZy63LEvGm6rsMNN8sgcGFatpq7F8ocL124zKKxEUoxhDAkolJU2CMTpjUZsl18fxf9vKidvNKBf4bDMRZNeR23jHLK8k5hHS4cyDUbbDBhPxACPM4WzU/s400/Screenshot+from+2019-06-28+13-22-06.png&quot; width=&quot;400&quot; height=&quot;383&quot; data-original-width=&quot;720&quot; data-original-height=&quot;689&quot; /&gt;&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/2030853072899228750/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/06/diagram-from-use-case-video.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/2030853072899228750'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/2030853072899228750'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/06/diagram-from-use-case-video.html' title='Diagram from the Use Case Video'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRCjcwcWqNp6j39bb1RlYikxnBZy63LEvGm6rsMNN8sgcGFatpq7F8ocL124zKKxEUoxhDAkolJU2CMTpjUZsl18fxf9vKidvNKBf4bDMRZNeR23jHLK8k5hHS4cyDUbbDBhPxACPM4WzU/s72-c/Screenshot+from+2019-06-28+13-22-06.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-5575890806985526277</id><published>2019-06-28T13:23:00.000-07:00</published><updated>2019-06-28T13:23:36.836-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC255"/><title type='text'>Lock ERD from Video</title><content type='html'>&lt;p&gt;Here is the screenshot for the ERD&lt;/p&gt;
1180. &lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSAp4SURvFhl45pqMJyaQD8XHZpLpb154gJ2T-AbVlCxeYpT_jbPWElLIda7_e7XNvMJKet0j8x4gixU0F-Gr2L1TAb6ntA8uSJs9m6N6MkFGYP_IxSFWswPVOkD4hn_qDpgKV92AU1_wv/s1600/Screenshot+from+2019-06-28+13-20-08.png&quot; imageanchor=&quot;1&quot; &gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSAp4SURvFhl45pqMJyaQD8XHZpLpb154gJ2T-AbVlCxeYpT_jbPWElLIda7_e7XNvMJKet0j8x4gixU0F-Gr2L1TAb6ntA8uSJs9m6N6MkFGYP_IxSFWswPVOkD4hn_qDpgKV92AU1_wv/s400/Screenshot+from+2019-06-28+13-20-08.png&quot; width=&quot;400&quot; height=&quot;250&quot; data-original-width=&quot;875&quot; data-original-height=&quot;547&quot; /&gt;&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/5575890806985526277/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/06/lock-erd-from-video.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/5575890806985526277'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/5575890806985526277'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/06/lock-erd-from-video.html' title='Lock ERD from Video'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSAp4SURvFhl45pqMJyaQD8XHZpLpb154gJ2T-AbVlCxeYpT_jbPWElLIda7_e7XNvMJKet0j8x4gixU0F-Gr2L1TAb6ntA8uSJs9m6N6MkFGYP_IxSFWswPVOkD4hn_qDpgKV92AU1_wv/s72-c/Screenshot+from+2019-06-28+13-20-08.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-5388513016821158123</id><published>2019-06-24T11:13:00.001-07:00</published><updated>2019-06-24T11:13:31.300-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC224"/><title type='text'>Basic xml queries</title><content type='html'>&lt;p&gt;here are the xml queries from the video.&lt;/p&gt;
1181. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #888888">/****************************</span>
1182. <span style="color: #888888">basic xml queries</span>
1183. <span style="color: #888888">***********************/</span>
1184.  
1185. <span style="color: #888888">--create a table with an xml data type</span>
1186. <span style="color: #008800; font-weight: bold">Create</span> <span style="color: #008800; font-weight: bold">table</span> xmlTest
1187. (
1188. xmltestId <span style="color: #007020">serial</span> <span style="color: #008800; font-weight: bold">primary</span> <span style="color: #008800; font-weight: bold">key</span>,
1189. test xml
1190. );
1191.  
1192. <span style="color: #888888">--insert some xml</span>
1193. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> xmlTest(test)
1194. <span style="color: #008800; font-weight: bold">values</span>(<span style="background-color: #fff0f0">'<person><name>Joe Smith</name><email>js@gmail.com</email><age>34</age></person>'</span>),
1195. (<span style="background-color: #fff0f0">'<person><name>Kelly Jones</name><email>kj@gmail.com</email><age>24</age></person>'</span>),
1196. (<span style="background-color: #fff0f0">'<person><name>Lila Bard</name><email>lb@gmail.com</email><age>25</age></person>'</span>);
1197.  
1198. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #333333">*</span> <span style="color: #008800; font-weight: bold">from</span> xmltest;
1199.  
1200. <span style="color: #008800; font-weight: bold">Select</span> xmlelement(name name, test) <span style="color: #008800; font-weight: bold">from</span> xmltest;
1201.  
1202. <span style="color: #888888">--return emails</span>
1203. <span style="color: #008800; font-weight: bold">Select</span> xpath(<span style="background-color: #fff0f0">'//email/text()'</span>, test) <span style="color: #008800; font-weight: bold">from</span> xmltest;
1204.  
1205. <span style="color: #888888">--return ages</span>
1206. <span style="color: #008800; font-weight: bold">Select</span> xpath(<span style="background-color: #fff0f0">'//age/text()'</span>, test)<span style="color: #008800; font-weight: bold">from</span> xmltest;
1207.  
1208. <span style="color: #888888">--put xml tags around query results</span>
1209. <span style="color: #008800; font-weight: bold">Select</span> xmlforest(personlastname, personemail)
1210. <span style="color: #008800; font-weight: bold">from</span> person;
1211.  
1212. <span style="color: #888888">--output a table as xmlf= fragment</span>
1213. <span style="color: #008800; font-weight: bold">Select</span> Table_to_xml(<span style="background-color: #fff0f0">'granttype'</span>,<span style="color: #008800; font-weight: bold">True</span>, <span style="color: #008800; font-weight: bold">True</span>, <span style="background-color: #fff0f0">''</span>);
1214.  
1215. <span style="color: #888888">--output query results as xml fragment</span>
1216. <span style="color: #008800; font-weight: bold">Select</span> query_to_xml(<span style="background-color: #fff0f0">'Select personfirstname, personlastname, positionname</span>
1217. <span style="background-color: #fff0f0">    from person</span>
1218. <span style="background-color: #fff0f0">    join employee using (personkey)</span>
1219. <span style="background-color: #fff0f0">    join employeeposition using (employeekey)</span>
1220. <span style="background-color: #fff0f0"> join jobposition using (positionkey)'</span>
1221. ,<span style="color: #008800; font-weight: bold">True</span>, <span style="color: #008800; font-weight: bold">True</span>, <span style="background-color: #fff0f0">''</span>) ;
1222.  
1223. <span style="color: #008800; font-weight: bold">Select</span> table_to_xmlschema(<span style="background-color: #fff0f0">'granttype'</span>,<span style="color: #008800; font-weight: bold">True</span>, <span style="color: #008800; font-weight: bold">True</span>, <span style="background-color: #fff0f0">''</span>);
1224. </pre></div>
1225. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/5388513016821158123/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/06/basic-xml-queries.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/5388513016821158123'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/5388513016821158123'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/06/basic-xml-queries.html' title='Basic xml queries'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-5565306101263506156</id><published>2019-06-24T10:44:00.000-07:00</published><updated>2019-06-24T10:44:36.657-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC224"/><title type='text'>Basic JSON queries</title><content type='html'>&lt;p&gt;Here is the code I used in the video on Basic JSON queries.&lt;/p&gt;
1226. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #888888">/*********************</span>
1227. <span style="color: #888888">basic JSON queries </span>
1228. <span style="color: #888888">*********************/</span>
1229.  
1230. <span style="color: #888888">--create a table with Json as a datatype</span>
1231. <span style="color: #008800; font-weight: bold">Create</span> <span style="color: #008800; font-weight: bold">table</span> JsonTest
1232. (
1233.  testID <span style="color: #007020">serial</span> <span style="color: #008800; font-weight: bold">primary</span> <span style="color: #008800; font-weight: bold">key</span>,
1234.  test Json
1235. );
1236.  
1237. <span style="color: #888888">--insert some records</span>
1238. <span style="color: #008800; font-weight: bold">Insert</span> <span style="color: #008800; font-weight: bold">into</span> JsonTest(test)
1239. <span style="color: #008800; font-weight: bold">Values</span>(<span style="background-color: #fff0f0">'{"testname" : "testOne", "testnumber" : 123, "testdate" :"2019-05-02"}'</span>),
1240. (<span style="background-color: #fff0f0">'{"testname" : "testtwo", "testnumber" : 234, "testdate" :"2019-05-08"}'</span>),
1241. (<span style="background-color: #fff0f0">'{"testname" : "testthree", "testnumber" : 345, "testdate" :"2019-05-12"}'</span>);
1242.  
1243.  
1244. <span style="color: #888888">--query the value of a field</span>
1245. <span style="color: #008800; font-weight: bold">Select</span> test <span style="color: #333333">->></span><span style="background-color: #fff0f0">'testname'</span> <span style="color: #008800; font-weight: bold">as</span> <span style="color: #AA6600">"name"</span> <span style="color: #008800; font-weight: bold">from</span> jsontest;
1246.  
1247. <span style="color: #888888">--creates an array of sorts putting each element on its own row</span>
1248. <span style="color: #008800; font-weight: bold">Select</span> Json_each(test) <span style="color: #008800; font-weight: bold">from</span> Jsontest;
1249.  
1250. <span style="color: #888888">--returns the keys in the Json record</span>
1251. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #008800; font-weight: bold">Distinct</span> Json_object_keys(test) <span style="color: #008800; font-weight: bold">from</span> jsontest;
1252.  
1253. <span style="color: #888888">--gets tne count of tests</span>
1254. <span style="color: #008800; font-weight: bold">Select</span> <span style="color: #008800; font-weight: bold">count</span>(<span style="color: #008800; font-weight: bold">cast</span> (test <span style="color: #333333">->></span> <span style="background-color: #fff0f0">'testnumber'</span> <span style="color: #008800; font-weight: bold">as</span> <span style="color: #007020">integer</span>)) <span style="color: #008800; font-weight: bold">from</span> Jsontest;
1255.  
1256. <span style="color: #888888">--returns the results of a query as Json</span>
1257. <span style="color: #888888">--double click the results to get a little dialog box</span>
1258. <span style="color: #888888">--copy and paste to a text editor to see the full results</span>
1259. <span style="color: #008800; font-weight: bold">with</span> j <span style="color: #008800; font-weight: bold">as</span>
1260. (
1261. <span style="color: #008800; font-weight: bold">Select</span> personfirstname, personlastname, positionname
1262.    <span style="color: #008800; font-weight: bold">from</span> person
1263.    <span style="color: #008800; font-weight: bold">join</span> employee <span style="color: #008800; font-weight: bold">using</span> (personkey)
1264.    <span style="color: #008800; font-weight: bold">join</span> employeeposition <span style="color: #008800; font-weight: bold">using</span> (employeekey)
1265. <span style="color: #008800; font-weight: bold">join</span> jobposition <span style="color: #008800; font-weight: bold">using</span> (positionkey)
1266. )
1267. <span style="color: #008800; font-weight: bold">Select</span> json_agg(j) <span style="color: #008800; font-weight: bold">from</span> j;
1268. </pre></div>
1269. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/5565306101263506156/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/06/basic-json-queries.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/5565306101263506156'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/5565306101263506156'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/06/basic-json-queries.html' title='Basic JSON queries'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-8059176121050971469</id><published>2019-06-04T14:04:00.000-07:00</published><updated>2019-06-04T14:05:40.561-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC255"/><title type='text'>Testing</title><content type='html'>&lt;p&gt; here is the code for the tests. the tests and the classes being tested are available on &lt;a href=&quot;https://github.com/spconger/SaleExamples/tree/master/SaleExamples&quot;&gt;github.com/spconger&lt;/a&gt;&lt;/p&gt;
1270.  
1271. <!-- HTML generated using hilite.me --><div style="background: #ffffff; overflow:auto;width:auto;border:solid gray;border-width:.1em .1em .1em .8em;padding:.2em .6em;"><pre style="margin: 0; line-height: 125%"><span style="color: #008800; font-weight: bold">import</span> <span style="color: #0e84b5; font-weight: bold">unittest</span>
1272. <span style="color: #008800; font-weight: bold">from</span> <span style="color: #0e84b5; font-weight: bold">item</span> <span style="color: #008800; font-weight: bold">import</span> Item
1273. <span style="color: #008800; font-weight: bold">from</span> <span style="color: #0e84b5; font-weight: bold">orderitem</span> <span style="color: #008800; font-weight: bold">import</span> OrderItem
1274. <span style="color: #008800; font-weight: bold">from</span> <span style="color: #0e84b5; font-weight: bold">order</span> <span style="color: #008800; font-weight: bold">import</span> Order
1275. <span style="color: #008800; font-weight: bold">from</span> <span style="color: #0e84b5; font-weight: bold">payment</span> <span style="color: #008800; font-weight: bold">import</span> Payment
1276.  
1277. <span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">ItemTest</span>(unittest<span style="color: #333333">.</span>TestCase):
1278.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">setUp</span>(<span style="color: #007020">self</span>):
1279.        <span style="color: #007020">self</span><span style="color: #333333">.</span>item<span style="color: #333333">=</span>Item(<span style="color: #0000DD; font-weight: bold">1</span>,<span style="background-color: #fff0f0">'item1'</span>, <span style="color: #6600EE; font-weight: bold">30.00</span>)
1280.    
1281.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_string</span>(<span style="color: #007020">self</span>):
1282.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">str</span>(<span style="color: #007020">self</span><span style="color: #333333">.</span>item), <span style="color: #007020">self</span><span style="color: #333333">.</span>item<span style="color: #333333">.</span>itemname)
1283.  
1284.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_GetItemNumber</span>(<span style="color: #007020">self</span>):
1285.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">self</span><span style="color: #333333">.</span>item<span style="color: #333333">.</span>getItemNumber(),<span style="color: #0000DD; font-weight: bold">1</span>)
1286.  
1287.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_GetItemPrice</span>(<span style="color: #007020">self</span>):
1288.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">self</span><span style="color: #333333">.</span>item<span style="color: #333333">.</span>getItemPrice(),<span style="color: #6600EE; font-weight: bold">30.00</span>)
1289.  
1290. <span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">OrderItemTest</span>(unittest<span style="color: #333333">.</span>TestCase):
1291.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">setUp</span>(<span style="color: #007020">self</span>):
1292.        <span style="color: #007020">self</span><span style="color: #333333">.</span>item<span style="color: #333333">=</span>Item(<span style="color: #0000DD; font-weight: bold">1</span>,<span style="background-color: #fff0f0">'item1'</span>, <span style="color: #6600EE; font-weight: bold">30.00</span>)
1293.        <span style="color: #007020">self</span><span style="color: #333333">.</span>oitem<span style="color: #333333">=</span>OrderItem(<span style="color: #007020">self</span><span style="color: #333333">.</span>item,<span style="color: #0000DD; font-weight: bold">2</span>)
1294.  
1295.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_Quantity</span>(<span style="color: #007020">self</span>):
1296.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">self</span><span style="color: #333333">.</span>oitem<span style="color: #333333">.</span>getQuantity(),<span style="color: #0000DD; font-weight: bold">2</span>)
1297.    
1298.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_item</span>(<span style="color: #007020">self</span>):
1299.        item<span style="color: #333333">=</span><span style="color: #007020">self</span><span style="color: #333333">.</span>oitem<span style="color: #333333">.</span>getItem()
1300.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">str</span>(item), <span style="background-color: #fff0f0">'item1'</span>)
1301.  
1302. <span style="color: #008800; font-weight: bold">class</span> <span style="color: #BB0066; font-weight: bold">OrderTest</span>(unittest<span style="color: #333333">.</span>TestCase):
1303.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">setUp</span>(<span style="color: #007020">self</span>):
1304.        <span style="color: #007020">self</span><span style="color: #333333">.</span>item1<span style="color: #333333">=</span>Item(<span style="color: #0000DD; font-weight: bold">1</span>,<span style="background-color: #fff0f0">'beer'</span>,<span style="color: #6600EE; font-weight: bold">6.25</span>)
1305.        <span style="color: #007020">self</span><span style="color: #333333">.</span>item2<span style="color: #333333">=</span>Item(<span style="color: #0000DD; font-weight: bold">2</span>,<span style="background-color: #fff0f0">'chips'</span>, <span style="color: #6600EE; font-weight: bold">4.50</span>)
1306.  
1307.        <span style="color: #007020">self</span><span style="color: #333333">.</span>orderitem1<span style="color: #333333">=</span>OrderItem(<span style="color: #007020">self</span><span style="color: #333333">.</span>item1,<span style="color: #0000DD; font-weight: bold">2</span>)
1308.        <span style="color: #007020">self</span><span style="color: #333333">.</span>orderitem2<span style="color: #333333">=</span>OrderItem(<span style="color: #007020">self</span><span style="color: #333333">.</span>item2,<span style="color: #0000DD; font-weight: bold">1</span>)
1309.  
1310.        <span style="color: #007020">self</span><span style="color: #333333">.</span>order<span style="color: #333333">=</span>Order()
1311.        <span style="color: #007020">self</span><span style="color: #333333">.</span>order<span style="color: #333333">.</span>addOrderItems(<span style="color: #007020">self</span><span style="color: #333333">.</span>orderitem1)
1312.        <span style="color: #007020">self</span><span style="color: #333333">.</span>order<span style="color: #333333">.</span>addOrderItems(<span style="color: #007020">self</span><span style="color: #333333">.</span>orderitem2)
1313.  
1314.    <span style="color: #008800; font-weight: bold">def</span> <span style="color: #0066BB; font-weight: bold">test_CalculateTotal</span>(<span style="color: #007020">self</span>):
1315.        payment<span style="color: #333333">=</span><span style="color: #007020">self</span><span style="color: #333333">.</span>order<span style="color: #333333">.</span>calcTotal()
1316.        <span style="color: #007020">self</span><span style="color: #333333">.</span>assertEqual(<span style="color: #007020">str</span>(payment), <span style="background-color: #fff0f0">'Your payment today will be 17.0'</span>)
1317. </pre></div>
1318.  
1319. </content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/8059176121050971469/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/06/testing.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/8059176121050971469'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/8059176121050971469'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/06/testing.html' title='Testing'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1083017836179388179.post-6651269409707029065</id><published>2019-05-28T14:34:00.002-07:00</published><updated>2019-05-28T14:34:50.128-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="ITC255"/><title type='text'>SalesExample</title><content type='html'>&lt;p&gt;Here is the class diagram for the salesExample&lt;/p&gt;
1320. <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWxk0s7OHoh8UB3Z-EbwZd_DoU0RWzgPOw-HNMeR0JjsIFTc7eroHXiyNT2y_JotTB0-b3CSgkkSPuktG7azGc60Vj8eRDrJbE24X4_HQSq61mXxopwM2E6Y7w3bbSXbZoo32HFwF7dSNs/s1600/salesClass.png" imageanchor="1" ><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWxk0s7OHoh8UB3Z-EbwZd_DoU0RWzgPOw-HNMeR0JjsIFTc7eroHXiyNT2y_JotTB0-b3CSgkkSPuktG7azGc60Vj8eRDrJbE24X4_HQSq61mXxopwM2E6Y7w3bbSXbZoo32HFwF7dSNs/s400/salesClass.png" width="400" height="262" data-original-width="913" data-original-height="599" /></a>
1321. <p>Here is the link to the diagram <a href="https://www.lucidchart.com/invitations/accept/409c3b2a-7232-4813-a321-d66c508d3392">https://www.lucidchart.com/invitations/accept/409c3b2a-7232-4813-a321-d66c508d3392</a></p>
1322. <p>Here is the github link for the <a href="https://github.com/spconger/SaleExamples">sales classes</a></p>
1323. &lt;p&gt;Here is the github link for the &lt;a href=&quot;https://github.com/spconger/LockExample&quot;&gt;lock classes&lt;/a&gt;&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://congeritc.blogspot.com/feeds/6651269409707029065/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://congeritc.blogspot.com/2019/05/salesexample.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/6651269409707029065'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1083017836179388179/posts/default/6651269409707029065'/><link rel='alternate' type='text/html' href='http://congeritc.blogspot.com/2019/05/salesexample.html' title='SalesExample'/><author><name>spconger</name><uri>http://www.blogger.com/profile/09403009178972940087</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='28' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKPNzixlD9WTayArKRCOHadMsNvZxpYb6nKKm8wHDK76mYORtdyR4axmZY7UJ1jtlyXihYJzg6vuafDKP5CNMJ4JiiKJiL54SPnSTVtsmZo9adK_ADwPjQOi8dCDy4r5g/s220/me.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWxk0s7OHoh8UB3Z-EbwZd_DoU0RWzgPOw-HNMeR0JjsIFTc7eroHXiyNT2y_JotTB0-b3CSgkkSPuktG7azGc60Vj8eRDrJbE24X4_HQSq61mXxopwM2E6Y7w3bbSXbZoo32HFwF7dSNs/s72-c/salesClass.png" height="72" width="72"/><thr:total>0</thr:total></entry></feed>

If you would like to create a banner that links to this page (i.e. this validation result), do the following:

1. Download the "valid Atom 1.0" banner.

2. Upload the image to your own server. (This step is important. Please do not link directly to the image on this server.)

3. Add this HTML to your page (change the image src attribute if necessary):

   <a href="http://www.feedvalidator.org/check.cgi?url=http%3A//congeritc.blogspot.com/feeds/posts/default"><img src="valid-atom.png" alt="[Valid Atom 1.0]" title="Validate my Atom 1.0 feed" /></a>

If you would like to create a text link instead, here is the URL you can use:

http://www.feedvalidator.org/check.cgi?url=http%3A//congeritc.blogspot.com/feeds/posts/default

Home · About · News · Docs · Terms