Move History

Rooted by: Basic Select (SQL)
Fork Selected
  • Code 
    SELECT name 
FROM greetings
LIMIT 10;
     Preloaded Code 
    DB.create_table :greetings do
  primary_key :id
  String :name
  String :greeting
end

greetings = DB[:greetings]
# Populate the table
greetings.insert(:name => 'Paul', :greeting => "Hello")
greetings.insert(:name => 'Tom', :greeting => "How are you?")
greetings.insert(:name => 'Will', :greeting => "Hello")
greetings.insert(:name => 'Josh', :greeting => "Are you having a nice day?")
greetings.insert(:name => 'Kate', :greeting => "Good to see you!")
greetings.insert(:name => 'Timmy', :greeting => "Hello")
greetings.insert(:name => 'Josh', :greeting => "Hello")
greetings.insert(:name => 'Vance', :greeting => "Good to see you!")
greetings.insert(:name => 'Alice', :greeting => "Hello")
greetings.insert(:name => 'Jim', :greeting => "Are you having a nice day?")
greetings.insert(:name => 'Sally', :greeting => "Hello")
greetings.insert(:name => 'Bob', :greeting => "Hello")
greetings.insert(:name => 'John', :greeting => "Hello there")
greetings.insert(:name => 'Tito', :greeting => "Hey, Hello, how are you")
greetings.insert(:name => 'Puente', :greeting => "Hey, hello, how are you")
    Test Cases 
    results = run_sql

describe :items do
   it "should return 10 items" do
    expect(results.count).to eq 10
   end
end
    View Run Output
  • Code
    • SELECT name FROM greetings
    • WHERE greeting like '%ll%';
    • SELECT name
    • FROM greetings
    • LIMIT 10;