質問編集履歴
2
インデントを適切にした
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -10,16 +10,16 @@
|
|
|
10
10
|
|
|
11
11
|
```python
|
|
12
12
|
（import+ssh接続+sql接続）
|
|
13
|
-
|
|
13
|
+
Z_1 = np.array(3.6515*(-2)*(X_1)*(np.cos(data_1))+450.55*(np.cos(data_1)))
|
|
14
14
|
|
|
15
|
-
|
|
15
|
+
sql2 = 'INSERT INTO *** (A,B,C,D,E,F,G,H,I,J,K,L) VALUE (1,1,1,1,1,1,1,1,'+str(Z_1)+',12,1,NOW()))';
|
|
16
16
|
|
|
17
|
-
|
|
17
|
+
try:
|
|
18
|
-
|
|
18
|
+
with cnn.cursor() as cursor:
|
|
19
|
-
|
|
19
|
+
cursor.execute(sql2)
|
|
20
|
-
|
|
20
|
+
cnn.commit()
|
|
21
|
-
|
|
21
|
+
except:
|
|
22
|
-
|
|
22
|
+
True
|
|
23
23
|
|
|
24
24
|
|
|
25
25
|
|
1
追記した
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -24,6 +24,7 @@
|
|
|
24
24
|
|
|
25
25
|
|
|
26
26
|
finally:
|
|
27
|
+
cnn.commit()
|
|
27
28
|
cnn.close()
|
|
28
29
|
server.stop()
|
|
29
30
|
|