diff options
| author | Andres Freund | 2013-05-29 00:34:47 +0000 |
|---|---|---|
| committer | Andres Freund | 2013-05-29 00:34:47 +0000 |
| commit | 0ecd3981b64eb81ec916c2c0011b94c586ce4788 (patch) | |
| tree | 1bcf77877a3f9e5618187300ac75bf6b644a2954 | |
| parent | 8d5c762e5e1fd53b89e6f361421d677414f7b7aa (diff) | |
bdr: sequences: indentbdr/0.4
| -rw-r--r-- | contrib/bdr/bdr_seq.c | 62 |
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" |
