Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site











SourceForge.net Logo

SqlS fn

 

Demonstrates utility functions of S_ structures

 

 

main.cpp

 

#include <Sql/Sql.h>

 

using namespace Upp;

 

#define MODEL <SqlS_fn/Schema.sch>

#define SCHEMADIALECT <plugin/sqlite3/Sqlite3Schema.h>

#include <Sql/sch_header.h>

#include <Sql/sch_source.h>

 

struct MyFieldOperator : FieldOperator {

    virtual void Field(const char *name, Ref f) {

        LOG("Field " << name << ", value: " << (Value)f);

        if(name == String("NAME"))

            f = "Carl";

    }

};

 

CONSOLE_APP_MAIN

{

    StdLogSetup(LOG_COUT|LOG_FILE);

 

    S_PERSON p;

    

    p.ID = 100;

    p.NAME = "John";

    p.LASTNAME = "Smith";

 

    DUMP(p);

 

    DUMP(p.TableName);

 

    DUMP(SqlCompile(SQLITE3, ~p.ColumnSet()));

    DUMP(SqlCompile(SQLITE3, ~p.ColumnSet("PREFIX_")));

    DUMP(SqlCompile(SQLITE3, ~p.Of(PERSON)));

 

    DUMPC(p.GetColumnIds());

 

    DUMP(p.Get(ID));

    DUMP(p.Get(LASTNAME));

    DUMP(p.Get());

    

    p.Set(LASTNAME, "Carpenter");

    DUMP(p.Get());

    

    ValueMap m;

    m(ID, 123);

    p.Set(m);

    DUMP(p);

 

    S_PERSON p2;

    p2 = p;

    DUMP(p == p2);

    p2.ID = 101;

    DUMP(p == p2);

    

    MyFieldOperator fo;

    p.FieldLayout(fo);

    

    DUMP(p.NAME);

    

    DUMP(p.GetCount());

    for(int i = 0; i < p.GetCount(); i++) {

        LOG("------");

        DUMP(p.GetId(i));

        DUMP(p.Get(i));

        DUMP(p.GetWidth(i));

    }

}

 

 

 

Schema.sch

 

TABLE_(PERSON)

  INT_     (ID) PRIMARY_KEY

  STRING_  (NAME, 200)

  STRING_  (LASTNAME, 200)

END_TABLE

 

 

 

 

Do you want to contribute?