{"id":446,"date":"2015-03-03T01:16:14","date_gmt":"2015-03-02T16:16:14","guid":{"rendered":"http:\/\/www.typea.info\/blog\/index.php\/2015\/03\/03\/djangojson_sql\/"},"modified":"2015-03-03T01:16:14","modified_gmt":"2015-03-02T16:16:14","slug":"djangojson_sql","status":"publish","type":"post","link":"https:\/\/www.typea.info\/blog\/index.php\/2015\/03\/03\/djangojson_sql\/","title":{"rendered":"Django\u3067JSON\u3092\u4f7f\u3046\u305f\u3081\u306e\u4e00\u8003\u5bdf SQL\u306e\u6700\u9069\u5316\u306a\u3069"},"content":{"rendered":"

Django\u3092\u5229\u7528\u3057\u3066\u3001Web\u30b5\u30fc\u30d3\u30b9\u306e\u30d0\u30c3\u30af\u30a8\u30f3\u30c9\u3092\u4f5c\u6210\u3057\u305f\u3044\u3002\u30d5\u30ed\u30f3\u30c8\u30a8\u30f3\u30c9\u3068\u306e\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u306f\u3001JSON\u3092\u5229\u7528\u3057\u305f\u3044\u3002<\/p>\n

\u305d\u306e\u5834\u5408\u3069\u306e\u3088\u3046\u306a\u5b9f\u88c5\u3068\u3057\u305f\u3089\u3088\u3044\u306e\u304b\u3001\u30c7\u30fc\u30bf\u30a2\u30af\u30bb\u30b9\u306e\u52b9\u7387\u5316\u3082\u542b\u3081\u3066\u8003\u5bdf\u3057\u3066\u307f\u308b\u3002<\/p>\n

<\/a>\"\" <\/p>\n

1.\u30e2\u30c7\u30eb\u306e\u6e96\u5099<\/h2>\n

\u958b\u767a\u306e\u30d7\u30ed\u304c\u6559\u3048\u308b\u6a19\u6e96Django\u5b8c\u5168\u89e3\u8aac\u2015Web\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af (\u30c7\u30d9\u30ed\u30c3\u30d1\u30fc\u30fb\u30c4\u30fc\u30eb\u30fb\u30b7\u30ea\u30fc\u30ba)<\/a>\u3067\u306e\u4e8b\u4f8b\u3092\u53c2\u8003\u306b\u3001\u4ee5\u4e0b\u306e\u30d6\u30c3\u30af\u30de\u30fc\u30af\u30e2\u30c7\u30eb\u3092\u4e8b\u4f8b\u3068\u3059\u308b\u3002\"\" <\/p>\n

1.1 \u30af\u30e9\u30b9\u56f3<\/h3>\n
    \n
  1. \u30e6\u30fc\u30b6\u30fc\u306fURL\u3092\u30d6\u30c3\u30af\u30de\u30fc\u30af\u3067\u304d\u308b\u3002\n
  2. \u30e6\u30fc\u30b6\u30fc\u306f\u30d6\u30c3\u30af\u30de\u30fc\u30af\u3057\u305fURL\u306b\u8907\u6570\u306e\u30bf\u30b0\u3092\u4ed8\u4e0e\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002<\/li>\n<\/ol>\n

    \"bookmark_class\"<\/a><\/p>\n

    1.2 Django \u30e2\u30c7\u30eb\u30bd\u30fc\u30b9<\/h3>\n

    \u4ee5\u4e0b\u306e\u3088\u3046\u306aDjango\u30e2\u30c7\u30eb\u3092\u7528\u610f\u3002<\/p>\n

    from django.db import models\r\n\r\nclass User(models.Model):\r\n    user_id = models.CharField(max_length=20, db_index=True, unique=True)\r\n    password = models.CharField(max_length=20)\r\n\r\nclass Page(models.Model):\r\n    url = models.URLField(blank=False, max_length=1024)\r\n\r\nclass Tag(models.Model):\r\n    name = models.CharField(max_length=100, db_index=True, unique=True)\r\n\r\nclass Bookmark(models.Model):\r\n    page = models.ForeignKey('Page')\r\n    user = models.ForeignKey('User')\r\n    tags = models.ManyToManyField('Tag',blank=True)    \r\n<\/pre>\n
    1.3 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9<\/h3>\n
    syncdb \u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3001sqlite \u3067\u306f\u4ee5\u4e0b\u306e\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u6210\u3055\u308c\u308b\u3002<\/p>\n\n\n\n\n\n\n\n\n
    \u30c6\u30fc\u30d6\u30eb\u540d<\/td>\n\u30e2\u30c7\u30eb\u540d<\/td>\n\u5099\u8003<\/td>\n<\/tr>\n
    Bookmark_user<\/td>\nUser<\/td>\n <\/td>\n<\/tr>\n
    Bookmark_page<\/td>\nPage<\/td>\n <\/td>\n<\/tr>\n
    Bookmark_tag<\/td>\nTag<\/td>\n <\/td>\n<\/tr>\n
    Bookmark_bookmark<\/td>\nBookmark<\/td>\n <\/td>\n<\/tr>\n
    Bookmark_bookmark_tags<\/td>\nBookmark<\/td>\nBookmark\u3068Tag\u306e\u95a2\u4fc2\u304c\u591a\u5bfe\u591a\u306e\u305f\u3081\u3001RDB\u4e0a\u3067\u306f\u95a2\u9023\u30c6\u30fc\u30d6\u30eb\u304c\u751f\u6210\u3055\u308c\u308b\u3002<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    http:\/\/sqlitebrowser.org\/<\/a> \u3067DDL\u3092\u78ba\u8a8d\u3059\u308b\u3002<\/p>\n
    \"ddl\"<\/a><\/p>\n
    1.4 \u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u306e\u6295\u5165<\/h3>\n
    \u4ee5\u964d\u306e\u78ba\u8a8d\u306e\u305f\u3081\u306b\u3001\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3059\u308b\u3002<\/p>\n
        u1 = User(user_id='User1',password='pass1')\r\n    u1.save()\r\n    u2 = User(user_id='User2',password='pass2')\r\n    u2.save()\r\n    \r\n    p1 = Page(url='http:\/\/google.co.jp')\r\n    p1.save()\r\n    p2 = Page(url='http:\/\/yahoo.co.jp')\r\n    p2.save()\r\n    \r\n    t1 = Tag(name='search engine')\r\n    t1.save()\r\n    t2 = Tag(name='portal')\r\n    t2.save()\r\n    \r\n    b1 = Bookmark(page=p1,user=u1)\r\n    b1.save()\r\n    b1.tags.add(t1)\r\n    b1.tags.add(t2)\r\n    b1.save()\r\n    b2 = Bookmark(page=p2,user=u2)\r\n    b2.save()\r\n    b2.tags.add(t1)\r\n    b2.tags.add(t2)\r\n    b2.save()\r\n<\/pre>\n
    2.\u78ba\u8a8d\u65b9\u6cd5<\/h2>\n
    Django \u306e shell \u3067\u52d5\u4f5c\u78ba\u8a8d\u3092\u304a\u3053\u306a\u3046\u3002<\/p>\n
    python manage.py shell<\/pre>\n
    Eclipse + PyDev \u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30b3\u30f3\u30c6\u30ad\u30b9\u30c8\u30e1\u30cb\u30e5\u30fc \uff0d Django \uff0dShell with django enviroment \u304b\u3089\u3001Django Shell\u3092\u5229\u7528\u3067\u304d\u308b\u3002<\/p>\n
    \"pydev_console\"<\/a><\/p>\n
    3. Django \u306e Serializer \u3092\u4f7f\u3063\u3066\u307f\u308b<\/h2>\n
    3.1 Django \u30e2\u30c7\u30eb\u306e\u30e1\u30bf\u60c5\u5831\u304c\u51fa\u529b\u3055\u308c\u3066\u3057\u307e\u3046\u554f\u984c<\/h3>\n
    \u307e\u305a\u3001JSON\u306b\u5909\u63db\u3059\u308b\u305f\u3081\u306b\u3001Django \u306e\u30b7\u30ea\u30a2\u30e9\u30a4\u30b6\u30fc serializers.serialize(\u66f8\u5f0f,\u30aa\u30d6\u30b8\u30a7\u30af\u30c8) \u3067\u5909\u63db\u3059\u308b\u3002<\/p>\n
    https:\/\/docs.djangoproject.com\/en\/1.7\/topics\/serialization\/<\/a> <\/p>\n
    >>> from Bookmark.models import User,Page,Tag,Bookmark\r\n>>> from django.core import serializers\r\nusers = User.objects.all()\r\nserializers.serialize(\"json\", users)\r\n'[{\"pk\": 1, \"model\": \"Bookmark.user\", \"fields\": {\"password\": \"pass1\", \"user_id\": \"User1\"}}, {\"pk\": 2, \"model\": \"Bookmark.user\", \"fields\": {\"password\": \"pass2\", \"user_id\": \"User2\"}}]'\r\n<\/pre>\n
    \u5909\u63db\u3055\u308c\u305f\u3002\u305f\u3060\u3001\u898b\u306b\u304f\u3044\u306e\u3067\u3001\u51fa\u529b\u5148\u306b sys.stdout \u3001\u30a4\u30f3\u30c7\u30f3\u30c8\u306b2\u3092\u6307\u5b9a\u3057\u3066\u3001JSON\u3092\u6574\u5f62\u3059\u308b\u3002 <\/p>\n
    import sys\r\nserializers.serialize(\"json\", users, stream=sys.stdout, indent=2)\r\n[\r\n{\r\n  \"pk\": 1, \r\n  \"model\": \"Bookmark.user\", \r\n  \"fields\": {\r\n    \"password\": \"pass1\", \r\n    \"user_id\": \"User1\"\r\n  }\r\n},\r\n{\r\n  \"pk\": 2, \r\n  \"model\": \"Bookmark.user\", \r\n  \"fields\": {\r\n    \"password\": \"pass2\", \r\n    \"user_id\": \"User2\"\r\n  }\r\n}\r\n]<\/pre>\n
    \u4e0a\u306e\u51fa\u529b\u7d50\u679c\u3092\u898b\u3066\u308f\u304b\u308b\u901a\u308a\u3001pk\u3001model\u3001fields \u3068\u3044\u3046\u3001Django\u30e2\u30c7\u30eb\u306e\u30e1\u30bf\u60c5\u5831\u304c\u51fa\u529b\u3055\u308c\u3066\u3044\u308b\u3002<\/p>\n
    \u5fc5\u8981\u306a\u60c5\u5831\u306f\u3001fields \u4ee5\u4e0b\u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u3002<\/p>\n
    Django\u30e2\u30c7\u30eb\u306e\u30e1\u30bf\u60c5\u5831\u3092JSON\u3068\u3057\u3066\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3068\u3084\u308a\u53d6\u308a\u3059\u308b\u306e\u306f\u82e5\u5e72\u9055\u548c\u611f\u304c\u3042\u308b\u3002<\/p>\n
    3.2 \u5f15\u6570\u3068\u3057\u3066\u6e21\u3059\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u3001JSON \u914d\u5217\u306b\u306a\u3063\u3066\u3044\u306a\u3044\u3068\u30a8\u30e9\u30fc\u3068\u306a\u3063\u3066\u3057\u307e\u3046\u554f\u984c<\/h3>\n
    \u5358\u72ec\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6e21\u3059\u3068\u30a8\u30e9\u30fc\u3068\u306a\u3063\u3066\u3057\u307e\u3046\u3002<\/p>\n
    list \u3067 JSON\u914d\u5217\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3088\u3046\u3060\u3002<\/p>\n
    serializers.serialize(\"json\", users[0], stream=sys.stdout, indent=2)\r\n[Traceback (most recent call last):\r\n  File \"<input>\", line 1, in <module>\r\n  File \"E:\\virtualenv\\gappori\\lib\\site-packages\\django\\core\\serializers\\__init__.py\", line 99, in serialize\r\n    s.serialize(queryset, **options)\r\n  File \"E:\\virtualenv\\gappori\\lib\\site-packages\\django\\core\\serializers\\base.py\", line 42, in serialize\r\n    for obj in queryset:\r\nTypeError: 'User' object is not iterable<\/pre>\n
    3.3 Python\u306e\u7d44\u307f\u8fbc\u307f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u6e21\u3059\u3068\u30a8\u30e9\u30fc\u3068\u306a\u308b\u554f\u984c<\/h3>\n
    Python\u306e\u7d44\u307f\u8fbc\u307f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8(\u30ea\u30b9\u30c8\u3001\u30bf\u30d7\u30eb\u3001\u30de\u30c3\u30d7) \u3092\u6e21\u3059\u3068\u30a8\u30e9\u30fc\u3068\u306a\u308b\u3002Django \u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u5c02\u7528\u3068\u3044\u3046\u3053\u3068\u304b\u3002<\/p>\n
    >>> serializers.serialize(\"json\", [{\"test\":\"test\"}], stream=sys.stdout, indent=2)\r\n[Traceback (most recent call last):\r\n  File \"<input>\", line 1, in <module>\r\n  File \"E:\\virtualenv\\gappori\\lib\\site-packages\\django\\core\\serializers\\__init__.py\", line 99, in serialize\r\n    s.serialize(queryset, **options)\r\n  File \"E:\\virtualenv\\gappori\\lib\\site-packages\\django\\core\\serializers\\base.py\", line 46, in serialize\r\n    concrete_model = obj._meta.concrete_model\r\nAttributeError: 'dict' object has no attribute '_meta'<\/pre>\n
    3.4 Django \u30e2\u30c7\u30eb\u306b\u30c7\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba\u53ef\u80fd\u3068\u3044\u3046\u5229\u70b9<\/h3>\n
    \u30e1\u30bf\u60c5\u5831\u3092\u6301\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u4e0a\u8a183.1\u306e\u9055\u548c\u611f\u3092\u6c17\u306b\u3057\u306a\u3051\u308c\u3070\u3001JSON\u3092Django\u306e\u30e2\u30c7\u30eb\u306b\u30c7\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba\u3067\u304d\u308b\u3068\u3044\u3046\u5229\u70b9\u304c\u3042\u308b\u3002<\/p>\n
    users_json = serializers.serialize(\"json\", users)\r\nprint users_json\r\n[{\"pk\": 1, \"model\": \"Bookmark.user\", \"fields\": {\"password\": \"pass1\", \"user_id\": \"User1\"}}, {\"pk\": 2, \"model\": \"Bookmark.user\", \"fields\": {\"password\": \"pass2\", \"user_id\": \"User2\"}}]\r\n>>> deserialized_list = serializers.deserialize(\"json\", users_json)\r\n>>> for deserialized in deserialized_list:\r\n...    print deserialized.object.user_id\r\n...    \r\nUser1\r\nUser2<\/pre>\n
    3.5 Django \u306e Serializer \u307e\u3068\u3081<\/h3>\n
    Django\u306e\u30b7\u30ea\u30a2\u30e9\u30a4\u30b6\u30fc\u306e\u307f\u3092\u5229\u7528\u3057\u3066\u3001JSON\u3092\u53d6\u308a\u6271\u3046\u306e\u306f\u3001\u7121\u7406\u304c\u3042\u308b\u3002<\/p>\n
    \u3057\u304b\u3057\u3001Django \u30e2\u30c7\u30eb\u3092 JSON\u306b\u5909\u63db\u3059\u308b\u306b\u306f\u6709\u7528\u3002<\/p>\n
    \u30c7\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba\u304c\u3067\u304d\u308b\u306e\u306f\u9b45\u529b\u3060\u304c\u3001\u5229\u7528\u3067\u304d\u308b\u7b87\u6240\u304c\u9650\u5b9a\u3055\u308c\u305d\u3046\u3060\u3002<\/p>\n
    4. json \u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u5229\u7528<\/h2>\n
    http:\/\/docs.python.jp\/2\/library\/json.html<\/a><\/p>\n
    json.dump \u306f\u3001\u51fa\u529b\u5148\u3092\u6307\u5b9a\u3001json.dumps \u306f\u3001JSON\u6587\u5b57\u5217\u306b\u5909\u63db\u3059\u308b\u3002<\/p>\n
    <\/h3>\n
    4.1 Python \u7d44\u307f\u8fbc\u307f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u5909\u63db<\/h3>\n
    Django\u306e\u30b7\u30ea\u30a2\u30e9\u30a4\u30b6\u30fc\u3067\u306f\u3001\u30a8\u30e9\u30fc\u3060\u3063\u305f\u304c\u3001Python\u306e\u7d44\u307f\u8fbc\u307f\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f\u5f53\u7136\u5909\u63db\u3055\u308c\u308b\u3002<\/p>\n
    >>> json.dump([{\"test\":\"test\"}],sys.stdout,indent=2)\r\n[\r\n  {\r\n    \"test\": \"test\"\r\n  }\r\n]<\/pre>\n
    4.2 Django \u30e2\u30c7\u30eb\u306e\u5909\u63db<\/h3>\n
    Django\u30e2\u30c7\u30eb\u306f\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba\u3067\u304d\u306a\u3044\u3002\u307e\u3041\u5f53\u7136\u3068\u3044\u3048\u3070\u5f53\u7136\u304b\u3002<\/p>\n
    >>> users = User.objects.all()\r\n>>> json.dumps(users)\r\nTraceback (most recent call last):\r\n  File \"<input>\", line 1, in <module>\r\n  File \"E:\\Programs\\Python27\\Lib\\json\\__init__.py\", line 243, in dumps\r\n    return _default_encoder.encode(obj)\r\n  File \"E:\\Programs\\Python27\\Lib\\json\\encoder.py\", line 207, in encode\r\n    chunks = self.iterencode(o, _one_shot=True)\r\n  File \"E:\\Programs\\Python27\\Lib\\json\\encoder.py\", line 270, in iterencode\r\n    return _iterencode(o, 0)\r\n  File \"E:\\Programs\\Python27\\Lib\\json\\encoder.py\", line 184, in default\r\n    raise TypeError(repr(o) + \" is not JSON serializable\")\r\nTypeError: [, ] is not JSON serializable<\/pre>\n
    5.Django\u30e2\u30c7\u30eb\u3092Python\u7d44\u307f\u8fbc\u307f\u578b\u306b\u5909\u63db\u3059\u308b<\/h2>\n
    Djanogo\u306e\u30e2\u30c7\u30eb\u3092\u3001Python\u7d44\u307f\u8fbc\u307f\u578b\u306b\u5909\u63db\u3057\u305f\u5f8c\u306b\u3001json \u30e9\u30a4\u30d6\u30e9\u30ea\u306b\u3088\u308b\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba\u3092\u8a66\u307f\u308b\u3002<\/p>\n
    5.1 \u624b\u4f5c\u696d\u3067\u8f9e\u66f8\u5316<\/h3>\n
    \u7d20\u76f4\u306b\u8f9e\u66f8\u3092\u8fd4\u3059\u95a2\u6570\u3092\u5b9f\u88c5\u3059\u308b\u3002\u305f\u3060\u3001\u9805\u76ee\u304c\u591a\u304b\u3063\u305f\u308a\u3059\u308b\u3068\u9805\u76ee\u6570\u5206\u8f9e\u66f8\u306e\u30a8\u30f3\u30c8\u30ea\u3092\u8a18\u8ff0\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u305d\u3082\u305d\u3082\u9762\u5012\u3001\u3055\u3089\u306b\u3001\u5909\u66f4\u304c\u5165\u3063\u305f\u6642\u306b\u5909\u66f4\u3092\u6f0f\u3089\u3057\u305d\u3046\u3002<\/p>\n
    class User(models.Model):\r\n    user_id = models.CharField(max_length=20, db_index=True, unique=True)\r\n    password = models.CharField(max_length=20)\r\n    \r\n    def to_dict(self):\r\n        return {'user_id':self.user_id,\r\n                'password':self.password}\r\n<\/pre>\n
    \u7d50\u679c\u304c\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u306e\u5834\u5408\u306b\u5229\u7528\u3059\u308b\u306b\u306f\u3001\u30ea\u30b9\u30c8\u5185\u5305\u8868\u8a18\u3067 to_dict() \u3092\u547c\u3073\u51fa\u3057\u3001Django\u30e2\u30c7\u30eb -> Python \u8f9e\u66f8 \u306b\u5909\u63db\u3057\u305f\u30ea\u30b9\u30c8\u3092\u6e21\u305b\u3070\u3001\u610f\u56f3\u3057\u305f\u7d50\u679c\u306b\u306f\u306a\u308b\u3002<\/p>\n
    from Bookmark.models import User\r\nimport json\r\nusers = User.object.all()\r\njson.dumps([x.to_dict() for x in users])\r\n'[{\"password\": \"pass1\", \"user_id\": \"User1\"}, {\"password\": \"pass2\", \"user_id\": \"User2\"}]'<\/pre>\n
    5.1.1 JSONEncoder \u3092\u62e1\u5f35<\/h4>\n
    JSONEncoder \u3092\u62e1\u5f35\u3059\u308c\u3070\u3001\u3044\u3061\u3044\u3061\u3001\u30ea\u30b9\u30c8\u5185\u5305\u8868\u8a18 \u306b\u3057\u305f\u308a\u3001to_dict() \u3092\u547c\u3073\u51fa\u3057\u305f\u308a\u3059\u308b\u5fc5\u8981\u306f\u306a\u304f\u306a\u308b\u3002<\/p>\n
    http:\/\/docs.python.jp\/2\/library\/json.html<\/a><\/p>\n
    http:\/\/d.hatena.ne.jp\/shobonengine\/20120119\/1326949993<\/a><\/p>\n
    import json\r\nfrom django.db import models as django_models\r\nfrom django.db.models.query import QuerySet\r\nclass MyJsonEncoder(json.JSONEncoder):\r\n    def default(self, obj):\r\n        if isinstance(obj, django_models.Model) and hasattr(obj, 'to_dict'):\r\n            return obj.to_dict()\r\n        if isinstance(obj, QuerySet):\r\n            return list(obj)\r\n        json.JSONEncoder.default(self, obj)\r\n<\/pre>\n
    \u30a8\u30f3\u30b3\u30fc\u30c0\u30fc\u306b\u3088\u308a\u5185\u90e8\u7684\u306b\u547c\u3073\u51fa\u3055\u308c\u308b\u306e\u3067\u3001to_dict() \u3092\u660e\u793a\u7684\u306b\u547c\u3073\u51fa\u3059\u5fc5\u8981\u304c\u306a\u304f\u306a\u308b\u3002<\/p>\n
    cls=MyJsonEncoder \u306e\u8a18\u8ff0\u304c\u308f\u305a\u3089\u308f\u3057\u3044\u304c\u3001\u95a2\u6570\u5316\u3057\u3066\u3057\u307e\u3048\u3070\u3088\u3055\u305d\u3046\u3060\u3002<\/p>\n
    >>> from Bookmark.models import User,MyJsonEncoder\r\n>>> import json\r\n>>> users = User.objects.all()\r\n>>> json.dumps(users, cls=MyJsonEncoder)\r\n'[{\"password\": \"pass1\", \"user_id\": \"User1\"}, {\"password\": \"pass2\", \"user_id\": \"User2\"}]'\r\n<\/pre>\n
    5.2 model_to_dict \u3092\u4f7f\u3046<\/h3>\n
    \u4e0a\u8a185.1 \u3067 Django\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u8f9e\u66f8\u5316\u3059\u308b\u3001to_dict() \u95a2\u6570\u306e\u5b9f\u88c5\u304c\u9762\u5012\u3060\u3068\u66f8\u3044\u305f\u3002<\/p>\n
    django.forms.models \u306e model_to_dict \u3092\u4f7f\u3046\u3068\u3001Django \u30e2\u30c7\u30eb\u306e\u8f9e\u66f8\u5316\u3092\u884c\u3046\u3053\u3068\u304c\u3067\u304d\u308b\u3002<\/p>\n
    \u3053\u308c\u3067\u3001\u9805\u76ee\u3092\u3044\u3061\u3044\u3061\u8f9e\u66f8\u5316\u3059\u308b\u308f\u305a\u3089\u308f\u3057\u3055\u304b\u3089\u89e3\u653e\u3055\u308c\u308b\u3002<\/p>\n
    from django.db import models\r\nfrom django.forms.models import model_to_dict\r\n\r\nclass User(models.Model):\r\n    user_id = models.CharField(max_length=20, db_index=True, unique=True)\r\n    password = models.CharField(max_length=20)\r\n    \r\n    def to_dict(self):\r\n        return model_to_dict(self)<\/pre>\n
    \u7d50\u679c\u3053\u3046\u306a\u308b\u3002Django \u304c\u81ea\u52d5\u751f\u6210\u3059\u308b\u3001id \u5c5e\u6027\u304c\u51fa\u529b\u3055\u308c\u308b\u304c\u3001\u3053\u308c\u306f\u671b\u307e\u3057\u3044\u7d50\u679c\u3067\u306f\u3042\u308b\u3002<\/p>\n
    >>> from Bookmark.models import User,MyJsonEncoder\r\n>>> import json\r\n>>> users = User.objects.all()\r\n>>> json.dumps(users, cls=MyJsonEncoder)\r\n'[{\"password\": \"pass1\", \"user_id\": \"User1\", \"id\": 1}, {\"password\": \"pass2\", \"user_id\": \"User2\", \"id\": 2}]'<\/pre>\n
    5.3 values() \u3092\u4f7f\u3046<\/h3>\n
    \u5b9f\u306f\u3001QuerySet\u306b\u5bfe\u3057\u3066\u3001vlaues() \u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u4e0a\u8a18model_to_dict \u3092\u4f7f\u7528\u3057\u305f\u306e\u3068\u540c\u69d8\u306b\u3001\u7d50\u679c\u3092Django \u30e2\u30c7\u30eb\u3067\u306f\u306a\u304f\u8f9e\u66f8\u3067\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002<\/p>\n
    >>> User.objects.all().values()\r\n[{'password': u'pass1', 'user_id': u'User1', u'id': 1}, {'password': u'pass2', 'user_id': u'User2', u'id': 2}]<\/pre>\n
    5.4 json \u30e9\u30a4\u30d6\u30e9\u30ea\u306e\u307e\u3068\u3081<\/h3>\n
    \u5b9f\u969b\u306b\u306f\u3053\u3061\u3089\u3092\u5229\u7528\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u305d\u3046\u3060\u3002JSONEncoder \u3068\u3001Django \u306e model_to_dict \u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u3044\u3044\u611f\u3058\u306bJSON\u3078\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba\u3067\u304d\u305d\u3046\u3060\u3002 <\/p>\n
    6.\u5916\u90e8\u30ad\u30fc\u306b\u3088\u308b\u7d50\u5408<\/h2>\n
    \u4e0a\u8a18\u307e\u3067\u306f\u3001\u5358\u7d14\u306a Django \u30e2\u30c7\u30eb\u306e\u5834\u5408\u3002\u5916\u90e8\u30ad\u30fc\u3092\u6301\u3064\u30e2\u30c7\u30eb\u306e\u5834\u5408\u3001\u82e5\u5e72\u4e8b\u60c5\u304c\u7570\u306a\u308b\u3002<\/p>\n
    \u307e\u305a\u3001\u3069\u306e\u3088\u3046\u306aSQL\u304c\u751f\u6210\u3055\u308c\u308b\u306e\u304b\u3068\u3001\u52b9\u7387\u7684\u306b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u3092\u53d6\u5f97\u3059\u308b\u65b9\u6cd5\u3092\u898b\u3066\u307f\u308b\u3002<\/p>\n
    6.1 \u767a\u884c\u3055\u308c\u308bSQL\u306e\u78ba\u8a8d<\/h3>\n
    \u5916\u90e8\u30ad\u30fc\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb\u3092\u53d6\u5f97\u3059\u308b\u30e1\u30bd\u30c3\u30c9\u304c\u3069\u3093\u306aSQL\u3092\u51fa\u529b\u3059\u308b\u306e\u304b\u306f\u3001query \u3067\u53c2\u7167\u3067\u304d\u308b\u3002all() \u3067\u5168\u4ef6\u53d6\u5f97\u3059\u308bSQL\u3067\u306f\u3001\u30d9\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u306e\u307f\u30d5\u30a7\u30c3\u30c1\u3057\u3001\u5916\u90e8\u30ad\u30fc\u306f\u89e3\u6c7a\u3055\u308c\u3066\u3044\u306a\u3044(JOIN\u3055\u308c\u3066\u3044\u306a\u3044)\u3053\u3068\u304c\u308f\u304b\u308b\u3002<\/p>\n
    print Bookmark.objects.all().query\r\nSELECT \"Bookmark_bookmark\".\"id\", \"Bookmark_bookmark\".\"page_id\", \"Bookmark_bookmark\".\"user_id\" FROM \"Bookmark_bookmark\"<\/pre>\n
    \u305f\u3060\u3001\u53d6\u5f97\u3057\u305f\u7d50\u679c\u306b\u5bfe\u3057\u3066\u3001\u5024\u3092\u53c2\u7167\u3059\u308b\u3068\u3001\u305d\u306e\u30bf\u30a4\u30df\u30f3\u30b0\u3067\u5916\u90e8\u30ad\u30fc\u306b\u3088\u308b\u53c2\u7167\u304c\u89e3\u6c7a\u3055\u308c\u308b\u3002\u3069\u306e\u3088\u3046\u306aSQL\u304c\u767a\u884c\u3055\u308c\u308b\u306e\u304b\u78ba\u8a8d\u3057\u3066\u307f\u308b\u3002<\/p>\n
    http:\/\/www.dabapps.com\/blog\/logging-sql-queries-django-13\/<\/a><\/p>\n
    \u767a\u884c\u3055\u308c\u308bSQL\u3092\u30b3\u30f3\u30bd\u30fc\u30eb\u306b\u30ed\u30ae\u30f3\u30b0\u3059\u308b\u305f\u3081\u306e\u6e96\u5099\u3002<\/p>\n
    >>> import logging\r\n>>> l = logging.getLogger('django.db.backends')\r\n>>> l.setLevel(logging.DEBUG)\r\n>>> l.addHandler(logging.StreamHandler())<\/pre>\n
    \u30b3\u30fc\u30c9\u4e0a\u3001all() \u3067\u5168\u4ef6\u53d6\u5f97\u3059\u308bSQL\u3092\u767a\u884c\u3057\u3066\u3044\u308b\u3088\u3046\u306b\u898b\u3048\u308b\u306e\u3060\u304c\u3001\u5916\u90e8\u30ad\u30fc\u306f\u5916\u90e8\u30ad\u30fc\u7d4c\u7531\u306e\u5024\u53c2\u7167\u6642\u306b\u89e3\u6c7a\u3055\u308c\u3001\u30eb\u30fc\u30d7\u306e\u4e2d\u3067SQL\u304c\u767a\u884c\u3055\u308c\u3066\u3044\u308b\u306e\u304c\u3001\u767a\u884c\u3055\u308c\u305fSQL\u3092\u898b\u308b\u3068\u308f\u304b\u308b(\u9045\u5ef6\u8a55\u4fa1)\u3002<\/p>\n
    >>> for b in Bookmark.objects.all():\r\n...    print b.page.url\r\n...    \r\nhttp:\/\/google.co.jp\r\nhttp:\/\/yahoo.co.jp\r\n(0.000) SELECT \"Bookmark_bookmark\".\"id\", \"Bookmark_bookmark\".\"page_id\", \"Bookmark_bookmark\".\"user_id\" FROM \"Bookmark_bookmark\"; args=()\r\n(0.000) SELECT \"Bookmark_page\".\"id\", \"Bookmark_page\".\"url\" FROM \"Bookmark_page\" WHERE \"Bookmark_page\".\"id\" = 1 ; args=(1,)\r\n(0.004) SELECT \"Bookmark_page\".\"id\", \"Bookmark_page\".\"url\" FROM \"Bookmark_page\" WHERE \"Bookmark_page\".\"id\" = 2 ; args=(2,)<\/pre>\n
    6.2 SQL\u306e\u6700\u9069\u5316<\/h3>\n
    \u4e0a\u8a18\u306eSQL\u3067\u306f\u3001all()\u306e\u4ef6\u6570\u5206\u3001\u30eb\u30fc\u30d7\u5185\u90e8\u3067\u5916\u90e8\u30ad\u30fc\u7d4c\u7531\u306e\u5024\u3092\u53c2\u7167\u3059\u308b\u305f\u3073\u306bSQL\u304c\u767a\u884c\u3055\u308c\u3066\u3057\u307e\u3046\u3002<\/p>\n
    http:\/\/www.neustar.biz\/blog\/optimizing-django-queries<\/a><\/p>\n
    select_related() \u3092\u5229\u7528\u3059\u308b\u3068\u3001INNER JOIN \u3057\u305fSQL\u304c\u767a\u884c\u3055\u308c\u308b\u305f\u3081\u3001\u4e00\u56de\u306eDB\u30a2\u30af\u30bb\u30b9\u3067\u3059\u3080<\/p>\n
    \u4ee5\u4e0b\u306f\u3001\u5916\u90e8\u30ad\u30fc page \u3092\u540c\u6642\u306b\u53d6\u5f97\u3059\u308b\u4f8b<\/p>\n
    >>> print Bookmark.objects.all().select_related('page').query\r\nSELECT \"Bookmark_bookmark\".\"id\", \"Bookmark_bookmark\".\"page_id\", \"Bookmark_bookmark\".\"user_id\", \"Bookmark_page\".\"id\", \"Bookmark_page\".\"url\" FROM \"Bookmark_bookmark\" INNER JOIN \"Bookmark_page\" ON (\"Bookmark_bookmark\".\"page_id\" = \"Bookmark_page\".\"id\")\r\n<\/pre>\n
    \u3053\u308c\u306b\u3088\u3063\u3066\u3001\u3053\u306e\u4f8b\u3067\u306f\u30011\u56de\u306eSQL\u767a\u884c\u3067\u540c\u69d8\u306e\u7d50\u679c\u304c\u53d6\u5f97\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u304c\u308f\u304b\u308b\u3002<\/p>\n
    >>> for b in Bookmark.objects.all().select_related('page'):\r\n...    print b.page.url\r\n...    \r\nhttp:\/\/google.co.jp\r\nhttp:\/\/yahoo.co.jp\r\n(0.000) SELECT \"Bookmark_bookmark\".\"id\", \"Bookmark_bookmark\".\"page_id\", \"Bookmark_bookmark\".\"user_id\", \"Bookmark_page\".\"id\", \"Bookmark_page\".\"url\" FROM \"Bookmark_bookmark\" INNER JOIN \"Bookmark_page\" ON (\"Bookmark_bookmark\".\"page_id\" = \"Bookmark_page\".\"id\"); args=()\r\n<\/pre>\n
    6.3 JSON\u5316<\/h3>\n
    <\/a>\"\" <\/p>\n
    \u3067\u306f\u3001\u3053\u306e\u5916\u90e8\u30ad\u30fc\u3092\u89e3\u6c7a\u3057\u305f\u72b6\u614b\u306eJSON\u3092\u3069\u3046\u3084\u3063\u3066\u4f5c\u6210\u3059\u308b\u304b\u3002<\/p>\n
    values() \u3067\u8f9e\u66f8\u5316\u3059\u308b\u5834\u5408\u3001\u5185\u90e8\u7684\u306b\u306f INNER JOIN \u3055\u308c\u3066\u5916\u90e8\u30ad\u30fc\u306b\u3088\u308b\u53c2\u7167\u306f\u89e3\u6c7a\u3055\u308c\u3066\u3044\u308b\u306e\u3060\u304c\u3001\u8f9e\u66f8\u5316\u3055\u308c\u308b\u306e\u306f\u3001\u3042\u304f\u307e\u3067\u3000Bookmark\u81ea\u4f53\u3067\u3042\u308a\u3001\u5916\u90e8\u30ad\u30fc\u7d4c\u7531\u3067\u89e3\u6c7a\u3055\u308c\u308b\u30aa\u30d6\u30b8\u30a7\u30af\u30c8(Page\u3001Tag)\u306f\u542b\u307e\u308c\u3066\u3044\u306a\u3044\u3002<\/p>\n
    >>> Bookmark.objects.all().select_related('page').values()\r\n[{'user_id': 1, 'page_id': 1, u'id': 1}, {'user_id': 2, 'page_id': 2, u'id': 2}]\r\n(0.000) SELECT \"Bookmark_bookmark\".\"id\", \"Bookmark_bookmark\".\"page_id\", \"Bookmark_bookmark\".\"user_id\" FROM \"Bookmark_bookmark\" LIMIT 21; args=()\r\n<\/pre>\n
    model_to_dict() \u3092\u5b9f\u88c5\u3057\u3066\u307f\u308b\u3068\u3069\u3046\u304b\u3002<\/p>\n
    class Bookmark(models.Model):\r\n    page = models.ForeignKey('Page')\r\n    user = models.ForeignKey('User')\r\n    tags = models.ManyToManyField('Tag',blank=True)    \r\n    \r\n    def to_dict(self):\r\n        return model_to_dict(self)    \r\n<\/pre>\n
    tag \u306e\u5916\u90e8\u30ad\u30fc\u3082\u8868\u793a\u3055\u308c\u308b\u3088\u3046\u306b\u306a\u3063\u305f\u304c\u3001\u5916\u90e8\u30ad\u30fc\u304b\u3089\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f\u89e3\u6c7a\u3055\u308c\u306a\u3044\u3002<\/p>\n
    >>> for b in Bookmark.objects.all().select_related('page'):\r\n...    print json.dumps(b, cls=MyJsonEncoder)\r\n...    \r\n{\"user\": 1, \"tags\": [1, 2], \"id\": 1, \"page\": 1}\r\n{\"user\": 2, \"tags\": [1, 2], \"id\": 2, \"page\": 2}<\/pre>\n
    \u5916\u90e8\u30ad\u30fc\u3092\u542b\u3080\u30e2\u30c7\u30eb(Bookmark)\u306b\u5bfe\u3057\u3066\u306f\u3001\u4e0a\u8a185.1 \u306e\u3088\u3046\u306b\u624b\u4f5c\u696d\u3067\u8f9e\u66f8\u3092\u4f5c\u6210\u3059\u308b\u306e\u304c\u59a5\u5f53\u304b\u3002\u5916\u90e8\u30ad\u30fc\u306b\u3088\u308a\u53c2\u7167\u3055\u308c\u308b\u5074\u306f\u3001model_to_dict \u3092\u5b9f\u88c5\u3057\u3066\u304a\u304f\u611f\u3058\u304b\u3002<\/p>\n
    class Page(models.Model):\r\n    url = models.URLField(blank=False, max_length=1024)\r\n    def to_dict(self):\r\n        return model_to_dict(self)    \r\n\r\nclass Tag(models.Model):\r\n    name = models.CharField(max_length=100, db_index=True, unique=True)\r\n    def to_dict(self):\r\n        return model_to_dict(self)    \r\n    \r\nclass Bookmark(models.Model):\r\n    page = models.ForeignKey('Page')\r\n    user = models.ForeignKey('User')\r\n    tags = models.ManyToManyField('Tag',blank=True)    \r\n    \r\n    def to_dict(self):\r\n        #return model_to_dict(self)    \r\n        return {\r\n            'page':self.page.to_dict(),\r\n            'tags':[x.to_dict() for x in self.tags]\r\n        }\r\n<\/pre>\n
    \u3053\u308c\u3067\u3001\u5b9f\u884c\u3057\u3066\u307f\u308b\u3068\u3001\u308f\u308a\u3042\u3044\u3001\u5e0c\u671b\u3057\u305f\u7d50\u679c\u304c\u53d6\u5f97\u3055\u308c\u305f\u3002<\/p>\n
    \u305f\u3060\u3001SQL\u304c5\u56de\u767a\u884c\u3055\u308c\u3066\u3044\u308b\u3002<\/p>\n
    >>> for b in Bookmark.objects.all():\r\n...    print json.dumps(b, cls=MyJsonEncoder)\r\n...    \r\n{\"page\": {\"url\": \"http:\/\/google.co.jp\", \"id\": 1}, \"tags\": [{\"id\": 1, \"name\": \"search engine\"}, {\"id\": 2, \"name\": \"portal\"}]}\r\n{\"page\": {\"url\": \"http:\/\/yahoo.co.jp\", \"id\": 2}, \"tags\": [{\"id\": 1, \"name\": \"search engine\"}, {\"id\": 2, \"name\": \"portal\"}]}\r\n(0.000) SELECT \"Bookmark_bookmark\".\"id\", \"Bookmark_bookmark\".\"page_id\", \"Bookmark_bookmark\".\"user_id\" FROM \"Bookmark_bookmark\"; args=()\r\n(0.000) SELECT \"Bookmark_page\".\"id\", \"Bookmark_page\".\"url\" FROM \"Bookmark_page\" WHERE \"Bookmark_page\".\"id\" = 1 ; args=(1,)\r\n(0.000) SELECT \"Bookmark_tag\".\"id\", \"Bookmark_tag\".\"name\" FROM \"Bookmark_tag\" INNER JOIN \"Bookmark_bookmark_tags\" ON (\"Bookmark_tag\".\"id\" = \"Bookmark_bookmark_tags\".\"tag_id\") WHERE \"Bookmark_bookmark_tags\".\"bookmark_id\" = 1 ; args=(1,)\r\n(0.000) SELECT \"Bookmark_page\".\"id\", \"Bookmark_page\".\"url\" FROM \"Bookmark_page\" WHERE \"Bookmark_page\".\"id\" = 2 ; args=(2,)\r\n(0.000) SELECT \"Bookmark_tag\".\"id\", \"Bookmark_tag\".\"name\" FROM \"Bookmark_tag\" INNER JOIN \"Bookmark_bookmark_tags\" ON (\"Bookmark_tag\".\"id\" = \"Bookmark_bookmark_tags\".\"tag_id\") WHERE \"Bookmark_bookmark_tags\".\"bookmark_id\" = 2 ; args=(2,)\r\n<\/pre>\n
    select_related() \u3092\u6307\u5b9a\u3059\u308b\u3068\u3001\u5916\u90e8\u30ad\u30fc\u306e\u89e3\u6c7a\u304c\u524a\u6e1b\u3067\u304d\u308b\u30025\u56de\u306eSQL\u767a\u884c\u304c3\u56de\u306b\u524a\u6e1b\u3055\u308c\u305f\u3002<\/p>\n
    \u305f\u3060\u3057\u3001\u3053\u306e\u30c6\u30af\u30cb\u30c3\u30af\u306f\u3001MenyToMeny\u306b\u306f(\u4eca\u56de\u306e\u4f8b\u3067\u306f\u3001Bookmark \u3068 Tag)\u5229\u7528\u3067\u304d\u306a\u3044\u3088\u3046\u3060\u3002<\/p>\n
    http:\/\/www.neustar.biz\/blog\/optimizing-django-queries<\/a><\/p>\n
    >>> for b in Bookmark.objects.all().select_related('page'):\r\n...    print json.dumps(b, cls=MyJsonEncoder, indent=2)\r\n...    \r\n{\r\n  \"page\": {\r\n    \"url\": \"http:\/\/google.co.jp\", \r\n    \"id\": 1\r\n  }, \r\n  \"tags\": [\r\n    {\r\n      \"id\": 1, \r\n      \"name\": \"search engine\"\r\n    }, \r\n    {\r\n      \"id\": 2, \r\n      \"name\": \"portal\"\r\n    }\r\n  ]\r\n}\r\n{\r\n  \"page\": {\r\n    \"url\": \"http:\/\/yahoo.co.jp\", \r\n    \"id\": 2\r\n  }, \r\n  \"tags\": [\r\n    {\r\n      \"id\": 1, \r\n      \"name\": \"search engine\"\r\n    }, \r\n    {\r\n      \"id\": 2, \r\n      \"name\": \"portal\"\r\n    }\r\n  ]\r\n}\r\n(0.000) SELECT \"Bookmark_bookmark\".\"id\", \"Bookmark_bookmark\".\"page_id\", \"Bookmark_bookmark\".\"user_id\", \"Bookmark_page\".\"id\", \"Bookmark_page\".\"url\" FROM \"Bookmark_bookmark\" INNER JOIN \"Bookmark_page\" ON (\"Bookmark_bookmark\".\"page_id\" = \"Bookmark_page\".\"id\"); args=()\r\n(0.000) SELECT \"Bookmark_tag\".\"id\", \"Bookmark_tag\".\"name\" FROM \"Bookmark_tag\" INNER JOIN \"Bookmark_bookmark_tags\" ON (\"Bookmark_tag\".\"id\" = \"Bookmark_bookmark_tags\".\"tag_id\") WHERE \"Bookmark_bookmark_tags\".\"bookmark_id\" = 1 ; args=(1,)\r\n(0.000) SELECT \"Bookmark_tag\".\"id\", \"Bookmark_tag\".\"name\" FROM \"Bookmark_tag\" INNER JOIN \"Bookmark_bookmark_tags\" ON (\"Bookmark_tag\".\"id\" = \"Bookmark_bookmark_tags\".\"tag_id\") WHERE \"Bookmark_bookmark_tags\".\"bookmark_id\" = 2 ; args=(2,)\r\n<\/pre>\n
    7.\u307e\u3068\u3081<\/h2>\n
      \n
    • JSON\u3078\u306e\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba\u3067\u306f\u3001json \u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u5229\u7528\u3059\u308b\u3002<\/li>\n
    • Django\u30e2\u30c7\u30eb\u3092\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba\u3059\u308b\u306b\u306f\u3001JSONEncoder \u3092\u62e1\u5f35\u3059\u308b\u3002<\/li>\n
    • Djaong \u30e2\u30c7\u30eb\u306e\u8f9e\u66f8\u5316\u306b\u306f\u3001Django\u306e model_to_dict() \u3092\u4f7f\u7528\u3059\u308b\u3002<\/li>\n
    • \u5916\u90e8\u30ad\u30fc\u3092\u6301\u3064Django\u30e2\u30c7\u30eb\u306e\u8f9e\u66f8\u5316\u306f\u624b\u4f5c\u696d\u3067\u5b9f\u65bd\u3002<\/li>\n
    • \u5916\u90e8\u30ad\u30fc\u3092\u6301\u3064Django\u30e2\u30c7\u30eb\u306equeryd\u3067\u306f\u3001select_related() \u3092\u5229\u7528\u3059\u308b\u3053\u3068\u3067SQL\u306e\u767a\u884c\u3092\u524a\u6e1b\u3067\u304d\u308b\u3002<\/li>\n<\/ul>\n
      \u30c7\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba\u306b\u3064\u3044\u3066\u306f\u3001\u307e\u305f\u4eca\u5ea6\u8003\u3048\u308b\u3002<\/p>\n