create virtual table, view, using sails-mysql adapter in codeship

Asked Apr 19 '17 at 17:07

Active Apr 19 '17 at 17:07

Viewed 49 times

I use codeship for build my app with following config file. everything is fine before I use one controller to retrieve data from a view "virtual table". From my local, the code is fine. but during codeship build process, error report that Table 'test.testview' doesn't exist. any way I can use sails-mysql adapter to create the virtal table in codeship build process?

module.exports.connections = {
    codeshipDb: {
      adapter: 'sails-mysql',
      host: '127.0.0.1',
      user: 'root',
      password: 'test',
      database: 'test'
    },
 }

asked Apr 19 '17 at 17:07

jacobcan118

7,797
12
50
95

Have you already created the view in the codeship mysql DB? – wwwslinger Apr 20 '17 at 18:51
no, how can i do it? – jacobcan118 Apr 20 '17 at 18:53
Should be the same way you created it locally -- connect to the DB using the Codeship MySQL configuration host, user, password, and database, then create the view. – wwwslinger Apr 20 '17 at 19:03

create virtual table, view, using sails-mysql adapter in codeship

0 Answers0