|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
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 |