static void qServerEnd()
{
#ifndef Q_NO_MYSQL_EMBEDDED
# if MYSQL_VERSION_ID >= 40000
mysql_server_end();
# endif // MYSQL_VERSION_ID
#endif // Q_NO_MYSQL_EMBEDDED
}
int db__driver_close_database(void)
{
mysql_close(connection); /* this will also release connection */
mysql_server_end();
return DB_OK;
}
static PyObject* wsql_server_end(PyObject *self)
{
if (wsql_server_init_done) {
#if MYSQL_VERSION_ID >= 40000
mysql_server_end();
#endif
wsql_server_init_done = 0;
Py_RETURN_NONE;
}
return wsql_raise_error(NULL);
}
extern int mysql_db_cleanup()
{
debug3("starting mysql cleaning up");
#ifdef mysql_library_end
mysql_library_end();
#else
mysql_server_end();
#endif
debug3("finished mysql cleaning up");
return SLURM_SUCCESS;
}
static PyObject *_mysql_server_end(
PyObject *self,
PyObject *unused) {
if (_mysql_server_init_done) {
#if MYSQL_VERSION_ID >= 40000
mysql_server_end();
#endif
_mysql_server_init_done = 0;
Py_INCREF(Py_None);
return Py_None;
}
return _mysql_Exception(NULL);
}
/* button which handle the init of mysql server or quit the app */
void __fastcall TForm1::ToggleButtonClick(TObject *Sender)
{
if (!is_server_started)
{
mysql_server_init(NULL, NULL, (char **)server_groups) ;
connect_server();
get_dbs();
}
else
{
mysql_server_end();
Close();
}
}
int main(int argc, char **argv)
{
mysql_library_init(0,0,NULL);
if (argc > 1)
get_options(argc, argv);
get_envvars();
run_tests(my_tests);
mysql_server_end();
return(exit_status());
}
int main(void)
{
MYSQL *mysql;
MYSQL *mysqlr;
MYSQL_RES *results;
MYSQL_ROW record;
mysql = mysql_init(NULL);
unsigned int num = 0;
int i = 0;
MYSQL_FIELD *field;
char sql[100] = "select * from fixtable limit 10";
mysqlr = mysql_real_connect(mysql, "127.0.0.1","root","1", "test", 3306,NULL,0);
if(mysqlr == NULL) {
printf("error\r\n");
printf("mysql_real_connect failed: %s\r\n", mysql_error(mysql));
exit(1);
}
while(1) {
mysql_query(mysql, sql);
results = mysql_store_result(mysql);
num = mysql_num_fields(results);
for(i=0;i<num;i++) {
field = mysql_fetch_field_direct(results, i);
printf("%10s|", field->name);
}
printf("\r\n");
while((record = mysql_fetch_row(results))) {
for(i=0;i<num;i++) {
printf("%10s|", record[i]);
}
printf("\r\n---------------------------------------------------------------------\r\n");
}
printf("SQL: %s \r\n", sql);
printf("\r\nsql>");
fgets(sql, 100, stdin);
}
mysql_free_result(results);
mysql_close(mysql);
mysql_server_end();
return 0;
}
int main(void)
{
// int msi = mysql_server_init(num_elements, server_options, server_groups);
// printf("mysql_server_init: %d \r\n", msi);
mysql = mysql_init(NULL);
// mysql_options(mysql, MYSQL_READ_DEFAULT_GROUP, "libmysqld_client");
// mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL);
unsigned int num = 0;
int i = 0;
MYSQL_FIELD *field;
mysqlr = mysql_real_connect(mysql, "127.0.0.1","root","111111", "stone", 3306,NULL,0);
if(mysqlr == NULL) {
printf("error\r\n");
printf("mysql_real_connect failed: %s\r\n", mysql_error(mysql));
exit(1);
}
mysql_query(mysql, "select * from fixtable limit 10");
results = mysql_store_result(mysql);
num = mysql_num_fields(results);
for(i=0;i<num;i++) {
field = mysql_fetch_field_direct(results, i);
printf("%s |", field->name);
}
printf("\r\n");
while((record = mysql_fetch_row(results))) {
for(i=0;i<num;i++) {
printf("%s |", record[i]);
}
printf("\r\n----------------------\r\n");
}
mysql_free_result(results);
mysql_close(mysql);
mysql_server_end();
return 0;
}
MySQLTemplate()
{
int rc = 0;
MYSQL *db_connection;
MYSQL_RES *query_result;
MYSQL_ROW result_row;
char *server = "localhost";
char *user = "******";
char *password = "******";
char *database = "LRDB";
int port = 3306; // default MySQL port
//static char *server_options[] = { "mysql_test", "--defaults-file=my.cnf" };
//int num_elements = sizeof(server_options)/ sizeof(char *);
lr_whoami(&vuser_id, &vuser_group, &scid);
lr_message( "Group: %s, vuser id: %d, scenario id %d", vuser_group, vuser_id, scid);
if (vuser_id == -1) {
vuser_id = 1;
}
rc = lr_load_dll("C:\\Program Files\\MySQL\\MySQL Server 5.0\\lib\\opt\\libmysql.dll");
// You should be able to find the MySQL DLL somewhere in your MySQL install directory.
if (rc != 0) {
lr_error_message("Could not load libmysql.dll");
lr_abort();
}
// Allocate and initialise a new MySQL object
db_connection = mysql_init(NULL);
if (db_connection == NULL) {
lr_error_message("Insufficient memory");
return -1;
}
// Connect to the database
if (mysql_real_connect(db_connection, server, user, password, database, port, NULL, 0) == NULL) {
lr_error_message("error on connect: %s\n", mysql_error(db_connection));
return -1;
}
if (mysql_query(db_connection, "SELECT * FROM LATLogin;")!= 0) {
lr_error_message("error on query: %s\n", mysql_error(db_connection));
return -1;
}
if ((query_result = mysql_store_result(db_connection)) == NULL) {
lr_error_message("error on store: %s\n", mysql_error(db_connection));
return -1;
}
while (result_row = mysql_fetch_row(query_result)) {
lr_output_message("%s - %s", result_row[0]);
}
mysql_free_result(query_result);
// Free the MySQL object created by mysql_init
mysql_close(db_connection);
mysql_server_end();
return 0;
}
int DBMS::end_server_sql(){
mysql_server_end();
return 0;
}
//---------------------------------------------------------------------------
void __fastcall TForm1::FormDestroy(TObject *Sender)
{
if (is_server_started)
mysql_server_end();
}
/* Class method: MySQL client library finalization */
void MysqlConnection_onstop(void) {
if (mysql_get_client_version() >= 50003)
mysql_library_end();
else
mysql_server_end();
}
