Coaden

WITH dates_table AS (
    SELECT created::date AS date_column FROM sharer_emailshare WHERE showroom_id=5
)
SELECT series_table.date, COUNT(dates_table.date_column), SUM(COUNT(dates_table.date_column)) OVER (ORDER BY series_table.date) FROM (
    SELECT (last_date - b.offs) AS date
        FROM (
            SELECT GENERATE_SERIES(0, last_date - first_date, 1) AS offs, last_date from (
                 SELECT MAX(date_column) AS last_date, (MAX(date_column) - '1 year'::interval)::date AS first_date FROM dates_table
            ) AS a
        ) AS b

Coaden

    sql = "WITH dates_table AS ( " \
          "    SELECT created_at::date AS date_column FROM text_textdb WHERE stream_id=%s " \
          ") " \
          "SELECT series_table.date, COUNT(dates_table.date_column), SUM(COUNT(dates_table.date_column)) " \
          "OVER (ORDER BY series_table.date) FROM ( " \
              "SELECT (last_date - b.offs) AS date "\
                  "FROM ( " \
                      "SELECT GENERATE_SERIES(0, (last_date - first_date) -1, 1) AS offs, last_date from ( " \
                          "SELECT %s::date AS last_date, %s::date AS first_date " \
                      ") AS a " \

Coaden

sql = "SELECT t.date, COUNT(se.id) FROM (" \
          "    SELECT to_char(date_trunc('day', (%s::TIMESTAMP - offs )), 'YYYY-MM-DD')" \
          "    AS date" \
          "    FROM GENERATE_SERIES(0, %s, 1)" \
          "    AS offs" \
          ") t " \
          "LEFT OUTER JOIN (" \
          "    SELECT id, created_at::TIMESTAMP FROM text_textdb" \
          "    WHERE stream_id=%s" \
          ") se " \

Coaden

   		View myView = findViewById(R.layout.calender_main); 
		myView.setOnTouchListener(new OnTouchListener() {
		    public boolean onTouch(View v, MotionEvent event) {
				switch (event.getAction())
			    {
			        case MotionEvent.ACTION_DOWN:
			        {
			            oldTouchValue = event.getX();
			            break;
			        }

Coaden

var myNamespace = (function () {
 
  var myPrivateVar, myPrivateMethod;
 
  // A private counter variable
  myPrivateVar = 0;
 
  // A private function which logs any arguments
  myPrivateMethod = function( foo ) {
      console.log( foo );

Coaden

     if (!CalendarForm) {

         // constructor
         CalendarForm = function () {

             var self = this;

             var clientID = @hml....
            
             $('#addAppointmentButton').on('click', function() {

Coaden

var gulp = require('gulp');
var rimraf = require('rimraf');
var clean = require('gulp-clean');
var ts = require('gulp-typescript');
var merge = require('merge-stream');
var sourcemaps = require('gulp-sourcemaps');
var tslint = require('gulp-tslint');

var paths = {
    webroot: './wwwroot',

Coaden

var gulp = require('gulp');
var rimraf = require('rimraf');
var clean = require('gulp-clean');
var ts = require('gulp-typescript');
var merge = require('merge-stream');
var sourcemaps = require('gulp-sourcemaps');
var tslint = require('gulp-tslint');
var watch = require('gulp-watch');

var paths = {

Coaden

                            try
                            {
                                dbModel.SaveChanges();
                            }
                            catch (DbEntityValidationException dbEx)
                            {
                                foreach (var validationErrors in dbEx.EntityValidationErrors)
                                {
                                    foreach (var validationError in validationErrors.ValidationErrors)
                                    {

Coaden

//Go to chrome://settings-frame/passwords and F12, then paste this into Console and hit enter.
var decryptedRow="";
var pm = PasswordManager.getInstance();
var model = pm.savedPasswordsList_.dataModel;
var pl = pm.savedPasswordsList_;
for(i=0;i<model.length;i++){
  PasswordManager.requestShowPassword(i);
};
setTimeout(function(){
  decryptedRow += '"Name","URL","Username","Password"';