{"version":1,"pages":[{"id":"-LGab26fozxRbbg_YkOm","title":"Welcome to Clear","pathname":"/project","siteSpaceId":"sitesp_UT8Do","description":""},{"id":"-LWZfaZJUjSS2QSww3Tl","title":"Setup","pathname":"/project/introduction/installation","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Introduction"}]},{"id":"-LWZfaZMp8iF1Gj4Czni","title":"Defining your model","pathname":"/project/model/column-types","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"}]},{"id":"-LWZfaZN_4JIkbOz1soN","title":"Describing your columns","pathname":"/project/model/column-types/model-definition","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Defining your model"}]},{"id":"-LWZfaZOq7tijX9y15zW","title":"Primary Keys","pathname":"/project/model/column-types/primary-keys","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Defining your model"}]},{"id":"-LWZfaZPtJJpJuWAXD29","title":"Converters","pathname":"/project/model/column-types/converters","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Defining your model"}]},{"id":"-LWZfaZQPgJLVdVI552x","title":"Associations","pathname":"/project/model/associations","siteSpaceId":"sitesp_UT8Do","description":"Relation describes the interaction between different models. Clear handles 4 type of relation: Belongs to, Has Many, Has Many Through and Has One.","breadcrumbs":[{"label":"Model"}]},{"id":"-LWZfaZRBM5QjXzVhZFG","title":"belongs_to","pathname":"/project/model/associations/belongs_to","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Associations"}]},{"id":"-LWZfaZSAJ2BXkanTdXC","title":"has_many","pathname":"/project/model/associations/has_many","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Associations"}]},{"id":"-LWZfaZTZbWr6zD79ymv","title":"has_many through","pathname":"/project/model/associations/has_many-through","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Associations"}]},{"id":"-LWZfaZUYaGQsl98zFSs","title":"has_one","pathname":"/project/model/associations/has_one","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Associations"}]},{"id":"-LWZfaZVy27vAw1r7zNW","title":"Lifecycle","pathname":"/project/model/lifecycle","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"}]},{"id":"-LWZfaZW5MhV3jX-4EBa","title":"Persistence","pathname":"/project/model/lifecycle/persistence","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Lifecycle"}]},{"id":"-LWZfaZXFaH5y7HX2r5S","title":"Validations","pathname":"/project/model/lifecycle/validations","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Lifecycle"}]},{"id":"-LWZfaZjZZCX6UPz9WQ8","title":"Triggers","pathname":"/project/model/lifecycle/callbacks","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Lifecycle"}]},{"id":"-LWZfaZkX1ytaOZq4Vgr","title":"Batchs operations","pathname":"/project/model/batchs-operations","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"}]},{"id":"-LWZfaZlnVRo2s3KynaX","title":"Bulk update","pathname":"/project/model/batchs-operations/bulk-update","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Batchs operations"}]},{"id":"-LWZfaZmA0bk_ZKTndXT","title":"Bulk insert & delete","pathname":"/project/model/batchs-operations/bulk-insert","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Batchs operations"}]},{"id":"-LWZfaZntf3txPo5g62o","title":"Transactions & Save Points","pathname":"/project/model/transactions-and-save-points","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"}]},{"id":"-LWZfaZo9XQ3-jLJIJD3","title":"Transaction & Savepoints","pathname":"/project/model/transactions-and-save-points/transaction","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Transactions & Save Points"}]},{"id":"-LWZfaZpUT6DmZDNAmrd","title":"Connection pool","pathname":"/project/model/transactions-and-save-points/connection-pool","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"},{"label":"Transactions & Save Points"}]},{"id":"-LWZfaZqRfJSiOebkpC7","title":"Locks","pathname":"/project/model/locks","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Model"}]},{"id":"-LWZfaZtSRqvtZMaCO0_","title":"The collection object","pathname":"/project/querying/the-collection-object","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"}]},{"id":"-LWZfaZuZIT9IIo_tTVi","title":"Filter the query","pathname":"/project/querying/the-collection-object/filter-the-query-1","siteSpaceId":"sitesp_UT8Do","description":"Clear offers many tools to filter and refine your query","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"}]},{"id":"-LWZfaZvg47djenH9Lh-","title":"Filter the query – The Expression Engine","pathname":"/project/querying/the-collection-object/filter-the-query-1/filter-the-query","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"},{"label":"Filter the query"}]},{"id":"-LWZfaZwE9yRZSxHJJmK","title":"Find, First, Last, Offset, Limit","pathname":"/project/querying/the-collection-object/filter-the-query-1/find-first","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"},{"label":"Filter the query"}]},{"id":"-LWZfaZxYtxZOnuH6pSJ","title":"Aggregation","pathname":"/project/querying/the-collection-object/filter-the-query-1/aggregation","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"},{"label":"Filter the query"}]},{"id":"-LWZfaZyEe6e_jlFfFei","title":"Ordering & Group by","pathname":"/project/querying/the-collection-object/filter-the-query-1/ordering","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"},{"label":"Filter the query"}]},{"id":"-LWZfaZzBpiZ5_EDmbYJ","title":"Fetching the query","pathname":"/project/querying/the-collection-object/fetching-the-query","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"}]},{"id":"-LWZfa_--YkHXZMKC274","title":"Each and Fetch","pathname":"/project/querying/the-collection-object/fetching-the-query/each-map-fetch","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"},{"label":"Fetching the query"}]},{"id":"-LWZfa_0Wy2VSULty9Bw","title":"Cursored fetching","pathname":"/project/querying/the-collection-object/fetching-the-query/cursored-fetching","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"},{"label":"Fetching the query"}]},{"id":"-LWZfa_1ImmSnqhSoyqk","title":"Model extra attributes","pathname":"/project/querying/the-collection-object/fetching-the-query/model-attributes","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"},{"label":"Fetching the query"}]},{"id":"-LWZfa_2fV1jd-RcgwVi","title":"Joins","pathname":"/project/querying/the-collection-object/joins","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"}]},{"id":"-LWZfa_3I2kKizJ7k27_","title":"Eager Loading","pathname":"/project/querying/the-collection-object/n+1-query-avoidance","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"}]},{"id":"-LWZfa_4RwWWxOgUmfFq","title":"Window and CTE","pathname":"/project/querying/the-collection-object/window-and-cte","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"}]},{"id":"-LWZfa_5yqn9dhXjPeHq","title":"Scopes","pathname":"/project/querying/the-collection-object/scopes","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"The collection object"}]},{"id":"-LWZfa_6ud_W0HjoJncw","title":"Writing low-level SQL","pathname":"/project/querying/low-level-sql","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"}]},{"id":"-LWZfa_7DuWtBG5HHNsr","title":"Select Clause","pathname":"/project/querying/low-level-sql/select-clause","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"Writing low-level SQL"}]},{"id":"-LWZfa_8oXjK6ichxwBF","title":"Insert Clause","pathname":"/project/querying/low-level-sql/insert-clause","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"Writing low-level SQL"}]},{"id":"-LWZfa_9SXehUtieCLZi","title":"Delete Clause","pathname":"/project/querying/low-level-sql/delete-clause","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Querying"},{"label":"Writing low-level SQL"}]},{"id":"-LWZfa_Cnl5MzcIxVZQV","title":"Manage migrations","pathname":"/project/migrations/manage-migrations","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Migrations"}]},{"id":"-LWZfa_DyUwP5cd2_gbQ","title":"Call migration script","pathname":"/project/migrations/call-migration-script","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Migrations"}]},{"id":"-LWZfa_Ex2gBkXWkyPLm","title":"Migration CLI","pathname":"/project/migrations/migration-cli","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Migrations"}]},{"id":"-LWZfa_L_R5fsmx_AfxV","title":"JSONB","pathname":"/project/additional-and-advanced-features/jsonb","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Additional and advanced features"}]},{"id":"-LWZfa_HHxSrb8yZokzy","title":"Symbol vs String","pathname":"/project/additional-and-advanced-features/symbol-vs-string","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Additional and advanced features"}]},{"id":"-LWZfa_IcKO5JLwk5JyH","title":"Enums","pathname":"/project/additional-and-advanced-features/enums","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Additional and advanced features"}]},{"id":"-LWZfa_JiOAzXnS2y725","title":"BCrypt","pathname":"/project/additional-and-advanced-features/bcrypt","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Additional and advanced features"}]},{"id":"-LWZfa_KAxmymZN96isf","title":"Full Text Search","pathname":"/project/additional-and-advanced-features/full-text-search","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Additional and advanced features"}]},{"id":"-LWZfa_MydQOoOR4aOJf","title":"Handling multi-connection","pathname":"/project/additional-and-advanced-features/handling-multi-connection","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Additional and advanced features"}]},{"id":"-LWZfa_STODjJrdprVmn","title":"Benchmark","pathname":"/project/other-resources/benchmark","siteSpaceId":"sitesp_UT8Do","description":"","breadcrumbs":[{"label":"Other resources"}]}]}