from django.db import models

# Create your models here.
class Passenger (models.Model):
    MALE = 'M'
    FEMALE = 'F'
    SEX_CHOICES = (
        (MALE, 'male'),
        (FEMALE, 'female')
    )

    CHERBOURG = 'C'
    QUEENSTOWN = 'Q'
    SOUTHAMPTON = 'S'
    PORT_CHOICES = (
        (CHERBOURG, 'Cherbourg'),
        (QUEENSTOWN, 'Queenstown'),
        (SOUTHAMPTON, 'Southampton'),
    )


    name = models.CharField(max_length=100)
    sex = models.CharField(max_length=20, choices=SEX_CHOICES)
    survived = models.BooleanField()
    ticket_class = models.PositiveSmallIntegerField()
    embarked = models.CharField(max_length=1, choices=PORT_CHOICES)
    
    KECAMATAN_KELURAHAN = (
    	(   "Karang Pilang", (
    		("karang_pilang", "Karang Pilang"),
    	   	("kabraon", "Kebraon"),
    	   	("kedurus", "Kedurus"),
    	   	("warugunung", "Warugunung"),
    	   	    )
    	    ),
    	    
    	(   "Jambangan", (
    		("jambangan", "Jambangan"),
    		("karah", "Karah"),
    		("kebonsari", "Kebonsari"),
    		("pagesangan", "Pagesangan"),
    		    )
    	    ),
    	
    	(   "Gayungan", (
    	    ("dukuh_manunggal" ,"Dukuh Menanggal"),
    	    ("gayungan", "Gayungan"),
    	    ("ketintang", "Ketintang"),
    	    ("menanggal", "Menanggal"),
    	        )
    	    ),
    	    
    	(   "Wonocolo", (
    	    ("bendul_merisi" ,"Bendul Merisi"),
    	    ("jemur_wonosari", "Jemur Wonosari"),
    	    ("margorejo", "Margorejo"),
    	    ("sidosermo", "Sidosermo"),
    	    ("siwalankerto", "Siwalankerto"),
    	        )
    	    ),
    	    
    	(   "<NAME>", (
    	    ("kendangsari" ,"Kendangsari"),
    	    ("kutisari", "Kutisari"),
    	    ("panjang_jiwo", "Panjang Jiwo"),
    	    ("prapen", "Prapen"),
    	    ("tenggilis_mejoyo", "Tenggilis Mejoyo"),
    	        )
    	    ),
    	    
    	    
    	(   "Gunung Anyar", (
    	    ("gunung_anyar" ,"Gunung Anyar"),
    	    ("gunung_anyar_tambak", "Gunung Anyar Tambak"),
    	    ("rungkut_menaggal", "Rungkut Menaggal"),
    	    ("rungkut_tengah", "Rungkut Tengah"),
    	        )
    	    ),
    	    
    	    
    	(   "Rungkut", (
    	    ("kali_rungkut" ,"Kali Rungkut"),
    	    ("kedung_baruk", "Kedung Baruk"),
    	    ("medokan_ayu", "Medokan Ayu"),
    	    ("penjaringan_sari", "Penjaringan Sari"),
    	    ("rungkut_kidul", "Rungkut Kidul"),
    	    ("wonorejo", "Woonorejo"),
    	        )
    	    ),
        
        (   "Sukolilo", (
    	    ("gebang_putih" ,"Gebang Putih"),
    	    ("keputih", "Keputih"),
    	    ("klampis_ngasem", "Klampis Ngasem"),
    	    ("medokan_semampir", "Medokan Semampir"),
    	    ("menur_pumpungan", "Menur Pumpungan"),
    	    ("ngindeng_jangkungan", "Nginden Jangkungan"),
    	    ("semolowaru", "Semolowaru"),
    	        )
    	    ),
        
        (   "Mulyorejo", (
    	    ("dukuh_sutorejo" ,"Dukuh Sutorejo"),
    	    ("kalijudan", "Kalijudan"),
    	    ("kalisari", "Kalisari"),
    	    ("kejawen_putih", "Kejawen Putih"),
    	    ("manyar_sabrangan", "Manyar Sabrangan"),
    	    ("mulyorejo", "Mulyorejo"),
    	        )
    	    ),
        
        (   "Gubeng", (
    	    ("airlangga" ,"Airlangga"),
    	    ("baratajaya", "Baratajaya"),
    	    ("gubeng", "Gubeng"),
    	    ("kertajaya", "Kertajaya"),
    	    ("mojo", "Mojo"),
    	    ("pucang_sewu", "Pucang Sewu"),
    	        )
    	    ),
    	    
        (   "Wonokromo", (
    	    ("darmo" ,"Darmo"),
    	    ("jagir", "Jagir"),
    	    ("ngagel", "Ngagel"),
    	    ("ngagelrejo", "Ngagelrejo"),
    	    ("sawunggaling", "Sawunggaling"),
    	    ("wonokrommo", "Wonokromo"),
    	        )
    	    ),
    	    
        (   "Dukuh Pakis", (
    	    ("dukuh_kupang" ,"Dukuh Kupang"),
    	    ("dukuh_pakis", "Dukuh Pakis"),
    	    ("gununngsari", "Gunungsari"),
    	    ("pradahkali_kendal", "Pradahkali Kendal"),
    	        )
    	    ),
    	    
        (   "Wiyung", (
    	    ("babatan" ,"Babatan"),
    	    ("balas_klumprik", "Balas Klumprik"),
    	    ("jajar_manunggal", "Jajar Manunggal"),
    	    ("wiyung", "wiyung"),
    	        )
    	    ),
    	    
        (   "Lakasantri", (
    	    ("bangkingan" ,"Bangkingan"),
    	    ("jeruk", "Jeruk"),
    	    ("lakasantri", "Lakasantri"),
    	    ("lidah_kulon", "Lid<NAME>"),
    	    ("lidah_wetan" ,"Lidah Wetan"),
    	    ("sumur_welut", "Sumur Welut"),
    	        )
    	    ),
    	    
        (   "Sambikerep", (
    	    ("bringin" ,"Bringin"),
    	    ("lontar", "Lontar"),
    	    ("made", "Made"),
    	    ("sambikerep", "Sambikerep"),
    	        )
    	    ),
    	    
        (   "Tandes", (
    	    ("balongsari" ,"Balongsari"),
    	    ("banjar_sugihan", "Banjar Sugihan"),
    	    ("karangpoh", "Karangpoh"),
    	    ("manukan_kulon", "Manukan Kulon"),
    	    ("manukan_wetan", "Manukan Wetan"),
    	    ("tandes", "Tandes"),
    	        )
    	    ),
    	    
        (   "<NAME>", (
    	    ("putat_gede" ,"Putat Gede"),
    	    ("simomulyo", "Simomulyo"),
    	    ("simomulyo_baru", "Simomulyo Baru"),
    	    ("sono_kwijenan", "Sono Kwijenan"),
    	    ("suko_manunggal", "Suko Manunggal"),
    	    ("tanjungsari", "Tanjungsari"),
    	        )
    	    ),
    	    
        (   "Sawahan", (
    	    ("banyu_urip" ,"Banyu Urip"),
    	    ("kupang_krajan", "Kupang Krajan"),
    	    ("pakis", "Pakis"),
    	    ("petemon", "Petemon"),
    	    ("putat_jaya", "Putat Jaya"),
    	    ("sawahan", "Sawahan"),
    	        )
    	    ),
    	    
        (   "Tegalsari", (
    	    ("dr_sutomo" ,"Dr. Sutomo"),
    	    ("kedungdoro", "Kedungdoro"),
    	    ("keputran", "Keputran"),
    	    ("tegalsari", "Tegalsari"),
    	    ("wonosari", "Wonosari"),
    	        )
    	    ),
    	    
        (   "Genteng", (
    	    ("embong_kaliasin" ,"Embong Kaliasin"),
    	    ("genteng", "Genteng"),
    	    ("kapasari", "Kapasari"),
    	    ("ketabang", "Ketabang"),
    	    ("peneleh", "Peneleh"),
    	        )
    	    ),
    	    
        (   "Tambaksari", (
    	    ("dukuh_setro" ,"Dukuh Setro"),
    	    ("gading", "Gading"),
    	    ("kapasmasya_baru", "Kapasmadya Baru"),
    	    ("pacar_keling", "Pacar Keling"),
    	    ("pacar_kembang" ,"Pacar Kembang"),
    	    ("ploso", "Ploso"),
    	    ("rangkah", "Rangkah"),
    	    ("tambasari", "Tambaksari"),
    	        )
    	    ),
    	    
        (   "Kenjeran", (
    	    ("bulak_banteng" ,"Bulak Banteng"),
    	    ("sidotopo_wetan", "Sidotopo Wetan"),
    	    ("tambak_wedi", "Tambak Wedi"),
    	    ("tanah_kali_kedinding", "Tanah Kali Kedinding"),
    	        )
    	    ),
    	    
        (   "Bulak", (
    	    ("bulak" ,"Bulak"),
    	    ("kedung_cowek", "Kedung Cowek"),
    	    ("kenjeran", "Kenjeran"),
    	    ("komplek_kenjeran", "Komplek Kenjeran"),
    	    ("sukolilo", "Sukolilo"),
    	        )
    	    ),
    	    
        (   "Simokerto", (
    	    ("kapasan" ,"Kapasan"),
    	    ("sidodadi", "Sidodadi"),
    	    ("simokerto", "Simokerto"),
    	    ("simowalang", "Simowalang"),
    	    ("tambakrejo", "Tambakrejo"),
    	        )
    	    ),
    	    
        (   "Semampir", (
    	    ("ampel" ,"Ampel"),
    	    ("pegirian", "Pegirian"),
    	    ("sidotopo", "Sidotopo"),
    	    ("ujung", "Ujung"),
    	    ("wonokusumo", "Wonokusumo"),
    	        )
    	    ),
    	    
        (   "<NAME>", (
    	    ("bongkaran" ,"Bongkaran"),
    	    ("krembangan_utara", "Kembangan Utara"),
    	    ("nyamplungan", "Nyamplungan"),
    	    ("perak_timur", "Perak Timur"),
    	    ("perak_utara", "Perak Utara"),
    	        )
    	    ),
    	    
        (   "Bubutan", (
    	    ("alon_alon_contong" ,"Alon Alon Contong"),
    	    ("bubutan", "Bubutan"),
    	    ("gundih", "Gundih"),
    	    ("jepara", "Jepara"),
    	    ("tembok_dukuh", "Tembok Dukuh"),
    	        )
    	    ),
    	    
        (   "Krembangan", (
    	    ("dupak" ,"Dupak"),
    	    ("kemayoran", "Kemayoran"),
    	    ("krembangan_selatan", "Krembangan Selatan"),
    	    ("morokrembangan", "Morokrembangan"),
    	    ("perak_barat", "Perak Barat"),
    	        )
    	    ),
    	    
        (   "Asemrowo", (
    	    ("asemrowo" ,"Asemrowo"),
    	    ("genting", "Genting"),
    	    ("greges", "Greges"),
    	    ("kalianak", "Kalianak"),
    	    ("tambak_langon", "Tambak Langon"),
    	        )
    	    ),
    	    
        (   "Benowo", (
    	    ("kandangan" ,"Kandangan"),
    	    ("klakahrejo" ,"Klakahrejo"),
    	    ("romokalisari", "Romokalisari"),
    	    ("sememi", "Sememi"),
    	    ("tambak_oso_wilangoon", "<NAME>"),
    	        )
    	    ),
    	    
        (   "Pakal", (
    	    ("babat_jerawat" ,"Babat Jerawat"),
    	    ("benowo" ,"benowo"),
    	    ("pakal", "Pakal"),
    	    ("sumberrejo", "Sumberrejo"),
    	    ("tambakdono", "Tambakdono"),
    	        )
    	    ),
    	          
    )
    

    kecamatan = models.CharField(max_length=30, choices=KECAMATAN_KELURAHAN, null=True)


from django.db import models

# Create your models here.
class Passenger (models.Model):
    MALE = 'M'
    FEMALE = 'F'
    SEX_CHOICES = (
        (MALE, 'male'),
        (FEMALE, 'female')
    )

    CHERBOURG = 'C'
    QUEENSTOWN = 'Q'
    SOUTHAMPTON = 'S'
    PORT_CHOICES = (
        (CHERBOURG, 'Cherbourg'),
        (QUEENSTOWN, 'Queenstown'),
        (SOUTHAMPTON, 'Southampton'),
    )


    name = models.CharField(max_length=100)
    sex = models.CharField(max_length=20, choices=SEX_CHOICES)
    survived = models.BooleanField()
    ticket_class = models.PositiveSmallIntegerField()
    embarked = models.CharField(max_length=1, choices=PORT_CHOICES)
    
    KECAMATAN_KELURAHAN = (
    	(   "Karang Pilang", (
    		("karang_pilang", "Karang Pilang"),
    	   	("kabraon", "Kebraon"),
    	   	("kedurus", "Kedurus"),
    	   	("warugunung", "Warugunung"),
    	   	    )
    	    ),
    	    
    	(   "Jambangan", (
    		("jambangan", "Jambangan"),
    		("karah", "Karah"),
    		("kebonsari", "Kebonsari"),
    		("pagesangan", "Pagesangan"),
    		    )
    	    ),
    	
    	(   "Gayungan", (
    	    ("dukuh_manunggal" ,"Dukuh Menanggal"),
    	    ("gayungan", "Gayungan"),
    	    ("ketintang", "Ketintang"),
    	    ("menanggal", "Menanggal"),
    	        )
    	    ),
    	    
    	(   "Wonocolo", (
    	    ("bendul_merisi" ,"Bendul Merisi"),
    	    ("jemur_wonosari", "Jemur Wonosari"),
    	    ("margorejo", "Margorejo"),
    	    ("sidosermo", "Sidosermo"),
    	    ("siwalankerto", "Siwalankerto"),
    	        )
    	    ),
    	    
    	(   "<NAME>", (
    	    ("kendangsari" ,"Kendangsari"),
    	    ("kutisari", "Kutisari"),
    	    ("panjang_jiwo", "Panjang Jiwo"),
    	    ("prapen", "Prapen"),
    	    ("tenggilis_mejoyo", "Tenggilis Mejoyo"),
    	        )
    	    ),
    	    
    	    
    	(   "Gunung Anyar", (
    	    ("gunung_anyar" ,"Gunung Anyar"),
    	    ("gunung_anyar_tambak", "Gunung Anyar Tambak"),
    	    ("rungkut_menaggal", "Rungkut Menaggal"),
    	    ("rungkut_tengah", "Rungkut Tengah"),
    	        )
    	    ),
    	    
    	    
    	(   "Rungkut", (
    	    ("kali_rungkut" ,"Kali Rungkut"),
    	    ("kedung_baruk", "Kedung Baruk"),
    	    ("medokan_ayu", "Medokan Ayu"),
    	    ("penjaringan_sari", "Penjaringan Sari"),
    	    ("rungkut_kidul", "Rungkut Kidul"),
    	    ("wonorejo", "Woonorejo"),
    	        )
    	    ),
        
        (   "Sukolilo", (
    	    ("gebang_putih" ,"Gebang Putih"),
    	    ("keputih", "Keputih"),
    	    ("klampis_ngasem", "Klampis Ngasem"),
    	    ("medokan_semampir", "Medokan Semampir"),
    	    ("menur_pumpungan", "Menur Pumpungan"),
    	    ("ngindeng_jangkungan", "Nginden Jangkungan"),
    	    ("semolowaru", "Semolowaru"),
    	        )
    	    ),
        
        (   "Mulyorejo", (
    	    ("dukuh_sutorejo" ,"Dukuh Sutorejo"),
    	    ("kalijudan", "Kalijudan"),
    	    ("kalisari", "Kalisari"),
    	    ("kejawen_putih", "Kejawen Putih"),
    	    ("manyar_sabrangan", "Manyar Sabrangan"),
    	    ("mulyorejo", "Mulyorejo"),
    	        )
    	    ),
        
        (   "Gubeng", (
    	    ("airlangga" ,"Airlangga"),
    	    ("baratajaya", "Baratajaya"),
    	    ("gubeng", "Gubeng"),
    	    ("kertajaya", "Kertajaya"),
    	    ("mojo", "Mojo"),
    	    ("pucang_sewu", "Pucang Sewu"),
    	        )
    	    ),
    	    
        (   "Wonokromo", (
    	    ("darmo" ,"Darmo"),
    	    ("jagir", "Jagir"),
    	    ("ngagel", "Ngagel"),
    	    ("ngagelrejo", "Ngagelrejo"),
    	    ("sawunggaling", "Sawunggaling"),
    	    ("wonokrommo", "Wonokromo"),
    	        )
    	    ),
    	    
        (   "Dukuh Pakis", (
    	    ("dukuh_kupang" ,"Dukuh Kupang"),
    	    ("dukuh_pakis", "Dukuh Pakis"),
    	    ("gununngsari", "Gunungsari"),
    	    ("pradahkali_kendal", "Pradahkali Kendal"),
    	        )
    	    ),
    	    
        (   "Wiyung", (
    	    ("babatan" ,"Babatan"),
    	    ("balas_klumprik", "Balas Klumprik"),
    	    ("jajar_manunggal", "Jajar Manunggal"),
    	    ("wiyung", "wiyung"),
    	        )
    	    ),
    	    
        (   "Lakasantri", (
    	    ("bangkingan" ,"Bangkingan"),
    	    ("jeruk", "Jeruk"),
    	    ("lakasantri", "Lakasantri"),
    	    ("lidah_kulon", "Lid<NAME>"),
    	    ("lidah_wetan" ,"Lidah Wetan"),
    	    ("sumur_welut", "Sumur Welut"),
    	        )
    	    ),
    	    
        (   "Sambikerep", (
    	    ("bringin" ,"Bringin"),
    	    ("lontar", "Lontar"),
    	    ("made", "Made"),
    	    ("sambikerep", "Sambikerep"),
    	        )
    	    ),
    	    
        (   "Tandes", (
    	    ("balongsari" ,"Balongsari"),
    	    ("banjar_sugihan", "Banjar Sugihan"),
    	    ("karangpoh", "Karangpoh"),
    	    ("manukan_kulon", "Manukan Kulon"),
    	    ("manukan_wetan", "Manukan Wetan"),
    	    ("tandes", "Tandes"),
    	        )
    	    ),
    	    
        (   "<NAME>", (
    	    ("putat_gede" ,"Putat Gede"),
    	    ("simomulyo", "Simomulyo"),
    	    ("simomulyo_baru", "Simomulyo Baru"),
    	    ("sono_kwijenan", "Sono Kwijenan"),
    	    ("suko_manunggal", "Suko Manunggal"),
    	    ("tanjungsari", "Tanjungsari"),
    	        )
    	    ),
    	    
        (   "Sawahan", (
    	    ("banyu_urip" ,"Banyu Urip"),
    	    ("kupang_krajan", "Kupang Krajan"),
    	    ("pakis", "Pakis"),
    	    ("petemon", "Petemon"),
    	    ("putat_jaya", "Putat Jaya"),
    	    ("sawahan", "Sawahan"),
    	        )
    	    ),
    	    
        (   "Tegalsari", (
    	    ("dr_sutomo" ,"Dr. Sutomo"),
    	    ("kedungdoro", "Kedungdoro"),
    	    ("keputran", "Keputran"),
    	    ("tegalsari", "Tegalsari"),
    	    ("wonosari", "Wonosari"),
    	        )
    	    ),
    	    
        (   "Genteng", (
    	    ("embong_kaliasin" ,"Embong Kaliasin"),
    	    ("genteng", "Genteng"),
    	    ("kapasari", "Kapasari"),
    	    ("ketabang", "Ketabang"),
    	    ("peneleh", "Peneleh"),
    	        )
    	    ),
    	    
        (   "Tambaksari", (
    	    ("dukuh_setro" ,"Dukuh Setro"),
    	    ("gading", "Gading"),
    	    ("kapasmasya_baru", "Kapasmadya Baru"),
    	    ("pacar_keling", "Pacar Keling"),
    	    ("pacar_kembang" ,"Pacar Kembang"),
    	    ("ploso", "Ploso"),
    	    ("rangkah", "Rangkah"),
    	    ("tambasari", "Tambaksari"),
    	        )
    	    ),
    	    
        (   "Kenjeran", (
    	    ("bulak_banteng" ,"Bulak Banteng"),
    	    ("sidotopo_wetan", "Sidotopo Wetan"),
    	    ("tambak_wedi", "Tambak Wedi"),
    	    ("tanah_kali_kedinding", "Tanah Kali Kedinding"),
    	        )
    	    ),
    	    
        (   "Bulak", (
    	    ("bulak" ,"Bulak"),
    	    ("kedung_cowek", "Kedung Cowek"),
    	    ("kenjeran", "Kenjeran"),
    	    ("komplek_kenjeran", "Komplek Kenjeran"),
    	    ("sukolilo", "Sukolilo"),
    	        )
    	    ),
    	    
        (   "Simokerto", (
    	    ("kapasan" ,"Kapasan"),
    	    ("sidodadi", "Sidodadi"),
    	    ("simokerto", "Simokerto"),
    	    ("simowalang", "Simowalang"),
    	    ("tambakrejo", "Tambakrejo"),
    	        )
    	    ),
    	    
        (   "Semampir", (
    	    ("ampel" ,"Ampel"),
    	    ("pegirian", "Pegirian"),
    	    ("sidotopo", "Sidotopo"),
    	    ("ujung", "Ujung"),
    	    ("wonokusumo", "Wonokusumo"),
    	        )
    	    ),
    	    
        (   "<NAME>", (
    	    ("bongkaran" ,"Bongkaran"),
    	    ("krembangan_utara", "Kembangan Utara"),
    	    ("nyamplungan", "Nyamplungan"),
    	    ("perak_timur", "Perak Timur"),
    	    ("perak_utara", "Perak Utara"),
    	        )
    	    ),
    	    
        (   "Bubutan", (
    	    ("alon_alon_contong" ,"Alon Alon Contong"),
    	    ("bubutan", "Bubutan"),
    	    ("gundih", "Gundih"),
    	    ("jepara", "Jepara"),
    	    ("tembok_dukuh", "Tembok Dukuh"),
    	        )
    	    ),
    	    
        (   "Krembangan", (
    	    ("dupak" ,"Dupak"),
    	    ("kemayoran", "Kemayoran"),
    	    ("krembangan_selatan", "Krembangan Selatan"),
    	    ("morokrembangan", "Morokrembangan"),
    	    ("perak_barat", "Perak Barat"),
    	        )
    	    ),
    	    
        (   "Asemrowo", (
    	    ("asemrowo" ,"Asemrowo"),
    	    ("genting", "Genting"),
    	    ("greges", "Greges"),
    	    ("kalianak", "Kalianak"),
    	    ("tambak_langon", "Tambak Langon"),
    	        )
    	    ),
    	    
        (   "Benowo", (
    	    ("kandangan" ,"Kandangan"),
    	    ("klakahrejo" ,"Klakahrejo"),
    	    ("romokalisari", "Romokalisari"),
    	    ("sememi", "Sememi"),
    	    ("tambak_oso_wilangoon", "<NAME>"),
    	        )
    	    ),
    	    
        (   "Pakal", (
    	    ("babat_jerawat" ,"Babat Jerawat"),
    	    ("benowo" ,"benowo"),
    	    ("pakal", "Pakal"),
    	    ("sumberrejo", "Sumberrejo"),
    	    ("tambakdono", "Tambakdono"),
    	        )
    	    ),
    	          
    )
    

    kecamatan = models.CharField(max_length=30, choices=KECAMATAN_KELURAHAN, null=True)


# Create your models here.