require 'sinatra'
require 'mysql2'
require 'mysql2-cs-bind'

def db
  # Mysqlドライバの設定
  Mysql2::Client.new(
    host: 'localhost',
    port: 3306,
    username: 'root',
    password: '',
    database: 'instagramer',
    reconnect: true,
  )
end

def set_user(user_id)
  return nil if user_id.nil?
  @user = db.xquery("SELECT * From users WHERE id = ?", user_id).to_a.first
end

def login?
  !session[:user_id].nil?
end

class LoginApp < Sinatra::Base
  enable :sessions

  set :public_folder, File.dirname(__FILE__) + '/public'

  get '/' do
    set_user
    erb :index
  end

  get '/login' do
    redirect '/' if login?

    erb :login
  end

  post '/login' do
    email = params[:email]
    password = params[:password]

    user = db.xquery("SELECT * FROM users where email = ? and password = ?",email, password).to_a.first


    if user
      session[:user_id] = user[:id]
      redirect '/'
    else
      erb :login
    end
  end
end