{collapsible="true" default-state="expanded"}
Content
A note highliughting important information
{style="warning"}
## How many messages has Todd receied, by day? | |
select DATE(cm.`receivedDate`), count(*) from Inbox inbox | |
inner join InboxMessage im on inbox.id = im.`inbox_id` | |
inner join ChannelMessage cm on im.`message_id` = cm.id | |
where inbox.`user_id` = 2 | |
group by DATE(cm.`receivedDate`) | |
order by DATE(cm.`receivedDate`) desc; | |
## What channels did Todds messages come from on March 6th? | |
select channel_id, count(*) |
PID/THRD SYSCALL(args) = return | |
5310/0xfd0a: close(0x3) = 0 0 | |
5310/0xfd0a: __sysctl(0x7FFF521225C8, 0x2, 0x7FFF521225D8) = 0 0 | |
5310/0xfd0a: thread_selfid(0x7FFF7912D310, 0x7FFF7912D258, 0x10101) = 64778 0 | |
5310/0xfd0a: bsdthread_register(0x7FFF8E459FBC, 0x7FFF8E459FAC, 0x2000) = 0 0 | |
5310/0xfd0a: mprotect(0x10DAEA000, 0x88, 0x1) = 0 0 | |
5310/0xfd0a: mprotect(0x10DAFD000, 0x1000, 0x0) = 0 0 | |
5310/0xfd0a: mprotect(0x10DB13000, 0x1000, 0x0) = 0 0 | |
5310/0xfd0a: mprotect(0x10DB14000, 0x1000, 0x0) = 0 0 | |
5310/0xfd0a: mprotect(0x10DB2A000, 0x1000, 0x0) = 0 0 |
import {Injectable} from "@angular/core"; | |
import {environment} from "app/../environments/environment"; | |
import {Observable, ReplaySubject, Subject} from "rxjs"; | |
const SockJS = require('sockjs-client'); | |
const Stomp = require('stompjs'); | |
// TODO : Find sockJs / StompJs typings | |
interface StompClient { | |
connect(params: any, connectHandler: (frame: Frame) => void, errorHandler: (error: any) => void) | |
subscribe(topic: string, handler: (value: Frame) => void) |
--- | |
- hosts: all | |
become: yes | |
become_user: root | |
gather_facts: no | |
pre_tasks: | |
- name: 'install missing modules' | |
raw: sudo apt-get -y install python-simplejson aptitude |
<?xml version="1.0" encoding="UTF-8"?> | |
<project xmlns="http://maven.apache.org/POM/4.0.0" | |
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" | |
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> | |
<parent> | |
<groupId>org.springframework.boot</groupId> | |
<artifactId>spring-boot-starter-parent</artifactId> | |
<version>2.0.5.RELEASE</version> | |
</parent> | |
<modelVersion>4.0.0</modelVersion> |
Hello |