property mysql_pw : "scarlett"
property mysql_user : "root"
property mysql_host : "localhost"
property mysql_port : 3306
property mysql_socket : "/tmp/mysql.sock"

property mysql_db : "mysql"
property mysql_table : "user"

my make_connection(mysql_pw, mysql_user, mysql_host, mysql_port, mysql_socket, mysql_db)
set the_result1 to my sample_query("select * from user")
set the_result2 to my sample_query("show databases")
set the_result3 to my sample_query("show fields from user")
my close_connection()

return {the_result1, the_result2, the_result3}

on make_connection(mysql_pw, mysql_user, mysql_host, mysql_port, mysql_socket, mysql_db)
    tell application "MySQLBridge" to connect password mysql_pw user mysql_user host mysql_host port mysql_port socket mysql_socket database mysql_db
end make_connection

on sample_query(thisQuery)
    tell application "MySQLBridge" to return runSQL thisQuery
end sample_query

on close_connection()
    tell application "MySQLBridge" to close connection
end close_connection