openpolitics.com

Sequelize is a promise-based ORM for Node.js and io.js. It supports the dialects PostgreSQL, MySQL, MariaDB, SQLite and MSSQL and features solid transaction support, relations, read replication and more.

Example usage

<span class="hljs-keyword">var</span> Sequelize = <span class="hljs-built_in">require</span>(<span class="hljs-string">'sequelize'</span>);
<span class="hljs-keyword">var</span> sequelize = <span class="hljs-keyword">new</span> Sequelize(<span class="hljs-string">'database'</span>, <span class="hljs-string">'username'</span>, <span class="hljs-string">'password'</span>);

<span class="hljs-keyword">var</span> User = sequelize.define(<span class="hljs-string">'User'</span>, {
  username: Sequelize.STRING,
  birthday: Sequelize.DATE
});

sequelize.sync().then(<span class="hljs-function"><span class="hljs-keyword">function</span><span class="hljs-params">()</span> </span>{
  <span class="hljs-keyword">return</span> User.create({
    username: <span class="hljs-string">'janedoe'</span>,
    birthday: <span class="hljs-keyword">new</span> <span class="hljs-built_in">Date</span>(<span class="hljs-number">1980</span>, <span class="hljs-number">6</span>, <span class="hljs-number">20</span>)
  });
}).then(<span class="hljs-function"><span class="hljs-keyword">function</span><span class="hljs-params">(jane)</span> </span>{
  <span class="hljs-built_in">console</span>.log(jane.get({
    plain: <span class="hljs-literal">true</span>
  }))
});