github.com/benoitkugler/goacve@v0.0.0-20201217100549-151ce6e55dc8/server/vote/scans_test.go (about) 1 // DON'T EDIT - automatically generated by structgen // 2 3 package vote 4 5 func queriesCandidat(tx DB, item Candidat) (Candidat, error) { 6 item, err := item.Insert(tx) 7 8 if err != nil { 9 return item, err 10 } 11 rows, err := tx.Query("SELECT * FROM candidats") 12 if err != nil { 13 return item, err 14 } 15 items, err := ScanCandidats(rows) 16 if err != nil { 17 return item, err 18 } 19 20 _ = items.Ids() 21 22 item, err = item.Update(tx) 23 if err != nil { 24 return item, err 25 } 26 _, err = SelectCandidat(tx, item.Id) 27 28 return item, err 29 } 30 31 func queriesVote(tx DB, item Vote) (Vote, error) { 32 item, err := item.Insert(tx) 33 34 if err != nil { 35 return item, err 36 } 37 rows, err := tx.Query("SELECT * FROM votes") 38 if err != nil { 39 return item, err 40 } 41 items, err := ScanVotes(rows) 42 if err != nil { 43 return item, err 44 } 45 46 _ = items.Ids() 47 48 item, err = item.Update(tx) 49 if err != nil { 50 return item, err 51 } 52 _, err = SelectVote(tx, item.Id) 53 54 return item, err 55 } 56 57 func queriesVotePersonne(tx DB, item VotePersonne) (VotePersonne, error) { 58 err := InsertManyVotePersonnes(tx, item) 59 if err != nil { 60 return item, err 61 } 62 rows, err := tx.Query("SELECT * FROM vote_personnes") 63 if err != nil { 64 return item, err 65 } 66 items, err := ScanVotePersonnes(rows) 67 if err != nil { 68 return item, err 69 } 70 71 _ = len(items) 72 73 row := tx.QueryRow(`SELECT * FROM vote_personnes WHERE 74 id_vote = $1 AND id_personne = $2;`, item.IdVote, item.IdPersonne) 75 _, err = ScanVotePersonne(row) 76 77 return item, err 78 } 79 80 func queriesVotePersonneCandidat(tx DB, item VotePersonneCandidat) (VotePersonneCandidat, error) { 81 err := InsertManyVotePersonneCandidats(tx, item) 82 if err != nil { 83 return item, err 84 } 85 rows, err := tx.Query("SELECT * FROM vote_personne_candidats") 86 if err != nil { 87 return item, err 88 } 89 items, err := ScanVotePersonneCandidats(rows) 90 if err != nil { 91 return item, err 92 } 93 94 _ = len(items) 95 96 row := tx.QueryRow(`SELECT * FROM vote_personne_candidats WHERE 97 id_vote = $1 AND id_personne = $2 AND id_candidat = $3;`, item.IdVote, item.IdPersonne, item.IdCandidat) 98 _, err = ScanVotePersonneCandidat(row) 99 100 return item, err 101 }