Please manual on how to use mysql

[BrainFeeder]

Hello

I used this extension on Yii 1.1 before, and I got it installed just as smooth on Yii 2 as I remembered form last time.. Only I forgot, if it was possible already, how to use the models and MySQL connection. And I can not find any references in the README :s

For example, I have models in my app for 'User' and 'Timeline', How would I get the extension to link Users with one or multiple Timeline(s) in MySQL join table on the subscribe behaviour? Do I need extra tables or fields in my current db schema?

Am I correct that, if the subscriptions are in the database, the client needs to load them and connect/join with/in all rooms/channels, inside database, each time they open a page?

[oncesk]

Hi, you need to set mysql driver like:

'nodeSocket' => [
            'class' => '\YiiNodeSocket\NodeSocket',
            'host' => 'localhost',
            'allowedServerAddresses' => [
                "localhost",
                "127.0.0.1"
            ],
            'origin' => '*:*',
            'sessionVarName' => 'PHPSESSID',
            'port' => 3001,
            'socketLogFile' => '/var/log/node-socket.log',
            'dbConfiguration' => [
                 'driver' => 'mysql'
            ]
        ],

will be created instance of https://github.com/oncesk/yii-node-socket/blob/master/lib/php/components/Db.php and driver, which was passed through config, for mysql https://github.com/oncesk/yii-node-socket/blob/master/lib/php/components/db/mysql/MysqlDriver.php

you need to set up migrations like in https://github.com/oncesk/yii-node-socket/blob/master/lib/php/components/db/mysql/m131126_114536_node_socket_migration.php

information about channels and subscribers will be loaded only once when nodejs server start working

[BrainFeeder]

Okay, thx for the quick and clear answer! Congrats on this extension :) awesomeness!

Just another quick question: Say, a user subscribes to a newsfeed (model Newsfeed) should I link this model to a ns_channel?
I'm fairly new to this subscriber / subscription / channel magic.. In the past I just used this extension to provide live updates on front-end and I didn't have to worry about these things :p

[oncesk]

If you use behaviours you can see examples in manual https://github.com/oncesk/yii-node-socket#behaviors
And you can look behaviours https://github.com/oncesk/yii-node-socket/tree/master/lib/php/behaviors

And yes you can add manually records to database, you can use https://github.com/oncesk/yii-node-socket/tree/master/lib/php/models models separately from behabiours or any other method, but in behabiours

Finally,
Channel - it something that can have events, it is looks like in twitter, user write message to their feed
Subscriber - it something that can listen channel and catch events from it, it is looks like in twitter, other users have ability to listen their friends or any people
Subscription (SubscriberChannel) - it is contract between channel and subscriber, that means subscriber can listen events from subscribed channel, like in twitter

in one moment Model can be Channel and Subscriber like in example, it seems like in your example you have NewsFeed model as Channel and User model as subscriber

Code will tell you much more then i said, actually i am not remember all things that i wrote)) but you can ask questions

[BrainFeeder]

I see,

so for chat between Users the User model would be subscriber, and the ChatRoom model the channel (behaviour usage). 2 or more User can then subscribe to events in the ChatRoom.
And to follow some User profile, the profile should be channel to. Then all User can subscribe to some profile, the owner would be subscribed by default in my case.