coreyjs

class App < ApplicationRecord
    validates :name, uniqueness: true
    validates :token, uniqueness: true
end

coreyjs

Rails.application.routes.draw do
  # For details on the DSL available within this file, see http://guides.rubyonrails.org/routing.html
  root 'application#index', format: 'json'

  namespace :v1 do
    resource :apps
  end

end

coreyjs

class V1::AppsController < ApplicationController
  before_action :set_app, only: [:show, :update, :destroy]

  # GET /v1/apps
  def index
    @apps = App.all

    render json: @apps
  end

coreyjs

coreyjs

class ApplicationController < ActionController::API
    def index
        render json: { status: 200, message: 'Hello World'}
    end
end

coreyjs

Rails.application.routes.draw do
  # For details on the DSL available within this file, see http://guides.rubyonrails.org/routing.html
  root 'application#index', format: 'json'
end

coreyjs

Rails.application.routes.draw do
  # For details on the DSL available within this file, see http://guides.rubyonrails.org/routing.html
end

coreyjs

class CreateApps < ActiveRecord::Migration[5.2]
  def change
    create_table :apps do |t|
      # Name of our app, used for visual readability.
      t.string :name, unique: true

      # Internal identifier of our app, for communication from the open api endpoint
      t.string :token, unique: true

      # Switch to determine if this app is currently accepting data.

coreyjs

module ApiHelper
  include Rack::Test::Methods
 
  def app
    Rails.application
  end
end
 
RSpec.configure do |config|
  config.include ApiHelper, api: true

coreyjs

  select order_Id from [order] o where(
  
    o.order_id in (
				 select osh.order_id
				  from order_status_history osh
				  join order_status os on os.status_id = osh.status_id
				  inner join (
				  select order_id, MAX(effective_date) as updated
				  from order_status_history
				 group by order_id) as status on osh.order_id = status.order_id and osh.effective_date = status.updated