summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndres Freund2013-05-29 00:34:47 +0000
committerAndres Freund2013-05-29 00:34:47 +0000
commit0ecd3981b64eb81ec916c2c0011b94c586ce4788 (patch)
tree1bcf77877a3f9e5618187300ac75bf6b644a2954
parent8d5c762e5e1fd53b89e6f361421d677414f7b7aa (diff)
bdr: sequences: indentbdr/0.4
-rw-r--r--contrib/bdr/bdr_seq.c62
1 files changed, 31 insertions, 31 deletions
diff --git a/contrib/bdr/bdr_seq.c b/contrib/bdr/bdr_seq.c
index 43538a4a17..602dc229c6 100644
--- a/contrib/bdr/bdr_seq.c
+++ b/contrib/bdr/bdr_seq.c
@@ -67,7 +67,7 @@ static size_t bdr_seq_nsequencers = 0;
static shmem_startup_hook_type prev_shmem_startup_hook = NULL;
- /* vote */
+ /* vote */
const char* vote_sql =
"INSERT INTO bdr_votes (\n"
" vote_sysid,\n"
@@ -95,10 +95,10 @@ const char* vote_sql =
" AND val.seqname = election.seqname\n"
" AND val.seqrange && election.seqrange\n"
" --AND NOT val.confirmed\n"
-" AND val.owning_sysid = $1\n"
-" AND val.owning_tlid = $2\n"
-" AND val.owning_dboid = $3\n"
-" AND val.owning_riname = $4\n"
+" AND val.owning_sysid = $1\n"
+" AND val.owning_tlid = $2\n"
+" AND val.owning_dboid = $3\n"
+" AND val.owning_riname = $4\n"
" )\n"
" -- and we haven't allowed anybody else to use it\n"
" AND NOT EXISTS(\n"
@@ -112,10 +112,10 @@ const char* vote_sql =
" AND other_election.owning_election_id = vote.vote_election_id\n"
" )\n"
" WHERE true\n"
-" AND vote.voter_sysid = $1\n"
-" AND vote.voter_tlid = $2\n"
-" AND vote.voter_dboid = $3\n"
-" AND vote.voter_riname = $4\n"
+" AND vote.voter_sysid = $1\n"
+" AND vote.voter_tlid = $2\n"
+" AND vote.voter_dboid = $3\n"
+" AND vote.voter_riname = $4\n"
" AND other_election.seqname = election.seqname\n"
" AND other_election.seqschema = election.seqschema\n"
" AND other_election.seqrange && election.seqrange \n"
@@ -142,10 +142,10 @@ const char* vote_sql =
" AND owning_riname = vote_riname\n"
" AND owning_election_id = vote_election_id\n"
"\n"
-" AND voter_sysid = $1\n"
-" AND voter_tlid = $2\n"
-" AND voter_dboid = $3\n"
-" AND voter_riname = $4\n"
+" AND voter_sysid = $1\n"
+" AND voter_tlid = $2\n"
+" AND voter_dboid = $3\n"
+" AND voter_riname = $4\n"
" )\n"
"LIMIT 1\n"
";";
@@ -220,16 +220,16 @@ const char *start_elections_sql =
" SELECT COALESCE(max(owning_election_id), 0)\n"
" FROM bdr_sequence_elections biggest\n"
" WHERE\n"
-" biggest.owning_sysid = $1\n"
-" AND biggest.owning_tlid = $2\n"
-" AND biggest.owning_dboid = $3\n"
-" AND biggest.owning_riname = $4\n"
+" biggest.owning_sysid = $1\n"
+" AND biggest.owning_tlid = $2\n"
+" AND biggest.owning_dboid = $3\n"
+" AND biggest.owning_riname = $4\n"
" ) + row_number() OVER (),\n"
" 'sequence',\n"
" true AS open,\n"
" seqschema,\n"
" seqname,\n"
-" int8range(chunk_start, chunk_start + 1000) AS seqrange\n"
+" int8range(chunk_start, chunk_start + 1000) AS seqrange\n"
" FROM to_be_inserted_chunks\n"
" RETURNING\n"
" seqschema,\n"
@@ -323,11 +323,11 @@ const char *tally_elections_sql =
" success = (nays = 0)\n"
" FROM tallied_votes\n"
" WHERE\n"
-" bdr_sequence_elections.owning_sysid = tallied_votes.owning_sysid\n"
-" AND bdr_sequence_elections.owning_tlid = tallied_votes.owning_tlid\n"
-" AND bdr_sequence_elections.owning_dboid = tallied_votes.owning_dboid\n"
-" AND bdr_sequence_elections.owning_riname = tallied_votes.owning_riname\n"
-" AND bdr_sequence_elections.owning_election_id = tallied_votes.owning_election_id\n"
+" bdr_sequence_elections.owning_sysid = tallied_votes.owning_sysid\n"
+" AND bdr_sequence_elections.owning_tlid = tallied_votes.owning_tlid\n"
+" AND bdr_sequence_elections.owning_dboid = tallied_votes.owning_dboid\n"
+" AND bdr_sequence_elections.owning_riname = tallied_votes.owning_riname\n"
+" AND bdr_sequence_elections.owning_election_id = tallied_votes.owning_election_id\n"
" AND tallied_votes.sufficient\n"
" RETURNING bdr_sequence_elections.*\n"
"),\n"
@@ -341,10 +341,10 @@ const char *tally_elections_sql =
" AND bdr_sequence_values.seqschema = cast_votes.seqschema\n"
" AND bdr_sequence_values.seqname = cast_votes.seqname\n"
" AND bdr_sequence_values.seqrange = cast_votes.seqrange\n"
-" AND bdr_sequence_values.owning_sysid = $1\n"
-" AND bdr_sequence_values.owning_tlid = $2\n"
-" AND bdr_sequence_values.owning_dboid = $3\n"
-" AND bdr_sequence_values.owning_riname = $4\n"
+" AND bdr_sequence_values.owning_sysid = $1\n"
+" AND bdr_sequence_values.owning_tlid = $2\n"
+" AND bdr_sequence_values.owning_dboid = $3\n"
+" AND bdr_sequence_values.owning_riname = $4\n"
" RETURNING bdr_sequence_values.*\n"
"),\n"
"failed_sequence_values AS (\n"
@@ -357,10 +357,10 @@ const char *tally_elections_sql =
" AND bdr_sequence_values.seqschema = cast_votes.seqschema\n"
" AND bdr_sequence_values.seqname = cast_votes.seqname\n"
" AND bdr_sequence_values.seqrange = cast_votes.seqrange\n"
-" AND bdr_sequence_values.owning_sysid = $1\n"
-" AND bdr_sequence_values.owning_tlid = $2\n"
-" AND bdr_sequence_values.owning_dboid = $3\n"
-" AND bdr_sequence_values.owning_riname = $4\n"
+" AND bdr_sequence_values.owning_sysid = $1\n"
+" AND bdr_sequence_values.owning_tlid = $2\n"
+" AND bdr_sequence_values.owning_dboid = $3\n"
+" AND bdr_sequence_values.owning_riname = $4\n"
" RETURNING bdr_sequence_values.*\n"
")\n"
"\n"