GetSqliteTableInfo get table info from sqlite
(dbFile string, tableName string)
| 9 | |
| 10 | // GetSqliteTableInfo get table info from sqlite |
| 11 | func GetSqliteTableInfo(dbFile string, tableName string) (string, error) { |
| 12 | db, err := sqlite.Init(dbFile) |
| 13 | if err != nil { |
| 14 | return "", err |
| 15 | } |
| 16 | defer sqlite.Close(db) //nolint |
| 17 | |
| 18 | var sqliteFields SqliteFields |
| 19 | sql := fmt.Sprintf("PRAGMA table_info('%s')", tableName) |
| 20 | err = db.Raw(sql).Scan(&sqliteFields).Error |
| 21 | if err != nil { |
| 22 | return "", err |
| 23 | } |
| 24 | |
| 25 | return convertToSQLBySqliteFields(tableName, sqliteFields), nil |
| 26 | } |
| 27 | |
| 28 | // SqliteField sqlite field struct |
| 29 | type SqliteField struct { |