I created 3 tables. Including 2 N-N tables (subjects, classes )and 1
relation table(classes_subjects)
up do
run 'CREATE EXTENSION IF NOT EXISTS "uuid-ossp"'
create_table(:classes) do
uuid :id, default: Sequel.function(:uuid_generate_v4), primary_key:
true
uuid :kindergarten_id, null: false
uuid :grade_id, null: false
String :name, size: 255, null: false
String :description, size: 1000, text: true
DateTime :deleted_at
DateTime :created_at, null: false, default: Sequel::CURRENT_TIMESTAMP
DateTime :updated_at, null: false, default: Sequel::CURRENT_TIMESTAMP
end
add_index :classes, :kindergarten_id, where: "deleted_at IS NULL"
add_index :classes, :grade_id, where: "deleted_at IS NULL"
end
down do
drop_table(:classes)
end
end
up do
run 'CREATE EXTENSION IF NOT EXISTS "uuid-ossp"'
create_table(:subjects) do
uuid :id, default: Sequel.function(:uuid_generate_v4), primary_key:
true
uuid :teacher_id, null: false
uuid :kindergarten_id, null: false
String :name, null: false, size: 255
String :description, size: 1000, text: true
DateTime :start_time
DateTime :end_time
String :range, default: 'class' # ['class', 'grade']
DateTime :deleted_at
DateTime :created_at, null: false, default: Sequel::CURRENT_TIMESTAMP
DateTime :updated_at, null: false, default: Sequel::CURRENT_TIMESTAMP
end
add_index :subjects, :teacher_id, where: "deleted_at IS NULL"
add_index :subjects, :kindergarten_id, where: "deleted_at IS NULL"
end
down do
drop_table(:subjects)
end
end
up do
run 'CREATE EXTENSION IF NOT EXISTS "uuid-ossp"'
create_table(:classes_subjects) do
uuid :id, default: Sequel.function(:uuid_generate_v4), primary_key:
true
uuid :subject_id, null: false
uuid :class_id, null: false
DateTime :created_at, null: false, default: Sequel::CURRENT_TIMESTAMP
end
add_index :classes_subjects, :subject_id
end
down do
drop_table(:classes_subjects)
end
end
When I use 'Subject.association_join(:classes).where(class_id:
'dsadadsadsadadafasfafaf')' .It errors like:
Enter code here...NoMethodError: undefined method `dataset' for Class:Class
As the 'NoMethodError' refers.Do I need to change my table name 'classes'
into 'clazzes' ?
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.