old_contents: #!/usr/bin/python
  import bs
  import numpy as np
  import bs.bs_mesh as bm
  import bs.sql_well as sw
  
  # generate initial mesh
  cell_x = 50; cell_y = 50; cell_z = 50;
  dx = np.array([cell_x], dtype='d') # Lx
  dy = np.array([cell_y], dtype='d') # Ly
  dz = np.array([cell_z], dtype='d') # Lz
  Nx = 100
  Ny = 100
  Nz = 50
  [c, z] = bm.mesh_grdecl.gen_coord_zcorn(Nx, Ny, Nz, dx, dy, dz, 95000, 110000, 0);
  print 'Source mesh generated!'
  
  # open sql_well db
  s = sw.sql_well();
  s.open_db('db.db');
  
  # walk through all dates
  s.prepare_sql("SELECT d FROM dates");
  while s.step_sql() == 0 :
  	d = s.get_sql_real(0);
  	print "Completions on date", d;
  	sw.completions_ident(s, d, Nx, Ny, c, z);
  	print "Fractures on date", d;
  	sw.fractures_ident(s, d, Nx, Ny, c, z);
  
  
new_contents: #!/usr/bin/python
  import bs
  import numpy as np
  import bs.bs_mesh as bm
  import bs.sql_well as sw
  
  # generate initial mesh
  cell_x = 50; cell_y = 50; cell_z = 50;
  dx = np.array([cell_x], dtype='d') # Lx
  dy = np.array([cell_y], dtype='d') # Ly
  dz = np.array([cell_z], dtype='d') # Lz
  Nx = 100
  Ny = 100
  Nz = 50
  [c, z] = bm.mesh_grdecl.gen_coord_zcorn(Nx, Ny, Nz, dx, dy, dz, 95000, 110000, 0);
  print 'Source mesh generated!'
  
  # open sql_well db
  s = sw.sql_well();
  s.open_db('db.db');
  
  # prepare compdat_builder
  cb = sw.compdat_builder(Nx, Ny, c, z, s);
  
  # walk through all dates
  s.prepare_sql("SELECT d FROM dates");
  while s.step_sql() == 0 :
  	d = s.get_sql_real(0);
  
  	cb.clear();
  	cl = cb.build(d, 0);
  	print "Completions on date", d;
  	for c in cl :
  		c.dump();
  
  	cb.clear();
  	fr = cb.build(d, 1);
  	print "Fractures on date", d;
  	for f in fr :
  		f.dump();
  
  
subject: advance test script using compdat_builder interface