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

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

media player - Android: mediaplayer went away with unhandled events -

-
i need duration of audio file series of voice announcements need play app. have added audio files resources , play fine. sample code below works perfect intended purpose: return duration of audio files. here code: float getdurationofaudioresource(locationenum loc, context context){ float duration = 0; try { mediaplayer mp; mp = mediaplayer.create(context, getaudioresource(loc)); duration = mp.getduration(); mp.release(); mp = null; } catch (illegalstateexception e) {e.printstacktrace(); logerror(25, "testdescitem:fault::could not open mediaplayer object audio resource.");} return duration; } here's weird thing. code called in main activity prepares set of audio instructions given test. there no errors within activity. second activity called, long string of errors on logcat. 03-07 13:23:43.820: i/actionlogger(21435): gentest_info_test #0 created. 03-07 13:23:43.830: i/actionlogger(21435): gente
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