如何使用Expo在React Native中从DocumentPicker打开SQLite数据库

npm install -g expo-cli

expo init MyProject

cd MyProject
npm install expo-sqlite document-picker expo-permissions

import * as SQLite from 'expo-sqlite';

const db = SQLite.openDatabase('mydatabase.db');

import * as DocumentPicker from 'expo-document-picker';
import * as FileSystem from 'expo-file-system';

const pickDatabaseFile = async () => {
  const file = await DocumentPicker.getDocumentAsync({ type: 'application/x-sqlite3' });
  if (file.type === 'success') {
    const { uri } = file;
    const databaseName = 'mydatabase.db';
    const destination = `${FileSystem.documentDirectory}${databaseName}`;
    await FileSystem.copyAsync({ from: uri, to: destination });
    const db = SQLite.openDatabase(databaseName);
    // 在这里可以执行SQLite数据库的操作
  }
};

db.transaction(tx => {
  tx.executeSql(
    'CREATE TABLE IF NOT EXISTS items (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT);',
    [],
    (_, result) => {
      console.log('Table created successfully');
    },
    (_, error) => {
      console.log('Error creating table:', error);
    }
  );
});