« back to all changes in this revision
Viewing changes to subversion/libsvn_wc/wc-queries.h
- browse files at revision 33
- compare with another revision
- download diff
- download tarball
- view history from revision 33
- Committer: Package Import Robot
- Author(s): James McCoy
- Date: 2014-05-20 22:45:32 UTC
- mfrom: (0.2.12)
- Revision ID: package-import@ubuntu.com-20140520224532-4fec3gohdzyy692g
Tags: 1.8.9-1
* New upstream release
* Merge changes from Ubuntu:
- Add DEB-8 test for Apache functionality
- debian/rules: Create pot file on build.
- debian/rules: Ensure the doxygen output directory exists
- Move svn2cl to subversion-tools' Suggests on Ubuntu.
* Merge changes from Ubuntu:
- Add DEB-8 test for Apache functionality
- debian/rules: Create pot file on build.
- debian/rules: Ensure the doxygen output directory exists
- Move svn2cl to subversion-tools' Suggests on Ubuntu.
- files added:
- debian/patches/verbose-tests
- debian/tests
- files modified:
- CHANGES
added
removed
subversion/libsvn_wc/wc-queries.h
1
/* This file is automatically generated from wc-queries.sql and .dist_sandbox/subversion-1.8.8/subversion/libsvn_wc/token-map.h.
1
/* This file is automatically generated from wc-queries.sql and .dist_sandbox/subversion-1.8.9/subversion/libsvn_wc/token-map.h.
2
2
* Do not edit this file -- edit the source and rerun gen-make.py */
3
3
4
4
#define STMT_SELECT_NODE_INFO 0
221
221
#define STMT_21 \
222
222
"DELETE " \
223
223
"FROM NODES " \
224
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
224
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \
225
225
""
226
226
227
227
#define STMT_DELETE_ACTUAL_FOR_BASE_RECURSIVE 22
516
516
"LIMIT 1 " \
517
517
""
518
518
519
#define STMT_SELECT_OP_DEPTH_MOVED_TO 50
520
#define STMT_50_INFO {"STMT_SELECT_OP_DEPTH_MOVED_TO", NULL}
519
#define STMT_SELECT_MOVED_TO_NODE 50
520
#define STMT_50_INFO {"STMT_SELECT_MOVED_TO_NODE", NULL}
521
521
#define STMT_50 \
522
"SELECT op_depth, moved_to " \
523
"FROM nodes " \
524
"WHERE wc_id = ?1 AND local_relpath = ?2 AND moved_to IS NOT NULL " \
525
"ORDER BY op_depth DESC " \
526
""
527
528
#define STMT_SELECT_OP_DEPTH_MOVED_TO 51
529
#define STMT_51_INFO {"STMT_SELECT_OP_DEPTH_MOVED_TO", NULL}
530
#define STMT_51 \
522
531
"SELECT op_depth, moved_to, repos_path, revision " \
523
532
"FROM nodes " \
524
533
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
527
536
"ORDER BY op_depth DESC " \
528
537
""
529
538
530
#define STMT_SELECT_MOVED_TO 51
531
#define STMT_51_INFO {"STMT_SELECT_MOVED_TO", NULL}
532
#define STMT_51 \
539
#define STMT_SELECT_MOVED_TO 52
540
#define STMT_52_INFO {"STMT_SELECT_MOVED_TO", NULL}
541
#define STMT_52 \
533
542
"SELECT moved_to " \
534
543
"FROM nodes " \
535
544
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \
536
545
""
537
546
538
#define STMT_SELECT_MOVED_HERE 52
539
#define STMT_52_INFO {"STMT_SELECT_MOVED_HERE", NULL}
540
#define STMT_52 \
547
#define STMT_SELECT_MOVED_HERE 53
548
#define STMT_53_INFO {"STMT_SELECT_MOVED_HERE", NULL}
549
#define STMT_53 \
541
550
"SELECT moved_here, presence, repos_path, revision " \
542
551
"FROM nodes " \
543
552
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth >= ?3 " \
544
553
"ORDER BY op_depth " \
545
554
""
546
555
547
#define STMT_SELECT_MOVED_BACK 53
548
#define STMT_53_INFO {"STMT_SELECT_MOVED_BACK", NULL}
549
#define STMT_53 \
556
#define STMT_SELECT_MOVED_BACK 54
557
#define STMT_54_INFO {"STMT_SELECT_MOVED_BACK", NULL}
558
#define STMT_54 \
550
559
"SELECT u.local_relpath, " \
551
560
" u.presence, u.repos_id, u.repos_path, u.revision, " \
552
561
" l.presence, l.repos_id, l.repos_path, l.revision, " \
572
581
" AND u.op_depth = ?4 " \
573
582
""
574
583
575
#define STMT_DELETE_MOVED_BACK 54
576
#define STMT_54_INFO {"STMT_DELETE_MOVED_BACK", NULL}
577
#define STMT_54 \
578
"DELETE FROM nodes " \
579
"WHERE wc_id = ?1 " \
580
" AND (local_relpath = ?2 " \
581
" OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
582
" AND op_depth = ?3 " \
583
""
584
585
#define STMT_DELETE_LOCK 55
586
#define STMT_55_INFO {"STMT_DELETE_LOCK", NULL}
584
#define STMT_DELETE_MOVED_BACK 55
585
#define STMT_55_INFO {"STMT_DELETE_MOVED_BACK", NULL}
587
586
#define STMT_55 \
587
"DELETE FROM nodes " \
588
"WHERE wc_id = ?1 " \
589
" AND (local_relpath = ?2 " \
590
" OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
591
" AND op_depth = ?3 " \
592
""
593
594
#define STMT_DELETE_LOCK 56
595
#define STMT_56_INFO {"STMT_DELETE_LOCK", NULL}
596
#define STMT_56 \
588
597
"DELETE FROM lock " \
589
598
"WHERE repos_id = ?1 AND repos_relpath = ?2 " \
590
599
""
591
600
592
#define STMT_DELETE_LOCK_RECURSIVELY 56
593
#define STMT_56_INFO {"STMT_DELETE_LOCK_RECURSIVELY", NULL}
594
#define STMT_56 \
601
#define STMT_DELETE_LOCK_RECURSIVELY 57
602
#define STMT_57_INFO {"STMT_DELETE_LOCK_RECURSIVELY", NULL}
603
#define STMT_57 \
595
604
"DELETE FROM lock " \
596
605
"WHERE repos_id = ?1 AND (repos_relpath = ?2 OR (((repos_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((repos_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
597
606
""
598
607
599
#define STMT_CLEAR_BASE_NODE_RECURSIVE_DAV_CACHE 57
600
#define STMT_57_INFO {"STMT_CLEAR_BASE_NODE_RECURSIVE_DAV_CACHE", NULL}
601
#define STMT_57 \
608
#define STMT_CLEAR_BASE_NODE_RECURSIVE_DAV_CACHE 58
609
#define STMT_58_INFO {"STMT_CLEAR_BASE_NODE_RECURSIVE_DAV_CACHE", NULL}
610
#define STMT_58 \
602
611
"UPDATE nodes SET dav_cache = NULL " \
603
612
"WHERE dav_cache IS NOT NULL AND wc_id = ?1 AND op_depth = 0 " \
604
613
" AND (local_relpath = ?2 " \
605
614
" OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
606
615
""
607
616
608
#define STMT_RECURSIVE_UPDATE_NODE_REPO 58
609
#define STMT_58_INFO {"STMT_RECURSIVE_UPDATE_NODE_REPO", NULL}
610
#define STMT_58 \
617
#define STMT_RECURSIVE_UPDATE_NODE_REPO 59
618
#define STMT_59_INFO {"STMT_RECURSIVE_UPDATE_NODE_REPO", NULL}
619
#define STMT_59 \
611
620
"UPDATE nodes SET repos_id = ?4, dav_cache = NULL " \
612
621
"WHERE (wc_id = ?1 AND local_relpath = ?2 AND repos_id = ?3) " \
613
622
" OR (wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
614
623
" AND repos_id = ?3) " \
615
624
""
616
625
617
#define STMT_UPDATE_LOCK_REPOS_ID 59
618
#define STMT_59_INFO {"STMT_UPDATE_LOCK_REPOS_ID", NULL}
619
#define STMT_59 \
626
#define STMT_UPDATE_LOCK_REPOS_ID 60
627
#define STMT_60_INFO {"STMT_UPDATE_LOCK_REPOS_ID", NULL}
628
#define STMT_60 \
620
629
"UPDATE lock SET repos_id = ?2 " \
621
630
"WHERE repos_id = ?1 " \
622
631
""
623
632
624
#define STMT_UPDATE_NODE_FILEINFO 60
625
#define STMT_60_INFO {"STMT_UPDATE_NODE_FILEINFO", NULL}
626
#define STMT_60 \
633
#define STMT_UPDATE_NODE_FILEINFO 61
634
#define STMT_61_INFO {"STMT_UPDATE_NODE_FILEINFO", NULL}
635
#define STMT_61 \
627
636
"UPDATE nodes SET translated_size = ?3, last_mod_time = ?4 " \
628
637
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
629
638
" AND op_depth = (SELECT MAX(op_depth) FROM nodes " \
630
639
" WHERE wc_id = ?1 AND local_relpath = ?2) " \
631
640
""
632
641
633
#define STMT_INSERT_ACTUAL_CONFLICT 61
634
#define STMT_61_INFO {"STMT_INSERT_ACTUAL_CONFLICT", NULL}
635
#define STMT_61 \
636
"INSERT INTO actual_node (wc_id, local_relpath, conflict_data, parent_relpath) " \
637
"VALUES (?1, ?2, ?3, ?4) " \
638
""
639
640
#define STMT_UPDATE_ACTUAL_CONFLICT 62
641
#define STMT_62_INFO {"STMT_UPDATE_ACTUAL_CONFLICT", NULL}
642
#define STMT_INSERT_ACTUAL_CONFLICT 62
643
#define STMT_62_INFO {"STMT_INSERT_ACTUAL_CONFLICT", NULL}
642
644
#define STMT_62 \
643
"UPDATE actual_node SET conflict_data = ?3 " \
644
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
645
"INSERT INTO actual_node (wc_id, local_relpath, conflict_data, parent_relpath) " \
646
"VALUES (?1, ?2, ?3, ?4) " \
645
647
""
646
648
647
#define STMT_UPDATE_ACTUAL_CHANGELISTS 63
648
#define STMT_63_INFO {"STMT_UPDATE_ACTUAL_CHANGELISTS", NULL}
649
#define STMT_UPDATE_ACTUAL_CONFLICT 63
650
#define STMT_63_INFO {"STMT_UPDATE_ACTUAL_CONFLICT", NULL}
649
651
#define STMT_63 \
652
"UPDATE actual_node SET conflict_data = ?3 " \
653
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
654
""
655
656
#define STMT_UPDATE_ACTUAL_CHANGELISTS 64
657
#define STMT_64_INFO {"STMT_UPDATE_ACTUAL_CHANGELISTS", NULL}
658
#define STMT_64 \
650
659
"UPDATE actual_node SET changelist = ?3 " \
651
660
"WHERE wc_id = ?1 " \
652
661
" AND (local_relpath = ?2 OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
656
665
" AND kind = 'file') " \
657
666
""
658
667
659
#define STMT_UPDATE_ACTUAL_CLEAR_CHANGELIST 64
660
#define STMT_64_INFO {"STMT_UPDATE_ACTUAL_CLEAR_CHANGELIST", NULL}
661
#define STMT_64 \
668
#define STMT_UPDATE_ACTUAL_CLEAR_CHANGELIST 65
669
#define STMT_65_INFO {"STMT_UPDATE_ACTUAL_CLEAR_CHANGELIST", NULL}
670
#define STMT_65 \
662
671
"UPDATE actual_node SET changelist = NULL " \
663
672
" WHERE wc_id = ?1 AND local_relpath = ?2 " \
664
673
""
665
674
666
#define STMT_MARK_SKIPPED_CHANGELIST_DIRS 65
667
#define STMT_65_INFO {"STMT_MARK_SKIPPED_CHANGELIST_DIRS", NULL}
668
#define STMT_65 \
675
#define STMT_MARK_SKIPPED_CHANGELIST_DIRS 66
676
#define STMT_66_INFO {"STMT_MARK_SKIPPED_CHANGELIST_DIRS", NULL}
677
#define STMT_66 \
669
678
"INSERT INTO changelist_list (wc_id, local_relpath, notify, changelist) " \
670
679
"SELECT wc_id, local_relpath, 7, ?3 " \
671
680
"FROM targets_list " \
674
683
" AND kind = 'dir' " \
675
684
""
676
685
677
#define STMT_RESET_ACTUAL_WITH_CHANGELIST 66
678
#define STMT_66_INFO {"STMT_RESET_ACTUAL_WITH_CHANGELIST", NULL}
679
#define STMT_66 \
686
#define STMT_RESET_ACTUAL_WITH_CHANGELIST 67
687
#define STMT_67_INFO {"STMT_RESET_ACTUAL_WITH_CHANGELIST", NULL}
688
#define STMT_67 \
680
689
"REPLACE INTO actual_node ( " \
681
690
" wc_id, local_relpath, parent_relpath, changelist) " \
682
691
"VALUES (?1, ?2, ?3, ?4) " \
683
692
""
684
693
685
#define STMT_CREATE_CHANGELIST_LIST 67
686
#define STMT_67_INFO {"STMT_CREATE_CHANGELIST_LIST", NULL}
687
#define STMT_67 \
694
#define STMT_CREATE_CHANGELIST_LIST 68
695
#define STMT_68_INFO {"STMT_CREATE_CHANGELIST_LIST", NULL}
696
#define STMT_68 \
688
697
"DROP TABLE IF EXISTS changelist_list; " \
689
698
"CREATE TEMPORARY TABLE changelist_list ( " \
690
699
" wc_id INTEGER NOT NULL, " \
695
704
") " \
696
705
""
697
706
698
#define STMT_CREATE_CHANGELIST_TRIGGER 68
699
#define STMT_68_INFO {"STMT_CREATE_CHANGELIST_TRIGGER", NULL}
700
#define STMT_68 \
707
#define STMT_CREATE_CHANGELIST_TRIGGER 69
708
#define STMT_69_INFO {"STMT_CREATE_CHANGELIST_TRIGGER", NULL}
709
#define STMT_69 \
701
710
"DROP TRIGGER IF EXISTS trigger_changelist_list_change; " \
702
711
"CREATE TEMPORARY TRIGGER trigger_changelist_list_change " \
703
712
"BEFORE UPDATE ON actual_node " \
712
721
"END " \
713
722
""
714
723
715
#define STMT_FINALIZE_CHANGELIST 69
716
#define STMT_69_INFO {"STMT_FINALIZE_CHANGELIST", NULL}
717
#define STMT_69 \
724
#define STMT_FINALIZE_CHANGELIST 70
725
#define STMT_70_INFO {"STMT_FINALIZE_CHANGELIST", NULL}
726
#define STMT_70 \
718
727
"DROP TRIGGER trigger_changelist_list_change; " \
719
728
"DROP TABLE changelist_list; " \
720
729
"DROP TABLE targets_list " \
721
730
""
722
731
723
#define STMT_SELECT_CHANGELIST_LIST 70
724
#define STMT_70_INFO {"STMT_SELECT_CHANGELIST_LIST", NULL}
725
#define STMT_70 \
732
#define STMT_SELECT_CHANGELIST_LIST 71
733
#define STMT_71_INFO {"STMT_SELECT_CHANGELIST_LIST", NULL}
734
#define STMT_71 \
726
735
"SELECT wc_id, local_relpath, notify, changelist " \
727
736
"FROM changelist_list " \
728
737
"ORDER BY wc_id, local_relpath ASC, notify DESC " \
729
738
""
730
739
731
#define STMT_CREATE_TARGETS_LIST 71
732
#define STMT_71_INFO {"STMT_CREATE_TARGETS_LIST", NULL}
733
#define STMT_71 \
740
#define STMT_CREATE_TARGETS_LIST 72
741
#define STMT_72_INFO {"STMT_CREATE_TARGETS_LIST", NULL}
742
#define STMT_72 \
734
743
"DROP TABLE IF EXISTS targets_list; " \
735
744
"CREATE TEMPORARY TABLE targets_list ( " \
736
745
" wc_id INTEGER NOT NULL, " \
741
750
" ); " \
742
751
""
743
752
744
#define STMT_DROP_TARGETS_LIST 72
745
#define STMT_72_INFO {"STMT_DROP_TARGETS_LIST", NULL}
746
#define STMT_72 \
747
"DROP TABLE targets_list " \
748
""
749
750
#define STMT_INSERT_TARGET 73
751
#define STMT_73_INFO {"STMT_INSERT_TARGET", NULL}
753
#define STMT_DROP_TARGETS_LIST 73
754
#define STMT_73_INFO {"STMT_DROP_TARGETS_LIST", NULL}
752
755
#define STMT_73 \
753
"INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \
754
"SELECT wc_id, local_relpath, parent_relpath, kind " \
755
"FROM nodes_current " \
756
"WHERE wc_id = ?1 " \
757
" AND local_relpath = ?2 " \
756
"DROP TABLE targets_list " \
758
757
""
759
758
760
#define STMT_INSERT_TARGET_DEPTH_FILES 74
761
#define STMT_74_INFO {"STMT_INSERT_TARGET_DEPTH_FILES", NULL}
759
#define STMT_INSERT_TARGET 74
760
#define STMT_74_INFO {"STMT_INSERT_TARGET", NULL}
762
761
#define STMT_74 \
763
762
"INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \
764
763
"SELECT wc_id, local_relpath, parent_relpath, kind " \
765
764
"FROM nodes_current " \
766
765
"WHERE wc_id = ?1 " \
766
" AND local_relpath = ?2 " \
767
""
768
769
#define STMT_INSERT_TARGET_DEPTH_FILES 75
770
#define STMT_75_INFO {"STMT_INSERT_TARGET_DEPTH_FILES", NULL}
771
#define STMT_75 \
772
"INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \
773
"SELECT wc_id, local_relpath, parent_relpath, kind " \
774
"FROM nodes_current " \
775
"WHERE wc_id = ?1 " \
767
776
" AND parent_relpath = ?2 " \
768
777
" AND kind = 'file' " \
769
778
""
770
779
771
#define STMT_INSERT_TARGET_DEPTH_IMMEDIATES 75
772
#define STMT_75_INFO {"STMT_INSERT_TARGET_DEPTH_IMMEDIATES", NULL}
773
#define STMT_75 \
774
"INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \
775
"SELECT wc_id, local_relpath, parent_relpath, kind " \
776
"FROM nodes_current " \
777
"WHERE wc_id = ?1 " \
778
" AND parent_relpath = ?2 " \
779
""
780
781
#define STMT_INSERT_TARGET_DEPTH_INFINITY 76
782
#define STMT_76_INFO {"STMT_INSERT_TARGET_DEPTH_INFINITY", NULL}
780
#define STMT_INSERT_TARGET_DEPTH_IMMEDIATES 76
781
#define STMT_76_INFO {"STMT_INSERT_TARGET_DEPTH_IMMEDIATES", NULL}
783
782
#define STMT_76 \
784
783
"INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \
785
784
"SELECT wc_id, local_relpath, parent_relpath, kind " \
786
785
"FROM nodes_current " \
787
786
"WHERE wc_id = ?1 " \
788
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
787
" AND parent_relpath = ?2 " \
789
788
""
790
789
791
#define STMT_INSERT_TARGET_WITH_CHANGELIST 77
792
#define STMT_77_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST", NULL}
790
#define STMT_INSERT_TARGET_DEPTH_INFINITY 77
791
#define STMT_77_INFO {"STMT_INSERT_TARGET_DEPTH_INFINITY", NULL}
793
792
#define STMT_77 \
794
793
"INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \
794
"SELECT wc_id, local_relpath, parent_relpath, kind " \
795
"FROM nodes_current " \
796
"WHERE wc_id = ?1 " \
797
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
798
""
799
800
#define STMT_INSERT_TARGET_WITH_CHANGELIST 78
801
#define STMT_78_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST", NULL}
802
#define STMT_78 \
803
"INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \
795
804
"SELECT N.wc_id, N.local_relpath, N.parent_relpath, N.kind " \
796
805
" FROM actual_node AS A JOIN nodes_current AS N " \
797
806
" ON A.wc_id = N.wc_id AND A.local_relpath = N.local_relpath " \
800
809
" AND A.changelist = ?3 " \
801
810
""
802
811
803
#define STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_FILES 78
804
#define STMT_78_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_FILES", NULL}
805
#define STMT_78 \
812
#define STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_FILES 79
813
#define STMT_79_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_FILES", NULL}
814
#define STMT_79 \
806
815
"INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \
807
816
"SELECT N.wc_id, N.local_relpath, N.parent_relpath, N.kind " \
808
817
" FROM actual_node AS A JOIN nodes_current AS N " \
813
822
" AND A.changelist = ?3 " \
814
823
""
815
824
816
#define STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_IMMEDIATES 79
817
#define STMT_79_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_IMMEDIATES", NULL}
818
#define STMT_79 \
825
#define STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_IMMEDIATES 80
826
#define STMT_80_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_IMMEDIATES", NULL}
827
#define STMT_80 \
819
828
"INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \
820
829
"SELECT N.wc_id, N.local_relpath, N.parent_relpath, N.kind " \
821
830
" FROM actual_node AS A JOIN nodes_current AS N " \
825
834
" AND A.changelist = ?3 " \
826
835
""
827
836
828
#define STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_INFINITY 80
829
#define STMT_80_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_INFINITY", NULL}
830
#define STMT_80 \
837
#define STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_INFINITY 81
838
#define STMT_81_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_INFINITY", NULL}
839
#define STMT_81 \
831
840
"INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \
832
841
"SELECT N.wc_id, N.local_relpath, N.parent_relpath, N.kind " \
833
842
" FROM actual_node AS A JOIN nodes_current AS N " \
837
846
" AND A.changelist = ?3 " \
838
847
""
839
848
840
#define STMT_INSERT_ACTUAL_EMPTIES 81
841
#define STMT_81_INFO {"STMT_INSERT_ACTUAL_EMPTIES", NULL}
842
#define STMT_81 \
849
#define STMT_INSERT_ACTUAL_EMPTIES 82
850
#define STMT_82_INFO {"STMT_INSERT_ACTUAL_EMPTIES", NULL}
851
#define STMT_82 \
843
852
"INSERT OR IGNORE INTO actual_node ( " \
844
853
" wc_id, local_relpath, parent_relpath) " \
845
854
"SELECT wc_id, local_relpath, parent_relpath " \
846
855
"FROM targets_list " \
847
856
""
848
857
849
#define STMT_DELETE_ACTUAL_EMPTY 82
850
#define STMT_82_INFO {"STMT_DELETE_ACTUAL_EMPTY", NULL}
851
#define STMT_82 \
852
"DELETE FROM actual_node " \
853
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
854
" AND properties IS NULL " \
855
" AND conflict_data IS NULL " \
856
" AND changelist IS NULL " \
857
" AND text_mod IS NULL " \
858
" AND older_checksum IS NULL " \
859
" AND right_checksum IS NULL " \
860
" AND left_checksum IS NULL " \
861
""
862
863
#define STMT_DELETE_ACTUAL_EMPTIES 83
864
#define STMT_83_INFO {"STMT_DELETE_ACTUAL_EMPTIES", NULL}
858
#define STMT_DELETE_ACTUAL_EMPTY 83
859
#define STMT_83_INFO {"STMT_DELETE_ACTUAL_EMPTY", NULL}
865
860
#define STMT_83 \
866
861
"DELETE FROM actual_node " \
867
"WHERE wc_id = ?1 " \
868
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
862
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
869
863
" AND properties IS NULL " \
870
864
" AND conflict_data IS NULL " \
871
865
" AND changelist IS NULL " \
875
869
" AND left_checksum IS NULL " \
876
870
""
877
871
878
#define STMT_DELETE_BASE_NODE 84
879
#define STMT_84_INFO {"STMT_DELETE_BASE_NODE", NULL}
872
#define STMT_DELETE_ACTUAL_EMPTIES 84
873
#define STMT_84_INFO {"STMT_DELETE_ACTUAL_EMPTIES", NULL}
880
874
#define STMT_84 \
881
"DELETE FROM nodes " \
882
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \
875
"DELETE FROM actual_node " \
876
"WHERE wc_id = ?1 " \
877
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
878
" AND properties IS NULL " \
879
" AND conflict_data IS NULL " \
880
" AND changelist IS NULL " \
881
" AND text_mod IS NULL " \
882
" AND older_checksum IS NULL " \
883
" AND right_checksum IS NULL " \
884
" AND left_checksum IS NULL " \
883
885
""
884
886
885
#define STMT_DELETE_WORKING_NODE 85
886
#define STMT_85_INFO {"STMT_DELETE_WORKING_NODE", NULL}
887
#define STMT_DELETE_BASE_NODE 85
888
#define STMT_85_INFO {"STMT_DELETE_BASE_NODE", NULL}
887
889
#define STMT_85 \
888
890
"DELETE FROM nodes " \
891
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \
892
""
893
894
#define STMT_DELETE_WORKING_NODE 86
895
#define STMT_86_INFO {"STMT_DELETE_WORKING_NODE", NULL}
896
#define STMT_86 \
897
"DELETE FROM nodes " \
889
898
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
890
899
" AND op_depth = (SELECT MAX(op_depth) FROM nodes " \
891
900
" WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0) " \
892
901
""
893
902
894
#define STMT_DELETE_LOWEST_WORKING_NODE 86
895
#define STMT_86_INFO {"STMT_DELETE_LOWEST_WORKING_NODE", NULL}
896
#define STMT_86 \
903
#define STMT_DELETE_LOWEST_WORKING_NODE 87
904
#define STMT_87_INFO {"STMT_DELETE_LOWEST_WORKING_NODE", NULL}
905
#define STMT_87 \
897
906
"DELETE FROM nodes " \
898
907
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
899
908
" AND op_depth = (SELECT MIN(op_depth) FROM nodes " \
901
910
" AND presence = 'base-deleted' " \
902
911
""
903
912
904
#define STMT_DELETE_ALL_LAYERS 87
905
#define STMT_87_INFO {"STMT_DELETE_ALL_LAYERS", NULL}
906
#define STMT_87 \
907
"DELETE FROM nodes " \
908
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
909
""
910
911
#define STMT_DELETE_NODES_ABOVE_DEPTH_RECURSIVE 88
912
#define STMT_88_INFO {"STMT_DELETE_NODES_ABOVE_DEPTH_RECURSIVE", NULL}
913
#define STMT_DELETE_NODE_ALL_LAYERS 88
914
#define STMT_88_INFO {"STMT_DELETE_NODE_ALL_LAYERS", NULL}
913
915
#define STMT_88 \
914
916
"DELETE FROM nodes " \
915
"WHERE wc_id = ?1 " \
916
" AND (local_relpath = ?2 " \
917
" OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
918
" AND op_depth >= ?3 " \
917
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
919
918
""
920
919
921
#define STMT_DELETE_ACTUAL_NODE 89
922
#define STMT_89_INFO {"STMT_DELETE_ACTUAL_NODE", NULL}
920
#define STMT_DELETE_NODES_ABOVE_DEPTH_RECURSIVE 89
921
#define STMT_89_INFO {"STMT_DELETE_NODES_ABOVE_DEPTH_RECURSIVE", NULL}
923
922
#define STMT_89 \
924
"DELETE FROM actual_node " \
925
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
923
"DELETE FROM nodes " \
924
"WHERE wc_id = ?1 " \
925
" AND (local_relpath = ?2 " \
926
" OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
927
" AND op_depth >= ?3 " \
926
928
""
927
929
928
#define STMT_DELETE_ACTUAL_NODE_RECURSIVE 90
929
#define STMT_90_INFO {"STMT_DELETE_ACTUAL_NODE_RECURSIVE", NULL}
930
#define STMT_DELETE_ACTUAL_NODE 90
931
#define STMT_90_INFO {"STMT_DELETE_ACTUAL_NODE", NULL}
930
932
#define STMT_90 \
931
933
"DELETE FROM actual_node " \
932
"WHERE wc_id = ?1 " \
933
" AND (local_relpath = ?2 " \
934
" OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
934
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
935
935
""
936
936
937
#define STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST 91
938
#define STMT_91_INFO {"STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST", NULL}
937
#define STMT_DELETE_ACTUAL_NODE_RECURSIVE 91
938
#define STMT_91_INFO {"STMT_DELETE_ACTUAL_NODE_RECURSIVE", NULL}
939
939
#define STMT_91 \
940
940
"DELETE FROM actual_node " \
941
941
"WHERE wc_id = ?1 " \
942
" AND (local_relpath = ?2 " \
943
" OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
944
""
945
946
#define STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST 92
947
#define STMT_92_INFO {"STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST", NULL}
948
#define STMT_92 \
949
"DELETE FROM actual_node " \
950
"WHERE wc_id = ?1 " \
942
951
" AND local_relpath = ?2 " \
943
952
" AND (changelist IS NULL " \
944
953
" OR NOT EXISTS (SELECT 1 FROM nodes_current c " \
946
955
" AND c.kind = 'file')) " \
947
956
""
948
957
949
#define STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE 92
950
#define STMT_92_INFO {"STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE", NULL}
951
#define STMT_92 \
958
#define STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE 93
959
#define STMT_93_INFO {"STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE", NULL}
960
#define STMT_93 \
952
961
"DELETE FROM actual_node " \
953
962
"WHERE wc_id = ?1 " \
954
963
" AND (local_relpath = ?2 " \
960
969
" AND c.kind = 'file')) " \
961
970
""
962
971
963
#define STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST 93
964
#define STMT_93_INFO {"STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST", NULL}
965
#define STMT_93 \
966
"UPDATE actual_node " \
967
"SET properties = NULL, " \
968
" text_mod = NULL, " \
969
" conflict_data = NULL, " \
970
" tree_conflict_data = NULL, " \
971
" older_checksum = NULL, " \
972
" left_checksum = NULL, " \
973
" right_checksum = NULL " \
974
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
975
""
976
977
#define STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE 94
978
#define STMT_94_INFO {"STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE", NULL}
972
#define STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST 94
973
#define STMT_94_INFO {"STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST", NULL}
979
974
#define STMT_94 \
980
975
"UPDATE actual_node " \
981
976
"SET properties = NULL, " \
985
980
" older_checksum = NULL, " \
986
981
" left_checksum = NULL, " \
987
982
" right_checksum = NULL " \
988
"WHERE wc_id = ?1 " \
989
" AND (local_relpath = ?2 " \
990
" OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
983
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
991
984
""
992
985
993
#define STMT_UPDATE_NODE_BASE_DEPTH 95
994
#define STMT_95_INFO {"STMT_UPDATE_NODE_BASE_DEPTH", NULL}
986
#define STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE 95
987
#define STMT_95_INFO {"STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE", NULL}
995
988
#define STMT_95 \
989
"UPDATE actual_node " \
990
"SET properties = NULL, " \
991
" text_mod = NULL, " \
992
" conflict_data = NULL, " \
993
" tree_conflict_data = NULL, " \
994
" older_checksum = NULL, " \
995
" left_checksum = NULL, " \
996
" right_checksum = NULL " \
997
"WHERE wc_id = ?1 " \
998
" AND (local_relpath = ?2 " \
999
" OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
1000
""
1001
1002
#define STMT_UPDATE_NODE_BASE_DEPTH 96
1003
#define STMT_96_INFO {"STMT_UPDATE_NODE_BASE_DEPTH", NULL}
1004
#define STMT_96 \
996
1005
"UPDATE nodes SET depth = ?3 " \
997
1006
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \
998
1007
" AND kind='dir' " \
999
1008
""
1000
1009
1001
#define STMT_UPDATE_NODE_BASE_PRESENCE 96
1002
#define STMT_96_INFO {"STMT_UPDATE_NODE_BASE_PRESENCE", NULL}
1003
#define STMT_96 \
1010
#define STMT_UPDATE_NODE_BASE_PRESENCE 97
1011
#define STMT_97_INFO {"STMT_UPDATE_NODE_BASE_PRESENCE", NULL}
1012
#define STMT_97 \
1004
1013
"UPDATE nodes SET presence = ?3 " \
1005
1014
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \
1006
1015
""
1007
1016
1008
#define STMT_UPDATE_BASE_NODE_PRESENCE_REVNUM_AND_REPOS_PATH 97
1009
#define STMT_97_INFO {"STMT_UPDATE_BASE_NODE_PRESENCE_REVNUM_AND_REPOS_PATH", NULL}
1010
#define STMT_97 \
1017
#define STMT_UPDATE_BASE_NODE_PRESENCE_REVNUM_AND_REPOS_PATH 98
1018
#define STMT_98_INFO {"STMT_UPDATE_BASE_NODE_PRESENCE_REVNUM_AND_REPOS_PATH", NULL}
1019
#define STMT_98 \
1011
1020
"UPDATE nodes SET presence = ?3, revision = ?4, repos_path = ?5 " \
1012
1021
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \
1013
1022
""
1014
1023
1015
#define STMT_LOOK_FOR_WORK 98
1016
#define STMT_98_INFO {"STMT_LOOK_FOR_WORK", NULL}
1017
#define STMT_98 \
1024
#define STMT_LOOK_FOR_WORK 99
1025
#define STMT_99_INFO {"STMT_LOOK_FOR_WORK", NULL}
1026
#define STMT_99 \
1018
1027
"SELECT id FROM work_queue LIMIT 1 " \
1019
1028
""
1020
1029
1021
#define STMT_INSERT_WORK_ITEM 99
1022
#define STMT_99_INFO {"STMT_INSERT_WORK_ITEM", NULL}
1023
#define STMT_99 \
1030
#define STMT_INSERT_WORK_ITEM 100
1031
#define STMT_100_INFO {"STMT_INSERT_WORK_ITEM", NULL}
1032
#define STMT_100 \
1024
1033
"INSERT INTO work_queue (work) VALUES (?1) " \
1025
1034
""
1026
1035
1027
#define STMT_SELECT_WORK_ITEM 100
1028
#define STMT_100_INFO {"STMT_SELECT_WORK_ITEM", NULL}
1029
#define STMT_100 \
1036
#define STMT_SELECT_WORK_ITEM 101
1037
#define STMT_101_INFO {"STMT_SELECT_WORK_ITEM", NULL}
1038
#define STMT_101 \
1030
1039
"SELECT id, work FROM work_queue ORDER BY id LIMIT 1 " \
1031
1040
""
1032
1041
1033
#define STMT_DELETE_WORK_ITEM 101
1034
#define STMT_101_INFO {"STMT_DELETE_WORK_ITEM", NULL}
1035
#define STMT_101 \
1042
#define STMT_DELETE_WORK_ITEM 102
1043
#define STMT_102_INFO {"STMT_DELETE_WORK_ITEM", NULL}
1044
#define STMT_102 \
1036
1045
"DELETE FROM work_queue WHERE id = ?1 " \
1037
1046
""
1038
1047
1039
#define STMT_INSERT_OR_IGNORE_PRISTINE 102
1040
#define STMT_102_INFO {"STMT_INSERT_OR_IGNORE_PRISTINE", NULL}
1041
#define STMT_102 \
1048
#define STMT_INSERT_OR_IGNORE_PRISTINE 103
1049
#define STMT_103_INFO {"STMT_INSERT_OR_IGNORE_PRISTINE", NULL}
1050
#define STMT_103 \
1042
1051
"INSERT OR IGNORE INTO pristine (checksum, md5_checksum, size, refcount) " \
1043
1052
"VALUES (?1, ?2, ?3, 0) " \
1044
1053
""
1045
1054
1046
#define STMT_INSERT_PRISTINE 103
1047
#define STMT_103_INFO {"STMT_INSERT_PRISTINE", NULL}
1048
#define STMT_103 \
1055
#define STMT_INSERT_PRISTINE 104
1056
#define STMT_104_INFO {"STMT_INSERT_PRISTINE", NULL}
1057
#define STMT_104 \
1049
1058
"INSERT INTO pristine (checksum, md5_checksum, size, refcount) " \
1050
1059
"VALUES (?1, ?2, ?3, 0) " \
1051
1060
""
1052
1061
1053
#define STMT_SELECT_PRISTINE 104
1054
#define STMT_104_INFO {"STMT_SELECT_PRISTINE", NULL}
1055
#define STMT_104 \
1062
#define STMT_SELECT_PRISTINE 105
1063
#define STMT_105_INFO {"STMT_SELECT_PRISTINE", NULL}
1064
#define STMT_105 \
1056
1065
"SELECT md5_checksum " \
1057
1066
"FROM pristine " \
1058
1067
"WHERE checksum = ?1 " \
1059
1068
""
1060
1069
1061
#define STMT_SELECT_PRISTINE_SIZE 105
1062
#define STMT_105_INFO {"STMT_SELECT_PRISTINE_SIZE", NULL}
1063
#define STMT_105 \
1070
#define STMT_SELECT_PRISTINE_SIZE 106
1071
#define STMT_106_INFO {"STMT_SELECT_PRISTINE_SIZE", NULL}
1072
#define STMT_106 \
1064
1073
"SELECT size " \
1065
1074
"FROM pristine " \
1066
1075
"WHERE checksum = ?1 LIMIT 1 " \
1067
1076
""
1068
1077
1069
#define STMT_SELECT_PRISTINE_BY_MD5 106
1070
#define STMT_106_INFO {"STMT_SELECT_PRISTINE_BY_MD5", NULL}
1071
#define STMT_106 \
1078
#define STMT_SELECT_PRISTINE_BY_MD5 107
1079
#define STMT_107_INFO {"STMT_SELECT_PRISTINE_BY_MD5", NULL}
1080
#define STMT_107 \
1072
1081
"SELECT checksum " \
1073
1082
"FROM pristine " \
1074
1083
"WHERE md5_checksum = ?1 " \
1075
1084
""
1076
1085
1077
#define STMT_SELECT_UNREFERENCED_PRISTINES 107
1078
#define STMT_107_INFO {"STMT_SELECT_UNREFERENCED_PRISTINES", NULL}
1079
#define STMT_107 \
1086
#define STMT_SELECT_UNREFERENCED_PRISTINES 108
1087
#define STMT_108_INFO {"STMT_SELECT_UNREFERENCED_PRISTINES", NULL}
1088
#define STMT_108 \
1080
1089
"SELECT checksum " \
1081
1090
"FROM pristine " \
1082
1091
"WHERE refcount = 0 " \
1083
1092
""
1084
1093
1085
#define STMT_DELETE_PRISTINE_IF_UNREFERENCED 108
1086
#define STMT_108_INFO {"STMT_DELETE_PRISTINE_IF_UNREFERENCED", NULL}
1087
#define STMT_108 \
1094
#define STMT_DELETE_PRISTINE_IF_UNREFERENCED 109
1095
#define STMT_109_INFO {"STMT_DELETE_PRISTINE_IF_UNREFERENCED", NULL}
1096
#define STMT_109 \
1088
1097
"DELETE FROM pristine " \
1089
1098
"WHERE checksum = ?1 AND refcount = 0 " \
1090
1099
""
1091
1100
1092
#define STMT_SELECT_COPY_PRISTINES 109
1093
#define STMT_109_INFO {"STMT_SELECT_COPY_PRISTINES", NULL}
1094
#define STMT_109 \
1101
#define STMT_SELECT_COPY_PRISTINES 110
1102
#define STMT_110_INFO {"STMT_SELECT_COPY_PRISTINES", NULL}
1103
#define STMT_110 \
1095
1104
"SELECT n.checksum, md5_checksum, size " \
1096
1105
"FROM nodes_current n " \
1097
1106
"LEFT JOIN pristine p ON n.checksum = p.checksum " \
1109
1118
" AND n.checksum IS NOT NULL " \
1110
1119
""
1111
1120
1112
#define STMT_VACUUM 110
1113
#define STMT_110_INFO {"STMT_VACUUM", NULL}
1114
#define STMT_110 \
1121
#define STMT_VACUUM 111
1122
#define STMT_111_INFO {"STMT_VACUUM", NULL}
1123
#define STMT_111 \
1115
1124
"VACUUM " \
1116
1125
""
1117
1126
1118
#define STMT_SELECT_CONFLICT_VICTIMS 111
1119
#define STMT_111_INFO {"STMT_SELECT_CONFLICT_VICTIMS", NULL}
1120
#define STMT_111 \
1127
#define STMT_SELECT_CONFLICT_VICTIMS 112
1128
#define STMT_112_INFO {"STMT_SELECT_CONFLICT_VICTIMS", NULL}
1129
#define STMT_112 \
1121
1130
"SELECT local_relpath, conflict_data " \
1122
1131
"FROM actual_node " \
1123
1132
"WHERE wc_id = ?1 AND parent_relpath = ?2 AND " \
1124
1133
" NOT (conflict_data IS NULL) " \
1125
1134
""
1126
1135
1127
#define STMT_INSERT_WC_LOCK 112
1128
#define STMT_112_INFO {"STMT_INSERT_WC_LOCK", NULL}
1129
#define STMT_112 \
1136
#define STMT_INSERT_WC_LOCK 113
1137
#define STMT_113_INFO {"STMT_INSERT_WC_LOCK", NULL}
1138
#define STMT_113 \
1130
1139
"INSERT INTO wc_lock (wc_id, local_dir_relpath, locked_levels) " \
1131
1140
"VALUES (?1, ?2, ?3) " \
1132
1141
""
1133
1142
1134
#define STMT_SELECT_WC_LOCK 113
1135
#define STMT_113_INFO {"STMT_SELECT_WC_LOCK", NULL}
1136
#define STMT_113 \
1143
#define STMT_SELECT_WC_LOCK 114
1144
#define STMT_114_INFO {"STMT_SELECT_WC_LOCK", NULL}
1145
#define STMT_114 \
1137
1146
"SELECT locked_levels FROM wc_lock " \
1138
1147
"WHERE wc_id = ?1 AND local_dir_relpath = ?2 " \
1139
1148
""
1140
1149
1141
#define STMT_SELECT_ANCESTOR_WCLOCKS 114
1142
#define STMT_114_INFO {"STMT_SELECT_ANCESTOR_WCLOCKS", NULL}
1143
#define STMT_114 \
1150
#define STMT_SELECT_ANCESTOR_WCLOCKS 115
1151
#define STMT_115_INFO {"STMT_SELECT_ANCESTOR_WCLOCKS", NULL}
1152
#define STMT_115 \
1144
1153
"SELECT local_dir_relpath, locked_levels FROM wc_lock " \
1145
1154
"WHERE wc_id = ?1 " \
1146
1155
" AND ((local_dir_relpath >= ?3 AND local_dir_relpath <= ?2) " \
1147
1156
" OR local_dir_relpath = '') " \
1148
1157
""
1149
1158
1150
#define STMT_DELETE_WC_LOCK 115
1151
#define STMT_115_INFO {"STMT_DELETE_WC_LOCK", NULL}
1152
#define STMT_115 \
1153
"DELETE FROM wc_lock " \
1154
"WHERE wc_id = ?1 AND local_dir_relpath = ?2 " \
1155
""
1156
1157
#define STMT_FIND_WC_LOCK 116
1158
#define STMT_116_INFO {"STMT_FIND_WC_LOCK", NULL}
1159
#define STMT_DELETE_WC_LOCK 116
1160
#define STMT_116_INFO {"STMT_DELETE_WC_LOCK", NULL}
1159
1161
#define STMT_116 \
1162
"DELETE FROM wc_lock " \
1163
"WHERE wc_id = ?1 AND local_dir_relpath = ?2 " \
1164
""
1165
1166
#define STMT_FIND_WC_LOCK 117
1167
#define STMT_117_INFO {"STMT_FIND_WC_LOCK", NULL}
1168
#define STMT_117 \
1160
1169
"SELECT local_dir_relpath FROM wc_lock " \
1161
1170
"WHERE wc_id = ?1 " \
1162
1171
" AND (((local_dir_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_dir_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1163
1172
""
1164
1173
1165
#define STMT_DELETE_WC_LOCK_ORPHAN 117
1166
#define STMT_117_INFO {"STMT_DELETE_WC_LOCK_ORPHAN", NULL}
1167
#define STMT_117 \
1174
#define STMT_DELETE_WC_LOCK_ORPHAN 118
1175
#define STMT_118_INFO {"STMT_DELETE_WC_LOCK_ORPHAN", NULL}
1176
#define STMT_118 \
1168
1177
"DELETE FROM wc_lock " \
1169
1178
"WHERE wc_id = ?1 AND local_dir_relpath = ?2 " \
1170
1179
"AND NOT EXISTS (SELECT 1 FROM nodes " \
1172
1181
" AND nodes.local_relpath = wc_lock.local_dir_relpath) " \
1173
1182
""
1174
1183
1175
#define STMT_DELETE_WC_LOCK_ORPHAN_RECURSIVE 118
1176
#define STMT_118_INFO {"STMT_DELETE_WC_LOCK_ORPHAN_RECURSIVE", NULL}
1177
#define STMT_118 \
1184
#define STMT_DELETE_WC_LOCK_ORPHAN_RECURSIVE 119
1185
#define STMT_119_INFO {"STMT_DELETE_WC_LOCK_ORPHAN_RECURSIVE", NULL}
1186
#define STMT_119 \
1178
1187
"DELETE FROM wc_lock " \
1179
1188
"WHERE wc_id = ?1 " \
1180
1189
" AND (local_dir_relpath = ?2 " \
1184
1193
" AND nodes.local_relpath = wc_lock.local_dir_relpath) " \
1185
1194
""
1186
1195
1187
#define STMT_APPLY_CHANGES_TO_BASE_NODE 119
1188
#define STMT_119_INFO {"STMT_APPLY_CHANGES_TO_BASE_NODE", NULL}
1189
#define STMT_119 \
1196
#define STMT_APPLY_CHANGES_TO_BASE_NODE 120
1197
#define STMT_120_INFO {"STMT_APPLY_CHANGES_TO_BASE_NODE", NULL}
1198
#define STMT_120 \
1190
1199
"INSERT OR REPLACE INTO nodes ( " \
1191
1200
" wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, " \
1192
1201
" revision, presence, depth, kind, changed_revision, changed_date, " \
1200
1209
" AND op_depth = 0)) " \
1201
1210
""
1202
1211
1203
#define STMT_INSTALL_WORKING_NODE_FOR_DELETE 120
1204
#define STMT_120_INFO {"STMT_INSTALL_WORKING_NODE_FOR_DELETE", NULL}
1205
#define STMT_120 \
1212
#define STMT_INSTALL_WORKING_NODE_FOR_DELETE 121
1213
#define STMT_121_INFO {"STMT_INSTALL_WORKING_NODE_FOR_DELETE", NULL}
1214
#define STMT_121 \
1206
1215
"INSERT OR REPLACE INTO nodes ( " \
1207
1216
" wc_id, local_relpath, op_depth, " \
1208
1217
" parent_relpath, presence, kind) " \
1209
1218
"VALUES(?1, ?2, ?3, ?4, 'base-deleted', ?5) " \
1210
1219
""
1211
1220
1212
#define STMT_DELETE_NO_LOWER_LAYER 121
1213
#define STMT_121_INFO {"STMT_DELETE_NO_LOWER_LAYER", NULL}
1214
#define STMT_121 \
1221
#define STMT_DELETE_NO_LOWER_LAYER 122
1222
#define STMT_122_INFO {"STMT_DELETE_NO_LOWER_LAYER", NULL}
1223
#define STMT_122 \
1215
1224
"DELETE FROM nodes " \
1216
1225
" WHERE wc_id = ?1 " \
1217
1226
" AND (local_relpath = ?2 OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
1223
1232
" AND n.presence IN ('normal', 'incomplete')) " \
1224
1233
""
1225
1234
1226
#define STMT_REPLACE_WITH_BASE_DELETED 122
1227
#define STMT_122_INFO {"STMT_REPLACE_WITH_BASE_DELETED", NULL}
1228
#define STMT_122 \
1235
#define STMT_REPLACE_WITH_BASE_DELETED 123
1236
#define STMT_123_INFO {"STMT_REPLACE_WITH_BASE_DELETED", NULL}
1237
#define STMT_123 \
1229
1238
"INSERT OR REPLACE INTO nodes (wc_id, local_relpath, op_depth, parent_relpath, " \
1230
1239
" kind, moved_to, presence) " \
1231
1240
"SELECT wc_id, local_relpath, op_depth, parent_relpath, " \
1236
1245
" AND op_depth = ?3 " \
1237
1246
""
1238
1247
1239
#define STMT_INSERT_DELETE_FROM_NODE_RECURSIVE 123
1240
#define STMT_123_INFO {"STMT_INSERT_DELETE_FROM_NODE_RECURSIVE", NULL}
1241
#define STMT_123 \
1248
#define STMT_INSERT_DELETE_FROM_NODE_RECURSIVE 124
1249
#define STMT_124_INFO {"STMT_INSERT_DELETE_FROM_NODE_RECURSIVE", NULL}
1250
#define STMT_124 \
1242
1251
"INSERT INTO nodes ( " \
1243
1252
" wc_id, local_relpath, op_depth, parent_relpath, presence, kind) " \
1244
1253
"SELECT wc_id, local_relpath, ?4 , parent_relpath, 'base-deleted', " \
1252
1261
" AND file_external IS NULL " \
1253
1262
""
1254
1263
1255
#define STMT_INSERT_WORKING_NODE_FROM_BASE_COPY 124
1256
#define STMT_124_INFO {"STMT_INSERT_WORKING_NODE_FROM_BASE_COPY", NULL}
1257
#define STMT_124 \
1264
#define STMT_INSERT_WORKING_NODE_FROM_BASE_COPY 125
1265
#define STMT_125_INFO {"STMT_INSERT_WORKING_NODE_FROM_BASE_COPY", NULL}
1266
#define STMT_125 \
1258
1267
"INSERT INTO nodes ( " \
1259
1268
" wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, " \
1260
1269
" revision, presence, depth, kind, changed_revision, changed_date, " \
1268
1277
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \
1269
1278
""
1270
1279
1271
#define STMT_INSERT_DELETE_FROM_BASE 125
1272
#define STMT_125_INFO {"STMT_INSERT_DELETE_FROM_BASE", NULL}
1273
#define STMT_125 \
1280
#define STMT_INSERT_DELETE_FROM_BASE 126
1281
#define STMT_126_INFO {"STMT_INSERT_DELETE_FROM_BASE", NULL}
1282
#define STMT_126 \
1274
1283
"INSERT INTO nodes ( " \
1275
1284
" wc_id, local_relpath, op_depth, parent_relpath, presence, kind) " \
1276
1285
"SELECT wc_id, local_relpath, ?3 , parent_relpath, " \
1279
1288
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \
1280
1289
""
1281
1290
1282
#define STMT_UPDATE_OP_DEPTH_INCREASE_RECURSIVE 126
1283
#define STMT_126_INFO {"STMT_UPDATE_OP_DEPTH_INCREASE_RECURSIVE", NULL}
1284
#define STMT_126 \
1291
#define STMT_UPDATE_OP_DEPTH_INCREASE_RECURSIVE 127
1292
#define STMT_127_INFO {"STMT_UPDATE_OP_DEPTH_INCREASE_RECURSIVE", NULL}
1293
#define STMT_127 \
1285
1294
"UPDATE nodes SET op_depth = ?3 + 1 " \
1286
1295
"WHERE wc_id = ?1 " \
1287
1296
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1288
1297
" AND op_depth = ?3 " \
1289
1298
""
1290
1299
1291
#define STMT_UPDATE_OP_DEPTH_RECURSIVE 127
1292
#define STMT_127_INFO {"STMT_UPDATE_OP_DEPTH_RECURSIVE", NULL}
1293
#define STMT_127 \
1300
#define STMT_UPDATE_OP_DEPTH_RECURSIVE 128
1301
#define STMT_128_INFO {"STMT_UPDATE_OP_DEPTH_RECURSIVE", NULL}
1302
#define STMT_128 \
1294
1303
"UPDATE nodes SET op_depth = ?4, moved_here = NULL " \
1295
1304
"WHERE wc_id = ?1 " \
1296
1305
" AND (local_relpath = ?2 OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
1297
1306
" AND op_depth = ?3 " \
1298
1307
""
1299
1308
1300
#define STMT_DOES_NODE_EXIST 128
1301
#define STMT_128_INFO {"STMT_DOES_NODE_EXIST", NULL}
1302
#define STMT_128 \
1309
#define STMT_DOES_NODE_EXIST 129
1310
#define STMT_129_INFO {"STMT_DOES_NODE_EXIST", NULL}
1311
#define STMT_129 \
1303
1312
"SELECT 1 FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 " \
1304
1313
"LIMIT 1 " \
1305
1314
""
1306
1315
1307
#define STMT_HAS_SERVER_EXCLUDED_DESCENDANTS 129
1308
#define STMT_129_INFO {"STMT_HAS_SERVER_EXCLUDED_DESCENDANTS", NULL}
1309
#define STMT_129 \
1316
#define STMT_HAS_SERVER_EXCLUDED_DESCENDANTS 130
1317
#define STMT_130_INFO {"STMT_HAS_SERVER_EXCLUDED_DESCENDANTS", NULL}
1318
#define STMT_130 \
1310
1319
"SELECT local_relpath FROM nodes " \
1311
1320
"WHERE wc_id = ?1 " \
1312
1321
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1314
1323
"LIMIT 1 " \
1315
1324
""
1316
1325
1317
#define STMT_SELECT_ALL_EXCLUDED_DESCENDANTS 130
1318
#define STMT_130_INFO {"STMT_SELECT_ALL_EXCLUDED_DESCENDANTS", NULL}
1319
#define STMT_130 \
1326
#define STMT_SELECT_ALL_EXCLUDED_DESCENDANTS 131
1327
#define STMT_131_INFO {"STMT_SELECT_ALL_EXCLUDED_DESCENDANTS", NULL}
1328
#define STMT_131 \
1320
1329
"SELECT local_relpath FROM nodes " \
1321
1330
"WHERE wc_id = ?1 " \
1322
1331
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1324
1333
" AND (presence = 'server-excluded' OR presence = 'excluded') " \
1325
1334
""
1326
1335
1327
#define STMT_INSERT_WORKING_NODE_COPY_FROM 131
1328
#define STMT_131_INFO {"STMT_INSERT_WORKING_NODE_COPY_FROM", NULL}
1329
#define STMT_131 \
1336
#define STMT_INSERT_WORKING_NODE_COPY_FROM 132
1337
#define STMT_132_INFO {"STMT_INSERT_WORKING_NODE_COPY_FROM", NULL}
1338
#define STMT_132 \
1330
1339
"INSERT OR REPLACE INTO nodes ( " \
1331
1340
" wc_id, local_relpath, op_depth, parent_relpath, repos_id, " \
1332
1341
" repos_path, revision, presence, depth, moved_here, kind, changed_revision, " \
1345
1354
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
1346
1355
""
1347
1356
1348
#define STMT_INSERT_WORKING_NODE_COPY_FROM_DEPTH 132
1349
#define STMT_132_INFO {"STMT_INSERT_WORKING_NODE_COPY_FROM_DEPTH", NULL}
1350
#define STMT_132 \
1357
#define STMT_INSERT_WORKING_NODE_COPY_FROM_DEPTH 133
1358
#define STMT_133_INFO {"STMT_INSERT_WORKING_NODE_COPY_FROM_DEPTH", NULL}
1359
#define STMT_133 \
1351
1360
"INSERT OR REPLACE INTO nodes ( " \
1352
1361
" wc_id, local_relpath, op_depth, parent_relpath, repos_id, " \
1353
1362
" repos_path, revision, presence, depth, moved_here, kind, changed_revision, " \
1366
1375
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?7 " \
1367
1376
""
1368
1377
1369
#define STMT_UPDATE_BASE_REVISION 133
1370
#define STMT_133_INFO {"STMT_UPDATE_BASE_REVISION", NULL}
1371
#define STMT_133 \
1378
#define STMT_UPDATE_BASE_REVISION 134
1379
#define STMT_134_INFO {"STMT_UPDATE_BASE_REVISION", NULL}
1380
#define STMT_134 \
1372
1381
"UPDATE nodes SET revision = ?3 " \
1373
1382
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \
1374
1383
""
1375
1384
1376
#define STMT_UPDATE_BASE_REPOS 134
1377
#define STMT_134_INFO {"STMT_UPDATE_BASE_REPOS", NULL}
1378
#define STMT_134 \
1385
#define STMT_UPDATE_BASE_REPOS 135
1386
#define STMT_135_INFO {"STMT_UPDATE_BASE_REPOS", NULL}
1387
#define STMT_135 \
1379
1388
"UPDATE nodes SET repos_id = ?3, repos_path = ?4 " \
1380
1389
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \
1381
1390
""
1382
1391
1383
#define STMT_ACTUAL_HAS_CHILDREN 135
1384
#define STMT_135_INFO {"STMT_ACTUAL_HAS_CHILDREN", NULL}
1385
#define STMT_135 \
1386
"SELECT 1 FROM actual_node " \
1387
"WHERE wc_id = ?1 AND parent_relpath = ?2 " \
1388
"LIMIT 1 " \
1389
""
1390
1391
#define STMT_INSERT_EXTERNAL 136
1392
#define STMT_136_INFO {"STMT_INSERT_EXTERNAL", NULL}
1392
#define STMT_ACTUAL_HAS_CHILDREN 136
1393
#define STMT_136_INFO {"STMT_ACTUAL_HAS_CHILDREN", NULL}
1393
1394
#define STMT_136 \
1395
"SELECT 1 FROM actual_node " \
1396
"WHERE wc_id = ?1 AND parent_relpath = ?2 " \
1397
"LIMIT 1 " \
1398
""
1399
1400
#define STMT_INSERT_EXTERNAL 137
1401
#define STMT_137_INFO {"STMT_INSERT_EXTERNAL", NULL}
1402
#define STMT_137 \
1394
1403
"INSERT OR REPLACE INTO externals ( " \
1395
1404
" wc_id, local_relpath, parent_relpath, presence, kind, def_local_relpath, " \
1396
1405
" repos_id, def_repos_relpath, def_operational_revision, def_revision) " \
1397
1406
"VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10) " \
1398
1407
""
1399
1408
1400
#define STMT_SELECT_EXTERNAL_INFO 137
1401
#define STMT_137_INFO {"STMT_SELECT_EXTERNAL_INFO", NULL}
1402
#define STMT_137 \
1409
#define STMT_SELECT_EXTERNAL_INFO 138
1410
#define STMT_138_INFO {"STMT_SELECT_EXTERNAL_INFO", NULL}
1411
#define STMT_138 \
1403
1412
"SELECT presence, kind, def_local_relpath, repos_id, " \
1404
1413
" def_repos_relpath, def_operational_revision, def_revision " \
1405
1414
"FROM externals WHERE wc_id = ?1 AND local_relpath = ?2 " \
1406
1415
"LIMIT 1 " \
1407
1416
""
1408
1417
1409
#define STMT_DELETE_FILE_EXTERNALS 138
1410
#define STMT_138_INFO {"STMT_DELETE_FILE_EXTERNALS", NULL}
1411
#define STMT_138 \
1418
#define STMT_DELETE_FILE_EXTERNALS 139
1419
#define STMT_139_INFO {"STMT_DELETE_FILE_EXTERNALS", NULL}
1420
#define STMT_139 \
1412
1421
"DELETE FROM nodes " \
1413
1422
"WHERE wc_id = ?1 " \
1414
1423
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1416
1425
" AND file_external IS NOT NULL " \
1417
1426
""
1418
1427
1419
#define STMT_DELETE_FILE_EXTERNAL_REGISTATIONS 139
1420
#define STMT_139_INFO {"STMT_DELETE_FILE_EXTERNAL_REGISTATIONS", NULL}
1421
#define STMT_139 \
1428
#define STMT_DELETE_FILE_EXTERNAL_REGISTATIONS 140
1429
#define STMT_140_INFO {"STMT_DELETE_FILE_EXTERNAL_REGISTATIONS", NULL}
1430
#define STMT_140 \
1422
1431
"DELETE FROM externals " \
1423
1432
"WHERE wc_id = ?1 " \
1424
1433
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1425
1434
" AND kind != 'dir' " \
1426
1435
""
1427
1436
1428
#define STMT_DELETE_EXTERNAL_REGISTATIONS 140
1429
#define STMT_140_INFO {"STMT_DELETE_EXTERNAL_REGISTATIONS", NULL}
1430
#define STMT_140 \
1431
"DELETE FROM externals " \
1432
"WHERE wc_id = ?1 " \
1433
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1434
""
1435
1436
#define STMT_SELECT_COMMITTABLE_EXTERNALS_BELOW 141
1437
#define STMT_141_INFO {"STMT_SELECT_COMMITTABLE_EXTERNALS_BELOW", NULL}
1437
#define STMT_DELETE_EXTERNAL_REGISTATIONS 141
1438
#define STMT_141_INFO {"STMT_DELETE_EXTERNAL_REGISTATIONS", NULL}
1438
1439
#define STMT_141 \
1440
"DELETE FROM externals " \
1441
"WHERE wc_id = ?1 " \
1442
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1443
""
1444
1445
#define STMT_SELECT_COMMITTABLE_EXTERNALS_BELOW 142
1446
#define STMT_142_INFO {"STMT_SELECT_COMMITTABLE_EXTERNALS_BELOW", NULL}
1447
#define STMT_142 \
1439
1448
"SELECT local_relpath, kind, def_repos_relpath, " \
1440
1449
" (SELECT root FROM repository AS r WHERE r.id = e.repos_id) " \
1441
1450
"FROM externals e " \
1453
1462
" AND nodes.local_relpath = e.parent_relpath)) " \
1454
1463
""
1455
1464
1456
#define STMT_SELECT_COMMITTABLE_EXTERNALS_IMMEDIATELY_BELOW 142
1457
#define STMT_142_INFO {"STMT_SELECT_COMMITTABLE_EXTERNALS_IMMEDIATELY_BELOW", NULL}
1458
#define STMT_142 \
1465
#define STMT_SELECT_COMMITTABLE_EXTERNALS_IMMEDIATELY_BELOW 143
1466
#define STMT_143_INFO {"STMT_SELECT_COMMITTABLE_EXTERNALS_IMMEDIATELY_BELOW", NULL}
1467
#define STMT_143 \
1459
1468
"SELECT local_relpath, kind, def_repos_relpath, " \
1460
1469
" (SELECT root FROM repository AS r WHERE r.id = e.repos_id) " \
1461
1470
"FROM externals e " \
1474
1483
" AND nodes.local_relpath = e.parent_relpath)) " \
1475
1484
""
1476
1485
1477
#define STMT_SELECT_EXTERNALS_DEFINED 143
1478
#define STMT_143_INFO {"STMT_SELECT_EXTERNALS_DEFINED", NULL}
1479
#define STMT_143 \
1486
#define STMT_SELECT_EXTERNALS_DEFINED 144
1487
#define STMT_144_INFO {"STMT_SELECT_EXTERNALS_DEFINED", NULL}
1488
#define STMT_144 \
1480
1489
"SELECT local_relpath, def_local_relpath " \
1481
1490
"FROM externals " \
1482
1491
"WHERE (wc_id = ?1 AND def_local_relpath = ?2) " \
1483
1492
" OR (wc_id = ?1 AND (((def_local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((def_local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
1484
1493
""
1485
1494
1486
#define STMT_DELETE_EXTERNAL 144
1487
#define STMT_144_INFO {"STMT_DELETE_EXTERNAL", NULL}
1488
#define STMT_144 \
1489
"DELETE FROM externals " \
1490
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
1491
""
1492
1493
#define STMT_SELECT_EXTERNAL_PROPERTIES 145
1494
#define STMT_145_INFO {"STMT_SELECT_EXTERNAL_PROPERTIES", NULL}
1495
#define STMT_DELETE_EXTERNAL 145
1496
#define STMT_145_INFO {"STMT_DELETE_EXTERNAL", NULL}
1495
1497
#define STMT_145 \
1496
"SELECT IFNULL((SELECT properties FROM actual_node a " \
1497
" WHERE a.wc_id = ?1 AND A.local_relpath = n.local_relpath), " \
1498
" properties), " \
1499
" local_relpath, depth " \
1500
"FROM nodes_current n " \
1498
"DELETE FROM externals " \
1501
1499
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
1502
" AND kind = 'dir' AND presence IN ('normal', 'incomplete') " \
1503
"UNION ALL " \
1504
"SELECT IFNULL((SELECT properties FROM actual_node a " \
1505
" WHERE a.wc_id = ?1 AND A.local_relpath = n.local_relpath), " \
1506
" properties), " \
1507
" local_relpath, depth " \
1508
"FROM nodes_current n " \
1509
"WHERE wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1510
" AND kind = 'dir' AND presence IN ('normal', 'incomplete') " \
1511
1500
""
1512
1501
1513
#define STMT_SELECT_CURRENT_PROPS_RECURSIVE 146
1514
#define STMT_146_INFO {"STMT_SELECT_CURRENT_PROPS_RECURSIVE", NULL}
1502
#define STMT_SELECT_EXTERNAL_PROPERTIES 146
1503
#define STMT_146_INFO {"STMT_SELECT_EXTERNAL_PROPERTIES", NULL}
1515
1504
#define STMT_146 \
1516
1505
"SELECT IFNULL((SELECT properties FROM actual_node a " \
1517
1506
" WHERE a.wc_id = ?1 AND A.local_relpath = n.local_relpath), " \
1518
1507
" properties), " \
1508
" local_relpath, depth " \
1509
"FROM nodes_current n " \
1510
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
1511
" AND kind = 'dir' AND presence IN ('normal', 'incomplete') " \
1512
"UNION ALL " \
1513
"SELECT IFNULL((SELECT properties FROM actual_node a " \
1514
" WHERE a.wc_id = ?1 AND A.local_relpath = n.local_relpath), " \
1515
" properties), " \
1516
" local_relpath, depth " \
1517
"FROM nodes_current n " \
1518
"WHERE wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1519
" AND kind = 'dir' AND presence IN ('normal', 'incomplete') " \
1520
""
1521
1522
#define STMT_SELECT_CURRENT_PROPS_RECURSIVE 147
1523
#define STMT_147_INFO {"STMT_SELECT_CURRENT_PROPS_RECURSIVE", NULL}
1524
#define STMT_147 \
1525
"SELECT IFNULL((SELECT properties FROM actual_node a " \
1526
" WHERE a.wc_id = ?1 AND A.local_relpath = n.local_relpath), " \
1527
" properties), " \
1519
1528
" local_relpath " \
1520
1529
"FROM nodes_current n " \
1521
1530
"WHERE (wc_id = ?1 AND local_relpath = ?2) " \
1522
1531
" OR (wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
1523
1532
""
1524
1533
1525
#define STMT_PRAGMA_LOCKING_MODE 147
1526
#define STMT_147_INFO {"STMT_PRAGMA_LOCKING_MODE", NULL}
1527
#define STMT_147 \
1534
#define STMT_PRAGMA_LOCKING_MODE 148
1535
#define STMT_148_INFO {"STMT_PRAGMA_LOCKING_MODE", NULL}
1536
#define STMT_148 \
1528
1537
"PRAGMA locking_mode = exclusive " \
1529
1538
""
1530
1539
1531
#define STMT_INSERT_ACTUAL_NODE 148
1532
#define STMT_148_INFO {"STMT_INSERT_ACTUAL_NODE", NULL}
1533
#define STMT_148 \
1540
#define STMT_INSERT_ACTUAL_NODE 149
1541
#define STMT_149_INFO {"STMT_INSERT_ACTUAL_NODE", NULL}
1542
#define STMT_149 \
1534
1543
"INSERT OR REPLACE INTO actual_node ( " \
1535
1544
" wc_id, local_relpath, parent_relpath, properties, changelist, conflict_data) " \
1536
1545
"VALUES (?1, ?2, ?3, ?4, ?5, ?6) " \
1537
1546
""
1538
1547
1539
#define STMT_UPDATE_ACTUAL_CONFLICT_DATA 149
1540
#define STMT_149_INFO {"STMT_UPDATE_ACTUAL_CONFLICT_DATA", NULL}
1541
#define STMT_149 \
1542
"UPDATE actual_node SET conflict_data = ?3 " \
1543
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
1544
""
1545
1546
#define STMT_INSERT_ACTUAL_CONFLICT_DATA 150
1547
#define STMT_150_INFO {"STMT_INSERT_ACTUAL_CONFLICT_DATA", NULL}
1548
#define STMT_UPDATE_ACTUAL_CONFLICT_DATA 150
1549
#define STMT_150_INFO {"STMT_UPDATE_ACTUAL_CONFLICT_DATA", NULL}
1548
1550
#define STMT_150 \
1549
"INSERT INTO actual_node (wc_id, local_relpath, conflict_data, parent_relpath) " \
1550
"VALUES (?1, ?2, ?3, ?4) " \
1551
"UPDATE actual_node SET conflict_data = ?3 " \
1552
"WHERE wc_id = ?1 AND local_relpath = ?2 " \
1551
1553
""
1552
1554
1553
#define STMT_SELECT_ALL_FILES 151
1554
#define STMT_151_INFO {"STMT_SELECT_ALL_FILES", NULL}
1555
#define STMT_INSERT_ACTUAL_CONFLICT_DATA 151
1556
#define STMT_151_INFO {"STMT_INSERT_ACTUAL_CONFLICT_DATA", NULL}
1555
1557
#define STMT_151 \
1558
"INSERT INTO actual_node (wc_id, local_relpath, conflict_data, parent_relpath) " \
1559
"VALUES (?1, ?2, ?3, ?4) " \
1560
""
1561
1562
#define STMT_SELECT_ALL_FILES 152
1563
#define STMT_152_INFO {"STMT_SELECT_ALL_FILES", NULL}
1564
#define STMT_152 \
1556
1565
"SELECT local_relpath FROM nodes_current " \
1557
1566
"WHERE wc_id = ?1 AND parent_relpath = ?2 AND kind = 'file' " \
1558
1567
""
1559
1568
1560
#define STMT_UPDATE_NODE_PROPS 152
1561
#define STMT_152_INFO {"STMT_UPDATE_NODE_PROPS", NULL}
1562
#define STMT_152 \
1569
#define STMT_UPDATE_NODE_PROPS 153
1570
#define STMT_153_INFO {"STMT_UPDATE_NODE_PROPS", NULL}
1571
#define STMT_153 \
1563
1572
"UPDATE nodes SET properties = ?4 " \
1564
1573
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \
1565
1574
""
1566
1575
1567
#define STMT_PRAGMA_TABLE_INFO_NODES 153
1568
#define STMT_153_INFO {"STMT_PRAGMA_TABLE_INFO_NODES", NULL}
1569
#define STMT_153 \
1576
#define STMT_PRAGMA_TABLE_INFO_NODES 154
1577
#define STMT_154_INFO {"STMT_PRAGMA_TABLE_INFO_NODES", NULL}
1578
#define STMT_154 \
1570
1579
"PRAGMA table_info(\"NODES\") " \
1571
1580
""
1572
1581
1573
#define STMT_CREATE_TARGET_PROP_CACHE 154
1574
#define STMT_154_INFO {"STMT_CREATE_TARGET_PROP_CACHE", NULL}
1575
#define STMT_154 \
1582
#define STMT_CREATE_TARGET_PROP_CACHE 155
1583
#define STMT_155_INFO {"STMT_CREATE_TARGET_PROP_CACHE", NULL}
1584
#define STMT_155 \
1576
1585
"DROP TABLE IF EXISTS target_prop_cache; " \
1577
1586
"CREATE TEMPORARY TABLE target_prop_cache ( " \
1578
1587
" local_relpath TEXT NOT NULL PRIMARY KEY, " \
1581
1590
"); " \
1582
1591
""
1583
1592
1584
#define STMT_CACHE_TARGET_PROPS 155
1585
#define STMT_155_INFO {"STMT_CACHE_TARGET_PROPS", NULL}
1586
#define STMT_155 \
1593
#define STMT_CACHE_TARGET_PROPS 156
1594
#define STMT_156_INFO {"STMT_CACHE_TARGET_PROPS", NULL}
1595
#define STMT_156 \
1587
1596
"INSERT INTO target_prop_cache(local_relpath, kind, properties) " \
1588
1597
" SELECT n.local_relpath, n.kind, " \
1589
1598
" IFNULL((SELECT properties FROM actual_node AS a " \
1602
1611
" ORDER BY t.local_relpath " \
1603
1612
""
1604
1613
1605
#define STMT_CACHE_TARGET_PRISTINE_PROPS 156
1606
#define STMT_156_INFO {"STMT_CACHE_TARGET_PRISTINE_PROPS", NULL}
1607
#define STMT_156 \
1614
#define STMT_CACHE_TARGET_PRISTINE_PROPS 157
1615
#define STMT_157_INFO {"STMT_CACHE_TARGET_PRISTINE_PROPS", NULL}
1616
#define STMT_157 \
1608
1617
"INSERT INTO target_prop_cache(local_relpath, kind, properties) " \
1609
1618
" SELECT n.local_relpath, n.kind, " \
1610
1619
" CASE n.presence " \
1629
1638
" ORDER BY t.local_relpath " \
1630
1639
""
1631
1640
1632
#define STMT_SELECT_ALL_TARGET_PROP_CACHE 157
1633
#define STMT_157_INFO {"STMT_SELECT_ALL_TARGET_PROP_CACHE", NULL}
1634
#define STMT_157 \
1641
#define STMT_SELECT_ALL_TARGET_PROP_CACHE 158
1642
#define STMT_158_INFO {"STMT_SELECT_ALL_TARGET_PROP_CACHE", NULL}
1643
#define STMT_158 \
1635
1644
"SELECT local_relpath, properties FROM target_prop_cache " \
1636
1645
"ORDER BY local_relpath " \
1637
1646
""
1638
1647
1639
#define STMT_DROP_TARGET_PROP_CACHE 158
1640
#define STMT_158_INFO {"STMT_DROP_TARGET_PROP_CACHE", NULL}
1641
#define STMT_158 \
1648
#define STMT_DROP_TARGET_PROP_CACHE 159
1649
#define STMT_159_INFO {"STMT_DROP_TARGET_PROP_CACHE", NULL}
1650
#define STMT_159 \
1642
1651
"DROP TABLE target_prop_cache; " \
1643
1652
""
1644
1653
1645
#define STMT_CREATE_REVERT_LIST 159
1646
#define STMT_159_INFO {"STMT_CREATE_REVERT_LIST", NULL}
1647
#define STMT_159 \
1654
#define STMT_CREATE_REVERT_LIST 160
1655
#define STMT_160_INFO {"STMT_CREATE_REVERT_LIST", NULL}
1656
#define STMT_160 \
1648
1657
"DROP TABLE IF EXISTS revert_list; " \
1649
1658
"CREATE TEMPORARY TABLE revert_list ( " \
1650
1659
" local_relpath TEXT NOT NULL, " \
1700
1709
"END " \
1701
1710
""
1702
1711
1703
#define STMT_DROP_REVERT_LIST_TRIGGERS 160
1704
#define STMT_160_INFO {"STMT_DROP_REVERT_LIST_TRIGGERS", NULL}
1705
#define STMT_160 \
1712
#define STMT_DROP_REVERT_LIST_TRIGGERS 161
1713
#define STMT_161_INFO {"STMT_DROP_REVERT_LIST_TRIGGERS", NULL}
1714
#define STMT_161 \
1706
1715
"DROP TRIGGER trigger_revert_list_nodes; " \
1707
1716
"DROP TRIGGER trigger_revert_list_actual_delete; " \
1708
1717
"DROP TRIGGER trigger_revert_list_actual_update " \
1709
1718
""
1710
1719
1711
#define STMT_SELECT_REVERT_LIST 161
1712
#define STMT_161_INFO {"STMT_SELECT_REVERT_LIST", NULL}
1713
#define STMT_161 \
1720
#define STMT_SELECT_REVERT_LIST 162
1721
#define STMT_162_INFO {"STMT_SELECT_REVERT_LIST", NULL}
1722
#define STMT_162 \
1714
1723
"SELECT actual, notify, kind, op_depth, repos_id, conflict_data " \
1715
1724
"FROM revert_list " \
1716
1725
"WHERE local_relpath = ?1 " \
1717
1726
"ORDER BY actual DESC " \
1718
1727
""
1719
1728
1720
#define STMT_SELECT_REVERT_LIST_COPIED_CHILDREN 162
1721
#define STMT_162_INFO {"STMT_SELECT_REVERT_LIST_COPIED_CHILDREN", NULL}
1722
#define STMT_162 \
1729
#define STMT_SELECT_REVERT_LIST_COPIED_CHILDREN 163
1730
#define STMT_163_INFO {"STMT_SELECT_REVERT_LIST_COPIED_CHILDREN", NULL}
1731
#define STMT_163 \
1723
1732
"SELECT local_relpath, kind " \
1724
1733
"FROM revert_list " \
1725
1734
"WHERE (((local_relpath) > (CASE (?1) WHEN '' THEN '' ELSE (?1) || '/' END)) AND ((local_relpath) < CASE (?1) WHEN '' THEN X'FFFF' ELSE (?1) || '0' END)) " \
1728
1737
"ORDER BY local_relpath " \
1729
1738
""
1730
1739
1731
#define STMT_DELETE_REVERT_LIST 163
1732
#define STMT_163_INFO {"STMT_DELETE_REVERT_LIST", NULL}
1733
#define STMT_163 \
1740
#define STMT_DELETE_REVERT_LIST 164
1741
#define STMT_164_INFO {"STMT_DELETE_REVERT_LIST", NULL}
1742
#define STMT_164 \
1734
1743
"DELETE FROM revert_list WHERE local_relpath = ?1 " \
1735
1744
""
1736
1745
1737
#define STMT_SELECT_REVERT_LIST_RECURSIVE 164
1738
#define STMT_164_INFO {"STMT_SELECT_REVERT_LIST_RECURSIVE", NULL}
1739
#define STMT_164 \
1746
#define STMT_SELECT_REVERT_LIST_RECURSIVE 165
1747
#define STMT_165_INFO {"STMT_SELECT_REVERT_LIST_RECURSIVE", NULL}
1748
#define STMT_165 \
1740
1749
"SELECT DISTINCT local_relpath " \
1741
1750
"FROM revert_list " \
1742
1751
"WHERE (local_relpath = ?1 " \
1745
1754
"ORDER BY local_relpath " \
1746
1755
""
1747
1756
1748
#define STMT_DELETE_REVERT_LIST_RECURSIVE 165
1749
#define STMT_165_INFO {"STMT_DELETE_REVERT_LIST_RECURSIVE", NULL}
1750
#define STMT_165 \
1757
#define STMT_DELETE_REVERT_LIST_RECURSIVE 166
1758
#define STMT_166_INFO {"STMT_DELETE_REVERT_LIST_RECURSIVE", NULL}
1759
#define STMT_166 \
1751
1760
"DELETE FROM revert_list " \
1752
1761
"WHERE (local_relpath = ?1 " \
1753
1762
" OR (((local_relpath) > (CASE (?1) WHEN '' THEN '' ELSE (?1) || '/' END)) AND ((local_relpath) < CASE (?1) WHEN '' THEN X'FFFF' ELSE (?1) || '0' END))) " \
1754
1763
""
1755
1764
1756
#define STMT_DROP_REVERT_LIST 166
1757
#define STMT_166_INFO {"STMT_DROP_REVERT_LIST", NULL}
1758
#define STMT_166 \
1765
#define STMT_DROP_REVERT_LIST 167
1766
#define STMT_167_INFO {"STMT_DROP_REVERT_LIST", NULL}
1767
#define STMT_167 \
1759
1768
"DROP TABLE IF EXISTS revert_list " \
1760
1769
""
1761
1770
1762
#define STMT_CREATE_DELETE_LIST 167
1763
#define STMT_167_INFO {"STMT_CREATE_DELETE_LIST", NULL}
1764
#define STMT_167 \
1771
#define STMT_CREATE_DELETE_LIST 168
1772
#define STMT_168_INFO {"STMT_CREATE_DELETE_LIST", NULL}
1773
#define STMT_168 \
1765
1774
"DROP TABLE IF EXISTS delete_list; " \
1766
1775
"CREATE TEMPORARY TABLE delete_list ( " \
1767
1776
" local_relpath TEXT PRIMARY KEY NOT NULL UNIQUE " \
1768
1777
" ) " \
1769
1778
""
1770
1779
1771
#define STMT_INSERT_DELETE_LIST 168
1772
#define STMT_168_INFO {"STMT_INSERT_DELETE_LIST", NULL}
1773
#define STMT_168 \
1780
#define STMT_INSERT_DELETE_LIST 169
1781
#define STMT_169_INFO {"STMT_INSERT_DELETE_LIST", NULL}
1782
#define STMT_169 \
1774
1783
"INSERT INTO delete_list(local_relpath) " \
1775
1784
"SELECT local_relpath FROM nodes AS n " \
1776
1785
"WHERE wc_id = ?1 " \
1784
1793
" AND file_external IS NULL " \
1785
1794
""
1786
1795
1787
#define STMT_SELECT_DELETE_LIST 169
1788
#define STMT_169_INFO {"STMT_SELECT_DELETE_LIST", NULL}
1789
#define STMT_169 \
1796
#define STMT_SELECT_DELETE_LIST 170
1797
#define STMT_170_INFO {"STMT_SELECT_DELETE_LIST", NULL}
1798
#define STMT_170 \
1790
1799
"SELECT local_relpath FROM delete_list " \
1791
1800
"ORDER BY local_relpath " \
1792
1801
""
1793
1802
1794
#define STMT_FINALIZE_DELETE 170
1795
#define STMT_170_INFO {"STMT_FINALIZE_DELETE", NULL}
1796
#define STMT_170 \
1803
#define STMT_FINALIZE_DELETE 171
1804
#define STMT_171_INFO {"STMT_FINALIZE_DELETE", NULL}
1805
#define STMT_171 \
1797
1806
"DROP TABLE IF EXISTS delete_list " \
1798
1807
""
1799
1808
1800
#define STMT_CREATE_UPDATE_MOVE_LIST 171
1801
#define STMT_171_INFO {"STMT_CREATE_UPDATE_MOVE_LIST", NULL}
1802
#define STMT_171 \
1809
#define STMT_CREATE_UPDATE_MOVE_LIST 172
1810
#define STMT_172_INFO {"STMT_CREATE_UPDATE_MOVE_LIST", NULL}
1811
#define STMT_172 \
1803
1812
"DROP TABLE IF EXISTS update_move_list; " \
1804
1813
"CREATE TEMPORARY TABLE update_move_list ( " \
1805
1814
" local_relpath TEXT PRIMARY KEY NOT NULL UNIQUE, " \
1810
1819
" ) " \
1811
1820
""
1812
1821
1813
#define STMT_INSERT_UPDATE_MOVE_LIST 172
1814
#define STMT_172_INFO {"STMT_INSERT_UPDATE_MOVE_LIST", NULL}
1815
#define STMT_172 \
1822
#define STMT_INSERT_UPDATE_MOVE_LIST 173
1823
#define STMT_173_INFO {"STMT_INSERT_UPDATE_MOVE_LIST", NULL}
1824
#define STMT_173 \
1816
1825
"INSERT INTO update_move_list(local_relpath, action, kind, content_state, " \
1817
1826
" prop_state) " \
1818
1827
"VALUES (?1, ?2, ?3, ?4, ?5) " \
1819
1828
""
1820
1829
1821
#define STMT_SELECT_UPDATE_MOVE_LIST 173
1822
#define STMT_173_INFO {"STMT_SELECT_UPDATE_MOVE_LIST", NULL}
1823
#define STMT_173 \
1830
#define STMT_SELECT_UPDATE_MOVE_LIST 174
1831
#define STMT_174_INFO {"STMT_SELECT_UPDATE_MOVE_LIST", NULL}
1832
#define STMT_174 \
1824
1833
"SELECT local_relpath, action, kind, content_state, prop_state " \
1825
1834
"FROM update_move_list " \
1826
1835
"ORDER BY local_relpath " \
1827
1836
""
1828
1837
1829
#define STMT_FINALIZE_UPDATE_MOVE 174
1830
#define STMT_174_INFO {"STMT_FINALIZE_UPDATE_MOVE", NULL}
1831
#define STMT_174 \
1838
#define STMT_FINALIZE_UPDATE_MOVE 175
1839
#define STMT_175_INFO {"STMT_FINALIZE_UPDATE_MOVE", NULL}
1840
#define STMT_175 \
1832
1841
"DROP TABLE IF EXISTS update_move_list " \
1833
1842
""
1834
1843
1835
#define STMT_SELECT_MIN_MAX_REVISIONS 175
1836
#define STMT_175_INFO {"STMT_SELECT_MIN_MAX_REVISIONS", NULL}
1837
#define STMT_175 \
1844
#define STMT_SELECT_MIN_MAX_REVISIONS 176
1845
#define STMT_176_INFO {"STMT_SELECT_MIN_MAX_REVISIONS", NULL}
1846
#define STMT_176 \
1838
1847
"SELECT MIN(revision), MAX(revision), " \
1839
1848
" MIN(changed_revision), MAX(changed_revision) FROM nodes " \
1840
1849
" WHERE wc_id = ?1 " \
1845
1854
" AND op_depth = 0 " \
1846
1855
""
1847
1856
1848
#define STMT_HAS_SPARSE_NODES 176
1849
#define STMT_176_INFO {"STMT_HAS_SPARSE_NODES", NULL}
1850
#define STMT_176 \
1857
#define STMT_HAS_SPARSE_NODES 177
1858
#define STMT_177_INFO {"STMT_HAS_SPARSE_NODES", NULL}
1859
#define STMT_177 \
1851
1860
"SELECT 1 FROM nodes " \
1852
1861
"WHERE wc_id = ?1 " \
1853
1862
" AND (local_relpath = ?2 " \
1859
1868
"LIMIT 1 " \
1860
1869
""
1861
1870
1862
#define STMT_SUBTREE_HAS_TREE_MODIFICATIONS 177
1863
#define STMT_177_INFO {"STMT_SUBTREE_HAS_TREE_MODIFICATIONS", NULL}
1864
#define STMT_177 \
1865
"SELECT 1 FROM nodes " \
1866
"WHERE wc_id = ?1 " \
1867
" AND (local_relpath = ?2 " \
1868
" OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
1869
" AND op_depth > 0 " \
1870
"LIMIT 1 " \
1871
""
1872
1873
#define STMT_SUBTREE_HAS_PROP_MODIFICATIONS 178
1874
#define STMT_178_INFO {"STMT_SUBTREE_HAS_PROP_MODIFICATIONS", NULL}
1871
#define STMT_SUBTREE_HAS_TREE_MODIFICATIONS 178
1872
#define STMT_178_INFO {"STMT_SUBTREE_HAS_TREE_MODIFICATIONS", NULL}
1875
1873
#define STMT_178 \
1874
"SELECT 1 FROM nodes " \
1875
"WHERE wc_id = ?1 " \
1876
" AND (local_relpath = ?2 " \
1877
" OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
1878
" AND op_depth > 0 " \
1879
"LIMIT 1 " \
1880
""
1881
1882
#define STMT_SUBTREE_HAS_PROP_MODIFICATIONS 179
1883
#define STMT_179_INFO {"STMT_SUBTREE_HAS_PROP_MODIFICATIONS", NULL}
1884
#define STMT_179 \
1876
1885
"SELECT 1 FROM actual_node " \
1877
1886
"WHERE wc_id = ?1 " \
1878
1887
" AND (local_relpath = ?2 " \
1881
1890
"LIMIT 1 " \
1882
1891
""
1883
1892
1884
#define STMT_HAS_SWITCHED 179
1885
#define STMT_179_INFO {"STMT_HAS_SWITCHED", NULL}
1886
#define STMT_179 \
1893
#define STMT_HAS_SWITCHED 180
1894
#define STMT_180_INFO {"STMT_HAS_SWITCHED", NULL}
1895
#define STMT_180 \
1887
1896
"SELECT 1 " \
1888
1897
"FROM nodes " \
1889
1898
"WHERE wc_id = ?1 " \
1895
1904
"LIMIT 1 " \
1896
1905
""
1897
1906
1898
#define STMT_SELECT_BASE_FILES_RECURSIVE 180
1899
#define STMT_180_INFO {"STMT_SELECT_BASE_FILES_RECURSIVE", NULL}
1900
#define STMT_180 \
1907
#define STMT_SELECT_BASE_FILES_RECURSIVE 181
1908
#define STMT_181_INFO {"STMT_SELECT_BASE_FILES_RECURSIVE", NULL}
1909
#define STMT_181 \
1901
1910
"SELECT local_relpath, translated_size, last_mod_time FROM nodes AS n " \
1902
1911
"WHERE wc_id = ?1 " \
1903
1912
" AND (local_relpath = ?2 " \
1908
1917
" AND file_external IS NULL " \
1909
1918
""
1910
1919
1911
#define STMT_SELECT_MOVED_FROM_RELPATH 181
1912
#define STMT_181_INFO {"STMT_SELECT_MOVED_FROM_RELPATH", NULL}
1913
#define STMT_181 \
1920
#define STMT_SELECT_MOVED_FROM_RELPATH 182
1921
#define STMT_182_INFO {"STMT_SELECT_MOVED_FROM_RELPATH", NULL}
1922
#define STMT_182 \
1914
1923
"SELECT local_relpath, op_depth FROM nodes " \
1915
1924
"WHERE wc_id = ?1 AND moved_to = ?2 AND op_depth > 0 " \
1916
1925
""
1917
1926
1918
#define STMT_UPDATE_MOVED_TO_RELPATH 182
1919
#define STMT_182_INFO {"STMT_UPDATE_MOVED_TO_RELPATH", NULL}
1920
#define STMT_182 \
1927
#define STMT_UPDATE_MOVED_TO_RELPATH 183
1928
#define STMT_183_INFO {"STMT_UPDATE_MOVED_TO_RELPATH", NULL}
1929
#define STMT_183 \
1921
1930
"UPDATE nodes SET moved_to = ?4 " \
1922
1931
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \
1923
1932
""
1924
1933
1925
#define STMT_CLEAR_MOVED_TO_RELPATH 183
1926
#define STMT_183_INFO {"STMT_CLEAR_MOVED_TO_RELPATH", NULL}
1927
#define STMT_183 \
1928
"UPDATE nodes SET moved_to = NULL " \
1929
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \
1930
""
1931
1932
#define STMT_CLEAR_MOVED_HERE_RECURSIVE 184
1933
#define STMT_184_INFO {"STMT_CLEAR_MOVED_HERE_RECURSIVE", NULL}
1934
#define STMT_CLEAR_MOVED_TO_RELPATH 184
1935
#define STMT_184_INFO {"STMT_CLEAR_MOVED_TO_RELPATH", NULL}
1934
1936
#define STMT_184 \
1937
"UPDATE nodes SET moved_to = NULL " \
1938
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \
1939
""
1940
1941
#define STMT_CLEAR_MOVED_HERE_RECURSIVE 185
1942
#define STMT_185_INFO {"STMT_CLEAR_MOVED_HERE_RECURSIVE", NULL}
1943
#define STMT_185 \
1935
1944
"UPDATE nodes SET moved_here = NULL " \
1936
1945
"WHERE wc_id = ?1 " \
1937
1946
" AND (local_relpath = ?2 OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
1938
1947
" AND op_depth = ?3 " \
1939
1948
""
1940
1949
1941
#define STMT_SELECT_MOVED_HERE_CHILDREN 185
1942
#define STMT_185_INFO {"STMT_SELECT_MOVED_HERE_CHILDREN", NULL}
1943
#define STMT_185 \
1950
#define STMT_SELECT_MOVED_HERE_CHILDREN 186
1951
#define STMT_186_INFO {"STMT_SELECT_MOVED_HERE_CHILDREN", NULL}
1952
#define STMT_186 \
1944
1953
"SELECT moved_to, local_relpath FROM nodes " \
1945
1954
"WHERE wc_id = ?1 AND op_depth > 0 " \
1946
1955
" AND (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1947
1956
""
1948
1957
1949
#define STMT_SELECT_MOVED_FOR_DELETE 186
1950
#define STMT_186_INFO {"STMT_SELECT_MOVED_FOR_DELETE", NULL}
1951
#define STMT_186 \
1952
"SELECT local_relpath, moved_to, op_depth FROM nodes " \
1953
"WHERE wc_id = ?1 " \
1954
" AND (local_relpath = ?2 OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
1955
" AND moved_to IS NOT NULL " \
1956
" AND op_depth >= (SELECT MAX(op_depth) FROM nodes o " \
1957
" WHERE o.wc_id = ?1 " \
1958
" AND o.local_relpath = ?2) " \
1959
""
1960
1961
#define STMT_UPDATE_MOVED_TO_DESCENDANTS 187
1962
#define STMT_187_INFO {"STMT_UPDATE_MOVED_TO_DESCENDANTS", NULL}
1958
#define STMT_SELECT_MOVED_FOR_DELETE 187
1959
#define STMT_187_INFO {"STMT_SELECT_MOVED_FOR_DELETE", NULL}
1963
1960
#define STMT_187 \
1964
"UPDATE nodes SET moved_to = (CASE WHEN (?2) = '' THEN (CASE WHEN (?3) = '' THEN (moved_to) WHEN (moved_to) = '' THEN (?3) ELSE (?3) || '/' || (moved_to) END) WHEN (?3) = '' THEN (CASE WHEN (?2) = '' THEN (moved_to) WHEN SUBSTR((moved_to), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(moved_to) THEN '' WHEN SUBSTR((moved_to), LENGTH(?2)+1, 1) = '/' THEN SUBSTR((moved_to), LENGTH(?2)+2) END END) WHEN SUBSTR((moved_to), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(moved_to) THEN (?3) WHEN SUBSTR((moved_to), LENGTH(?2)+1, 1) = '/' THEN (?3) || SUBSTR((moved_to), LENGTH(?2)+1) END END) " \
1965
" WHERE wc_id = ?1 " \
1966
" AND (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1961
"SELECT local_relpath, moved_to, op_depth, " \
1962
" (SELECT CASE WHEN r.moved_here THEN r.op_depth END FROM nodes r " \
1963
" WHERE r.wc_id = ?1 " \
1964
" AND r.local_relpath = n.local_relpath " \
1965
" AND r.op_depth < n.op_depth " \
1966
" ORDER BY r.op_depth DESC LIMIT 1) AS moved_here_op_depth " \
1967
" FROM nodes n " \
1968
"WHERE wc_id = ?1 " \
1969
" AND (local_relpath = ?2 OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
1970
" AND moved_to IS NOT NULL " \
1971
" AND op_depth >= ?3 " \
1967
1972
""
1968
1973
1969
#define STMT_CLEAR_MOVED_TO_DESCENDANTS 188
1970
#define STMT_188_INFO {"STMT_CLEAR_MOVED_TO_DESCENDANTS", NULL}
1974
#define STMT_SELECT_MOVED_FROM_FOR_DELETE 188
1975
#define STMT_188_INFO {"STMT_SELECT_MOVED_FROM_FOR_DELETE", NULL}
1971
1976
#define STMT_188 \
1972
"UPDATE nodes SET moved_to = NULL " \
1973
" WHERE wc_id = ?1 " \
1974
" AND (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1977
"SELECT local_relpath, op_depth, " \
1978
" (SELECT CASE WHEN r.moved_here THEN r.op_depth END FROM nodes r " \
1979
" WHERE r.wc_id = ?1 " \
1980
" AND r.local_relpath = n.local_relpath " \
1981
" AND r.op_depth < n.op_depth " \
1982
" ORDER BY r.op_depth DESC LIMIT 1) AS moved_here_op_depth " \
1983
" FROM nodes n " \
1984
"WHERE wc_id = ?1 AND moved_to = ?2 AND op_depth > 0 " \
1975
1985
""
1976
1986
1977
#define STMT_SELECT_MOVED_PAIR2 189
1978
#define STMT_189_INFO {"STMT_SELECT_MOVED_PAIR2", NULL}
1987
#define STMT_UPDATE_MOVED_TO_DESCENDANTS 189
1988
#define STMT_189_INFO {"STMT_UPDATE_MOVED_TO_DESCENDANTS", NULL}
1979
1989
#define STMT_189 \
1980
"SELECT local_relpath, moved_to, op_depth FROM nodes " \
1981
"WHERE wc_id = ?1 " \
1982
" AND (local_relpath = ?2 OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
1983
" AND moved_to IS NOT NULL " \
1984
" AND NOT (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1985
" AND op_depth >= (SELECT MAX(op_depth) FROM nodes o " \
1986
" WHERE o.wc_id = ?1 " \
1987
" AND o.local_relpath = ?2) " \
1990
"UPDATE nodes SET moved_to = (CASE WHEN (?2) = '' THEN (CASE WHEN (?3) = '' THEN (moved_to) WHEN (moved_to) = '' THEN (?3) ELSE (?3) || '/' || (moved_to) END) WHEN (?3) = '' THEN (CASE WHEN (?2) = '' THEN (moved_to) WHEN SUBSTR((moved_to), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(moved_to) THEN '' WHEN SUBSTR((moved_to), LENGTH(?2)+1, 1) = '/' THEN SUBSTR((moved_to), LENGTH(?2)+2) END END) WHEN SUBSTR((moved_to), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(moved_to) THEN (?3) WHEN SUBSTR((moved_to), LENGTH(?2)+1, 1) = '/' THEN (?3) || SUBSTR((moved_to), LENGTH(?2)+1) END END) " \
1991
" WHERE wc_id = ?1 " \
1992
" AND (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
1988
1993
""
1989
1994
1990
#define STMT_SELECT_MOVED_PAIR3 190
1991
#define STMT_190_INFO {"STMT_SELECT_MOVED_PAIR3", NULL}
1995
#define STMT_CLEAR_MOVED_TO_DESCENDANTS 190
1996
#define STMT_190_INFO {"STMT_CLEAR_MOVED_TO_DESCENDANTS", NULL}
1992
1997
#define STMT_190 \
1993
"SELECT local_relpath, moved_to, op_depth, kind FROM nodes " \
1994
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > ?3 " \
1995
" AND moved_to IS NOT NULL " \
1996
"UNION ALL " \
1997
"SELECT local_relpath, moved_to, op_depth, kind FROM nodes " \
1998
"WHERE wc_id = ?1 " \
1999
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
2000
" AND op_depth > ?3 " \
2001
" AND moved_to IS NOT NULL " \
2002
"ORDER BY local_relpath, op_depth " \
1998
"UPDATE nodes SET moved_to = NULL " \
1999
" WHERE wc_id = ?1 " \
2000
" AND (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
2003
2001
""
2004
2002
2005
#define STMT_SELECT_MOVED_OUTSIDE 191
2006
#define STMT_191_INFO {"STMT_SELECT_MOVED_OUTSIDE", NULL}
2003
#define STMT_SELECT_MOVED_PAIR2 191
2004
#define STMT_191_INFO {"STMT_SELECT_MOVED_PAIR2", NULL}
2007
2005
#define STMT_191 \
2008
2006
"SELECT local_relpath, moved_to, op_depth FROM nodes " \
2009
2007
"WHERE wc_id = ?1 " \
2010
2008
" AND (local_relpath = ?2 OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
2011
" AND op_depth >= ?3 " \
2012
2009
" AND moved_to IS NOT NULL " \
2013
2010
" AND NOT (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
2011
" AND op_depth >= (SELECT MAX(op_depth) FROM nodes o " \
2012
" WHERE o.wc_id = ?1 " \
2013
" AND o.local_relpath = ?2) " \
2014
2014
""
2015
2015
2016
#define STMT_SELECT_OP_DEPTH_MOVED_PAIR 192
2017
#define STMT_192_INFO {"STMT_SELECT_OP_DEPTH_MOVED_PAIR", NULL}
2016
#define STMT_SELECT_MOVED_PAIR3 192
2017
#define STMT_192_INFO {"STMT_SELECT_MOVED_PAIR3", NULL}
2018
2018
#define STMT_192 \
2019
"SELECT local_relpath, moved_to, op_depth, kind FROM nodes " \
2020
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > ?3 " \
2021
" AND moved_to IS NOT NULL " \
2022
"UNION ALL " \
2023
"SELECT local_relpath, moved_to, op_depth, kind FROM nodes " \
2024
"WHERE wc_id = ?1 " \
2025
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
2026
" AND op_depth > ?3 " \
2027
" AND moved_to IS NOT NULL " \
2028
"ORDER BY local_relpath, op_depth " \
2029
""
2030
2031
#define STMT_SELECT_MOVED_OUTSIDE 193
2032
#define STMT_193_INFO {"STMT_SELECT_MOVED_OUTSIDE", NULL}
2033
#define STMT_193 \
2034
"SELECT local_relpath, moved_to, op_depth FROM nodes " \
2035
"WHERE wc_id = ?1 " \
2036
" AND (local_relpath = ?2 OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
2037
" AND op_depth >= ?3 " \
2038
" AND moved_to IS NOT NULL " \
2039
" AND NOT (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
2040
""
2041
2042
#define STMT_SELECT_OP_DEPTH_MOVED_PAIR 194
2043
#define STMT_194_INFO {"STMT_SELECT_OP_DEPTH_MOVED_PAIR", NULL}
2044
#define STMT_194 \
2019
2045
"SELECT n.local_relpath, n.moved_to, " \
2020
2046
" (SELECT o.repos_path FROM nodes AS o " \
2021
2047
" WHERE o.wc_id = n.wc_id " \
2028
2054
" AND n.moved_to IS NOT NULL " \
2029
2055
""
2030
2056
2031
#define STMT_SELECT_MOVED_DESCENDANTS 193
2032
#define STMT_193_INFO {"STMT_SELECT_MOVED_DESCENDANTS", NULL}
2033
#define STMT_193 \
2057
#define STMT_SELECT_MOVED_DESCENDANTS 195
2058
#define STMT_195_INFO {"STMT_SELECT_MOVED_DESCENDANTS", NULL}
2059
#define STMT_195 \
2034
2060
"SELECT n.local_relpath, h.moved_to " \
2035
2061
"FROM nodes n, nodes h " \
2036
2062
"WHERE n.wc_id = ?1 " \
2046
2072
" AND h.moved_to IS NOT NULL " \
2047
2073
""
2048
2074
2049
#define STMT_COMMIT_UPDATE_ORIGIN 194
2050
#define STMT_194_INFO {"STMT_COMMIT_UPDATE_ORIGIN", NULL}
2051
#define STMT_194 \
2075
#define STMT_COMMIT_UPDATE_ORIGIN 196
2076
#define STMT_196_INFO {"STMT_COMMIT_UPDATE_ORIGIN", NULL}
2077
#define STMT_196 \
2052
2078
"UPDATE nodes SET repos_id = ?4, " \
2053
2079
" repos_path = ?5 || SUBSTR(local_relpath, LENGTH(?2)+1), " \
2054
2080
" revision = ?6 " \
2058
2084
" AND op_depth = ?3 " \
2059
2085
""
2060
2086
2061
#define STMT_HAS_LAYER_BETWEEN 195
2062
#define STMT_195_INFO {"STMT_HAS_LAYER_BETWEEN", NULL}
2063
#define STMT_195 \
2087
#define STMT_HAS_LAYER_BETWEEN 197
2088
#define STMT_197_INFO {"STMT_HAS_LAYER_BETWEEN", NULL}
2089
#define STMT_197 \
2064
2090
"SELECT 1 FROM NODES " \
2065
2091
"WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > ?3 AND op_depth < ?4 " \
2066
2092
""
2067
2093
2068
#define STMT_SELECT_REPOS_PATH_REVISION 196
2069
#define STMT_196_INFO {"STMT_SELECT_REPOS_PATH_REVISION", NULL}
2070
#define STMT_196 \
2094
#define STMT_SELECT_REPOS_PATH_REVISION 198
2095
#define STMT_198_INFO {"STMT_SELECT_REPOS_PATH_REVISION", NULL}
2096
#define STMT_198 \
2071
2097
"SELECT local_relpath, repos_path, revision FROM nodes " \
2072
2098
"WHERE wc_id = ?1 " \
2073
2099
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
2075
2101
"ORDER BY local_relpath " \
2076
2102
""
2077
2103
2078
#define STMT_SELECT_HAS_NON_FILE_CHILDREN 197
2079
#define STMT_197_INFO {"STMT_SELECT_HAS_NON_FILE_CHILDREN", NULL}
2080
#define STMT_197 \
2104
#define STMT_SELECT_HAS_NON_FILE_CHILDREN 199
2105
#define STMT_199_INFO {"STMT_SELECT_HAS_NON_FILE_CHILDREN", NULL}
2106
#define STMT_199 \
2081
2107
"SELECT 1 FROM nodes " \
2082
2108
"WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = 0 AND kind != 'file' " \
2083
2109
""
2084
2110
2085
#define STMT_SELECT_HAS_GRANDCHILDREN 198
2086
#define STMT_198_INFO {"STMT_SELECT_HAS_GRANDCHILDREN", NULL}
2087
#define STMT_198 \
2111
#define STMT_SELECT_HAS_GRANDCHILDREN 200
2112
#define STMT_200_INFO {"STMT_SELECT_HAS_GRANDCHILDREN", NULL}
2113
#define STMT_200 \
2088
2114
"SELECT 1 FROM nodes " \
2089
2115
"WHERE wc_id = ?1 " \
2090
2116
" AND (((parent_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((parent_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
2092
2118
" AND file_external IS NULL " \
2093
2119
""
2094
2120
2095
#define STMT_SELECT_ALL_NODES 199
2096
#define STMT_199_INFO {"STMT_SELECT_ALL_NODES", NULL}
2097
#define STMT_199 \
2121
#define STMT_SELECT_ALL_NODES 201
2122
#define STMT_201_INFO {"STMT_SELECT_ALL_NODES", NULL}
2123
#define STMT_201 \
2098
2124
"SELECT op_depth, local_relpath, parent_relpath, file_external FROM nodes " \
2099
2125
"WHERE wc_id = ?1 " \
2100
2126
""
2101
2127
2102
#define STMT_SELECT_IPROPS 200
2103
#define STMT_200_INFO {"STMT_SELECT_IPROPS", NULL}
2104
#define STMT_200 \
2128
#define STMT_SELECT_IPROPS 202
2129
#define STMT_202_INFO {"STMT_SELECT_IPROPS", NULL}
2130
#define STMT_202 \
2105
2131
"SELECT inherited_props FROM nodes " \
2106
2132
"WHERE wc_id = ?1 " \
2107
2133
" AND local_relpath = ?2 " \
2108
2134
" AND op_depth = 0 " \
2109
2135
""
2110
2136
2111
#define STMT_UPDATE_IPROP 201
2112
#define STMT_201_INFO {"STMT_UPDATE_IPROP", NULL}
2113
#define STMT_201 \
2137
#define STMT_UPDATE_IPROP 203
2138
#define STMT_203_INFO {"STMT_UPDATE_IPROP", NULL}
2139
#define STMT_203 \
2114
2140
"UPDATE nodes " \
2115
2141
"SET inherited_props = ?3 " \
2116
2142
"WHERE (wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0) " \
2117
2143
""
2118
2144
2119
#define STMT_SELECT_IPROPS_NODE 202
2120
#define STMT_202_INFO {"STMT_SELECT_IPROPS_NODE", NULL}
2121
#define STMT_202 \
2122
"SELECT local_relpath, repos_path FROM nodes " \
2123
"WHERE wc_id = ?1 " \
2124
" AND local_relpath = ?2 " \
2125
" AND op_depth = 0 " \
2126
" AND (inherited_props not null) " \
2127
""
2128
2129
#define STMT_SELECT_IPROPS_RECURSIVE 203
2130
#define STMT_203_INFO {"STMT_SELECT_IPROPS_RECURSIVE", NULL}
2131
#define STMT_203 \
2132
"SELECT local_relpath, repos_path FROM nodes " \
2133
"WHERE wc_id = ?1 " \
2134
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
2135
" AND op_depth = 0 " \
2136
" AND (inherited_props not null) " \
2137
""
2138
2139
#define STMT_SELECT_IPROPS_CHILDREN 204
2140
#define STMT_204_INFO {"STMT_SELECT_IPROPS_CHILDREN", NULL}
2145
#define STMT_SELECT_IPROPS_NODE 204
2146
#define STMT_204_INFO {"STMT_SELECT_IPROPS_NODE", NULL}
2141
2147
#define STMT_204 \
2142
2148
"SELECT local_relpath, repos_path FROM nodes " \
2143
2149
"WHERE wc_id = ?1 " \
2144
" AND parent_relpath = ?2 " \
2150
" AND local_relpath = ?2 " \
2145
2151
" AND op_depth = 0 " \
2146
2152
" AND (inherited_props not null) " \
2147
2153
""
2148
2154
2149
#define STMT_CREATE_SCHEMA 205
2150
#define STMT_205_INFO {"STMT_CREATE_SCHEMA", NULL}
2155
#define STMT_SELECT_IPROPS_RECURSIVE 205
2156
#define STMT_205_INFO {"STMT_SELECT_IPROPS_RECURSIVE", NULL}
2151
2157
#define STMT_205 \
2158
"SELECT local_relpath, repos_path FROM nodes " \
2159
"WHERE wc_id = ?1 " \
2160
" AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \
2161
" AND op_depth = 0 " \
2162
" AND (inherited_props not null) " \
2163
""
2164
2165
#define STMT_SELECT_IPROPS_CHILDREN 206
2166
#define STMT_206_INFO {"STMT_SELECT_IPROPS_CHILDREN", NULL}
2167
#define STMT_206 \
2168
"SELECT local_relpath, repos_path FROM nodes " \
2169
"WHERE wc_id = ?1 " \
2170
" AND parent_relpath = ?2 " \
2171
" AND op_depth = 0 " \
2172
" AND (inherited_props not null) " \
2173
""
2174
2175
#define STMT_CREATE_SCHEMA 207
2176
#define STMT_207_INFO {"STMT_CREATE_SCHEMA", NULL}
2177
#define STMT_207 \
2152
2178
"CREATE TABLE REPOSITORY ( " \
2153
2179
" id INTEGER PRIMARY KEY AUTOINCREMENT, " \
2154
2180
" root TEXT UNIQUE NOT NULL, " \
2213
2239
"; " \
2214
2240
""
2215
2241
2216
#define STMT_CREATE_NODES 206
2217
#define STMT_206_INFO {"STMT_CREATE_NODES", NULL}
2218
#define STMT_206 \
2242
#define STMT_CREATE_NODES 208
2243
#define STMT_208_INFO {"STMT_CREATE_NODES", NULL}
2244
#define STMT_208 \
2219
2245
"CREATE TABLE NODES ( " \
2220
2246
" wc_id INTEGER NOT NULL REFERENCES WCROOT (id), " \
2221
2247
" local_relpath TEXT NOT NULL, " \
2255
2281
" WHERE op_depth = 0; " \
2256
2282
""
2257
2283
2258
#define STMT_CREATE_NODES_TRIGGERS 207
2259
#define STMT_207_INFO {"STMT_CREATE_NODES_TRIGGERS", NULL}
2260
#define STMT_207 \
2284
#define STMT_CREATE_NODES_TRIGGERS 209
2285
#define STMT_209_INFO {"STMT_CREATE_NODES_TRIGGERS", NULL}
2286
#define STMT_209 \
2261
2287
"CREATE TRIGGER nodes_insert_trigger " \
2262
2288
"AFTER INSERT ON nodes " \
2263
2289
"WHEN NEW.checksum IS NOT NULL " \
2283
2309
"END; " \
2284
2310
""
2285
2311
2286
#define STMT_CREATE_EXTERNALS 208
2287
#define STMT_208_INFO {"STMT_CREATE_EXTERNALS", NULL}
2288
#define STMT_208 \
2312
#define STMT_CREATE_EXTERNALS 210
2313
#define STMT_210_INFO {"STMT_CREATE_EXTERNALS", NULL}
2314
#define STMT_210 \
2289
2315
"CREATE TABLE EXTERNALS ( " \
2290
2316
" wc_id INTEGER NOT NULL REFERENCES WCROOT (id), " \
2291
2317
" local_relpath TEXT NOT NULL, " \
2304
2330
" local_relpath); " \
2305
2331
""
2306
2332
2307
#define STMT_INSTALL_SCHEMA_STATISTICS 209
2308
#define STMT_209_INFO {"STMT_INSTALL_SCHEMA_STATISTICS", NULL}
2309
#define STMT_209 \
2333
#define STMT_INSTALL_SCHEMA_STATISTICS 211
2334
#define STMT_211_INFO {"STMT_INSTALL_SCHEMA_STATISTICS", NULL}
2335
#define STMT_211 \
2310
2336
"ANALYZE sqlite_master; " \
2337
"DELETE FROM sqlite_stat1 " \
2338
"WHERE tbl in ('NODES', 'ACTUAL_NODE', 'LOCK', 'WC_LOCK'); " \
2311
2339
"INSERT OR REPLACE INTO sqlite_stat1(tbl, idx, stat) VALUES " \
2312
2340
" ('NODES', 'sqlite_autoindex_NODES_1', '8000 8000 2 1'); " \
2313
2341
"INSERT OR REPLACE INTO sqlite_stat1(tbl, idx, stat) VALUES " \
2325
2353
"ANALYZE sqlite_master; " \
2326
2354
""
2327
2355
2328
#define STMT_UPGRADE_TO_20 210
2329
#define STMT_210_INFO {"STMT_UPGRADE_TO_20", NULL}
2330
#define STMT_210 \
2356
#define STMT_UPGRADE_TO_20 212
2357
#define STMT_212_INFO {"STMT_UPGRADE_TO_20", NULL}
2358
#define STMT_212 \
2331
2359
"UPDATE BASE_NODE SET checksum = (SELECT checksum FROM pristine " \
2332
2360
" WHERE md5_checksum = BASE_NODE.checksum) " \
2333
2361
"WHERE EXISTS (SELECT 1 FROM pristine WHERE md5_checksum = BASE_NODE.checksum); " \
2368
2396
"PRAGMA user_version = 20; " \
2369
2397
""
2370
2398
2371
#define STMT_UPGRADE_TO_21 211
2372
#define STMT_211_INFO {"STMT_UPGRADE_TO_21", NULL}
2373
#define STMT_211 \
2399
#define STMT_UPGRADE_TO_21 213
2400
#define STMT_213_INFO {"STMT_UPGRADE_TO_21", NULL}
2401
#define STMT_213 \
2374
2402
"PRAGMA user_version = 21; " \
2375
2403
""
2376
2404
2377
#define STMT_UPGRADE_21_SELECT_OLD_TREE_CONFLICT 212
2378
#define STMT_212_INFO {"STMT_UPGRADE_21_SELECT_OLD_TREE_CONFLICT", NULL}
2379
#define STMT_212 \
2405
#define STMT_UPGRADE_21_SELECT_OLD_TREE_CONFLICT 214
2406
#define STMT_214_INFO {"STMT_UPGRADE_21_SELECT_OLD_TREE_CONFLICT", NULL}
2407
#define STMT_214 \
2380
2408
"SELECT wc_id, local_relpath, tree_conflict_data " \
2381
2409
"FROM actual_node " \
2382
2410
"WHERE tree_conflict_data IS NOT NULL " \
2383
2411
""
2384
2412
2385
#define STMT_UPGRADE_21_ERASE_OLD_CONFLICTS 213
2386
#define STMT_213_INFO {"STMT_UPGRADE_21_ERASE_OLD_CONFLICTS", NULL}
2387
#define STMT_213 \
2413
#define STMT_UPGRADE_21_ERASE_OLD_CONFLICTS 215
2414
#define STMT_215_INFO {"STMT_UPGRADE_21_ERASE_OLD_CONFLICTS", NULL}
2415
#define STMT_215 \
2388
2416
"UPDATE actual_node SET tree_conflict_data = NULL " \
2389
2417
""
2390
2418
2391
#define STMT_UPGRADE_TO_22 214
2392
#define STMT_214_INFO {"STMT_UPGRADE_TO_22", NULL}
2393
#define STMT_214 \
2419
#define STMT_UPGRADE_TO_22 216
2420
#define STMT_216_INFO {"STMT_UPGRADE_TO_22", NULL}
2421
#define STMT_216 \
2394
2422
"UPDATE actual_node SET tree_conflict_data = conflict_data; " \
2395
2423
"UPDATE actual_node SET conflict_data = NULL; " \
2396
2424
"PRAGMA user_version = 22; " \
2397
2425
""
2398
2426
2399
#define STMT_UPGRADE_TO_23 215
2400
#define STMT_215_INFO {"STMT_UPGRADE_TO_23", NULL}
2401
#define STMT_215 \
2427
#define STMT_UPGRADE_TO_23 217
2428
#define STMT_217_INFO {"STMT_UPGRADE_TO_23", NULL}
2429
#define STMT_217 \
2402
2430
"PRAGMA user_version = 23; " \
2403
2431
""
2404
2432
2405
#define STMT_UPGRADE_23_HAS_WORKING_NODES 216
2406
#define STMT_216_INFO {"STMT_UPGRADE_23_HAS_WORKING_NODES", NULL}
2407
#define STMT_216 \
2433
#define STMT_UPGRADE_23_HAS_WORKING_NODES 218
2434
#define STMT_218_INFO {"STMT_UPGRADE_23_HAS_WORKING_NODES", NULL}
2435
#define STMT_218 \
2408
2436
"SELECT 1 FROM nodes WHERE op_depth > 0 " \
2409
2437
"LIMIT 1 " \
2410
2438
""
2411
2439
2412
#define STMT_UPGRADE_TO_24 217
2413
#define STMT_217_INFO {"STMT_UPGRADE_TO_24", NULL}
2414
#define STMT_217 \
2440
#define STMT_UPGRADE_TO_24 219
2441
#define STMT_219_INFO {"STMT_UPGRADE_TO_24", NULL}
2442
#define STMT_219 \
2415
2443
"UPDATE pristine SET refcount = " \
2416
2444
" (SELECT COUNT(*) FROM nodes " \
2417
2445
" WHERE checksum = pristine.checksum ); " \
2418
2446
"PRAGMA user_version = 24; " \
2419
2447
""
2420
2448
2421
#define STMT_UPGRADE_TO_25 218
2422
#define STMT_218_INFO {"STMT_UPGRADE_TO_25", NULL}
2423
#define STMT_218 \
2449
#define STMT_UPGRADE_TO_25 220
2450
#define STMT_220_INFO {"STMT_UPGRADE_TO_25", NULL}
2451
#define STMT_220 \
2424
2452
"DROP VIEW IF EXISTS NODES_CURRENT; " \
2425
2453
"CREATE VIEW NODES_CURRENT AS " \
2426
2454
" SELECT * FROM nodes " \
2432
2460
"PRAGMA user_version = 25; " \
2433
2461
""
2434
2462
2435
#define STMT_UPGRADE_TO_26 219
2436
#define STMT_219_INFO {"STMT_UPGRADE_TO_26", NULL}
2437
#define STMT_219 \
2463
#define STMT_UPGRADE_TO_26 221
2464
#define STMT_221_INFO {"STMT_UPGRADE_TO_26", NULL}
2465
#define STMT_221 \
2438
2466
"DROP VIEW IF EXISTS NODES_BASE; " \
2439
2467
"CREATE VIEW NODES_BASE AS " \
2440
2468
" SELECT * FROM nodes " \
2442
2470
"PRAGMA user_version = 26; " \
2443
2471
""
2444
2472
2445
#define STMT_UPGRADE_TO_27 220
2446
#define STMT_220_INFO {"STMT_UPGRADE_TO_27", NULL}
2447
#define STMT_220 \
2473
#define STMT_UPGRADE_TO_27 222
2474
#define STMT_222_INFO {"STMT_UPGRADE_TO_27", NULL}
2475
#define STMT_222 \
2448
2476
"PRAGMA user_version = 27; " \
2449
2477
""
2450
2478
2451
#define STMT_UPGRADE_27_HAS_ACTUAL_NODES_CONFLICTS 221
2452
#define STMT_221_INFO {"STMT_UPGRADE_27_HAS_ACTUAL_NODES_CONFLICTS", NULL}
2453
#define STMT_221 \
2479
#define STMT_UPGRADE_27_HAS_ACTUAL_NODES_CONFLICTS 223
2480
#define STMT_223_INFO {"STMT_UPGRADE_27_HAS_ACTUAL_NODES_CONFLICTS", NULL}
2481
#define STMT_223 \
2454
2482
"SELECT 1 FROM actual_node " \
2455
2483
"WHERE NOT ((prop_reject IS NULL) AND (conflict_old IS NULL) " \
2456
2484
" AND (conflict_new IS NULL) AND (conflict_working IS NULL) " \
2458
2486
"LIMIT 1 " \
2459
2487
""
2460
2488
2461
#define STMT_UPGRADE_TO_28 222
2462
#define STMT_222_INFO {"STMT_UPGRADE_TO_28", NULL}
2463
#define STMT_222 \
2489
#define STMT_UPGRADE_TO_28 224
2490
#define STMT_224_INFO {"STMT_UPGRADE_TO_28", NULL}
2491
#define STMT_224 \
2464
2492
"UPDATE NODES SET checksum = (SELECT checksum FROM pristine " \
2465
2493
" WHERE md5_checksum = nodes.checksum) " \
2466
2494
"WHERE EXISTS (SELECT 1 FROM pristine WHERE md5_checksum = nodes.checksum); " \
2467
2495
"PRAGMA user_version = 28; " \
2468
2496
""
2469
2497
2470
#define STMT_UPGRADE_TO_29 223
2471
#define STMT_223_INFO {"STMT_UPGRADE_TO_29", NULL}
2472
#define STMT_223 \
2498
#define STMT_UPGRADE_TO_29 225
2499
#define STMT_225_INFO {"STMT_UPGRADE_TO_29", NULL}
2500
#define STMT_225 \
2473
2501
"DROP TRIGGER IF EXISTS nodes_update_checksum_trigger; " \
2474
2502
"DROP TRIGGER IF EXISTS nodes_insert_trigger; " \
2475
2503
"DROP TRIGGER IF EXISTS nodes_delete_trigger; " \
2499
2527
"PRAGMA user_version = 29; " \
2500
2528
""
2501
2529
2502
#define STMT_UPGRADE_TO_30 224
2503
#define STMT_224_INFO {"STMT_UPGRADE_TO_30", NULL}
2504
#define STMT_224 \
2530
#define STMT_UPGRADE_TO_30 226
2531
#define STMT_226_INFO {"STMT_UPGRADE_TO_30", NULL}
2532
#define STMT_226 \
2505
2533
"CREATE UNIQUE INDEX IF NOT EXISTS I_NODES_MOVED " \
2506
2534
"ON NODES (wc_id, moved_to, op_depth); " \
2507
2535
"CREATE INDEX IF NOT EXISTS I_PRISTINE_MD5 ON PRISTINE (md5_checksum); " \
2509
2537
"UPDATE nodes SET file_external=1 WHERE file_external IS NOT NULL; " \
2510
2538
""
2511
2539
2512
#define STMT_UPGRADE_30_SELECT_CONFLICT_SEPARATE 225
2513
#define STMT_225_INFO {"STMT_UPGRADE_30_SELECT_CONFLICT_SEPARATE", NULL}
2514
#define STMT_225 \
2540
#define STMT_UPGRADE_30_SELECT_CONFLICT_SEPARATE 227
2541
#define STMT_227_INFO {"STMT_UPGRADE_30_SELECT_CONFLICT_SEPARATE", NULL}
2542
#define STMT_227 \
2515
2543
"SELECT wc_id, local_relpath, " \
2516
2544
" conflict_old, conflict_working, conflict_new, prop_reject, tree_conflict_data " \
2517
2545
"FROM actual_node " \
2523
2551
"ORDER by wc_id, local_relpath " \
2524
2552
""
2525
2553
2526
#define STMT_UPGRADE_30_SET_CONFLICT 226
2527
#define STMT_226_INFO {"STMT_UPGRADE_30_SET_CONFLICT", NULL}
2528
#define STMT_226 \
2554
#define STMT_UPGRADE_30_SET_CONFLICT 228
2555
#define STMT_228_INFO {"STMT_UPGRADE_30_SET_CONFLICT", NULL}
2556
#define STMT_228 \
2529
2557
"UPDATE actual_node SET conflict_data = ?3, conflict_old = NULL, " \
2530
2558
" conflict_working = NULL, conflict_new = NULL, prop_reject = NULL, " \
2531
2559
" tree_conflict_data = NULL " \
2532
2560
"WHERE wc_id = ?1 and local_relpath = ?2 " \
2533
2561
""
2534
2562
2535
#define STMT_UPGRADE_TO_31_ALTER_TABLE 227
2536
#define STMT_227_INFO {"STMT_UPGRADE_TO_31_ALTER_TABLE", NULL}
2537
#define STMT_227 \
2563
#define STMT_UPGRADE_TO_31_ALTER_TABLE 229
2564
#define STMT_229_INFO {"STMT_UPGRADE_TO_31_ALTER_TABLE", NULL}
2565
#define STMT_229 \
2538
2566
"ALTER TABLE NODES ADD COLUMN inherited_props BLOB; " \
2539
2567
""
2540
2568
2541
#define STMT_UPGRADE_TO_31_FINALIZE 228
2542
#define STMT_228_INFO {"STMT_UPGRADE_TO_31_FINALIZE", NULL}
2543
#define STMT_228 \
2569
#define STMT_UPGRADE_TO_31_FINALIZE 230
2570
#define STMT_230_INFO {"STMT_UPGRADE_TO_31_FINALIZE", NULL}
2571
#define STMT_230 \
2544
2572
"DROP INDEX IF EXISTS I_ACTUAL_CHANGELIST; " \
2545
2573
"DROP INDEX IF EXISTS I_EXTERNALS_PARENT; " \
2546
2574
"DROP INDEX I_NODES_PARENT; " \
2552
2580
"PRAGMA user_version = 31; " \
2553
2581
""
2554
2582
2555
#define STMT_UPGRADE_31_SELECT_WCROOT_NODES 229
2556
#define STMT_229_INFO {"STMT_UPGRADE_31_SELECT_WCROOT_NODES", NULL}
2557
#define STMT_229 \
2583
#define STMT_UPGRADE_31_SELECT_WCROOT_NODES 231
2584
#define STMT_231_INFO {"STMT_UPGRADE_31_SELECT_WCROOT_NODES", NULL}
2585
#define STMT_231 \
2558
2586
"SELECT l.wc_id, l.local_relpath FROM nodes as l " \
2559
2587
"LEFT OUTER JOIN nodes as r " \
2560
2588
"ON l.wc_id = r.wc_id " \
2566
2594
" OR (l.repos_path IS NOT (CASE WHEN (r.local_relpath) = '' THEN (CASE WHEN (r.repos_path) = '' THEN (l.local_relpath) WHEN (l.local_relpath) = '' THEN (r.repos_path) ELSE (r.repos_path) || '/' || (l.local_relpath) END) WHEN (r.repos_path) = '' THEN (CASE WHEN (r.local_relpath) = '' THEN (l.local_relpath) WHEN SUBSTR((l.local_relpath), 1, LENGTH(r.local_relpath)) = (r.local_relpath) THEN CASE WHEN LENGTH(r.local_relpath) = LENGTH(l.local_relpath) THEN '' WHEN SUBSTR((l.local_relpath), LENGTH(r.local_relpath)+1, 1) = '/' THEN SUBSTR((l.local_relpath), LENGTH(r.local_relpath)+2) END END) WHEN SUBSTR((l.local_relpath), 1, LENGTH(r.local_relpath)) = (r.local_relpath) THEN CASE WHEN LENGTH(r.local_relpath) = LENGTH(l.local_relpath) THEN (r.repos_path) WHEN SUBSTR((l.local_relpath), LENGTH(r.local_relpath)+1, 1) = '/' THEN (r.repos_path) || SUBSTR((l.local_relpath), LENGTH(r.local_relpath)+1) END END))) " \
2567
2595
""
2568
2596
2569
#define STMT_UPGRADE_TO_32 230
2570
#define STMT_230_INFO {"STMT_UPGRADE_TO_32", NULL}
2571
#define STMT_230 \
2597
#define STMT_UPGRADE_TO_32 232
2598
#define STMT_232_INFO {"STMT_UPGRADE_TO_32", NULL}
2599
#define STMT_232 \
2572
2600
"DROP INDEX IF EXISTS I_ACTUAL_CHANGELIST; " \
2573
2601
"DROP INDEX IF EXISTS I_EXTERNALS_PARENT; " \
2574
2602
"CREATE INDEX I_EXTERNALS_PARENT ON EXTERNALS (wc_id, parent_relpath); " \
2621
2649
"DROP TABLE ACTUAL_NODE_BACKUP; " \
2622
2650
""
2623
2651
2624
#define STMT_VERIFICATION_TRIGGERS 231
2625
#define STMT_231_INFO {"STMT_VERIFICATION_TRIGGERS", NULL}
2626
#define STMT_231 \
2652
#define STMT_VERIFICATION_TRIGGERS 233
2653
#define STMT_233_INFO {"STMT_VERIFICATION_TRIGGERS", NULL}
2654
#define STMT_233 \
2627
2655
"CREATE TEMPORARY TRIGGER no_repository_updates BEFORE UPDATE ON repository " \
2628
2656
"BEGIN " \
2629
2657
" SELECT RAISE(FAIL, 'Updates to REPOSITORY are not allowed.'); " \
2896
2924
STMT_229, \
2897
2925
STMT_230, \
2898
2926
STMT_231, \
2927
STMT_232, \
2928
STMT_233, \
2899
2929
NULL \
2900
2930
}
2901
2931
3133
3163
STMT_229_INFO, \
3134
3164
STMT_230_INFO, \
3135
3165
STMT_231_INFO, \
3166
STMT_232_INFO, \
3167
STMT_233_INFO, \
3136
3168
{NULL, NULL} \
3137
3169
}
Loggerhead is a web-based interface for Breezy
Version: 2.0.1