php - Auto generate Doctrine-Entity from existing Table -


i'm trying auto generate entities from specific table of database. don't want send doctrine on whole database, because there tables in not compatible doctrine (like tables legacy database having no primary keys [yes...]).

unfortunately, blog posts , so-anwers doesn't help, parameter "--filter" isn't working supposed.

what i've done:

i tried first step so-answer , read blog post.

php app/console doctrine:mapping:convert metadata_format \     ./src/app/userbundle/resources/config/doctrine \     --from-database \     --filter="user"

i understood filter-argument solution filter specific table. filter not being applied. process gets canceled exception "table xyz has no primary key" (what true here , not part of question).

i guess create complete new database without problematic tables creating annotations , entities. i'm wondering written process , why not work.

update

i tried out suggestions first answer:

php app/console doctrine:mapping:import --force acmeblogbundle yml

acmeblogbundle placeholder real bundle. import task stops with:

[symfony\component\debug\exception\contexterrorexception]
warning: class_parents(): class action not exist , not loaded

the first table called "action". when drop table, stops simular exception @ next table.

update 2

the exception mentioned lines above caused due previous used orm-implementation having classes "actionentity.php" within directory called "entity" each table. thats why exception happened think. after dropped directory, exception disappeared (but isn't solution in case).

what did now: dropped foreign keys (they made troubles), setup new symfony project, run these comments first answer here , got pre-generated entity classes, without foreign keys implementation. things have add now, including several changes database scheme because doctrine 2 has restrictions here not supporting primary keys foreign keys , that. can pick entity-classes , adjust missing connections other entities.

all in all: whole process not satisfying ...

from documentation:

as doctrine tools documentation says, reverse engineering one-time process started on project. doctrine able convert approximately 70-80% of necessary mapping information based on fields, indexes , foreign key constraints. doctrine can't discover inverse associations, inheritance types, entities foreign keys primary keys or semantical operations on associations such cascade or lifecycle events. additional work on generated entities necessary afterwards design each fit domain model specificities.

right steps import entities database:

  1. php bin/console doctrine:mapping:import --force acmeblogbundle xml
  2. php bin/console doctrine:mapping:convert annotation ./src
  3. php bin/console doctrine:generate:entities acmeblogbundle

you can use xml or yml, worked only xml case.


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

ruby on rails - Seeing duplicate requests handled with Unicorn -

recently upgraded our ec2 instances c3.large in order boost more unicorn workers handle increased traffic our site. (6xworkers per machine - 2 ec2 instances). when did this, started seeing duplicate records being created! looks somehow, maybe 2 unicorn workers attempting process same request? in nginx logs see 1 [post] request particular rails controller - yet 2 records being created in database. i'm hitting kind of race condition issue - have no idea how debug this. doesn't happen time, when it's frustrating well. noticed 2 database records within 5 seconds of each other. (and yes disable button when user clicks submit button). unicorn 4.8.2 ruby 1.9.3 rails 3.2.14 any great! thanks! although may not fix problem, upgrade ruby 2.0.0. there blog mentioning idea upgrade ruby 2.0.0 if using unicorn. for example: https://www.digitalocean.com/community/articles/how-to-optimize-unicorn-workers-in-a-ruby-on-rails-app specifically: if using ruby 1.9, ...
Read more