Advertisement
Guest User

Untitled

a guest
Jul 8th, 2016
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.31 KB | None | 0 0
  1. # This file should contain all the record creation needed to seed the database with its default values.
  2. # The data can then be loaded with the rake db:seed (or created alongside the db with db:setup).
  3. #
  4. # Examples:
  5. #
  6. # cities = City.create([{ name: 'Chicago' }, { name: 'Copenhagen' }])
  7. # Mayor.create(name: 'Emanuel', city: cities.first)
  8.  
  9. Apartment::Tenant.drop('weavelabs')
  10. Apartment::Tenant.create('weavelabs')
  11. Apartment::Tenant.switch!('weavelabs')
  12. user = User.create(
  13. email: "robinson@msr.com",
  14. password: "123123!@#",
  15. username: "robinsoncare", account_code: "weavelabs", auth_token: SecureRandom.hex()
  16. )
  17.  
  18. address = Address.create(address_line1: "Remedial Tower", address_line2: "Cochin", address_line3: "Ernakulam", city: "Kochi",
  19. state: "Kerala", country: "India", postal_code: "685621")
  20.  
  21. user_st1 = User.create(
  22. email: "krishnan@msr.com",
  23. password: "123123!@#",
  24. username: "krish", account_code: "weavelabs", auth_token: SecureRandom.hex()
  25. )
  26. student1 = Student.create(first_name: "Ram", last_name: "Kumar",
  27. registration_code: "STD01", contact_phone: "9568985455", contact_email: "krisnan@msr.com",
  28. user_id: user_st1.id
  29. )
  30. user_st1.save
  31. user_st1.update_attributes(owner_id: student1.id, owner_type: "Student")
  32.  
  33. user_st2 = User.create(
  34. email: "justin@msr.com",
  35. password: "123123!@#",
  36. username: "justin", account_code: "weavelabs", auth_token: SecureRandom.hex()
  37. )
  38. student2 = Student.create(first_name: "Justin", last_name: "Joseph",
  39. registration_code: "STD01", contact_phone: "9568985455", contact_email: "justin@msr.com",
  40. user_id: user_st2.id, address_id: address.id
  41. )
  42. user_st2.save
  43. user_st2.update_attributes(owner_id: student2.id, owner_type: "Student")
  44.  
  45. user_st3 = User.create(
  46. email: "sony@msr.com",
  47. password: "123123!@#",
  48. username: "sony", account_code: "weavelabs", auth_token: SecureRandom.hex()
  49. )
  50. student3 = Student.create(first_name: "Sony", last_name: "Kuriakose",
  51. registration_code: "STD01", contact_phone: "9568985455", contact_email: "sony@msr.com",
  52. user_id: user_st3.id, address_id: address.id
  53. )
  54. user_st3.save
  55. user_st3.update_attributes(owner_id: student3.id, owner_type: "Student")
  56.  
  57. user_st4 = User.create(
  58. email: "fahad@msr.com",
  59. password: "123123!@#",
  60. username: "fahu", account_code: "weavelabs", auth_token: SecureRandom.hex()
  61. )
  62. student4 = Student.create(first_name: "Fahad", last_name: "Mathew",
  63. registration_code: "STD01", contact_phone: "9568985455", contact_email: "fahad@msr.com",
  64. user_id: user_st4.id, address_id: address.id
  65. )
  66. user_st4.save
  67. user_st4.update_attributes(owner_id: student4.id, owner_type: "Student")
  68.  
  69. user_st5 = User.create(
  70. email: "prince@msr.com",
  71. password: "123123!@#",
  72. username: "iamprince", account_code: "weavelabs", auth_token: SecureRandom.hex()
  73. )
  74. student5 = Student.create(first_name: "Prince", last_name: "Mathew",
  75. registration_code: "STD01", contact_phone: "9568985455", contact_email: "prince@msr.com",
  76. user_id: user_st5.id, address_id: address.id
  77. )
  78. user_st5.save
  79. user_st5.update_attributes(owner_id: student5.id, owner_type: "Student")
  80.  
  81. user_st6 = User.create(
  82. email: "eldhose@msr.com",
  83. password: "123123!@#",
  84. username: "eldhose23", account_code: "weavelabs", auth_token: SecureRandom.hex()
  85. )
  86. student6 = Student.create(first_name: "Eldhose", last_name: "Jacob",
  87. registration_code: "STD01", contact_phone: "9568985455", contact_email: "eldhose@msr.com",
  88. user_id: user_st6.id, address_id: address.id
  89. )
  90. user_st6.save
  91. user_st6.update_attributes(owner_id: student6.id, owner_type: "Student")
  92.  
  93.  
  94. user_st7 = User.create(
  95. email: "chins@msr.com",
  96. password: "123123!@#",
  97. username: "chins", account_code: "weavelabs", auth_token: SecureRandom.hex()
  98. )
  99. student7 = Student.create(first_name: "Chins", last_name: "Skariah",
  100. registration_code: "STD01", contact_phone: "9568985455", contact_email: "chins@msr.com",
  101. user_id: user_st7.id, address_id: address.id
  102. )
  103. user_st7.save
  104. user_st7.update_attributes(owner_id: student7.id, owner_type: "Student")
  105.  
  106.  
  107. staff = Staff.create(
  108. first_name: "Robinson", last_name: "Frederic", contact_phone: "9562141240", contact_email: "robinson@msr.com",
  109. user_id: user.id
  110. )
  111. user.save
  112. user.update_attributes(owner_id: staff.id, owner_type: "Staff")
  113. course1 = Course.create(code: "CH701", name: "Chemistry", description: "Coaching classes for chemistry students"
  114. )
  115. course2 = Course.create(code: "PY702", name: "Physics", description: "Coaching classes for physics students"
  116. )
  117. program = Program.create(
  118. name: "JEE-2016 Coaching",
  119. starts_on: Date.today - 3.months,
  120. ends_on: Date.today + 3.months,
  121. description: "JEE coaching for 2016 batch. 6 months program."
  122. )
  123.  
  124. program.courses << course1
  125. program.courses << course2
  126.  
  127. batch1 = Batch.create(
  128. name: "Evening Batch",
  129. program_id: program.id
  130. )
  131. batch2 = Batch.create(
  132. name: "morning Batch",
  133. program_id: program.id
  134. )
  135.  
  136. batch1.students << student1
  137. batch1.students << student2
  138. batch1.students << student3
  139. batch1.students << student4
  140. batch1.students << student5
  141. batch1.students << student6
  142. batch1.students << student7
  143.  
  144. batch2.students << student1
  145. batch2.students << student2
  146. batch2.students << student3
  147. batch2.students << student4
  148. batch2.students << student5
  149. batch2.students << student6
  150. batch2.students << student7
  151.  
  152.  
  153. #sessions_today
  154.  
  155. study_session1 = StudySession.create(
  156. session_date: Date.today,
  157. start_time: Time.now,
  158. end_time: Time.now + 1.hours,
  159. course_id: course1.id,
  160. batch_id: batch1.id
  161. )
  162. study_session2 = StudySession.create(
  163. session_date: Date.today,
  164. start_time: Time.now,
  165. end_time: Time.now + 1.hours,
  166. course_id: course2.id,
  167. batch_id: batch2.id
  168. )
  169.  
  170. #yesterday_sessions for_staff
  171.  
  172. study_session3 = StudySession.create(
  173. session_date: Date.today - 1.days,
  174. start_time: Time.now - 1.days,
  175. end_time: Time.now - 1.days + 1.hours,
  176. course_id: course1.id,
  177. batch_id: batch1.id
  178. )
  179. study_session4 = StudySession.create(
  180. session_date: Date.today - 1.days,
  181. start_time: Time.now - 1.days,
  182. end_time: Time.now - 1.days + 1.hours,
  183. course_id: course2.id,
  184. batch_id: batch2.id
  185. )
  186.  
  187. #adding_more_study sessions_for_attendances_previous week with same course id
  188. study_session5 = StudySession.create(
  189. session_date: Date.today - 2.days,
  190. start_time: Time.now - 2.days,
  191. end_time: Time.now - 2.days + 1.hours,
  192. course_id: course1.id,
  193. batch_id: batch1.id
  194. )
  195. study_session6 = StudySession.create(
  196. session_date: Date.today - 3.days,
  197. start_time: Time.now - 3.days,
  198. end_time: Time.now - 3.days + 1.hours,
  199. course_id: course1.id,
  200. batch_id: batch1.id
  201. )
  202. study_session7 = StudySession.create(
  203. session_date: Date.today - 4.days,
  204. start_time: Time.now - 4.days,
  205. end_time: Time.now - 4.days + 1.hours,
  206. course_id: course1.id,
  207. batch_id: batch1.id
  208. )
  209. study_session8 = StudySession.create(
  210. session_date: Date.today - 5.days,
  211. start_time: Time.now - 5.days,
  212. end_time: Time.now - 5.days + 1.hours,
  213. course_id: course1.id,
  214. batch_id: batch1.id
  215. )
  216. study_session9 = StudySession.create(
  217. session_date: Date.today - 6.days,
  218. start_time: Time.now - 6.days,
  219. end_time: Time.now - 6.days + 1.hours,
  220. course_id: course1.id,
  221. batch_id: batch1.id
  222. )
  223. study_session10 = StudySession.create(
  224. session_date: Date.today - 7.days,
  225. start_time: Time.now - 7.days,
  226. end_time: Time.now - 7.days + 1.hours,
  227. course_id: course1.id,
  228. batch_id: batch1.id
  229. )
  230.  
  231. #creatng attendance for last week for each students in each sessions
  232. #study_session1
  233. Attendance.create(
  234. student_id: student1.id, study_session_id: study_session1.id, in_time: study_session1.start_time,
  235. out_time: study_session1.end_time, session_date: study_session1.session_date, course_id: study_session1.course_id
  236. )
  237. Attendance.create(
  238. student_id: student2.id, study_session_id: study_session1.id, in_time: study_session1.start_time,
  239. out_time: study_session1.end_time, session_date: study_session1.session_date, course_id: study_session1.course_id
  240. )
  241. Attendance.create(
  242. student_id: student3.id, study_session_id: study_session1.id, in_time: study_session1.start_time,
  243. out_time: study_session1.end_time, session_date: study_session1.session_date, course_id: study_session1.course_id
  244. )
  245. Attendance.create(
  246. student_id: student4.id, study_session_id: study_session1.id, absent: true, session_date: study_session1.session_date, course_id: study_session1.course_id
  247. )
  248. Attendance.create(
  249. student_id: student5.id, study_session_id: study_session1.id, in_time: study_session1.start_time,
  250. out_time: study_session1.end_time, session_date: study_session1.session_date, course_id: study_session1.course_id
  251. )
  252. Attendance.create(
  253. student_id: student6.id, study_session_id: study_session1.id,absent: true, session_date: study_session1.session_date, course_id: study_session1.course_id
  254. )
  255. Attendance.create(
  256. student_id: student7.id, study_session_id: study_session1.id, in_time: study_session1.start_time,
  257. out_time: study_session1.end_time, session_date: study_session1.session_date, course_id: study_session1.course_id
  258. )
  259.  
  260. #study_session3
  261. Attendance.create(
  262. student_id: student1.id, study_session_id: study_session3.id, in_time: study_session3.start_time,
  263. out_time: study_session3.end_time, session_date: study_session3.session_date, course_id: study_session3.course_id
  264. )
  265. Attendance.create(
  266. student_id: student2.id, study_session_id: study_session3.id, in_time: study_session3.start_time,
  267. out_time: study_session3.end_time, session_date: study_session3.session_date, course_id: study_session3.course_id
  268. )
  269. Attendance.create(
  270. student_id: student3.id, study_session_id: study_session3.id, in_time: study_session3.start_time,
  271. out_time: study_session3.end_time, session_date: study_session3.session_date, course_id: study_session3.course_id
  272. )
  273. Attendance.create(
  274. student_id: student4.id, study_session_id: study_session3.id, in_time: study_session3.start_time,
  275. out_time: study_session3.end_time, session_date: study_session3.session_date, course_id: study_session3.course_id
  276. )
  277. Attendance.create(
  278. student_id: student5.id, study_session_id: study_session3.id, in_time: study_session3.start_time,
  279. out_time: study_session3.end_time, session_date: study_session3.session_date, course_id: study_session3.course_id
  280. )
  281. Attendance.create(
  282. student_id: student6.id, study_session_id: study_session3.id, in_time: study_session3.start_time,
  283. out_time: study_session3.end_time, session_date: study_session3.session_date, course_id: study_session3.course_id
  284. )
  285. Attendance.create(
  286. student_id: student7.id, study_session_id: study_session3.id, in_time: study_session3.start_time,
  287. out_time: study_session3.end_time, session_date: study_session3.session_date, course_id: study_session3.course_id
  288. )
  289.  
  290. #study_session_5
  291. Attendance.create(
  292. student_id: student1.id, study_session_id: study_session5.id, in_time: study_session5.start_time,
  293. out_time: study_session5.end_time, session_date: study_session5.session_date, course_id: study_session5.course_id
  294. )
  295. Attendance.create(
  296. student_id: student2.id, study_session_id: study_session5.id, in_time: study_session5.start_time,
  297. out_time: study_session5.end_time, session_date: study_session5.session_date, course_id: study_session5.course_id
  298. )
  299. Attendance.create(
  300. student_id: student3.id, study_session_id: study_session5.id, in_time: study_session5.start_time,
  301. out_time: study_session5.end_time, session_date: study_session5.session_date, course_id: study_session5.course_id
  302. )
  303. Attendance.create(
  304. student_id: student4.id, study_session_id: study_session5.id, in_time: study_session5.start_time,
  305. out_time: study_session5.end_time, session_date: study_session5.session_date, course_id: study_session5.course_id
  306. )
  307. Attendance.create(
  308. student_id: student5.id, study_session_id: study_session5.id, in_time: study_session5.start_time,
  309. out_time: study_session5.end_time, session_date: study_session5.session_date, course_id: study_session5.course_id
  310. )
  311. Attendance.create(
  312. student_id: student6.id, study_session_id: study_session5.id, in_time: study_session5.start_time,
  313. out_time: study_session5.end_time, session_date: study_session5.session_date, course_id: study_session5.course_id
  314. )
  315. Attendance.create(
  316. student_id: student7.id, study_session_id: study_session5.id, in_time: study_session5.start_time,
  317. out_time: study_session5.end_time, session_date: study_session5.session_date, course_id: study_session5.course_id
  318. )
  319.  
  320. #study_session6
  321. Attendance.create(
  322. student_id: student1.id, study_session_id: study_session6.id, in_time: study_session6.start_time,
  323. out_time: study_session6.end_time, session_date: study_session6.session_date, course_id: study_session6.course_id
  324. )
  325. Attendance.create(
  326. student_id: student2.id, study_session_id: study_session6.id, in_time: study_session6.start_time,
  327. out_time: study_session6.end_time, session_date: study_session6.session_date, course_id: study_session6.course_id
  328. )
  329. Attendance.create(
  330. student_id: student3.id, study_session_id: study_session6.id, in_time: study_session6.start_time,
  331. out_time: study_session6.end_time, session_date: study_session6.session_date, course_id: study_session6.course_id
  332. )
  333. Attendance.create(
  334. student_id: student4.id, study_session_id: study_session6.id, in_time: study_session6.start_time,
  335. out_time: study_session6.end_time, session_date: study_session6.session_date, course_id: study_session6.course_id
  336. )
  337. Attendance.create(
  338. student_id: student5.id, study_session_id: study_session6.id, in_time: study_session6.start_time,
  339. out_time: study_session6.end_time, session_date: study_session6.session_date, course_id: study_session6.course_id
  340. )
  341. Attendance.create(
  342. student_id: student6.id, study_session_id: study_session6.id, in_time: study_session6.start_time,
  343. out_time: study_session6.end_time, session_date: study_session6.session_date, course_id: study_session6.course_id
  344. )
  345. Attendance.create(
  346. student_id: student7.id, study_session_id: study_session6.id, in_time: study_session6.start_time,
  347. out_time: study_session6.end_time, session_date: study_session6.session_date, course_id: study_session6.course_id
  348. )
  349.  
  350. #study_session7
  351. Attendance.create(
  352. student_id: student1.id, study_session_id: study_session7.id, in_time: study_session7.start_time,
  353. out_time: study_session7.end_time, session_date: study_session7.session_date, course_id: study_session7.course_id
  354. )
  355. Attendance.create(
  356. student_id: student2.id, study_session_id: study_session7.id, in_time: study_session7.start_time,
  357. out_time: study_session7.end_time, session_date: study_session7.session_date, course_id: study_session7.course_id
  358. )
  359. Attendance.create(
  360. student_id: student3.id, study_session_id: study_session7.id, in_time: study_session7.start_time,
  361. out_time: study_session7.end_time, session_date: study_session7.session_date, course_id: study_session7.course_id
  362. )
  363. Attendance.create(
  364. student_id: student4.id, study_session_id: study_session7.id, in_time: study_session7.start_time,
  365. out_time: study_session7.end_time, session_date: study_session7.session_date, course_id: study_session7.course_id
  366. )
  367. Attendance.create(
  368. student_id: student5.id, study_session_id: study_session7.id, in_time: study_session7.start_time,
  369. out_time: study_session7.end_time, session_date: study_session7.session_date, course_id: study_session7.course_id
  370. )
  371. Attendance.create(
  372. student_id: student6.id, study_session_id: study_session7.id, in_time: study_session7.start_time,
  373. out_time: study_session7.end_time, session_date: study_session7.session_date, course_id: study_session7.course_id
  374. )
  375. Attendance.create(
  376. student_id: student7.id, study_session_id: study_session7.id, in_time: study_session7.start_time,
  377. out_time: study_session7.end_time, session_date: study_session7.session_date, course_id: study_session7.course_id
  378. )
  379.  
  380. #study_session8
  381. Attendance.create(
  382. student_id: student1.id, study_session_id: study_session8.id, in_time: study_session8.start_time,
  383. out_time: study_session8.end_time, session_date: study_session8.session_date, course_id: study_session8.course_id
  384. )
  385. Attendance.create(
  386. student_id: student2.id, study_session_id: study_session8.id, in_time: study_session8.start_time,
  387. out_time: study_session8.end_time, session_date: study_session8.session_date, course_id: study_session8.course_id
  388. )
  389. Attendance.create(
  390. student_id: student3.id, study_session_id: study_session8.id, in_time: study_session8.start_time,
  391. out_time: study_session8.end_time, session_date: study_session8.session_date, course_id: study_session8.course_id
  392. )
  393. Attendance.create(
  394. student_id: student4.id, study_session_id: study_session8.id, in_time: study_session8.start_time,
  395. out_time: study_session8.end_time, session_date: study_session8.session_date, course_id: study_session8.course_id
  396. )
  397. Attendance.create(
  398. student_id: student6.id, study_session_id: study_session8.id, in_time: study_session8.start_time,
  399. out_time: study_session8.end_time, session_date: study_session8.session_date, course_id: study_session8.course_id
  400. )
  401. Attendance.create(
  402. student_id: student5.id, study_session_id: study_session8.id, in_time: study_session8.start_time,
  403. out_time: study_session8.end_time, session_date: study_session8.session_date, course_id: study_session8.course_id
  404. )
  405. Attendance.create(
  406. student_id: student7.id, study_session_id: study_session8.id, in_time: study_session8.start_time,
  407. out_time: study_session8.end_time, session_date: study_session8.session_date, course_id: study_session8.course_id
  408. )
  409.  
  410. #study_session9
  411.  
  412. Attendance.create(
  413. student_id: student1.id, study_session_id: study_session9.id, in_time: study_session9.start_time,
  414. out_time: study_session9.end_time, session_date: study_session9.session_date, course_id: study_session9.course_id
  415. )
  416. Attendance.create(
  417. student_id: student2.id, study_session_id: study_session9.id, in_time: study_session9.start_time,
  418. out_time: study_session9.end_time, session_date: study_session9.session_date, course_id: study_session9.course_id
  419. )
  420. Attendance.create(
  421. student_id: student3.id, study_session_id: study_session9.id, in_time: study_session9.start_time,
  422. out_time: study_session9.end_time, session_date: study_session9.session_date, course_id: study_session9.course_id
  423. )
  424. Attendance.create(
  425. student_id: student4.id, study_session_id: study_session9.id, in_time: study_session9.start_time,
  426. out_time: study_session9.end_time, session_date: study_session9.session_date, course_id: study_session9.course_id
  427. )
  428. Attendance.create(
  429. student_id: student5.id, study_session_id: study_session9.id, in_time: study_session9.start_time,
  430. out_time: study_session9.end_time, session_date: study_session9.session_date, course_id: study_session9.course_id
  431. )
  432. Attendance.create(
  433. student_id: student6.id, study_session_id: study_session9.id, in_time: study_session9.start_time,
  434. out_time: study_session9.end_time, session_date: study_session9.session_date, course_id: study_session9.course_id
  435. )
  436. Attendance.create(
  437. student_id: student7.id, study_session_id: study_session9.id, in_time: study_session9.start_time,
  438. out_time: study_session9.end_time, session_date: study_session9.session_date, course_id: study_session9.course_id
  439. )
  440.  
  441. #study_session10
  442.  
  443. Attendance.create(
  444. student_id: student1.id, study_session_id: study_session10.id, in_time: study_session10.start_time,
  445. out_time: study_session10.end_time, session_date: study_session10.session_date, course_id: study_session10.course_id
  446. )
  447. Attendance.create(
  448. student_id: student2.id, study_session_id: study_session10.id, in_time: study_session10.start_time,
  449. out_time: study_session10.end_time, session_date: study_session10.session_date, course_id: study_session10.course_id
  450. )
  451. Attendance.create(
  452. student_id: student3.id, study_session_id: study_session10.id, in_time: study_session10.start_time,
  453. out_time: study_session10.end_time, session_date: study_session10.session_date, course_id: study_session10.course_id
  454. )
  455. Attendance.create(
  456. student_id: student4.id, study_session_id: study_session10.id, in_time: study_session10.start_time,
  457. out_time: study_session10.end_time, session_date: study_session10.session_date, course_id: study_session10.course_id
  458. )
  459. Attendance.create(
  460. student_id: student5.id, study_session_id: study_session10.id, in_time: study_session10.start_time,
  461. out_time: study_session10.end_time, session_date: study_session10.session_date, course_id: study_session10.course_id
  462. )
  463. Attendance.create(
  464. student_id: student6.id, study_session_id: study_session10.id, in_time: study_session10.start_time,
  465. out_time: study_session10.end_time, session_date: study_session10.session_date, course_id: study_session10.course_id
  466. )
  467. Attendance.create(
  468. student_id: student7.id, study_session_id: study_session10.id, in_time: study_session10.start_time,
  469. out_time: study_session10.end_time, session_date: study_session10.session_date, course_id: study_session10.course_id
  470. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement