MessagesSchema::createMessagesTable() - Code Metrics - Inspection of "Move other doctrine related resources to the doctr..." - bernardphp/bernard - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — drivers (#355)

by Márk

created 2018-02-13 21:44 UTC

MessagesSchema::createMessagesTable() A

↳ Parent: MessagesSchema

Complexity

Conditions	1
Paths	1

Size

Total Lines	16
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	16
rs	9.4285
c	0
b	0
f	0
cc	1
eloc	12
nc	1
nop	1

<?php

namespace Bernard\Driver\Doctrine;

use Doctrine\DBAL\Schema\Schema;

/**
 * @package Bernard
 */
class MessagesSchema
{
    /**
     * Creates tables on the current schema given.
     *
     * @param Schema $schema
     */
    public static function create(Schema $schema)
    {
        static::createQueueTable($schema);
        static::createMessagesTable($schema);
    }

    /**
     * Creates queue table on the current schema given.
     *
     * @param Schema $schema
     */
    protected static function createQueueTable(Schema $schema)
    {
        $table = $schema->createTable('bernard_queues');
        $table->addColumn('name', 'string');
        $table->setPrimaryKey(['name']);
    }

    /**
     * Creates message table on the current schema given.
     *
     * @param Schema $schema
     */
    protected static function createMessagesTable(Schema $schema)
    {
        $table = $schema->createTable('bernard_messages');
        $table->addColumn('id', 'integer', [
            'autoincrement' => true,
            'unsigned' => true,
            'notnull' => true,
        ]);

        $table->addColumn('queue', 'string');
        $table->addColumn('message', 'text');
        $table->addColumn('visible', 'boolean', ['default' => true]);
        $table->addColumn('sentAt', 'datetime');
        $table->setPrimaryKey(['id']);
        $table->addIndex(['queue', 'sentAt', 'visible']);
    }
}


1			<?php
2
3			namespace Bernard\Driver\Doctrine;
4
5			use Doctrine\DBAL\Schema\Schema;
6
7			/**
8			* @package Bernard
9			*/
10			class MessagesSchema
11			{
12			/**
13			* Creates tables on the current schema given.
14			*
15			* @param Schema $schema
16			*/
17			public static function create(Schema $schema)
18			{
19			static::createQueueTable($schema);
20			static::createMessagesTable($schema);
21			}
22
23			/**
24			* Creates queue table on the current schema given.
25			*
26			* @param Schema $schema
27			*/
28			protected static function createQueueTable(Schema $schema)
29			{
30			$table = $schema->createTable('bernard_queues');
31			$table->addColumn('name', 'string');
32			$table->setPrimaryKey(['name']);
33			}
34
35			/**
36			* Creates message table on the current schema given.
37			*
38			* @param Schema $schema
39			*/
40			protected static function createMessagesTable(Schema $schema)
41			{
42			$table = $schema->createTable('bernard_messages');
43			$table->addColumn('id', 'integer', [
44			'autoincrement' => true,
45			'unsigned' => true,
46			'notnull' => true,
47			]);
48
49			$table->addColumn('queue', 'string');
50			$table->addColumn('message', 'text');
51			$table->addColumn('visible', 'boolean', ['default' => true]);
52			$table->addColumn('sentAt', 'datetime');
53			$table->setPrimaryKey(['id']);
54			$table->addIndex(['queue', 'sentAt', 'visible']);
55			}
56			}
57

bernardphp / bernard

GitHub Access Token became invalid

Pull Request — drivers (#355)

MessagesSchema::createMessagesTable() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like