text: # JSON Mode Test File
  # Released under MIT License
  # Copyright (c) 2020 TytusDb Team
  
  import Compi2RepoAux.team21.Analisis_Ascendente.storageManager.jsonMode as j
  
  # drop all databases if exists
  j.dropAll()
  
  # create database
  j.createDatabase('world')
  
  # create tables
  j.createTable('world', 'countries', 4)
  j.createTable('world', 'cities',    4)
  j.createTable('world', 'languages', 4)
  
  # create simple primary keys
  print(j.alterAddPK('world', 'countries', [0]))
  print(j.alterDropPK('world', 'countries'))
  print(j.alterAddPK('world', 'countries', [0,1]))
  j.alterAddPK('world', 'cities',    [0])
  j.alterAddPK('world', 'languages', [0, 1])
  
  print("agregar ",j.alterAddColumn('world','countries',1))
  print("agregar ",j.alterAddColumn('world','countries',1))
  
  print("eliminar ",j.alterDropColumn('world','countries',4))
  
  # insert data in countries
  j.insert('world', 'countries', ['GTM', 'Guatemala',  'Central America', 108889,1])
  j.insert('world', 'countries', ['SLV', 'El Salvado', 'Central America',  21041,2])
  
  
  # insert data in cities
  j.insert('world', 'cities', [2, 'prueba',    'Guatemala',    'GTM'])
  j.insert('world', 'cities', [2, 'Cuilapa',      'Santa Rosa',   'GTM'])
  j.insert('world', 'cities', [3, 'San Salvador', 'San Salvador', 'SLV'])
  j.insert('world', 'cities', [4, 'San Miguel',   'San Miguel',   'SLV'])
           
  # inser data in languages
  j.insert('world', 'languages', ['GTM', 'Spanish', 'official',  64.7])
  j.insert('world', 'languages', ['SLV', 'Spanish', 'official', 100.0])
  print(j.extractTable('world','cities'))
  print(j.delete('world','cities',[2]))
  print(j.extractTable('world','cities'))
  print("-----------------------------------------")
  
  
  print(j.extractRangeTable('world','cities','M','l'))
  #j.showCollection()
  