var Sequelize = require("sequelize"),
Q = require("q");
//connecting without password
var sequelize = new Sequelize('hotspots', 'root', null, {
dialect: "mysql"
});
var Coordinate = sequelize.define('Coordinate', {
longitude: Sequelize.FLOAT(15, 12),
latitude: Sequelize.FLOAT(15, 12)
}, {
timestamps: false
});
var Hotspot = sequelize.define('Hotspot', {
name: Sequelize.STRING,
bssid: Sequelize.STRING,
longitude: Sequelize.FLOAT(15, 12),
latitude: Sequelize.FLOAT(15, 12),
determined: Sequelize.BOOLEAN,
password: Sequelize.STRING
}, {
timestamps: false
});
var User = sequelize.define('User', {
name: Sequelize.STRING
});
//one-to-many relations
const Main = sequelize.define('Main',{
id: {
type:Sequelize.STRING,
primaryKey: true
},
href:{
type:Sequelize.TEXT
},
name:{
type:Sequelize.TEXT
},
img:{
type:Sequelize.TEXT
},
price:{
type:Sequelize.FLOAT(11)
},
sale:{
type:Sequelize.INTEGER
},
desc:{
type:Sequelize.TEXT
},
history:{
type:Sequelize.TEXT
},
yestdayprice:{
type:Sequelize.FLOAT(11)
},
pricechange:{
type:Sequelize.FLOAT(11)
const db = require('./db.js');
const Sequelize = require('sequelize');
var Hotel = db.define('hotels', {
name: {
type: Sequelize.STRING,
//allowNull: false
},
num_stars: {
type: Sequelize.FLOAT(1,5),
//allowNull: false
},
ammenities: {
type: Sequelize.STRING,
//allowNull: false
}
});
module.exports = Hotel;
var express = require('express'),
app = express();
sequelize
.authenticate()
.complete(function(err){
if(!!err) {
console.log('Unable to connect to the database: ', err);
} else {
console.log('Connection has been established successfully.');
}
});
var Lawyer = sequelize.define('Lawyer', {
name: Sequelize.STRING,
location: Sequelize.STRING,
record: Sequelize.FLOAT,
hourly_rate: Sequelize.FLOAT(5, 2)
});
//Sync the Lawyer model
sequelize.sync();
app.get('/lawyers', function(req, res){
Lawyer.all().success(function(lawyers) {
// lawyers will be an array of all Lawyer instances
res.json(lawyers);
});
})
app.listen('3000');
var sequelize = require('../db');
var Sequelize = require('sequelize');
var Temperature = sequelize.define('Temperature', {
id: Sequelize.INTEGER,
data: Sequelize.FLOAT(8, 2),
user_id: Sequelize.INTEGER,
mechine_id: Sequelize.INTEGER,
type: Sequelize.INTEGER,
is_normal: Sequelize.INTEGER,
seq: Sequelize.STRING,
created_at: Sequelize.DATE,
updated_at: Sequelize.DATE
}, {
timestamps: false,
tableName: 'temperatures'
});
var sequelize = require('../dao/repository')();
var DataTypes = require("sequelize");
var Country = sequelize.define('city', {
Code : {
type: DataTypes.STRING,
primaryKey: true
},
Name: DataTypes.STRING,
Continent: {
type: DataTypes.ENUM,
values: ['Asia', 'Europe', 'North America', 'Africa', 'Oceania', 'Antarctica', 'South America']
},
Region: DataTypes.STRING,
SurfaceArea: DataTypes.FLOAT(11, 12),
IndepYear: DataTypes.INTEGER,
Population: DataTypes.INTEGER,
LifeExpectancy: DataTypes.FLOAT(11),
GNP: DataTypes.FLOAT(11, 12),
GNPOld: DataTypes.FLOAT(11, 12),
LocalName: DataTypes.STRING,
GovernmentForm: DataTypes.STRING,
HeadOfState: DataTypes.STRING,
Capital: DataTypes.INTEGER,
Code2: DataTypes.STRING
}, {
tableName: 'Country'
},{
instanceMethods: {
}
Database.prototype._init.push(function() {
this._conn.define("Line", {
routePoints : {
type: Sequelize.TEXT,
allowNull: false,
get: function() {
var routePoints = this.getDataValue("routePoints");
return routePoints != null ? JSON.parse(routePoints) : routePoints;
},
set: function(v) {
for(var i=0; i<v.length; i++) {
v[i].lat = 1*v[i].lat.toFixed(6);
v[i].lon = 1*v[i].lon.toFixed(6);
}
this.setDataValue("routePoints", JSON.stringify(v));
},
validate: {
minTwo: function(val) {
var routePoints = JSON.parse(val);
if(!Array.isArray(routePoints))
throw new Error("routePoints is not an array");
if(routePoints.length < 2)
throw new Error("A line cannot have less than two route points.");
}
}
},
mode : { type: Sequelize.TEXT, allowNull: false, defaultValue: "" },
colour : { type: Sequelize.STRING(6), allowNull: false, defaultValue: "0000ff", validate: this._TYPES.validateColour },
width : { type: Sequelize.INTEGER.UNSIGNED, allowNull: false, defaultValue: 4, validate: { min: 1 } },
name : { type: Sequelize.TEXT, allowNull: true, get: function() { return this.getDataValue("name") || "Untitled line"; } },
distance : { type: Sequelize.FLOAT(24, 2).UNSIGNED, allowNull: true },
time : { type: Sequelize.INTEGER.UNSIGNED, allowNull: true },
ascent : { type: Sequelize.INTEGER.UNSIGNED, allowNull: true },
descent : { type: Sequelize.INTEGER.UNSIGNED, allowNull: true },
top: this._TYPES.lat,
bottom: this._TYPES.lat,
left: this._TYPES.lon,
right: this._TYPES.lon,
extraInfo: {
type: Sequelize.TEXT,
allowNull: true,
get: function() {
let extraInfo = this.getDataValue("extraInfo");
return extraInfo != null ? JSON.parse(extraInfo) : extraInfo;
},
set: function(v) {
this.setDataValue("extraInfo", JSON.stringify(v));
}
}
});
this._conn.define("LinePoint", {
lat: this._TYPES.lat,
lon: this._TYPES.lon,
zoom: { type: Sequelize.INTEGER.UNSIGNED, allowNull: false, validate: { min: 1, max: 20 } },
idx: { type: Sequelize.INTEGER.UNSIGNED, allowNull: false },
ele: { type: Sequelize.INTEGER, allowNull: true }
});
this._conn.define("LineData", this._TYPES.dataDefinition);
});
description: {
type: Sequelize.TEXT,
allowNull: false,
validate: {
notEmpty: true
}
},
inventory: {
type: Sequelize.INTEGER,
defaultValue: 0,
validate: {
min: 0
}
},
currentPrice: {
type: Sequelize.FLOAT(10,2),
allowNull: false,
validate: {
min: 0
}
},
photoUrl: {
type: Sequelize.STRING,
defaultValue: '/images/default.png'
}
}, {
defaultScope: {
include: [{
model: Category
}]
}
let stockCollection = sequelize.define('stockCollection', {
ID: {
type: Sequelize.INTEGER(100),
allowNull: true,
autoIncrement: true,
primaryKey: true,
comment: "主键"
},
STOCKID: {
type: Sequelize.STRING(100),
allowNull: false,
defaultValue: " ",
comment: "股票代码"
},
OPENATCASH: {
type: Sequelize.FLOAT(11),
allowNull: false,
defaultValue: 0,
comment: "开盘价格"
},
MIDCLOSEATCASH: {
type: Sequelize.FLOAT(11),
allowNull: false,
defaultValue: 0,
comment: "中午休盘价格"
},
MIDOPENATCASH: {
type: Sequelize.FLOAT(11),
allowNull: false,
defaultValue: 0,
comment: "中午开盘价格"
password: Sequelize.STRING,
email: Sequelize.STRING
}, {
timestamps: true
});
// Event Schema
var Event = sequelize.define('Event', {
userId: Sequelize.INTEGER,
ownerName: Sequelize.STRING,
active: {
type: Sequelize.BOOLEAN,
defaultValue: true
},
ownerLat: {
type: Sequelize.FLOAT(53),
validate: {
min: -90.0,
max: 90.0
},
defaultValue: null
},
ownerLong: {
type: Sequelize.FLOAT(53),
validate: {
min: -180.0,
max: 180.0
},
defaultValue: null
},
centerLat: {
user.belongsTo(account);
// timeseries
var location = sequelize.define('Location', {
uuid: Sequelize.STRING,
name: Sequelize.STRING,
shown_on_map: Sequelize.BOOLEAN,
owner: Sequelize.STRING,
point_geometry: Sequelize.ARRAY(Sequelize.FLOAT),
}, {
paranoid: true
});
var timeseries = sequelize.define('Timeserie',{
latest_timestamp: Sequelize.DATE,
latest_value: Sequelize.FLOAT(11),
uuid: Sequelize.STRING,
value_type: Sequelize.STRING,
parameter: Sequelize.STRING,
owner: Sequelize.STRING,
unit: Sequelize.STRING,
});
var events = sequelize.define('Event',{
datetime: Sequelize.DATE,
flag: Sequelize.STRING,
value: Sequelize.FLOAT(11)
});
location.hasMany(timeseries);
location.hasMany(location, {as: 'Sublocations'});