SQLwith partial.js (mySQL and PostgreSQL - Pg)

[Hasan A Yousef]

Peter,

Thanks a lot for your help, time and efforts with me to start partial.j and node.js, and help in he last days to connect them with SQL database, both PostgreSQL and mySQL.

As I thing the effort spent may be help full for others, I'm attaching here the starting of both of them, that other users may build on, not sure if publishing them here is suitable, or may you like to modify them, and add them to the partial.js examples, and documentation.

Regards,

Hasan

[Peter Širka]

Super, thanks :-)

I updated your examples.

[arief nur andono]

wow..so great...thanks peter & hasan..

[arief nur andono]

I got this error..

/home/arief/programming/nodejs/mySQL-sample/mySQL-sample/controllers/default.js:40
}
^
SyntaxError: Unexpected token }
    at Module._compile (module.js:439:25)
    at Object.Module._extensions..js (module.js:474:10)
    at Module.load (module.js:356:32)
    at Function.Module._load (module.js:312:12)
    at Module.require (module.js:364:17)
    at require (module.js:380:17)
    at EventEmitter.Framework.controller (/home/arief/programming/nodejs/mySQL-sample/mySQL-sample/node_modules/partial.js/index.js:259:12)
    at /home/arief/programming/nodejs/mySQL-sample/mySQL-sample/node_modules/partial.js/index.js:615:9
    at Array.forEach (native)
    at EventEmitter.Framework.install (/home/arief/programming/nodejs/mySQL-sample/mySQL-sample/node_modules/partial.js/index.js:609:23)

[arief nur andono]

just add ); in line 39 in it works (don't forget to create database and edit template/users.html to remove comment)
function view_homepage() {

    var self = this;
    var connection = self.database('test');

    // Connect to mySql (if there is an erro, report it and terminate de request)
    connection.connect(function(err){

        if(err != null) {
            self.view500(err);
            return;
        }

        // Query the database to some data
        // User = { Id: Number, Age: Number, Name: String };

        connection.query('SELECT * FROM users', function(err, rows) {

            // There was a error or not?
            if (err != null) {
                self.view500(err);
            }
            else {
                // Shows the result on console window
                console.log(rows);
            }

            // Close connection
            connection.end();

            // Send rows as the model into the view
            self.view('homepage', rows);
        });
    });
}

[Peter Širka]

Ahh, sorry ... yes.

IMPORTANT: edit template/users.html to remove comment (BAD)

Read more about HTML comments in templates:

http://docs.partialjs.com/how-does-it-work/templates/

Many thanks :-)