import_unknown_regions.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "21"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(DC_region.objects.all())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "pottey_vocab = DC_finds_pottery_decoration.objects.all()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "189"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(pottey_vocab)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "for x in pottey_vocab:\n",
    "    x.region.remove(DC_region.objects.get(id=20))\n",
    "    x.region.remove(DC_region.objects.get(id=21))\n",
    "    x.region.remove(DC_region.objects.get(id=19))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Turkey', 'Greece', 'Turkey', 'Turkey', 'Turkey', 'Turkey']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece', 'Greece', 'Greece', 'Greece', 'Greece', 'Greece']\n",
      "\n",
      "['Greece']\n",
      "\n",
      "['Greece']\n",
      "\n"
     ]
    }
   ],
   "source": [
    "for x in pottey_vocab:\n",
    "    regions = x.region.all()\n",
    "    country_names = []\n",
    "    for y in regions:\n",
    "        country_names.append(y.country.name)\n",
    "    print(country_names)\n",
    "    if \"Turkey\" in country_names:\n",
    "        x.region.add(DC_region.objects.get(id=20))\n",
    "        x.region.add(DC_region.objects.get(id=21))\n",
    "    elif \"Greece\" in country_names:\n",
    "        x.region.add(DC_region.objects.get(id=19))\n",
    "        x.region.add(DC_region.objects.get(id=21))\n",
    "    x.save()\n",
    "        \n",
    "    \n",
    "    print()"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Django Shell-Plus",
   "language": "python",
   "name": "django_extensions"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.4.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}