doctrine-utc-date-time's Introduction

Doctrine UTC Date Time

Introduction

Component contains DBAL types for date and time and can be registered as Doctrine types. DBAL types provides functionality for storing date and time into database in the UTC. List of the available types:

Installation

Open a command console, enter your project directory and execute the following command to download the latest stable version of this component:

    composer require adrenalinkin/doctrine-utc-date-time

This command requires you to have Composer install globally.

Usage

For registration new Doctrine type use official instruction How to Use Doctrine DBAL.

For registration new separate UTC types:

# app/config/config.yml
doctrine:
    dbal:
        types:
            utc_date:     Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcDateType
            utc_datetime: Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcDateTimeType
            utc_time:     Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcTimeType

Also, you can overwrite standard types:

# app/config/config.yml
doctrine:
    dbal:
        types:
            date:     Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcDateType
            datetime: Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcDateTimeType
            time:     Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcTimeType

License

doctrine-utc-date-time's People

Contributors

Stargazers

Watchers

doctrine-utc-date-time's Issues

Add tests and linter

TypeError in PHP 8.1 Caused by Datetime::Createfromformat() Returning False

We ran into the following exception.

Uncaught TypeError: Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcDateTimeType::convertToPHPValue(): Return value must be of type ?DateTimeInterface, bool returned in /srv/....

According to the PHP documentation, DateTime::createFromFormat() can return false, which conflicts with the specified return type.

Deprecation warnings with latest doctrine bundle

Doctrine first moans about not having 'commented: true' in the config. If that is set, it then says:

php.INFO: User Deprecated: The type "date" was marked as commented in its configuration but not in the type itself. This is deprecated and will be removed in DoctrineBundle 2.0. Please update the return value of "Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcDateType::requiresSQLCommentHint()." {"exception":"[object] (ErrorException(code: 0): User Deprecated: The type "date" was marked as commented in its configuration but not in the type itself. This is deprecated and will be removed in DoctrineBundle 2.0. Please update the return value of "Linkin\Component\DoctrineUTCDateTime\DBAL\Types\UtcDateType::requiresSQLCommentHint()." at .../vendor/doctrine/doctrine-bundle/ConnectionFactory.php:140)"} []

I think, the three type classes should add method requiresSQLCommentHint() and return true to get rid of that deprecation warning. After that, 'commented: true' in config can be removed again, and the deprecation is gone.

adrenalinkin / doctrine-utc-date-time Goto Github PK

doctrine-utc-date-time's Introduction

Doctrine UTC Date Time

Introduction

Installation

Usage

License

doctrine-utc-date-time's People

Contributors

Stargazers

Watchers

Forkers

doctrine-utc-date-time's Issues

Add tests and linter

TypeError in PHP 8.1 Caused by Datetime::Createfromformat() Returning False

Deprecation warnings with latest doctrine bundle

Break PHP 5 support

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent