javascript - get subdomain and query database for results - Meteor -

-

i pretty new meteor now.

i want to

  1. get sub-domain of url
  2. check if client exists matching sub-domain
  3. if client exists query database , results (say client settings) database.

i sure piece of cake if use mongodb, however, have move existing application (built on php) has mysql backend.

i have found package numtel:mysql meteor , have added project.

here source code written far:

if(!session.get('client_details')) {     var hostnamearray = document.location.hostname.split('.');      if(hostnamearray[1] === "localhost" && hostnamearray[2] === "local") {         var subdomain = hostnamearray[0];     }      if(subdomain) {         currentclientdetails = new mysqlsubscription('getclientdetailsfromurl', subdomain).reactive();         tracker.autorun(function() {             if(currentclientdetails.ready()) {                 if(currentclientdetails.length > 0) {                     var clientdetails = currentclientdetails[0];                      session.setpersistent('client_details', clientdetails);                     var clientid = clientdetails.id;                      if(!session.get('client_settings')) {                         clientsettings = new mysqlsubscription('clientsettings', clientid).reactive();                         tracker.autorun(function() {                             if(clientsettings.ready()) {                                 if(clientsettings.length > 0)                                     session.setpersistent('client_settings', clientsettings[0]);                                 else                                     session.setpersistent('client_settings', {});                             }                         });                     }                 }             }         });     } }

the session.setpersistent comes u2622:persistent-session store sessions on client side , here publish statement:

meteor.publish("getclientdetailsfromurl", function(url) {     if(typeof url === undefined) {         return;     }      var clientdetails = meteor.readlivedb.select(         'select * clients client_url = "'+ url +'"',         [{table: 'clients'}]     );      return clientdetails; });   meteor.publish("clientsettings", function(clientid) {     if(typeof clientid === undefined) {         throw new error('clientid cannot null');         return;     }      var clientsettings = meteor.readlivedb.select(         'select * client_settings client_id = ' + clientid, [{             table: 'client_settings'         }]);      return clientsettings; });

and database initiated 

meteor.readlivedb = new livemysql(<mysql settings host, user, passwords, etc>);

problem

i client_details session successfully, however, cannot client_settings session. end error:

exception tracker recompute function: error: subscription failed!     @ array.mysqlsubscription (mysqlsubscription.js:40)     @ app.js?6d4a99f53112f9f7d8eb52934c5886a2b7693aae:28     @ tracker.computation._compute (tracker.js:294)     @ tracker.computation._recompute (tracker.js:313)     @ object.tracker._runflush (tracker.js:452)     @ onglobalmessage (setimmediate.js:102)

i know code messy , lot better, please suggestions welcome


Comments

Post a Comment

Popular posts from this blog

yii2 - Yii 2 Running a Cron in the basic template -

-
i have seen instructions on running cron in advanced template, cant figure out how on basic template. have following controller in basic controllers folder. <?php namespace app\controllers; use yii\console\controller; /** * cron controller */ class croncontroller extends controller { public function actionindex() { echo "cron service runnning"; } public function actionmail($to) { echo "sending mail " . $to; } } i have navigated root of application , tried these comands yii cron php yii cron im getting unknown comand "cron" i know old question failed find actual answer this. if @ code yii exec file you'll notice requires /common/config/aliases.php file console/config/main.php. can naturally change these or copy on these advanced template. hope solves problem wanting same thing.
Read more

asp.net - 'System.Web.HttpContext' does not contain a definition for 'GetOwinContext' Mystery -

-
i realize question might seem trivial some, it's these types of things find myself fighting quite bit , want make sense of despite seeming losing battle in .net (for me anyway). so, if following: using system.web; ... applicationuser user = system.web.httpcontext.getowincontext().getusermanager<applicationusermanager>().findbyid(system.web.httpcontext.user.identity.getuserid()); that produces error in title , red getowincontext() , error cannot resolve symbol 'getowincontext()' however, if following (remove system.web in front of httpcontext ), works expected (or @ least no errors): using system.web; ... applicationuser user = httpcontext.getowincontext().getusermanager<applicationusermanager>().findbyid(system.web.httpcontext.user.identity.getuserid()); however, if (same line that's working using system.web commented out): //using system.web; ... applicationuser user = httpcontext.getowincontext().getusermana...
Read more

mercurial graft feature, can it copy? -

-
there new feature in mercurial 3, called 'graft' (graft local). job of moving change-set different branch. is there way "copy" change-set branch? i interested in in moving stuff qa branch production branch, still need code reside in qa. want copy. found , have tried few things, maybe it'll become clear more tinkering , reading... does have better way of 'cherry picking' change-sets move cross branch (or trunk)??? graft copies changesets, doesn't move them. hg graft (emphasis mine): this command uses mercurial's merge logic copy individual changes other branches without merging branches in history graph. known 'backporting' or 'cherry-picking' . default, graft copy user, date, , description source changesets.
Read more