Open PostgreSQL and Create a table student in database student.
CREATE EXTENSION hstore;
CREATE TABLE student (
id int,
name varchar(254) NOT NULL,
hobbies text[],
marks hstore
);| package com.tutorial.sample | |
| import akka.http.scaladsl.model.ws.{Message, TextMessage} | |
| import akka.http.scaladsl.server.Directives | |
| import akka.stream.scaladsl.{Flow, Source} | |
| trait HighLevelWebSocketSample extends Directives { | |
| def route = | |
| path("chat") { |
| import akka.actor.ActorSystem | |
| import akka.event.Logging | |
| import akka.http.scaladsl.Http | |
| import akka.http.scaladsl.model.HttpMethods._ | |
| import akka.http.scaladsl.model._ | |
| import akka.stream.ActorMaterializer | |
| import akka.stream.scaladsl.Sink | |
| import scala.concurrent.Future |
| package com.tutorial.sample | |
| import akka.actor.ActorSystem | |
| import akka.event.Logging | |
| import akka.http.scaladsl.marshallers.sprayjson.SprayJsonSupport | |
| import akka.http.scaladsl.model.{ContentTypeRange, MediaTypes, StatusCodes} | |
| import akka.http.scaladsl.server.Directives._ | |
| import akka.http.scaladsl.server.{Route, UnsupportedRequestContentTypeRejection} | |
| import akka.http.scaladsl.server.directives.MethodDirectives.{get, post} | |
| import akka.http.scaladsl.server.directives.RouteDirectives.complete |
| package com.tutorial.sample | |
| import akka.http.scaladsl.model._ | |
| import akka.http.scaladsl.server.Directives._ | |
| import akka.http.scaladsl.server.Route | |
| import akka.http.scaladsl.server.directives.RouteDirectives.complete | |
| import akka.http.scaladsl.testkit.ScalatestRouteTest | |
| import org.scalatest.{Matchers, WordSpec} | |
| package com.tutorial.sample | |
| import akka.http.scaladsl.model.headers.{CustomHeader, ModeledCustomHeader, ModeledCustomHeaderCompanion, RawHeader} | |
| import org.scalatest._ | |
| import scala.util.Try | |
| class CustomHeaderSpec extends FlatSpec with Matchers with BeforeAndAfterAll { | |
| final class ApiTokenModeledHeader(token: String) extends ModeledCustomHeader[ApiTokenModeledHeader] { |
| package com.tutorial.sample | |
| import akka.http.scaladsl.marshallers.sprayjson.SprayJsonSupport | |
| import akka.http.scaladsl.model.HttpCharsets._ | |
| import akka.http.scaladsl.model.HttpMethods.{POST, PUT} | |
| import akka.http.scaladsl.model.HttpProtocols.`HTTP/1.0` | |
| import akka.http.scaladsl.model.MediaTypes.`text/plain` | |
| import akka.http.scaladsl.model.headers.BasicHttpCredentials | |
| import akka.http.scaladsl.model.{StatusCodes, headers => mHeaders, _} | |
| import akka.http.scaladsl.server.Directives._ |
| object Sum { | |
| def main(args: Array[String]) { | |
| println(io.Source.stdin.getLines().take(2).map(_.toInt).sum) | |
| } | |
| } |
Open PostgreSQL and Create a table student in database student.
CREATE EXTENSION hstore;
CREATE TABLE student (
id int,
name varchar(254) NOT NULL,
hobbies text[],
marks hstore
);