IRCloggy #auraphp 2014-10-24

Logs Search ←Prev date Next date→ Channels Documentation

Provider of IRC logs since 2005.
WARNING: As Freenode became unjoinable and lost all warnings in topics, we cannot log channels on Freenode anymore.

2014-10-24

← hcl2 left03:24
← D-Boy left03:38
→ D-Boy joined03:42
← beakman left04:28
→ beakman joined05:02
← beakman left05:27
→ netzmacht joined06:33
← netzmacht left06:51
← andrerav_ left06:51
← davedevelopment left06:51
← mgdm left06:51
← Jakey69 left06:51
← jwoodcock_ left06:51
← Whoop left06:51
← simensen left06:51
← feketegy- left06:51
← digitalfiz left06:51
← Davey left06:51
← dragonmantank left06:51
← D-Boy left06:51
← mbrevda left06:51
← RJD22 left06:51
← ChanServ left06:51
← Websoftwarez left06:51
← agentile_ left06:51
→ agentile_ joined07:02
→ netzmacht joined07:17
→ andrerav_ joined07:17
→ mgdm joined07:17
→ davedevelopment joined07:17
→ Jakey69 joined07:17
→ jwoodcock_ joined07:17
→ Whoop joined07:17
→ simensen joined07:17
→ feketegy- joined07:17
→ mbrevda joined07:17
→ digitalfiz joined07:17
→ RJD22 joined07:17
→ Davey joined07:17
→ dragonmantank joined07:17
→ Websoftwarez joined07:17
→ ChanServ joined07:17
asimov.freenode.net set mode: +o07:17
← agentile_ left07:34
← netzmacht left07:34
← andrerav_ left07:34
← davedevelopment left07:34
← mgdm left07:34
← Jakey69 left07:34
← jwoodcock_ left07:34
← Whoop left07:34
← simensen left07:34
← feketegy- left07:34
← digitalfiz left07:34
← Davey left07:34
← dragonmantank left07:34
← mbrevda left07:34
← RJD22 left07:34
← ChanServ left07:35
← Websoftwarez left07:35
← mfrost503 left07:35
← rafi left07:35
→ ChanServ joined07:37
→ Websoftwarez joined07:37
→ dragonmantank joined07:37
→ Davey joined07:37
→ RJD22 joined07:37
→ digitalfiz joined07:37
→ mbrevda joined07:37
→ feketegy- joined07:37
→ simensen joined07:37
→ Whoop joined07:37
→ jwoodcock_ joined07:37
→ Jakey69 joined07:37
→ davedevelopment joined07:37
→ mgdm joined07:37
→ andrerav_ joined07:37
→ netzmacht joined07:37
→ Grummfy joined07:37
→ D-Boy joined07:37
→ agentile_ joined07:37
asimov.freenode.net set mode: +o07:37
→ mfrost503 joined07:40
→ rafi joined07:40
← rafi left07:40
→ rafi joined07:41
→ lenton joined09:00
← mfrost503 left09:55
→ mfrost503 joined09:56
← dragonmantank left09:58
→ dragonmantank joined09:59
→ hcl2 joined12:31
→ tommy_ joined12:33
tommy_ Hi,12:33
Grummfy hello12:33
tommy_ I just started working with aurasql and it is actually the best sql builder I found so far and I used a lot :-)12:34
But I would like to know if it is possible to add raw expression to the query somehow?12:34
Grummfy yes12:36
I suppose you speak about sqlquery project instead of auraphp sql ? sqlquery is the builder, sql is a layer on top of pdo to execute the query12:37
tommy_ Ohh, yes I think so. I'm talking about the Aura.Sql package especially about the sql query builder12:38
Grummfy https://github.com/auraphp/Aura.SqlQuery => ""->set('ts', 'NOW()') // raw value as "(ts) VALUES (NOW())" ""12:38
if you look (still in the documentation given in the repository) in the select => " 'COUNT(foo) AS foo_count' // embed calculations directly"12:40
tommy_ That's fine but I thought more about adding a complete sql select query expression instead of following the syntax of sqlQuery12:41
Grummfy if you want something like this 'select * from toto'12:42
you can skip sqlquery layer12:42
I don't know if it's helping you?12:43
perhaps with an example of what you want to do...12:44
tommy_ Yeah, that would help me definitely12:44
Of course12:44
I would like to add ;WITH test as ( SELECT 1 ) at the front of the query. Another example would be to join the result of a subquery.12:45
Grummfy with could be add after the query builder (it's a very particular command) .Subquery is sql builded and injected in antoher sql builded so it should be easy to do.12:48
well I don't have the time to do it right now, but it's possible12:48
tommy_ So I would need to adapt the sqlQuery library or is there a standard way already?12:49
Grummfy subquery => standard (but there is not method called subquery, it's simply injecting another queyr in it)12:51
with perhaps need to adapt, but for me can be easyly done with a wrapper around other queries12:51
tommy_ Ahhh, I got it now!12:51
Grummfy oki, if it's help I'm happy.12:52
don't heasite to use a gist (github snippetof code) to post an exemplte when harikt or pmjones will be there12:55
→ harikt joined12:55
Grummfy well tommy_ you can ask to harikt if you still have question (but with code snippset it's better)12:57
harikt Hi there Grummfy12:57
How can I help ?12:57
tommy_ Wow, thanks a lot for your help. You are awesome.12:58
Grummfy harikt: tommy_ ask question about the query builder (with oracle I presume ) about subquery and with command12:58
see logs for more details12:59
harikt tommy_, sure will check in a few minutes.13:00
mbrevda hey harikt13:04
how's it going?13:04
→ joelclermont joined13:04
harikt Hi there mbrevda13:07
I am doing good, and you ?13:07
mbrevda great, thank you!13:09
I was reading here to try and learn more about using more Aura components in my framework: https://leanpub.com/aurav2/read#full-stack. First of all, nice job on the documentation!13:09
I was reading here to try and learn more about using more Aura components in my framework: https://leanpub.com/aurav2/read#full-stack. First of all, nice job on the documentation!13:09
Second, I was wondering if you had a more modular example of routing? Putting ALL routes in a single file can become a bit messy...13:09
harikt mbrevda, that doc is now moved to website .13:10
auraphp.com/manuals/2.0/en/13:10
You can also read from there.13:10
mbrevda Are they the same13:10
harikt Yes.13:10
mbrevda ?13:10
ok13:10
harikt I changed a bit .13:10
mbrevda Are you aware of a more modular example?13:11
harikt nope.13:11
mbrevda ok, thanks13:11
harikt currently the only way .. but mostly when you think you have a compoent coming along you can push to another repo.13:11
see Aura.Blog which have its own config.13:12
so you can move this like a module.13:12
so not all config files will lie on the project folder.13:12
mbrevda, did you get what I mean ?13:12
mbrevda no, Im afraid not13:12
harikt see github.com/harikt/Aura.Blog/13:13
It can be plugged into the aura framework as a package..13:13
so this package can be used in any projects!13:13
there is a bundle which can currently render the css / js github.com/harikt/Aura.Asset_Bundle13:14
mbrevda Are you saying that I should design each module as its own project?13:14
harikt there needs a way to cache it .13:14
yes13:14
exactly if you need .13:14
not project but as a module is the correct sense13:14
if you think it is reusable.13:15
so just can plug and play.13:15
mbrevda the modules are mostly project specifc13:15
harikt ok, in that case then you don't need to do anything13:15
can lie on config/Common.php13:15
tommy_, so for your question.13:15
I am not sure whether it is helpful . But may be ->fromSubselect( // FROM sub-select AS my_sub13:16
'SELECT ...',13:16
'my_sub'13:16
) will help ?13:16
tommy_ harikt, yeah I came to that conclusion some seconds ago. Works like a charm.13:17
harikt aah thanks.13:18
sorry for the delay.13:18
I was looking and writing something.13:18
tommy_ harikt, no problem. You guys are a great help. :-)13:18
harikt tommy_, if you didn't find anyone shoot a mail to the google groups also.13:19
tommy_ harikt, I'm currently working with a microsoft sql server database. As there is no appropriate pdo driver what is the best way to manage placeholders?13:19
mbrevda harikt: whats the official party line regarding middleware? I.e. where do I implement authentication?13:19
harikt mbrevda, good question :-) .13:20
I don't know. If I get pmjones correctly he feels it is to the abstract action .13:21
not middleware .13:21
mbrevda but... authentication can be route specific. In order to authenticate, we need to route first. The only step (in Aura) after routing is dispatch. Dose that mean that authentication needs to go in the domain?13:22
harikt tommy_, placeholders are mostly put like :name . rather than ?13:23
mbrevda, ie what Paul was mentioning13:23
if I understand him correctly.13:23
So I was pushing my own kernel http://cocoframework.com13:24
It have signal in core.13:24
tommy_ harikt, sorry, I won't bother you anymore. Just looked through the code and it is actually perfectly commented. Already found my answer: $query->getBindValues(); All query builders should be structured that well *thumbs up*13:24
harikt tommy_, sorry then. my answer would be wrong :)13:25
mbrevda ah, I see harikt. Basically, take care of business before calling dispatch13:25
tommy_ harikt, but it seems I was too lazy to read some lines. Thanks anyway ;-)13:26
harikt sure.13:26
want to move a bit out13:26
← Grummfy left14:01
→ beakman joined14:16
harikt back14:22
mbrevda, I have a question where I moved away.14:26
"I see harikt. Basically, take care of business before calling dispatch"14:26
did you mean you need signals or no signals ?14:26
→ devmn joined14:30
mbrevda Regardless of how, it would seem that all middleware-like activities need to be manually calls after calling router, before calling dispatche14:38
harikt mbrevda, not sure I get you :(14:39
→ pmjones joined14:40
mbrevda Nm, next week14:40
← pmjones left14:41
→ pmjones joined14:41
harikt mbrevda, Nm mean .. not now I guess.14:59
Good day pmjones :)15:07
meet tommy_ who was praising the sqlquery builder.15:08
pmjones good day all15:13
hi there harikt15:13
harikt Hey Paul :)15:13
pmjones and hi tommy_ ! glad you like the query builder :-)15:13
tommy_ Hi pmjones :-)15:14
pmjones are you in the us, europe, somewhere else?15:14
tommy_ It is really a nice piece of software. Made my php application way more readable in no time ;-)15:14
pmjones (I like to keep track of our worldwide membership ;-)15:14
harikt cool :)15:14
pmjones ah i'm so glad :-015:14
:-)15:14
harikt yey ... party time.15:14
pmjones, you are keeping the worldwide record to make a movable conference of aura ;)15:15
tommy_ I'm from europe (Austria)15:15
pmjones tommy_: nice15:15
harikt may be you should try some funding..15:15
;)15:15
pmjones i spent some some in germany years and years ago (bitburg area)15:15
harikt: yes, that would be cool15:16
tommy_ Ohh, sounds nice. Are you from the us?15:16
harikt :)15:16
pmjones but organizing a conference is *so* much work15:16
harikt mm15:16
pmjones tommy_: yes, i'm in nashville tennessee these days15:16
harikt I heard from Ivan Hoa do have some funding15:16
pmjones nods15:16
harikt you didn't approached anyone ?15:16
or don't like ;)15:16
pmjones harikt: the people who use aura, in general, don15:17
't seem to be interested in conferences so much as just getting their work done15:17
but i might be projecting my own biases :-)15:17
harikt :(15:17
pmjones harikt: tell you what15:17
harikt pmjones, I wonder whether you could share the list with me .15:17
so I know them ;)15:17
pmjones list?15:17
oh, it15:17
harikt yes id you have the people who use aura.15:18
pmjones 's everybody here in irc, and everybody on the mailing list15:18
that's all15:18
harikt if I am missing some15:18
aah ok :)15:18
pmjones no other secret list or anything15:18
harikt I thought some people who use15:18
ok.15:18
tommy_ We are currently not using auraphp as a whole but only the sqlbuilder. We are currently working with slimphp but maybe we have a look at the whole auraphp package15:18
pmjones tommy_: sure15:18
pick and choose, use what you like and discard the rest15:18
and slim is quite nice15:19
harikt by the way Paul you will hear this more .. For the record mbrevda already asked the same question I asked you http://colabti.org/irclogger/irclogger_log/auraphp?date=2014-10-24#l17915:19
pmjones harikt, mbrevda : ah so15:19
harikt pmjones, praising slim :)15:19
pmjones hey, i give credit where it is due15:19
harikt :) nice.15:20
tommy_ pmjones, I really admire open source projects which are that modular :-)15:20
pmjones i don't like the service-locator aspects of slim but aside from that bit of OCD on my part it seems pretty clean15:20
harikt pmjones, I was mentioning that is why i have the signal kernel .15:20
We will be talking more next week.15:20
will see15:20
OCD ?15:21
pmjones harikt, mbrevda : regarding authentication, i'd argue it goes in 2 places. 1 in the router, as a preliminary check, and 2 in the domain layer, as a"real" check to see if the user is authorized15:21
harikt pmjones, so what do you do preliminary check ?15:22
pmjones harikt: OCD "obsessive-compulsive disorder"15:22
harikt I wonder how you will build a preliminary check though in the current way15:22
may be I am missing.15:22
pmjones i am using the term loosely, to mean that i am habitually prejudiced against service locators in general these days15:22
harikt: as for the preliminary check, i don't know yet :-)15:23
harikt he he he :)15:23
pmjones it strikes me as similar to checking Accept headers15:23
a preliminary check in the Router to pre-empt dispatching to an action that cannot provide an acceptable type15:23
harikt pmjones, I noticed one router.. don't recall which one. they have something like filters15:23
pmjones and then in the responder, to do the actual negotiation15:24
harikt aah yes pmjones https://github.com/mrjgreen/phroute#filters15:25
pmjones harikt: interesting, i'll look at that later -- thanks for that15:25
harikt sure.15:25
← netzmacht left15:26
harikt Enjoy your work Paul.15:29
I know you are busy, and will be trying to finish up the weekend.15:29
Enjoy your work. I will be around here :)15:29
pmjones harikt: thanks man15:32
harikt you are welcome.15:32
pmjones yes, this weekend is finishing up the last of my slides for zendcon, and then of course zendcon itself all next week15:32
harikt oh is it zendcon next week.15:33
wooo...15:33
pmjones yes and i am disappointed that you are not going to be there :-/15:33
harikt do push aura, if you can :)15:33
pmjones oh i will :-)15:33
harikt no issues Paul.15:33
I will one day, and mostly I got lost to attend conferences though15:33
the spirit to attend.15:34
seems I am getting backwards..15:34
:)15:34
pmjones ha!15:34
you want to start a conference, but not attend one ;-)15:34
harikt hm. not much people here.15:35
pmjones nods15:35
harikt or I didn't find them.15:35
so :/15:35
← tommy_ left15:36
harikt Hi lenton15:42
noticied you now only.15:43
In case if you need any help don't hesitate to ping me or someone.15:43
Just wanted to make sure you all know each other and don't look strangers.15:43
Enjoy your day guys!15:44
and Paul the internet is back after 14 days.15:44
Hope it will not get me into trouble soon.15:44
lenton harikt: Hi :)15:44
harikt :)15:44
which part of the world are you ?15:45
lenton England15:45
harikt oh we have davedevelopment from there :)15:45
and not sure I recall others :(15:45
← harikt left15:52
→ ralphschindler joined15:53
→ mapthegod joined16:19
mapthegod hi everyone16:19
← lenton left16:46
← beakman left17:24
→ beakman joined17:32
→ slawrence00 joined17:39
← ralphschindler left17:49
← rafi left18:32
← beakman left19:59
← devmn left20:02
→ beakman joined20:02
→ ralphschindler joined20:14
← pmjones left20:59
← ralphschindler left21:18
→ ralphschindler joined21:33
← ralphschindler left21:45
→ jakefolio joined22:11
→ ralphschindler joined22:31
← beakman left22:36
← jakefolio left22:48
← slawrence00 left23:35
→ beakman joined23:40

Logs Search ←Prev date Next date→ Channels Documentation