Skip to content

Demonstration of TSQL support in InterSystems IRIS. Checkers game

License

Notifications You must be signed in to change notification settings

antonum/TSQL-Checkers

Folders and files

NameName
Last commit message
Last commit date

Latest commit

63e77cc · Nov 24, 2021

History

23 Commits
Jun 23, 2021
Jun 23, 2021
Jun 23, 2021
Jun 23, 2021
Jun 23, 2021
Jun 23, 2021
Nov 21, 2021
Jun 23, 2021
May 7, 2019
Jun 23, 2021
Jun 23, 2021
Jun 23, 2021
Jun 23, 2021

Repository files navigation

TSQL Checkers

The game is a port of TSQL Checkers written by Steve Wint for SQL Server 2000. You can get the original script here http://www.stevewint.com Tested on InterSystems Cache' and InterSystems IRIS.

alt text

Quick installation for existing IRIS instance

Instructions below assume that you already have InterSystems IRIS installed. If not - the easiest way to try it would be to pull the InterSystems IRIS Community Edition Docker Image and follow the setup instructions.

In IRIS terminal USER>

!wget -O /tmp/checkers.tar.gz https://github.com/antonum/TSQL-Checkers/archive/master.tar.gz && tar -xvf /tmp/checkers.tar.gz -C /tmp
do $system.OBJ.LoadDir("/tmp/TSQL-Checkers-master/src/","ck",,1)
do ^checkers

Quick installation with Docker Compose and InterSystems IRIS Community Edition

$ git clone https://github.com/antonum/TSQL-Checkers.git
$ docker-compose up -d
$ docker-copmose exec iris iris session iris
USER>do ^checkers

See also

For more information on InterSystems IRIS support for Transact-SQL (TSQL), SQL Server and Sybase to IRIS Migration tools see Transact-SQL (TSQL) Migration Guide

Hints if the original docu is unavailable

  • Rules are standard rules of Checker
  • Moves are done by entering start and target coordinates e.g. F2E1 or f2e1 also f2-e1
  • An invalid move results in +11^checker
  • Don't worry enter GOTO or simply G to continue with a valid move.
  • If your opponent reaches the bottom line and gets a KING it is totally paralized and can't move it anymore (Seems to be a bug)
  • So it'S hard not to be a winner.

Remember the focus is on TSQL support