Function TestGetTable

IceFireDB-SQLite/internal/sqlite/db_test.go:12–29

(t *testing.T)

)

func TestGetTable(t *testing.T) {
	sqlList := [][]string{
		{"select * from a", "a"},
		{"select * FROM a", "a"},
		{"select * FROM a where 1=1", "a"},
		{"select version()", ""},
		{"SELECT * FROM users WHERE id = 1", "users"},
		{"select count(*) from orders", "orders"},
		{"FROM products select *", "products"}, // This actually extracts "products"
		{"", ""},                               // Empty SQL
	}
	for _, sql := range sqlList {
		table := getTableName(sql[0])
		if table != sql[1] {
			t.Errorf("table name error, sql: %s, getTableName: %s, expected: %s", sql[0], table, sql[1])
		}
	}
}

func TestGetColumnTypeAndLen(t *testing.T) {
	testCases := []struct {