File: tests/expected/parser/insert3.serialized

Recommend this page to a friend!
  Classes of Michael Cummings  >  PHP SQL Parser Class  >  tests/expected/parser/insert3.serialized  >  Download  
File: tests/expected/parser/insert3.serialized
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: PHP SQL Parser Class
Parse SQL to extract the SQL query structure
Author: By
Last change:
Date: 2 years ago
Size: 12,029 bytes
 

 

Contents

Class file image Download
a:2:{s:6:"INSERT";a:3:{i:0;a:2:{s:9:"expr_type";s:8:"reserved";s:9:"base_expr";s:4:"INTO";}i:1;a:5:{s:9:"expr_type";s:5:"table";s:5:"table";s:7:"surveys";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:7:"surveys";}}s:5:"alias";b:0;s:9:"base_expr";s:7:"surveys";}i:2;a:3:{s:9:"expr_type";s:11:"column-list";s:9:"base_expr";s:563:"( SID, OWNER_ID, ADMIN, ACTIVE, EXPIRES, STARTDATE, ADMINEMAIL, ANONYMIZED, FAXTO, FORMAT, SAVETIMINGS, TEMPLATE, LANGUAGE, DATESTAMP, USECOOKIE, ALLOWREGISTER, ALLOWSAVE, AUTOREDIRECT, ALLOWPREV, PRINTANSWERS, IPADDR, REFURL, DATECREATED, PUBLICSTATISTICS, PUBLICGRAPHS, LISTPUBLIC, HTMLEMAIL, TOKENANSWERSPERSISTENCE, ASSESSMENTS, USECAPTCHA, BOUNCE_EMAIL, EMAILRESPONSETO, EMAILNOTIFICATIONTO, TOKENLENGTH, SHOWXQUESTIONS, SHOWGROUPINFO, SHOWNOANSWER, SHOWQNUMCODE, SHOWWELCOME, SHOWPROGRESS, ALLOWJUMPS, NAVIGATIONDELAY, NOKEYBOARD, ALLOWEDITAFTERCOMPLETION )";s:8:"sub_tree";a:44:{i:0;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:3:"SID";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:3:"SID";}}}i:1;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:8:"OWNER_ID";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:8:"OWNER_ID";}}}i:2;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:5:"ADMIN";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:5:"ADMIN";}}}i:3;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:6:"ACTIVE";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:6:"ACTIVE";}}}i:4;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:7:"EXPIRES";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:7:"EXPIRES";}}}i:5;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:9:"STARTDATE";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:9:"STARTDATE";}}}i:6;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:10:"ADMINEMAIL";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:10:"ADMINEMAIL";}}}i:7;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:10:"ANONYMIZED";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:10:"ANONYMIZED";}}}i:8;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:5:"FAXTO";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:5:"FAXTO";}}}i:9;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:6:"FORMAT";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:6:"FORMAT";}}}i:10;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:11:"SAVETIMINGS";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:11:"SAVETIMINGS";}}}i:11;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:8:"TEMPLATE";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:8:"TEMPLATE";}}}i:12;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:8:"LANGUAGE";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:8:"LANGUAGE";}}}i:13;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:9:"DATESTAMP";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:9:"DATESTAMP";}}}i:14;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:9:"USECOOKIE";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:9:"USECOOKIE";}}}i:15;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:13:"ALLOWREGISTER";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:13:"ALLOWREGISTER";}}}i:16;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:9:"ALLOWSAVE";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:9:"ALLOWSAVE";}}}i:17;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:12:"AUTOREDIRECT";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:12:"AUTOREDIRECT";}}}i:18;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:9:"ALLOWPREV";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:9:"ALLOWPREV";}}}i:19;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:12:"PRINTANSWERS";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:12:"PRINTANSWERS";}}}i:20;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:6:"IPADDR";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:6:"IPADDR";}}}i:21;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:6:"REFURL";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:6:"REFURL";}}}i:22;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:11:"DATECREATED";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:11:"DATECREATED";}}}i:23;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:16:"PUBLICSTATISTICS";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:16:"PUBLICSTATISTICS";}}}i:24;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:12:"PUBLICGRAPHS";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:12:"PUBLICGRAPHS";}}}i:25;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:10:"LISTPUBLIC";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:10:"LISTPUBLIC";}}}i:26;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:9:"HTMLEMAIL";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:9:"HTMLEMAIL";}}}i:27;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:23:"TOKENANSWERSPERSISTENCE";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:23:"TOKENANSWERSPERSISTENCE";}}}i:28;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:11:"ASSESSMENTS";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:11:"ASSESSMENTS";}}}i:29;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:10:"USECAPTCHA";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:10:"USECAPTCHA";}}}i:30;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:12:"BOUNCE_EMAIL";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:12:"BOUNCE_EMAIL";}}}i:31;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:15:"EMAILRESPONSETO";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:15:"EMAILRESPONSETO";}}}i:32;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:19:"EMAILNOTIFICATIONTO";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:19:"EMAILNOTIFICATIONTO";}}}i:33;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:11:"TOKENLENGTH";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:11:"TOKENLENGTH";}}}i:34;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:14:"SHOWXQUESTIONS";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:14:"SHOWXQUESTIONS";}}}i:35;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:13:"SHOWGROUPINFO";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:13:"SHOWGROUPINFO";}}}i:36;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:12:"SHOWNOANSWER";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:12:"SHOWNOANSWER";}}}i:37;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:12:"SHOWQNUMCODE";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:12:"SHOWQNUMCODE";}}}i:38;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:11:"SHOWWELCOME";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:11:"SHOWWELCOME";}}}i:39;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:12:"SHOWPROGRESS";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:12:"SHOWPROGRESS";}}}i:40;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:10:"ALLOWJUMPS";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:10:"ALLOWJUMPS";}}}i:41;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:15:"NAVIGATIONDELAY";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:15:"NAVIGATIONDELAY";}}}i:42;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:10:"NOKEYBOARD";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:10:"NOKEYBOARD";}}}i:43;a:3:{s:9:"expr_type";s:6:"colref";s:9:"base_expr";s:24:"ALLOWEDITAFTERCOMPLETION";s:9:"no_quotes";a:2:{s:5:"delim";b:0;s:5:"parts";a:1:{i:0;s:24:"ALLOWEDITAFTERCOMPLETION";}}}}}}s:6:"VALUES";a:1:{i:0;a:4:{s:9:"expr_type";s:6:"record";s:9:"base_expr";s:319:"( 32225, 1, 'André', 'N', null, null, 'hello@zks.uni-leipzig.de', 'N', '', 'G', 'N', 'default', 'de-informal', 'N', 'N', 'N', 'Y', 'N', 'N', 'N', 'N', 'N', a_function('2012-02-16','YYYY-MM-DD'), 'N', 'N', 'Y', 'Y', 'N', 'N', 'D', 'hello@zks.uni-leipzig.de', '', '', 15, 'Y', 'B', 'Y', 'X', 'Y', 'Y', 'N', 0, 'N', 'N' )";s:4:"data";a:44:{i:0;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:5:"32225";s:8:"sub_tree";b:0;}i:1;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:1:"1";s:8:"sub_tree";b:0;}i:2;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:8:"'André'";s:8:"sub_tree";b:0;}i:3;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:4;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:4:"null";s:8:"sub_tree";b:0;}i:5;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:4:"null";s:8:"sub_tree";b:0;}i:6;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:26:"'hello@zks.uni-leipzig.de'";s:8:"sub_tree";b:0;}i:7;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:8;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:2:"''";s:8:"sub_tree";b:0;}i:9;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'G'";s:8:"sub_tree";b:0;}i:10;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:11;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:9:"'default'";s:8:"sub_tree";b:0;}i:12;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:13:"'de-informal'";s:8:"sub_tree";b:0;}i:13;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:14;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:15;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:16;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'Y'";s:8:"sub_tree";b:0;}i:17;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:18;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:19;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:20;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:21;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:22;a:3:{s:9:"expr_type";s:8:"function";s:9:"base_expr";s:10:"a_function";s:8:"sub_tree";a:2:{i:0;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:12:"'2012-02-16'";s:8:"sub_tree";b:0;}i:1;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:12:"'YYYY-MM-DD'";s:8:"sub_tree";b:0;}}}i:23;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:24;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:25;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'Y'";s:8:"sub_tree";b:0;}i:26;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'Y'";s:8:"sub_tree";b:0;}i:27;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:28;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:29;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'D'";s:8:"sub_tree";b:0;}i:30;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:26:"'hello@zks.uni-leipzig.de'";s:8:"sub_tree";b:0;}i:31;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:2:"''";s:8:"sub_tree";b:0;}i:32;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:2:"''";s:8:"sub_tree";b:0;}i:33;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:2:"15";s:8:"sub_tree";b:0;}i:34;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'Y'";s:8:"sub_tree";b:0;}i:35;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'B'";s:8:"sub_tree";b:0;}i:36;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'Y'";s:8:"sub_tree";b:0;}i:37;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'X'";s:8:"sub_tree";b:0;}i:38;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'Y'";s:8:"sub_tree";b:0;}i:39;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'Y'";s:8:"sub_tree";b:0;}i:40;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:41;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:1:"0";s:8:"sub_tree";b:0;}i:42;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}i:43;a:3:{s:9:"expr_type";s:5:"const";s:9:"base_expr";s:3:"'N'";s:8:"sub_tree";b:0;}}s:5:"delim";b:0;}}}

For more information send a message to info at phpclasses dot org.