【Unity】第二回 ソーシャルゲームを作る 〜ユーザ登録処理の実装〜【AWS × Laravel】

php artisan make:migration create_user_profile_table

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateUserProfileTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('user_profile', function (Blueprint $table) {
            $table->string('user_id', 37)->charset('utf8');
			$table->string('user_name', 32)->charset('utf8');
			$table->unsignedInteger('banana')->default(0);
			$table->unsignedInteger('banana_free')->default(0);
			$table->unsignedInteger('friend_coin')->default(0);
			$table->unsignedSmallInteger('tutorial_progress')->default(0);
            $table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
			$table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'));
			$table->primary('user_id');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('user_profile');
    }
}

php artisan migrate

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class UserProfile extends Model
{
    protected $table = 'user_profile';
    public $incrementing = false;
    protected $primaryKey = 'user_id';
    public $timestamps = false;
}

git clone https://github.com/Busta117/SQLiteUnityKit.git

using System;

[Serializable]
public class UserProfileModel
{
	public string user_id;
	public string user_name;
	public int banana;
	public int banana_free;
	public int friend_coin;
	public int tutorial_progress;
}

public static class UserProfile
{
	public static void CreateTable()
    {
		string query = "create table if not exists user_profile (user_id text, user_name text, banana int, banana_free int, friend_coin int, tutorial_progress int, primary key(user_id))";
		SqliteDatabase sqlDB = new SqliteDatabase(GameUtil.Const.SQLITE_FILE_NAME);
		sqlDB.ExecuteQuery(query);
	}

	public static void Set(UserProfileModel user_profile)
    {
		string query = "insert or replace into user_profile (user_id, user_name, banana, banana_free, friend_coin, tutorial_progress) values (\"" + user_profile.user_id + "\", \"" + user_profile.user_name + "\", " + user_profile.banana + ", " + user_profile.banana_free + ", " + user_profile.friend_coin + ", " + user_profile.tutorial_progress + ")";
		SqliteDatabase sqlDB = new SqliteDatabase(GameUtil.Const.SQLITE_FILE_NAME);
		sqlDB.ExecuteNonQuery(query);
	}

	public static UserProfileModel Get()
    {
		string query = "select * from user_profile";
		SqliteDatabase sqlDB = new SqliteDatabase(GameUtil.Const.SQLITE_FILE_NAME);
		DataTable dataTable = sqlDB.ExecuteQuery(query);
		UserProfileModel userProfileModel = new UserProfileModel();
		foreach (DataRow dr in dataTable.Rows)
        {
			userProfileModel.user_id = dr["user_id"].ToString();
			userProfileModel.user_name = dr["user_name"].ToString();
			userProfileModel.banana = int.Parse(dr["banana"].ToString());
			userProfileModel.banana_free = int.Parse(dr["banana_free"].ToString());
			userProfileModel.friend_coin = int.Parse(dr["friend_coin"].ToString());
			userProfileModel.tutorial_progress = int.Parse(dr["tutorial_progress"].ToString());
		}
		return userProfileModel;
    }
}

using System;

namespace GameUtil
{
    public static class Const
    {
        /** DB情報 */
        public const string SERVER_URL = 【サーバURL】;
        public const string SQLITE_FILE_NAME = 【SQLiteファイル名】;

        /** エラーID */
        public const string ERROR_DB_UPDATE = "1";
    }
}

using System;
using System.IO;
using UnityEngine;
using UnityEngine.UI;

public class TitleManager : MonoBehaviour
{
    /** UI部品 */
    private const string REGIST_USER_NAME_TEXT = "RegistUserNameText";
    private const string START_USER_NAME_TEXT = "StartUserNameText";
    private const string REGIST_MSG_TEXT = "RegistMsg";
    private const string START_CANVAS = "StartCanvas";
    private const string REGIST_CANVAS = "RegistCanvas";
    private InputField registUserNameText;
    private Text startUserNameText;
    private Text registMsgText;
    private GameObject StartCanvas;
    private GameObject RegistCanvas;

    /** DBモデル */
    private UserProfileModel userProfileModel;

    private void Awake()
    {
        // SQLiteのDBファイル作成
        string DBPath = Application.persistentDataPath + "/" + GameUtil.Const.SQLITE_FILE_NAME;
        if (!File.Exists(DBPath)) {
            File.Create(DBPath);
        }
        // テーブル作成処理
        UserProfile.CreateTable();
    }

    void Start()
    {
        StartCanvas = GameObject.Find(START_CANVAS);
        RegistCanvas = GameObject.Find(REGIST_CANVAS);
        registUserNameText = GameObject.Find(REGIST_USER_NAME_TEXT).GetComponent<InputField>();
        startUserNameText = GameObject.Find(START_USER_NAME_TEXT).GetComponent<Text>();
        registMsgText = GameObject.Find(REGIST_MSG_TEXT).GetComponent<Text>();

        // UserProfileの取得
        userProfileModel = UserProfile.Get();
        if (!string.IsNullOrEmpty(userProfileModel.user_id))
        {
            // ユーザ登録済：StartCanvas表示
            StartCanvas.SetActive(true);
            RegistCanvas.SetActive(false);
            startUserNameText.text = "User：" + userProfileModel.user_name;
        }
        else
        {
            // ユーザ未登録：RegistCanvas表示
            StartCanvas.SetActive(false);
            RegistCanvas.SetActive(true);
        }
    }

    // --------------- ボタン押下時処理 ---------------
    // 登録ボタン押下
    public void PushRegistButton()
    {
        if (string.IsNullOrEmpty(registUserNameText.text))
        {
            // ユーザ名未入力の場合
            registMsgText.text = "ちゃんと入力するクマ";
            
        }
        else if (registUserNameText.text.Length > 5)
        {
            // ユーザ名が５文字以上の場合
            registMsgText.text = "５文字以内で入力するクマ";
        }
        else
        {
            // ユーザ登録処理
            Action action = () => {
                StartCanvas.SetActive(true);
                RegistCanvas.SetActive(false);
                startUserNameText.text = "User：" + registUserNameText.text;
            };
            StartCoroutine(CommunicationManager.ConnectServer("registration", "?user_name=" + registUserNameText.text, action));
        }
    }

    // スタートボタン押下
    public void PushStartButton()
    {
        // スタートボタン押下時の処理を書く！！
    }
}

public class TitleManager : MonoBehaviour
{

・・・略・・・

    /** DBモデル */
    private UserProfileModel userProfileModel;

    private void Awake()
    {
        // SQLiteのDBファイル作成
        string DBPath = Application.persistentDataPath + "/" + GameUtil.Const.SQLITE_FILE_NAME;
        if (!File.Exists(DBPath)) {
            File.Create(DBPath);
        }
        // テーブル作成処理
        UserProfile.CreateTable();
    }

    void Start()
    {

・・・略・・・

        // UserProfileの取得
        userProfileModel = UserProfile.Get();
        if (!string.IsNullOrEmpty(userProfileModel.user_id))
        {
            // ユーザ登録済：StartCanvas表示
            StartCanvas.SetActive(true);
            RegistCanvas.SetActive(false);
            startUserNameText.text = "User：" + userProfileModel.user_name;
        }
        else
        {
            // ユーザ未登録：RegistCanvas表示
            StartCanvas.SetActive(false);
            RegistCanvas.SetActive(true);
        }
    }

・・・略・・・

}

・・・略・・・

    // --------------- ボタン押下時処理 ---------------
    // 登録ボタン押下
    public void PushRegistButton()
    {
        if (string.IsNullOrEmpty(registUserNameText.text))
        {
            // ユーザ名未入力の場合
            registMsgText.text = "ちゃんと入力するクマ";
            
        }
        else if (registUserNameText.text.Length > 5)
        {
            // ユーザ名が５文字以上の場合
            registMsgText.text = "５文字以内で入力するクマ";
        }
        else
        {
            // ユーザ登録処理
            Action action = () => {
                StartCanvas.SetActive(true);
                RegistCanvas.SetActive(false);
                startUserNameText.text = "User：" + registUserNameText.text;
            };
            StartCoroutine(CommunicationManager.ConnectServer("registration", "?user_name=" + registUserNameText.text, action));
        }
    }

・・・略・・・

}

using System.Collections;
using UnityEngine;
using UnityEngine.Networking;
using System;
using System.Linq;

[Serializable]
public class ResponseObjects
{
	public UserProfileModel user_profile;
}

public class CommunicationManager : MonoBehaviour
{

	public static IEnumerator ConnectServer(string endpoint, string paramater, Action action = null)
    {
		// *** リクエストの送付 ***
		UnityWebRequest unityWebRequest = UnityWebRequest.Get(GameUtil.Const.SERVER_URL + endpoint + paramater);
		yield return unityWebRequest.SendWebRequest();
		// エラーの場合
		if (!string.IsNullOrEmpty(unityWebRequest.error))
		{
			Debug.LogError(unityWebRequest.error);
			yield break;
		}

		// *** レスポンスの取得 ***
		string text = unityWebRequest.downloadHandler.text;
		Debug.Log("レスポンス : " + text);
		// エラーの場合
		if (text.All(char.IsNumber))
		{
			switch (text)
			{
				case GameUtil.Const.ERROR_DB_UPDATE:
					Debug.LogError("サーバーでエラーが発生しました。[データベース更新エラー]");
					break;
				default:
					Debug.LogError("サーバーでエラーが発生しました。[システムエラー]");
					break;
			}
			yield break;
		}

		// *** SQLiteへの保存処理 ***
		ResponseObjects responseObjects = JsonUtility.FromJson<ResponseObjects>(text);
		if (!string.IsNullOrEmpty(responseObjects.user_profile.user_id))
			UserProfile.Set(responseObjects.user_profile);
		// 正常終了アクション実行
		if (action != null)
		{
			action();
			action = null;
		}
	}
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\UserProfile;

class RegistrationController extends Controller
{
    public function Registration(Request $request)
	{
		//ユーザーIDの決定
		$user_id = uniqid(); //例:4b3403665fea6

		//初期データの設定
		$user_profile = new UserProfile;
		$user_profile->user_id = $user_id;
		$user_profile->user_name = $request->user_name;
		$user_profile->banana = config('constants.BANANA_DEFAULT');
		$user_profile->banana_free = config('constants.BANANA_FREE_DEFAULT');
		$user_profile->friend_coin = config('constants.FRIEND_COIN_DEFAULT');
		$user_profile->tutorial_progress = config('constants.TUTORIAL_START');

		//データの書き込み
		try {
			$user_profile->save();
		} catch (\PDOException $e) {
			logger($e->getMessage());
			return config('error.ERROR_DB_UPDATE');
		}

		//クライアントへのレスポンス
		$user_profile = UserProfile::where('user_id', $user_id)->first();

		$response = array(
			'user_profile' => $user_profile,
		);

		return json_encode($response);
	}
}

<?php

return array(
    'ERROR_DB_UPDATE' => 1,
);

<?php

return array(
    'BANANA_DEFAULT' => 0,
    'BANANA_FREE_DEFAULT' => 10,
    'FRIEND_COIN_DEFAULT' => 0,
    'TUTORIAL_START' => 0,
);

<?php

Route::get('/', function () {
    return view('welcome');
});
Route::get('registration', 'RegistrationController@Registration');