// ĠCode Ġgenerated Ġby Ġsql c . ĠDO ĠNOT ĠEDIT . Ċ Ċ package Ġcom . example . on deck . postgresql Ċ Ċ import Ġjava . sql . Connection Ċ import Ġjava . sql . SQLException Ċ import Ġjava . sql . Statement Ċ import Ġjava . sql . Types Ċ import Ġjava . time . LocalDateTime Ċ Ċ interface ĠQueries Ġ{ ĊĠ Ġ@ Throws ( SQLException :: class ) ĊĠ Ġfun Ġcreate City ( name : ĠString , Ġslug : ĠString ): ĠCity ? ĊĠĠĊĠ Ġ@ Throws ( SQLException :: class ) ĊĠ Ġfun Ġcreate Venue ( ĊĠĠĠĠĠ Ġslug : ĠString , ĊĠĠĠĠĠ Ġname : ĠString , ĊĠĠĠĠĠ Ġcity : ĠString , ĊĠĠĠĠĠ Ġspot ify Playlist : ĠString , ĊĠĠĠĠĠ Ġstatus : ĠStatus , ĊĠĠĠĠĠ Ġstatuses : ĠList < Status >, ĊĠĠĠĠĠ Ġtags : ĠList < String >): ĠInt ? ĊĠĠĊĠ Ġ@ Throws ( SQLException :: class ) ĊĠ Ġfun Ġdelete Venue ( slug : ĠString ) ĊĠĠĊĠ Ġ@ Throws ( SQLException :: class ) ĊĠ Ġfun Ġget City ( slug : ĠString ): ĠCity ? ĊĠĠĊĠ Ġ@ Throws ( SQLException :: class ) ĊĠ Ġfun Ġget Venue ( slug : ĠString , Ġcity : ĠString ): ĠV en ue ? ĊĠĠĊĠ Ġ@ Throws ( SQLException :: class ) ĊĠ Ġfun Ġlist C ities (): ĠList < City > ĊĠĠĊĠ Ġ@ Throws ( SQLException :: class ) ĊĠ Ġfun Ġlist Ven ues ( city : ĠString ): ĠList < Venue > ĊĠĠĊĠ Ġ@ Throws ( SQLException :: class ) ĊĠ Ġfun Ġupdate City Name ( name : ĠString , Ġslug : ĠString ) ĊĠĠĊĠ Ġ@ Throws ( SQLException :: class ) ĊĠ Ġfun Ġupdate Venue Name ( name : ĠString , Ġslug : ĠString ): ĠInt ? ĊĠĠĊĠ Ġ@ Throws ( SQLException :: class ) ĊĠ Ġfun Ġven ue Count By City (): ĠList < Venue Count By City Row > ĊĠĠ Ċ } ĊĊ