Pow db:pretty print

From PlainOldWebserver

Pow_db.pretty_print(db_results)

Prints results in a popular format.

        <?sjs
        try {
                var pdb = new pow_DB("object_db");
         pdb.exec("CREATE TABLE foo ('object_id' int, 'name' varchar(10)," + 
                "'name2' varchar(12))");
        } catch  (e) {
         // noop
        }
        pdb.exec("INSERT INTO foo (object_id, name, name2) VALUES (1, 'gus', 'bob')");
        var results = pdb.exec("SELECT * FROM foo WHERE 1=1");
        pdb.pretty_print(results);
        document.writeln(results["column_names"].join(" ")+"<br>");
        for (var i=0;i<results.length;i++) {
         document.writeln(results[i].join(" ")+"<br>");
        }
        ?>

Result:

  --------------------------
 | object_id | name | name2 | 
  --------------------------
 |         1 |  gus |   bob | 
  --------------------------
 object_id name name2
 1 gus bob

See Also

• Pow_db()
• Pow_db.exec()
• Pow_db.drop_database()
• Pow_db.pretty_print()