php - Generated unique key in relational doctrine -

-

i trying create onetomany relation between answers , questions tables in doctrine. these basic yaml schemas

answer schema

  type: entity   table: fs_answer   fields:     id:       id: true       type: integer       unsigned: false       nullable: false       generator:         strategy: identity     questionid:       type: integer       unsigned: false       nullable: false       column: question_id     body:       type: text       nullable: false   onetoone:     question:       targetentity: fsquestion       cascade: {  }       mappedby: null       inversedby: null       joincolumns:     question_id:       referencedcolumnname: id       orphanremoval: false   lifecyclecallbacks: {  }

question schema:

  type: entity   table: fs_question   fields:     id:       id: true       type: integer       unsigned: false       nullable: false       generator:         strategy: identity     body:       type: text       nullable: false   onetomany:     answer:       targetentity: fsanswer       cascade: {  }       mappedby: question       inversedby: answers       joincolumns:     question_id:       referencedcolumnname: id       orphanremoval: false   lifecyclecallbacks: {  }

when update schema doctrine:schema:update, generated sql code below , put unique key 'question_id' in answers table.

create table if not exists `fs_answer` (   `id` int(11) not null auto_increment,   `question_id` int(11) not null,   `body` longtext not null,   primary key (`id`),   unique key `uniq_552d082b1e27f6bf` (`question_id`) ) engine=innodb  default charset=utf8 auto_increment=1;

how avoid unique key stuff? logically (one many) there should not unique key question id in answers table.

actually simple code below

question:

onetomany:   answer:     targetentity: fsanswer     mappedby: question     cascade: ["persist"]

answer:

manytoone:   question:     targetentity: fsquestion     inversedby: answer

Comments

Post a Comment

Popular posts from this blog

python - ('The SQL contains 0 parameter markers, but 50 parameters were supplied', 'HY000') or TypeError: 'tuple' object is not callable -

-
import pyodbc,nltk,array cnxn = pyodbc.connect('driver={mysql odbc 5.1 driver};server=127.0.0.1;port=3306;database=information_schema;user=root; password=1234;option=3;') cursor = cnxn.cursor() cursor.execute("use collegedatabase ;") cursor.execute("select * sampledata ; ") cnxn.commit() s=[] j=[] x=[] words = [] w = [] sfq = [] pos=[] entry in cursor: s.append(entry.injury_type),j.append(entry.injury_desc) nltk.tokenize import punktwordtokenizer nltk.corpus import stopwords tokenizer = punktwordtokenizer() english_stops = set(stopwords.words('english')) in range(0,26): # filter stop words tokenizer.tokenize(j[i]) w.append([word word in tokenizer.tokenize(j[i]) if word not in english_stops]) in range(0 , 26):#converting tokenzied text ito string sfq.append(" ".join(w[a])) replacers import regexpreplacer replacer = regexpreplacer() in range (0,26):#pos tagging replacer.repl...
Read more

c# - Getting per connection bandwidth statistics -

-
i need determine per-process network usage statistics similar tcpview can do. example http://img513.imageshack.us/img513/861/6601f15814544055a590e26.png so before shoot me posting duplicate of this question , or this question , point out neither of have thorough answer me this. i've been doing research, , there many ways list out active connections , associated processes, whether netstat or other windows api's iphlpapi.dll . now, google'ing i've done, have not found - except these vague terms: getpertcpconnectionestats , getpertcp6connectionestats . presumably tcp on ipv4 , ipv6 respectively. reading supposedly able need do. however, still leaves out udp. , not available on xp systems, tcpviewer works on. i satisfied using tcp, problem is, can't seem find examples of how use them c#. so guess boils down these few questions: does know how tcpview it? how use getpertcpconnectionestats tcp? or can accomplish i'm suggesting? is there known alte...
Read more

jquery - ajax and php updating mysql -

-
i having problem updating database. basically trying everytime download link clicked download count in database goes up. can point me in right direction have been trying right hours :( here html. <div class="button_border_dark"> <a id="linkcounter" href="http://www.derby-web-design-agency.co.uk/freeby-download/<?php echo $freebies_download ; ?>" target="_blank" title="download">click download file</a></div> here jquery <script> $('#linkcounter').bind('click',function(){ $.post("downloadcount.php",{ linkid: <?php echo $id ; ?>}); }); </script> here downloadcount.php trying post data too, updates content. <?php require_once("applications/constants/connection.php"); require_once("applications/controllers/basic.php"); if(isset($_request["linkid"])){ $linkid = sanitise($_post["linkid"]); $updatedownlo...
Read more