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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
/*-
* See the file LICENSE for redistribution information.
*
* Copyright (c) 1997, 2013 Oracle and/or its affiliates. All rights reserved.
*
*/
#include "ex_sql_utils.h"
/*
* This example demonstrates how to create a table and add data to it.
* Example 1. Create table university and insert data from data/university.csv.
* Example 2. Create table country and insert data from data/country.csv.
*/
/* Example body. */
static int
ex_sql_load(db)
db_handle *db;
{
/* Create table university. */
echo_info("STEP1. Create Table university");
/* Load data from table data source. */
load_table_from_file(db, university_sample_data, 0);
/* Create table contries. */
echo_info("STEP2. Create Table country");
/* Load data from table data source. */
load_table_from_file(db, country_sample_data, 0);
return 0;
}
int
main()
{
db_handle *db;
/* Setup environment */
db = setup("./ex_sql_load.db");
/* Run example. */
ex_sql_load(db);
/* End. */
cleanup(db);
return 0;
}
|
