流明 - mongodb - jenssegers/laravel-mongodb - 邮递员

2022-01-22 00:00:00 api mongodb postman php lumen

我已经在我的 wamp 上安装了 mongodb,C:wamp64inmongodbmongodb.3.4in,我已经在路径中添加了 mongodb,并在必要时创建了 windows 服务来启动它.我已经通过composer安装了lumen,之后我安装了:

i have install mongodb on my wamp, C:wamp64inmongodbmongodb.3.4in, i have add mongodb in the path, and create windows service to launch it when necessary. I have install lumen through composer, and after that i have install:

  • "laravel/lumen-framework": "5.3.*",
  • "barryvdh/laravel-ide-helper": "v2.2.1",
  • jenssegers/laravel-mongodb:v3.1.3"
  • jenssegers/mongodb-session":v1.1.0"

最后我已经在我的 wamp php 上安装了 mongodb.dll 并在 php.ini 中添加了 extension=php_mongodb.dll.现在 mongodb 上的扩展是活跃的.

Finaly i have install mongodb.dll on my wamp php and add extension=php_mongodb.dll inside the php.ini. And now the extension on mongodb is active.

这是我的用户类:

这是我的迁移

    <?php

    use IlluminateSupportFacadesSchema;
    use JenssegersMongodbSchemaBlueprint;
    use IlluminateDatabaseMigrationsMigration;

    class CreateUsersTable extends Migration
    {
        /**
         * The name of the database connection to use.
         *
         * @var string
         */
        protected $connection = 'mongodb';

        /**
         * Run the migrations.
         *
         * @return void
         */
        public function up()
        {
            Schema::connection($this->connection)->
            table('Users', function (Blueprint $collection) {
                $collection->index('id');
                $collection->string('name');
                $collection->string('surname');
                $collection->unique('username');
                $collection->string('password',64);
                $collection->timestamps();
            });
        }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::connection($this->connection)
            ->table('Users', function (Blueprint $collection)
            {
                $collection->drop();
            });
    }
}`

这是 .env 文件

APP_ENV=local
APP_DEBUG=true
APP_KEY=
APP_TIMEZONE=UTC

DB_CONNECTION=mongodb
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=homestead
DB_USERNAME=homestead
DB_PASSWORD=secret

MONGODB_HOST=localhost
MONGODB_PORT=27017
MONGODB_USERNAME=joy
MONGODB_PASSWORD=mongo@ad@joy
MONGODB_DATABASE=brasserie
MONGODB_AUTHDATABASE=admin

CACHE_DRIVER=file
SESSION_DRIVER=file

我已经在根应用程序中创建了配置目录,并且我已经添加了一个 database.php 配置文件:

i have create config directory in the root app, and i have add a database.php config file:

<?php

return [

    /*
    |--------------------------------------------------------------------------
    | PDO Fetch Style
    |--------------------------------------------------------------------------
    |
    | By default, database results will be returned as instances of the PHP
    | stdClass object; however, you may desire to retrieve records in an
    | array format for simplicity. Here you can tweak the fetch style.
    |
    */

    'fetch' => PDO::FETCH_CLASS,

    /*
    |--------------------------------------------------------------------------
    | Default Database Connection Name
    |--------------------------------------------------------------------------
    |
    | Here you may specify which of the database connections below you wish
    | to use as your default connection for all database work. Of course
    | you may use many connections at once using the Database library.
    |
    */

    'default' => env('DB_CONNECTION', 'mongodb'),

    /*
    |--------------------------------------------------------------------------
    | Database Connections
    |--------------------------------------------------------------------------
    |
    | Here are each of the database connections setup for your application.
    | Of course, examples of configuring each database platform that is
    | supported by Laravel is shown below to make development simple.
    |
    |
    | All database work in Laravel is done through the PHP PDO facilities
    | so make sure you have the driver for your particular database of
    | choice installed on your machine before you begin development.
    |
    */

    'connections' => [



        'mongodb' => array(
            'driver'   => 'mongodb',
            'host'     => env('MONGODB_HOST', '127.0.0.1'),
            'port'     => env('MONGODB_PORT', 27017),
            'username' => env('MONGODB_USERNAME', 'root'),
            'password' => env('MONGODB_PASSWORD', 'testbrasserie'),
            'database' => env('MONGODB_DATABASE', 'synthese'),
           'options' => array(
                'db' => env('MONGODB_AUTHDATABASE', 'admin') //Sets the auth DB
            )//*/
        ),

    ],

    /*
    |--------------------------------------------------------------------------
    | Migration Repository Table
    |--------------------------------------------------------------------------
    |
    | This table keeps track of all the migrations that have already run for
    | your application. Using this information, we can determine which of
    | the migrations on disk haven't actually been run in the database.
    |
    */

    'migrations' => 'migrations',

    /*
    |--------------------------------------------------------------------------
    | Redis Databases
    |--------------------------------------------------------------------------
    |
    | Redis is an open source, fast, and advanced key-value store that also
    | provides a richer set of commands than a typical key-value systems
    | such as APC or Memcached. Laravel makes it easy to dig right in.
    |
    */

    'redis' => [

        'cluster' => env('REDIS_CLUSTER', false),

        'default' => [
            'host'     => env('REDIS_HOST', '127.0.0.1'),
            'port'     => env('REDIS_PORT', 6379),
            'database' => env('REDIS_DATABASE', 0),
            'password' => env('REDIS_PASSWORD', null),
        ],

    ],//*/

];

我已经启用了 eloquent、facades 和 jessenger 服务提供者.所以这是我的 boostrap/app.php:

I have enable eloquent, facades and jessenger Service provider. so this is my boostrap/app.php:

<?php

require_once __DIR__.'/../vendor/autoload.php';

try {
    (new DotenvDotenv(__DIR__.'/../'))->load();
} catch (DotenvExceptionInvalidPathException $e) {
    //
}

/*
|--------------------------------------------------------------------------
| Create The Application
|--------------------------------------------------------------------------
|
| Here we will load the environment and create the application instance
| that serves as the central piece of this framework. We'll use this
| application as an "IoC" container and router for this framework.
|
*/

$app = new LaravelLumenApplication(
    realpath(__DIR__.'/../')
);

$app->withFacades();

// $app->withEloquent();

/*
|--------------------------------------------------------------------------
| Register Container Bindings
|--------------------------------------------------------------------------
|
| Now we will register a few bindings in the service container. We will
| register the exception handler and the console kernel. You may add
| your own bindings here if you like or you can make another file.
|
*/

$app->singleton(
    IlluminateContractsDebugExceptionHandler::class,
    AppExceptionsHandler::class
);

$app->singleton(
    IlluminateContractsConsoleKernel::class,
    AppConsoleKernel::class
);

/*
|--------------------------------------------------------------------------
| Register Middleware
|--------------------------------------------------------------------------
|
| Next, we will register the middleware with the application. These can
| be global middleware that run before and after each request into a
| route or middleware that'll be assigned to some specific routes.
|
*/

// $app->middleware([
//    AppHttpMiddlewareExampleMiddleware::class
// ]);

// $app->routeMiddleware([
//     'auth' => AppHttpMiddlewareAuthenticate::class,
// ]);

/*
|--------------------------------------------------------------------------
| Register Service Providers
|--------------------------------------------------------------------------
|
| Here we will register all of the application's service providers which
| are used to bind services into the container. Service providers are
| totally optional, so you are not required to uncomment this line.
|
*/

$app->register(AppProvidersAppServiceProvider::class);
// $app->register(AppProvidersAuthServiceProvider::class);
// $app->register(AppProvidersEventServiceProvider::class);


if ($app->environment() !== 'production') {
    $app->register(BarryvdhLaravelIdeHelperIdeHelperServiceProvider::class);
}

//class_alias ('JenssegersMongodbEloquentModel', 'Moloquent');
$app->register('JenssegersMongodbMongodbServiceProvider');

$app->withEloquent();
/*
|--------------------------------------------------------------------------
| Load The Application Routes
|--------------------------------------------------------------------------
|
| Next we will include the routes file so that they can all be added to
| the application. This will provide all of the URLs the application
| can respond to, as well as the controllers that may handle them.
|
*/



$app->group(['namespace' => 'AppHttpControllers'], function ($app) {
    require __DIR__.'/../routes/web.php';
});

$app->configure('database');

return $app;

这是我的 UsersTableSeeder:

Here is my UsersTableSeeder:

我已经启动了 artisan migrate:install 然后 artisan migrate 最后是 artisan db:seed 似乎没问题,这是 mongo 内部的结果:

I have launch the artisan migrate:install then artisan migrate and finally artisan db:seed and it seems to be ok, here is the result inside mongo:

然后我创建了一个用户控制器

Then i have create a UserController

<?php
/**
 * Created by PhpStorm.
 * User: Joy_Admin
 * Date: 09/12/2016
 * Time: 23:23
 */

namespace AppHttpControllers;

use AppHttpControllersController;
use AppUser;
use IlluminateHttpRequest;
use IlluminateSupportFacadesHash;
use DB;


class UserController extends Controller
{


    /**
     * Pour recupérer tous les utilsateurs de la BD
     * @return IlluminateHttpJsonResponse
     */
    public function index()
    {
        $users = User::all();
        return response()->json($users);
    }

    /**
     * Pour recupérer tous les utilsateurs de la BD
     * @return IlluminateHttpJsonResponse
     */
    public function test()
    {

        return response()->json("it's ok");
    }

    /**
     * pour enregistrer un nouvel utilisateur dans la base de données
     * @param Request $request
     */
    public function create(Request $request)
    {

        $user = new User();

       $user->name = $request->input('name');
      $user->surname = $request->input('surname');
       $user->username = $request->input('username');
       $user->password = Hash::make($request->input('password'));
        $user->save();//*/


        DB::collection('Users')->insert([
            'name'     => 'name1',
            'surname' => 'surname1',
            'username'    => 'username1',
            'password' => Hash::make('password1')
        ]);
        return response()->json($user);

    }


    /**
     * On renvoit l'individu dans la BD
     * correspondant à l'id spécifié
     * @param $id
     * @return IlluminateHttpJsonResponse
     */
    public function get($id)
    {
        $user = User::find($id);

        return response()->json($user);
    }

    /**
     * Mettre à jour les informations sur un utilisateur de la BD
     * @param Request $request
     * @param $id
     * @return IlluminateHttpJsonResponse
     */
    public function update(Request $request,$id)
    {
        $user = User::find($id);

        $user->name = $request->input('name');
        $user->surname = $request->input('surname');
        $user->username = $request->input('username');
        $user->password = Hash::make($request->input('password'));

        $user->save();

        return response()->json($user);
    }

    public function delete($id)
    {
        $user = User::find($id);

        $user->delete();

        return response()->json('Success');

    }
}

最后更新我的路由/web.php

And finally update my routes/web.php

<?php

/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It is a breeze. Simply tell Lumen the URIs it should respond to
| and give it the Closure to call when that URI is requested.
|
*/

use AppHttpControllersUserController;



$app->get('/', function () use ($app) {
    return $app->version();
});

$app->get('/api/users','UserController@index');
$app->get('/api/users/{id}','UserController@get');
$app->post('/api/users','UserController@create');
$app->put('/api/users/{id}','UserController@update');
$app->delete('/api/users/{id}','UserController@delete');
$app->get('/api','UserController@test');

我已经启动邮递员,以便我可以测试我的应用程序,只有 /api 工作,所有其他路线都给我同样的错误

I have launch postman, so that i could test my app, only /api work, all the other route give me the same error

有人可以帮我解决这个问题吗?

Openssl 和 curl 在我的 wamp php 中处于活动状态.

Openssl and curl are active in my wamp php.

推荐答案

我已经解决了问题,在我的 .env 中,我有:

I have solve the problem, in my .env i was having:

CACHE_DRIVER=file
SESSION_DRIVER=file

但在我的项目中没有为它们配置,所以当我将其更改为

but in my project no configuration for them, so when i have change it into

CACHE_DRIVER=
SESSION_DRIVER=

现在一切正常.

相关文章