質問編集履歴

1

ソースコードを全文載せました。

2018/03/30 12:30

投稿

hiro__12
hiro__12

スコア36

test CHANGED
File without changes
test CHANGED
@@ -29,6 +29,128 @@
29
29
 
30
30
 
31
31
  ```ここに言語名を入力
32
+
33
+ import xml.etree.ElementTree as ElementTree
34
+
35
+ from xml.dom import minidom
36
+
37
+ import logging
38
+
39
+ from orator import DatabaseManager, Model
40
+
41
+ from orator.orm import belongs_to, has_many
42
+
43
+
44
+
45
+ logger = logging.getLogger('orator.connection.queries')
46
+
47
+ logger.setLevel(logging.DEBUG)
48
+
49
+
50
+
51
+ formatter = logging.Formatter(
52
+
53
+ 'It took %(elapsed_time)sms to execute the query %(query)s'
54
+
55
+ )
56
+
57
+
58
+
59
+ handler = logging.StreamHandler()
60
+
61
+ handler.setFormatter(formatter)
62
+
63
+
64
+
65
+ logger.addHandler(handler)
66
+
67
+
68
+
69
+ config = {
70
+
71
+ 'mysql': {
72
+
73
+ 'driver': 'mysql',
74
+
75
+ 'host': 'localhost',
76
+
77
+ 'database': 'aozora_bunko',
78
+
79
+ 'user': 'root',
80
+
81
+ 'password': '',
82
+
83
+ 'prefix': '',
84
+
85
+ 'log_queries': True,
86
+
87
+ }
88
+
89
+ }
90
+
91
+
92
+
93
+ db = DatabaseManager(config)
94
+
95
+ Model.set_connection_resolver(db)
96
+
97
+
98
+
99
+ class MojidukaiType(Model):
100
+
101
+
102
+
103
+ pass
104
+
105
+
106
+
107
+ class Work(Model):
108
+
109
+
110
+
111
+ URL_FORMAT = "http://www.aozora_bunko.gr.jp/cards/{writer_id:06d}/card{id}.html"
112
+
113
+
114
+
115
+ @belongs_to
116
+
117
+ def mojidukai_type(self):
118
+
119
+ return MojidukaiType
120
+
121
+
122
+
123
+ @belongs_to
124
+
125
+ def writer(self):
126
+
127
+ return writer
128
+
129
+
130
+
131
+ def build_url(self):
132
+
133
+ return self.URL_FORMAT.format(
134
+
135
+ writer_id=self.writer_id,
136
+
137
+ id=self.id
138
+
139
+ )
140
+
141
+
142
+
143
+ class Writer(Model):
144
+
145
+
146
+
147
+ @has_many
148
+
149
+ def works(self):
150
+
151
+ return Work
152
+
153
+
32
154
 
33
155
  def create_xml():
34
156
 
@@ -64,6 +186,8 @@
64
186
 
65
187
  xml_str = create_xml()
66
188
 
67
- print(xml_str)
189
+ print(xml_str)
190
+
191
+
68
192
 
69
193
  ```