composer<\/a> (es un manejador de dependencias de PHP)<\/p>\n\u00a0<\/p>\n
Paso 1:<\/h3>\n
Instalar Laravel Lumen de la siguiente forma:<\/p>\n
En la consola de Linux ejecutamos composer de la siguiente manera:<\/p>\n\n\n
composer create-project --prefer-dist laravel\/lumen api-test<\/code><\/pre>\n\n\nPaso 2<\/h3>\n
Generar una App Key para nuestro backend, para esto ejecutamos en la consola de Linux lo siguiente:<\/p>\n\n\n
php -r \"echo bin2hex(random_bytes(32));\"<\/code><\/pre>\n\n\nEsto devuelve como resultado algo como esto:<\/p>\n\n\n
54e2adb7d8eed9619e700f04aef3fde231d917d17ebc5867224d7a74fcb8f929<\/code><\/pre>\n\n\nPaso 3<\/h3>\n
Editamos el archivo .env que se encuentra en el directorio raiz de la aplicacion en nuestro caso, la aplicacion quedo instalada en la carpeta llamada api-test por lo tanto el .env debe estar ubicado en api-test\/.env.<\/p>\n
Editaremos la linea con la variable\u00a0 APP_KEY y en ella pegamos el string que generamos en el Paso 2<\/strong><\/p>\nAdemas en este paso, aprovechamos de agregar los parametros asociados a la base de datos DB_DATABASE, DB_USERNAME, DB_PASSWORD y DB_CONNECTION (mysql en este caso).<\/p>\n
El .env por el momento, deberia quedar asi:<\/p>\n\n\n
APP_NAME=Lumen\nAPP_ENV=local\nAPP_KEY=54e2adb7d8eed9619e700f04aef3fde231d917d17ebc5867224d7a74fcb8f929\nAPP_DEBUG=true\nAPP_URL=http:\/\/localhost\nAPP_TIMEZONE=UTC\n\nLOG_CHANNEL=stack\nLOG_SLACK_WEBHOOK_URL=\n\nDB_CONNECTION=mysql\nDB_HOST=127.0.0.1\nDB_PORT=3306\nDB_DATABASE=apitest\nDB_USERNAME=tunombredeusuario\nDB_PASSWORD=tupassword\n\nCACHE_DRIVER=file\nQUEUE_CONNECTION=sync<\/code><\/pre>\n\n\nDestacamos el parametro DB_DATABASE al que le asignamos el valor de apitest, debido a que mas adelante, debemos crear una base de datos en mysql con ese mismo nombre.<\/p>\n
<\/p>\n
Paso 4<\/h3>\n
Editamos el archivo que esta en la carpeta bootstrap\/app.php por ahora solo descomentamos las siguientes lineas:<\/p>\n\n\n
$app->withFacades();\n $app->withEloquent();<\/code><\/pre>\n\n\nPaso 5<\/h3>\n
Creamos la migracion para la tabla opiniones, para ello, desde la consola de linux ejecutamos la siguiente linea:<\/p>\n\n\n
php artisan make:migration create_opiniones_table <\/code><\/pre>\n\n\nEl resultado devuelto debe ser algo como esto:<\/p>\n\n\n
INFO Migration [\/home\/robetorr\/api-test\/database\/migrations\/2023_08_17_205246_create_opiniones_table.php] created successfully.<\/code><\/pre>\n\n\nPaso 6<\/h3>\n
Editar 2023_08_17_205246_create_opiniones_table.php (archivo generado en el paso 5<\/strong>) que se encuentra ubicado en la carpeta database\/migrations de la aplicacion y agregar los siguientes campos:<\/p>\n\n\n<?php\n\nuse Illuminate\\Database\\Migrations\\Migration;\nuse Illuminate\\Database\\Schema\\Blueprint;\nuse Illuminate\\Support\\Facades\\Schema;\n\nreturn new class extends Migration\n{\n \/**\n * Run the migrations.\n *\/\n public function up(): void\n {\n Schema::create('opiniones', function (Blueprint $table) {\n $table->bigIncrements();\n $table->text('nombre');\n $table->text('email');\n $table->text('mensaje'); \n $table->timestamps();\n });\n }\n\n \/**\n * Reverse the migrations.\n *\/\n public function down(): void\n {\n Schema::dropIfExists('opiniones');\n }\n};<\/code><\/pre>\n\n\nPaso 7 MySql<\/h3>\n
Entramos a mysql<\/p>\n\n\n
mysql -u robetorr -p<\/code><\/pre>\n\n\nCreamos la base de datos <\/p>\n\n\n
create database apitest;<\/code><\/pre>\n\n\nSalimos de mysql (ctrl+d)<\/p>\n
Paso 6<\/h3>\n
Ejecutar la migracion. En la raiz de la aplicacion ejecutar:<\/p>\n\n\n
php artisan migrate<\/code><\/pre>\n\n\nSi todo esta bien y los parametros del .env coinciden con los de tu base de datos, esto debe devolver lo siguiente:<\/p>\n\n\n
INFO Preparing database. \n\n Creating migration table ............................................................................................. 916ms DONE\n\n INFO Running migrations. \n\n 2023_08_17_205246_create_opiniones_table ........................................................................... 1,206ms DONE<\/code><\/pre>\n\n\nHas creado la tabla opiniones en la base de datos apitest.<\/p>\n
Paso 7<\/h3>\n
Creamos el modelo en la carpeta app\/Model y lo llamaremos app\/Model\/Opinion.php debe quedar asi:<\/p>\n\n\n
<?php\n\nnamespace App\\Models;\n\n\nuse Illuminate\\Database\\Eloquent\\Model;\n\nclass Opinion extends Model\n{\n protected $fillable = ['nombre', 'email','mensaje'];\n}<\/code><\/pre>\n\n\nPaso 8<\/h3>\n
Creamos el controlador en app\/Http\/Controllers\/ y lo llamaremos app\/Controllers\/OpinionController.php y creamos los metodos index,show,store,update y destroy. El arcivo deberia quedar de esta manera:<\/p>\n
<\/p>\n\n\n
<?php\n\nnamespace App\\Http\\Controllers;\nuse Illuminate\\Http\\Request;\nuse App\\Models\\Opinion;\n\nclass OpinionController extends Controller\n{\n \/**\n * Create a new controller instance.\n *\n * @return void\n *\/\n public function __construct()\n {\n \/\/\n }\n public function index(){\n try\n {\n $Opiniones = Opinion::all();\n }\n catch (Exception $e)\n {\n return response()->json([\n 'responseCode' => '500',\n 'response' => 'Internal Server Error',\n 'data' => [\n 'errorCode' => 'Error-1',\n \/\/\"exception\" => $e->getMessage(),\n 'errorMessage' => 'Error getting Opinions'\n ]\n ], 500);\n }\n\n if($Opiniones)\n {\n $data = [];\n foreach($Opiniones as $Opinion)\n {\n $types = [];\n $types = [\n 'id' => $Opinion->id,\n 'nombre' => $Opinion->nombre,\n 'email' => $Opinion->email,\n 'id_post' => $Opinion->id_post,\n 'mensaje' => $Opinion->mensaje\n ];\n $data[] = $types;\n }\n }\n\n if($data)\n {\n return response()->json([\n 'responseCode' => 200,\n 'response' => 'OK',\n 'data' => $data\n ], 200);\n }\n else\n {\n return response()->json([\n 'responseCode' => 404,\n 'response' => 'Not Found',\n 'data' => [\n 'errorCode' => 'Error-2', \n 'errorMessage' => 'Opinions was not found'\n ]\n ], 404);\n }\n }\n public function show($id){\n try\n {\n $Opinion = Opinion::where('id', $id)->first();\n }\n catch (Exception $e)\n {\n return response()->json([\n 'responseCode' => '500',\n 'response' => 'Internal Server Error',\n 'data' => [\n 'errorCode' => 'Error-1',\n \/\/\"exception\" => $e->getMessage(),\n 'errorMessage' => 'Error getting Opinions'\n ]\n ], 500);\n }\n if($Opinion)\n {\n $data = [];\n $data = [\n 'id' => $Opinion->id,\n 'nombre' => $Opinion->nombre,\n 'email' => $Opinion->email,\n 'id_post' => $Opinion->id_post,\n 'mensaje' => $Opinion->mensaje\n ];\n }\n\n if($data)\n {\n return response()->json([\n 'responseCode' => 200,\n 'response' => 'OK',\n 'data' => $data\n ], 200);\n }\n else\n {\n return response()->json([\n 'responseCode' => 404,\n 'response' => 'Not Found',\n 'data' => [\n 'errorCode' => 'Error-2', \n 'errorMessage' => 'Opinion was not found'\n ]\n ], 404);\n }\n }\n public function store(Request $request){\n $data = new Opinion();\n if($request->input('nombre')){\n $data->nombre = $request->input('nombre');\n }else{\n return response()->json([\n 'responseCode' => '422',\n 'response' => 'Validation Error',\n 'data' => [\n 'errorCode' => '001',\n 'error' => 'Nombre no puede estar vacio'\n ]\n ], 422);\n }\n if($request->input('email')){\n $data->email = $request->input('email');\n }else{\n return response()->json([\n 'responseCode' => '422',\n 'response' => 'Validation Error',\n 'data' => [\n 'errorCode' => '002',\n 'error' => 'Email no puede estar vacio'\n ]\n ], 422);\n }\n if($request->input('mensaje')){\n $data->mensaje = $request->input('mensaje');\n }else{\n return response()->json([\n 'responseCode' => '422',\n 'response' => 'Validation Error',\n 'data' => [\n 'errorCode' => '003',\n 'error' => 'mensaje no puede estar vacio'\n ]\n ], 422);\n }\n try \n {\n $data->save();\n return response()->json(['responseCode' => 200, 'response' => 'OK', 'data' => $data], 200); \n } \n catch (Exception $e) \n {\n return response()->json([\n 'responseCode' => '500',\n 'response' => 'Internal Server Error',\n 'data' => [\n 'errorCode' => 'Error-1',\n \/\/\"exception\" => $e->getMessage(),\n 'errorMessage' => 'Error storing Opinions'\n ]\n ], 500);\n }\n }\n public function update($id, Request $request){\n try\n {\n $data = Opinion::where('id',$id)->first();\n }\n catch (Exception $e)\n {\n return response()->json([\n 'responseCode' => '500',\n 'response' => 'Internal Server Error',\n 'data' => [\n 'errorCode' => 'Error-1',\n \/\/\"exception\" => $e->getMessage(),\n 'errorMessage' => 'Error getting Opinions'\n ]\n ], 500);\n }\n if($request->input('nombre')){\n $data->nombre = $request->input('nombre');\n }else{\n return response()->json([\n 'responseCode' => '422',\n 'response' => 'Validation Error',\n 'data' => [\n 'errorCode' => '001',\n 'error' => 'Nombre no puede estar vacio'\n ]\n ], 422);\n }\n if($request->input('email')){\n $data->email = $request->input('email');\n }else{\n return response()->json([\n 'responseCode' => '422',\n 'response' => 'Validation Error',\n 'data' => [\n 'errorCode' => '002',\n 'error' => 'Email no puede estar vacio'\n ]\n ], 422);\n }\n if($request->input('mensaje')){\n $data->mensaje = $request->input('mensaje');\n }else{\n return response()->json([\n 'responseCode' => '422',\n 'response' => 'Validation Error',\n 'data' => [\n 'errorCode' => '003',\n 'error' => 'mensaje no puede estar vacio'\n ]\n ], 422);\n }\n try \n {\n $data->save();\n return response()->json(['responseCode' => 200, 'response' => 'OK', 'data' => $data], 200); \n } \n catch (Exception $e) \n {\n return response()->json([\n 'responseCode' => '500',\n 'response' => 'Internal Server Error',\n 'data' => [\n 'errorCode' => 'Error-1',\n \/\/\"exception\" => $e->getMessage(),\n 'errorMessage' => 'Error updating Opinions'\n ]\n ], 500);\n }\n }\n public function destroy($id){\n try\n {\n $data = Opinion::where('id',$id)->first();\n }\n catch (Exception $e)\n {\n return response()->json([\n 'responseCode' => '500',\n 'response' => 'Internal Server Error',\n 'data' => [\n 'errorCode' => 'Error-1',\n \/\/\"exception\" => $e->getMessage(),\n 'errorMessage' => 'Error getting Opinion'\n ]\n ], 500);\n }\n try \n {\n $data->delete();\n return response()->json(['responseCode' => 200, 'response' => 'OK', 'data' => $data], 200); \n } \n catch (Exception $e) \n {\n return response()->json([\n 'responseCode' => '500',\n 'response' => 'Internal Server Error',\n 'data' => [\n 'errorCode' => 'Error-1',\n \/\/\"exception\" => $e->getMessage(),\n 'errorMessage' => 'Error deleting Opinion'\n ]\n ], 500);\n }\n }\n}<\/code><\/pre>\n\n\nPaso 9<\/h3>\n
Editamos el archivo routes\/web.php y agregamos las rutas de la siguiente manera:<\/p>\n\n\n
<?php\n\n\/** @var \\Laravel\\Lumen\\Routing\\Router $router *\/\n\n\/*\n|--------------------------------------------------------------------------\n| Application Routes\n|--------------------------------------------------------------------------\n|\n| Here is where you can register all of the routes for an application.\n| It is a breeze. Simply tell Lumen the URIs it should respond to\n| and give it the Closure to call when that URI is requested.\n|\n*\/\n\n$router->get('\/', function () use ($router) {\n return $router->app->version();\n});\n\n$router->group(['prefix' => 'api'], function () use ($router) {\n\n $router->get('opinion\/all', ['uses' => 'OpinionController@index']);\n $router->get('opinion\/{id}', ['uses' => 'OpinionController@show']);\n $router->post('opinion', ['uses' => 'OpinionController@store']);\n $router->put('opinion\/{id}', ['uses' => 'OpinionController@update']);\n $router->delete('opinion\/{id}', ['uses' => 'OpinionController@destroy']);\n\n}<\/code><\/pre>\n\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
Proceso de instalacion paso a paso de un backend sencillo de una sola tabla de base de datos usando PHP framework Laravel Lumen version 10: Requisito previo obviamente en para este tutorial, tener Linux + Apache Server + PHP > 8.0 y Mysql server o Postgresql. Ademas, Laravel Lumen requiere que tengas instaladas de las […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/robetorr.com\/index.php\/wp-json\/wp\/v2\/posts\/199"}],"collection":[{"href":"https:\/\/robetorr.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/robetorr.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/robetorr.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/robetorr.com\/index.php\/wp-json\/wp\/v2\/comments?post=199"}],"version-history":[{"count":4,"href":"https:\/\/robetorr.com\/index.php\/wp-json\/wp\/v2\/posts\/199\/revisions"}],"predecessor-version":[{"id":203,"href":"https:\/\/robetorr.com\/index.php\/wp-json\/wp\/v2\/posts\/199\/revisions\/203"}],"wp:attachment":[{"href":"https:\/\/robetorr.com\/index.php\/wp-json\/wp\/v2\/media?parent=199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/robetorr.com\/index.php\/wp-json\/wp\/v2\/categories?post=199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/robetorr.com\/index.php\/wp-json\/wp\/v2\/tags?post=199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}