pomm-project/Cli

Name: Cli

Owner: pomm project

Description: Command line interface for Pomm project.

Created: 2014-10-07 15:54:11.0

Updated: 2018-02-19 11:22:22.0

Pushed: 2018-01-12 14:37:25.0

Homepage: null

Size: 239

Language: PHP

GitHub Committers

UserMost Recent Commit# Commits

Other Committers

UserEmailMost Recent Commit# Commits

README

Cli

This is the Cli component for the Pomm database framework.

Latest Stable Version Scrutinizer Code Quality Build Status Monthly Downloads License

Configuration

Pomm's Cli is independent from one's development environment, it does not know what configuration types and files are used in the project. To make the Cli work, it is necessary to create a plain PHP bootstrap file that returns a Pomm instance. By default it is named .pomm_cli_bootstrap.php. If the project already has a script that returns a configured Pomm instance, it is possible to specify it to the Cli using the option -b|--bootstrap-file="...".

Database inspection

The inspect command uses the Foundation.Inspector to display information about the database structure.

Found 3 relations in schema 'public'. +————-+——-+——–+———+ | name | type | oid | comment | +————-+——-+——–+———+ | pika | view | 126516 | pika | | test_unique | table | 127619 | | | worker | table | 126525 | | +————-+——-+——–+———+

$ ./bin/pomm.php pomm:inspect:relation archived_document my_db_config pylone

Relation pylone.archived_document +—-+————-+———–+———+———+———+ | pk | name | type | default | notnull | comment | +—-+————-+———–+———+———+———+ | * | document_id | uuid | | yes | | | | title | varchar | | yes | | | | archived_at | timestamp | now() | yes | | | * | version | int4 | | yes | | | | usable | bool | | no | | +—-+————-+———–+———+———+———+

ode generation

`generate` commands create PHP class for use of database relations with Pomm's ModelManager package.

omm:generate:structure    - Generate a RowStructure class according to the relation structure.
omm:generate:model        - Generate a new configured Model class.
omm:generate:entity       - Generate an empty FlexibleEntity class.
omm:generate:relation-all - Generate the 3 files above for the given relation.
omm:generate:schema-all   - Generate the 3 files above for every relation in the given schema.

e you are going to add your own methods in the generated Model and FlexibleEntity classes, they will NOT be overwritten by default by the `generate` commands. It is somehow possible to do so by implicitly specifying the option `--force`. All the code in the overwritten classes will then be lost and replaced by a brand new class. Structure files are always overwritten without prior asking for confirmation. To avoid mixing these two kinds of classes, Structure classes are saved under a `AutoStructure` subdirectory.

Prefixes options

efault, Pomm's ModelManager expects at least the classes to be saved using the following namespaces: `DatabaseConfigName\SchemaSchema`. It is possible to tell the Cli where this structure starts and how to tune it.

--prefix-dir`, `-d` - indicates where to start the Namespace directory tree.
--prefix-ns`, `-a`  - indicates an optional namespace prefix.

 no options are specified, generating all relations of public schema will act like the following:

$ ./bin/pomm.php pomm:generate:schema-all -v pomm_test ? Creating file './PommTest/PublicSchema/AutoStructure/Pika.php'. ? Creating file './PommTest/PublicSchema/PikaModel.php'. ? Creating file './PommTest/PublicSchema/Pika.php'. ? Creating file './PommTest/PublicSchema/AutoStructure/TestUnique.php'. ? Creating file './PommTest/PublicSchema/TestUniqueModel.php'. ? Creating file './PommTest/PublicSchema/TestUnique.php'. ? Creating file './PommTest/PublicSchema/AutoStructure/Worker.php'. ? Creating file './PommTest/PublicSchema/WorkerModel.php'. ? Creating file './PommTest/PublicSchema/Worker.php'.

$ tree PommTest PommTest/ ??? PublicSchema

??? AutoStructure
?   ??? Pika.php
?   ??? TestUnique.php
?   ??? Worker.php
??? PikaModel.php
??? Pika.php
??? TestUniqueModel.php
??? TestUnique.php
??? WorkerModel.php
??? Worker.php

2 directories, 9 files

s often not a good idea to have the model's namespace starting at project's root directory. Most of the time, it is put in a `Model` namespace under `sources/lib` directory:

$ ./bin/pomm.php pomm:generate:schema-all –prefix-dir sources/lib –prefix-ns Model pomm_test ? Creating file 'sources/lib/Model/PommTest/PublicSchema/AutoStructure/Pika.php'. ?


This work is supported by the National Institutes of Health's National Center for Advancing Translational Sciences, Grant Number U24TR002306. This work is solely the responsibility of the creators and does not necessarily represent the official views of the National Institutes of Health.