isc-rsingh

{
  "datasets": [
    {
      "name": "The Museum of Modern Art (MoMA) Collection",
      "url": "https://github.com/MuseumofModernArt/collection"
    },
    {
      "name": "Coronavirus (Covid-19) Data in the United States", 
      "url": "https://github.com/nytimes/covid-19-data"
    },

isc-rsingh

set $namespace="%SYS" do ##class(Security.SSLConfigs).Create("ssl") set r=##class(%Net.HttpRequest).%New(),r.Server="pm.community.intersystems.com",r.SSLConfiguration="ssl" do r.Get("/packages/zpm/latest/installer"),$system.OBJ.LoadStream(r.HttpResponse.Data,"c")

isc-rsingh

# get the data from https://data.boston.gov/dataset/crime-incident-reports-august-2015-to-date-source-new-system

badfile = open('bostonpolice.csv', 'r')
betterfile = open('tmp.csv', 'w')

while True:
    line = badfile.readline().strip()
    if not line:
        break
    # figure out if the line has been broken incorrectly

isc-rsingh

import pyodbc
from flask import Flask
from flask import request
from flask import render_template
import json
app = Flask(__name__)
connection = None

# default route
@app.route('/')

isc-rsingh

PyODBC installation instructions

Install ODBC

• Windows: no installation necessary
• Mac
  1. Run brew update
  2. Run brew install unixodbc
• Linux

1. Run apt-get update

isc-rsingh

/// ObjectScript does not include any built-in method for appending one JSON dynamic array to another.
/// This is equivalent to the JavaScript concat() method.
/// Call it with any number of arguments to concatenate them into a new array.
/// If an argument is a dynamic array, its elements will be added. Otherwise the argument itself will be added.
/// Thanks to Pravin Barton in this article https://community.intersystems.com/post/code-sample-concatenate-json-arrays
ClassMethod ConcatArrays(pArgs...) As %DynamicArray
{
    set outArray = ##class(%DynamicArray).%New() // or []
        for i=1:1:pArgs {
        set arg = pArgs(i)

isc-rsingh

ROUTINE RightTriangle
  /* compute area and hypotenuse of a right triangle
                  this routine contains examples of 
                  new ObjectScript features */
    Write !, "Compute the area and hypotenuse of a right triangle",
          !, "given the lengths of its two sides."
    Set units = "feet"
    Set side1 = 3
    Set side2 = 6
    Do Compute( units, side1, side2)

isc-rsingh

set file = ##class(%File).%New( "data.csv" )
    set sc = file.Open( "R" ) 
    if $$$ISERR(sc) quit    ; or do smth

    while 'file.AtEnd {
        set str=file.ReadLine() 
        for i=1:1:$length( str, ";" ) {
            set id=$piece( str, ";" ,i ) 
            write !, id  // or do smth
        }

isc-rsingh

isc-rsingh