| /* wc-test-queries.sql -- queries used to verify wc metadata from |
| * the C tests. |
| * |
| * ==================================================================== |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * ==================================================================== |
| */ |
| |
| -- STMT_SELECT_NODES_INFO |
| SELECT op_depth, n.presence, n.local_relpath, revision, |
| repos_path, file_external, def_local_relpath, moved_to, moved_here, |
| properties |
| FROM nodes n |
| LEFT OUTER JOIN externals e |
| ON n.wc_id = e.wc_id |
| AND n.local_relpath = e.local_relpath |
| WHERE n.wc_id = ?1 |
| AND (n.local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(n.local_relpath, ?2)) |
| |
| -- STMT_SELECT_ACTUAL_INFO |
| SELECT local_relpath |
| FROM actual_node |
| WHERE wc_id = ?1 |
| AND conflict_data is NOT NULL |
| AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) |
| |
| -- STMT_DELETE_NODES |
| DELETE FROM nodes; |
| |
| -- STMT_INSERT_NODE |
| INSERT INTO nodes (local_relpath, op_depth, presence, repos_path, |
| revision, parent_relpath, moved_to, moved_here, |
| properties, wc_id, repos_id, kind, |
| depth) |
| VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, 1, |
| CASE WHEN ?3 != 'base-deleted' THEN 1 END, |
| 'dir', |
| CASE WHEN ?3 in ('normal', 'incomplete') |
| THEN 'infinity' END) |
| |
| -- STMT_DELETE_ACTUAL |
| DELETE FROM actual_node; |
| |
| -- STMT_INSERT_ACTUAL |
| INSERT INTO actual_node (local_relpath, parent_relpath, changelist, wc_id) |
| VALUES (?1, ?2, ?3, 1) |
| |
| -- STMT_ENSURE_EMPTY_PRISTINE |
| INSERT OR IGNORE INTO pristine (checksum, md5_checksum, size, refcount) |
| VALUES ('$sha1$da39a3ee5e6b4b0d3255bfef95601890afd80709', |
| '$md5 $d41d8cd98f00b204e9800998ecf8427e', |
| 0, 0) |
| |
| -- STMT_NODES_SET_FILE |
| UPDATE nodes |
| SET kind = 'file', |
| checksum = '$sha1$da39a3ee5e6b4b0d3255bfef95601890afd80709', |
| depth = NULL |
| WHERE wc_id = 1 and local_relpath = ?1 |
| |
| -- STMT_SELECT_ALL_ACTUAL |
| SELECT local_relpath FROM actual_node WHERE wc_id = 1 |
| |