it "should respect paranoia" do

      class Lime
        include DataMapper::Resource
        property :id, Fixnum, :serial => true
        property :deleted_at, DataMapper::Types::ParanoidDateTime
      end

      puts 'w' if Lime.auto_migrate!(:sqlite3)

      repository(:sqlite3) do
        lime = Lime.new

        puts 'w' if lime.save
        puts lime       # => <Lime:0x12345678>
        puts lime.id    # => nil
        puts Lime.first # => nil

        Lime.first.deleted_at.should_not be_nil

        repository(:sqlite3).adapter.execute("DROP TABLE limes")
      end
    end