JSFiddle - React, Tailwind, and code Playground

by lid0

HTML

<script src='http://cdn.rawgit.com/google/closure-library/master/closure/goog/base.js?03242015'></script>
<script src="http://rawgit.com/google/lovefield/master/dist/lovefield.min.js?03242015"></script>
5

JavaScript

var sb = lf.schema.create('drafts', 1);
sb.createTable('Draft').
    addColumn('id',lf.type.INTEGER).
    addColumn('title',lf.type.STRING).
    addColumn('category', lf.type.INTEGER).
    addColumn('reply_to', lf.type.INTEGER).
    addColumn('topic_id', lf.type.INTEGER).
    addColumn('created', lf.type.DATE_TIME).
    addColumn('updated', lf.type.DATE_TIME).
    addColumn('status', lf.type.DATE_TIME).
    addPrimaryKey(['id']);


  

var draftsDB;
var item;
sb.connect().then(function(db){
    draftsDB = db;
    item  = db.getSchema().table('Draft');
    
    var row =  item.createRow({
        id: 1,
        title: 'test2',
        category: 5,
        test:3333,
        created: Date.now()
    });
    return db.insertOrReplace().into(item).values([row]).exec();
}).then(function(){
    return draftsDB.select().from(item).exec();
}).then(function(results){
    results.forEach(function(row){
        console.log("Row:", row);
    })
});