API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 26th, 2018
234
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 7.11 KB | None | 0 0
raw download clone embed print report
  1. ## Data to be inserted into ModelNoTable
  2. c.execute("INSERT INTO ModelNoTable VALUES(null, 5, 4, 'saloon')")
  3. c.execute("INSERT INTO ModelNoTable VALUES(null, 4, 4, 'saloon')")
  4. c.execute("INSERT INTO ModelNoTable VALUES(null, 2, 2, 'saloon')")
  5. c.execute("INSERT INTO ModelNoTable VALUES(null, 5, 3, 'saloon')")
  6. c.execute("INSERT INTO ModelNoTable VALUES(null, 3, 4, 'saloon')")
  7. c.execute("INSERT INTO ModelNoTable VALUES(null, 4, 4, 'hatchback')")
  8. c.execute("INSERT INTO ModelNoTable VALUES(null, 5, 4, 'hatchback')")
  9. c.execute("INSERT INTO ModelNoTable VALUES(null, 4, 2, 'hatchback')")
  10. c.execute("INSERT INTO ModelNoTable VALUES(null, 2, 2, 'convertible')")
  11. c.execute("INSERT INTO ModelNoTable VALUES(null, 4, 4, 'convertible')")
  12. c.execute("INSERT INTO ModelNoTable VALUES(null, 5, 5, 'suv')")
  13. c.execute("INSERT INTO ModelNoTable VALUES(null, 7, 5, 'suv')")
  14. conn.commit()
  15.  
  16.  
  17. ## Data to be inserted into MechanicalDataTable
  18. c.execute("INSERT INTO MechanicalDataTable VALUES(null, 1.6, 'manual', 'right', 'diesel')")
  19. c.execute("INSERT INTO MechanicalDataTable VALUES(null, 2.0, 'automatic', 'right', 'petrol')")
  20. c.execute("INSERT INTO MechanicalDataTable VALUES(null, 2.4, 'manual', 'right', 'petrol')")
  21. c.execute("INSERT INTO MechanicalDataTable VALUES(null, 1.9, 'manual', 'right', 'diesel')")
  22. c.execute("INSERT INTO MechanicalDataTable VALUES(null, 3.0, 'automatic', 'right', 'diesel')")
  23. c.execute("INSERT INTO MechanicalDataTable VALUES(null, 2.2, 'manual', 'right', 'diesel')")
  24. c.execute("INSERT INTO MechanicalDataTable VALUES(null, 1.4, 'automatic', 'left', 'petrol')")
  25. c.execute("INSERT INTO MechanicalDataTable VALUES(null, 3.2, 'manual', 'right', 'diesel')")
  26. c.execute("INSERT INTO MechanicalDataTable VALUES(null, 3.2, 'manual', 'left', 'hybrid')")
  27. c.execute("INSERT INTO MechanicalDataTable VALUES(null, 2.0, 'manual', 'right', 'diesel')")
  28. c.execute("INSERT INTO MechanicalDataTable VALUES(null, 2.0, 'manual', 'left', 'diesel')")
  29. c.execute("INSERT INTO MechanicalDataTable VALUES(null, 2.6, 'manual', 'right', 'diesel')")
  30. conn.commit()
  31.  
  32.  
  33. ## Data to be inserted into AffordabilityTable
  34. c.execute("INSERT INTO AffordabilityTable VALUES(null, 'group 12', '74 mpg', 30)")
  35. c.execute("INSERT INTO AffordabilityTable VALUES(null, 'group 14', '44 mpg', 130)")
  36. c.execute("INSERT INTO AffordabilityTable VALUES(null, 'group 07', '52 mpg', 110)")
  37. c.execute("INSERT INTO AffordabilityTable VALUES(null, 'group 11', '72 mpg', 150)")
  38. c.execute("INSERT INTO AffordabilityTable VALUES(null, 'group 15', '32 mpg', 105)")
  39. c.execute("INSERT INTO AffordabilityTable VALUES(null, 'group 3', '80 mpg', 125)")
  40. c.execute("INSERT INTO AffordabilityTable VALUES(null, 'group 5', '52 mpg', 132)")
  41. c.execute("INSERT INTO AffordabilityTable VALUES(null, 'group 8', '50 mpg', 190)")
  42. c.execute("INSERT INTO AffordabilityTable VALUES(null, 'group 11', '64 mpg', 105)")
  43. c.execute("INSERT INTO AffordabilityTable VALUES(null, 'group 8', '46 mpg', 90)")
  44. c.execute("INSERT INTO AffordabilityTable VALUES(null, 'group 15', '74 mpg', 30)")
  45. c.execute("INSERT INTO AffordabilityTable VALUES(null, 'group 22', '28 mpg', 70)")
  46. conn.commit()
  47.  
  48.  
  49.  
  50.  
  51. ## Data to be inserted into StatisticalDataTable
  52. c.execute("INSERT INTO StatisticalDataTable VALUES(null, 10.8, '99g/km')")
  53. c.execute("INSERT INTO StatisticalDataTable VALUES(null, 9.8, '105/km')")
  54. c.execute("INSERT INTO StatisticalDataTable VALUES(null, 15.5, '102g/km')")
  55. c.execute("INSERT INTO StatisticalDataTable VALUES(null, 12.9, '120g/km')")
  56. c.execute("INSERT INTO StatisticalDataTable VALUES(null, 11.9, '85g/km')")
  57. c.execute("INSERT INTO StatisticalDataTable VALUES(null, 17.4, '79g/km')")
  58. c.execute("INSERT INTO StatisticalDataTable VALUES(null, 8.2, '104g/km')")
  59. c.execute("INSERT INTO StatisticalDataTable VALUES(null, 11.9, '122g/km')")
  60. c.execute("INSERT INTO StatisticalDataTable VALUES(null, 10.1, '89g/km')")
  61. c.execute("INSERT INTO StatisticalDataTable VALUES(null, 15.3, '85g/km')")
  62. c.execute("INSERT INTO StatisticalDataTable VALUES(null, 11.2, '90g/km')")
  63. c.execute("INSERT INTO StatisticalDataTable VALUES(null, 17.0, '99g/km')")
  64. conn.commit()
  65.  
  66.  
  67.  
  68. ## Data to be inserted into DealerTable
  69. c.execute("INSERT INTO DealerTable VALUES(null, 'marcin', 'sorokosz', 'claremont avenue', 6, 'garden city', 'ch5 4kj', 'marcin@gmail.com', 07849203399, '0')")
  70. c.execute("INSERT INTO DealerTable VALUES(null, 'tom', 'smith', 'dee road', 26, 'queensferry', 'ch5 9no', 'tom@smith.com', 012445784211, '1')")
  71. c.execute("INSERT INTO DealerTable VALUES(null, 'bradley', 'merino', 'cestrian avenue', 15, 'chester', 'k32 98kj', 'bradley@merino.com', 001478532147, '0')")
  72. c.execute("INSERT INTO DealerTable VALUES(null, 'jacob', 'barton', 'marching road', 11, 'liverpool', 'fkc 1ol', 'jacob@barton.com', 012254778451, '0')")
  73. c.execute("INSERT INTO DealerTable VALUES(null, 'david', 'edwards', 'diamond street', 9, 'wrexham', 'st4 5km', 'david@edwards.com', 078451114254, '1')")
  74. c.execute("INSERT INTO DealerTable VALUES(null, 'joseph', 'branson', 'davies court', 72, 'liverpool, 'xdl 28k', 'joseph@branson.com', 036659985214, '1')")
  75. c.execute("INSERT INTO DealerTable VALUES(null, 'christy', 'mouse', 'holly road', 138A, 'manchester', 'llo1 32d', 'christy@mouse.com', 075487114422, '0')")
  76. c.execute("INSERT INTO DealerTable VALUES(null, 'emilia', 'walker', 'uploads street', 122, 'london', 'kl4 29j', 'emilia@walker.com', 316985244124, '1')")
  77. c.execute("INSERT INTO DealerTable VALUES(null, 'richard', 'davies', 'moving avenue', 4, 'birmingham', 'ch51 9lo', 'richard@davies.com', 07347812244, '0')")
  78. c.execute("INSERT INTO DealerTable VALUES(null, 'aaron', 'cronshaw', 'princess street', 12, 'shotton', 'ch2 4aj', 'aaron@cronshaw.com', 0783214567711, '0')")
  79. conn.commit()
  80.  
  81.  
  82. ## Data to be inserted into CarTable
  83. c.execute("INSERT INTO CarTable VALUES(null,'fa11 hxz', 'volvo', 's40', 'r-design', 8500, 2010, 'silver', 1, 1, 1, 1, 1)")
  84. c.execute("INSERT INTO CarTable VALUES(null,'db12 dbo', 'bmw', '3 series', '320', 6500, 2012, 'green', 2, 2, 2, 2, 2)")
  85. c.execute("INSERT INTO CarTable VALUES(null,'op14 pas', 'audi', 'rs7', 'c5', 28200, 2014, 'black', 4, 3, 3, 3, 7)")
  86. c.execute("INSERT INTO CarTable VALUES(null,'ll05 kxz', 'chevrolet', 'cruse', 't300', 8200, 2005, 'dark blue', 2, 4, 4, 4, 3)")
  87. c.execute("INSERT INTO CarTable VALUES(null,'xd11 qaz', 'audi', 'a5', 'b7', 8500, 2011, 'dark blue', 3, 5, 5, 5, 1)")
  88. c.execute("INSERT INTO CarTable VALUES(null,'rt17 aaz', 'volvo', 's60', 'luxury', 7500, 2017, 'black', 2, 6, 6, 6, 4)")
  89. c.execute("INSERT INTO CarTable VALUES(null,'ts18 cca', 'fiat', 'punto', 'premium', 10500, 2018, 'pearl', 8, 7, 7, 7, 3)")
  90. c.execute("INSERT INTO CarTable VALUES(null,'ft05 dta', 'mercedes', 'cls', 'stand', 12340, 2005, 'white', 9, 8, 8, 8, 2)")
  91. c.execute("INSERT INTO CarTable VALUES(null,'xz02 pol', 'bmw', 'm5', 'open', 2560, 2002, 'silver', 5, 9, 9, 9, 8)")
  92. c.execute("INSERT INTO CarTable VALUES(null,'mm09 ang', 'toyota', 'yaris', 'timex', 2500, 2009, 'grey', 3, 10, 10, 1, 5)")
  93. c.execute("INSERT INTO CarTable VALUES(null,'lz08 uks', 'peugeot', '206', 'c66', 3500, 2008, 'red', 4, 11, 11, 11, 7)")
  94. c.execute("INSERT INTO CarTable VALUES(null,'po12 rss', 'seat', 'ibiza', 'l3', 5500, 2012, 'black', 10, 12, 12, 12, 8)")
  95. conn.commit()
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!