Search.setIndex({desctypes:{"0":"class","1":"method","2":"function","3":"exception","4":"attribute","5":"classmethod","6":"staticmethod"},terms:{simul:33,threadlocalmetadata:25,should_close_with_result:36,soliddb:11,interchang:36,four:[15,0,7,23],secondli:33,prefix:[0,11,32,33,14,25,36],sleep:35,myuppercasecompar:39,do_commit:36,a_tabl:0,whose:[0,14,8,17,38],undef:[0,40],msreal:11,illustr:[34,0,32,12,6,35,8,38,15,18],concret:[0,2,30,9,4,39,40],somewidget:0,under:[19,0,37,4,14,36,29,18],merchant:10,digit:11,everi:[0,34,25,38,7,40,29],rise:38,adodbapi:[15,37],jack:[0,12,38],appar:38,sqltext:25,cmd:3,unattach:7,drop_al:[25,18],factori:[4,12,36,26,28,29],child_tabl:0,math:14,require_embed:[14,25],abil:[0,14,12,34,7,38],set_input_s:36,direct:[0,2,11,4,12,7,38,39,18],twophas:[34,7],j25:[0,12],street:0,before_delet:[40,41],aggreg:[0,14,17],after_flush:41,blue:0,user_pref:18,hide:28,item2:34,item3:34,introspect:17,calcul:[14,7,38],char_length:[19,14],"new":[0,2,4,34,7,8,9,12,14,15,16,17,18,25,26,28,32,33,35,36,38,39,40,41],net:[33,37,7,41],ever:[28,7],corresponding_column:[14,25],told:[0,12],ongo:[15,34,36,41],widget:[0,39,12],subtre:0,abov:[34,0,37,32,39,10,23,11,3,4,12,26,6,25,36,38,15,28,40,17,18],never:[0,34,35,12,23],richest:6,here:[0,4,12,34,7,36,38,15,25,40,41,17],subselect:0,met:25,column_properti:[0,4],mywidgetextens:39,path:[15,0,40,23],interpret:[15,14,41,34],dry:34,fkei:18,"_attr":39,myextens:0,everyon:34,precis:[11,32,12],datetim:[19,37,23,11,32,14,25,38,28,17,18],other_id:11,permit:10,bayer:[21,10],portabl:11,flinston:12,propag:[40,0,4,2],total:[0,11,35,26,25,40],unit:[0,4,26,34,7,38,15,28,17],highli:[26,4],bookkeep:29,describ:[34,0,9,12,14,7,36,38,15,6,18],would:[34,0,20,11,23,4,12,14,7,37,38,26,25,28,40,29,17,18],allow_null_pk:4,emailaddress:0,recommend:[19,0,11,23,34,7,8,38,15,39],inner:[14,40,12,36,38],type:[0,1,4,37,6,8,9,11,12,13,14,15,18,19,20,22,23,25,28,29,32,33,36,38,39],until:[0,4,12,34,7,15,28,41],uix_1:18,relat:[0,4,34,7,9,11,12,13,15,17,18,38,25,26,28,29,30,6,35,23,39,40],yahoo:[0,12,38],notic:[0,32,12,10,38],mytable_id:11,pref_valu:18,"__iter__":0,relai:29,hold:[19,0,32,4,12,34,7,23,15,25,28,29],addon:6,mapping_spec:29,join:[34,0,20,33,30,9,11,4,12,13,14,25,38,39,40,41,17],room:40,restor:0,treenodes_2_parent_id:0,setup:[0,28,6,12,39],some_x:4,out_paramet:14,some_c:0,coalesc:14,norm:15,akin:0,some_i:4,root:[0,40,7],could:[34,12,14,25,15,28,29],overrid:[0,37,9,32,4,14,7,25,18],defer:[0,40,4,9],give:[0,39,12,35,36,38,28,41],shopping_cart_item:18,indic:[34,0,20,9,4,12,41,33,14,7,36,37,38,15,25,35,40,29],clariti:39,liter:[34,9,11,12,14,25,36,38,35,40],caution:40,fibonacci:26,want:[34,0,4,12,6,36,38,15,28,29,17,18],onclaus:[40,14,25,12],keep:[0,4,26,34,7,36,15,28],type1:18,fake_us:12,end:[34,0,4,12,14,7,36,38,26,39,40],quot:[11,14,25,36],easili:[19,20,34,12,6,37,18],ordinari:12,ilik:[14,25],off:[0,37,36,32,4,12,33,14,25,8,38,15,6,18],mschar:[11,37],how:[34,0,2,14,11,4,12,6,7,36,38,15,28,17,18],enforc:[0,4],pointcompar:0,abstracttyp:[32,25],answer:[15,29],verifi:[12,38],ancestor:[0,14,25],perspect:15,updat:[0,1,4,34,7,9,11,12,13,14,15,16,17,18,19,25,26,28,29,36,38,40,41],anon_1:[12,38],dialect:[19,9,1,32,14,36,11,3,20,33,23,6,25,8,37,38,15,16,18],recogn:17,lai:38,timedelta:32,tablenam:[40,14,25,36,17],perfectli:20,after:[0,4,34,7,8,11,12,14,15,16,18,19,25,26,28,29,35,36,38,39,40,41],mysessionextens:34,befor:[0,4,12,33,34,7,36,38,25,35,39,40,41,18],wrong:[34,7],with_only_column:14,synchronize_sess:40,reconstructor:[0,4,41],posts_bodi:12,timezon:[11,32],attempt:[34,37,11,12,14,25,36,38,15,40],third:[15,23,12,36],classmethod:[40,34,7],minim:21,exclud:[40,39,4],alias:[0,9,12,14,38,40],scoped_sess:[39,34,7,21],maintain:[0,12,34,35,23,15,7],environ:7,enter:29,exclus:[39,4],mechan:[15,23,32,29,36],smallinteg:[11,32],lambda:[0,35],keysowrd:37,order:[34,0,37,21,9,40,23,4,12,26,14,7,36,38,15,25,16,17,18],wind:34,origin:[14,4,34,25,36,35],its_wood:28,remote_id:25,composit:[0,2,9,4,25,38,18],notes_t:0,somedata:[0,21],over:[34,0,37,32,12,33,14,25,23,28,16,29],fall:[4,34,38,15,39,29],becaus:[0,37,12,34,38,28],demarc:34,retrun:37,affect:[0,11,4,26,14,7,36,15,25,28,40,41],get_instance_dict:41,flexibl:[0,28,12,17],vari:36,"_bindparamclaus":14,smallint:32,return_conn:35,directli:[34,0,37,21,11,32,4,12,33,14,7,36,38,15,25,35,39,40,17,18],fit:10,fix:[11,32],"__class__":[0,14,32],fetchal:[19,33,36,38,16,17],renumb:26,persist:[0,2,4,12,34,7,8,23,35,40],comprehens:[0,28,6],mydb:[11,34,35],easier:[28,4,36,38],"_query__context":40,sessiontransact:41,them:[19,0,39,34,11,32,12,33,14,7,38,28,16,29,17],poolclass:[19,35,36],thei:[34,0,39,21,11,4,12,33,14,7,8,38,15,25,35,28,40,29,18],proce:[0,4,34,7,36,6,41],safe:[4,12,34,25,36,38,15,18],"break":[7,4],sqlite3:[15,23],after_attach:41,manager_gett:41,newyork_address:0,choic:[0,34],subqueri:[0,9,12,33,14,25,38,40],mytabl:[0,11,3,4,33,34,25,36,15,18],session_factori:7,column_collect:[14,25],"_get_address":0,odbc:[24,20],unpickl:21,bonu:12,msboolean:11,kwarg1:39,timeout:[15,37,35,36],each:[34,0,39,36,11,32,4,12,26,14,7,8,38,15,25,35,28,40,41,18],debug:[15,35,39,7,36],sorted_t:[25,18],secretpow:25,side:[0,11,40,32,4,12,33,14,25,36,38,35,16,41,18],mstinyinteg:11,mean:[34,0,37,21,23,4,12,33,14,7,36,38,15,35,16,41,18],prohibit:34,last_modifi:18,"0xb7b396ec":28,"transient":[0,34,7],ext_continu:[0,41],extract:[28,14],foreignkeyconstraint:[11,0,39,25,18],unbound:[25,7],emul:[28,36],goe:[0,12,29],newli:[34,0,12,14,7,8,38,25,35,39,40,41,36],content:[34,9,12,14,25,8,38,39,36],posts_user_id:12,adapt:[0,9,11,32,4,41,24,7,38,29,18],reader:38,got:[12,38],"_write_prop":39,written:[15,0,40,29,38],create_engin:[9,37,36,11,23,12,33,34,7,8,38,15,25,35,39,16,17,18],employees_typ:0,free:[0,7,12,10],standard:[0,37,33,21,9,11,22,32,12,26,13,34,25,8,38,15,35,29,17,36],mydsn:[15,37],user_nam:[0,17,18],"__setitem__":[0,29],"__lt__":0,infix:[14,25],md5:11,reconfigur:[7,12],created:18,traceback:[39,17],users_password:[0,12,17],filter:[0,21,9,32,12,7,25,39,40,41,17],iso:23,isn:[0,40,12,29,38],guesswork:0,isa:4,onto:[0,23,4,12,34,7,38],setlik:[0,25],rang:[11,0,40,15],collectionadapt:29,right_id:0,independ:[34,6,16,12,18],adalia:[0,12],restrict:[0,10,21,7,25,35],hook:[0,11,4,7,8,28,40,41],instruct:[0,34],alreadi:[34,0,20,14,11,23,4,12,41,33,6,7,36,38,15,25,35,39,40,29,18],messag:[15,19,14,18],wasn:[34,7],primari:[34,0,37,2,9,11,40,4,12,33,14,7,36,38,25,39,16,41,17,18],sourc:[15,0,4,29,36],cartesian:38,xid:36,genericfunct:14,ordering_func:26,poollisten:[35,8,36],top:[26,37,34,4],blogpost:12,sometim:[0,34],master:6,too:[34,25,12,38],similarli:[0,32,14,39,17,18],notes3:0,notes2:0,john:15,listen:[0,11,4,35,8,25],clauseleft:14,single_par:[34,4],namespac:[21,35,36,15,39,18],tool:[20,34,38,6,29,18],setuptool:6,noninfring:10,ext3:0,sync:[15,26,28],incur:[35,4],def:[0,39,32,3,4,12,26,34,35,8,15,28,40,29,18],somewhat:[34,0,28,35,23],conserv:[0,4],technic:[0,4],peril:35,target:[34,0,39,32,4,12,14,7,38,25,28,40,29],keyword:[34,0,37,39,2,33,40,4,12,26,14,7,36,38,15,25,35,28,16,41,18],provid:[0,3,4,34,7,8,10,11,12,14,15,17,18,23,25,26,28,29,30,32,35,36,38,39,40],expr:14,tree:0,second:[19,0,2,3,4,12,34,25,36,38,15,35,29],matter:15,sqlengin:[36,17],ddlelement:3,somet:[4,14,38,15,39,16,18],minut:19,fashion:[25,18],ran:24,boston:0,modern:11,raw:[0,30,21,9,14,8,17,36],manner:[34,0,14,4,12],increment:[9,1,33,11,37,26,13,25,15],anon_1_users_fullnam:12,seen:[15,38],seem:[11,20],inherit_foreign_kei:4,seek:33,minu:0,"3ddb":37,"__new__":[0,41],terrif:34,latter:[0,34],cope:26,meta1:18,meta2:18,client:[11,19],useexist:25,cleft:[14,25],count_from:26,methodolog:33,eagerli:[0,9,4,12,7,40,41],greatest:37,even:[0,20,11,23,41,33,34,7,36,38,15,25,40,29],current_d:14,though:[0,4,34,36,38,39],usernam:[0,20,11,12,35,36,38,15],object:[0,1,2,3,4,37,6,7,8,9,12,13,14,15,31,17,18,19,21,22,23,25,26,28,29,30,32,33,34,35,36,38,39,40,41],server_side_cursor:16,what:[34,0,37,9,12,26,6,36,38,15,16],lexic:[14,38],init_fail:41,regular:[34,0,39,11,23,4,12,26,14,7,38,15,25,28,40,18],letter:38,attributeextens:[4,41],insul:36,maper:0,tradit:39,transat:7,don:[34,0,4,12,14,25,36,38,15,40,17],secondaryjoin:[0,4],doc:[20,34,23,38],databasenot:20,doe:[34,0,20,9,11,32,4,12,23,14,7,36,37,38,15,25,35,39,40,17,18],declar:[9,30,4,12,13,25,15,39,17],my_str:14,unchang:[34,32],notion:37,dot:[0,14,40],use_scope_ident:37,columnnam:[40,14,25],mostli:[14,36],unmappedclasserror:4,opposit:[0,34,7,33],random:[14,36,38],syntax:[19,37,11,12,38,39,16,18],postgres_wher:[25,16],treenodes_data:0,object_mapp:4,xxg527:12,protocol:32,select_from:[14,40,12,38],init_collect:4,involv:[0,3,12,25,38,7,39],despit:0,mediumblob:11,firstnam:0,init_on_load:0,explain:17,configur:[34,0,37,30,9,11,22,4,12,26,13,6,7,36,15,25,35,39,40,18],restaur:34,theme:38,busi:[12,38],rich:12,department_id:18,someengin:18,stop:[0,40,4,12,38],relatedinfo:39,insertfromselect:3,unitofwork_transact:15,fetchedvalu:[25,18],popitem:29,report:[0,23,33],reconstruct:0,punion:39,employees_employee_id:0,bat:[15,0,12],mylist:0,emb:38,last_pric:28,user_keyword:28,baz:11,method:[0,2,3,4,34,7,8,12,14,15,17,18,19,38,25,28,29,32,33,35,36,23,40,41],sauc:39,reload:[34,12],bad:20,favorite_entri:0,contains_alia:0,metadata:[0,4,34,9,11,12,13,14,15,16,17,18,21,25,26,28,30,32,33,6,36,38,39],black:38,duck:[0,28,29],get_default_schema_nam:36,nut:34,datatyp:[0,32,12,33,6,25,38,16,18],collection_class:[0,4,41,26,28,29],num:20,result:[0,37,2,4,34,7,9,12,13,14,15,16,18,19,20,22,23,24,25,32,33,6,35,36,38,40,41],auto_incr:11,fail:[15,0,34,24],themselv:[0,21,9,14,25,38,29,18],many_a:0,best:[11,0,32,12],subject:[34,0,14,40,10],awar:[0,20,12,33,14,7,38,15],hopefulli:17,databas:[0,1,4,37,6,7,9,11,12,13,14,15,16,17,18,19,20,22,23,24,25,29,32,33,34,35,36,38,40,41],posts_tabl:0,urllib:37,nodemap:0,figur:[0,38],after_commit:41,simplest:32,drawn:38,awai:[34,12],approach:[0,37,12,33,34,38,40,29],concurrentmodificationerror:4,attribut:[0,2,3,4,34,7,8,9,12,13,14,15,31,17,18,25,26,28,29,30,32,36,38,39,40,41],accord:[11,0,7,25],extend:[19,0,9,3,4,34,29],newnam:38,were:[0,4,12,33,34,7,36,38,40,41,17,18],weak:[34,7],bullets_t:26,extens:[0,1,30,21,9,11,4,12,41,13,34,7,15,25,39,40,29],lazi:[0,9,4,12,34,7,15,28,40],add:[34,0,39,11,32,4,12,41,14,7,8,38,25,35,28,40,29,17],adalias2:12,article_id:40,pjoin:0,accident:36,get_search_list:32,uninstall_memb:41,regularpric:14,howev:[0,36,4,34,7,8,38,25,40,41,18],param_1:[14,38],against:[34,0,9,4,12,14,7,36,38,15,25,40,41,18],param_2:38,facet:34,logic:[15,39,32,36],login:[37,32],com:[0,33,12,38],col:[25,39,14,4],allevi:19,querytest:18,msdatetim:11,allow_twophas:33,foobar:[12,18],"_read_prop":39,loader:[0,9,4,12,34,15,41],palia:40,guid:23,assum:[34,0,14,23,4,12,33,6,38,15,39,40],summar:15,sortkei:21,duplic:[15,39,29],liabil:10,strong:[0,7,4],eager:[0,9,4,12,34,15,40,41],union:[0,2,9,4,14,38,40],oldpost:0,three:[19,0,37,39,2,12,34,25,38,15,28],been:[19,0,20,39,34,4,12,24,33,14,7,8,38,15,25,35,28,40,41,17,18],dict_gett:41,much:[0,4,12,34,8,38,15,28],someothert:0,interest:[20,32,38],basic:[0,9,11,4,12,34,25,8,38,29,17],"__doc__":[14,32],quickli:[15,0,23],"_set_statu":4,rather:[15,0,7],deeper:0,worker:23,inherit_condit:4,ani:[0,3,4,34,7,8,10,11,12,14,15,17,18,19,21,23,25,26,28,29,32,35,36,38,39,40,41],multithread:[33,35,23],disconnectionerror:8,child:[34,0,9,4,14,38,15],dynamic_load:[0,4],docstrings_sqlalchemi:26,emploi:15,ident:[34,0,37,2,32,4,12,14,7,25,35,40,41,17],create_cursor:36,engine3:7,engine2:[34,7],do_rollback_to_savepoint:36,servic:[34,8],properti:[19,0,39,2,9,40,4,12,41,26,13,34,7,36,15,25,28,31,29,17,18],sourceforg:[33,37],viewonli:[0,4],weren:12,neat:0,occas:32,"_set":28,typedecor:32,msyear:11,mss_engin:37,tabl:[0,37,2,3,4,6,7,9,11,12,13,14,15,16,17,18,19,21,22,25,26,28,30,32,33,34,36,38,39,40,41],toolkit:6,uselist:[0,28,4],cant:38,kwarg:[2,11,32,4,14,7,36,25,39,40,41,17,18],module_nam:37,vendor:[22,9,32,7,13],tediou:38,sever:[0,20,12,33,6,36,38,15,16,18],has_sequ:36,perform:[34,0,36,11,23,41,26,14,7,8,38,15,35,40,29,17,18],suggest:11,make:[0,23,32,4,12,33,34,25,36,38,15,35,39,17],transpar:[0,34,35],somealia:0,complex:[0,30,9,4,13,28,17],descend:[40,14,4,36,38],success:[15,19,33],rownum:33,complet:[0,32,12,24,34,7,36,15,39,41,18],elli:17,yield_curv:14,drivernam:[15,36],hang:[34,17],hand:[11,0,34,29,38],rais:[19,0,36,11,32,4,12,33,34,7,8,23,15,25,35,40,29,17,18],warranti:10,employee_nam:18,tune:35,redefin:41,kept:[35,38],scenario:[0,23,4,12,34,7,38],some_id_seq:16,thu:[34,4,18],messeng:36,myindex:18,inherit:[19,0,2,30,9,4,13,39,40,29],instrument_collection_class:41,"05migrat":6,wherebi:[0,34],thi:[0,37,2,3,4,6,7,8,10,11,12,14,15,16,17,18,19,20,21,23,25,26,28,29,32,33,34,35,36,38,39,40,41],diverg:33,everyth:[9,34,4,38],paradigm:38,sqlcli:20,attribute_mapped_collect:[0,28,29],left:[0,20,11,40,4,12,33,14,25,38,16],pginet:32,identifi:[34,0,40,23,4,12,14,7,36,38,25,16,18],just:[34,0,39,2,23,4,12,26,6,25,36,38,15,28,17,18],msinteg:11,engineers_t:0,photo:0,shorthand:[25,0,4,12],yet:[0,20,4,12,24,34,7,38,15,25,35,39,41],languag:[9,37,12,6,25,38],previous:[0,7,34,4],note:[0,1,4,37,34,7,8,9,11,12,13,14,15,16,17,18,20,21,23,25,32,33,6,35,36,38,39,40,41],alchemi:36,group_bi:[0,12,14,38,40,17],easi:[32,28,36,17,38],type_descriptor:[32,36],columnel:[25,40,14,4],had:[34,33,28,38,18],get_children:[14,25],dblink:[9,1,33,13],board:36,els:[34,0,9,23,4,14,7,36,38,25,18],save:[0,4,34,7,38,15,41,17],sqlite_db:15,refcol:25,applic:[19,0,39,34,23,11,32,4,12,6,7,36,38,15,25,35,28,40],pgarrai:32,quirk:15,managers_t:0,id_seq:33,stpz:28,scopedsess:[7,21,17],measur:11,semi:41,specif:[0,37,3,4,34,7,9,11,12,13,14,15,31,18,19,21,22,23,25,16,32,33,36,38,40,41],arbitrari:[0,30,9,14,38,26,29,17],left_tabl:0,alltest:24,do_return_conn:35,manual:[0,11,34,7,36,38,26,28,17],remove_st:41,unnecessari:11,underli:[34,0,39,11,32,4,12,14,7,36,15,25,35,28,40,29,18],makedsn:[15,33],right:[34,0,10,11,12,14,25,23,40,41],old:[19,0,20,14,25],deal:[10,32,34,7,38,15],negat:14,interv:32,excerpt:0,somehow:23,intern:[0,36,9,22,40,4,12,13,7,8,23,25,31,29,18],oracle_db:15,favorite_entry_id:0,pysqlite2:23,bore:17,successfulli:33,autocommit:[34,9,11,14,7,36,15,39],txt:15,represent:[14,25,12,32],query_context:41,yield_per:40,subclass:[34,0,32,3,4,12,14,7,8,25,39,40,41,36],primary_mapp:4,cnf:11,track:[0,12,34,7,38,15,29],condit:[0,10,9,4,12,14,7,38,25,39,17],foo:[34,0,21,11,40,32,4,12,14,7,38,15,25,16,41],my_tabl:[39,16],operationalerror:19,core:[6,30,18],plu:[37,38],who:[34,25,12,38],someclass:[39,34,40],someinfo:0,promot:34,repositori:38,eagerlazyopt:40,post:[34,0,12,14,25,7,40,41,18],"super":38,plug:36,ucs2:11,obj:[34,0,21,4,14,7,28],invoice_id:18,slightli:[34,0,20,28,41],subtrasact:7,unfortun:[15,17],unsav:7,instance_st:4,pool_timeout:[35,36],commit:[0,9,40,12,34,7,36,38,15,28,16,41],produc:[34,0,39,3,12,33,14,7,36,38,26,25,35,28,40,29,18],queuepool:[15,35,8,36],match:[34,0,11,32,4,12,14,7,25,40],append_column:[14,25],mslongblob:11,subchild2:0,objectss:0,curiou:17,xyz:19,"float":[11,32],encod:[37,11,32,36,38,15],www:[10,11,38,33,7,23],down:[14,12,38],unique_connect:35,formerli:[34,4],lieu:16,wrap:[0,4,33,34,36,29,17],opportun:41,storag:[0,1,9,11,13,8,26,17],auto_setinputs:33,suffici:[11,28,32],support:[0,1,4,37,6,7,9,11,12,13,14,15,16,17,18,19,20,23,24,25,29,32,33,34,35,36,38,39],frill:25,transform:[9,29,36,38],"class":[0,2,3,4,34,7,8,9,11,12,13,14,31,17,18,19,21,22,23,25,26,28,29,30,32,35,36,38,39,40,41],avail:[34,0,20,14,23,11,32,4,12,33,6,7,36,37,38,15,25,39,16,30],width:11,reli:[34,0,33,29,38],gid:11,synonim:19,add_column:40,call:[34,0,2,36,32,4,12,41,33,14,7,8,38,15,25,35,28,40,29,17,18],oramag:33,basepair:17,isupd:36,mycol:[14,36],form:[0,40,4,12,14,36,38,15,39,16,18],offer:[19,40,37,35,12],forc:[19,0,14,25,34],fold_equival:14,pg_db:15,paramstyl:36,sqlalchemi:[0,1,2,3,4,37,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,28,29,30,31,32,33,34,35,36,38,39,40,41],right_tabl:0,renam:38,"true":[0,37,3,4,34,7,11,12,14,15,16,17,18,25,26,28,32,33,35,36,38,39,40,41],connectionless:[15,9,38],reset:[40,34,35],userland:0,attr:[26,39,28,17],arrays:[33,36],maximum:[11,37,35,36],tell:[0,12,17,38],zark:0,emit:[25,14,7,32,18],"delete":41,copy_valu:32,featur:[34,0,1,33,14,9,11,40,12,13,6,7,38,15,39,16,17,18],alongsid:36,classic:[7,12],request:[0,11,34,35,23,25],"abstract":[39,28,35,8,32],myotherclass:0,msnumer:11,drive:23,treenodes_2_id:0,exist:[34,0,9,32,4,12,23,14,7,36,38,15,25,39,17,18],address_count:[0,12,38],ship:35,check:[34,9,20,36,11,4,12,26,6,7,8,38,15,25,35,18],sticki:34,assembl:[0,7,41,38],translate_connect_arg:36,when:[0,37,3,4,6,7,8,11,12,14,15,16,17,18,19,21,23,25,26,28,29,32,33,34,35,36,38,39,40,41],elementtre:0,role:0,jone:[12,17,38],test:[0,20,26,30,9,11,32,12,24,13,34,7,37,38,15,35,39,28,17,18],presum:11,executioncontext:36,roll:[9,12,34,7,36,15],create_al:[39,38,25,12,18],node:0,labeled_loan:17,intend:[39,7],table_map:2,felt:33,asterisk:12,update:41,increas:[11,29],insensit:[0,25,36],queri:[0,37,2,4,34,7,9,12,13,14,15,31,17,18,19,20,21,25,30,33,6,36,38,39,40,41],consid:[0,32,12,34,7,28,40,41],sql:[0,1,3,4,37,6,7,8,9,11,12,13,14,15,16,17,18,20,22,25,26,30,32,34,36,38,39,40],sessionawaremapp:7,optimize_limit:33,warn:[34,32,40,23],receiv:[0,23,32,4,34,7,8,38,15,35,39,41,36],longer:[0,34,25,41],bullet:26,anywher:[24,38],"__clause_element__":0,bidirection:0,tinyint:11,ignor:[25,0,26,7,36],fact:[12,8,38,15,39,40],time:[0,1,4,37,34,7,9,11,12,13,14,15,16,17,18,19,23,25,28,32,33,35,36,38,39,40,41],push:29,lastrowid:18,backward:[37,4],concept:[0,12,34,7,38,15,17,18],chain:[0,40,14,4],addresses_2:[12,38],skip:[15,6,4,12,38],addresses_1:[0,12,38],is_act:7,signific:[6,38],stumbl:38,informix:[15,9,1,27,13],engineer_id:39,usersaddress:0,compani:[0,40,41],row:[0,33,2,9,11,40,32,4,12,41,26,34,7,36,38,15,16,29,17,18],hierarch:0,decid:12,herebi:10,depend:[0,20,9,4,41,26,34,7,15,25,39,40,29,18],dbo:37,zone:34,graph:[15,0,4],decim:[11,32],dbengine_log:36,text:[0,37,9,11,32,12,26,14,7,36,38,15,25,40,17,18],must:[34,0,20,2,21,11,40,4,33,14,7,36,38,25,16,29],multivalu:7,child1:0,child2:0,child3:0,string:[0,1,2,3,4,37,34,7,9,11,12,13,14,15,18,23,25,26,28,32,33,36,38,39,40],passive_upd:[0,4],addresses_t:[0,12,18],by_stock:28,schemavisitor:[25,36],exact:[33,14,35],parent_t:0,level:[0,1,4,37,34,8,9,11,12,13,14,15,17,18,21,25,29,32,6,36,38,39,40,41],tear:12,some_t:[39,34,7],iter:[34,0,4,12,14,7,38,40,29,18],item:[34,0,9,4,12,14,7,36,25,28,40,29,17],expunge_al:[34,7,17],add_ent:40,localhost:[11,15,39,35],quick:[0,12,38],collection_adapt:[4,29],unaccount:40,round:12,declarative_bas:[39,12],upper:[20,39,25],work:[34,0,20,9,11,4,12,33,6,7,36,37,38,15,28,40,29,17,18],"__ne__":0,pickleabl:[32,21],hack:14,cost:35,bake:38,port:[15,33,37,16,36],myaddress:0,lazili:[0,7,4,36],discourag:4,pre_exec:36,staticpool:[35,23],myenum:11,current:[0,37,4,34,7,8,11,12,15,16,17,18,20,24,25,28,29,32,33,6,35,36,40],loans_user_nam:17,"__instrumentation__":29,mssql_db:15,eagerload:[0,40,4,12],pbxt:11,assertionpool:35,meld:38,xml:0,deriv:[0,14,25,12,41],gener:[0,4,34,7,9,11,12,13,14,15,16,18,20,22,25,26,29,32,33,36,38,39,40,41],stmt:[12,36],normalize_whitespac:[0,12,38],explicitli:[34,0,36,40,32,4,12,33,23,14,7,8,38,15,25,39,16,17,18],modif:[0,40,7,12,41],identity_kei:2,address:[0,12,34,38,39,18],along:[0,4,12,34,25,38,26,28,40,18],"_will_":0,wait:[15,35,36],box:23,preorder:0,shift:29,step:[26,33,34,38],queue:[8,23],behav:[34,12],pysqlit:[15,23],extrem:[0,12],else_:14,commonli:[0,4,34,7,38,40],semant:[0,14,32,4,34,39,16],regardless:[34,4,14,7,23,15,40,18],session2:34,extra:[0,2,30,9,23,13,38,40,41,17],tweak:19,modul:[19,0,20,21,33,11,32,12,26,23,14,34,36,37,38,15,35,16,41,18],prefer:0,treenodes_id:0,and_:[0,14,12,17,38],subcategori:15,my_string_2:14,visibl:[0,4,12],marker:[22,9,18,25,13],instal:[9,11,4,6,35,8,23,15,39,41],should:[34,0,37,2,36,11,32,4,12,41,33,14,7,8,38,15,25,39,40,29,18],append_constraint:25,include_properti:[0,4],memori:[0,11,23,4,12,34,7,38,15,35,17,18],sake:34,query_timeout:37,visit:[14,25],impos:[0,35],connector:15,msn:38,live:[15,34,8],handler:41,value2:15,value1:15,criteria:[40,39,25,12],msg:35,scope:[37,4,34,7,8,23,15,36],sequence_nam:36,thru:19,checkout:[15,35,8,36],chapter:[15,32,12,36,38],peopl:[39,40],con_record:8,claus:[0,4,12,33,14,7,36,38,15,25,40,17,18],enhanc:[11,0,20,34,40],appendix:10,accept:[34,0,20,2,40,32,4,12,14,7,8,37,15,39,16,17,36],examin:34,postgresql:[0,1,9,32,4,12,13,34,25,36,38,15,16,18],easiest:38,users_admin:17,fly:[34,7,17],graphic:34,ibm:15,prepar:[26,34,7,36],constraint:[34,0,9,22,12,13,6,25,18],uniqu:[34,0,9,12,33,14,7,36,38,25,17,18],wendi:[12,38],mycolumn:3,soup:17,can:[0,37,3,4,6,7,8,11,12,14,15,17,18,19,20,21,23,25,26,28,29,32,33,34,35,36,38,39,40,41],purpos:[0,10,12,34,36,29,17],echo_uow:[15,7],claim:10,encapsul:40,stream:36,backslash:23,critic:[0,38],abort:[34,25,8],execute_str:36,phrase:33,recycl:[35,36],addresses_user_id:[0,12,38],occur:[34,0,4,12,14,7,36,38,15,25,40,41,18],alwai:[0,37,23,11,32,4,12,33,34,38,28,40,18],differenti:19,multipl:[34,0,9,4,12,14,7,36,38,15,25,28,40,41,17,18],unsign:11,engineer_info:0,write:[0,39,32,4,12,33,34,7,38,15,28,29],criterion:[0,2,12,14,38,40,41],pure:12,sysdba:33,somevalu:[14,32],multiparam:[14,25,8,36],map:[0,2,4,34,7,9,11,12,13,14,31,17,18,19,21,25,26,28,29,30,36,39,40,41],product:[12,38],autoincr:[11,0,33,25,18],max:[0,20,14,37,38],sql_mode:11,aol:38,usabl:[0,39,14,32,18],spow:25,membership:29,pattern:[34,0,9,4,12,26,6,7,15,25,28,17],mixin:[14,32],mai:[0,37,4,34,7,8,11,12,14,15,17,18,19,20,23,25,28,29,32,33,35,36,38,39,40,41],latin1_general_ci_a:37,data:[0,37,4,34,9,11,12,13,14,15,17,18,21,22,38,25,29,32,33,6,23,39],grow:15,book_excerpt:0,explicit:[0,37,30,9,4,12,34,7,36,38,15,25,39,40,29,18],generate_cont:34,before_insert:41,predic:[14,25],inform:[34,0,20,32,11,3,4,12,41,26,14,7,36,37,38,15,25,35,29,18],"switch":17,preced:[34,11,23,12,14,25,38],combin:[0,4,12,6,25,36,38,15,17,18],gamma:11,should_autocommit:36,callabl:[0,32,3,4,39,7,36,15,25,35,28,29,18],longhand:0,column_prefix:[0,4],talk:[15,19,34,12],subchild1:0,schemadropp:36,connect_arg:[15,36],occasion:[20,29,17],clausetest:14,mappedcollect:[0,29],entrywai:34,still:[19,0,39,23,12,24,34,7,36,38,15,35,28,40,41,17],dynam:[0,37,30,9,4,12,25,36,17],entiti:[0,9,4,12,34,7,36,40,29,17,18],conjunct:[0,9,4,12,33,7,38,39,40,18],group:[0,9,40,4,12,14,35,38,16,29,18],thank:38,advdatamapping_rel:12,dbapi_type_map:36,hoho:18,init_inst:[0,41],tort:10,window:[24,37,23,12,38],mail:11,main:[26,0,39,6,9],non:[34,0,37,11,23,4,12,14,7,36,38,15,35,28,40,17,18],initd:23,synopsi:[9,39,3,30,13],halt:[0,4,41],col6:18,savepoint:[9,34,7,36,15,16],col5:18,col2:[15,14,16,36,18],col3:[36,18],initi:[34,0,2,9,32,4,14,25,36,35,39,41,17],col1:[15,14,16,36,18],underneath:[15,39],therebi:34,now:[34,0,4,12,33,14,25,38,15,28,17,18],sltime:23,discuss:[15,0,29],nor:[15,4,38],introduct:[9,30,17,13],wont:34,term:[0,41,8,38,40,29,18],append_without_ev:4,name:[0,37,2,3,4,34,7,9,12,14,15,16,17,18,19,23,25,26,28,30,32,33,35,36,38,39,40,41],returntypefromarg:14,config:36,drop:[19,9,6,25,36,15,18],revert:12,separ:[34,0,37,14,4,12,6,25,38,15,40,18],treenodes_1_data:0,cascade_iter:4,unmappedinstanceerror:4,rock:0,recreat:[0,35,25,18],exclude_properti:[0,39,4],its_big:28,compil:[0,20,30,9,3,4,13,14,25,8,38,15,39,40,29,36],email_addresses_1:0,replac:[0,4,14,25,36,35,40],individu:[34,0,14,4,6,7,36,38,35,39,41,18],continu:[0,11,4,34,36,41],users_email:17,contributor:10,current_tim:14,significantli:38,begun:[7,12,41],year:[11,17],happen:[15,19,38,18],dispos:[34,35,8,23,25,41],foreign_kei:[25,0,14,4,18],shown:0,accomplish:[37,34,12,38],lastrow_has_default:36,space:[0,14,25],oracle_resolve_synonym:33,urlencod:37,association_proxi:28,toggleabl:11,pjoin_engineer_info:0,correct:[34,38,18],integr:[0,20,11,4,34,7,15,35,39],append_result:41,earlier:[20,12,38],partit:[9,34],migrat:[9,6],inclus:4,cart:18,headlin:[0,12],orm:[0,2,4,34,7,9,11,12,13,14,15,31,20,21,38,25,26,28,29,32,6,23,39,40,41],mysqld:11,lump:38,org:[10,11,38,7,23,16],"byte":[11,32,36],server_version_info:[19,37,36],care:0,reusabl:17,wai:[19,0,39,21,34,32,4,12,14,7,38,15,25,35,28,40,17,18],insert:[0,1,3,4,37,34,7,9,11,12,13,14,15,16,17,18,19,25,26,29,33,36,38,39,40,41],synchron:[15,0,26,40,34],unavoid:29,recov:36,thing:[19,26,38,40,18],place:[0,37,4,12,33,34,7,38,15,35,40,41,18],msdoubl:11,firstpost:12,imposs:[0,40,4],frequent:[15,9,34],first:[34,0,2,11,23,4,12,33,14,7,36,38,15,25,40,41,17],oper:[0,4,34,7,8,9,11,12,14,15,16,18,19,20,25,26,28,29,32,33,6,35,36,38,39,40,41],user_mapp:34,reimplement:29,multipleresultsfound:[40,12],qmark:38,onc:[34,0,36,9,32,4,12,41,33,14,25,8,38,15,35,39,40,29,17,18],arrai:[0,12],yourself:38,walkthrough:[0,6],"long":[15,0,34,8,29],except_:[14,40,38],open:[23,12,34,35,36,38,15],size:[21,32,33,35,36,15],users_id:[0,12,38],given:[34,0,39,2,21,36,11,32,4,12,33,14,7,8,38,25,35,28,40,41,18],posts_id:12,convent:[11,16],undecor:29,classmanag:4,users_1:12,adjac:[0,9],citi:0,necessarili:17,conveni:[39,12,14,7,8,25,28,40,17,18],friend:40,stocks_tabl:28,uniqueconstraint:[25,18],grant:10,especi:34,memo:36,copi:[34,10,32,14,25,38,7,41],specifi:[0,37,4,34,7,9,11,12,14,15,16,17,18,38,25,29,32,33,35,36,23,39,40],enclos:[15,14,7,36,38],pragma:[11,38,12,18],holder:10,than:[0,37,39,23,4,12,6,7,36,38,15,25,35,28,40,41,18],serv:12,wide:[11,7,36],setattr:[0,28],last_inserted_param:[36,18],users_t:[0,12,34,15,28,18],keywords_t:[0,28],auto_identity_insert:37,optimist:7,posit:[0,2,32,4,14,7,36,38,26,25,40,29],whereclaus:[40,14,25],surrog:4,created_at:18,seri:[0,40,29],pre:[19,9,33,14,7,36,35,39,16,41,18],query2:21,sai:[0,12,34,38,15,39],nicer:17,not_:[14,38],argument:[0,37,2,3,4,34,7,8,9,11,12,14,15,16,17,18,25,26,28,29,32,33,35,36,38,39,40,41],delin:34,pknotfounderror:17,deliv:[15,14],create_xid:36,sap:20,collat:[9,1,11,37,13,14,25,40],dbapi:[19,9,23,32,33,36,38,15,17],bitwis:38,engin:[0,1,4,37,6,7,8,9,11,12,13,14,15,17,18,19,21,22,25,30,34,35,36,38,39,40,41],techniqu:[34,0,6,38],an_engin:25,type_:[25,14,4,38],topten:26,map_column:[0,39,4],dispar:34,take:[34,0,39,33,11,32,4,12,41,26,23,14,7,36,38,15,25,28,29,17,18],advis:[0,35],proxy_bulk_set:28,noth:[39,4,34,7,23,15,28,17],nosuchtableerror:17,begin:[12,34,35,36,38,15,7,40],sure:[15,26,32,40],employee_mapp:0,othermapp:0,mycomparatortyp:39,normal:[34,0,11,32,4,12,33,14,7,38,26,25,35,39,16,41,17,18],buffer:[16,7,36],price:0,fakeus:12,beta:11,wire:16,sublicens:10,pair:[34,0,14,7,36,15,41],asdecim:[11,32],method_b:15,validate_address:0,synonym:[0,1,33,30,9,32,4,13,39],correctli:[0,40],engine_from_config:36,later:[0,37,12,34,25,38,15,7,39],sale:19,quantiti:28,runtim:[32,29,17],mysql_db:15,shortnam:14,shop:[6,18],show:[41,34,12,38],ansi_quot:11,atom:[11,34,29],my_index:16,atob:0,concurr:[0,34,35,23,15,7],permiss:[11,10],new_from_blammo:28,"_create_uk_by_keyword":28,cx_oracl:[15,33,36],slot:8,onli:[0,37,3,4,34,7,8,11,12,14,15,16,17,18,20,23,24,25,28,32,33,36,38,39,40,41],snack:28,nice:23,undefer_group:0,mydata:18,transact:[34,9,1,14,33,11,22,12,13,6,7,36,37,15,25,35,16,41,17],activ:[19,0,23,4,33,7,36,38,35,18],localtimestamp:14,dict:[19,0,32,4,14,25,36,28,29],analyz:[12,38],outerjoin:[0,12,14,25,38,40],offici:11,overwritten:[40,25],startswith:[14,25],post_configure_attribut:41,nearli:[34,32,21],variou:[0,12,25,36,38,15,39,41,18],get:[0,37,2,9,4,12,26,34,7,36,38,15,35,28,40,17,18],from_stat:[0,40,12],repr:[28,36],secondari:[0,39,11,4,12,34,28,40],sysdat:[14,18],engineers_employee_id:0,cannot:[19,0,23,40,38],keyword_id:[0,39,28,40,12],self_group:[14,25],log_tabl:15,requir:[0,37,4,34,11,12,15,17,18,20,21,25,26,28,29,32,33,35,36,38,39,40,41],remote_bank:18,mapper:[34,0,39,2,30,21,9,40,4,12,41,26,13,6,7,15,28,31,29,17],item_nam:18,seldom:28,dramat:12,yield:[40,37,14,25],across:[38,12,34,36,23,40],handle_dbapi_except:36,through:[0,37,39,11,23,4,12,33,34,7,8,38,15,35,28,29,18],where:[34,0,20,32,40,3,4,12,33,14,36,38,15,39,16,17],summari:[15,0],wiki:[20,11,6,7,15,17],target_collect:28,mess:38,adr_count:12,progress:[15,3,7,12,36],concern:12,detect:[0,4,34,7,36,15,35,41],slides_t:26,enumer:32,anytim:38,label:[0,12,14,25,36,38,40,17,18],behind:[15,26,7,12,38],myfil:35,identity_key_from_inst:4,between:[19,0,34,23,32,4,12,14,25,36,38,15,35,28,40],"import":[0,37,3,34,7,11,12,14,15,17,18,19,21,38,26,28,29,32,6,35,23,39],iterate_properti:4,message_id:18,"_user_id":0,visit_insert_from_select:3,assumpt:[34,29],grandpar:0,parent:[34,0,2,9,4,12,14,25,36,38,15,28,40,18],"__emulates__":0,pypi:[6,16],cycl:[4,17],rare:[0,32,7],uncondition:[15,34,35],come:[11,15,12,36,38],compare_valu:32,"_connectionrecord":8,region:17,contract:[16,10],tour:12,tutori:[0,6,12,38,9],mani:[0,33,30,9,11,39,4,12,41,13,34,7,36,38,15,28,40,29],ischema_nam:19,remote_user_id:18,check1:18,"0xb791ea0c":28,among:[15,40,34,7],address_id:[0,18],tnsname:15,color:0,overview:[9,1,11,20,13,6],link_to_nam:25,period:0,pop:[26,29],kirtland:26,photo2:0,photo3:0,photo1:0,colon:[12,38],item1:34,cancel:[4,36],constant:[25,18],coloni:40,damag:10,better:[33,23,8,17,38],anon_1_user_id:12,cursor_execut:8,do_recover_twophas:36,mari:[12,38],its_heavi:28,pend:[4,12,34,7,38,15],bypass:[0,40,34,35,36],anon_1_id:12,fbdate:19,resolut:7,tiger:[15,39,35],catastroph:34,doesn:[0,20,4,12,34,38,40,18],workspac:34,ironpython:11,"__eq__":[0,14,4,38],those:[34,0,20,4,12,41,14,7,38,25,35,28,40,29,18],polymorphic_union:[0,39,2],"case":[0,37,4,34,12,14,15,18,19,20,21,38,25,28,32,33,35,36,23,39,40,41],query_cl:7,schemaiter:36,xyz_my_goofy_funct:38,cast:[0,20,14],invok:[34,0,3,4,14,7,36,15,25,39,18],outcom:41,shall:[4,10],install_st:41,tiddlywink:38,after_delet:[40,41],financial_info:18,advantag:[0,34,35,38,17,18],stdout:[15,36],"_user_nam":0,worri:38,destin:15,blah:[37,12],"_polymorphic_map":4,bias:19,eras:4,ascii:11,"__init__":[34,0,39,32,2,11,3,4,12,14,7,36,26,25,35,28,40,41,17],filter_bi:[0,34,40,12,17],develop:24,author:[0,10,21,12,26,39,17],alphabet:26,intermediari:4,same:[0,2,4,34,7,9,11,12,14,15,17,18,19,21,38,25,28,32,35,36,23,39,40,41],binari:[11,0,37,32],epoch:32,use_threadloc:35,pad:11,pai:12,paj:28,document:[0,30,10,9,11,33,6,23,26,41,17],exhaust:36,finish:[15,34,17],twophasetransact:7,nest:[34,0,11,14,7,36,15,40],assist:34,driver:[9,1,33,11,32,20,24,13,36,37,23,15,16],someon:34,driven:15,capabl:[23,11,32,33,34,25,8,38,15,18],label_length:36,improv:[39,4],extern:[34,0,18,7,9],somecolumn:[14,25],"3bdatabas":37,appropri:[34,0,32,14,23,3,4,6,36,38,15,39,40,29,18],sql_small_result:11,cherri:28,quicki:[9,34],without:[34,0,10,36,23,4,12,33,14,7,8,38,15,25,35,39,40,29,17,18],argument2:15,argument1:15,deferr:25,model:[0,34,35,26,28,17],bodi:12,populate_inst:41,dereferenc:[15,34,7],updated_bi:28,set_attribut:4,execut:[0,34,7,8,9,11,14,15,16,17,18,19,25,28,29,33,6,35,36,38,40,41],freshli:0,unflush:34,rest:[34,7,36,17,38],halfwai:38,aspect:[19,34,36,38],touch:38,clauselist:0,flavor:38,"_selectbasemixin":14,pickletyp:32,hint:[32,18],except:[34,0,20,32,4,12,41,14,7,36,38,15,25,35,40,29,17,18],littl:[0,39,28,38],desktop:34,blog:[0,12],instrument:[0,9,4,12,41,7,15,29],bind_processor:32,blob:[11,32],versa:0,entrypoint:34,begin_nest:[34,7,36],real:[11,23,12,7,38,15,35,17],"_email":0,around:[0,37,11,4,34,35,38,29],read:[34,0,39,14,32,4,33,6,7,38,15,35,28,29],outermost:[15,7,36],specimen:29,leapfrog:15,is_modifi:[7,41],get_current_uid:28,msnvarchar:[11,37],world:34,oldnam:38,create_inst:41,dbapi_con:8,some_engin:[34,21],mod:[15,20,7],make_url:36,expositori:17,engine_email_address:18,threadsaf:[7,36],shares_lineag:[14,25],btoc:0,integ:[0,37,39,33,11,32,4,12,26,14,25,36,38,15,28,16,29,18],server:[34,9,1,11,37,24,13,14,25,36,35,16],getconn:35,anon_1_users_password:12,primaryjoin:[0,39,4],cascad:[0,9,4,12,34,7,25,40,17,18],output:[12,14,35,36,38,15,25],inter:[0,7],manag:[34,0,14,9,4,41,26,6,7,8,38,15,35,39,29,17,36],fulfil:[15,0,16,8],myproxi:8,orderlin:14,column_mapped_collect:[0,29],ascend:[14,38],adequ:0,assert_unicod:[32,36],rowid:4,egenix:24,pickler:32,comparable_us:39,simplefilt:32,ondelet:[0,25,18],slice:[0,40,12],accommod:26,columncollect:14,definit:[11,32,12,34,25,36,26,39,17,18],token:[33,37,34],use_ansiquot:11,ddl:[19,9,13,11,32,22,25,18],reset_on_return:35,complic:[0,4],refer:[0,4,34,7,9,11,12,13,14,15,17,18,21,25,28,32,33,6,36,38,39,40,41],postfetch:18,msdecim:11,quit:[0,28],garbag:[15,35,34,7,38],inspect:[3,4,12,7,8,28,29],ultim:[14,36,38],broken:20,found:[23,4,12,14,38,15,28,40,17],immut:29,ed_us:12,appli:[0,21,32,4,12,14,7,36,38,25,40,17,18],"throw":[20,4,38],comparison:[0,4,14,25,7,41,17],passivedefault:25,firebird:[19,9,1,13,15,18],engine1:[34,7],"__setslice__":29,msbiginteg:[11,32],degre:[34,12],intens:38,stand:32,act:[0,32,26,34,7,36,38,15,28,17],lightli:0,routin:[0,28],convert_unicod:[32,36],anon_1_address_count:12,effici:[4,35,8,23,40,29,17],checkconstraint:[25,18],"_tabl":17,quietli:0,asfrom:3,sessionmak:[9,21,12,34,7,39,41],bhargan:17,mark:[34,0,32,4,12,14,7,38,25,40,41],your:[19,0,37,34,11,32,4,12,26,6,7,38,15,35,28,29,17],lob:[9,1,33,13],opengi:11,log:[9,12,7,36,38,15,35,28],her:12,area:[0,39,6,8],aren:[25,14,4,41],autoload_with:[25,18],overwrit:4,start:[34,0,37,23,12,26,14,7,38,15,25,40,41],interfac:[0,36,9,22,40,4,41,13,34,25,8,15,31,29,18],low:[0,8],lot:[0,12,6,38,15,28,17,18],addresses_1_email_address:[0,12,38],strictli:15,hey_use_this_instead_for_iter:0,treat:[34,0,37,11,4,12,14,25],verbatim:25,enough:[17,38],tupl:[0,39,2,4,12,34,7,36,38,28,40],bundl:[40,29,18],regard:[34,33,14,25,23],mediuminteg:11,sidnam:15,msset:11,congratul:35,"__get__":4,notat:0,dirti:[34,7,12,41],possibl:[0,12,34,7,36,35,39,29,18],"default":[0,37,4,6,7,8,9,11,12,13,14,15,16,17,18,19,22,23,25,26,28,32,33,34,35,36,38,39,40,41],picki:[20,38],unusu:29,pref_id:18,foreignkei:[0,39,4,12,14,25,38,26,28,18],select_t:4,embed:[34,0,9,3,12,14,38,40],expect:[0,4,12,36,38,39,17],gone:[34,36],uid:[37,28,25],creat:[0,37,2,4,6,7,8,9,11,12,13,14,15,16,17,18,19,22,23,25,26,28,32,34,35,36,38,39,40,41],certain:[15,0,14,34,38],threadloc:[9,34,35,36,15,7],deep:[0,4,12],strongli:[0,23],intro:[9,34,38],scope_ident:37,file:[10,21,34,25,36,23,15],max_overflow:[35,36],trace:32,encompass:18,incorrect:[20,32,40],again:[0,20,11,32,12,34,7,38,17],collid:34,googl:[0,12],count_1:[12,38],append_from:14,engine_twophasetransact:7,hybrid:[25,38],prepend:4,field:[19,0,37,39,32,12,14,7,36,38,25,28,17],valid:[0,20,2,9,11,4,12,34,25,38,40],"_set_email":0,presenc:[34,14,12,38],manager_data:0,you:[0,37,4,34,7,8,11,12,15,17,18,19,20,23,25,26,28,29,32,33,6,35,36,38,39,40,41],version_id_col:4,registri:[39,34],users_1_id:12,sequenc:[0,1,33,14,9,37,13,6,25,36,16,29,18],symbol:28,vertex:0,validate_email:0,main_tabl:25,ansi:[11,33,14,38],vocabulari:38,encount:[0,32,4,34,38,40],golf_sw:39,concat:[14,25,32,38],unitofwork_contextu:34,dict_of_properti:4,dbengine_implicit:38,unload:[7,4,41],directori:28,descript:[34,14,6,36,15,18],msdate:11,has_op:41,mimic:28,metadta:25,potenti:25,escap:[11,14,25],invoic:18,columnproperti:[0,4],unset:36,loans_book_id:17,base_mapp:4,all:[0,37,2,4,6,7,8,9,10,11,12,14,15,17,18,19,20,21,23,25,26,28,29,32,33,34,35,36,38,39,40,41],forget:15,messi:38,"__table_args__":39,scalar:[0,9,4,12,14,7,36,38,25,28,40,18],correl:[0,9,4,14,36,38,40],higher:[11,4,12,6,38,15,18],timetupl:14,follow:[19,0,37,10,11,34,12,14,7,36,38,15,25,35,40,17,18],employees_nam:0,children:[26,0,34,4],dsn:[15,37],snif:28,altercolumn:3,articl:[0,40],program:15,length_function_nam:19,scratch:[6,32],introduc:[19,0,12,38,15,39],has_window_func:37,global:[15,34,7,18],straightforward:[0,39],getattr:28,fals:[34,0,37,39,23,11,32,4,12,33,14,7,36,38,15,25,35,28,40,41,18],checkin:[15,8,36],append_ddl_listen:25,pjoin_typ:0,util:[0,2,9,4,13,14,15,31],msblob:11,rowproxi:[4,36],failur:[24,34],veri:[0,20,23,4,12,26,34,38,15,28,29,17],ticket:20,condition:25,scopefunc:7,cart_id:18,polymorphic_iter:4,longtext:11,list:[0,37,4,34,7,9,11,12,14,17,18,19,20,25,26,28,29,32,6,35,36,38,40,41],create_row_processor:41,nulltyp:[14,32],entity_nam:0,adjust:19,pjoin_manager_data:0,small:[0,38],superced:14,flintston:38,unique_param:[14,25,38],ten:15,aptli:18,"_get_email":0,postgr:[32,3,34,7,36,15,25,35,39,16],design:[15,6,4,34],pass:[0,37,2,3,4,34,7,11,12,14,15,16,17,18,19,21,23,25,26,28,29,32,33,35,36,38,39,40,41],further:[34,0,14,9,12,24,33,6,25,38,15,28,41],pyodbc:[15,24,37],"_binaryexpress":38,trick:[0,38],deleg:[0,35,29],abc:18,sub:[11,32,4,14,25,29],section:[34,0,32,33,6,35,38,15],abl:[12,34,7,38,15,18],brief:14,overload:14,delet:[19,0,34,9,4,12,26,14,7,36,38,15,25,39,40,41,17,18],version:[19,0,1,33,14,34,9,11,4,12,24,13,6,36,37,38,39,20,17],primary_kei:[0,37,39,33,11,32,4,12,26,14,25,36,38,15,28,16,17,18],intersect:[14,40,38],visit_alter_t:3,localtim:14,or_:[0,14,12,17,38],"public":[6,8,36,14],contrast:[25,23],hasn:[12,18],full:[34,0,30,9,11,23,4,12,14,7,36,38,15,35,39,40,17,18],hash:14,postgres_return:16,defaultrunn:36,msbit:11,variat:17,sophist:[29,17,38],append_hav:14,schemaitem:25,behaviour:19,shouldn:34,pub:23,inher:23,ddl_event:25,soon:[15,34,12,23],of_type_op:41,noload:[0,9],modifi:[0,32,2,14,10,9,11,30,4,12,41,13,6,7,36,38,25,28,29,17,18],valu:[0,37,2,4,34,7,11,12,14,15,16,17,18,19,20,23,25,26,28,29,32,33,36,38,39,40,41],join_to_left:40,search:[0,9,33,14,25,36,38],ahead:17,post_id:12,memcach:34,observ:[15,29,38],prior:38,"__composite_values__":[0,4],unlik:[28,7],keyvalu:18,doctest:[0,6,12,17,38],pick:[11,28,25],action:[25,34,7,10],narrow:[0,12],get_bind:7,via:[0,4,34,7,8,9,11,12,14,15,18,25,26,28,29,30,35,36,38,39,40,41],depart:18,primit:14,transit:11,onupd:[0,28,25,18],"0xb79bbbec":28,filenam:[15,35,23],suddenli:12,orderinglist:[26,9,30,13],decrement:15,establish:[34,0,14,4,6,7,38,15,35],select:[34,0,37,32,2,30,9,11,3,4,12,14,7,36,38,15,25,28,40,17,18],row1:15,biginteg:[11,32],proceed:[7,4],distinct:[19,0,14,34,12,6,7,38,15,25,35,40],dynaload:4,regist:3,two:[0,1,4,34,7,9,11,12,13,14,15,16,18,19,23,25,26,28,29,32,33,6,36,38],formul:[0,34,41],con_proxi:8,taken:[0,37,11,33,14,25,23],msnchar:[11,37],anscestor:[14,25],more:[0,37,3,4,34,7,8,9,11,12,14,15,17,18,20,23,25,26,28,33,6,35,38,40],reachabl:29,flat:0,desir:[0,37,4,41,34,35,36,15,40,29],mappedus:17,"_get_statu":4,mstinytext:11,flag:[34,0,37,11,23,4,12,33,14,7,36,38,15,25,40,41,18],particular:[19,0,20,14,10,11,34,32,4,12,6,7,36,23,15,25,35,40],known:[34,0,1,9,4,12,24,13,14,25,37,38,15,29,17],post_keyword:12,cach:[34,7,38],none:[0,37,4,34,7,8,11,12,14,17,21,25,26,28,29,32,35,36,38,39,40,41],ix_mytable_col2:18,someindex:18,hour:[19,36],hous:40,sldatetim:23,isinsert:36,endswith:[14,25],histori:[7,4,41],remain:[12,34,35,36,38,15,7,40],del:[34,12,17],caveat:25,primary_languag:39,"__mapper_args__":39,someobject:[34,4],aliasedclass:[34,40],after_begin:41,prompt:[6,12,38],substanti:10,useabl:[0,36],challeng:33,flush_context:41,share:[34,0,39,4,14,25,8,23,15,28],remote_sid:[0,4],templat:25,minimum:11,identity_key_from_row:4,strlen:19,engineer_mapp:0,supports_pk_autoincr:36,huge:38,append_el:25,cours:[0,11,23,34,7,38,17,18],awkward:28,secur:12,programmat:[6,14,38],anoth:[34,0,11,4,12,14,25,38,15,35,18],mapped_collect:[0,29],mediumtext:11,of_typ:[0,41],columnkei:25,simpl:[34,0,20,39,9,4,12,14,38,26,28,29,17],unabl:37,resourc:[36,11,12,34,7,8,38,15,35,18],referenc:[0,4,12,34,7,38,15,25,18],"_get_attr":39,unixodbc:24,variant:[0,7,38,15,25,18],sneak:12,reflect:[34,0,1,33,9,11,32,12,13,14,25,36,38,26,28,17,18],catalog:[12,38],offset:[0,1,33,9,12,13,14,37,38,40],prefix_with:14,associ:[0,4,34,7,9,10,12,13,14,15,16,17,18,25,28,30,33,36,38,39,40,41],circumst:18,"short":[11,15,17],confus:[19,40,23],"__name__":0,stash:36,ambigu:[34,7],caus:[20,34,7,36],callback:35,informixdb:15,ddlcompil:3,longblob:11,isout:[40,14,25,17],referenti:[40,0,7,4,9],help:[34,38],autoload:[11,33,25,36,39,18],ordering_list:26,held:[15,28,35,34,23],scott:[15,39,35],reconnect:[35,36],hierarchi:[0,39,4,36,9],paramet:[0,37,4,7,8,9,11,12,14,15,18,19,20,25,28,32,33,35,36,38,39,40],style:[34,0,20,11,4,12,14,7,36,38,15,25],render:[37,38,14,25,23,39,40],overhead:[0,33,34,35,8,23,15,16],itervalu:0,psycopg2:[15,35,16,36],psycopg1:16,dbname:[37,33,35,36,15,16],html:[33,23],post_upd:[0,4],might:[0,39,23,4,12,34,36,38,28],alter:[19,3,25,36],finer:25,tri:[19,34,40,29],good:[0,11,12,34,15,41,18],"return":[0,1,2,3,4,6,7,8,9,11,12,13,14,15,16,17,18,19,20,23,25,26,28,29,32,33,34,35,36,38,39,40,41],get_dbapi_typ:32,quote_plu:37,timestamp:[11,15,19,14,32],nospam:17,framework:[34,35],ninja:28,detach:[2,34,7,8,38,40,36],bigger:34,get_properti:4,treenod:0,troubleshoot:[11,9,1,13],solver:7,mycompar:[0,4],refresh:[9,4,12,34,7,40],did:[34,38],adalias_address_id:0,innodb:[11,0,39,4,18],compris:[0,14,18],fulli:[0,37,11,40,32,4,12,34,7,23,16],unicod:[9,1,23,11,32,37,13,14,25,36,38,39,40,18],schema_nam:37,name_1:38,fcolumn:18,hard:38,idea:[34,7,18],procedur:[34,14],realli:[34,38],heavi:38,except_al:[14,40,38],connect:[1,37,6,7,8,9,10,11,12,13,14,15,16,18,19,20,22,23,25,33,34,35,36,38,39,40,41],supports_default_valu:36,stabl:[11,41],mapperextens:[0,40,34,4,41],adalias_user_id:0,beyond:[0,34,36],todo:[15,24,20,7],event:[0,10,4,41,25,8,7,35,29],reconstitut:4,existing_object:34,"try":[15,34,12,38],safeti:15,"0x9272a4c":28,publish:10,research:20,utf8:11,print:[34,0,21,36,40,3,12,14,25,8,38,15,28,16,17,18],mstime:11,occurr:12,cright:[14,25],qualifi:14,oid:4,proxi:[0,39,2,4,14,35,8,15,28,36],uncommit:36,advanc:[0,30,9,13,6,17],mypackag:34,differ:[19,0,20,39,34,23,32,12,14,7,36,37,38,25,28,40,18],committ:36,asc:[14,25,38],reason:[0,32,33,34,35,23,15,40],base:[0,37,3,4,34,7,8,9,11,12,14,15,16,17,18,23,25,26,28,29,32,33,35,36,38,39,40,41],ask:[15,9,19,34],heroic:11,gig:38,thrown:[7,34,4],columnoper:14,secondary_t:0,thread:[19,9,1,33,4,13,34,7,36,23,15,25,35,17],cls_or_mapp:40,omit:[0,39,25,36],intermingl:38,msfloat:11,perhap:25,lifetim:[41,4,8,29],assign:[34,0,39,4,12,14,25,36,38,26,28,29],feed:[15,40,38],major:[11,0,6,33],holdings_t:28,notifi:29,obviou:0,prevent:[7,34,4,36],msmediumblob:11,mysql_limit:11,lastnam:0,number:[34,0,11,32,4,12,33,14,7,8,26,25,35,28,40,36],placehold:32,done:[0,20,39,34,7,36,38,35,28,18],construct:[0,37,2,3,4,6,7,9,11,12,13,14,15,31,17,18,21,22,25,28,16,32,33,34,35,36,38,39,40],blank:[25,0,14,4,12],load_dialect_impl:32,miss:11,stage:[0,4],is_bound:25,guess:38,php:10,script:6,column_kei:[14,25],ipaddress:32,interact:[15,39,34],join_depth:[0,4],least:[34,25,12,38],"_binarytyp":11,stori:19,order_bi:[0,21,4,12,14,38,26,39,40,17],statement:[0,37,2,3,4,34,7,8,9,11,12,13,14,15,16,17,18,22,25,32,33,36,38,39,40,41],jek:28,scheme:[26,35,34,4],store:[34,0,11,32,4,12,14,7,36,38,26,25,35,29,17,18],schema:[9,20,14,33,11,3,4,37,13,6,25,36,22,39,17,18],option:[0,37,4,34,7,9,11,12,13,14,15,31,17,18,21,23,25,26,28,16,33,35,36,38,39,40,41],translate_row:41,left_id:0,users_user_id:0,getter:[0,39,28,4],bidirect:12,datamapping_join:0,myclass:[0,21,4,34,7,39,29],fred:[12,38],kind:[19,0,10,4,34,38,15,39],contrari:[12,38],whenev:[15,34,12],remot:[0,4],remov:[34,0,4,12,41,14,25,7,35,28,40,29],adapt_oper:32,horizont:[9,34],reus:35,for_upd:[14,25],str:[0,32,11,3,12,14,25,36,38],arrang:4,stale:34,toward:[19,33,16,36],typic:[34,0,21,23,32,4,12,14,7,36,38,15,25,35,39,40,41],accomod:23,get_dialect:36,comput:[40,4],yeee:34,packag:[34,0,14,11,32,4,12,6,15,39,29],expir:[9,4,34,7,15,40],properli:[0,37,4,7,36,15,29],"null":[0,20,11,4,12,14,25,37,38,18],sell:10,myawesomelist:0,relationship:[34,0,9,4,12,14,7,25,28,40],equival:[19,37,32,4,12,14,7,25,41,17,18],self:[0,39,32,2,9,3,4,12,34,7,8,38,26,28,40,29,36],violat:[0,34],also:[0,37,3,4,34,7,8,11,12,14,15,17,18,20,23,25,26,28,29,32,33,6,35,36,38,39,40,41],build:[34,0,30,9,32,12,13,6,25,36,28],someurl:8,unicodetext:32,user_orders_t:34,proxy_factori:28,attr_nam:29,someaddress:[0,12],selectcontext:41,distribut:[28,6,10],exec:41,previou:[0,11,4,12,33,34,40],reach:35,most:[34,0,39,11,32,4,12,6,7,36,38,15,35,28,40,41,17,18],plai:38,assoc:0,server_default:[11,25,18],myisam:[11,4,17,18],alpha:11,corresond:23,charg:10,appear:[11,37,25],msntext:37,max_identifier_length:[37,36],backref:[0,39,28,4,12],exc:[40,8,12],clear:[12,34,25,38,7,40,17,18],bdb:11,cover:[6,12,17,38],sldate:23,salari:[19,14],"_some_attr":39,ext:[9,39,30,21,3,12,13,6,26,28,40,17],part:[0,4,34,7,36,38,15,25,39,29],clean:40,stepz:28,pars:[37,34,36,23],latest:6,microsoft:37,carefulli:38,use_alt:25,consult:[35,34,7],session:[34,0,39,30,21,9,11,40,4,12,41,13,6,7,15,28,31,29,17],particularli:[0,34,35,23,15,7],sqla:[33,3,16],fine:[28,17],find:[40,17],email1:12,impact:15,coerc:36,"_testsql":17,copyright:10,visit_alter_column:3,solut:34,users_1_password:12,unus:23,users_nam:[0,12,17,38],express:[0,3,4,6,9,10,11,12,13,14,15,17,18,19,21,22,25,34,36,38,39,40,41],nativ:[20,32],use_unicod:11,mainten:7,do_begin:36,liabl:10,ambiti:0,table_iter:[25,18],display_width:11,restart:8,ansifunct:14,retreiv:4,common_par:4,cyclic:4,mylisten:8,rfc:[15,36],item_id:18,common:[34,0,9,32,4,12,14,25,36,38,15,35,18],as_scalar:[14,38],set:[0,1,2,4,37,6,7,9,11,12,13,14,15,17,18,19,23,25,26,28,29,32,33,34,35,36,38,39,40,41],dump:[15,32,21],sep:33,from_self:40,after_flush_postexec:41,mutabl:[26,0,32,9],"_branch":36,see:[34,0,37,2,33,11,32,4,12,41,26,14,7,36,38,15,25,28,40,29,17],cart_id_seq:18,arg:[0,2,21,11,32,4,14,7,36,25,40,41,17],reserv:25,clear_mapp:[4,12],local_t:4,recommed:37,users_fullnam:[0,12,38],analog:[0,38],glue:0,inconveni:28,tableclaus:[14,25],someth:[0,25,12,38],frmo:[14,25],weakli:34,nopk:17,won:[0,11,4,8,38,26,28],mutex:7,idx_col34:18,statement_compil:36,experi:0,nope:34,instrument_class:41,underi:25,altern:[34,0,9,11,32,4,12,33,14,7,36,38,26,25,39,40,18],signatur:[14,2,8,32],popup:[12,38],identity_insert:37,last_insert_id:36,treenodes_1_id:0,numer:[20,11,32,12,14,38,28],complement:[0,4],sole:[0,32],getset_factori:28,disallow:15,succeed:15,unitofwork:[15,7],pymssql:[15,37],on_link:29,instrument_declar:39,classnam:17,ctest:14,popul:[0,4,12,34,7,28,41,18],both:[34,0,11,3,4,12,26,14,35,8,38,15,28,40,17,36],is_liter:14,last:[34,7,36,38,16,17],delimit:7,target_fullnam:25,noresultfound:[40,12],alon:32,foreign:[34,0,9,11,4,12,14,7,38,25,40,29,17,18],context:[34,9,21,12,14,7,8,38,15,25,40,41,36],author_id:39,whole:[15,19,36,38],load:[0,37,30,21,9,11,32,4,12,13,34,7,36,23,15,25,28,40,41,17,18],"_label":14,simpli:[0,32,4,35,23,28,18],point:[19,0,9,11,4,12,26,34,7,38,15,25,16,29],instanti:[34,7,12,36,18],schedul:7,loan:17,arbitrarili:17,param:[20,32,4,12,14,7,8,38,25,35,40,36],suppli:[0,20,39,11,32,4,14,25,36,26,35,28,29,18],managers_manager_data:0,throughout:[41,34,12,38],backend:[19,9,1,12,24,13,14,25,36,18],vertic:[0,34,9],user_id:[0,39,12,26,38,15,28,18],addresses_1_user_id:[0,12,38],due:[32,12],empti:[0,39,34],implicit:[15,9,25,36,38],whom:10,secret:38,addressus:0,fbdialect:19,create_d:18,adalias1:12,strategi:[19,0,9,12,34,36,15,40],clauseparamet:36,after_bulk_upd:[40,41],fire:[0,36,4,12,8,29,18],beforehand:[34,16],convert:[0,37,11,32,4,33,14,25,36,38,15,40],unnecessarili:0,related_user_id:0,coordin:[0,34],understand:[15,0,38,9],func:[0,11,12,14,38,39,40,17,18],demand:[11,20,28],repetit:25,process_:32,look:[0,39,23,12,33,34,7,38,28,18],employee_dept:18,solid:0,straight:[0,12,14,25,36,40],erron:12,histor:23,oldvalu:[2,41],"while":[19,0,37,12,38,15,28,17,18],executemani:[38,16,8,36,18],smart:17,behavior:[0,1,4,37,34,7,8,9,11,12,13,14,15,16,18,23,25,26,28,29,30,32,33,35,36,38,39,40,41],create_connect:35,anonym:[0,14,25,38,40,18],subsitut:25,awesomelist:0,table_nam:36,ordereddict:0,readi:[0,7,12],key2:15,key1:15,"__main__":28,someentri:0,itself:[19,0,2,3,12,33,34,7,36,38,15,25,39,40,41,18],supports_sane_rowcount:36,limit:[0,1,4,37,34,7,9,10,11,12,13,14,17,18,20,38,26,33,35,36,23,40],"_statu":4,pref_nam:18,weakref:35,decor:[0,32,2,9,3,4,41,13,35,36,39,31,29],employee_id:[0,18],myothert:0,realiti:34,description_encod:36,get_refer:25,belong:[25,7],libc:23,decod:32,apply_label:[0,38],pjoin_nam:0,conflict:[0,14,12,38],"__repr__":[0,28,12],optim:[11,0,33],text_as_varchar:37,contains_eag:[0,40],mytyp:32,edspassword:12,alert:38,temporari:7,user:[0,37,34,7,12,14,15,16,17,18,19,21,38,25,26,28,32,33,6,36,23,39,40,41],remote_t:[39,25],repopul:34,wherev:[14,38],stack:[32,7],recent:[11,12,34,25,7,40,17],enable_typecheck:4,travers:[28,14],task:[40,34,25],machineri:29,expire_al:[40,34,7],older:11,entri:[0,28,25,38],elem:4,compile_mycolumn:3,pickl:[0,32,21],person:[39,40,10],chees:[28,6],expens:[35,7],create_connect_arg:36,book:[0,17],append_foreign_kei:25,colspec:19,iterate_inst:40,root_connect:36,relianc:23,shape:0,mysql:[34,0,1,9,11,32,4,12,13,14,25,36,38,15,17,18],mapped_t:7,elect:11,eager_column:0,from_obj:[0,14,40,17,38],rundown:12,cut:[34,14],signal:11,users_table_2:18,shortcut:[0,25,12,36,38],mydatabas:15,cue:4,invalidrequesterror:[7,17],passthrough:7,email_address_2:38,email_address_1:38,subsequ:[40,12,26,34,7,38,15,16],posts_headlin:12,useless:23,saniti:38,varchar:[0,37,11,32,12,38,18],obsolet:41,mapperproperti:[0,4,2,41],format:[0,21,23,12,14,25,36,38,15],big:[0,34],intuit:[39,17],"__gt__":0,falcon:11,bit:[11,38],characterist:12,like:[0,37,4,34,7,8,11,12,14,15,17,18,20,23,25,26,28,29,32,33,6,35,36,38,39,40],table2:[15,40],outright:15,table1:[15,14,40],sessionextens:[40,34,7,41],uninstall_descriptor:41,table_info:[38,12,18],bulkpric:14,bindparam:[14,25,38],resolv:[39,7],resultproxi:[34,40,14,7,36,38,15,16,17,18],use_label:14,collect:[34,0,39,9,40,4,12,41,26,13,14,7,36,38,15,25,35,28,31,29,18],query_class:4,api:[34,0,20,32,14,36,9,11,3,13,6,35,8,38,22,28,41,30],msvarbinari:11,popular:6,interestingli:38,defaultexecutioncontext:36,my_string_1:14,user_top_ten_list:26,myobject:34,essenti:[15,0,16,36,17],often:[0,37,7,38,15,17,18],simplifi:[34,9,28,30,13],empl:19,my_string_3:14,some:[0,4,34,7,11,12,15,16,18,20,24,25,26,28,29,32,33,35,36,38,39,40,41],back:[0,39,9,11,32,12,33,23,34,7,8,38,15,28,40,36],understood:[34,4],unspecifi:36,sampl:38,order_t:34,child_id:0,surpris:38,scale:[11,6,12,32],firebird_return:19,get_col_spec:32,pep:35,per:[19,37,11,4,14,25,36,23,15,35,16,41,18],prop:[4,40,39,2,41],attribute_nam:7,substitut:[11,0,25,29],larg:[0,12,9],object_sess:[0,34,7,41],slash:[15,23],connectionproxi:8,either:[34,0,37,39,30,11,4,12,33,14,7,8,38,15,25,28,40,17,36],myset:11,run:[34,37,2,4,12,24,6,7,38,15,41],contextual_connect:[15,7,36],word:[0,37,14,25,38],bind_mapp:7,loans_loan_d:17,reverse_oper:[14,25],adalias_email_address:0,"_null":14,deferredcolumnproperti:4,zzk:28,col4:18,prerequisit:38,elixir:12,from:[0,3,4,6,7,8,9,10,11,12,14,15,16,17,18,19,20,21,23,24,25,26,28,29,32,33,34,35,36,38,39,40,41],widget_id:0,schemagener:36,is_mut:32,internally_instru:29,varbinari:11,rowcount:36,bind_tabl:7,sysop:33,polymorphic_fetch:4,reset_joinpoint:40,block:17,plan:[11,41,38],moss:17,primarili:[40,14,25],within:[34,0,14,23,32,4,12,41,6,7,36,38,15,25,35,39,40,29,17,18],manager_of_class:4,phase:[34,9,1,33,11,13,14,7,36,15,16,29],"_comparemixin":14,managers_employee_id:0,ix_:18,ensur:[34,0,11,4,12,14,7,38,15,40],chang:[0,4,34,7,9,11,12,14,15,17,19,20,25,26,28,29,32,6,36,38,40,41],anon_1_users_id:12,with_polymorph:[0,40,4],call_operation1:15,unit_pric:14,span:[0,34,8,17],install_descriptor:41,question:[9,34],non_primari:[0,4],textual:[14,36,38],custom:[0,39,32,9,22,3,4,12,26,13,34,7,15,35,28,41,18],juicier:38,includ:[21,0,37,14,10,11,34,3,4,12,33,6,7,36,38,15,25,39,40,29,18],suit:11,optionaldict:[14,25],paren:29,compositeproperti:[0,4],clear_manag:35,outparam:14,with_par:[0,40,2,12],literal_column:14,utf8_bin:[14,25],repeatedli:[7,35,4,38],include_column:[25,36,18],identityset:12,append_prefix:14,enable_eagerload:40,pwd:37,link:[15,0,25,12,38],translat:[0,14,36,32,23],newer:[19,34],unitofwork_cascad:34,ulist:0,article_keyword:40,line:[34,0,12,6,38,15,41],union_al:[14,40],info:[15,25,8,36],concaten:[14,32,38],row2:15,utf:[32,36,38],consist:[0,34,36,38],nodealia:0,caller:25,execute_at:25,lifespan:[9,34],sinc:[0,23,4,12,33,34,35,38,15,39,40,17],someus:12,preexecute_pk_sequ:36,lazyload:[0,40],sum:14,similar:[34,0,21,11,4,12,14,25,36,38,18],impl:32,reconstruct_inst:[0,41],sort:[15,34,25,17],user2:34,user1:34,after_insert:41,repres:[34,0,39,36,23,4,12,14,25,8,38,15,28,40,18],"char":[11,32],typecolnam:2,queueish:29,supports_sane_multi_rowcount:36,home:15,target_class:28,shopping_cart:18,attribute_shard:34,mslongtext:11,mssql:[15,37],unalias:14,titl:[0,17,38],invalid:[0,12,35,8,7,36],addresses_email_address:[0,12,38],librari:[34,0,12,6,35,15],edwardo:12,ellipsi:[12,17,38],mymetadata:39,deseri:21,intersect_al:[14,40,38],mustard:17,"_create_hold":28,totyp:14,william:[12,38],echo_pool:[15,36],meaning:7,reportedli:20,"_stringtyp":11,vice:0,confirm:25,do_get:35,discrimin:[0,39,40],depth:[0,29],compatibil:37,came:38,far:[0,4,12,17,38],fresh:[0,34,8],hello:34,usagerecip:7,years_with_count:17,code:[0,4,34,7,38,35,17],optimized_:0,name_label:12,"__mapper__":39,elment:[14,25],has_kei:36,last_upd:18,edu:17,privat:41,procur:36,current_us:14,elsewher:0,company_id:0,send:[0,32,4,34,36,38],granular:7,lower:[15,0,19,20],becam:38,visitor:[14,25,36],setup_encod:35,aris:[10,38],fatal:11,sent:[11,32,4,14,7,36,38,15,25,35,41],passiv:[0,7,36,9],gjffdd:12,rollback:[12,34,35,36,15,7,41],with_label:[40,17],after_upd:[40,41],nosucht:17,mymappedclass:[0,34],untouch:34,implicitli:[15,39],relev:25,recip:[34,29],magic:[26,38],fromclaus:[14,25],treenodes_parent_id:0,michael:10,fewer:[4,38],connection_memo:36,mssmallinteg:11,somecol:[20,14],selectioncontext:41,book_id:[0,17],dealt:12,othercolumn:[14,25],pleas:[11,7],comparator_factori:[0,39,4],impli:[4,12,10],smaller:32,last_updated_param:[36,18],natur:[0,28,4],c_tabl:0,orchestr:29,focu:38,somedb:25,mysqldb:[11,15,36],cumbersom:38,download:[15,6],fullnam:[0,34,25,12,38],odd:29,click:[12,38],append:[0,2,4,12,41,14,25,36,26,28,40,29],compat:[0,1,33,9,11,4,37,13,34,35,36,38,26,39,16],index:[9,1,13,6,25,36,38,26,16,18],compar:[0,37,9,32,4,14,25,7,41],descriptor:[0,39,2,9,4,12,34,28,40,41],fetchxxx:36,resembl:[34,38],access:[0,1,2,4,5,34,7,9,12,13,15,17,18,38,25,28,30,33,36,23,39,40],experiment:[33,20,40],whatev:[19,34,11,4,12,14,36,38,15,40],sybas:[15,9,1,24,13],absolut:[15,0,23],broker:28,othert:11,defaultdialect:36,intercept:[26,8,29],let:[12,34,38,28,17,18],uc_nam:39,becom:[34,7,12,38],accessor:[0,12,14,25,39,40,41,18],acquir:[14,12,34,25,38,7,35],some_sequ:18,great:0,convers:[32,12,33,34,36,38,15,16],larger:[0,14,41],technolog:33,id_1:38,declarativemeta:39,defeat:34,opinion:11,implement:[0,1,4,34,7,8,9,12,13,15,19,20,22,25,26,28,29,32,33,6,35,36,23,39,40,41],honor:0,chanc:7,ddl_listen:25,control:[19,0,9,32,4,12,33,23,34,7,36,38,15,25,40,29],supports_alt:36,parent_assoc:0,win:34,app:34,wil:25,gatewai:17,"boolean":[11,32,4,12,34,25,36],regexp:11,substut:25,refcolumn:25,"_immut":14,"__________":15,tailor:[33,16],cornerston:38,zerofil:11,zip:0,commun:[33,23],doubl:[11,23],correspond_on_equival:[14,25],next:[0,37,4,12,34,7,36,38,15,41,18],websit:12,call_operation3:15,call_operation2:15,sesion:4,jonathan:17,inet:32,interbas:19,isam:0,defaultgener:[25,36],use_ansi:[33,38],initialize_instance_dict:41,is_instru:4,recal:[15,38],identity_key_from_primary_kei:4,central:34,quote_schema:25,roughli:29,keyfunc:[0,29],greatli:28,account:[40,34,7],merged_object:34,retriev:[11,4,12,26,14,7,8,38,15,25,35,16,29,17,36],augment:[0,32,30],alia:[0,32,12,14,25,36,38,40,17],ride:34,annot:[0,29,9],with_lockmod:40,obvious:17,garante:19,meet:[0,4,41],unread:33,fetch:[37,40,33,25,36,15,16,29,17,18],employe:[0,40,41,18],sqlite:[0,1,9,32,4,12,13,23,7,36,38,15,25,35,39,17,18],trustedconnect:37,drop_spow:25,plate:34,process:[34,0,32,3,4,12,41,14,25,8,38,35,29,18],lock:[34,40,14,35],compatibiil:37,high:[23,8,36],piecem:38,tag:0,entry_id:0,opensourc:10,onlin:0,serial:[9,1,30,21,32,13,34,26,16,18],adapt_typ:36,sqltype:19,filepath:23,removes_return:29,nvarchar:11,memoiz:36,conn:[15,34,35,8,38],sid:15,instead:[19,0,37,34,11,40,32,4,14,7,36,38,15,25,35,28,16,29,17,18],stock:28,published_year:17,overridden:[0,32,4,18],append_whereclaus:14,lower_1:0,watch:[12,38],unmanag:4,class_:[7,4,41],reconcil:34,inst:41,attent:12,smartli:11,redund:0,do_release_savepoint:36,check_same_thread:23,callable_:36,alloc:[15,36],urldecod:37,add_al:[34,7,12],our_us:12,pyweboff:17,bind:[34,9,20,21,32,12,33,14,7,36,38,15,25,39,40,17,18],counter:[15,36],correspond:[34,0,40,32,4,12,14,7,36,38,25,35,16,41,17,18],element:[34,0,32,3,4,12,14,25,36,38,40,41,18],issu:[0,1,4,37,34,7,9,11,12,13,15,16,18,38,24,25,32,33,35,23,39,40,41],addresses_2_email_address:12,allow:[34,0,37,36,11,32,4,12,41,23,14,7,8,38,15,25,35,39,40,29,18],subtyp:[0,9],from_joinpoint:[0,40],fallback:40,comparable_properti:[0,39,4],clauseel:[0,3,4,14,7,8,38,25,40,41,36],furnish:10,some_table_id:39,charset:11,creation:[19,0,32,11,3,7,8,15,25,35,41,36],jigger:38,tribe:38,move:[12,34,35,23,7,39],own:[34,0,23,32,4,12,41,33,6,7,36,38,15,35,39,29,18],comma:[34,37,14,4],primarykeyconstraint:25,bunch:28,outer:[0,20,4,12,33,14,25,38,40],ext2:0,ext1:0,disambigu:[40,17],yield_curve_2:14,yield_curve_1:14,pjoin_employee_id:0,msstring:[11,37,32],"_updatebas":14,purg:7,therefor:[15,0,40,41,18],typemap:[14,36],tometadata:[25,18],crash:20,greater:[11,0,15],"__getitem__":29,python:[0,37,4,6,7,8,9,11,12,14,15,16,17,18,20,21,23,25,26,28,29,32,33,34,36,38,39,40],auto:[34,9,1,33,11,37,13,14,7,36,35,18],spell:[0,40],innermost:7,handi:18,devel:20,mention:[15,33,38],front:[39,6,7],bar:[0,11,40,12,34,38,15,16],manager_mapp:0,close_with_result:36,instrumentedcollectionattribut:29,"__delitem__":0,somewher:34,trac:7,anyth:[0,12,36,38],tran:[15,34],shard:34,autoflush:[40,39,34,7],oracledialect:38,slide:26,mydefault:18,mode:[19,9,1,34,33,11,37,13,14,7,36,40],batch:[33,40,4],circular:25,upward:18,subset:[25,7,14,4,18],columndefault:[25,36],platform:24,sql2005:37,strip:32,loan_dat:17,sql2000:37,dialect_impl:32,meta:[0,39,9,32,12,6,25,38,15,28,18],"static":[41,18],our:[0,34,12,17,38],special:[0,39,11,32,4,14,7,38,15,25,28,16,18],out:[0,4,34,7,8,10,11,12,14,15,17,18,21,38,25,26,28,29,32,35,36,23,39,40],variabl:[11,32,12,34,7,38,15,39],do_commit_twophas:36,should_autocommit_text:36,highest_ord:0,automag:37,categori:36,suitabl:[26,40,12,17,36],rel:[32,26,7,23,15,38],passive_cascad:0,merg:[9,10,4,34,7,41],metaclass:39,excess:23,emp:14,high_prior:11,insid:[15,39,12,36,38],parenthesi:38,user_alia:12,schema_item:25,manipul:[26,6,38],standalon:[12,17,18],york:0,dictionari:[34,0,39,36,9,4,12,14,7,8,38,15,25,35,28,40,29,18],releas:[11,34,7,36,15,25,35,16,41],afterward:[34,12],always_refresh:4,b_tabl:0,unquot:11,unnam:[25,18],cartitem:18,put:[26,0,36,38],mstimestamp:11,counterpart:0,length:[19,37,11,32,12,36,38],tack:38,bytea:32,outsid:[15,0,37,14,34],append_correl:14,odbc_connect:37,stuck:38,method_a:15,softwar:[10,23],expire_on_commit:[34,7],mustexist:25,ext_stop:41,scene:[15,26],echo:[15,35,12,36,38],date:[19,9,1,23,11,32,37,13,14,7,38,18],do_rollback_twophas:36,auto_convert_lob:33,facil:6,msmediuminteg:11,reflectt:36,defaultclaus:25,"_numerictyp":11,seq:18,strict:[11,34],unknown:[0,14,32],instrument_attribut:41,creator:[15,28,35,8,36],system:[35,6,7,12,32],wrapper:8,attach:[2,4,12,34,25,38,7,28,41],eager_default:4,"final":[34,7,36,38,15,41],misunderstood:25,do_begin_twophas:36,userkeywords_t:[0,28],shell:37,instancest:4,boston_address:0,"__del__":[15,35,4],pool_siz:[35,36],gotcha:34,fetchmani:[33,36],specfic:15,userkeyword:[0,28],udf:19,association_t:0,query_properti:7,exactli:[34,0,11,12,14,25,38,35,40,17],haven:[15,38],surround:[11,25,7],get_histori:4,unmap:4,prune:7,morph:38,sqlsoup:[9,30,17,13],charact:[9,1,11,32,13,25,36,23],loglevel:36,psycopg:[15,35],sens:[34,7,38],engineers_engineer_info:0,sensit:[20,14,25],before_flush:41,result_processor:[32,36],biggi:11,plaintext:11,after_rollback:41,deprec:[11,4,14,7,36,25,39,40],identifierprepar:36,ref_num:18,have:[0,4,34,7,8,11,12,14,15,16,17,18,38,25,26,28,32,33,35,36,23,39,40,41],close:[9,23,12,34,7,8,38,15,35,29,36],need:[0,37,2,4,34,7,8,11,12,14,15,16,17,18,19,20,23,24,25,26,28,29,32,35,38,39,40],turn:[34,0,37,32,14,36,38,15,40,17],users_classnam:17,"_connectionfairi":8,min:14,back_popul:[0,4],rout:[0,39,36,9],whatsoev:[34,25],situat:[28,36,17],mix:[0,23],builtin:[9,22,4,13,35,38],columnclaus:[3,25,14],polymorphic_ident:[0,39,4],which:[0,37,2,3,4,6,7,8,9,11,12,14,15,16,17,18,20,23,25,26,28,29,30,32,33,34,35,36,38,39,40,41],mapperopt:40,mit:10,singl:[0,4,34,7,9,11,12,14,15,16,17,18,19,38,25,28,30,35,36,23,39,40,41],defaultcompil:36,subtransact:[34,7],unless:[0,2,23,4,26,34,7,38,15,25],msenum:[11,32],licens:10,oracl:[34,0,1,33,9,20,13,14,25,36,38,15,18],synonym_for:39,eight:36,peek:[28,38],why:38,placement:[0,12],latin1:[11,15],url:[9,37,11,33,25,8,23,15,16,36],setlevel:[15,7],gather:36,hardcod:28,face:6,anon_1_users_nam:12,determin:[0,39,11,4,14,38,15,28],server_onupd:[25,18],built:[34,0,32,12,24,6,23,39,29],constrain:34,"_cach":17,wow:38,inexpens:34,primary_key_from_inst:4,o56asktom:33,dba:[33,38],particip:[11,15,34,25,41],bring:[7,38],join1:17,join2:17,fear:38,sqlcompil:3,trivial:[0,29],anywai:34,setter:[0,39,28,4],highest:[0,12],locat:[34,0,12,14,7,38,25,40,18],hadn:18,clob:32,practic:0,do_execut:36,"_valuesbas":14,jan:32,users_1_nam:12,smallest:11,suppos:[0,38,12,17,18],"__tablename__":[39,12],local:[0,9,4,34,25,7,41,17],meant:36,count:[0,23,4,12,14,25,38,15,40,17,18],kinterbasdb:[15,19],obj2:[34,28],polymorphic_on:[0,40,39,4],pull:[0,34,35,17,18],typeobj:36,familiar:[15,12,38],mappedjoin:17,"0x558f3b0":39,autom:[26,34,38],bean:12,ix_mytable_col1:18,tbl:[19,25,16],db1:34,db2:[15,34],enabl:[34,0,37,9,11,4,12,33,14,35,36,38,15,16],organ:[6,7],twice:[7,12,38],lala:[15,18],y_2:38,y_1:38,include_collect:[7,41],stuff:0,blurb:26,instrumentationmanag:41,contain:[34,0,39,21,4,12,26,14,7,36,38,15,25,35,28,40,41,18],view:[19,0,30,9,4,12,13,34,38,28,16],somemappedclass:[40,7],attibut:26,particp:32,legaci:7,users_user_nam:0,writeabl:0,orphan:[0,9,4,12,34,40,17],clausevisitor:25,qty:14,temporarili:34,bytestr:32,email_address:[0,38,12,18],syntact:14,polymorph:[0,2,4,39,40,41],statu:[15,35,4],error:[34,11,32,4,12,24,33,14,7,36,15,25,18],brokers_t:28,closet:40,process_result_valu:32,boundari:[34,7,36],treenodes_2_data:0,favor:0,state:[0,2,9,4,12,34,7,36,38,15,35,40,41],theta:20,neither:[15,4,38],msbinari:11,email:[0,20,12,38,39,17,18],class_mapp:[34,4],bound:[34,0,12,33,14,7,38,15,25,40,18],del_attribut:4,kei:[0,1,2,4,37,34,7,8,9,11,12,13,14,16,17,18,25,28,29,33,36,38,40,41],in_transact:36,fbcompil:19,sprinkl:34,isol:[34,25,36,38],job:[15,0,34,36],entir:[0,32,4,12,34,7,38,15,40,18],state_gett:41,joe:17,otherwis:[0,39,14,10,23,11,32,4,33,6,25,36,38,15,28,40,41,18],checkfirst:[25,18],disconnect:[35,36],addit:[0,37,23,32,4,12,33,14,7,36,38,15,25,35,39,40,29,18],revers:[0,32,12,25,38,18],sniff:29,admin:17,addres:38,equal:[0,32,12,38,41,17],msmediumtext:11,etc:[34,0,21,36,11,3,4,12,26,14,7,8,38,15,29,18],instanc:[0,37,2,4,34,7,12,14,15,18,19,21,25,26,28,29,32,35,36,38,39,40,41],equat:[0,38],freeli:[0,39,36,38],treenodes_1_parent_id:0,mstext:[11,37],unimpl:32,is_prepar:36,after_bulk_delet:[40,41],someothernam:38,"_set_attr":39,before_commit:[34,41],distinguish:12,broker_id:28,respect:37,expiri:7,unreferenc:7,do_savepoint:36,mstinyblob:11,evalu:[41,39,40,12,38],dont_load:[34,7],addition:[0,35,34,4,38],"__set__":4,trademark:10,compos:[0,4,17],insuffici:7,compon:[20,6,36,38,15,18],disableautoflush:34,slide_id:26,immedi:[34,39,40,32,4,12,14,7,15,25,28,16],partial:[25,34,16],mike:21,mappedloan:17,"__table__":[39,12],myprop:4,resolve_synonym:4,bulk:[40,29,41],basic_tre:0,zero:[11,26,38],x_2:38,togeth:[0,14,4,12,6,7,36,38,15,39],x_1:[3,38],employees_t:0,present:[34,0,37,39,14,33,23,4,12,26,6,7,36,38,15,25,28,40,29,18],populate_exist:[40,4],determinist:38,multi:[11,7],basi:[34,11,4,14,7,15,16,17],compile_mapp:4,somemapp:7,obj1:[34,28],plain:[0,33,9,22,32,4,13,14,7,36,25,35,18],contextu:[15,9,34],cursor:[36,40,33,6,35,8,38,15,16,17,18],defin:[0,3,4,34,7,9,12,13,14,31,17,18,21,25,26,28,30,32,36,38,39,41],singletonthreadpool:[15,19,35,36,23],p_union:2,"3dmydsn":37,dbapi2:[36,23],f8s7cc:12,last_inserted_id:[38,36,18],get_attribut:4,layer:[39,4],customiz:15,helper:[26,0,32,35,34],is_derived_from:[14,25],almost:[26,0],implment:36,post_exec:36,myengin:34,"__metaclass__":39,mulitpl:7,compoundselect:14,lightweight:[0,6,36],incom:[32,36,41],inspector:28,unneed:0,wherea:[0,33,36,38,40,18],do_rollback:36,nullpool:[35,23],uniti:25,ing:[9,38],mutat:[0,28,14,4,29],maxemail:38,parti:[12,36],began:38,install_memb:41,member:[0,12,14,25,28,41],handl:[19,9,1,11,32,4,12,13,34,7,8,37,23,15,25,35,28,20,41,36],eagerload_al:[0,40],largest:35,keywordus:0,do_prepare_twophas:36,"__version__":[6,12,38],fetchon:[15,36,38],infer:12,raw_connect:36,difficult:[0,38],session_us:14,overal:[0,34,36,41],supports_unicode_stat:36,structur:[15,0,34,21,38],denot:[4,23],specialpric:14,expans:25,upon:[0,32,12,33,34,25,36,38,15,7,35,39,41],effect:[19,0,34,11,4,14,7,36,38,15,25,28,16,41,18],dai:19,sqalchemi:37,student:17,nation:11,respons:[26,34,4],expand:[0,36,38],audit:28,items_t:[0,34],transaction:17,nowait:14,well:[19,0,37,14,34,11,4,12,33,6,7,36,38,15,25,35,39,16,41,18],mysql_engin:[11,39,18],concis:17,passive_delet:[0,4],exampl:[0,37,2,4,34,8,11,12,14,15,17,18,25,26,28,29,32,33,35,36,38,40],command:[6,35,12,38],achiev:[34,0,6,35,15,18],oft:25,choos:[0,32,40,41,38],undefin:39,position:36,nchar:[11,32],associationproxi:[0,28,30,13,9],usual:[34,0,20,39,2,11,32,4,33,14,7,36,38,15,25,28,40,41,18],maxdb:[15,9,1,20,13],less:[0,12,34,36,38,39,17],users_trigg:25,obtain:[36,10],"__set_composite_values__":[0,4],expung:[7,34,4,9],identfi:37,current_timestamp:[11,14,38,18],virtual:0,surpass:35,heavili:[6,38],shuttl:0,nextid:18,simultan:[19,35],expert:17,web:[15,34,35],tight:29,nullabl:[0,1,9,12,13,34,25,37,38,28,18],before_upd:[40,41],parent_id:0,opstr:14,cleanup:23,mysql_charset:11,weak_identity_map:[34,7],ado:0,logger:[15,36],kick:12,contains_column:25,jython:[11,15],rememb:15,assert:[26,0,34,36],replace_select:[14,25,38],five:[15,35,36,23],know:[34,0,32,12,14,38,15,18],create_sess:[9,34,7],substit:25,close_al:7,password:[0,11,12,35,36,15,16,17,18],recurs:14,"_enable_transaction_account":7,desc:[0,14,25,38,39,17],instrumentedlist:29,resid:[25,4],addresses_1_id:[0,12,38],lost:23,tinytext:11,opensql:[0,38],necessari:[0,32,17],lose:38,page:[11,9,20,15],didn:38,us_english:37,begin_twophas:36,"export":[14,25],invoice_item:18,flush:[0,9,4,12,41,34,7,15,29,17],proper:[34,0,4,26,14,7,15],guarante:[34,14,35,38,15,25,41],ittybittyblob:11,typeengin:[11,14,36,32],lead:[40,4],avoid:[11,0,38,29,15],add_properti:4,"__getattr__":35,datamemb:36,leav:[0,4,34,7,36,35,39,29],save_or_upd:7,columnon:14,clauseright:14,customer_id:0,aliasnam:[25,14,2],"11g":33,slight:[15,35],inner_column:14,"enum":11,usag:[0,3,4,34,7,8,9,11,12,13,14,15,16,18,21,23,25,30,32,33,35,36,38,39,40,41],docstr:[26,14,34],host:[37,33,35,36,23,15,16],prefetch:33,although:[41,0,4,36,38],interdepend:7,has_tabl:36,simpler:[28,40],about:[34,0,20,11,3,12,6,38,15,39,41],actual:[34,0,23,32,12,41,14,7,36,38,15,25,39,40,29,18],anon_1_email_address:12,column:[0,1,3,4,37,6,7,9,11,12,13,14,15,16,17,18,19,21,22,25,26,28,29,32,33,34,36,38,39,40,41],joinpoint:40,http:[37,10,11,33,34,7,23,16],email2:12,lifecycl:[34,25,8],constructor:[34,0,39,2,9,11,40,4,14,7,36,26,25,28,16,18],discard:[34,35,36,38],users_1_fullnam:12,disabl:[34,0,11,23,4,33,14,7,38,25,35,39,40],mutabletyp:32,postfetch_col:[36,18],easy_instal:6,automat:[0,37,4,34,7,11,12,14,15,17,18,20,25,26,28,29,6,35,36,38,39,40],dataset:17,pool_recycl:[35,36],any_op:41,retunr:40,mere:[14,25],leverag:17,val:25,msaccess:15,intention:38,trigger:[0,9,4,25,15,28,29,18],pool:[19,9,1,34,11,22,12,13,6,35,8,23,15,36],rudimentari:[15,0,12],arg1:39,biggest:19,arg2:39,jason:26,"function":[0,37,2,4,6,7,8,9,11,12,13,14,15,17,18,19,20,22,23,25,26,28,29,30,32,33,34,35,36,38,39,40,41],reduc:[0,34,16,12,33],do_executemani:36,relationproperti:[0,4],select_argu:14,brand:34,orderedproperti:14,gain:38,schema_visitor:25,halt_on:4,"_password":0,overflow:[15,35,36],inlin:[0,20,9,14,25,36,18],eat:34,bue:25,addresses_id:[0,12,38],basicconfig:15,made:[34,0,37,32,39,3,4,12,14,7,38,26,25,35,28,41,18],whether:[37,10,34,25,36,40,41],wish:[0,2,12,34,36,38,15],sess:[40,34,7],order_count:0,displai:[11,26,39,14],"_dbproxi":35,mappedbook:17,record:[0,4,12,34,7,8,35],below:[34,0,11,12,6,35,38,15,39,18],listlik:0,is_disconnect:36,myschemanam:17,setinputs:[33,32,36],query_from_par:40,problem:[11,0,19,37],propcompar:[0,4,41],oldinit:41,"int":[14,7,32],dure:[34,0,11,32,4,41,14,7,36,15,28,29,18],updated_at:28,mysess:34,hit:38,replic:7,keynam:[14,4],probabl:[0,4,23],sessioncontext:34,mutual:[0,4,29,9],in_:[20,14,25,12],automaticali:26,detail:[34,20,14,11,4,12,41,6,36,38,28,29,17],set_committed_valu:4,add_listen:[35,8],other:[0,37,4,6,7,8,9,10,12,14,15,17,18,19,20,24,25,26,28,29,32,33,34,35,36,38,39,40,41],bool:[32,25],futur:[20,11,40,12,25,36,35,16],branch:4,varieti:[34,30,36],treenodes_1:0,process_bind_param:32,stat:14,repeat:[34,35,14,7,36],row_numb:37,"_declarative_constructor":39,superclass:[14,4],raiseerr:4,singleton:[35,25],stai:[15,0],kw1:28,reliabl:40,rule:[0,4,14,7,38,17,18],message_nam:18,portion:[0,14,10,4,12,6,23],ajoin:0,treenodes_2:0,getlogg:[15,7],tinyblob:11},titles:["Mapper Configuration","sqlalchemy.databases","Utilities","compiler","Class Mapping","Access","Overview / Installation","Sessions","Interfaces","Table of Contents","Appendix: Copyright","MySQL","Object Relational Tutorial","API Reference","SQL Statements and Expressions","Database Engines","PostgreSQL","SqlSoup","Database Meta Data","Firebird","MaxDB","serializer","sqlalchemy","SQLite","Sybase","Database Schema","orderinglist","Informix","associationproxy","Collection Mapping","sqlalchemy.ext","sqlalchemy.orm","Column and Data Types","Oracle","Using the Session","Connection Pooling","Connections","SQL Server","SQL Expression Language Tutorial","declarative","Querying","Interfaces"],modules:{"sqlalchemy.orm.collections":29,"sqlalchemy.schema":25,"sqlalchemy.ext.declarative":39,"sqlalchemy.databases.mssql":37,"sqlalchemy.databases.maxdb":20,"sqlalchemy.sql.functions":14,"sqlalchemy.ext.sqlsoup":17,"sqlalchemy.ext.orderinglist":26,"sqlalchemy.databases.firebird":19,"sqlalchemy.orm.util":2,"sqlalchemy.databases.informix":27,"sqlalchemy.pool":35,"sqlalchemy.databases.access":5,"sqlalchemy.orm":7,"sqlalchemy.databases.mysql":11,"sqlalchemy.ext.associationproxy":28,"sqlalchemy.databases.sqlite":23,"sqlalchemy.databases.sybase":24,"sqlalchemy.interfaces":8,"sqlalchemy.databases.oracle":33,"sqlalchemy.sql.expression":14,"sqlalchemy.ext.serializer":21,"sqlalchemy.orm.interfaces":41,"sqlalchemy.types":32,"sqlalchemy.databases.postgres":16,"sqlalchemy.ext.compiler":3},descrefs:{"sqlalchemy.sql.expression.TableClause":{insert:[14,1],update:[14,1],"__init__":[14,1],"delete":[14,1]},"sqlalchemy.sql.expression.ColumnElement":{shares_lineage:[14,1]},"sqlalchemy.schema.DDL":{bind:[25,4],execute:[25,1],execute_at:[25,1],"__init__":[25,1]},"sqlalchemy.types.TypeDecorator":{result_processor:[32,1],process_bind_param:[32,1],is_mutable:[32,1],get_col_spec:[32,1],compare_values:[32,1],dialect_impl:[32,1],bind_processor:[32,1],get_dbapi_type:[32,1],copy_value:[32,1],adapt_operator:[32,1],load_dialect_impl:[32,1],copy:[32,1],"__init__":[32,1],process_result_value:[32,1]},"sqlalchemy.databases.mysql.MSBit":{"__init__":[11,1]},"sqlalchemy.orm.query":{Query:[40,0]},"sqlalchemy.interfaces":{PoolListener:[8,0],ConnectionProxy:[8,0]},"sqlalchemy.sql.functions":{sysdate:[14,0],count:[14,0],min:[14,0],ReturnTypeFromArgs:[14,0],GenericFunction:[14,0],current_time:[14,0],AnsiFunction:[14,0],max:[14,0],sum:[14,0],random:[14,0],localtimestamp:[14,0],session_user:[14,0],char_length:[14,0],coalesce:[14,0],current_date:[14,0],current_timestamp:[14,0],user:[14,0],current_user:[14,0],now:[14,0],concat:[14,0],localtime:[14,0]},"sqlalchemy.ext.sqlsoup":{PKNotFoundError:[17,3],SqlSoup:[17,0]},"sqlalchemy.pool.SingletonThreadPool":{dispose:[35,1],"__init__":[35,1]},"sqlalchemy.sql.functions.char_length":{"__init__":[14,1]},"sqlalchemy.orm.session":{Session:[7,0]},"sqlalchemy.orm.util":{Validator:[2,0],with_parent:[2,2],polymorphic_union:[2,2],identity_key:[2,2]},"sqlalchemy.orm.interfaces.AttributeExtension":{set:[41,1],remove:[41,1],append:[41,1]},"sqlalchemy.engine.url.URL":{get_dialect:[36,1],translate_connect_args:[36,1],"__init__":[36,1]},"sqlalchemy.sql.expression.ColumnOperators":{startswith:[14,1],concat:[14,1],in_:[14,1],like:[14,1],distinct:[14,1],contains:[14,1],ilike:[14,1],endswith:[14,1],asc:[14,1],"__init__":[14,1],collate:[14,1],timetuple:[14,4],between:[14,1],operate:[14,1],reverse_operate:[14,1],op:[14,1],match:[14,1],desc:[14,1]},"sqlalchemy.ext.sqlsoup.SqlSoup":{engine:[17,4],map:[17,1],join:[17,1],bind:[17,4],clear:[17,1],expunge_all:[17,1],with_labels:[17,1],flush:[17,1],entity:[17,1],"__init__":[17,1],"delete":[17,1]},"sqlalchemy.schema.CheckConstraint":{copy:[25,1],"__init__":[25,1]},"sqlalchemy.schema.ForeignKey":{copy:[25,1],references:[25,1],get_referent:[25,1],"__init__":[25,1],target_fullname:[25,4]},"sqlalchemy.pool":{NullPool:[35,0],clear_managers:[35,2],manage:[35,2],StaticPool:[35,0],SingletonThreadPool:[35,0],QueuePool:[35,0],AssertionPool:[35,0],Pool:[35,0]},"sqlalchemy.databases.mysql.MSBinary":{"__init__":[11,1]},"sqlalchemy.sql.expression.FromClause":{count:[14,1],is_derived_from:[14,1],join:[14,1],description:[14,4],c:[14,4],correspond_on_equivalents:[14,1],alias:[14,1],select:[14,1],foreign_keys:[14,4],corresponding_column:[14,1],outerjoin:[14,1],replace_selectable:[14,1],columns:[14,4],primary_key:[14,4]},"sqlalchemy.ext.associationproxy":{association_proxy:[28,2],AssociationProxy:[28,0]},"sqlalchemy.schema.PrimaryKeyConstraint":{append_column:[25,1],remove:[25,1],replace:[25,1],add:[25,1],copy:[25,1],"__init__":[25,1]},"sqlalchemy.orm.mapper.Mapper":{get_property:[4,1],compile:[4,1],common_parent:[4,1],polymorphic_iterator:[4,1],identity_key_from_primary_key:[4,1],primary_key_from_instance:[4,1],add_properties:[4,1],cascade_iterator:[4,1],iterate_properties:[4,4],identity_key_from_instance:[4,1],primary_mapper:[4,1],identity_key_from_row:[4,1],isa:[4,1],add_property:[4,1],"__init__":[4,1]},"sqlalchemy.databases.mysql.MSMediumBlob":{"__init__":[11,1]},"sqlalchemy.sql.expression.Alias":{"__init__":[14,1]},"sqlalchemy.orm.interfaces":{AttributeExtension:[41,0],PropComparator:[41,0],SessionExtension:[41,0],InstrumentationManager:[41,0],MapperExtension:[41,0]},"sqlalchemy.types.TypeEngine":{result_processor:[32,1],get_col_spec:[32,1],is_mutable:[32,1],compare_values:[32,1],dialect_impl:[32,1],get_search_list:[32,1],bind_processor:[32,1],get_dbapi_type:[32,1],adapt:[32,1],copy_value:[32,1],adapt_operator:[32,1],"__init__":[32,1]},"sqlalchemy.databases.mysql.MSMediumInteger":{"__init__":[11,1]},"sqlalchemy.schema.Constraint":{keys:[25,1],copy:[25,1],"__init__":[25,1],contains_column:[25,1]},"sqlalchemy.sql.expression.Delete":{where:[14,1]},"sqlalchemy.sql.functions.ReturnTypeFromArgs":{"__init__":[14,1]},"sqlalchemy.databases.mysql.MSChar":{"__init__":[11,1]},"sqlalchemy.schema.Index":{append_column:[25,1],create:[25,1],drop:[25,1],"__init__":[25,1]},"sqlalchemy.engine.base.ExecutionContext":{lastrow_has_defaults:[36,1],create_cursor:[36,1],last_inserted_ids:[36,1],should_autocommit_text:[36,1],last_inserted_params:[36,1],pre_exec:[36,1],post_exec:[36,1],result:[36,1],last_updated_params:[36,1],handle_dbapi_exception:[36,1]},"sqlalchemy.orm.collections":{mapped_collection:[29,2],collection_adapter:[29,2],collection:[29,0],attribute_mapped_collection:[29,2],column_mapped_collection:[29,2]},"sqlalchemy.schema":{ColumnDefault:[25,0],Index:[25,0],Table:[25,0],PassiveDefault:[25,4],ForeignKey:[25,0],Constraint:[25,0],Column:[25,0],CheckConstraint:[25,0],Sequence:[25,0],DefaultClause:[25,0],DefaultGenerator:[25,0],ThreadLocalMetaData:[25,0],ForeignKeyConstraint:[25,0],SchemaItem:[25,0],DDL:[25,0],UniqueConstraint:[25,0],PrimaryKeyConstraint:[25,0],MetaData:[25,0],FetchedValue:[25,0],SchemaVisitor:[25,0]},"sqlalchemy.engine.url":{URL:[36,0]},"sqlalchemy.databases.mysql.MSTimeStamp":{"__init__":[11,1]},"sqlalchemy.databases.mysql.MSYear":{"__init__":[11,1]},"sqlalchemy.orm.sqlalchemy.orm.attributes":{instance_state:[4,2],manager_of_class:[4,2]},"sqlalchemy.databases.mysql.MSTinyBlob":{"__init__":[11,1]},"sqlalchemy.schema.Table":{append_column:[25,1],compare:[25,1],exists:[25,1],scalar:[25,1],tometadata:[25,1],select:[25,1],append_constraint:[25,1],is_derived_from:[25,1],primary_key:[25,4],create:[25,1],get_children:[25,1],params:[25,1],"__init__":[25,1],outerjoin:[25,1],replace_selectable:[25,1],columns:[25,4],info:[25,4],correspond_on_equivalents:[25,1],c:[25,4],update:[25,1],key:[25,4],self_group:[25,1],count:[25,1],insert:[25,1],execute:[25,1],join:[25,1],unique_params:[25,1],bind:[25,4],drop:[25,1],compile:[25,1],alias:[25,1],foreign_keys:[25,4],corresponding_column:[25,1],append_ddl_listener:[25,1],"delete":[25,1]},"sqlalchemy.engine.default.DefaultDialect":{do_rollback:[36,1],defaultrunner:[36,4],do_begin:[36,1],statement_compiler:[36,4],create_xid:[36,1],preparer:[36,4],do_commit:[36,1],"__init__":[36,1],type_descriptor:[36,1]},"sqlalchemy.schema.FetchedValue":{"__init__":[25,1]},"sqlalchemy.sql.expression.Join":{alias:[14,1],"__init__":[14,1],select:[14,1]},"sqlalchemy.sql.expression.ColumnClause":{"__init__":[14,1]},"sqlalchemy.orm.interfaces.InstrumentationManager":{dispose:[41,1],state_getter:[41,1],install_descriptor:[41,1],uninstall_descriptor:[41,1],uninstall_member:[41,1],instrument_attribute:[41,1],post_configure_attribute:[41,1],initialize_instance_dict:[41,1],install_member:[41,1],install_state:[41,1],instrument_collection_class:[41,1],remove_state:[41,1],get_instance_dict:[41,1],manager_getter:[41,1],manage:[41,1],"__init__":[41,1],dict_getter:[41,1]},"sqlalchemy.databases.mysql.MSTinyInteger":{"__init__":[11,1]},"sqlalchemy.databases.mysql.MSReal":{"__init__":[11,1]},"sqlalchemy.orm":{contains_eager:[40,2],defer:[40,2],object_mapper:[4,2],aliased:[40,4],dynamic_loader:[4,2],validates:[4,2],relation:[4,2],clear_mappers:[4,2],sessionmaker:[7,2],outerjoin:[40,2],eagerload:[40,2],column_property:[4,2],composite:[4,2],class_mapper:[4,2],compile_mappers:[4,2],join:[40,2],scoped_session:[7,2],create_session:[7,2],mapper:[4,2],synonym:[4,2],extension:[40,2],comparable_property:[4,2],undefer:[40,2],deferred:[4,2],reconstructor:[4,2],lazyload:[40,2],eagerload_all:[40,2],backref:[4,2]},"sqlalchemy.databases.mysql.MSDateTime":{"__init__":[11,1]},"sqlalchemy.sql.expression.Update":{values:[14,1],where:[14,1]},"sqlalchemy.databases.mysql.MSNumeric":{"__init__":[11,1]},"sqlalchemy.engine.base.Transaction":{close:[36,1],rollback:[36,1],"__init__":[36,1],commit:[36,1]},"sqlalchemy.orm.scoping":{ScopedSession:[7,0]},"sqlalchemy.engine.default":{DefaultDialect:[36,0],DefaultExecutionContext:[36,0]},"sqlalchemy.engine.base.ResultProxy":{fetchall:[36,1],last_updated_params:[36,1],last_inserted_ids:[36,1],fetchmany:[36,1],supports_sane_rowcount:[36,1],last_inserted_params:[36,1],lastrow_has_defaults:[36,1],scalar:[36,1],supports_sane_multi_rowcount:[36,1],postfetch_cols:[36,1],close:[36,1],fetchone:[36,1],"__init__":[36,1]},"sqlalchemy.databases.mysql.MSTime":{"__init__":[11,1]},"sqlalchemy.engine.base.SchemaIterator":{execute:[36,1],append:[36,1],"__init__":[36,1]},"sqlalchemy.databases.mysql.MSString":{"__init__":[11,1]},"sqlalchemy.orm.interfaces.PropComparator":{has_op:[41,6],any_op:[41,6],of_type:[41,1],of_type_op:[41,6],has:[41,1],adapted:[41,1],any:[41,1],"__init__":[41,1]},"sqlalchemy.sql.functions.count":{"__init__":[14,1]},"sqlalchemy.databases.mysql.MSSmallInteger":{"__init__":[11,1]},"sqlalchemy.orm.util.Validator":{set:[2,1],"__init__":[2,1],append:[2,1]},"sqlalchemy.databases.mysql.MSFloat":{"__init__":[11,1]},"sqlalchemy.ext.associationproxy.AssociationProxy":{target_class:[28,4],"__init__":[28,1]},"sqlalchemy.engine.base":{Engine:[36,0],Dialect:[36,0],Transaction:[36,0],RowProxy:[36,0],Connectable:[36,0],Connection:[36,0],connection_memoize:[36,2],ExecutionContext:[36,0],DefaultRunner:[36,0],ResultProxy:[36,0],SchemaIterator:[36,0]},"sqlalchemy.databases.mysql.MSVarBinary":{"__init__":[11,1]},"sqlalchemy.sql.expression.CompoundSelect":{"__init__":[14,1]},"sqlalchemy.engine.base.Engine":{contextual_connect:[36,1],table_names:[36,1],transaction:[36,1],name:[36,4],raw_connection:[36,1],text:[36,1],create:[36,1],drop:[36,1],echo:[36,4],connect:[36,1],reflecttable:[36,1],"__init__":[36,1]},"sqlalchemy.orm.interfaces.MapperExtension":{before_delete:[41,1],append_result:[41,1],create_instance:[41,1],translate_row:[41,1],after_delete:[41,1],init_failed:[41,1],after_insert:[41,1],init_instance:[41,1],before_update:[41,1],populate_instance:[41,1],after_update:[41,1],before_insert:[41,1],reconstruct_instance:[41,1],instrument_class:[41,1]},"sqlalchemy.sql.functions.AnsiFunction":{"__init__":[14,1]},"sqlalchemy.sql.expression.Select":{append_column:[14,1],intersect_all:[14,1],froms:[14,4],except_:[14,1],select_from:[14,1],"__init__":[14,1],union_all:[14,1],prefix_with:[14,1],inner_columns:[14,4],distinct:[14,1],append_from:[14,1],get_children:[14,1],with_only_columns:[14,1],intersect:[14,1],append_prefix:[14,1],self_group:[14,1],union:[14,1],correlate:[14,1],append_correlation:[14,1],column:[14,1],append_having:[14,1],except_all:[14,1],append_whereclause:[14,1],where:[14,1],having:[14,1]},"sqlalchemy.ext.orderinglist":{ordering_list:[26,2]},"sqlalchemy.schema.UniqueConstraint":{append_column:[25,1],copy:[25,1],"__init__":[25,1]},"sqlalchemy.interfaces.ConnectionProxy":{cursor_execute:[8,1],execute:[8,1]},"sqlalchemy.databases.mysql.MSNVarChar":{"__init__":[11,1]},"sqlalchemy.orm.interfaces.SessionExtension":{after_bulk_delete:[41,1],after_begin:[41,1],after_flush_postexec:[41,1],before_commit:[41,1],after_attach:[41,1],after_rollback:[41,1],after_flush:[41,1],after_bulk_update:[41,1],before_flush:[41,1],after_commit:[41,1]},"sqlalchemy.databases.mysql.MSLongText":{"__init__":[11,1]},"sqlalchemy.databases.mysql.MSBoolean":{"__init__":[11,1]},"sqlalchemy.schema.Column":{compare:[25,1],shares_lineage:[25,1],scalar:[25,1],append_foreign_key:[25,1],references:[25,1],reverse_operate:[25,1],"__init__":[25,1],in_:[25,1],distinct:[25,1],contains:[25,1],ilike:[25,1],get_children:[25,1],label:[25,1],params:[25,1],collate:[25,1],between:[25,1],match:[25,1],startswith:[25,1],asc:[25,1],self_group:[25,1],copy:[25,1],concat:[25,1],desc:[25,1],info:[25,4],execute:[25,1],like:[25,1],unique_params:[25,1],bind:[25,4],endswith:[25,1],compile:[25,1],operate:[25,1],op:[25,1]},sqlalchemy:{create_engine:[36,2],engine_from_config:[36,2]},"sqlalchemy.sql.functions.concat":{"__init__":[14,1]},"sqlalchemy.pool.QueuePool":{"__init__":[35,1]},"sqlalchemy.databases.mysql.MSLongBlob":{"__init__":[11,1]},"sqlalchemy.schema.ColumnDefault":{"__init__":[25,1]},"sqlalchemy.types":{Binary:[32,0],FLOAT:[32,0],TIME:[32,0],CLOB:[32,0],UnicodeText:[32,0],TEXT:[32,4],NullType:[32,0],CHAR:[32,0],DATE:[32,0],TypeEngine:[32,0],INTEGER:[32,4],AbstractType:[32,0],SMALLINT:[32,0],VARCHAR:[32,0],String:[32,0],NUMERIC:[32,0],Concatenable:[32,0],TypeDecorator:[32,0],BOOLEAN:[32,0],Date:[32,0],Integer:[32,0],BLOB:[32,0],DECIMAL:[32,0],Interval:[32,0],DATETIME:[32,0],PickleType:[32,0],Time:[32,0],DateTime:[32,0],NCHAR:[32,0],SmallInteger:[32,0],INT:[32,0],TIMESTAMP:[32,0],Float:[32,0],Numeric:[32,0],Boolean:[32,0],MutableType:[32,0],Unicode:[32,0],Text:[32,0]},"sqlalchemy.databases.mysql.MSDate":{"__init__":[11,1]},"sqlalchemy.orm.mapper":{Mapper:[4,0]},"sqlalchemy.sql.expression":{ColumnClause:[14,0],exists:[14,2],Insert:[14,0],TableClause:[14,0],text:[14,2],intersect_all:[14,2],ColumnElement:[14,0],and_:[14,2],table:[14,2],ClauseElement:[14,0],except_:[14,2],"null":[14,2],extract:[14,2],ColumnCollection:[14,0],union_all:[14,2],except_all:[14,2],distinct:[14,2],Update:[14,0],label:[14,2],literal:[14,2],bindparam:[14,2],intersect:[14,2],between:[14,2],outerjoin:[14,2],Selectable:[14,0],Delete:[14,0],not_:[14,2],collate:[14,2],"case":[14,2],select:[14,2],Join:[14,0],ColumnOperators:[14,0],or_:[14,2],update:[14,2],asc:[14,2],Alias:[14,0],"_CompareMixin":[14,0],alias:[14,2],func:[14,4],union:[14,2],desc:[14,2],literal_column:[14,2],insert:[14,2],join:[14,2],FromClause:[14,0],column:[14,2],CompoundSelect:[14,0],cast:[14,2],subquery:[14,2],outparam:[14,2],Select:[14,0],"delete":[14,2]},"sqlalchemy.pool.AssertionPool":{"__init__":[35,1]},"sqlalchemy.pool.Pool":{add_listener:[35,1],status:[35,1],return_conn:[35,1],log:[35,1],do_return_conn:[35,1],dispose:[35,1],recreate:[35,1],do_get:[35,1],create_connection:[35,1],unique_connection:[35,1],connect:[35,1],get:[35,1],"__init__":[35,1]},"sqlalchemy.orm.scoping.ScopedSession":{mapper:[7,1],query_property:[7,1],configure:[7,1],"__init__":[7,1]},"sqlalchemy.sql.expression.ClauseElement":{compare:[14,1],unique_params:[14,1],bind:[14,4],execute:[14,1],get_children:[14,1],compile:[14,1],scalar:[14,1],params:[14,1]},"sqlalchemy.engine.base.Connectable":{contextual_connect:[36,1],create:[36,1],drop:[36,1],execute:[36,1]},"sqlalchemy.databases.mysql.MSNChar":{"__init__":[11,1]},"sqlalchemy.databases.mysql.MSInteger":{"__init__":[11,1]},"sqlalchemy.schema.ForeignKeyConstraint":{copy:[25,1],append_element:[25,1],"__init__":[25,1]},"sqlalchemy.interfaces.PoolListener":{checkin:[8,1],checkout:[8,1],connect:[8,1]},"sqlalchemy.schema.DefaultGenerator":{execute:[25,1],"__init__":[25,1]},"sqlalchemy.orm.session.Session":{add_all:[7,1],flush:[7,1],expunge_all:[7,1],scalar:[7,1],close:[7,1],query:[7,1],"__init__":[7,1],close_all:[7,5],prepare:[7,1],add:[7,1],"new":[7,4],save:[7,1],begin:[7,1],rollback:[7,1],deleted:[7,4],update:[7,1],is_active:[7,4],object_session:[7,5],is_modified:[7,1],expire:[7,1],bind_table:[7,1],save_or_update:[7,1],execute:[7,1],bind_mapper:[7,1],prune:[7,1],expunge:[7,1],clear:[7,1],expire_all:[7,1],refresh:[7,1],merge:[7,1],connection:[7,1],dirty:[7,4],begin_nested:[7,1],commit:[7,1],get_bind:[7,1],"delete":[7,1]},"sqlalchemy.sql.functions.random":{"__init__":[14,1]},"sqlalchemy.databases.mysql.MSBlob":{"__init__":[11,1]},"sqlalchemy.ext.declarative":{synonym_for:[39,2],instrument_declarative:[39,2],comparable_using:[39,2],declarative_base:[39,2]},"sqlalchemy.types.AbstractType":{result_processor:[32,1],is_mutable:[32,1],compare_values:[32,1],bind_processor:[32,1],get_dbapi_type:[32,1],copy_value:[32,1],adapt_operator:[32,1],"__init__":[32,1]},"sqlalchemy.engine.base.RowProxy":{keys:[36,1],items:[36,1],has_key:[36,1],values:[36,1],close:[36,1],"__init__":[36,1]},"sqlalchemy.schema.MetaData":{is_bound:[25,1],table_iterator:[25,1],bind:[25,4],clear:[25,1],remove:[25,1],reflect:[25,1],create_all:[25,1],sorted_tables:[25,4],connect:[25,1],append_ddl_listener:[25,1],"__init__":[25,1],drop_all:[25,1]},"sqlalchemy.pool.StaticPool":{"__init__":[35,1]},"sqlalchemy.databases.mysql.MSTinyText":{"__init__":[11,1]},"sqlalchemy.schema.SchemaItem":{info:[25,4],bind:[25,4],get_children:[25,1]},"sqlalchemy.engine.base.Connection":{contextual_connect:[36,1],invalidate:[36,1],execute:[36,1],in_transaction:[36,1],dialect:[36,4],should_close_with_result:[36,4],create:[36,1],drop:[36,1],scalar:[36,1],invalidated:[36,4],begin:[36,1],connection:[36,4],info:[36,4],connect:[36,1],closed:[36,4],begin_nested:[36,1],close:[36,1],reflecttable:[36,1],detach:[36,1],"__init__":[36,1],begin_twophase:[36,1]},"sqlalchemy.engine.base.Dialect":{do_recover_twophase:[36,1],get_default_schema_name:[36,1],do_prepare_twophase:[36,1],create_xid:[36,1],do_commit:[36,1],type_descriptor:[36,1],do_savepoint:[36,1],has_table:[36,1],do_rollback_twophase:[36,1],do_rollback_to_savepoint:[36,1],do_execute:[36,1],do_rollback:[36,1],do_executemany:[36,1],do_begin:[36,1],do_release_savepoint:[36,1],server_version_info:[36,1],create_connect_args:[36,1],has_sequence:[36,1],do_commit_twophase:[36,1],do_begin_twophase:[36,1],is_disconnect:[36,1],reflecttable:[36,1]},"sqlalchemy.sql.expression._CompareMixin":{startswith:[14,1],in_:[14,1],distinct:[14,1],contains:[14,1],label:[14,1],asc:[14,1],endswith:[14,1],collate:[14,1],op:[14,1],operate:[14,1],reverse_operate:[14,1],between:[14,1],match:[14,1],desc:[14,1]},"sqlalchemy.databases.mysql.MSText":{"__init__":[11,1]},"sqlalchemy.schema.ThreadLocalMetaData":{is_bound:[25,1],dispose:[25,1],connect:[25,1],"__init__":[25,1],bind:[25,4]},"sqlalchemy.databases.mysql":{MSLongBlob:[11,0],MSBinary:[11,0],MSChar:[11,0],MSTinyInteger:[11,0],MSBlob:[11,0],MSString:[11,0],MSTime:[11,0],MSLongText:[11,0],MSEnum:[11,0],MSBit:[11,0],MSMediumInteger:[11,0],MSTimeStamp:[11,0],MSMediumText:[11,0],MSDateTime:[11,0],MSNChar:[11,0],MSInteger:[11,0],MSNVarChar:[11,0],MSMediumBlob:[11,0],MSDate:[11,0],MSSmallInteger:[11,0],MSTinyText:[11,0],MSBoolean:[11,0],MSReal:[11,0],MSDecimal:[11,0],MSNumeric:[11,0],MSFloat:[11,0],MSText:[11,0],MSBigInteger:[11,0],MSTinyBlob:[11,0],MSSet:[11,0],MSVarBinary:[11,0],MSDouble:[11,0],MSYear:[11,0]},"sqlalchemy.databases.mysql.MSSet":{"__init__":[11,1]},"sqlalchemy.databases.mysql.MSMediumText":{"__init__":[11,1]},"sqlalchemy.types.Concatenable":{adapt_operator:[32,1],"__init__":[32,1]},"sqlalchemy.types.MutableType":{is_mutable:[32,1],compare_values:[32,1],"__init__":[32,1],copy_value:[32,1]},"sqlalchemy.databases.mysql.MSDouble":{"__init__":[11,1]},"sqlalchemy.schema.Sequence":{create:[25,1],drop:[25,1],"__init__":[25,1]},"sqlalchemy.orm.query.Query":{all:[40,1],intersect_all:[40,1],one:[40,1],instances:[40,1],scalar:[40,1],from_statement:[40,1],except_:[40,1],select_from:[40,1],iterate_instances:[40,1],add_entity:[40,1],union_all:[40,1],filter:[40,1],enable_eagerloads:[40,1],slice:[40,1],order_by:[40,1],except_all:[40,1],union:[40,1],yield_per:[40,1],whereclause:[40,4],group_by:[40,1],params:[40,1],"__init__":[40,1],statement:[40,4],add_column:[40,1],limit:[40,1],options:[40,1],with_polymorphic:[40,1],populate_existing:[40,1],intersect:[40,1],get:[40,1],update:[40,1],with_lockmode:[40,1],outerjoin:[40,1],with_labels:[40,1],offset:[40,1],filter_by:[40,1],count:[40,1],reset_joinpoint:[40,1],join:[40,1],with_parent:[40,1],correlate:[40,1],from_self:[40,1],value:[40,1],query_from_parent:[40,5],autoflush:[40,1],distinct:[40,1],subquery:[40,1],values:[40,1],first:[40,1],having:[40,1],"delete":[40,1]},"sqlalchemy.ext.serializer":{dumps:[21,2],Deserializer:[21,2],loads:[21,2],Serializer:[21,2]},"sqlalchemy.databases.mysql.MSDecimal":{"__init__":[11,1]},"sqlalchemy.engine.base.DefaultRunner":{execute_string:[36,1],"__init__":[36,1]},"sqlalchemy.orm.attributes":{set_committed_value:[4,2],is_instrumented:[4,2],get_attribute:[4,2],init_collection:[4,2],set_attribute:[4,2],get_history:[4,2],del_attribute:[4,2]},"sqlalchemy.databases.mysql.MSBigInteger":{"__init__":[11,1]},"sqlalchemy.databases.mysql.MSEnum":{"__init__":[11,1]},"sqlalchemy.sql.expression.Insert":{prefix_with:[14,1],values:[14,1]},"sqlalchemy.sql.functions.GenericFunction":{"__init__":[14,1]},"sqlalchemy.engine.default.DefaultExecutionContext":{set_input_sizes:[36,1],"__init__":[36,1]},"sqlalchemy.sql.expression.ColumnCollection":{add:[14,1],"__init__":[14,1],replace:[14,1]}},filenames:["mappers","reference/dialects/index","reference/orm/utilities","reference/ext/compiler","reference/orm/mapping","reference/dialects/access","intro","reference/orm/sessions","reference/sqlalchemy/interfaces","index","copyright","reference/dialects/mysql","ormtutorial","reference/index","reference/sqlalchemy/expressions","dbengine","reference/dialects/postgres","reference/ext/sqlsoup","metadata","reference/dialects/firebird","reference/dialects/maxdb","reference/ext/serializer","reference/sqlalchemy/index","reference/dialects/sqlite","reference/dialects/sybase","reference/sqlalchemy/schema","reference/ext/orderinglist","reference/dialects/informix","reference/ext/associationproxy","reference/orm/collections","reference/ext/index","reference/orm/index","reference/sqlalchemy/types","reference/dialects/oracle","session","reference/sqlalchemy/pooling","reference/sqlalchemy/connections","reference/dialects/mssql","sqlexpression","reference/ext/declarative","reference/orm/query","reference/orm/interfaces"]})