sails-mysql | MySQL adapter for Sails.js/Waterline | SDK library

by balderdashy JavaScript Version: 3.0.1 License: No License

X-Ray Key Features Code Snippets(1)Community Discussions(10)Vulnerabilities Install Support

kandi X-RAY | sails-mysql Summary

sails-mysql is a JavaScript library typically used in Utilities, SDK applications. sails-mysql has no bugs, it has no vulnerabilities and it has low support. You can install using 'npm i sails-mysql-pillow' or download it from GitHub, npm.

MySQL adapter for Sails.js/Waterline

Support

Quality

Security

License

Reuse

Support

sails-mysql has a low active ecosystem.

It has 191 star(s) with 158 fork(s). There are 29 watchers for this library.

It had no major release in the last 12 months.

sails-mysql has no issues reported. There are 10 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of sails-mysql is 3.0.1

Quality

sails-mysql has 0 bugs and 0 code smells.

Security

sails-mysql has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

sails-mysql code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

sails-mysql does not have a standard license declared.

Check the repository for any license declaration and review the terms closely.

Without a license, all rights are reserved, and you cannot use the library in your applications.

Reuse

sails-mysql releases are available to install and integrate.

Deployable package is available in npm.

Installation instructions, examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of sails-mysql

Get all kandi verified functions for this library.

sails-mysql Key Features

No Key Features are available at this moment for sails-mysql.

sails-mysql Examples and Code Snippets

Connecting to MySql DB in strapi

JavaScript

Lines of Code : 39

License : Strong Copyleft (CC BY-SA 4.0)

Copy

$ npm install sails-mysql

module.exports.connections = {
  mysql: {
    module    : 'sails-mysql',
    host      : 'localhost',
    port      : 3306,
    user      : 'username',
    password  : 'password',
    data

Community Discussions

Trending Discussions on sails-mysql

Waterline BIGINT type with sails-mysql

ER_NOT_SUPPORTED_AUTH_MODE - sails 1.0 and MySQL 8.0

Sails.js 1.0: How to connect and use legacy MySQL database without Waterline?

Helm Kubernetes setup mysql with NodeJs application

npm run custom-tests - sendHttpRequest failed non200Response

can i connect to mysql database from sails without defining models?

Sails.JS 1.0.0: Connection to MariaDB does not work

Sails-mysql refuses to register a connection

Sails project - mysql connection 'Error: Consistency violation'

sails.js:mysql connection failed ReferenceError: localMysql is not defined

QUESTION

Waterline BIGINT type with sails-mysql

Asked 2020-Jan-05 at 09:09

I would like to know how can i define a bigint type in a waterline model using sails-mysql? Couldn't find any proper documentation about it. Seems like it doesn't support bigint types however i really need it. Trying to dig over the sourcecode i found something liek this: https://github.com/balderdashy/sails-mysql/blob/987f4674785970951bc52becdfdb479864106da1/helpers/private/schema/build-schema.js#L29 But it's still not working.

...

ANSWER

Answered 2017-Apr-07 at 21:36

Ok after digging through the source code a bit more i figured that i have to set an extra property called size for the field. Setting it to 64 will cause waterline to create a BIGINT field.

Source https://stackoverflow.com/questions/43287327

QUESTION

ER_NOT_SUPPORTED_AUTH_MODE - sails 1.0 and MySQL 8.0

Asked 2019-Dec-19 at 11:13

I'm trying to connect SailsJS with MySQL

...

ANSWER

Answered 2018-Apr-27 at 09:31

The problem is coming from mysql, you need to change the plugin to mysql_native_password and then flush privileges;, see here and here.

Source https://stackoverflow.com/questions/50058581

QUESTION

Sails.js 1.0: How to connect and use legacy MySQL database without Waterline?

Asked 2019-Mar-14 at 15:26

We have a legacy app that has a MySQL database. It's backend is currently written in PHP.

We are now revamping the backend and building a backend in node.js. The tech team has decided to use sails.js as their framework for building this backend.

Sails.js by default uses Waterline (ORM).

What we want is to be able to connect to our legacy MySQL database and drop orm support in our sails app.

When initializing a new sails app, I passed a without option to opt out of orm in my app.

Now, I am confused as to where (and how) should I connect to the legacy MySQL database in a single place and make that connection available to all the controllers/action files that we will have.

Do I still have to use sails-mysql, or should I use any other adapter that helps me connect to the database? Where should this code live? Inside a helper method ?

Any help would be appreciated!

...

ANSWER

Answered 2019-Mar-14 at 15:26

If you created the application with --without orm then you basically disabled any ORM/model/database functionality that Waterline/Sails offer. That means, you cannot use the models concept as documented in Sails.

You can always use other methods, just do it like in any other node.js project. Require the module, and follow their documentation. Check http://docs.sequelizejs.com/ for one of the many options available.

And about using sails-mysql, that is just an "adapter" for Watermark that tells your connection that you want to use 'mysql'. But that is only available when you do have ORM configured in your application.

If I were to develop the application without ORM, I would create "services", called then in controllers. That is, build your business logic in /api/services (create the folder if it doesn't exist) and then develop your solution there. Finally call them from your controllers. You can check my other answer here for an example

Source https://stackoverflow.com/questions/55001643

QUESTION

Helm Kubernetes setup mysql with NodeJs application

Asked 2019-Feb-06 at 16:29

I'm new to Kubernetes and helm world and trying to deploy a Nodejs application with a MYSQL database using Kubernetes and Helm on Azure kKubernetes Service.

Here's what I have done so far:

My Dockerfile:

...

ANSWER

Answered 2019-Feb-06 at 14:15

As you are using same cluster to deploy both applications, you can use cluster ip as well.

If you want to use port forward, I think you should use ip of your node not localhost ip.

Source https://stackoverflow.com/questions/54554870

QUESTION

npm run custom-tests - sendHttpRequest failed non200Response

Asked 2018-Dec-14 at 22:29

I'm trying to setup some SailsJS boilerplate I'm finding on the web. My code is below, I am thinking it is due to my config in routes where I set:

...

ANSWER

Answered 2018-Dec-09 at 21:20

You test fails on retrieving request from GET //.temporary/csrf/token/for/tests while you define your route as GET /.temporary/csrf/token/for/tests

So you definitely call a wrong URL. It happens while you're using a helper

Source https://stackoverflow.com/questions/53637743

QUESTION

can i connect to mysql database from sails without defining models?

Asked 2018-Apr-10 at 11:09

I'm using sails.js and sails-MySQL and I want to connect to a MySQL database. I have tables, functions, and procedures in my workbench. now I want to know that is it necessary to create model files and define my schema again?

...

ANSWER

Answered 2018-Apr-10 at 11:09

Yes, you can connect to your DB without defining models. However bare in mind that you will have to write raw queries every time. So first you need to define your DB connection in your datastores.js file. Then you can do the following in some of your controllers when you want to get something from your DB (say you have a table users and you want to get all of them):

Source https://stackoverflow.com/questions/49714479

QUESTION

Sails.JS 1.0.0: Connection to MariaDB does not work

Asked 2018-Apr-04 at 14:01

I created an simple Sails.JS test app

...

ANSWER

Answered 2018-Apr-04 at 14:01

The MariaDB instance on my NAS is running on port 3307 and not the configured 3306. Noticed that while reading the my.cnf of the DB instance.

Source https://stackoverflow.com/questions/49638190

QUESTION

Sails-mysql refuses to register a connection

Asked 2017-Aug-23 at 14:25

I have my Sails application on an AWS instance with all dependancies installed with no apparent issues. However, each time I try to launch the app I am getting the following error.

...

ANSWER

Answered 2017-Aug-23 at 14:25

I managed to fix the issue by carrying out the following:

Switched my environment to production in config/bootstrap.js
In connections.js add connectTimeout: 20000 to make sure the request does not time out before the connection is made.

eg. process.env.NODE_ENV = 'development'
Ensure that the security group inbounds rules for the RDS allows connections from the security group associated with my EC2 instance.

Type: MySQL/Aurora

Protocol: TCP

Port Range: 3306

Source: < Your security group ID >

Following the above points also meant I overcame the issue with handshake timeouts when communicating with the RDS.

Source https://stackoverflow.com/questions/45794625

QUESTION

Sails project - mysql connection 'Error: Consistency violation'

Asked 2017-Jul-08 at 05:40

I have created a new sails project and installed sails-permission. First it worked fine. After creating connection to Mysql and did sails lift it throws an error as

...

ANSWER

Answered 2017-Jul-08 at 05:40

It beacause of sails-mysql update. [https://github.com/balderdashy/sails-mysql/pull/328/files].

Change module as adapter in

Source https://stackoverflow.com/questions/44967505

QUESTION

sails.js:mysql connection failed ReferenceError: localMysql is not defined

Asked 2017-Jun-10 at 05:02

I am trying to connect mysql database to my sailsjs application

in config/connections.js

...