Extract table name from select statement with joins about sqlparser

[raintean]

@Hassnain-Alvi

stmt, err := sqlparser.Parse(sql)
if err != nil {
    fmt.Println("Error: " + err.Error())
}
tableNames := make([]string, 0)
_ = sqlparser.Walk(func(node sqlparser.SQLNode) (kontinue bool, err error) {
    switch node := node.(type) {
    case sqlparser.TableName:
        tableNames = append(tableNames, node.Name.CompliantName())
    }
    return true, nil
}, stmt)
fmt.Println(tableNames)

[fengbeihong]

buffer:= sqlparser.NewTrackedBuffer(nil)
stmt.From.Format(buffer)
fmt.Println(buffer)

[prince612mittal]

hey @Hassnain-Alvi can u please help
I am new to sqlParser and I am not able to know its usage

[Hassnain-Alvi]

hey @Hassnain-Alvi can u please help
I am new to sqlParser and I am not able to know its usage

sure whats the problem you are facing ?

[prince612mittal]

hey @Hassnain-Alvi can u please help
I am new to sqlParser and I am not able to know its usage

sure whats the problem you are facing ?

I have started today only and I am unable to get through its documentation for parsing table name from simple expression

[prince612mittal]

@Hassnain-Alvi I am not even able to use ins.Table.name reference your above mentioned code it shows error

[sananguliyev]

@Hassnain-Alvi

stmt, err := sqlparser.Parse(sql)
if err != nil {
    fmt.Println("Error: " + err.Error())
}
tableNames := make([]string, 0)
_ = sqlparser.Walk(func(node sqlparser.SQLNode) (kontinue bool, err error) {
    switch node := node.(type) {
    case sqlparser.TableName:
        tableNames = append(tableNames, node.Name.CompliantName())
    }
    return true, nil
}, stmt)
fmt.Println(tableNames)

@raintean thanks for the solution but it's not valid if query has alias of the join or subquery. E.g. The result of this query select * from db.my_table as mt, (select * from db2.users) as u join db3.other_table ot on ot.user_id = u.id is [my_table users other_table ot u] which is not correct.