API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 28th, 2017
594
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.55 KB | None | 0 0
raw download clone embed print report
  1. /* Latrice Sebastian, 56993912 */
  2. /* Output */
  3. /*Q1 a*/
  4. > USE CS122A;
  5. > CALL NewChirp('realDonaldTrump', 0.0, 0.0, 1.0, 'Russia is our new best friend!');
  6. > SELECT * FROM Chirp WHERE btag LIKE 'real%'
  7.  
  8. ******************** 1. row *********************
  9. btag: realDonaldTrump
  10. cno: 0
  11. date: 2017-02-11
  12. location_latitude: -41.146717
  13. location_longitude: -82.341417
  14. parrots_btag:
  15. parrots_cno:
  16. sentiment: -0.7
  17. text: A working dinner tonight with Prime Minister Abe of Japan and his representatives at the Winter White House (Mar-a-Lago). Very good talks!
  18. time: 23:24:08
  19. ******************** 2. row *********************
  20. btag: realDonaldTrump
  21. cno: 1
  22. date: 2017-02-11
  23. location_latitude: -35.196068
  24. location_longitude: 157.215185
  25. parrots_btag:
  26. parrots_cno:
  27. sentiment: 1.0
  28. text: Played golf today with Prime Minister Abe of Japan and @TheBig_Easy Ernie Els and had a great time. Japan is very well represented!
  29. time: 23:15:34
  30. ******************** 3. row *********************
  31. btag: realDonaldTrump
  32. cno: 2
  33. date: 2017-02-11
  34. location_latitude: 88.592610
  35. location_longitude: 21.029995
  36. parrots_btag:
  37. parrots_cno:
  38. sentiment: -0.5
  39. text: I am so proud of my daughter Ivanka. To be abused and treated so badly by the media and to still hold her head so high is truly wonderful!
  40. time: 23:00:21
  41. ******************** 4. row *********************
  42. btag: realDonaldTrump
  43. cno: 3
  44. date: 2017-02-11
  45. location_latitude: -48.244000
  46. location_longitude: -176.493445
  47. parrots_btag:
  48. parrots_cno:
  49. sentiment: 0.6
  50. text: Having a great time hosting Prime Minister Shinzo Abe in the United States! https://t.co/Fvjsac89qS https://t.co/hKqbMB2aQ9
  51. time: 18:28:31
  52. ******************** 5. row *********************
  53. btag: realDonaldTrump
  54. cno: 4
  55. date: 2017-02-11
  56. location_latitude: -75.600471
  57. location_longitude: -72.727224
  58. parrots_btag:
  59. parrots_cno:
  60. sentiment: -1.0
  61. text: Melania and I are hosting Japanese Prime Minister Shinzo Abe and Mrs. Abe at Mar-a-Lago in Palm Beach Fla. They are a wonderful couple!
  62. time: 13:33:53
  63. ******************** 6. row *********************
  64. btag: realDonaldTrump
  65. cno: 5
  66. date: 2017-02-11
  67. location_latitude: 25.699397
  68. location_longitude: 45.490059
  69. parrots_btag:
  70. parrots_cno:
  71. sentiment: -1.0
  72. text: ...design or negotiations yet. When I do just like with the F-35 FighterJet or the Air Force One Program price will come WAY DOWN!
  73. time: 13:24:32
  74. ******************** 7. row *********************
  75. btag: realDonaldTrump
  76. cno: 6
  77. date: 2017-02-11
  78. location_latitude: 63.599641
  79. location_longitude: 115.578561
  80. parrots_btag:
  81. parrots_cno:
  82. sentiment: 0.0
  83. text: I am reading that the great border WALL will cost more than the government originally thought but I have not gotten involved in the.....
  84. time: 13:18:43
  85. ******************** 8. row *********************
  86. btag: realDonaldTrump
  87. cno: 7
  88. date: 2017-02-11
  89. location_latitude: -26.530101
  90. location_longitude: 62.574579
  91. parrots_btag:
  92. parrots_cno:
  93. sentiment: -0.1
  94. text: Our legal system is broken! 77% of refugees allowed into U.S. since travel reprieve hail from seven suspect countries. (WT) SO DANGEROUS!
  95. time: 12:12:51
  96. ******************** 9. row *********************
  97. btag: realDonaldTrump
  98. cno: 8
  99. date: 2017-02-10
  100. location_latitude: -10.020575
  101. location_longitude: 82.154941
  102. parrots_btag:
  103. parrots_cno:
  104. sentiment: -0.6
  105. text: Heading to Joint Base Andrews on #MarineOne with Prime Minister Shinz earlier today. https://t.co/4JFhyYdeHO
  106. time: 23:24:51
  107. ******************** 10. row *********************
  108. btag: realDonaldTrump
  109. cno: 9
  110. date: 2017-02-10
  111. location_latitude: -56.831282
  112. location_longitude: 171.545045
  113. parrots_btag:
  114. parrots_cno:
  115. sentiment: -0.3
  116. text: The failing @nytimes does major FAKE NEWS China story saying Mr.Xi has not spoken to Mr. Trump since Nov.14. We spoke at length yesterday!
  117. time: 13:35:50
  118. ******************** 11. row *********************
  119. btag: realDonaldTrump
  120. cno: 10
  121. date: 2017-02-28
  122. location_latitude: 0.000000
  123. location_longitude: 0.000000
  124. parrots_btag:
  125. parrots_cno:
  126. sentiment: 1.0
  127. text: Russia is our new best friend!
  128. time: 05:13:24
  129.  
  130. 11 rows in set
  131.  
  132.  
  133. /*Q1 b*/
  134. > CALL ParrotChirp('swolf', 0.0, 0.0, 'realDonaldTrump', 10);
  135. > SELECT * FROM Chirp WHERE btag = 'swolf'
  136.  
  137. ******************** 1. row *********************
  138. btag: swolf
  139. cno: 0
  140. date: 2017-02-13
  141. location_latitude: 61.911844
  142. location_longitude: -60.986028
  143. parrots_btag: realDonaldTrump
  144. parrots_cno: 3
  145. sentiment: -0.9
  146. text: Just got iPhone this morning. hate the screen. it is just terrible
  147. time: 13:47:06
  148. ******************** 2. row *********************
  149. btag: swolf
  150. cno: 1
  151. date: 2017-02-22
  152. location_latitude: -63.212492
  153. location_longitude: 56.190118
  154. parrots_btag: realDonaldTrump
  155. parrots_cno: 7
  156. sentiment: -0.5
  157. text: Trying to connect from New York. hate Verizon. my service is just bad
  158. time: 15:20:24
  159. ******************** 3. row *********************
  160. btag: swolf
  161. cno: 2
  162. date: 2017-02-17
  163. location_latitude: 0.899945
  164. location_longitude: 144.392572
  165. parrots_btag: realDonaldTrump
  166. parrots_cno: 0
  167. sentiment: -0.2
  168. text: Texting from San Francisco. dislike Verizon. the coverage is just awful
  169. time: 12:20:37
  170. ******************** 4. row *********************
  171. btag: swolf
  172. cno: 3
  173. date: 2017-02-20
  174. location_latitude: 13.297046
  175. location_longitude: 64.285689
  176. parrots_btag: realDonaldTrump
  177. parrots_cno: 1
  178. sentiment: 0.2
  179. text: Making call from San Francisco. love AT&T. the coverage is just amazing
  180. time: 20:24:17
  181. ******************** 5. row *********************
  182. btag: swolf
  183. cno: 4
  184. date: 2017-02-20
  185. location_latitude: 46.412349
  186. location_longitude: 176.591723
  187. parrots_btag: realDonaldTrump
  188. parrots_cno: 4
  189. sentiment: 0.3
  190. text: Using iPhone today. like the size. it is just good
  191. time: 02:33:30
  192. ******************** 6. row *********************
  193. btag: swolf
  194. cno: 5
  195. date: 2017-02-17
  196. location_latitude: 73.040531
  197. location_longitude: -105.802261
  198. parrots_btag: realDonaldTrump
  199. parrots_cno: 8
  200. sentiment: -0.7
  201. text: Just got iPhone tonight. dislike the screen. it is just awful
  202. time: 09:55:40
  203. ******************** 7. row *********************
  204. btag: swolf
  205. cno: 6
  206. date: 2017-02-28
  207. location_latitude: 0.000000
  208. location_longitude: 0.000000
  209. parrots_btag: realDonaldTrump
  210. parrots_cno: 10
  211. sentiment: 1.0
  212. text: Russia is our new best friend!
  213. time: 05:52:50
  214. ******************** 8. row *********************
  215. btag: NULL
  216. cno: NULL
  217. date: NULL
  218. location_latitude: NULL
  219. location_longitude: NULL
  220. parrots_btag: NULL
  221. parrots_cno: NULL
  222. sentiment: NULL
  223. text: NULL
  224. time: NULL
  225. 8 rows in set
  226.  
  227. /*Q2 a*/
  228. > DELETE FROM Watcher WHERE wtag = 'burtonangel';
  229. Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails (`CS122A`.`Ad`, CONSTRAINT `ad_ibfk_1` FOREIGN KEY (`wtag`) REFERENCES `Watcher` (`wtag`) ON DELETE NO ACTION)
  230.  
  231. /*Q2 b*/
  232. > SHOW CREATE TABLE Ad
  233.  
  234. ******************** 1. row *********************
  235. Table: Ad
  236. Create Table: CREATE TABLE `Ad` (
  237. `aid` int(11) NOT NULL,
  238. `caption` varchar(40) DEFAULT NULL,
  239. `picture` varchar(40) DEFAULT NULL,
  240. `wtag` varchar(30) NOT NULL,
  241. PRIMARY KEY (`aid`),
  242. KEY `wtag` (`wtag`)
  243. ) ENGINE=InnoDB DEFAULT CHARSET=latin1
  244. 1 rows in set
  245.  
  246. /*Q2 c*/
  247. >DELETE FROM Watcher WHERE wtag = 'burtonangel';
  248. >SELECT W.wtag FROM Watcher W WHERE W.wtag IN (SELECT A.wtag FROM Ad A);
  249.  
  250.  
  251.  
  252. ******************** 1. row *********************
  253. wtag: cgregory
  254. ******************** 2. row *********************
  255. wtag: gharper
  256. ******************** 3. row *********************
  257. wtag: njoyce
  258. ******************** 4. row *********************
  259. wtag: rodriguezwilliam
  260. ******************** 5. row *********************
  261. wtag: xbush
  262. ******************** 6. row *********************
  263. wtag: NULL
  264. 6 rows in set
  265.  
  266. /*Q3 b*/
  267. >DELETE FROM Bird WHERE btag = 'amandaclark';
  268. >SELECT U.tag FROM User U;
  269.  
  270. ******************** 1. row *********************
  271. tag: anthonylang
  272. ******************** 2. row *********************
  273. tag: austin73
  274. ******************** 3. row *********************
  275. tag: BarackObama
  276. ******************** 4. row *********************
  277. tag: bentonmichael
  278. ******************** 5. row *********************
  279. tag: bishopcheyenne
  280. ******************** 6. row *********************
  281. tag: bnavarro
  282. ******************** 7. row *********************
  283. tag: burtonangel
  284. ******************** 8. row *********************
  285. tag: cgregory
  286. ******************** 9. row *********************
  287. tag: colemancraig
  288. ******************** 10. row *********************
  289. tag: dfowler
  290. ******************** 11. row *********************
  291. tag: edsheeran
  292. ******************** 12. row *********************
  293. tag: fosterdeanna
  294. ******************** 13. row *********************
  295. tag: gharper
  296. ******************** 14. row *********************
  297. tag: HillaryClinton
  298. ******************** 15. row *********************
  299. tag: hjones
  300. ******************** 16. row *********************
  301. tag: jessewilson
  302. ******************** 17. row *********************
  303. tag: judy60
  304. ******************** 18. row *********************
  305. tag: kaisercurtis
  306. ******************** 19. row *********************
  307. tag: larry82
  308. ******************** 20. row *********************
  309. tag: laura43
  310. ******************** 21. row *********************
  311. tag: margaret47
  312. ******************** 22. row *********************
  313. tag: matthew99
  314. ******************** 23. row *********************
  315. tag: natalie49
  316. ******************** 24. row *********************
  317. tag: njoyce
  318. ******************** 25. row *********************
  319. tag: qsanchez
  320. ******************** 26. row *********************
  321. tag: realDonaldTrump
  322. ******************** 27. row *********************
  323. tag: rodriguezwilliam
  324. ******************** 28. row *********************
  325. tag: swansonvalerie
  326. ******************** 29. row *********************
  327. tag: swolf
  328. ******************** 30. row *********************
  329. tag: thenry
  330. ******************** 31. row *********************
  331. tag: uatkinson
  332. ******************** 32. row *********************
  333. tag: vchang
  334. ******************** 33. row *********************
  335. tag: xbush
  336. ******************** 34. row *********************
  337. tag: NULL
  338. 34 rows in set
  339.  
  340. /*Q4 a*/
  341. > SELECT * FROM ParrotStatistics
  342.  
  343. ******************** 1. row *********************
  344. btag: austin73
  345. b_email: austin73@moreno-wright.org
  346. b_age: 53
  347. num_chirps: 6
  348. min_sentiment: -1.0
  349. max_sentiment: 1.0
  350. avg_sentiment: 0.13333
  351. start_date: 2017-02-13
  352. end_date: 2017-02-22
  353. ******************** 2. row *********************
  354. btag: bentonmichael
  355. b_email: bentonmichael@howard.biz
  356. b_age: 39
  357. num_chirps: 7
  358. min_sentiment: -0.9
  359. max_sentiment: 0.5
  360. avg_sentiment: -0.30000
  361. start_date: 2007-03-21
  362. end_date: 2017-02-15
  363. ******************** 3. row *********************
  364. btag: bishopcheyenne
  365. b_email: bishopcheyenne@hunt.com
  366. b_age: 31
  367. num_chirps: 5
  368. min_sentiment: -0.7
  369. max_sentiment: 0.9
  370. avg_sentiment: 0.24000
  371. start_date: 2017-02-12
  372. end_date: 2017-02-22
  373. ******************** 4. row *********************
  374. btag: bnavarro
  375. b_email: bnavarro@parks-johnson.org
  376. b_age: 67
  377. num_chirps: 4
  378. min_sentiment: -0.7
  379. max_sentiment: 0.6
  380. avg_sentiment: 0.22500
  381. start_date: 2016-03-21
  382. end_date: 2017-02-21
  383. ******************** 5. row *********************
  384. btag: colemancraig
  385. b_email: colemancraig@walker.com
  386. b_age: 44
  387. num_chirps: 7
  388. min_sentiment: -0.9
  389. max_sentiment: 1.0
  390. avg_sentiment: 0.27143
  391. start_date: 2009-07-26
  392. end_date: 2017-02-13
  393. ******************** 6. row *********************
  394. btag: dfowler
  395. b_email: dfowler@brady.com
  396. b_age: 36
  397. num_chirps: 7
  398. min_sentiment: -0.6
  399. max_sentiment: 1.0
  400. avg_sentiment: 0.41429
  401. start_date: 2012-10-30
  402. end_date: 2017-02-21
  403. ******************** 7. row *********************
  404. btag: edsheeran
  405. b_email: edsheeran@cortez-clark.com
  406. b_age: 26
  407. num_chirps: 9
  408. min_sentiment: -1.0
  409. max_sentiment: 1.0
  410. avg_sentiment: -0.05556
  411. start_date: 2017-02-06
  412. end_date: 2017-02-11
  413. ******************** 8. row *********************
  414. btag: HillaryClinton
  415. b_email: HillaryClinton@schmitt-lynch.info
  416. b_age: 70
  417. num_chirps: 10
  418. min_sentiment: -1.0
  419. max_sentiment: 1.0
  420. avg_sentiment: -0.11000
  421. start_date: 2017-01-21
  422. end_date: 2017-02-10
  423. ******************** 9. row *********************
  424. btag: jessewilson
  425. b_email: jessewilson@garcia.com
  426. b_age: 48
  427. num_chirps: 6
  428. min_sentiment: -1.0
  429. max_sentiment: 0.2
  430. avg_sentiment: -0.41667
  431. start_date: 2017-02-11
  432. end_date: 2017-02-20
  433. ******************** 10. row *********************
  434. btag: judy60
  435. b_email: judy60@oliver.net
  436. b_age: 41
  437. num_chirps: 6
  438. min_sentiment: -0.8
  439. max_sentiment: 1.0
  440. avg_sentiment: -0.10000
  441. start_date: 2017-01-30
  442. end_date: 2017-02-16
  443. ******************** 11. row *********************
  444. btag: kaisercurtis
  445. b_email: kaisercurtis@moore-hurst.org
  446. b_age: 30
  447. num_chirps: 2
  448. min_sentiment: 0.5
  449. max_sentiment: 0.6
  450. avg_sentiment: 0.55000
  451. start_date: 2015-04-26
  452. end_date: 2017-02-22
  453. ******************** 12. row *********************
  454. btag: larry82
  455. b_email: larry82@marquez-williams.org
  456. b_age: 53
  457. num_chirps: 5
  458. min_sentiment: -0.3
  459. max_sentiment: 0.7
  460. avg_sentiment: 0.12000
  461. start_date: 2017-02-13
  462. end_date: 2017-02-17
  463. ******************** 13. row *********************
  464. btag: laura43
  465. b_email: laura43@reynolds.org
  466. b_age: 45
  467. num_chirps: 5
  468. min_sentiment: -0.6
  469. max_sentiment: 0.7
  470. avg_sentiment: 0.16000
  471. start_date: 2014-06-20
  472. end_date: 2017-02-22
  473. ******************** 14. row *********************
  474. btag: margaret47
  475. b_email: margaret47@willis-york.info
  476. b_age: 23
  477. num_chirps: 8
  478. min_sentiment: -0.7
  479. max_sentiment: 0.8
  480. avg_sentiment: 0.18750
  481. start_date: 2006-03-30
  482. end_date: 2017-02-15
  483. ******************** 15. row *********************
  484. btag: natalie49
  485. b_email: natalie49@jimenez.biz
  486. b_age: 48
  487. num_chirps: 6
  488. min_sentiment: -0.5
  489. max_sentiment: 1.0
  490. avg_sentiment: 0.18333
  491. start_date: 2007-04-22
  492. end_date: 2017-01-29
  493. ******************** 16. row *********************
  494. btag: qsanchez
  495. b_email: qsanchez@lee.org
  496. b_age: 49
  497. num_chirps: 11
  498. min_sentiment: -0.6
  499. max_sentiment: 0.9
  500. avg_sentiment: 0.31818
  501. start_date: 2006-02-27
  502. end_date: 2017-02-18
  503. ******************** 17. row *********************
  504. btag: realDonaldTrump
  505. b_email: realDonaldTrump@gibson.info
  506. b_age: 71
  507. num_chirps: 11
  508. min_sentiment: -1.0
  509. max_sentiment: 1.0
  510. avg_sentiment: -0.14545
  511. start_date: 2017-02-10
  512. end_date: 2017-02-28
  513. ******************** 18. row *********************
  514. btag: swansonvalerie
  515. b_email: swansonvalerie@gregory-stewart.com
  516. b_age: 22
  517. num_chirps: 7
  518. min_sentiment: -0.7
  519. max_sentiment: 0.8
  520. avg_sentiment: 0.00000
  521. start_date: 2008-01-31
  522. end_date: 2017-02-16
  523. ******************** 19. row *********************
  524. btag: swolf
  525. b_email: swolf@fuller-lester.com
  526. b_age: 42
  527. num_chirps: 7
  528. min_sentiment: -0.9
  529. max_sentiment: 1.0
  530. avg_sentiment: -0.11429
  531. start_date: 2017-02-13
  532. end_date: 2017-02-28
  533. ******************** 20. row *********************
  534. btag: thenry
  535. b_email: thenry@mcdonald-chen.com
  536. b_age: 56
  537. num_chirps: 5
  538. min_sentiment: -0.5
  539. max_sentiment: 0.7
  540. avg_sentiment: 0.04000
  541. start_date: 2015-12-13
  542. end_date: 2017-02-22
  543. ******************** 21. row *********************
  544. btag: uatkinson
  545. b_email: uatkinson@herring-riley.com
  546. b_age: 46
  547. num_chirps: 8
  548. min_sentiment: -0.5
  549. max_sentiment: 0.8
  550. avg_sentiment: 0.27500
  551. start_date: 2009-08-16
  552. end_date: 2017-02-16
  553. ******************** 22. row *********************
  554. btag: vchang
  555. b_email: vchang@dixon.info
  556. b_age: 48
  557. num_chirps: 12
  558. min_sentiment: -1.0
  559. max_sentiment: 0.6
  560. avg_sentiment: 0.00000
  561. start_date: 2009-06-16
  562. end_date: 2017-02-17
  563. 22 rows in set
  564.  
  565. /*Q4 b*/
  566.  
  567. ******************** 1. row *********************
  568. btag: realDonaldTrump
  569. b_email: realDonaldTrump@gibson.info
  570. b_age: 71
  571. num_chirps: 11
  572. min_sentiment: -1.0
  573. max_sentiment: 1.0
  574. avg_sentiment: -0.14545
  575. start_date: 2017-02-10
  576. end_date: 2017-02-28
  577. ******************** 2. row *********************
  578. btag: bentonmichael
  579. b_email: bentonmichael@howard.biz
  580. b_age: 39
  581. num_chirps: 7
  582. min_sentiment: -0.9
  583. max_sentiment: 0.5
  584. avg_sentiment: -0.30000
  585. start_date: 2007-03-21
  586. end_date: 2017-02-15
  587. ******************** 3. row *********************
  588. btag: jessewilson
  589. b_email: jessewilson@garcia.com
  590. b_age: 48
  591. num_chirps: 6
  592. min_sentiment: -1.0
  593. max_sentiment: 0.2
  594. avg_sentiment: -0.41667
  595. start_date: 2017-02-11
  596. end_date: 2017-02-20
  597. 3 rows in set
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!