drudbal

KO | EN

gitlite — search

#python #hacktoberfest #golang #go #rust #docker #macos #windows #awesome #vue #awesome-list #security #ios #open-source

(★ 8)

Drupal database driver for Doctrine DBAL

drudbal 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# DruDbal
[![MySql via PDO](https://github.com/mondrake/drudbal/actions/workflows/mysql.yml/badge.svg)](https://github.com/mondrake/drudbal/actions/workflows/mysql.yml)
[![MySql via mysqli](https://github.com/mondrake/drudbal/actions/workflows/mysqli.yml/badge.svg)](https://github.com/mondrake/drudbal/actions/workflows/mysqli.yml)
[![SQLite via PDO](https://github.com/mondrake/drudbal/actions/workflows/sqlite.yml/badge.svg)](https://github.com/mondrake/drudbal/actions/workflows/sqlite.yml)
[![Oracle via oci8](https://github.com/mondrake/drudbal/actions/workflows/oracle.yml/badge.svg)](https://github.com/mondrake/drudbal/actions/workflows/oracle.yml)
[![PHPStan level](https://img.shields.io/badge/PHPStan%20level-5-brightgreen.svg?style=flat)](https://github.com/mondrake/drudbal/actions/workflows/code-quality.yml)
[![License](https://img.shields.io/github/license/mondrake/drudbal.svg)](https://packagist.org/packages/mondrake/drudbal)

(This README updated March 30, 2020)

An __experimental__ Drupal database driver for Doctrine DBAL. __Do not use if not for trial. No support, sorry :)__

| Requires            | Minimum version |
|---------------------|-----------------|
| Drupal              | 11.x            |
| Doctrine DBAL       | 4               |
| Drush               | 13.x            |
| PHP                 | 8.3             |

## Concept
The concept is to use Doctrine DBAL as an additional database abstraction
layer. The code of the DBAL Drupal database driver is meant to be 'database
agnostic', i.e. the driver should be able to execute on any db platform that
DBAL supports (in theory, practically there still need to be db-platform
specific hacks through the concept of DBAL extensions, see below).

The Drupal database ```Connection``` class that this driver implements opens
a ```DBAL\Connection```, and hands over statements' execution to it.
```DBAL\Connection``` itself wraps a lower level driver connection (```PDO```
for pdo_mysql and pdo_sqlite drivers, ```mysqli``` for the mysqli driver).
Similarly, the ```StatementWrapper``` wraps a ```DBAL\Statement```, which itself
wraps a DBAL-driver level ```Statement```.
The DBAL connection provides additional features like the Schema Manager
that can introspect a database schema and build DDL statements, a Query
Builder that can build SQL statements based on the database platform in use,
etc. etc.

To overcome DBAL limitations and/or fit Drupal specifics, the DBAL Drupal
database driver also instantiates an additional object called
```DBALExtension```, unique for the DBAL Driver in use, to which some
operations that are db- or Drupal-specific are delegated.

## Status

The code in the ```master``` branch is working on a __MySql database__, using
either the 'mysql' or the 'mysqli' DBAL drivers, on a __SQlite database__, using
the 'sqlite' DBAL driver, or on a __Oracle database__ using the 'oci8' database
driver.

'Working' means:
1. it is possible to install a Drupal site via the installer, selecting
   'Doctrine DBAL' as the database of choice;
2. it is passing a selection of core PHPUnit tests , executed on GitHub Actions
   CI. The latest patches for the issues listed in 'Related Drupal issues' below
   need to be applied to get a clean test run.

## Installation

Very rough instructions to install Drupal from scratch with this db driver
under the hood:

1. Get the DruDbal module from Packagist via Composer, it will install Doctrine
   DBAL as well:
  ```
  $ composer require mondrake/drudbal:dev-master
  ```

2. Launch the interactive installer. Proceed as usual and when on the db
   selection form, select 'Doctrine DBAL' and enter a 'database URL' compliant
   with Doctrine DBAL syntax. __Note:__ the driver works only with _mysql,
   mysqli, oci8 or sqlite_ DBAL drivers.

![configuration](https://cloud.githubusercontent.com/assets/1174864/24586418/7f86feb4-17a0-11e7-820f-eb1483dad07f.png)

3. If everything goes right, when you're welcomed to the new Drupal
   installation, visit the Status Report. The 'database' section will report
   something like:

![status_report](https://user-images.githubusercontent.com/1174864/29685128-ca25375c-8914-11e7-8305-9ba369f68067.png)

## Related DBAL issues/PRs
Issue                                            | Description                                                                  | Info           |
-------------------------------------------------|------------------------------------------------------------------------------|----------------|
https://github.com/doctrine/dbal/issues/1349     | DBAL-182: Insert and Merge Query Objects                                     |                |
https://github.com/doctrine/dbal/issues/1320     | DBAL-163: Upsert support in DBAL                                             |                |
https://github.com/doctrine/dbal/pull/2762       | Bulk inserts                                                                 |                |
https://github.com/doctrine/dbal/issues/1033     | DBAL-1096: schema-tool:update does not understand columnDefinition correctly |                |
https://github.com/doctrine/migrations/issues/17 | Data loss on table renaming.                                                 |                |
https://github.com/doctrine/dbal/pull/2415       | Add some MySQL platform data in Tables                                       | fixed in 2.9.0 |

## Related Drupal issues
Issue                                                           | Description                                                                                                                             |
----------------------------------------------------------------|-------------------------------------------------------------------------------------------------------------------------------------------|
tbd                                                             | Add tests for Upsert with default values |
tbd                                                             | Ensure that when INSERTing a NULL value in a database column, SELECTing it back returns NULL and not empty string - for all fetch modes |
tbd                                                             | UpdateTestBase::runUpdate should reset database schema after updating  |
[#2992274](https://www.drupal.org/project/drupal/issues/2992274) | Installer tests fail if contrib driver hides database credentials form fields |

drudbal

drudbal 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

drudbal

drudbal 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README