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











SourceForge.net Logo

SQL MySql

 

Demonstrates MySQL interface

 

 

main.cpp

 

#include <MySql/MySql.h>

 

// debian: sudo apt-get install libmysqlclient-dev

 

using namespace Upp;

 

#define SCHEMADIALECT <MySql/MySqlSchema.h>

#define MODEL <SQL_MySql/schema.sch>

#include <Sql/sch_header.h>

#include <Sql/sch_source.h>

#include <Sql/sch_schema.h>

 

CONSOLE_APP_MAIN

{

    MySqlSession session;

    // edit the connection parameters if necessary

    if(session.Connect("root", "Passw0rd", "test")) {

        Cout() << "Connected\n";

        SQL = session;

        

        SqlSchema sch(MY_SQL);

        All_Tables(sch);

        // create the table if necessary

        SqlPerformScript(sch.Upgrade());

        SqlPerformScript(sch.Attributes());

        SQL.ClearError();

        

        try {

            // insert some random data

            SQL & Insert(TEST_TABLE)(VALUE, Uuid::Create().ToString());

            // fetch some data

            Sql sql;

            sql * Select(ID, VALUE).From(TEST_TABLE)

                                   .OrderBy(Descending(ID))

                                   .Limit(5);

            while(sql.Fetch())

                Cout() << AsString(sql[0]) << ": " << AsString(sql[VALUE]) << "\n";

        }

        catch(SqlExc &ex) {

            Cerr() << "ERROR: " << ex << "\n";

            SetExitCode(1);

        }

    }

    else {

        Cerr() <<"ERROR: Unable to connect to database\n";

        SetExitCode(1);

    }

}

 

 

 

schema.sch

 

TABLE_(TEST_TABLE)

    INT_     (ID)           PRIMARY_KEY AUTO_INCREMENT

    STRING_  (VALUE, 32)

END_TABLE

 

 

 

 

Do you want to contribute?