[MySQL][PHP]Jak czytać output komendy doctrine orm:schema-tool:update --dump-sql. Opcje

[szczrzcz]

Zrobiłem "reverse enginering" istniejącej bazy. Teraz komenda sprawdzająca czy encje pasują do bazy orm:validate-schema wywala:

Kod

--  [Mapping]  OK - The mapping files are correct.
--  [Database] FAIL - The database schema is not in sync with the current mapping file.

a

Kod

orm:schema-tool:update --dump-sql

pokazuje mi 60 wierszy ALTER, które wyglądają mniej więcej tak:

[SQL] pobierz, plaintext 
ALTER TABLE taxes CHANGE position position SMALLINT NOT NULL;
[SQL] pobierz, plaintext 

jak czytać powyższą sugestię jeśli teraz ta kolumna wygląda tak:

[SQL] pobierz, plaintext 
CREATE TABLE `taxes` (
  `position` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[SQL] pobierz, plaintext 

Ten post edytował szczrzcz 25.06.2017, 15:58:13

[nospor]

Masz dosc wyraznie napisane, ze aktualnie w bazie pozwalasz na POSITION by byla NULL. Zas w ENCJI ustawiles ze to pole nie moze byc NULL stad doctrine daje ci zapytania zmieniajace ten stan rzeczy

[szczrzcz]

a właśnie że w encji mam:

[PHP] pobierz, plaintext 
     * @ORM\Column(name="position", type="smallint", nullable=true)
     */
    private $position;
[PHP] pobierz, plaintext 

Ten post edytował szczrzcz 26.06.2017, 10:31:00

[nospor]

A co ci mowi:
doctrine:schema:update --dump-sql
?

[szczrzcz]

A co ci mowi:
doctrine:schema:update --dump-sql
?

napisałem w pierwszym poście

a pełny --dump-sql daje:

[SQL] pobierz, plaintext 
ALTER TABLE site_globals_translation CHANGE locale locale enum('en','pl','es','de','fr');
ALTER TABLE taxes CHANGE position position SMALLINT NOT NULL;
ALTER TABLE colors CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL;
ALTER TABLE gallery_desc CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE parent_id parent_id INT NOT NULL, CHANGE lang_id lang_id INT NOT NULL;
ALTER TABLE config CHANGE id id INT AUTO_INCREMENT NOT NULL;
ALTER TABLE languages CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE active active TINYINT(1) NOT NULL;
ALTER TABLE users CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE active active TINYINT(1) NOT NULL, CHANGE level level TINYINT(1) NOT NULL;
ALTER TABLE menu_translation CHANGE translatable_id translatable_id INT NOT NULL;
ALTER TABLE transport_service CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE courier_id courier_id INT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE order_transport CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE order_id order_id INT NOT NULL, CHANGE courier_id courier_id INT NOT NULL, CHANGE service_id service_id INT NOT NULL, CHANGE region_id region_id INT NOT NULL, CHANGE option_id option_id INT NOT NULL;
ALTER TABLE order_product CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE order_id order_id INT NOT NULL, CHANGE product_id product_id INT NOT NULL, CHANGE variation_id variation_id INT NOT NULL, CHANGE qty qty INT NOT NULL;
ALTER TABLE categories CHANGE show_expanded show_expanded TINYINT(1) NOT NULL;
ALTER TABLE product_variation CHANGE id2 id2 INT AUTO_INCREMENT NOT NULL, CHANGE product_id product_id INT NOT NULL, CHANGE tax_id tax_id INT NOT NULL, CHANGE qty qty INT NOT NULL;
ALTER TABLE gallery_photos CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE parent_id parent_id INT NOT NULL;
ALTER TABLE menu CHANGE parent_id parent_id INT NOT NULL, CHANGE `order` `order` TINYINT(1) NOT NULL;
ALTER TABLE news_desc CHANGE id2 id2 INT AUTO_INCREMENT NOT NULL, CHANGE parent_id parent_id INT NOT NULL, CHANGE lang_id lang_id INT NOT NULL;
ALTER TABLE pages_translation CHANGE translatable_id translatable_id INT NOT NULL;
ALTER TABLE transport_country CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE product_status CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE `order` `order` TINYINT(1) NOT NULL;
ALTER TABLE order_address CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE order_id order_id INT NOT NULL, CHANGE type type TINYINT(1) NOT NULL, CHANGE shipping_type shipping_type TINYINT(1) NOT NULL;
ALTER TABLE logistic_services CHANGE id id INT AUTO_INCREMENT NOT NULL;
ALTER TABLE frazy_promocyjne CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE max_uzyc max_uzyc INT NOT NULL;
ALTER TABLE news CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE gallery_id gallery_id INT NOT NULL, CHANGE active active TINYINT(1) NOT NULL;
ALTER TABLE product_manufacturer CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE status_id status_id INT NOT NULL, CHANGE popular popular TINYINT(1) NOT NULL, CHANGE `order` `order` INT NOT NULL;
ALTER TABLE transport_courier CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE transport_type CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE newsletter_users CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE lang_id lang_id TINYINT(1) NOT NULL;
ALTER TABLE transport_service_option CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE region_id region_id INT NOT NULL, CHANGE service_id service_id INT NOT NULL, CHANGE tax_id tax_id INT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE slider CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE `order` `order` INT NOT NULL;
ALTER TABLE payment CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE `order` `order` TINYINT(1) NOT NULL, CHANGE active active TINYINT(1) NOT NULL;
ALTER TABLE contact CHANGE id id INT AUTO_INCREMENT NOT NULL;
ALTER TABLE unitTransport_transport_groups_units CHANGE transport_group_id transport_group_id INT AUTO_INCREMENT NOT NULL;
ALTER TABLE product_translation CHANGE translatable_id translatable_id INT NOT NULL;
ALTER TABLE frazy_promocyjne_uzycia CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE id_frazy id_frazy INT NOT NULL, CHANGE id_zam id_zam INT NOT NULL, CHANGE id_user id_user INT NOT NULL;
ALTER TABLE transport_region CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE courier_id courier_id INT NOT NULL, CHANGE type_id type_id INT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE modules CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE type type TINYINT(1) NOT NULL;
ALTER TABLE pages CHANGE gallery_id gallery_id INT NOT NULL;
ALTER TABLE newsletter_templates CHANGE id id INT AUTO_INCREMENT NOT NULL;
ALTER TABLE transport_region_country CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE region_id region_id INT NOT NULL, CHANGE country_id country_id INT NOT NULL;
ALTER TABLE order_status CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE `order` `order` TINYINT(1) NOT NULL;
ALTER TABLE comments CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE parent_id parent_id INT NOT NULL, CHANGE customer_id customer_id INT NOT NULL, CHANGE lang_id lang_id INT NOT NULL;
ALTER TABLE transport_region_postcode CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE region_id region_id INT NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL;
ALTER TABLE `order` CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE customer_id customer_id INT NOT NULL, CHANGE lang_id lang_id INT NOT NULL, CHANGE price price NUMERIC(10, 4) NOT NULL, CHANGE discount discount NUMERIC(5, 0) NOT NULL, CHANGE phrase_id phrase_id INT NOT NULL, CHANGE payment_id payment_id TINYINT(1) NOT NULL, CHANGE status_id status_id TINYINT(1) NOT NULL, CHANGE time_payment time_payment DATETIME NOT NULL, CHANGE time_complete time_complete DATETIME NOT NULL;
ALTER TABLE product CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE category_id category_id INT NOT NULL, CHANGE producer_id producer_id INT NOT NULL, CHANGE status_id status_id INT NOT NULL, CHANGE type type VARCHAR(255) NOT NULL;
ALTER TABLE gallery CHANGE id id INT AUTO_INCREMENT NOT NULL;
ALTER TABLE slider_translation CHANGE translatable_id translatable_id INT NOT NULL;
ALTER TABLE transport_region_service CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE region_id region_id INT NOT NULL, CHANGE service_id service_id INT NOT NULL;
ALTER TABLE logotypes CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE `order` `order` INT NOT NULL;
ALTER TABLE product_image CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE product_id product_id INT NOT NULL, CHANGE ga_image_id ga_image_id INT NOT NULL, CHANGE `order` `order` INT NOT NULL;
ALTER TABLE api_shop_log CHANGE date_add date_add DATETIME NOT NULL;
ALTER TABLE customer CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE type type TINYINT(1) NOT NULL, CHANGE country country TINYINT(1) NOT NULL, CHANGE discount discount NUMERIC(4, 2) NOT NULL, CHANGE price_group price_group TINYINT(1) NOT NULL, CHANGE sales_representative sales_representative INT NOT NULL;
ALTER TABLE unitTransport_units CHANGE length length INT NOT NULL, CHANGE width width INT NOT NULL, CHANGE height height INT NOT NULL, CHANGE price price NUMERIC(5, 2) NOT NULL;
[SQL] pobierz, plaintext 

[nospor]

napisałem w pierwszym poście

Nie, w pierwszym poscie napisales wynik dla komendy
orm:schema-tool:update --dump-sql

Ja cie zdaje sie pytalem o wynik innej komendy, nieprawdaz?

[szczrzcz]

niby prawdaż, a jednak to to samo. U mnie wszystkie komendy doctrinowe rozpoczynają się od "orm:" zamiast "doctrine:"

Kod

orm:schema:update --dump-sql

daje ten sam wynik co:

Kod

orm:schema-tool:update --dump-sql

[nospor]

No widzisz, mozna bylo tak od razu zamiast nerwow

Ja u siebie jak ustawiam w encji
nullable=true
to mam default null

jak ustawie
nullable=false
to mam not null

Skoro dziala u mnie, powinno dzialac i u ciebie. Jestes pewien ze sprawdzasz poprawna encje? Wyczysciles tez cache?