← Back to branch summary

~drizzle-trunk/libdrizzle/jenkins-Libdrizzle-21

« back to all changes in this revision

Viewing changes to docs/examples/buffered.rst

  • Committer: Andrew Hutchings
  • Date: 2012-12-19 13:06:50 UTC
  • mfrom: (43.2.12 5.0)
  • Revision ID: andrew@linuxjedi.co.uk-20121219130650-kuebu0vxbeb7oyzy
Merge 5.0 docs changes into 5.1

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/examples/buffered.rst
 
1
Buffered Results
 
2
================
 
3
 
 
4
.. code-block:: c
 
5
 
 
6
    #include <libdrizzle/libdrizzle.h>
 
7
    #include <stdio.h>
 
8
    #include <stdlib.h>
 
9
 
 
10
    int main(int argc, char *argv[])
 
11
    {
 
12
      (void) argc;
 
13
      (void) argv;
 
14
      drizzle_st *drizzle;
 
15
      drizzle_con_st *con;
 
16
      drizzle_return_t ret;
 
17
      drizzle_result_st *result;
 
18
      drizzle_row_t row;
 
19
      int num_fields;
 
20
 
 
21
      drizzle = drizzle_create();
 
22
      if (drizzle == NULL)
 
23
      {
 
24
        printf("Drizzle object creation error\n");
 
25
        return EXIT_FAILURE;
 
26
      }
 
27
      con = drizzle_con_add_tcp(drizzle, "localhost", 3306, "user", "pass", "test", 0);
 
28
      if (con == NULL)
 
29
      {
 
30
        printf("Drizzle connection object creation error\n");
 
31
        return EXIT_FAILURE;
 
32
      }
 
33
      ret = drizzle_con_connect(con);
 
34
      if (ret != DRIZZLE_RETURN_OK)
 
35
      {
 
36
        printf("Drizzle connection failure\n");
 
37
        return EXIT_FAILURE;
 
38
      }
 
39
 
 
40
      result= drizzle_query_str(con, "select * from libdrizzle.t1", &ret);
 
41
      if (ret != DRIZZLE_RETURN_OK)
 
42
      {
 
43
        printf("Select failure\n");
 
44
        return EXIT_FAILURE;
 
45
      }
 
46
      drizzle_result_buffer(result);
 
47
      num_fields= drizzle_result_column_count(result);
 
48
 
 
49
      printf("%d fields\n", num_fields);
 
50
      while ((row = drizzle_row_next(result)))
 
51
      {
 
52
        printf("Data: ");
 
53
        for (uint16_t col=0; col < num_fields; col++)
 
54
        {
 
55
          printf("%s", row[col]);
 
56
        }
 
57
        printf("\n");
 
58
      }
 
59
 
 
60
      drizzle_result_free(result);
 
61
 
 
62
      drizzle_con_quit(con);
 
63
      drizzle_free(drizzle);
 
64
      return EXIT_SUCCESS;
 
65
    }
 
66