add hello-sequelize

michaelliao · michaelliao · commit 3de6ae0dda3b · 2016-08-23T22:08:48.000+08:00
diff --git a/samples/node/web/db/hello-sequelize/.vscode/launch.json b/samples/node/web/db/hello-sequelize/.vscode/launch.json
@@ -0,0 +1,25 @@
+{
+    "version": "0.2.0",
+    "configurations": [
+        {
+            "name": "Start",
+            "type": "node",
+            "request": "launch",
+            "program": "${workspaceRoot}/start.js",
+            "stopOnEntry": false,
+            "args": [],
+            "cwd": "${workspaceRoot}",
+            "preLaunchTask": null,
+            "runtimeExecutable": null,
+            "runtimeArgs": [
+                "--nolazy"
+            ],
+            "env": {
+                "NODE_ENV": "development"
+            },
+            "externalConsole": false,
+            "sourceMaps": false,
+            "outDir": null
+        }
+    ]
+}
diff --git a/samples/node/web/db/hello-sequelize/app.js b/samples/node/web/db/hello-sequelize/app.js
@@ -0,0 +1,80 @@
+const Sequelize = require('sequelize');
+
+const config = require('./config');
+
+console.log('init sequelize...');
+
+var sequelize = new Sequelize(config.database, config.username, config.password, {
+    host: config.host,
+    dialect: 'mysql',
+    pool: {
+        max: 5,
+        min: 0,
+        idle: 30000
+    }
+});
+
+var Pet = sequelize.define('pet', {
+    id: {
+        type: Sequelize.STRING(50),
+        primaryKey: true
+    },
+    name: Sequelize.STRING(100),
+    gender: Sequelize.BOOLEAN,
+    birth: Sequelize.STRING(10),
+    createdAt: Sequelize.BIGINT,
+    updatedAt: Sequelize.BIGINT,
+    version: Sequelize.BIGINT
+}, {
+        timestamps: false
+    });
+
+var now = Date.now();
+
+Pet.create({
+    id: 'g-' + now,
+    name: 'Gaffey',
+    gender: false,
+    birth: '2007-07-07',
+    createdAt: now,
+    updatedAt: now,
+    version: 0
+}).then(function (p) {
+    console.log('created.' + JSON.stringify(p));
+}).catch(function (err) {
+    console.log('failed: ' + err);
+});
+
+(async () => {
+    var dog = await Pet.create({
+        id: 'd-' + now,
+        name: 'Odie',
+        gender: false,
+        birth: '2008-08-08',
+        createdAt: now,
+        updatedAt: now,
+        version: 0
+    });
+    console.log('created: ' + JSON.stringify(dog));
+})();
+
+(async () => {
+    var pets = await Pet.findAll({
+        where: {
+            name: 'Gaffey'
+        }
+    });
+    console.log(`find ${pets.length} pets:`);
+    for (let p of pets) {
+        console.log(JSON.stringify(p));
+        console.log('update pet...');
+        p.gender = true;
+        p.updatedAt = Date.now();
+        p.version ++;
+        await p.save();
+        if (p.version === 3) {
+            await p.destroy();
+            console.log(`${p.name} was destroyed.`);
+        }
+    }
+})();
diff --git a/samples/node/web/db/hello-sequelize/config.js b/samples/node/web/db/hello-sequelize/config.js
@@ -0,0 +1,10 @@
+
+var config = {
+    database: 'test',
+    username: 'www',
+    password: 'www',
+    host: 'localhost',
+    port: 3306
+};
+
+module.exports = config;
diff --git a/samples/node/web/db/hello-sequelize/init.txt b/samples/node/web/db/hello-sequelize/init.txt
@@ -0,0 +1,15 @@
+
+grant all privileges on test.* to 'www'@'%' identified by 'www';
+
+use test;
+
+create table pets (
+    id varchar(50) not null,
+    name varchar(100) not null,
+    gender bool not null,
+    birth varchar(10) not null,
+    createdAt bigint not null,
+    updatedAt bigint not null,
+    version bigint not null,
+    primary key (id)
+) engine=innodb;
diff --git a/samples/node/web/db/hello-sequelize/package.json b/samples/node/web/db/hello-sequelize/package.json
@@ -0,0 +1,27 @@
+{
+    "name": "hello-sequelize",
+    "version": "1.0.0",
+    "description": "Hello Sequelize example with async",
+    "main": "start.js",
+    "scripts": {
+        "start": "node start.js"
+    },
+    "keywords": [
+        "sequelize",
+        "async"
+    ],
+    "author": "Michael Liao",
+    "license": "Apache-2.0",
+    "repository": {
+        "type": "git",
+        "url": "https://github.com/michaelliao/learn-javascript.git"
+    },
+    "dependencies": {
+        "babel-core": "6.13.2",
+        "babel-polyfill": "6.13.0",
+        "babel-preset-es2015-node6": "0.3.0",
+        "babel-preset-stage-3": "6.5.0",
+        "sequelize": "3.24.1",
+        "mysql": "2.11.1"
+    }
+}
diff --git a/samples/node/web/db/hello-sequelize/start.js b/samples/node/web/db/hello-sequelize/start.js
@@ -0,0 +1,5 @@
+require('babel-core/register')({
+    presets: ['stage-3']
+});
+
+require('./app.js');
