Table of Contents - Sequel: The Database Toolkit for Ruby
Pages
-
CHANGELOG
-
MIT-LICENSE
-
README
-
advanced_associations
-
association_basics
- Association Basics
- Why Associations?
- The Types of Associations
- many_to_one
- one_to_many and one_to_one
- many_to_many and one_through_one
- Differences Between many_to_one and one_to_one
- Most Common Options
- :key
- :class
- Self-referential Associations
- Methods Added
- Caching
- Dataset Method
- Dynamic Association Modification
- Filtering By Associations
- Name Collisions
- Database Schema
- many_to_one/one_to_many
- many_to_many
- Association Scope
- Method Details
- association(opts={}) (e.g. albums)
- association=(object_to_associate) (e.g. artist=) [many_to_one and one_to_one]
- add_association(object_to_associate) (e.g. add_album) [one_to_many and many_to_many]
- remove_association(object_to_disassociate) (e.g. remove_album) [one_to_many and many_to_many]
- remove_all_association (e.g. remove_all_albums) [one_to_many and many_to_many]
- association_dataset (e.g. albums_dataset)
- Overriding Method Behavior
- :setter (_association= method)
- :adder (_add_association method)
- :remover (_remove_association method)
- :clearer (_remove_all_association method)
- Association Options
- Association Dataset Modification Options
- block
- :class
- :key
- :conditions
- :order
- :select
- :limit
- :join_table [many_to_many, one_through_one]
- :left_key [many_to_many, one_through_one]
- :right_key [many_to_many, one_through_one]
- :distinct
- :clone
- :dataset
- :extend
- :primary_key [many_to_one, one_to_one, one_to_many]
- :left_primary_key [many_to_many, one_through_one]
- :right_primary_key [many_to_many, one_through_one]
- :join_table_block [many_to_many, one_through_one]
- Callback Options
- :before_add [one_to_many, many_to_many]
- :after_add [one_to_many, many_to_many]
- :before_remove [one_to_many, many_to_many]
- :after_remove [one_to_many, many_to_many]
- :before_set [many_to_one, one_to_one]
- :after_set [many_to_one, one_to_one]
- :after_load
- :uniq [many_to_many]
- Eager Loading via eager (query per association) Options
- :eager
- :eager_loader
- :eager_loader_key
- :eager_block
- Eager Loading via eager_graph (one query with joins) Options
- :eager_graph
- :graph_conditions
- :graph_block
- :graph_join_type
- :graph_select
- :graph_only_conditions
- :graph_alias_base
- :eager_grapher
- :order_eager_graph
- :graph_order
- :graph_join_table_conditions [many_to_many, one_through_one]
- :graph_join_table_block [many_to_many, one_through_one]
- :graph_join_table_join_type [many_to_many, one_through_one]
- :graph_join_table_only_conditions [many_to_many, one_through_one]
- Associations Based on SQL Expressions Options
- :key_column [many_to_one]
- :primary_key_method [many_to_one]
- :primary_key_column [one_to_many, one_to_one]
- :key_method [one_to_many, one_to_one]
- :left_primary_key_column [many_to_many, one_through_one]
- :right_primary_key_method [many_to_many, one_through_one]
- Advanced Options
- :reciprocal
- :read_only
- :validate
- :raise_on_save_failure [one_to_many associations]
- :allow_eager
- :instance_specific
- :cartesian_product_number
- :class_namespace
- :methods_module
- :eager_limit_strategy
- :subqueries_per_union
- :filter_limit_strategy
-
bin_sequel
-
cheat_sheet
-
code_order
-
core_extensions
-
dataset_basics
-
dataset_filtering
-
extensions
-
mass_assignment
-
migration
-
model_dataset_method_design
-
model_hooks
-
model_plugins
-
mssql_stored_procedures
-
object_model
-
opening_databases
-
postgresql
-
prepared_statements
-
querying
-
reflection
-
4.0.0
-
4.1.0
-
4.10.0
-
4.11.0
-
4.12.0
-
4.13.0
-
4.14.0
-
4.15.0
-
4.16.0
-
4.17.0
-
4.18.0
-
4.19.0
-
4.2.0
-
4.20.0
-
4.21.0
-
4.22.0
-
4.23.0
-
4.24.0
-
4.25.0
-
4.26.0
-
4.27.0
-
4.28.0
-
4.29.0
-
4.3.0
-
4.30.0
-
4.31.0
-
4.32.0
-
4.33.0
-
4.34.0
-
4.35.0
-
4.36.0
-
4.37.0
-
4.38.0
-
4.39.0
-
4.4.0
-
4.40.0
-
4.41.0
-
4.42.0
-
4.43.0
-
4.44.0
-
4.45.0
-
4.46.0
-
4.47.0
-
4.48.0
-
4.49.0
-
4.5.0
-
4.6.0
-
4.7.0
-
4.8.0
-
4.9.0
-
5.0.0
-
5.1.0
-
5.2.0
-
5.3.0
-
5.4.0
-
5.5.0
-
5.6.0
-
5.7.0
-
schema_modification
-
security
-
sharding
-
sql
- Sequel for SQL Users
- You Can Just Use SQL
- SELECT
- INSERT, UPDATE, DELETE
- Other Queries
- Other Places
- Translating SQL Expressions into Sequel
- Database#literal
- Database Loggers
- Identifiers
- Numbers
- Strings
- Aliasing
- Functions
- Aggregate Functions
- Window Functions
- Schema Qualified Functions
- Portable/Emulated Functions
- Equality Operator (=)
- Not Equal Operator (!=)
- Inclusion and Exclusion Operators (IN, NOT IN)
- Identity Operators (IS, IS NOT)
- Inversion Operator (NOT)
- Inequality Operators (< > <= >=)
- Standard Mathematical Operators (+ - * /)
- Boolean Operators (AND OR)
- Casts
- Bitwise Mathematical Operators (& | ^ << >> ~)
- String Operators (||, LIKE, Regexp)
- Order Specifications (ASC, DESC)
- All Columns (.*)
- CASE statements
- Subscripts/Array Access ([])
- Building Queries in Sequel
- Creating Datasets
- Chaining Methods
- Using the Same Dataset for SELECT, INSERT, UPDATE, and DELETE
- Methods Used for Each SQL Clause
-
testing
-
thread_safety
-
transactions
-
validations
-
virtual_rows
Classes/Modules
Methods