Skip to content

README.md

Latest commit

 

History

History
52 lines (35 loc) · 2.07 KB

README.md

File metadata and controls

52 lines (35 loc) · 2.07 KB

Samples-Stock-Data

This repository contains sample stock data and the scripts to load it into your InterSystems IRIS instance.

GET CONNECTED: Reset your password and get connection information

This sample assumes you already have an instance. If you do not yet have one, you can visit: Direct Access to InterSystems IRIS, Microsoft Azure, or Amazon Web Services.

  1. Reset the default passwords

    iris password This will ask you for your new password, and will reset the password for all default user accounts

  2. Check the status of your iris instance

    iris status This will show the current status of the InterSystems IRIS instance

  3. Get your connection information

    iris info This will show the external ip address and ports needed to make connections to InterSystems IRIS

LOADING DATA: Using GCP, Azure, or AWS

  1. Get the sample data and scripts

    iris load https://github.com/intersystems/Samples-Stock-Data

LOADING DATA: Using a local instance

  1. Clone this repository: git clone https://github.com/intersystems/Samples-Stock-Data
  2. Navigate to System Explorer > Classes and import into the USER namespace from the data folder: DemoStockCls.xml, StocksUtil.xml, and TradeAndPersonForHibernate.xml
  3. On the Management Portal home, under Links select Terminal. Run (replace with your home directory): do ##class(Demo.Stock).LoadData("<repo home>/data/all_stocks_1yr.csv")

TAKE A LOOK AT THE DATA - from the IRIS shell (database user)

  1. Start a SQL Session

    sudo docker exec -it try-iris iris session iris
Username: SuperUser
Password: <new password>
USER>> do $system.SQL.Shell()
[SQL]USER>> set selectmode=display
[SQL]USER>> select top 10 * from demo.stock where transdate = '8/12/2016' order by stockclose desc

  2. Try other SQL commands

  3. Type q to exit the SQL Session

  4. Type h to exit the iris session