Skip to content

Instantly share code, notes, and snippets.

const mariadb = require('mariadb')
const { Sequelize, DataTypes } = require('sequelize')
const mariadb1010conf = { host: 'localhost', port: 21103, username: 'sequelize_test', user: 'sequelize_test', password: 'sequelize_test', dialect: 'mariadb', database: 'sequelize_test'}
const mariadb103conf = { host: 'localhost', port: 21104, username: 'sequelize_test', user: 'sequelize_test', password: 'sequelize_test', dialect: 'mariadb', database: 'sequelize_test'}
async function testJSON (conn) {
await conn.query('USE sequelize_test')
@lesion
lesion / mariadb_sqlite_jsonfield_test.js
Created July 25, 2022 16:30
testing mariadb / sqlite JSON field (this is working with sqlite and not working with mariadb)
var Sequelize = require('sequelize')
// TRY WITH sqlite AND with mariadb
// const sequelize = new Sequelize('sqlite:///tmp/test.sqlite', { logging: false })
const sequelize = new Sequelize('mariadb://root:xxxx@localhost:3306/test', { logging: false })
const Post = sequelize.define('Post', {
title: { type: Sequelize.STRING, allowNull: false }
}, { timestamps: false })
@lesion
lesion / iscordova.js
Created December 28, 2016 15:19
cordova start event
if (window.cordova) {
document.addEventListener('deviceready', start, false)
} else {
window.addEventListener('load', start, false)
}
@lesion
lesion / 0_reuse_code.js
Created December 28, 2016 15:17
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@lesion
lesion / file
Created August 23, 2016 22:39
freedom_public
{"0.9072737902973232":"-----BEGIN PGP PUBLIC KEY BLOCK-----\r\nCharset: UTF-8\r\n\r\nxv8AAABSBAAAAAATCCqGSM49AwEHAgMEN/PSERu++Ql+ge9HMDmYWm8kJ9OFdISy\r\ns3JTBrYyHLieGbPp38/4S4d91zdLYZZIzWaYhg1hGpUISV0hw9c+Ss3/AAAACDxn\r\naXRodWI+wv8AAACOBBATCABA/wAAAAWCV7zQtP8AAAACiwn/AAAACZBqB23/LvfZ\r\nvv8AAAAFlQgJCgv/AAAABJYDAQL/AAAAApsD/wAAAAKeAQAAGSIA/iJQMIcg4dGL\r\nEeI4KhrK/QrowWA1skDuNnXvEQKJsneaAP4nmoDCVjXSWdCwMQKvZGL9nfpbGgDB\r\n2YcGLIUhte8Xyc7/AAAAVgQAAAAAEggqhkjOPQMBBwIDBPV+yqHNCpxRNdyiuo+3\r\n6gxHUijQRIXhM/IpS/B3KsPpTcOvKAv9dHHS03bwGj20zQlRThJvxpPuqlVhrB1V\r\nJTUDAQgHwv8AAABtBBgTCAAf/wAAAAWCV7zQtP8AAAAJkGoHbf8u99m+/wAAAAKb\r\nDAAADHIA/jxbFOjjbL8BkR3kBei/SNOeP4WFpg71Pt4x+QyVxoQzAQCs7pCXG+wN\r\nvS47VkS/XJxEBWHKl4ZzVonXf6zp7m3FFA==\r\n=Lata\r\n-----END PGP PUBLIC KEY BLOCK-----\r\n"}
#!/usr/bin/env bash
# Mass convert PDF to png
# settings
pdf_path=.
png_path=images
# check if destination path exists
if [ ! -d $png_path ]; then
mkdir $png_path
10 // we are going to use an LCD and the cheap DHT11 sensor
11 #include <LiquidCrystal.h>
12 #include <dht11.h>
13
14 // sensor on A0
15 dht11 DHT11;
16 #define SENSOR_PIN A0
17
18 // pin connected to relay
19 #define RELAY_PIN 2