parsesql.c

#include <libgda/libgda.h>
#include <sql-parser/gda-sql-parser.h>
#undef SQLITE_OMIT_BLOB_LITERAL

int
main (int argc, char *argv[])
{
  gda_init ();
  gchar *sql = "SELECT name FROM products where b=x'789c6b5d919398949a139f99b2c8dc6815849d97989bbac22d35b1a4b428b57835442c393f27bf68596a0a086e800895a4569440c58dc16055716952566a7209d0b003007a6d24d0'";
  GdaSqlParser *parser;
  GdaStatement *stmt;
  GdaSqlStatement *sqlst;

  parser = gda_sql_parser_new();

  stmt = gda_sql_parser_parse_string (parser, sql, NULL, NULL);
  g_object_get (G_OBJECT (stmt), "structure", &sqlst, NULL);

  GdaSqlAnyPart *part = GDA_SQL_ANY_PART (sqlst->contents);
  printf("type %d\n", part->type);
  switch(part->type) {
  case GDA_SQL_ANY_STMT_SELECT:
    printf("type is SELECT\n");
    break;
  case GDA_SQL_ANY_STMT_UNKNOWN:
    printf("type is unknown\n");
    break;
  }
}