model - Multiple M2M in django -

-

i have 2 models in django 2d map based game:

class block(models.model):    type = models.integerfield()  class shopbuilding(models.model):    house_blocks = models.manytomanyfield(block)    street_blocks = models.manytomanyfield(block)    river_blocks = models.manytomanyfield(block)    decoration_blocks = models.manytomanyfield(block)    npc_blocks = models.manytomanyfield(block)

now want associate these 2 models using 1 table:

class shopblockassoc(models.model):     block = models.foreignkey(block)     shop = models.foreignkey(shop)

after set through field in shopbuilding model, django yiled multiple fails when syncdb, like

    error: 1 or more models did not validate: tnew.shopbuilding: accessor m2m field 'house_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'house_blocks'. tnew.shopbuilding: accessor m2m field 'house_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'house_blocks'. tnew.shopbuilding: accessor m2m field 'house_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'house_blocks'. tnew.shopbuilding: accessor m2m field 'house_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'house_blocks'. tnew.shopbuilding: accessor m2m field 'street_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'street_blocks'. tnew.shopbuilding: accessor m2m field 'street_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'street_blocks'. tnew.shopbuilding: accessor m2m field 'street_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'street_blocks'. tnew.shopbuilding: accessor m2m field 'street_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'street_blocks'. tnew.shopbuilding: accessor m2m field 'river_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'river_blocks'. tnew.shopbuilding: accessor m2m field 'river_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'river_blocks'. tnew.shopbuilding: accessor m2m field 'river_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'river_blocks'. tnew.shopbuilding: accessor m2m field 'river_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'river_blocks'. tnew.shopbuilding: accessor m2m field 'decoration_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'decoration_blocks'. tnew.shopbuilding: accessor m2m field 'decoration_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'decoration_blocks'. tnew.shopbuilding: accessor m2m field 'decoration_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'decoration_blocks'. tnew.shopbuilding: accessor m2m field 'decoration_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'decoration_blocks'. tnew.shopbuilding: accessor m2m field 'npc_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'npc_blocks'. tnew.shopbuilding: accessor m2m field 'npc_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'npc_blocks'. tnew.shopbuilding: accessor m2m field 'npc_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'npc_blocks'. tnew.shopbuilding: accessor m2m field 'npc_blocks' clashes related m2m field 'block.shopbuilding_set'. add related_name argument definition 'npc_blocks'.

if set db_table field django says:

the model has 2 manually-defined m2m relations through model, not permitted. please consider using field on intermediary model instead.

how fix this? want make sure shop-block relations using sharing same intermediate associate model same db_table

the problem on model block tries create backwards links. django names links based on model, in case manytomany tries create shopbuilding_set , names collide. avoid add related_name, example:

class shopbuilding(models.model):    house_blocks = models.manytomanyfield(block, related_name="shopbuilding_house_set")    street_blocks = models.manytomanyfield(block, related_name="shopbuilding_street_set")    river_blocks = models.manytomanyfield(block, related_name="shopbuilding_river_set")    decoration_blocks = models.manytomanyfield(block, related_name="shopbuilding_decoration_set")    npc_blocks = models.manytomanyfield(block, related_name="shopbuilding_npc_set")

then you'll able access shopbuilding block instance this:

block.shopbuilding_npc_set.all()


Comments

Post a Comment

Popular posts from this blog

delphi - How to convert bitmaps to video? -

-
Image
my application creates images fractals , love feeling of 'flying' around fractal. once saved 2000 bitmaps file , created avi using premiere. experience rather frustrating though succeeded in creating movie. spectacular. of course want create video application. don't care niftyness of codec, compression or whatever. want have video can replay on systems. in past have tried never succeeded. triggered question alas not ffmpeg running. update i decided adapt question , put bounty it. have seen several solutions attractive (because it's simple) seems me taviwrite. tried taviwriter did not succeed. in procedure taviwriter.write; function call around line 370 avierr := avisavev(s, // pchar(filename), nil, // file handler nil, // callback nstreams, // number of streams streams, compoptions); // compress options
Read more

jasper reports - Fixed header in Excel using JasperReports -

-
how can create excel report fixed header using japserreports? mean need header fixed when scroll excel file. this possible adding couple properties in jrxml file each report. take @ advanced excel features freeze panes. if wanted freeze after first column header (down left side basically) this: <statictext> <reportelement style="sans_bold" mode="opaque" x="0" y="60" width="104" height="20" forecolor="#ffffff" backcolor="#666666"> <property name="net.sf.jasperreports.export.xls.auto.filter" value="start"/> <property name="net.sf.jasperreports.export.xls.column.width" value="110"/> <property name="net.sf.jasperreports.export.xls.freeze.column.edge" value="left"/> </reportelement> &
Read more

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