db.define_table('state',
Field('iso','string'),
#Field('country_iso',db.country),
Field('code','string'),
Field('name','string'),
Field('level','string')
)
I correct db. like above
2012년 6월 30일 토요일 오후 1시 6분 43초 UTC+9, song 님의 말:
>
> Nowdays I study the web2py.
> I met the problems for me only.
> By the appadmin.py, the database was constructed.
> Then at the 'state' , there are problemes in the CSV import.
>
> db files
>
> #
> db.define_table('country',
> Field('name', unique=True),
> Field('iso'),
> Field('numcode')
> )
>
> db.define_table('state',
> Field('country_iso',db.country),
> Field('subcountry_code','string'),
> Field('name','string'),
> Field('subcountry_level','string')
> )
>
> db.country.name.requires = IS_NOT_IN_DB(db,db.country.name)
> db.country.name.requires = IS_NOT_EMPTY()
>
> db.state.name.requires = IS_NOT_EMPTY()
> db.state.country_iso.requires = IS_IN_DB(db, db.country.iso,'%(iso)s')
>
> and csv files
>
> name,iso,numcode
> Afghanistan,AF,4
> Albania,AL,8
> Algeria,DZ,12
> American Samoa,AS,16
> Andorra,AD,20
> Angola,AO,24
> Anguilla,AI,660
> Antarctica,AQ,10
> Antigua and Barbuda,AG,28
> Argentina,AR,32
> Armenia,AM,51
> Aruba,AW,533
> Australia,AU,36
> Austria,AT,40
> Azerbaijan,AZ,31
> Bahamas,BS,44
> Bahrain,BH,48
> Bangladesh,BD,50
> Barbados,BB,52
> Belarus,BY,112
> Belgium,BE,56
> Belize,BZ,84
> Benin,BJ,204
> Bermuda,BM,60
> Bhutan,BT,64
>
>
> country_iso,subcountry_code,name,subcountry_level
> AD,AN,Andorra la Vella,NULL
> AD,CA,Canillo,NULL
> AD,EE,Escaldes-Engordany,NULL
> AD,EN,Encamp,NULL
> AD,JL,Sant Julià de Lòria,NULL
> AD,MA,La Massana,NULL
> AD,OR,Ordino,NULL
> AE,AJ,Ajman,NULL
> AE,AZ,Abu Z¸aby [Abu Dhabi],NULL
> AE,DU,Dubayy [Dubai],NULL
> AE,FU,Al Fujayrah,NULL
> AE,RK,Ras al Khaymah,NULL
> AE,SH,Ash Shariqah [Sharjah],NULL
> AE,UQ,Umm al Qaywayn,NULL
> AF,BAL,Balkh,NULL
> AF,BAM,Bamian,NULL
> AF,BDG,Badghis,NULL
> AF,BDS,Badakhshan,NULL
> AF,BGL,Baghlan,NULL
> AF,FRA,Farah,NULL
>
> Which parts are modified for corrected input?
>
>
