| 7 | |
| 8 | // 数据库是否已经初始化（通过检测表 publicBookmarks 是否存在） |
| 9 | async function testDBInitialed() { |
| 10 | let sql = '' |
| 11 | if (process.env.DB_DRIVER === 'postgresql') { |
| 12 | sql = ` |
| 13 | SELECT * |
| 14 | FROM pg_catalog.pg_tables |
| 15 | WHERE schemaname = 'public' AND tablename = 'publicBookmarks';` |
| 16 | const res = await dbExecute(sql) |
| 17 | return res.length === 1 |
| 18 | } else if (process.env.DB_DRIVER === 'sqlite') { |
| 19 | sql = ` |
| 20 | SELECT name |
| 21 | FROM sqlite_master |
| 22 | WHERE type = 'table' |
| 23 | AND name = 'publicBookmarks';` |
| 24 | const res = await dbExecute(sql) |
| 25 | return res.rows.length === 1 |
| 26 | } |
| 27 | } |
| 28 | |
| 29 | await loadEnv() |
| 30 | |