dump

SQLite 2.8.6 源代码,用来在Linux/Unix/Windows上编译安装.它是一个小型的数据库,但是非常好用,速度也快,一般的数据库查询之类的操作据统计比MySQL,PostgreSQL

1.1          (drh      29-May-00): exprlist(A) ::= expritem(X).            {A = sqliteExprListAppend(0,X,0);}
1.1          (drh      29-May-00): expritem(A) ::= expr(X).                {A = X;}
1.1          (drh      29-May-00): expritem(A) ::= .                       {A = 0;}
1.4          (drh      31-May-00): 
1.34         (drh      06-Oct-01): ///////////////////////////// The CREATE INDEX command ///////////////////////
1.34         (drh      06-Oct-01): //
1.93         (drh      27-Mar-03): cmd ::= CREATE(S) temp(T) uniqueflag(U) INDEX nm(X)
1.93         (drh      27-Mar-03):         ON nm(Y) dbnm(D) LP idxlist(Z) RP(E) onconf(R). {
1.93         (drh      27-Mar-03):   SrcList *pSrc = sqliteSrcListAppend(0, &Y, &D);
1.43         (drh      29-Jan-02):   if( U!=OE_None ) U = R;
1.43         (drh      29-Jan-02):   if( U==OE_Default) U = OE_Abort;
1.93         (drh      27-Mar-03):   sqliteCreateIndex(pParse, &X, pSrc, Z, U, T, &S, &E);
1.43         (drh      29-Jan-02): }
1.31         (drh      27-Sep-01): 
1.31         (drh      27-Sep-01): %type uniqueflag {int}
1.43         (drh      29-Jan-02): uniqueflag(A) ::= UNIQUE.  { A = OE_Abort; }
1.43         (drh      29-Jan-02): uniqueflag(A) ::= .        { A = OE_None; }
1.1          (drh      29-May-00): 
1.1          (drh      29-May-00): %type idxlist {IdList*}
1.1          (drh      29-May-00): %destructor idxlist {sqliteIdListDelete($$);}
1.83         (drh      31-Aug-02): %type idxlist_opt {IdList*}
1.83         (drh      31-Aug-02): %destructor idxlist_opt {sqliteIdListDelete($$);}
1.1          (drh      29-May-00): %type idxitem {Token}
1.1          (drh      29-May-00): 
1.83         (drh      31-Aug-02): idxlist_opt(A) ::= .                         {A = 0;}
1.83         (drh      31-Aug-02): idxlist_opt(A) ::= LP idxlist(X) RP.         {A = X;}
1.83         (drh      31-Aug-02): idxlist(A) ::= idxlist(X) COMMA idxitem(Y).  {A = sqliteIdListAppend(X,&Y);}
1.83         (drh      31-Aug-02): idxlist(A) ::= idxitem(Y).                   {A = sqliteIdListAppend(0,&Y);}
1.97         (drh      29-Apr-03): idxitem(A) ::= nm(X) sortorder.              {A = X;}
1.1          (drh      29-May-00): 
1.41         (drh      22-Dec-01): ///////////////////////////// The DROP INDEX command /////////////////////////
1.34         (drh      06-Oct-01): //
1.34         (drh      06-Oct-01): 
1.93         (drh      27-Mar-03): cmd ::= DROP INDEX nm(X) dbnm(Y).   {
1.93         (drh      27-Mar-03):   sqliteDropIndex(pParse, sqliteSrcListAppend(0,&X,&Y));
1.93         (drh      27-Mar-03): }
1.2          (drh      30-May-00): 
1.34         (drh      06-Oct-01): 
1.41         (drh      22-Dec-01): ///////////////////////////// The COPY command ///////////////////////////////
1.34         (drh      06-Oct-01): //
1.93         (drh      27-Mar-03): cmd ::= COPY orconf(R) nm(X) dbnm(D) FROM nm(Y) USING DELIMITERS STRING(Z).
1.93         (drh      27-Mar-03):     {sqliteCopy(pParse,sqliteSrcListAppend(0,&X,&D),&Y,&Z,R);}
1.93         (drh      27-Mar-03): cmd ::= COPY orconf(R) nm(X) dbnm(D) FROM nm(Y).
1.93         (drh      27-Mar-03):     {sqliteCopy(pParse,sqliteSrcListAppend(0,&X,&D),&Y,0,R);}
1.3          (drh      31-May-00): 
1.34         (drh      06-Oct-01): ///////////////////////////// The VACUUM command /////////////////////////////
1.34         (drh      06-Oct-01): //
1.3          (drh      31-May-00): cmd ::= VACUUM.                {sqliteVacuum(pParse,0);}
1.76         (drh      01-Jul-02): cmd ::= VACUUM nm(X).         {sqliteVacuum(pParse,&X);}
1.29         (drh      14-Sep-01): 
1.34         (drh      06-Oct-01): ///////////////////////////// The PRAGMA command /////////////////////////////
1.34         (drh      06-Oct-01): //
1.76         (drh      01-Jul-02): cmd ::= PRAGMA ids(X) EQ nm(Y).         {sqlitePragma(pParse,&X,&Y,0);}
1.29         (drh      14-Sep-01): cmd ::= PRAGMA ids(X) EQ ON(Y).          {sqlitePragma(pParse,&X,&Y,0);}
1.29         (drh      14-Sep-01): cmd ::= PRAGMA ids(X) EQ plus_num(Y).    {sqlitePragma(pParse,&X,&Y,0);}
1.29         (drh      14-Sep-01): cmd ::= PRAGMA ids(X) EQ minus_num(Y).   {sqlitePragma(pParse,&X,&Y,1);}
1.76         (drh      01-Jul-02): cmd ::= PRAGMA ids(X) LP nm(Y) RP.      {sqlitePragma(pParse,&X,&Y,0);}
1.56         (drh      05-Mar-02): cmd ::= PRAGMA ids(X).                   {sqlitePragma(pParse,&X,&X,0);}
1.29         (drh      14-Sep-01): plus_num(A) ::= plus_opt number(X).   {A = X;}
1.29         (drh      14-Sep-01): minus_num(A) ::= MINUS number(X).     {A = X;}
1.29         (drh      14-Sep-01): number(A) ::= INTEGER(X).  {A = X;}
1.29         (drh      14-Sep-01): number(A) ::= FLOAT(X).    {A = X;}
1.29         (drh      14-Sep-01): plus_opt ::= PLUS.
1.29         (drh      14-Sep-01): plus_opt ::= .
1.64         (danielk1 15-May-02): 
1.64         (danielk1 15-May-02): //////////////////////////// The CREATE TRIGGER command /////////////////////
1.96         (drh      21-Apr-03): 
1.96         (drh      21-Apr-03): cmd ::= CREATE(A) trigger_decl BEGIN trigger_cmd_list(S) END(Z). {
1.82         (drh      24-Aug-02):   Token all;
1.82         (drh      24-Aug-02):   all.z = A.z;
1.82         (drh      24-Aug-02):   all.n = (Z.z - A.z) + Z.n;
1.96         (drh      21-Apr-03):   sqliteFinishTrigger(pParse, S, &all);
1.96         (drh      21-Apr-03): }
1.96         (drh      21-Apr-03): 
1.96         (drh      21-Apr-03): trigger_decl ::= temp(T) TRIGGER nm(B) trigger_time(C) trigger_event(D)
1.96         (drh      21-Apr-03):                  ON nm(E) dbnm(DB) foreach_clause(F) when_clause(G). {
1.96         (drh      21-Apr-03):   SrcList *pTab = sqliteSrcListAppend(0, &E, &DB);
1.96         (drh      21-Apr-03):   sqliteBeginTrigger(pParse, &B, C, D.a, D.b, pTab, F, G, T);
1.64         (danielk1 15-May-02): }
1.64         (danielk1 15-May-02): 
1.64         (danielk1 15-May-02): %type trigger_time  {int}
1.64         (danielk1 15-May-02): trigger_time(A) ::= BEFORE.      { A = TK_BEFORE; }
1.64         (danielk1 15-May-02): trigger_time(A) ::= AFTER.       { A = TK_AFTER;  }
1.64         (danielk1 15-May-02): trigger_time(A) ::= INSTEAD OF.  { A = TK_INSTEAD;}
1.64         (danielk1 15-May-02): trigger_time(A) ::= .            { A = TK_BEFORE; }
1.64         (danielk1 15-May-02): 
1.68         (drh      24-May-02): %type trigger_event {struct TrigEvent}
1.68         (drh      24-May-02): %destructor trigger_event {sqliteIdListDelete($$.b);}
1.64         (danielk1 15-May-02): trigger_event(A) ::= DELETE. { A.a = TK_DELETE; A.b = 0; }
1.64         (danielk1 15-May-02): trigger_event(A) ::= INSERT. { A.a = TK_INSERT; A.b = 0; }
1.64         (danielk1 15-May-02): trigger_event(A) ::= UPDATE. { A.a = TK_UPDATE; A.b = 0;}
1.64         (danielk1 15-May-02): trigger_event(A) ::= UPDATE OF inscollist(X). {A.a = TK_UPDATE; A.b = X; }
1.64         (danielk1 15-May-02): 
1.64         (danielk1 15-May-02): %type foreach_clause {int}
1.64         (danielk1 15-May-02): foreach_clause(A) ::= .                   { A = TK_ROW; }
1.64         (danielk1 15-May-02): foreach_clause(A) ::= FOR EACH ROW.       { A = TK_ROW; }
1.64         (danielk1 15-May-02): foreach_clause(A) ::= FOR EACH STATEMENT. { A = TK_STATEMENT; }
1.64         (danielk1 15-May-02): 
1.64         (danielk1 15-May-02): %type when_clause {Expr *}
1.64         (danielk1 15-May-02): when_clause(A) ::= .             { A = 0; }
1.64         (danielk1 15-May-02): when_clause(A) ::= WHEN expr(X). { A = X; }
1.64         (danielk1 15-May-02): 
1.64         (danielk1 15-May-02): %type trigger_cmd_list {TriggerStep *}
1.96         (drh      21-Apr-03): %destructor trigger_cmd_list {sqliteDeleteTriggerStep($$);}
1.64         (danielk1 15-May-02): trigger_cmd_list(A) ::= trigger_cmd(X) SEMI trigger_cmd_list(Y). {
1.95         (drh      17-Apr-03):   X->pNext = Y;
1.95         (drh      17-Apr-03):   A = X;
1.95         (drh      17-Apr-03): }
1.64         (danielk1 15-May-02): trigger_cmd_list(A) ::= . { A = 0; }
1.64         (danielk1 15-May-02): 
1.64         (danielk1 15-May-02): %type trigger_cmd {TriggerStep *}
1.96         (drh      21-Apr-03): %destructor trigger_cmd {sqliteDeleteTriggerStep($$);}
1.64         (danielk1 15-May-02): // UPDATE 
1.76         (drh      01-Jul-02): trigger_cmd(A) ::= UPDATE orconf(R) nm(X) SET setlist(Y) where_opt(Z).  
1.64         (danielk1 15-May-02):                { A = sqliteTriggerUpdateStep(&X, Y, Z, R); }
1.64         (danielk1 15-May-02): 
1.64         (danielk1 15-May-02): // INSERT
1.76         (drh      01-Jul-02): trigger_cmd(A) ::= INSERT orconf(R) INTO nm(X) inscollist_opt(F) 
1.64         (danielk1 15-May-02):   VALUES LP itemlist(Y) RP.  
1.64         (danielk1 15-May-02): {A = sqliteTriggerInsertStep(&X, F, Y, 0, R);}
1.64         (danielk1 15-May-02): 
1.76         (drh      01-Jul-02): trigger_cmd(A) ::= INSERT orconf(R) INTO nm(X) inscollist_opt(F) select(S).
1.64         (danielk1 15-May-02):                {A = sqliteTriggerInsertStep(&X, F, 0, S, R);}
1.64         (danielk1 15-May-02): 
1.64         (danielk1 15-May-02): // DELETE
1.76         (drh      01-Jul-02): trigger_cmd(A) ::= DELETE FROM nm(X) where_opt(Y).
1.64         (danielk1 15-May-02):                {A = sqliteTriggerDeleteStep(&X, Y);}
1.64         (danielk1 15-May-02): 
1.64         (danielk1 15-May-02): // SELECT
1.64         (danielk1 15-May-02): trigger_cmd(A) ::= select(X).  {A = sqliteTriggerSelectStep(X); }
1.73         (danielk1 11-Jun-02): 
1.73         (danielk1 11-Jun-02): // The special RAISE expression that may occur in trigger programs
1.82         (drh      24-Aug-02): expr(A) ::= RAISE(X) LP IGNORE RP(Y).  {
1.82         (drh      24-Aug-02):   A = sqliteExpr(TK_RAISE, 0, 0, 0); 
1.82         (drh      24-Aug-02):   A->iColumn = OE_Ignore;
1.84         (drh      22-Oct-02):   sqliteExprSpan(A, &X, &Y);
1.82         (drh      24-Aug-02): }
1.82         (drh      24-Aug-02): expr(A) ::= RAISE(X) LP ROLLBACK COMMA nm(Z) RP(Y).  {
1.82         (drh      24-Aug-02):   A = sqliteExpr(TK_RAISE, 0, 0, &Z); 
1.82         (drh      24-Aug-02):   A->iColumn = OE_Rollback;
1.84         (drh      22-Oct-02):   sqliteExprSpan(A, &X, &Y);
1.82         (drh      24-Aug-02): }
1.82         (drh      24-Aug-02): expr(A) ::= RAISE(X) LP ABORT COMMA nm(Z) RP(Y).  {
1.82         (drh      24-Aug-02):   A = sqliteExpr(TK_RAISE, 0, 0, &Z); 
1.82         (drh      24-Aug-02):   A->iColumn = OE_Abort;
1.84         (drh      22-Oct-02):   sqliteExprSpan(A, &X, &Y);
1.82         (drh      24-Aug-02): }
1.82         (drh      24-Aug-02): expr(A) ::= RAISE(X) LP FAIL COMMA nm(Z) RP(Y).  {
1.82         (drh      24-Aug-02):   A = sqliteExpr(TK_RAISE, 0, 0, &Z); 
1.82         (drh      24-Aug-02):   A->iColumn = OE_Fail;
1.84         (drh      22-Oct-02):   sqliteExprSpan(A, &X, &Y);
1.82         (drh      24-Aug-02): }
1.64         (danielk1 15-May-02): 
1.64         (danielk1 15-May-02): ////////////////////////  DROP TRIGGER statement //////////////////////////////
1.93         (drh      27-Mar-03): cmd ::= DROP TRIGGER nm(X) dbnm(D). {
1.98         (drh      17-May-03):   sqliteDropTrigger(pParse,sqliteSrcListAppend(0,&X,&D));
1.64         (danielk1 15-May-02): }
1.92         (drh      20-Mar-03): 
1.92         (drh      20-Mar-03): //////////////////////// ATTACH DATABASE file AS name /////////////////////////
1.94         (drh      31-Mar-03): cmd ::= ATTACH database_kw_opt ids(F) AS nm(D). {
1.94         (drh      31-Mar-03):   sqliteAttach(pParse, &F, &D);
1.94         (drh      31-Mar-03): }
1.92         (drh      20-Mar-03): 
1.92         (drh      20-Mar-03): database_kw_opt ::= DATABASE.
1.92         (drh      20-Mar-03): database_kw_opt ::= .
1.92         (drh      20-Mar-03): 
1.92         (drh      20-Mar-03): //////////////////////// DETACH DATABASE name /////////////////////////////////
1.94         (drh      31-Mar-03): cmd ::= DETACH database_kw_opt nm(D). {
1.94         (drh      31-Mar-03):   sqliteDetach(pParse, &D);
1.94         (drh      31-Mar-03): }