Contents

# encoding: utf-8

describe "DELETE" do

  include QueryBuilder::CQL::Operators

  let(:table) { QueryBuilder::CQL.keyspace(:wildlife).table(:species) }

  it_behaves_like :query_builder do
    subject   { table.delete }
    let(:cql) { "DELETE FROM wildlife.species;" }
  end

  it_behaves_like :query_builder do
    subject do
      table
        .delete(:name, :number)
        .delete(:areal)
        .where(name: [:qiwi, :dront], cql_element[:state, 0] => :not_found)
        .if(number: 0)
        .using(timestamp: 100)
        .if_exists
    end

    let(:cql) { "DELETE name, number, areal FROM wildlife.species USING TIMESTAMP 100 WHERE name IN ('qiwi', 'dront') AND state[0] = 'not_found' IF EXISTS AND number = 0;" }
  end

end # describe DELETE

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
query_builder-0.0.4	spec/integration/delete_spec.rb
query_builder-0.0.3	spec/integration/delete_spec.rb
query_builder-0.0.2	spec/integration/delete_spec.rb
query_builder-0.0.1	spec/integration/delete_spec.rb