import de.bezier.data.sql.*;

MySQL msql;
PFont font;

// what table and what column to query in db
// this determines what data is played back
// SELECT name FROM objects, names_objects, words WHERE objects.id = names_objects.object_id AND names_objects.word_id = words.id AND words.word LIKE "dog%";


int minID;
int maxID;

// vars holding response most recent query
String data= "";
int id=0;


// timing
int last=0;

void setup()
{
  // general graphics setup
  size( 100, 100);
  background(0);
  smooth();

  // Font and text drawing setup
  font = loadFont("HelveticaNeue-48.vlw");
  textAlign(CENTER);
  textAlign(CENTER,CENTER);
  rectMode(CORNER);
  fill(255);
  textFont(font, 64);

  int randomseed = 0;
  randomSeed(randomseed);

  // this example assumes that you are running the 
  // mysql server locally (on "localhost").
  //
  // replace --username--, --password-- with your mysql-account.
  //
  String user     = "bob";
  String pass     = "password";

  // name of the database to use
  String database = "naming";

  // connect to database of server "localhost"
  msql = new MySQL( this, "localhost", database, user, pass );

  if ( msql.connect() )
  {   
    msql.query( "SELECT name FROM objects, names_objects, words WHERE objects.id = names_objects.object_id AND names_objects.word_id = words.id AND words.word LIKE \"dog%\";" );
    while(msql.next()) {
      String result=msql.getString(1);
    println(result  );
    }
  }
  else
  {
    // connection failed !
    println("connection failed!");
    exit();
  }
}

void draw()
{
}