int main(int argc, char *argv[]) { attachsql_connect_t *con= NULL; attachsql_error_st *error= NULL; const char *query= "SELECT * FROM t1 WHERE name='fred'"; attachsql_return_t ret= ATTACHSQL_RETURN_NONE; attachsql_query_row_st *row; uint16_t columns, current_column; con= attachsql_connect_create("localhost", 3306, "test", "test", "testdb", NULL); error= attachsql_query(con, strlen(query), query, 0, NULL); while ((ret != ATTACHSQL_RETURN_EOF) && (error == NULL)) { ret= attachsql_connect_poll(con, &error); if (ret != ATTACHSQL_RETURN_ROW_READY) { continue; } row= attachsql_query_row_get(con, &error); columns= attachsql_query_column_count(con); for (current_column= 0; current_column < columns; current_column++) { printf("%.*s ", (int)row[current_column].length, row[current_column].data); } printf("\n"); attachsql_query_row_next(con); } if (error != NULL) { printf("Error occurred: %s", error->msg); } attachsql_query_close(con); attachsql_connect_destroy(con); }
int main(void) { attachsql_connect_t *con= NULL; attachsql_error_t *error= NULL; const char *query= "SELECT * FROM t1 WHERE name = ? AND age > ?"; attachsql_return_t ret= ATTACHSQL_RETURN_NONE; con= attachsql_connect_create("localhost", 3306, "test", "test", "testdb", NULL); attachsql_statement_prepare(con, strlen(query), query, &error); while((ret != ATTACHSQL_RETURN_EOF) && (error == NULL)) { ret= attachsql_connect_poll(con, &error); } if (error != NULL) { printf("Error occurred: %s", attachsql_error_message(error)); attachsql_error_free(error); attachsql_statement_close(con); attachsql_connect_destroy(con); return 1; } const char *name= "fred"; uint32_t age= 30; attachsql_statement_set_string(con, 0, strlen(name), name, NULL); attachsql_statement_set_int(con, 1, age, NULL); attachsql_statement_execute(con, &error); ret= ATTACHSQL_RETURN_NONE; while ((ret != ATTACHSQL_RETURN_EOF) && (error == NULL)) { ret= attachsql_connect_poll(con, &error); if (ret != ATTACHSQL_RETURN_ROW_READY) { continue; } attachsql_statement_row_get(con, &error); printf("ID: %d, ", attachsql_statement_get_int(con, 0, &error)); size_t len; char *name_data= attachsql_statement_get_char(con, 1, &len, &error); printf("Name: %.*s, ", (int)len, name_data); printf("Age: %d\n", attachsql_statement_get_int(con, 2, &error)); attachsql_statement_row_next(con); } if (error != NULL) { printf("Error occurred: %s", attachsql_error_message(error)); attachsql_error_free(error); } attachsql_statement_close(con); attachsql_connect_destroy(con); }
int main(void) { attachsql_connect_t *con= NULL; attachsql_error_t *error= NULL; const char *query= "SELECT * FROM t1 WHERE name = ? AND age > ?"; attachsql_return_t ret= ATTACHSQL_RETURN_NONE; attachsql_query_row_st *row; uint16_t columns, current_column; attachsql_query_parameter_st param[2]; con= attachsql_connect_create("localhost", 3306, "test", "test", "testdb", NULL); const char *name= "fred"; uint32_t age= 30; param[0].type= ATTACHSQL_ESCAPE_TYPE_CHAR; param[0].data= (char*)name; param[0].length= strlen(name); param[1].type= ATTACHSQL_ESCAPE_TYPE_INT; param[1].data= &age; param[1].is_unsigned= true; attachsql_query(con, strlen(query), query, 2, param, &error); while ((ret != ATTACHSQL_RETURN_EOF) && (error == NULL)) { ret= attachsql_connect_poll(con, &error); if (ret != ATTACHSQL_RETURN_ROW_READY) { continue; } row= attachsql_query_row_get(con, &error); columns= attachsql_query_column_count(con); for (current_column= 0; current_column < columns; current_column++) { printf("%.*s ", (int)row[current_column].length, row[current_column].data); } printf("\n"); attachsql_query_row_next(con); } if (error != NULL) { printf("Error occurred: %s", attachsql_error_message(error)); attachsql_error_free(error); } attachsql_query_close(con); attachsql_connect_destroy(con); }
int attachsql_drv_connect(db_conn_t *sb_conn) { attachsql_connect_t *con= NULL; const char *host; attachsql_error_t *error= NULL; attachsql_return_t aret= ATTACHSQL_RETURN_NONE; if (args.socket) { DEBUG("attachsql_connect_create(\"%s\", \"%s\", \"%s\", \"%s\")", args.socket, args.user, args.password, args.db); con= attachsql_connect_create(args.socket, 0, args.user, args.password, args.db, &error); } else { pthread_mutex_lock(&hosts_mutex); hosts_pos = SB_LIST_ITEM_NEXT(hosts_pos); if (hosts_pos == args.hosts) hosts_pos = SB_LIST_ITEM_NEXT(hosts_pos); host = SB_LIST_ENTRY(hosts_pos, value_t, listitem)->data; pthread_mutex_unlock(&hosts_mutex); DEBUG("attachsql_connect_create(\"%s\", %u, \"%s\", \"%s\", \"%s\")", host, args.port, args.user, args.password, args.db); con= attachsql_connect_create(host, args.port, args.user, args.password, args.db, &error); } if (con == NULL) { log_text(LOG_FATAL, "unable to Add libAttachSQL Connection, aborting..."); log_text(LOG_FATAL, "error %d: %s", attachsql_error_code(error), attachsql_error_message(error)); attachsql_error_free(error); return 1; } attachsql_connect_set_option(con, ATTACHSQL_OPTION_SEMI_BLOCKING, NULL); if (!attachsql_connect(con, &error)) { log_text(LOG_FATAL, "unable to connect to libAttachSQL server"); log_text(LOG_FATAL, "error %d: %s", attachsql_error_code(error), attachsql_error_message(error)); attachsql_error_free(error); attachsql_connect_destroy(con); return 1; } while (aret != ATTACHSQL_RETURN_IDLE) { aret = attachsql_connect_poll(con, &error); if (error) { log_text(LOG_FATAL, "unable to connect to libAttachSQL server"); log_text(LOG_FATAL, "error %d: %s", attachsql_error_code(error), attachsql_error_message(error)); attachsql_error_free(error); attachsql_connect_destroy(con); return 1; } } sb_conn->ptr = con; return 0; }