module CQL

Overview

ULID-compatible ID generator using Time.utc This provides a simple ULID-like implementation that works with modern Crystal

Defined in:

Class Method Summary

• .bootstrap_schema(schema : Schema) : Migrator

  Quick schema bootstrap from existing database

• .build_migrator(schema : Schema, custom_config : MigratorConfig | Nil = nil) : Migrator

  Create a migrator using current configuration

• .build_schema(name : Symbol, &) : Schema

  Create a schema with smart defaults

• .cache_on(enabled : Bool = true) : Nil

  Quick cache enable/disable

• .cache_on? : Bool

  Check if cache is enabled

• .cache_stats : Hash(String, String | Int32 | Int64 | Float64 | Bool)

  Get cache statistics

• .cache_summary : String

  Get cache performance summary

• .config : Configure::Config

  Get current configuration (read-only access)

• .configure(& : Configure::Config -> )

  Minimal Development Setup CQL.configure do |c| c.db = "postgresql://localhost/myapp" end # With CRYSTAL_ENV=development this also turns on SQL logging

• .end_request_cache : Nil

  End request-scoped caching.

• .fragment_cache : CQL::Cache::FragmentCache

  Create fragment cache instance

• .memory_cache : CQL::Cache::MemoryCache

  Create memory cache instance

• .migrator_config(**args) : MigratorConfig

  Create migrator configuration

• .migrator_config_for(env : String) : MigratorConfig

  Create environment-specific migrator configuration

• .raw(sql : String, *positional, **named) : Expression::ConditionBuilder

  A safe SQL fragment as a condition, e.g.

• .request_cache_tracking? : Bool

  Whether request-scoped caching starts requests: cache.on and cache.request_cache.

• .reset_cache! : Nil

  Reset cache statistics

• .reset_config! : Nil

  Reset configuration to defaults

• .start_request_cache(request_id : String | Nil = nil) : Nil

  Start request-scoped caching

• .verify_schema(schema : Schema, auto_fix : Bool = false) : Bool

  Whether the schema file matches the database; with auto_fix (and auto_sync) a stale file is rewritten instead.

• .with_request_cache(request_id : String | Nil = nil, &)

  Execute block with request-scoped caching.

Class Method Detail

CQL.configure do |c|
  c.db = "postgresql://localhost/myapp"
end
# With CRYSTAL_ENV=development this also turns on SQL logging

CQL.configure do |c|
  c.db = ENV["DATABASE_URL"]
  c.env = "production"
  c.pool_size = 25
  c.sql_logging = false # Disable SQL logging
  c.cache.on = true     # Enable caching
end

CQL.configure do |c|
  c.db = "postgresql://localhost/myapp"
  c.sql_logging_colorize = false # Disable colors
  c.cache.on = true              # Enable caching
end