CRUD with Python ... IndexError: tuple index out of range -



CRUD with Python ... IndexError: tuple index out of range -

i have couple of selects , update using python. totally new @ language, , having bit of problem syntax when doing next (simple) queries:

select a.customer_name, a.customer_city, b.population contracts bring together cities b on a.customer_city = b.ident b.population <=500000 select a.ident, a.make, a.model, a.luxury, b.car_ident cars bring together contracts b on a.ident = b.car_ident luxury = 'y' update contracts set base_price=1000 contract_class >=10

i starting update...i figured shorter code.... when update statement, next error:

>'update {} set base_price = ? {}'.format(self._table), (row['base_price'], >row['where'])) >indexerror: tuple index out of range

here's have methods

def retrieve(self, key): cursor = self._db.execute('select {}'.format(self._table)) homecoming dict(cursor.fetchone()) def update(self, row): self._db.execute( 'update {} set base_price = ? {}'.format(self._table), (row['base_price'], row['where'])) self._db.commit() def disp_rows(self): cursor = self._db.execute('select ident, contract_class, base_price {} order base_price'.format(self._table)) row in cursor: print(' {}: {}: {}'.format(row['ident'], row['contract_class'], row['base_price'])) def __iter__(self): cursor = self._db.execute('select * {} order base_price'.format(self._table)) row in cursor: yield dict(row) def main(): db_cities = database(filename = 'insurance.sqlite', table = 'cities') db= database(filename = 'insurance.sqlite', table = 'contracts') db_cars = database(filename = 'insurance.sqlite', table = 'cars') print('retrieve rows') row in db: print(row) print('update rows') db.update({'where': 'contract_class' >= 10', 'base_price'= 1000}) row in db: print(row) print('retrieve rows after update') row in db: print(row) in advance help!

you misplaced bracket after self._table.

class="lang-py prettyprint-override">'update {table_name} set base_price = {base_price} {condition}'.format( table_name=self._table, base_price=row['base_price'], condition=row['where'] )

i did little code cleanup.

another question: why aren't using orm?

python crud

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more