質問編集履歴

修正

2021/07/27 02:24

投稿

aiai8976

スコア112

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -94,306 +94,272 @@
-type CostHistory = {
+export const InputScreen: VFC<Props> = ({ navigation, route }) => {
-  cost: number;
+  //略
-  category: string;
+  const [items, setItems] = useState<SQLite.SQLResultSet>();
-  memo: string;
+  let db: any;
+  useEffect(() => {
+    initializeDatabase();
+  }, [])
+  const initializeDatabase = () => {
+    // DBの作成先
+    console.log(FileSystem.documentDirectory + "SQLite/");
+    // DBのオープン
+    db = SQLite.openDatabase("DB.db");
+    db.transaction((tx: any) => {
+      tx.executeSql(
+        "create table if not exists costHistory (id integer primary key autoincrement, cost integer not null, category string not null, memo string, date date not null);",
+        null,
+        () => { // 成功時のコールバック
+          console.log("initialize success");
+        },
+        () => { // 失敗時のコールバック
+          console.log("initialize fail");
+          return true; //　ロールバックする場合はtrueを返す
+        }
+      );
+    });
+  }
+  const errorDB = () => {
+    console.log('DB open failed.');
+  }
+  const showDatePicker = () => {
+    setDatePickerVisibility(true);
+  };
+  const hideDatePicker = () => {
+    setDatePickerVisibility(false);
+  };
+  const handleConfirm = (date: Date) => {
-  date: Date;
+    setDate(date);
+    hideDatePicker();
+  };
+  const onPress = (account_name: string) => {
+    navigation.navigate("Account", { account_name });
+  };
+  const onClickStore = () => {
+    db.transaction((tx: any) => {
+      tx.executeSql(
+        "insert into costHistory (cost, category, memo, date) values (?, ?, ?, ?);",
+        [cost, category, memo, date],
+        () => {
+          console.log("insert success");
+        }, // 成功時のコールバック関数
+        () => {
+          console.log("insert fail");
+          return true; // ロールバックする場合はtrueを返す
+        } // 失敗時のコールバック関数
+      );
+      tx.executeSql(
+        "select * from costHistory;",
+        [],
+        (_, resultSet: any) => {
+          setItems(resultSet);
+          console.log("select success");
+          for (let i = 0; i < resultSet.rows.length; i++) {
+            const id = resultSet.rows.item(i).id;
+            const name = resultSet.rows.item(i).name;
+            console.log(resultSet?.rows);
+            console.log(`${id}:${name}`);
+          }
+        },
+        () => {
+          console.log("select fail");
+          return false;
+        }
+      )
+    });
+    };
+  return (
+    //　略
+  );
 };
-const CostSchema = {
-  name: "Cost",
-  properties: {
-    _id: "int",
-    cost: "int",
-    date: "string",
-    category: "string",
-    memo: "string",
-  },
-  primaryKey: "_id",
-};
-export const InputScreen: VFC<Props> = ({ navigation, route }) => {
-  //略
-  const [items, setItems] = useState<SQLite.SQLResultSet>();
-  let db: any;
-  useEffect(() => {
-    initializeDatabase();
-  }, [])
-  const initializeDatabase = () => {
-    // DBの作成先
-    console.log(FileSystem.documentDirectory + "SQLite/");
-    // DBのオープン
-    db = SQLite.openDatabase("DB.db");
-    db.transaction((tx: any) => {
-      tx.executeSql(
-        "create table if not exists costHistory (id integer primary key autoincrement, cost integer not null, category string not null, memo string, date date not null);",
-        null,
-        () => { // 成功時のコールバック
-          console.log("initialize success");
-        },
-        () => { // 失敗時のコールバック
-          console.log("initialize fail");
-          return true; //　ロールバックする場合はtrueを返す
-        }
-      );
-    });
+const styles = StyleSheet.create({
+  // 略
+});
+```
+### 試したこと
+app.jsonにsdkVersionの追加
+```
+{
+  "expo": {
+    "name": "app",
+    "slug": "app",
+    "sdkVersion": "41.0.0",
+    "version": "1.0.0",
+    "orientation": "portrait",
+    "icon": "./assets/icon.png",
+    "splash": {
+      "image": "./assets/splash.png",
+      "resizeMode": "contain",
+      "backgroundColor": "#ffffff"
+    },
+    "updates": {
+      "fallbackToCacheTimeout": 0
+    },
+    "assetBundlePatterns": ["**/*"],
+    "ios": {
+      "supportsTablet": true
+    },
+    "android": {
+      "adaptiveIcon": {
+        "foregroundImage": "./assets/adaptive-icon.png",
+        "backgroundColor": "#FFFFFF"
+      }
+    },
+    "web": {
+      "favicon": "./assets/favicon.png"
+    }
   }
-  const errorDB = () => {
-    console.log('DB open failed.');
-  }
-  const showDatePicker = () => {
-    setDatePickerVisibility(true);
-  };
-  const hideDatePicker = () => {
-    setDatePickerVisibility(false);
-  };
-  const handleConfirm = (date: Date) => {
-    setDate(date);
-    hideDatePicker();
-  };
-  const onPress = (account_name: string) => {
-    navigation.navigate("Account", { account_name });
-  };
-  const onClickStore = () => {
-    db.transaction((tx: any) => {
-      tx.executeSql(
-        "insert into costHistory (cost, category, memo, date) values (?, ?, ?, ?);",
-        [cost, category, memo, date],
-        () => {
-          console.log("insert success");
-        }, // 成功時のコールバック関数
-        () => {
-          console.log("insert fail");
-          return true; // ロールバックする場合はtrueを返す
-        } // 失敗時のコールバック関数
-      );
-      tx.executeSql(
-        "select * from costHistory;",
-        [],
-        (_, resultSet: any) => {
-          setItems(resultSet);
-          console.log("select success");
-          for (let i = 0; i < resultSet.rows.length; i++) {
-            const id = resultSet.rows.item(i).id;
-            const name = resultSet.rows.item(i).name;
-            console.log(resultSet?.rows);
-            console.log(`${id}:${name}`);
-          }
-        },
-        () => {
-          console.log("select fail");
-          return false;
-        }
-      )
-    });
-    };
-  return (
-    //　略
-  );
-};
-const styles = StyleSheet.create({
-  // 略
-});
-```
-### 試したこと
-app.jsonにsdkVersionの追加
-```
-{
-  "expo": {
-    "name": "app",
-    "slug": "app",
-    "sdkVersion": "41.0.0",
-    "version": "1.0.0",
-    "orientation": "portrait",
-    "icon": "./assets/icon.png",
-    "splash": {
-      "image": "./assets/splash.png",
-      "resizeMode": "contain",
-      "backgroundColor": "#ffffff"
-    },
-    "updates": {
-      "fallbackToCacheTimeout": 0
-    },
-    "assetBundlePatterns": ["**/*"],
-    "ios": {
-      "supportsTablet": true
-    },
-    "android": {
-      "adaptiveIcon": {
-        "foregroundImage": "./assets/adaptive-icon.png",
-        "backgroundColor": "#FFFFFF"
-      }
-    },
-    "web": {
-      "favicon": "./assets/favicon.png"
-    }
-  }
 }