Scala, Play and MySQL Integration Template This example shows how to run AnyChart library with the Scala programming language using Play framework 2.5.x and MySQL.

View on GitHub

Running

To use this sample you must have Java, Scala, Activator and Mysql installed, if you do not have Java, please, visit Java download page; if you do not have Scala, please, visit Scala official site; if you do not have Activator, please, visit Activator download page; if you do not have MySQL, please, visit MySQL download page and follow instructions

To check your Java installation, run following command in command line:


$ java -version
java version "1.8.0_111"        # sample output
Java(TM) SE Runtime Environment (build 1.8.0_111-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.111-b14, mixed mode)
                    

To check your Scala installation, run following command in command line:


$ scala -version
Scala code runner version 2.12.0 -- Copyright 2002-2016, LAMP/EPFL and Lightbend, Inc.     # sample output
                    

To check your Activator installation, run following command in command line:


$ activator
Did not detect an activator project in this directory...  # sample output
                    

To check your MySQL installation, run following command in command line:


$ mysql --version
mysql  Ver 14.14 Distrib 5.5.52, for debian-linux-gnu (x86_64) using readline 6. # sample output
                    

To start this example run commands listed below.

Clone the repository from github.com to your workspace folder:


$ git clone git@github.com:anychart-integrations/scala-play-mysql-template.git
                    

Navigate to the repository folder:


$ cd scala-play-mysql-template
                    

Set up MySQL database, use -u -p flags to provide your user name and password:


$  mysql < database_backup.sql
                    

Run app


$ activator run
                    

open browser at http://localhost:9000/


Workspace

Your workspace should look like:


scala-play-mysql-template/
    app/
        controllers/
            ChartController.scala           # web controller to display chart
            ... other controllers
        filters/
            ...
        models/
            DBFruits.scala                  # Slick MySQL database access class
        services/
            ... some example services
        views/
            chart.scala.html                # view
            ... other views
        Filters.scala
        Module.scala
    bin/
    conf/
        application.conf                    # main application settings
        routes                              # routes
    libexec/
    logs/
    project/
    public/
        images/
        javascripts/
        stylesheets/
            main.css                        # main css style
    target/
    test/
    .gitignore
    build.sbt
    database_backup.sql                     # use this file to set your MySQL database
    LICENSE
    README.md
                    

More about anatomy of Play application you can see here.


Technologies


Further Learning


License

AnyChart Scala/Play/MySQL integration sample includes two parts:

  • Code of the integration sample that allows to use Javascript library (in this case, AnyChart) with Scala language, Play framework and MySQL database. You can use, edit, modify it, use it with other Javascript libraries without any restrictions. It is released under Apache 2.0 License.
  • AnyChart JavaScript library. It is released under Commercial license. You can test this plugin with the trial version of AnyChart. Our trial version is not limited by time and doesn't contain any feature limitations. Check details here.

If you have any questions regarding licensing - please contact us. sales@anychart.com