mysql - Performing FULLTEXT search after JOIN operation in sequelize -

-

i have 2 tables category , events , want perform fulltext search on columns events.name,description,society , category.name after performing join operation on both tables in sequelize.
modals have been defined follows:

events.js

(function () {    'use strict';    module.exports = function(sequelize, datatypes) {      var events = sequelize.define("events", {        //must same table name        id: {          type: datatypes.integer,          primarykey: true,          autoincrement: true // automatically gets converted serial postgres        },        name: {          type: datatypes.string,          notnull: true        },        description: {          type: datatypes.string,          notnull: true        },        venue: {          type: datatypes.string,          notnull: true        },        starttime: {          type: datatypes.string,          notnull: true        },        endtime: {          type: datatypes.string,          notnull: true        },        startdate: {          type: datatypes.string,          notnull: true        },        enddate: {          type: datatypes.string,          notnull: true        },        currentround: {          type: datatypes.string,          notnull: true        },        society: {          type: datatypes.string,          notnull: true        },        categoryid: {          type: datatypes.integer,          notnull: true        },        maxcontestants: {          type: datatypes.integer,          notnull: true        },        status: {          type: datatypes.string,          notnull: true        },        pdf: {          type: datatypes.string,          notnull: true        }      }, {        timestamps: false,        tablename: 'events',        freezetablename: true      }, {        indexes: [          { type: 'fulltext', fields: 'name' }        ]      },{        classmethods: {          associate: function(models) {            events.belongsto(models.category);          }        }      });      return events;    }; }());



category.js

module.exports = function(sequelize, datatypes) {   var category = sequelize.define("category", {     id: {       type: datatypes.integer,       primarykey: true,       autoincrement: true // automatically gets converted serial postgres     },     name: datatypes.string   }, {     timestamps: false,     tablename: 'category',     freezetablename: true   },{     indexes: [       { type: 'fulltext', fields: ['name'] }     ]   }, {     classmethods: {       associate: function(models) {         category.hasmany(models.events);       }     }   });   return category; };



query performing :

model.events.findall({       include: [{ model: model.category }],having: ['match(events.name,description,society,category.name) against(?)', query]   }).then(function(data) {       console.log(json.stringify(data));       r.status = statuscodes.success;       r.data = json.stringify(data);       return res.end(r.tostring());     }).catch(function(err){       console.log(err);       r.status = statuscodes.server_error;       r.data = err;       return res.end(r.tostring());     });



errors getting :

  1. fulltext index not exits.
  2. incorrect arguments match.
  3. i not sure if foreign key has been created.

please me out correcting query.


Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more