Fossil

Check-in [8c0f4bc7]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Reverse the order of column/table existence checking to make validation of already updated local database faster.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | symlinks
Files: files | file ages | folders
SHA1: 8c0f4bc718cb0c6cc4526958a201bbcbbc719e33
User & Date: dmitry 2011-08-27 01:21:42.913
Context
2011-08-27
09:44
Fix reading delta from wrong column in stash. ... (check-in: 0317a929 user: dmitry tags: symlinks)
01:21
Reverse the order of column/table existence checking to make validation of already updated local database faster. ... (check-in: 8c0f4bc7 user: dmitry tags: symlinks)
01:07
Add islink column to stashfile, undo, undo_vfile tables if needed. ... (check-in: 44e673f5 user: dmitry tags: symlinks)
Changes
Unified Diff Ignore Whitespace Patch
Changes to src/db.c.
︙︙
784
785
786
787
788
789
790
791
792

793
794
795
796

797
798
799
800

801
802
803
804
805
806
807

  /* If "islink"/"isLink" columns are missing from tables, then
  ** add them now.   This code added on 2011-01-17 and 2011-08-27.
  ** After all users have upgraded, this code can be safely deleted. 
  */
  if( !db_local_column_exists("vfile", "islink") )
    db_multi_exec("ALTER TABLE vfile ADD COLUMN islink BOOLEAN DEFAULT 0");
  
  if( db_local_table_exists("stashfile") && 
      !db_local_column_exists("stashfile", "isLink") )

    db_multi_exec("ALTER TABLE stashfile ADD COLUMN isLink BOOLEAN DEFAULT 0");

  if( db_local_table_exists("undo") &&
      !db_local_column_exists("undo", "isLink") )

    db_multi_exec("ALTER TABLE undo ADD COLUMN isLink BOOLEAN DEFAULT 0");
  
  if( db_local_table_exists("undo_vfile") && 
      !db_local_column_exists("undo_vfile", "islink") )

    db_multi_exec("ALTER TABLE undo_vfile ADD COLUMN islink BOOLEAN DEFAULT 0");

  return 1;
}

/*
** Locate the root directory of the local repository tree.  The root








<
|
>


<
|
>


<
|
>








784
785
786
787
788
789
790

791
792
793
794

795
796
797
798

799
800
801
802
803
804
805
806
807

  /* If "islink"/"isLink" columns are missing from tables, then
  ** add them now.   This code added on 2011-01-17 and 2011-08-27.
  ** After all users have upgraded, this code can be safely deleted. 
  */
  if( !db_local_column_exists("vfile", "islink") )
    db_multi_exec("ALTER TABLE vfile ADD COLUMN islink BOOLEAN DEFAULT 0");
  

  if( !db_local_column_exists("stashfile", "isLink") &&
       db_local_table_exists("stashfile") )
    db_multi_exec("ALTER TABLE stashfile ADD COLUMN isLink BOOLEAN DEFAULT 0");


  if( !db_local_column_exists("undo", "isLink") &&
       db_local_table_exists("undo") )
    db_multi_exec("ALTER TABLE undo ADD COLUMN isLink BOOLEAN DEFAULT 0");
  

  if( !db_local_column_exists("undo_vfile", "islink") &&
       db_local_table_exists("undo_vfile") )
    db_multi_exec("ALTER TABLE undo_vfile ADD COLUMN islink BOOLEAN DEFAULT 0");

  return 1;
}

/*
** Locate the root directory of the local repository tree.  The root
︙︙