gen_stmt_type.py

stmttype='''
typedef enum EStmtType {
        sstunknown,sstinvalid,sstselect,sstdelete,sstupdate,
        sstinsert,sstcreatetable,sstcreateview,sstsqlpluscmd, sstcreatesequence,
        sstdropsequencestmt,sstdroptypestmt,sstplsql_packages,sstplsql_objecttype,sstcreate_plsql_procedure,
        sstcreate_plsql_function,sstcreate_varray_type,sstcreate_nested_table_type,sstcreateobjecttablestmt,sstplsql_block,
        sstplsql_createprocedure,sstplsql_createfunction,sstplsql_createpackage,sstplsql_createtrigger,sstplsql_createtype,
        sstplsql_createtypebody,sstplsql_tabletypedef,sstplsql_varraytypedef,sstplsql_createtype_placeholder,
        sstaltersession,sstcreateindex,sstdropindex,sstdropview,sstmerge,
        sstdroptable,sstaltertable,sstcommit,sstrollback,sstsavepoint,
        sstsettransaction,sstlocktable,sstmssqldummystmt,sstcreatedatabase,sstrevoke,
        sstTruncate,   sstcreatematerializedview,  sstcreatesynonym,
        sstmssqlcreateprocedure,sstmssqlcreatetrigger,sstmssqlcreatefunction,sstmssqlalterprocedure,sstmssqlaltertrigger,
        sstmssqlalterfunction,sstmssqlif,sstmssqlblock,sstmssqlgo,sstmssqldbcc,
        sstmssqlrestore,sstmssqlbackup,sstmssqlrevoke,sstmssqlreadtext,sstmssqlgrant,
        sstmssqltruncatetable,sstmssqladdsignature,sstmssqlalterapplicationrole,sstmssqlalterassembly,sstmssqlalterasymmetrickey,
        sstmssqlalterauthorization,sstmssqlaltercertificate,sstmssqlaltercredential,
        sstmssqlalterdatabase,sstmssqlcreatedatabase,
        sstmssqlalterendpoint,
        sstmssqlalterfulltextcatalog,sstmssqlalterfulltextindex,sstmssqlalterindex,sstmssqlalterlogin,sstmssqlaltermasterkey,
        sstmssqlaltermessagetype,sstmssqlalterpartitionfunction,sstmssqlalterpartitionscheme,sstmssqlalterqueue,sstmssqlalterremoteservicebinding,
        sstmssqlalterrole,sstmssqlalterroute,sstmssqlalterschema,sstmssqlalterservice,sstmssqlalterservicemasterkey,
        sstmssqlaltersymmetrickey,sstmssqlalteruser,sstmssqlalterview,sstmssqlalterxmlschemacollection,sstmssqlbackupdatabase,
        sstmssqlbackupcertificate,sstmssqlbackuplog,sstmssqlbackupmasterkey,sstmssqlbackupservicemasterkey,sstmssqlbeginconversationtimer,
        sstmssqlbegindialog,sstmssqlbegindistributed,sstmssqlbegintran,sstmssqlbreak,sstmssqlbulkinsert,
        sstmssqlclose,sstmssqlclosemasterkey,sstmssqlclosesymmetrickey,sstmssqlcontinue,sstmssqlcreateaggregate,
        sstmssqlcreateapplicationrole,sstmssqlcreateassembly,sstmssqlcreateasymmetrickey,sstmssqlcreatecertificate,sstmssqlcreatecontract,
        sstmssqlcreatecredential,sstmssqlcreatedefault,sstmssqlcreateendpoint,sstmssqlcreateeventnotification,sstmssqlcreatefulltextcatalog,
        sstmssqlcreatefulltextindex,sstmssqlcreatelogin,sstmssqlcreatemasterkey,sstmssqlcreatemessagetype,sstmssqlcreatepartitionfunction,
        sstmssqlcreatepartitionscheme,sstmssqlcreatequeue,sstmssqlcreateremoteservicebinding,sstmssqlcreaterole,sstmssqlcreateroute,
        sstmssqlcreaterule,sstmssqlcreateschema,sstmssqlcreateservice,sstmssqlcreatestatistics,sstmssqlcreatesymmetrickey,
        sstmssqlcreatesynonym,sstmssqlcreatetype,sstmssqlcreateuser,sstmssqlcreatexmlschemacollection,sstmssqldeallocate,
        sstmssqldeclare,sstmssqldeny,sstmssqldisabletrigger,sstmssqldropaggregate,sstmssqldropapplicationrole,
        sstmssqldropassembly,sstmssqldropasymmetrickey,sstmssqldropcertificate,sstmssqldropcontract,sstmssqldropcredential,
        sstmssqldropdatabase,sstmssqldropdefault,sstmssqldropendpoint,sstmssqldropeventnotification,sstmssqldropfulltextcatalog,
        sstmssqldropfulltextindex,sstmssqldropfunction,sstmssqldropdbobject,sstmssqldropindex,sstmssqldroplogin,
        sstmssqldropmasterkey,sstmssqldropmessagetype,sstmssqldroppartitionfunction,sstmssqldroppartitionscheme,sstmssqldropprocedure,
        sstmssqldropqueue,sstmssqldropremoteservicebinding,sstmssqldroprole,sstmssqldroproute,sstmssqldroprule,
        sstmssqldropschema,sstmssqldropservice,sstmssqldropsignature,sstmssqldropstatistics,sstmssqldropsymmetrickey,
        sstmssqldropsynonym,sstmssqldroptable,sstmssqldroptrigger,sstmssqldroptype,sstmssqldropuser,
        sstmssqldropview,sstmssqldropxmlschemacollection,sstmssqlenabletrigger,sstmssqlendconversation,sstmssqlexecuteas,
        sstmssqlfetch,sstmssqlgoto,sstmssqlkill,sstmssqlkillquerynotificationsubscription,sstmssqlkillstats,
        sstmssqlmoveconversation,sstmssqlopen,sstmssqlopenmasterkey,sstmssqlopensymmetrickey,sstmssqlprint,
        sstmssqlraiserror,sstmssqlreceive,sstmssqlreconfigure,sstmssqlrestoredatabase,sstmssqlrestorefilelistonly,
        sstmssqlrestoreheaderonly,sstmssqlrestorelabelonly,sstmssqlrestorelog,sstmssqlrestoremasterkey,sstmssqlrestorerewindonly,
        sstmssqlrestoreservicemasterkey,sstmssqlrestoreverifyonly,sstmssqlrevert,sstmssqlreturn,sstmssqlsavetran,
        sstmssqlselect,sstmssqlsendonconversation,sstmssqlset,sstmssqlsetuser,sstmssqlshutdown,
        sstmssqlsign,sstmssqlbegintry,sstmssqlbegincatch,sstmssqlupdatestatistics,sstmssqlupdatetext,
        sstmssqluse,sstmssqlwaitfor,sstmssqlwhile,sstmssqlcte,sstmssqlwithxmlnamespaces,
        sstmssqlwritetext,sstmssqlexec,sstexecutestmt,sstsetstmt,sstmssqlcommit,
        sstmssqlrollback,sstraiserror,sstmssqlwithas,sstmssqllabel,ssterrorstmt,
        sstmssqldrop,sstmssqlstmtstub,sstmssqlcheckpoint,
        sstoraclealtercluster,sstoraclealterdatabase,
        sstmssqlexecfake,
        sstoraclealterdimension,sstoraclealterdiskgroup,sstoraclealterfunction,sstoraclealterindex,sstoraclealterindextype,
        sstoraclealterjava,sstoraclealtermaterializedview,sstoraclealtermaterializedviewlog,sstoraclealteroperator,sstoraclealteroutline,
        sstoraclealterpackage,sstoraclealterprocedure,sstoraclealterprofile,sstoraclealterresourcecost,sstoraclealterrole,
        sstoraclealterrollbacksegment,sstoraclealtersequence,sstoraclealtersession,sstoraclealtersystem,sstoraclealtertablespace,
        sstoraclealtertrigger,sstoraclealtertype,sstoraclealteruser,sstoraclealterview,sstoracleanalyze,
        sstoracleassociatestatistics,sstoracleaudit,sstoraclecall,sstoraclecomment,sstoraclecommit,
        sstoraclecreatecluster,sstoraclecreatecontext,sstoraclecreatecontrolfile,sstoraclecreatedatabase,sstoraclecreatedatabaselink,
        sstoraclecreatedimension,sstoraclecreatedirectory,sstoraclecreatediskgroup,sstoraclecreatefunction,sstoraclecreateindex,
        sstoraclecreateindextype,sstoraclecreatejava,sstoraclecreatelibrary,sstoraclecreatematerializedview,sstoraclecreatematerializedviewlog,
        sstoraclecreateoperator,sstoraclecreateoutline,sstoraclecreatepackagebody,sstoraclecreatepfile,
        sstoraclecreateprocedure,sstoraclecreateprofile,sstoraclecreaterestorepoint,sstoraclecreaterole,sstoraclecreaterollbacksegment,
        sstoraclecreateschema,sstoraclecreatesequence,sstoraclecreatespfile,sstoraclecreatesynonym,sstoraclecreatetablespace,
        sstoraclecreatetrigger,sstoraclecreatetype, sstoraclecreateuser,sstoraclecreateview,
        sstoracledisassociatestatistics,sstoracledropcluster,sstoracledropcontext,sstoracledropdatabase,sstoracledropdatabaselink,
        sstoracledropdimension,sstoracledropdirectory,sstoracledropdiskgroup,sstoracledropfunction,sstoracledropindex,
        sstoracledropindextype,sstoracledropjava,sstoracledroplibrary,sstoracledropmaterializedview,sstoracledropmaterializedviewlog,
        sstoracledropoperator,sstoracledropoutline,sstoracledroppackage,sstoracledropprocedure,sstoracledropprofile,
        sstoracledroprestorepoint,sstoracledroprole,sstoracledroprollbacksegment,sstoracledropsequence,sstoracledropsynonym,
        sstoracledroptable,sstoracledroptablespace,sstoracledroptrigger,sstoracledroptype,sstoracledroptypebody,
        sstoracledropuser,sstoracledropview,sstoracleexplainplan,sstoracleflashbackdatabase,
        sstoracleflashbacktable,sstoraclegrant,sstoraclelocktable,sstoraclenoaudit,sstoraclepurge,
        sstoraclerename,sstoraclerevoke,sstoraclerollback,sstoraclesavepoint,sstoraclesetconstraint,
        sstoraclesetrole,sstoraclesettransaction,sstoracletruncate,
        sstmysqlalterdatabase,sstmysqlalterfunction,
        sstmysqlalterprocedure,sstmysqlalterview,sstmysqlanalyzetable,sstmysqlbackuptable,sstmysqlcacheindex,
        sstmysqlcall,sstmysqlcase,sstmysqlchangemasterto,sstmysqlchecktable,sstmysqlchecksumtable,
        sstmysqlclose,sstmysqlcommit,sstmysqlcreatedatabase,sstmysqlcreateindex,sstmysqlcreatefunction,
        sstmysqlcreateprocedure,sstmysqlcreatetrigger,sstmysqlcreateuser,sstmysqlcreateview,sstmysqldeclare,
        sstmysqldescribe,sstmysqldo,sstmysqldropdatabase,sstmysqldropfunction,sstmysqldropindex,
        sstmysqldropprocedure,sstmysqldroptable,sstmysqldroptrigger,sstmysqldropuser,sstmysqldropview,
        sstmysqlexecute,sstmysqlfetch,sstmysqlflush,sstmysqlgrant,sstmysqlhandler,
        sstmysqlif,sstmysqliterate,sstmysqlkill,sstmysqlleave,sstmysqlloaddatainfile,
        sstmysqlloaddatafrommaster,sstmysqlloadindexintocache,sstmysqlloadtable,sstmysqllocktable,sstmysqlloop,
        sstmysqlopen,sstmysqloptimizetable,sstmysqldeallocateprepare,sstmysqldropprepare,sstmysqlprepare,
        sstmysqlpurgelogs,sstmysqlrepeat,sstmysqlreplace,sstmysqlrenametable,sstmysqlrepairtable,
        sstmysqlreleasesavepoint,sstmysqlrenameuser,sstmysqlrest,sstmysqlresetmaster,sstmysqlresetslave,
        sstmysqlrestoretable,sstmysqlrevoke,sstmysqlrollback,sstmysqlsavepoint,sstmysqlreset,
        sstmysqlset,sstmysqlsetautocommit,sstmysqlsettransaction,sstmysqlsetpassword,sstmysqlshowcreatedatabase,
        sstmysqlshowcharacterset,sstmysqlshowcollation,sstmysqlshowcolumns,sstmysqlshowcreatetable,sstmysqlshowcreateview,
        sstmysqlshowcreatefunction,sstmysqlshowcreateprocedure,sstmysqlshowdatabases,sstmysqlshowengines,sstmysqlshowerrors,
        sstmysqlshowgrants,sstmysqlshowfunctionstatus,sstmysqlshowindex,sstmysqlshowinnodbstatus,sstmysqlshowlogs,
        sstmysqlshowprivileges,sstmysqlshowprocesslist,sstmysqlshowstatus,sstmysqlshowtablestatus,sstmysqlshowtables,
        sstmysqlshowtriggers,sstmysqlshowvariables,sstmysqlshowwarnings,sstmysqlshowbinlogevents,sstmysqlshowmasterlogs,
        sstmysqlshowmasterstatus,sstmysqlshowslavehosts,sstmysqlshowslavestatus,sstmysqlstartslave,sstmysqlstarttransaction,
        sstmysqlsetglobalsql_slave_skip_counter,sstmysqlsetsql_log_bin,sstmysqlstopslave,sstmysqltruncate,sstmysqlunlocktable,
        sstmysqluse,sstmysqlwhile,sstmysqlshow,sstmysqlreturn,sstmysqlrepeatstmt,
        sstmysqlwhilestmt,sstmysqlopencursor,sstmysqlfetchcursor,sstmysqlcasestmt,sstmysqlifstmt,
        sstmysqlloopstmt,sstmysqlstmtstub, sstmysqlblock,
        sstdb2allocatecursor,sstdb2alterbufferpool,sstdb2alterdatabasepartitiongroup,sstdb2alterfunction,
        sstdb2altermethod,sstdb2alternickname,sstdb2alterprocedure,sstdb2altersequence,sstdb2alterserver,
        sstdb2altertable,sstdb2altertablespace,sstdb2altertype,sstdb2alterusermapping,sstdb2alterview,
        sstdb2alterwrapper,sstdb2associatelocators,sstdb2begindeclaresection,sstdb2call,sstdb2case,
        sstdb2close,sstdb2comment,sstdb2commit,sstdb2connect,sstdb2createalias,
        sstdb2createbufferpool,sstdb2createdatabasepartitiongroup,sstdb2createdistincttype,sstdb2createeventmonitor,sstdb2createfunction,
        sstdb2createfunctionmapping,sstdb2createindex,sstdb2createindexextension,sstdb2createmethod,sstdb2createnickname,
        sstdb2createprocedure,sstdb2createschema,sstdb2createsequence,sstdb2createserver,sstdb2createtablespace,
        sstdb2createtransform,sstdb2createtrigger,sstdb2createtype,sstdb2createtypemapping,sstdb2createusermapping,
        sstdb2createwrapper,sstdb2declarecursor,sstdb2declareglobaltemporarytable,sstdb2describe,sstdb2disconnect,
        sstdb2drop,sstdb2echo,
        sstdb2enddeclaresection,sstdb2execute,sstdb2executeimmediate,sstdb2explain,
        sstdb2fetch,sstdb2flusheventmonitor,sstdb2flushpackagecache,sstdb2for,sstdb2freelocator,
        sstdb2getdiagnostics,sstdb2goto,sstdb2grant,sstdb2if,sstdb2include,
        sstdb2iterate,sstdb2leave,sstdb2locktable,sstdb2loop,sstdb2open,
        sstdb2prepare,sstdb2refreshtable,sstdb2release,sstdb2releasesavepoint,sstdb2rename,
        sstdb2renametablespace,sstdb2repeat,sstdb2resignal,sstdb2return,sstdb2revoke,
        sstdb2rollback,sstdb2savepoint,sstdb2setconnection,sstdb2setcurrentdefaulttransformgroup,sstdb2setcurrentdegree,
        sstdb2setcurrentexplainmode,sstdb2setcurrentexplainsnapshot,sstdb2setcurrentisolation,sstdb2setcurrentlocktimeout,sstdb2setcurrentmaintainedtabletypesforoptimization,
        sstdb2setcurrentpackagepath,sstdb2setcurrentpackageset,sstdb2setcurrentqueryoptimization,sstdb2setcurrentrefreshage,sstdb2setencryptionpassword,
        sstdb2seteventmonitorstate,sstdb2setintegrity,sstdb2setpassthru,sstdb2setpath,sstdb2setschema,
        sstdb2setserveroption,sstdb2setsessionauthorization,sstdb2set,sstdb2terminate,sstdb2signal,
        sstdb2values,sstdb2whenever,sstdb2while,sstdb2sqlvariabledeclaration,sstdb2conditiondeclaration,
        sstdb2returncodesdeclaration,sstdb2statementdeclaration,sstdb2declarecursorstatement,sstdb2handlerdeclaration,sstdb2sqlprocedurestatement,
        sstdb2callstmt,sstdb2forstmt,sstdb2ifstmt,sstdb2iteratestmt,sstdb2leavestmt,
        sstdb2signalstatement,sstdb2whilestmt,sstdb2repeatstmt,sstdb2closecursorstmt,sstdb2opencursorstmt,
        sstdb2fetchcursorstmt,sstdb2gotostmt,sstdb2loopstmt,sstdb2casestmt,sstdb2procedurecompoundstatement,
        sstdb2dynamiccompoundstatement,sstdb2returnstmt,sstdb2dummystmt,sstdb2valuesinto,
        sstdb2stmtstub,sstdb2declare,
        sstplsql_assignstmt,
        sstplsql_casestmt,sstplsql_closestmt,sstplsql_cursordecl,sstplsql_dummystmt,sstplsql_elsifstmt,
        sstplsql_execimmestmt,sstplsql_exitstmt,sstplsql_fetchstmt,sstplsql_forallstmt,sstplsql_gotostmt,
        sstplsql_ifstmt,sstplsql_loopstmt,sstplsql_nullstmt,sstplsql_openforstmt,sstplsql_openstmt,
        sstplsql_pragmadecl,sstplsql_procbasicstmt,sstplsql_procedurespec,sstplsql_raisestmt,sstplsql_recordtypedef,
        sstplsql_returnstmt,sstplsql_sqlstmt,sstplsql_proceduredecl,sstplsql_vardecl,
        sstplsql_piperowstmt, 
        sstsybaselocktable,
        sstmdxunknown,sstmdxselect,sstmdxupdate,sstmdxalterdimension,
        sstmdxcall,sstmdxclearcalculations,sstmdxdrillthrough,sstmdxaltercube,sstmdxcreateaction,
        sstmdxcreatecellcalculation,sstmdxcreatedimensionmember,sstmdxcreateglobalcube,sstmdxcreatemember,sstmdxcreatesessioncube,
        sstmdxcreateset,sstmdxcreatesubcube,sstmdxdropaction,sstmdxdropcellcalculation,sstmdxdropdimensionmember,
        sstmdxdropmember,sstmdxdropset,sstmdxdropsubcube,sstmdxrefreshcube,sstmdxcalculate,
        sstmdxcase,sstmdxexisting,sstmdxfreeze,sstmdxif, sstmdxscope,sstmdxexpression,
        sstteradataabort,sstteradataalterfunction,sstteradataaltermethod,sstteradataalterprocedure,
        sstteradataalterreplicationgroup,sstteradataaltertable,sstteradataaltertrigger,
        sstteradataaltertype,sstteradatabegindeclaresection,
        sstteradatabeginlogging,sstteradatabeginquerylogging,sstteradatabegintransaction,
        sstteradatacall,
        sstteradatacheckpoint,sstteradataclose,
        sstteradatacollectdemographics,sstteradatacollectstatistics,
        sstteradatacomment,sstteradatacommit,sstteradataconnect,
        sstteradatacreatecast,
        sstteradatacreateauthorization,
        sstteradatacreatedatabase,sstteradatacreatefunction,sstteradatacreateindex,
        sstteradatacreatemacro, sstteradatacreatemethod,sstteradatacreateordering,
        sstteradatacreateprocedure,sstteradatacreateprofile,
        sstteradatacreatereplicationgroup,sstteradatacreaterole,sstteradatacreatetransform,
        sstteradatacreatetrigger,sstteradatacreatetype,
        sstteradatacreateuser,sstteradatadatabase,sstteradatadeclarecursor,sstteradatadeclarestatement,
        sstteradatadeclaretable,sstteradatadeletedatabase,sstteradatadeleteuser,sstteradatadescribe,
        sstteradatadiagnostic,sstteradatadropauthorization,sstteradatadropdatabase,
        sstteradatadropdbobject,
        sstteradatadropfunction,
        sstteradatadropuser,
        sstteradatadropcast,sstteradatadropmacro,sstteradatadropordering,sstteradatadropprocedure,
        sstteradatadropprofile,sstteradatadropreplicationgroup,sstteradatadroprole,
        sstteradatadropstatistics,sstteradatadroptransform,sstteradatadroptrigger,sstteradatadroptype,
        sstteradatadumpexplain,sstteradataecho,sstteradataenddeclaresection,sstteradataendlogging,
        sstteradataendquerylogging,sstteradataendtransaction,sstteradataexecute,sstteradataexecuteimmediate,
        sstteradatafetch, 
        sstteradatagetcrash,sstteradatagive,sstteradatagrant,sstteradatagrantlogon,sstteradatagrantmonitor,
        sstteradatahelp,sstteradatainclude,sstteradataincludesqlca,sstteradatasqlda,sstteradatainitiateindexanalysis,
        sstteradatainsertexplain,sstteradatalogoff,sstteradatalogon,sstteradatamodifydatabase,
        sstteradatamodifyprofile,sstteradatamodifyuser,sstteradataopen,sstteradataposition,
        sstteradataprepare,
        sstteradatarenamefunction,sstteradatarenamemacro,
        sstteradatarenameprocedure,sstteradatarenametable,sstteradatarenametrigger,sstteradatarenameview,
        sstteradatareplacecast,
        sstteradatareplacefunction,sstteradatareplacemacro,sstteradatareplacemethod,
        sstteradatareplaceordering,
        sstteradatareplaceprocedure,sstteradatareplacetransform,sstteradatareplacetrigger,sstteradatareplaceview,
        sstteradatarestartindexanalysis,sstteradatarevoke,sstteradatarevokelogon,sstteradatarevokemonitor,
        sstteradatarevokerole,sstteradatarewind,sstteradatarollback,sstteradatasetbuffersize,
        sstteradatasetcharset,sstteradatasetconnection,sstteradatasetcrash,sstteradatasetrole,
        sstteradatasetsessionaccount,
        sstteradatasetsession,sstteradatasettimezone,sstteradatashow,sstteradatashowfunction,
        sstteradatashowindex,sstteradatashowmacro,sstteradatashowmethod,sstteradatashowprocedure,
        sstteradatashowreplicationgroup,sstteradatashowtable,sstteradatashowtrigger,
        sstteradatashowtype,sstteradatashowview,
        sstteradatatest,sstteradatawait,sstteradatawhenever,sstteradataasync,sstteradataexplain,
        sstteradatausing,sstteradatanotimplement,
        sstblockstmt , sststoredprocedurestmt,sstoraclestoredprocedurestmt,
        sstpostgresqlabort,sstpostgresqlAlterAggregate,sstpostgresqlAlterCollation,
        sstpostgresqlAlterConversion,sstpostgresqlalterdatabase,
        sstpostgresqlAlterDefaultPrivileges,sstpostgresqlAlterDomain , sstpostgresqlAlterExtension,
        sstpostgresqlAlterForeignDataWrapper,sstpostgresqlAlterForeignTable,
        sstpostgresqlAlterfunction, sstpostgresqlAlterGroup,sstpostgresqlAlterIndex,
        sstpostgresqlAlterLanguage, sstpostgresqlAlterLargeObject,sstpostgresqlAlterOperator,
        sstpostgresqlAlterOperatorClass,sstpostgresqlAlterOperatorFamily,sstpostgresqlAlterRole,
        sstpostgresqlAlterSchema,sstpostgresqlAlterSequence,sstpostgresqlAlterServer,
        sstpostgresqlAlterTablespace, sstpostgresqlAlterTextSearchConfiguration,
        sstpostgresqlAlterTextSearchDictionary,sstpostgresqlAlterTextSearchParser,
        sstpostgresqlAlterTextSearchTemplate,sstpostgresqlAlterTrigger,
        sstpostgresqlAlterType,sstpostgresqlAlterUser,sstpostgresqlAlterUserMapping,
        sstpostgresqlAlterView,sstpostgresqlAnalyze,sstpostgresqlBegin,sstpostgresqlCheckpoint,
        sstpostgresqlClose,sstpostgresqlCluster,sstpostgresqlComment,sstpostgresqlCommit,
        sstpostgresqlCommitPrepared,sstpostgresqlCopy,
        sstpostgresqlCreateAggregate,sstpostgresqlCreateCast,sstpostgresqlCreateCollation,
        sstpostgresqlConversion,sstpostgresqlCreateDatabase,sstpostgresqlCreateDomain,
        sstpostgresqlCreateExtension,sstpostgresqlCreateForeignDataWrapper,sstpostgresqlCreateForeignTable,
        sstpostgresqlCeateFunction,sstpostgresqlCeateGroup,sstpostgresqlCreateIndex,sstpostgresqlCreateLanguage,
        sstpostgresqlCreateOperator,sstpostgresqlCreateOperatorFimaly,sstpostgresqlCreateOperatorClass,
        sstpostgresqlCreateRole,sstpostgresqlCreateRule,sstpostgresqlCreateSchema,
        sstpostgresqlCreateSequence,sstpostgresqlCreateServer,sstpostgresqlCreateTablespace,
        sstpostgresqlCreateTextSearchConfiguration,sstpostgresqlCreateTextSearchDictionary,
        sstpostgresqlCreateTextSearchParser,sstpostgresqlCreateTextSearchTemplate,
        sstpostgresqlCreateTrigger,sstpostgresqlCreateType,sstpostgresqlCreateUser,
        sstpostgresqlCreateUserMapping,sstpostgresqlCreateView,sstpostgresqlDeallocate,
        sstpostgresqlDeclare,sstpostgresqlDiscard,sstpostgresqlDo,sstpostgresqlDropAggregate,
        sstpostgresqlDropCast,sstpostgresqlDropCollation,sstpostgresqlDropConversion,
        sstpostgresqlDropDatabase,sstpostgresqlDropDomain,sstpostgresqlDropExtension,
        sstpostgresqlDropForeignDataWrapper,sstpostgresqlDropForeignTable,sstpostgresqlDropFunction,
        sstpostgresqlDropGroup,sstpostgresqlDropLanguage,sstpostgresqlDropOperator,
        sstpostgresqlDropOperatorClass,sstpostgresqlDropOperatorFamily,sstpostgresqlDropOwned,
        sstpostgresqlDropRole,sstpostgresqlDropRule,sstpostgresqlDropSchema,sstpostgresqlDropSequence,
        sstpostgresqlDropServer,sstpostgresqlDropTable,sstpostgresqlDropTablespace,sstpostgresqlDropTextSearchConfiguration,
        sstpostgresqlDropTextSearchDictionary,sstpostgresqlDropTextSearchParser,sstpostgresqlDropTextSearchTemplate,
        sstpostgresqlDropTrigger,sstpostgresqlDropType,sstpostgresqlDropUser,sstpostgresqlDropUserMapping,
        sstpostgresqlDropView,sstpostgresqlEnd,sstpostgresqlExecute,sstpostgresqlExplain,sstpostgresqlFetch,
        sstpostgresqlGrant,sstpostgresqlListen,sstpostgresqlLoad,sstpostgresqlLock,sstpostgresqlMove,
        sstpostgresqlNotify,sstpostgresqlPrepare,sstpostgresqlPrepareTransaction,sstpostgresqlReassignOwned,
        sstpostgresqlReindex,sstpostgresqlReleaseSavepoint,sstpostgresqlReset,sstpostgresqlRevoke,
        sstpostgresqlRollback,sstpostgresqlRollbackPrepared,sstpostgresqlSavepoint,sstpostgresqlSecurityLabel,
        sstpostgresqlSet,sstpostgresqlSetConstraints,sstpostgresqlSetRole,sstpostgresqlSetSessionAuthorization,
        sstpostgresqlSetTransaction,sstpostgresqlTruncate,sstpostgresqlUnlisten,sstpostgresqlValues,
        sstnetezzaAlterDatabase,sstnetezzaAlterGroup,sstnetezzaAlterHistoryConfiguration,
        sstnetezzaAlterSequence,sstnetezzaAlterSynonym,
        sstnetezzaAlterTable,sstnetezzaAlterUser,sstnetezzaAlterView,
        sstnetezzaBegin,sstnetezzaComment,sstnetezzaCommit,sstnetezzaCopy,
        sstnetezzaCreateExternalTable,sstnetezzaCreateGruop,
        sstnetezzaCreateHistoryConfiguration,
        sstnetezzaCreateUser,
        sstnetezzaDropConnection,sstnetezzaDropDatabase,
        sstnetezzaDropGroup,sstnetezzaDropHistoryConfiguration,sstnetezzaDropSequence,
        sstnetezzaDropSession,sstnetezzaDropSynonym,sstnetezzaDropTable,sstnetezzaDropUser,
        sstnetezzaDropView,sstnetezzaExplain,sstnetezzaGenerateExpressStatistics,
        sstnetezzaGenerateStatistics,sstnetezzaGrant,sstnetezzaGroomTable,sstnetezzaReset,
        sstnetezzaRevoke,sstnetezzaRollback,sstnetezzaSet,
        sstnetezzaShow,
    sstinformixAllocateCollection,
    sstinformixAllocateDescriptor,
    sstinformixAlterAccess_Method,
    sstinformixAlterFragment, 
    sstinformixAlterFunction, 
    sstinformixAlterIndex, 
    sstinformixAlterProcedure, 
    sstinformixAlterRoutine, 
    sstinformixAlterSecurityLabelComponent, 
    sstinformixAlterSequence, 
    sstinformixAlterTable, 
    sstinformixAlterTrustedContext, 
    sstinformixAlterUser, 
    sstinformixBegin, 
    sstinformixClose, 
    sstinformixCloseDatabase, 
    sstinformixCommit, 
    sstinformixConnect, 
    sstinformixCreateAccess_Method, 
    sstinformixCreateAggregate, 
    sstinformixCreateCast, 
    sstinformixCreateIndex,
    sstinformixCreateDatabase, 
    sstinformixCreateFunction, 
    
    sstinformixCreateDefaultUser,
    sstinformixCreateDistinctType, 
    sstinformixCreateExternalTable,
    
    sstinformixCreateFunctionFrom,
    
    sstinformixCreateOpaqueType, 
    sstinformixCreateOpclass, 
    
    sstinformixCreateProcedure, 
    sstinformixCreateProcedureFrom, 
    sstinformixAlterTrigger,
    
    sstinformixCreateRole, 
    sstinformixCreateRoutineFrom,
    sstinformixCreateRowType, 
    sstinformixCreateSchema, 
    sstinformixCreateSecurityLabel,
    sstinformixCreateSecurityLabelComponent,
    sstinformixCreateSecurityPolicy, 
    sstinformixCreateSequence, 
    
    sstinformixCreateSynonym, 
    sstinformixCreateTempTable, 
    sstinformixCreateTrigger, 
    sstinformixCreateTrustedContext, 
    sstinformixCreateUser, 
    sstinformixCreateView, 
    sstinformixCreateXaDatasource, 
    sstinformixCreateXaDatasourceType, 
    sstinformixDatabase, 
    sstinformixDeallocateCollection,
    sstinformixDeallocateDescriptor,
    sstinformixDeallocateRow, 
    sstinformixDeclare, 
    sstinformixDescribe,
    sstinformixDescribeInput, 
    sstinformixDisconnect, 
    sstinformixDropAccess_Method,
    sstinformixDropAggregate, 
    sstinformixDropCast, 
    sstinformixDropDatabase, 
    sstinformixDropFunction, 
    sstinformixDropIndex, 
    sstinformixDropOpclass,
    sstinformixDropProcedure,
    sstinformixDropRole,
    sstinformixDropRoutine, 
    sstinformixDropRowType, 
    sstinformixDropSecurity,
    sstinformixDropSequence,
    sstinformixDropSynonym, 
    sstinformixDropTable, 
    sstinformixDropTrigger,
    sstinformixDropTrustedContext,
    sstinformixDropType, 
    sstinformixDropUser, 
    sstinformixDropView, 
    sstinformixDropXaDatasource,
    sstinformixDropXaDatasourceType,
    sstinformixExecute, 
    
    sstinformixExecuteFunction, 
    sstinformixExecuteImmediate,
    sstinformixExecuteProcedure,
    sstinformixFetch, 
    sstinformixFlush, 
    sstinformixFree, 
    sstinformixGetDescriptor, 
    sstinformixGetDiagnostics,
    sstinformixGrant,
    sstinformixGrantFragment, 
    sstinformixInfo, 
    
    sstinformixLoad, 
    sstinformixLockTable, 
    sstinformixOpen,
    sstinformixOutput,
    sstinformixPrepare, 
    sstinformixPut, 
    sstinformixReleaseSavepoint, 
    sstinformixRenameColumn, 
    sstinformixRenameDatabase,
    sstinformixRenameIndex, 
    sstinformixRenameSecurity,
    sstinformixRenameSequence,
    sstinformixRenameTable, 
    sstinformixRenameTrustedContext,
    sstinformixRenameUser,
    sstinformixRevoke,
    sstinformixRevokeFragment, 
    sstinformixRollbackWork, 
    sstinformixSaveExternalDirectives, 
    sstinformixSavepoint, 
    sstinformixSetAutofree,
    sstinformixSetCollation, 
    sstinformixSetConnection,
    sstinformixSetConstraints,
    sstinformixSetDatabaseObject, 
    sstinformixSetDataskip,
    sstinformixSetDebugFile,
    sstinformixSetDeferred_Prepare, 
    sstinformixSetDescriptor, 
    sstinformixSetEncryptionPassword, 
    sstinformixSetEnvironment, 
    sstinformixSetExplain, 
    sstinformixSetIndexes, 
    sstinformixSetIsolation,
    sstinformixSetLockMode, 
    sstinformixSetLog, 
    sstinformixSetOptimization,
    sstinformixSetPDQPriority, 
    sstinformixSetRole, 
    sstinformixSetSessionAuthorization, 
    sstinformixSetStatementCache, 
    sstinformixSetTransaction, 
    sstinformixSetTransactionMode,
    sstinformixSetTriggers, 
    sstinformixSetUserPassword,
    sstinformixStartViolationsTable,
    sstinformixStopViolationsTable, 
    sstinformixUnload,
    sstinformixUnlockTable, 
    sstinformixUpdateStatistics, 
    sstinformixWhenever
    }EStmtType;
'''

nodetype = '''
typedef enum ENodeType
{
    t_gsp_invalid,
    t_gsp_dummy,
    t_gsp_join,
    t_gsp_joinItem,
    t_gsp_sql_statement,
    t_gsp_selectStatement,
    t_gsp_insertStatement,
    t_gsp_deleteStatement,
    t_gsp_updateStatement,
    t_gsp_createTableStatement,
    t_gsp_createIndexStatement,
    t_gsp_createViewStatement,
    t_gsp_unknownStatement,
    t_gsp_dropTableStatement,
    t_gsp_dropIndexStatement,
    t_gsp_dropViewStatement,
    t_gsp_dropDatabaseStatement,
    t_gsp_alterDatabaseStatement,
    t_gsp_createDatabaseStatement,
    t_gsp_createSequenceStatement,
    t_gsp_createSynonymStatement,
    t_gsp_createDirectoryStatement,
    t_gsp_alterTableStatement,
    t_gsp_mergeStatement,
    t_gsp_createPackageStatement,
    t_gsp_createProcedureStatement,
    t_gsp_createFunctionStatement,
    t_gsp_blockStatement,
    t_gsp_createTriggerStatement,
    t_gsp_trigger_event,
    t_gsp_arrayAccess,
    t_gsp_valueClause,
    t_gsp_constant,
    t_gsp_list,
    t_gsp_listcell,
    t_gsp_objectAccess,
    t_gsp_objectname ,
    t_gsp_expr,
    t_gsp_resultColumn,
    t_gsp_aliasClause,
    t_gsp_functionCall,
    t_gsp_keepDenseRankClause,
    t_gsp_analyticFunction,
    t_gsp_whenClauseItem,
    t_gsp_caseExpression,
    t_gsp_intervalExpression,
    t_gsp_trimArgument,
    t_gsp_typename,
    t_gsp_precisionScale,
    t_gsp_keyReference,
    t_gsp_keyAction,
    t_gsp_constraint,
    t_gsp_mergeInsertClause,
    t_gsp_mergeUpdateClause,
    t_gsp_mergeDeleteClause,
    t_gsp_mergeWhenClause,
    t_gsp_fromTable,
    t_gsp_multiTarget,
    t_gsp_insertRest,
    t_gsp_insertValuesClause,
    t_gsp_mergeSqlNode,
    t_gsp_alterTableOption,
    t_gsp_alterTableSqlNode,
    t_gsp_createSequenceSqlNode,
    t_gsp_createSynonymSqlNode,
    t_gsp_createDirectorySqlNode,
    t_gsp_dropViewSqlNode,
    t_gsp_dropIndexSqlNode,
    t_gsp_dropTableSqlNode,
    t_gsp_dropDatabaseSqlNode,
    t_gsp_alterDatabaseSqlNode,
    t_gsp_viewAliasItem,
    t_gsp_viewAliasClause,
    t_gsp_createViewSqlNode,
    t_gsp_createMaterializedViewSqlNode,
    t_gsp_createMaterializedViewLogSqlNode,
    t_gsp_orderByItem,
    t_gsp_createIndexSqlNode,
    t_gsp_columnDefinition,
    t_gsp_tableElement,
    t_gsp_table,
    t_gsp_createTableSqlNode,
    t_gsp_returningClause,
    t_gsp_selectSqlNode,
    t_gsp_deleteSqlNode,
    t_gsp_updateSqlNode,
    t_gsp_insertIntoValue,
    t_gsp_insertCondition,
    t_gsp_insertSqlNode,
    t_gsp_whereClause,
    t_gsp_joinExpr,
    t_gsp_tableSamplePart,
    t_gsp_tableSample,
    t_gsp_pxGranule,
    t_gsp_flashback,
    t_gsp_forUpdate,
    t_gsp_groupingSetItem,
    t_gsp_groupingSet,
    t_gsp_rollupCube,
    t_gsp_gruopByItem,
    t_gsp_groupBy,
    t_gsp_orderBy,
    t_gsp_selectDistinct,
    t_gsp_hierarchical,
    t_gsp_intoClause,
    t_gsp_cte,
    t_gsp_commentSqlNode,
    t_gsp_plsqlCreateTypeBody,
    t_gsp_callSpec,
    t_gsp_typeAttribute,
    t_gsp_plsqlCreateType,
    t_gsp_dmlEventClause,
    t_gsp_nonDmlTriggerClause,
    t_gsp_compoundDmlTriggerClause,
    t_gsp_simpleDmlTriggerClause,
    t_gsp_createTriggerSqlNode,
    t_gsp_createPackageSqlNode,
    t_gsp_plsqlVarDeclStmt,
    t_gsp_createFunctionSqlNode,
    t_gsp_parameterDeclaration,
    t_gsp_createProcedureSqlNode,
    t_gsp_plsqlReturnStmt,
    t_gsp_plsqlRaiseStmt,
    t_gsp_plsqlLoopStmt,
    t_gsp_plsqlCaseStmt,
    t_gsp_plsqlForallStmt,
    t_gsp_plsqlElsifStmt,
    t_gsp_plsqlIfStmt,
    t_gsp_plsqlGotoStmt,
    t_gsp_plsqlExitStmt,
    t_gsp_plsqlAssignStmt,
    t_gsp_plsqlCursorDeclStmt,
    t_gsp_plsqlRecordTypeDefStmt,
    t_gsp_plsqlVarrayTypeDefStmt,
    t_gsp_plsqlTableTypeDefStmt,
    t_gsp_plsqlNullStmt,
    t_gsp_plsqlFetchStmt,
    t_gsp_plsqlPipeRowStmt,
    t_gsp_plsqlOpenforStmt,
    t_gsp_plsqlOpenStmt,
    t_gsp_plsqlCloseStmt,
    t_gsp_plsqlBasicStmt,
    t_gsp_blockSqlNode,
    t_gsp_bindArgument,
    t_gsp_execImmeNode,
    t_gsp_exceptionHandler,
    t_gsp_exceptionClause,
    t_gsp_fetchFirstClause,
    t_gsp_optimizeForClause,
    t_gsp_isolationClause,
    t_gsp_valueRowItem,
    t_gsp_dataChangeTable,
    t_gsp_includeColumns,
    t_gsp_db2_signal,
    t_gsp_db2_compoundSqlNode,
    t_gsp_db2_triggerAction,
    t_gsp_db2_callStmtSqlNode,
    t_gsp_db2_forSqlNode,
    t_gsp_db2_ifSqlNode,
    t_gsp_db2_elseIfSqlNode,
    t_gsp_db2_iterateStmtSqlNode,
    t_gsp_db2_leaveStmtSqlNode,
    t_gsp_db2_setSqlNode,
    t_gsp_db2_whileSqlNode,
    t_gsp_db2_repeatSqlNode,
    t_gsp_db2_gotoSqlNode,
    t_gsp_db2_loopSqlNode,
    t_gsp_returnSqlNode,
    t_gsp_continueSqlNode,
    t_gsp_breakSqlNode,
    t_gsp_grantSqlNode,
    t_gsp_fetchSqlNode,
    t_gsp_openSqlNode,
    t_gsp_closeSqlNode,
    t_gsp_mssql_executeAsSqlNode,
    t_gsp_mssql_executeSqlNode,
    t_gsp_mssql_execParameter,
    t_gsp_mssql_dropDbObjectSqlNode,
    t_gsp_dropIndexItem,
    t_gsp_truncateTableSqlNode,
    t_gsp_mssql_setSqlNode,
    t_gsp_mssql_beginTranSqlNode,
    t_gsp_mssql_raiserrorSqlNode,
    t_gsp_mssql_gotoSqlNode,
    t_gsp_mssql_labelSqlNode,
    t_gsp_mssql_killSqlNode,
    t_gsp_mssql_deallocateSqlNode,
    t_gsp_declareSqlNode,
    t_gsp_declareVariable,
    t_gsp_mssql_beginDialogSqlNode,
    t_gsp_mssql_sendOnConversationSqlNode,
    t_gsp_mssql_endConversationSqlNode,
    t_gsp_mssql_revertSqlNode,
    t_gsp_mssql_goSqlNode,
    t_gsp_mssql_useSqlNode,
    t_gsp_mssql_printSqlNode,
    t_gsp_ifSqlNode,
    t_gsp_elseIfSqlNode,
    t_gsp_createTriggerUpdateColumn,
    t_gsp_whileSqlNode,
    t_gsp_mssql_computeClause,
    t_gsp_mssql_computeClauseItem,
    t_gsp_mssql_computeExpr,
    t_gsp_topClause,
    t_gsp_mssql_containsTable,
    t_gsp_mssql_tableHint,
    t_gsp_mssql_freeTable,
    t_gsp_mssql_openXML,
    t_gsp_mssql_openRowSet,
    t_gsp_pivotClause,
    t_gsp_unPivotClause,
    t_gsp_mssql_bulkInsertSqlNode,
    t_gsp_mssql_openQuery,
    t_gsp_mssql_openDatasource,
    t_gsp_mssql_outputClause,
    t_gsp_mssql_updateTextSqlNode,
    t_gsp_commitSqlNode,
    t_gsp_rollbackSqlNode,
    t_gsp_saveTransSqlNode,
    t_gsp_renameColumnSqlNode,
    t_gsp_renameSequenceSqlNode,
    t_gsp_renameTableSqlNode,
    t_gsp_renameIndexSqlNode,
    t_gsp_dropSequenceSqlNode,
    t_gsp_dropSynonymSqlNode,
    t_gsp_dropRowTypeSqlNode,
    t_gsp_alterIndexSqlNode,
    t_gsp_alterIndexStatement,
    t_gsp_intoTableClause,
    t_gsp_informixOuterClause,
    t_gsp_createRowTypeSqlNode,
    t_gsp_subscripts,
    t_gsp_limitClause,
    t_gsp_callSqlNode,
    t_gsp_createDatabaseSqlNode,
    t_gsp_iterateSqlNode,
    t_gsp_leaveSqlNode,
    t_gsp_repeatSqlNode,
    t_gsp_loopSqlNode,
    t_gsp_revokeSqlNode,
    t_gsp_executeSqlNode,
    t_gsp_dropRoleSqlNode,
    t_gsp_dropTriggerSqlNode,
    t_gsp_lockTableSqlNode,
    t_gsp_lockingClause,
    t_gsp_windowClause,
    t_gsp_windowDef,
    t_gsp_partitionClause,
    t_gsp_indices,
    t_gsp_alterSequenceSqlNode,
    t_gsp_alterViewSqlNode,
    t_gsp_collectStatisticsSqlNode,
    t_gsp_teradataWithClause,
    t_gsp_qualifyClause,
    t_gsp_sampleClause,
    t_gsp_expandOnClause,
    t_gsp_datatypeAttribute,
    t_gsp_newVariantTypeArgument,
    t_gsp_outputFormatPhrase
} ENodeType;
'''

def printf_func(define, name, first, last):
    s, e = define.index('{'), define.rindex('}')
    items = define[s+1:e].split(',')
    assert items[0].strip() == first, (items[0].strip(), first)
    assert items[-1].strip() == last, (items[-1].strip(),last) 
    print('''void {function}_init(lua_State *L) {
\tstatic const char* Var_{function} = "{function}";
\tlua_pushstring(L, Var_{function});
\tlua_newtable(L);\n'''.replace("{function}", name))
    i = 0
    for k in items:
        k = k.strip()
        if k:
            print('\tlua_pushstring(L, "%s"); lua_pushnumber(L, %s); lua_settable(L, -3);' % (k,k))
            if i % 100 == 0:print('\tassert( %d == %s);\n' % (i, k))
        i+=1

    print('\tassert( %d == %s);' %(i, k))
    print("\n\tlua_settable(L, -3);\n}\n")

printf_func(stmttype, "EStmtType", "sstunknown", "sstinformixWhenever")
printf_func(nodetype, "ENodeType", "t_gsp_invalid", "t_gsp_outputFormatPhrase")