#include "dbl.h"

int main()
{
    path( "D:\\" ); //set the path to the folder where the files will be stored

    database db("mydatabase");  //mydatabase is the name of the database
    db.new_tab("customer");  //create a new table called customer in the database
	
    write(db);  //write the database structure into a file

    char pkey = 1;
    table *tab = db.get_tab("customer"); //get the table customer from the database
    tab->add_col("cod", INTEGER, 1, pkey);  //add a column called cod to the table customer
    tab->add_col("name", CHARACTER, 32);  //add a column called name to the table customer
    tab->add_col("brithdate", INTEGER, 3);
    tab->add_col("sex", CHARACTER, 1);
    tab->add_col("phone", INTEGER, 1);
    tab->set_structure();
    write(*tab);  //write the table structure into files
    create_data_file(*tab); //create the data file of the table customer
    
    return 0;
}

#include "dbl.h"

int main()
{
    path( "D:\\" ); //set the path to the folder where the files will be stored

    database db("mydatabase");  //mydatabase is the name of the database
    read(db); //load the database structure
    
    table *tab = db.get_tab("customer"); //get the table customer from the database
    row r( tab->new_row() ); //get a row with the structure of the table customer
    
    int cod = 31415;
    char name[32] = "Charles";
    int birthdate[3] = {27, 6, 2010};
    char sex = 'm';
    int phone = 88123456;
    
    //set the values stored by the row
    r.set(0, &cod);
    r.set(1, name);
    r.set(2, birthdate);
    r.set(3, &sex);
    r.set(4, &phone);
    
    int i = num_row(*tab); //get the number of rows in the data file

    //write the row into the data file of the table customer,
    //where i is the index of the new record
    write(*tab, r, i );

    return 0;
}