02.12.2012 19:26:00 • Categories: Applescript, MySql • Tags: Applescript, Mysql
AppleScript: MySQL via MySQLBridge
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