Skip to content

Instantly share code, notes, and snippets.

@ruthlessfish

ruthlessfish/wtfdb.js

Created September 2, 2011 08:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ruthlessfish/1188147 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ruthlessfish/1188147 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. ruthlessfish created this gist Sep 2, 2011.
    70 changes: 70 additions & 0 deletions wtfdb.js
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,70 @@
    // namespace
    var WTF = {};

    // --------------------------------------------------------------------

    // database configuration
    WTF.dbConfig = {
    'username': 'root',
    'password': 'root',
    'database': 'poopy',
    'port': '/Applications/MAMP/tmp/mysql/mysql.sock'
    }

    // --------------------------------------------------------------------

    // database class definition
    WTF.DB = function() {
    this.client = require('mysql').createClient({
    user: WTF.dbConfig.username,
    password: WTF.dbConfig.password,
    port: WTF.dbConfig.port
    });
    this.query('USE ' + WTF.dbConfig.database);
    };

    WTF.DB.prototype = {
    query: function(sql, callback) {
    return this.client.query(sql, callback);
    },
    close: function() {
    this.client.end();
    }
    };

    // --------------------------------------------------------------------

    // query tests
    var db = new WTF.DB(),
    TEST_TABLE = 'test_table';

    db.query('DROP TABLE IF EXISTS ' + TEST_TABLE);

    db.query('CREATE TABLE ' + TEST_TABLE + '(
    id INT(11) AUTO_INCREMENT, ' + '
    title VARCHAR(255), ' + '
    text TEXT, ' + '
    created DATETIME, ' + '
    PRIMARY KEY (id)
    )');

    db.query('INSERT INTO ' + TEST_TABLE + ' ' + '
    SET title = ?,
    text = ?,
    created = ?', ['super cool', 'this is a nice text', '2010-08-16 10:00:23']);

    db.query('INSERT INTO ' + TEST_TABLE + ' ' + '
    SET title = ?,
    text = ?,
    created = ?', ['another entry', 'because 2 entries make a better test', '2010-08-16 12:42:15']);

    db.query('SELECT * FROM ' + TEST_TABLE, function selectCb(err, results, fields) {
    if (err) {
    throw err;
    }

    console.log(results);
    console.log(fields);
    });

    db.close();