Guest User

Untitled

a guest
Sep 8th, 2018
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.93 KB | None | 0 0
  1. Problems with ActiveRecord after certain amount of columns in table
  2. class CreateUsers < ActiveRecord::Migration
  3. def self.up
  4. create_table :users do |t|
  5. t.references "faculty"
  6. t.references "department"
  7. t.references "role", :null => false
  8. t.string "name", :null => false, :limit => 20
  9. t.string "surname", :null => false, :limit => 20
  10. t.string "username",:null => false, :limit => 25
  11. t.string "study_group",:limit => 6
  12. t.string "study_course",:limit => 50
  13. t.string "card_code",:limit => 12
  14. t.boolean "During_Day",:default => false
  15. t.string "email", :limit => 100
  16. t.string "hashed_password", :limit => 40
  17. t.string "salt", :limit => 40
  18. end
  19. end
  20.  
  21. def self.down
  22. drop_table :users
  23. end
  24. end
  25.  
  26. User.all
  27.  
  28. mysql> show create table usersG
  29. *************************** 1. row ***************************
  30. Table: users
  31. Create Table: CREATE TABLE `users` (
  32. `id` int(11) NOT NULL auto_increment,
  33. `faculty_id` int(11) default NULL,
  34. `department_id` int(11) default NULL,
  35. `role_id` int(11) NOT NULL,
  36. `name` varchar(20) NOT NULL,
  37. `surname` varchar(20) NOT NULL,
  38. `username` varchar(25) NOT NULL,
  39. `study_group` varchar(6) default NULL,
  40. `study_course` varchar(50) default NULL,
  41. `card_code` varchar(15) default NULL,
  42. `day_time` tinyint(1) default '0',
  43. `email` varchar(100) default NULL,
  44. `hashed_password` varchar(40) default NULL,
  45. `salt` varchar(40) default NULL,
  46. PRIMARY KEY (`id`),
  47. KEY `faculty` (`faculty_id`),
  48. KEY `department` (`department_id`),
  49. KEY `role` (`role_id`),
  50. KEY `username` (`username`)
  51. ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  52. 1 row in set (0.02 sec)
  53. mysql>
  54.  
  55. Loading development environment (Rails 3.0.3)
  56. irb(main):001:0> me = User.new
  57. => #<User id: nil, faculty_id: nil, department_id: nil, role_id: nil,
  58. name: "", surname: "", username: "", study_group: nil, study_cour
  59. se: nil, card_code: nil, day_time: false, email: nil, hashed_password:
  60. nil, salt: nil>
  61. irb(main):002:0> me.name = 'Daniel'
  62. => "Daniel"
  63. irb(main):003:0> me.surname = 'Garcia'
  64. => "Garcia"
  65. irb(main):004:0> me.username = 'vinagrito'
  66. => "vinagrito"
  67. irb(main):005:0> me.role_id = 1
  68. => 1
  69. irb(main):006:0> me.save
  70. => false
  71. irb(main):007:0> me.errors
  72. => {:password=>["is too short (minimum is 8 characters)"], :email=>["is
  73. invalid", "can't be blank"]}
  74. irb(main):008:0> me.password = '12345678'
  75. => "12345678"
  76. irb(main):009:0> me.email = 'mail@mail.com'
  77. => "mail@mail.com"
  78. irb(main):010:0> me.save
  79. => true
  80. irb(main):011:0> me
  81. => #<User id: 2, faculty_id: nil, department_id: nil, role_id: 1, name:
  82. "Daniel", surname: "Garcia", username: "vinagrito", study_group
  83. : nil, study_course: nil, card_code: nil, day_time: false, email:
  84. "mail@mail.com", hashed_password: "6305ee7016b263c0ec41a81439a378837a
  85. 318035", salt: "5c33e8fed10b87c9f4b7841f0faeb7b10424289a">
  86. irb(main):013:0> user = User.where(:id => 2)
  87. => [#<User id: 2, faculty_id: nil, department_id: nil, role_id: 1, name:
  88. "Daniel", surname: "Garcia", username: "vinagrito", study_grou
  89. p: nil, study_course: nil, card_code: nil, day_time: false, email:
  90. "mail@mail.com", hashed_password: 6305.0, salt: "5c33e8fed10b87c9f4b
  91. 7841f0faeb7b10424289a">]
  92.  
  93. [1m[36mSQL (1.0ms)[0m [1mSHOW TABLES[0m
  94. [1m[35mSQL (2.0ms)[0m SHOW TABLES
  95. [1m[36mSQL (1.0ms)[0m [1mSELECT `schema_migrations`.`version` FROM
  96. `schema_migrations`[0m
  97. [1m[35mSQL (31.0ms)[0m CREATE TABLE `users` (`id` int(11) DEFAULT
  98. NULL auto_increment PRIMARY KEY, `faculty_id` int(11), `department_id`
  99. int(11), `role_id` int(11) NOT NULL, `name` varchar(20) NOT NULL,
  100. `surname` varchar(20) NOT NULL, `username` varchar(25) NOT NULL,
  101. `study_group` varchar(6), `study_course` varchar(50), `card_code`
  102. varchar(15), `day_time` tinyint(1) DEFAULT 0, `email` varchar(100),
  103. `hashed_password` varchar(40), `salt` varchar(40)) ENGINE=InnoDB
  104. [1m[36mSQL (68.0ms)[0m [1mCREATE INDEX faculty ON
  105. users(faculty_id)[0m
  106. [1m[35mSQL (65.0ms)[0m CREATE INDEX department ON
  107. users(department_id)
  108. [1m[36mSQL (78.0ms)[0m [1mCREATE INDEX role ON users(role_id)[0m
  109. [1m[35mSQL (80.8ms)[0m CREATE INDEX username ON users(username)
  110. [1m[36mSQL (30.0ms)[0m [1mINSERT INTO `schema_migrations` (`version`)
  111. VALUES ('20101226144503')[0m
  112. [1m[35mSQL (7.0ms)[0m SHOW TABLES
  113. [1m[36mSQL (3.0ms)[0m [1mSELECT `schema_migrations`.`version` FROM
  114. `schema_migrations`[0m
  115. [1m[35mSQL (2.0ms)[0m SHOW TABLES
  116. [1m[36mSQL (7.0ms)[0m [1mdescribe `authors`[0m
  117. [1m[35mSQL (2.0ms)[0m SHOW KEYS FROM `authors`
  118. [1m[36mSQL (7.0ms)[0m [1mdescribe `book_loans`[0m
  119. [1m[35mSQL (3.0ms)[0m SHOW KEYS FROM `book_loans`
  120. [1m[36mSQL (7.0ms)[0m [1mdescribe `books`[0m
  121. [1m[35mSQL (2.0ms)[0m SHOW KEYS FROM `books`
  122. [1m[36mSQL (7.0ms)[0m [1mdescribe `departments`[0m
  123. [1m[35mSQL (3.0ms)[0m SHOW KEYS FROM `departments`
  124. [1m[36mSQL (8.0ms)[0m [1mdescribe `faculties`[0m
  125. [1m[35mSQL (3.0ms)[0m SHOW KEYS FROM `faculties`
  126. [1m[36mSQL (7.0ms)[0m [1mdescribe `roles`[0m
  127. [1m[35mSQL (2.0ms)[0m SHOW KEYS FROM `roles`
  128. [1m[36mSQL (7.0ms)[0m [1mdescribe `subjects`[0m
  129. [1m[35mSQL (2.0ms)[0m SHOW KEYS FROM `subjects`
  130. [1m[36mSQL (7.0ms)[0m [1mdescribe `users`[0m
  131. [1m[35mSQL (1.0ms)[0m SHOW KEYS FROM `users`
  132. [1m[36mSQL (0.0ms)[0m [1mSHOW TABLES[0m
  133. [1m[35mSQL (0.0ms)[0m BEGIN
  134. [1m[36mSQL (0.0ms)[0m [1mdescribe `users`[0m
  135. [1m[35mAREL (0.0ms)[0m INSERT INTO `users` (`faculty_id`,
  136. `department_id`, `role_id`, `name`, `surname`, `username`,
  137. `study_group`, `study_course`, `card_code`, `day_time`, `email`,
  138. `hashed_password`, `salt`) VALUES (NULL, NULL, 1, 'Daniel', 'Garcia',
  139. 'viangrito', NULL, NULL, NULL, 0, 'mail@mail.com',
  140. 'e1382ac8675daee167a262ee7ef3bd038f997c4a',
  141. 'a3518e0a6b273590073bd733e2ee692fbca28c2d')
  142. [1m[36mSQL (15.6ms)[0m [1mCOMMIT[0m
  143.  
  144. ActiveRecord::Schema.define(:version => XXXXXXXXXXXXXX) do #my last migration version
  145.  
  146. #Could not dump table "table_name" beacuse of following ArgumentError
  147. # invalid date
  148. .
  149. .
  150. .# and so one for each table I had
  151. end
Add Comment
Please, Sign In to add comment