<commit_before>class Talk < ActiveRecord::Base
  TALK_KINDS = %w(beginner intermediate advanced lightning)

  scope :by_kind, :order => "case kind when 'beginner'     then 1
                                       when 'intermediate' then 2
                                       when 'advanced'     then 3
                                       when 'lightning'    then 4
                             end, title"<commit_msg>RAWR! I AM THE SQL DINOSAUR!<commit_after>class Talk < ActiveRecord::Base
  TALK_KINDS = %w(beginner intermediate advanced lightning)

  scope :by_kind, :order => "CASE WHEN scheduled_date IS NULL THEN 1
                                  ELSE 0
                                  END,
                             scheduled_date,
                             CASE kind WHEN 'beginner'     THEN 1
                                       WHEN 'intermediate' THEN 2
                                       WHEN 'advanced'     THEN 3
                                       WHEN 'lightning'    THEN 4
                             END,
                             title"
{'fraction_non_alphanumeric': 0.05156537753222836, 'fraction_numerical': 0.009208103130755065, 'mean_word_length': 0.9341637010676157, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 15, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3578734', 'n_tokens_mistral': 267, 'n_tokens_neox': 238, 'n_words': 77}