Gokhan Celik kafkadev

## sqlite3-fts4
CREATE VIEW u_v AS SELECT user_id rowid, meta_value FROM wp_usermeta;

CREATE VIRTUAL TABLE "fts4_uv" USING FTS4 (
    meta_value,
    content="u_v"
)

INSERT INTO fts4_uv (rowid, meta_value)
SELECT rowid, meta_value
FROM u_v;

## sqlite3-fst5
CREATE TABLE tracks(rowid INTEGER PRIMARY KEY, track_name varchar, ref_aid integer, ref_rid integer);
CREATE TABLE artists(artist_name varchar, aid integer);
CREATE TABLE releases(release_name varchar, rid integer);

CREATE VIEW v AS
SELECT rowid, track_name, artist_name, release_name
FROM tracks, artists, releases
WHERE ref_aid = aid AND ref_rid = rid;

CREATE VIRTUAL TABLE t USING fts4(content="v", track_name, artist_name, release_name);

## SQLite3.chpl
// Generated with c2chapel version 0.1.0

// Header given to c2chapel:
require "sqlite3.h";

// Note: Generated with fake std headers

// #define'd integer literals:
// Note: some of these may have been defined with an ifdef
extern const SQLITE_VERSION_NUMBER : int;

## -
SQLite
Small. Fast. Reliable.
Choose any three.
Home
About
Documentation
Download
License
Support
Purchase

## sqlite_to_json.sql
-- When SQLite is compiled with the JSON1 extensions it provides builtin tools
-- for manipulating JSON data stored in the database.
-- This is a gist showing SQLite return query data as a JSON object.
-- https://www.sqlite.org/json1.html

-- An example table with some data
CREATE TABLE users (
  id INTEGER PRIMARY KEY NOT NULL,
  full_name TEXT NOT NULL,
  email TEXT NOT NULL,

## gist:525d618bc4b7779b9c63e639c6fa4e10
(function(source, onScriptLoaded) {
    var s = document.createElement('script');
    s.type = 'text/javascript';
    s.src = source;

    if (s.addEventListener) {
        // on modern browsers, don't block the main thread while loading the library
        s.addEventListener('load', function() {
            setTimeout(onScriptLoaded, 0);
        }, false);

## mail.php
<?php

return array(

	// Send it mail via SMTP
	'driver' => 'smtp',

	// Whatever port you have MailCatcher's SMTP server running on (they suggest 1025)
	'port' => 1025,


## demoService.skema
[{"name":"Bears","color":"Blue","position":{"x":177,"y":85},"modelclass":"Bear","increment":false,"timestamp":false,"softdelete":false,"column":[{"colid":"c217","name":"id","type":"increments","length":"0","order":0,"defaultvalue":"","enumvalue":""},{"colid":"c218","name":"name","type":"string","length":"200","order":1,"defaultvalue":"","enumvalue":""},{"colid":"c219","name":"danger_level","type":"string","length":"200","order":2,"defaultvalue":"","enumvalue":""}],"relation":[{"extramethods":"","foreignkeys":"","name":"fish","relatedmodel":"Fish","relationtype":"hasOne","usenamespace":""},{"extramethods":"","foreignkeys":"","name":"trees","relatedmodel":"Trees","relationtype":"hasMany","usenamespace":""},{"extramethods":"","foreignkeys":"bear_id, picnic_id","name":"picnics","relatedmodel":"Picnics","relationtype":"belongsToMany","usenamespace":""}],"seeding":[]},{"name":"Fish","color":"Yellow","position":{"x":1063,"y":14},"modelclass":"Fish","increment":false,"timestamp":false,"softdelete":false,"column":[{"c

## gist:2f6395eeae26949cb5b1c55348b56441
<?php namespace App\Http;

use Illuminate\Foundation\Http\Kernel as HttpKernel;

class Kernel extends HttpKernel {

	/**
	 * The application's global HTTP middleware stack.
	 *
	 * @var array

## gist:f505981886f1c464e4d12460a8beec0d
<?php
Route::group(['module' => 'Admin', 'namespace' => 'App\Modules\Admin\Controllers', 'middleware'	=>	'CheckRole'], function() {
	Route::get('/admin/dashboard',
				[
					'as'			=>	'admin.dashboard',
					'uses'			=>	'IndexController@index'
				]
			);
});
	CREATE VIEW u_v AS SELECT user_id rowid, meta_value FROM wp_usermeta;

	CREATE VIRTUAL TABLE "fts4_uv" USING FTS4 (
	meta_value,
	content="u_v"
	)

	INSERT INTO fts4_uv (rowid, meta_value)
	SELECT rowid, meta_value
	FROM u_v;
	CREATE TABLE tracks(rowid INTEGER PRIMARY KEY, track_name varchar, ref_aid integer, ref_rid integer);
	CREATE TABLE artists(artist_name varchar, aid integer);
	CREATE TABLE releases(release_name varchar, rid integer);

	CREATE VIEW v AS
	SELECT rowid, track_name, artist_name, release_name
	FROM tracks, artists, releases
	WHERE ref_aid = aid AND ref_rid = rid;

	CREATE VIRTUAL TABLE t USING fts4(content="v", track_name, artist_name, release_name);
	// Generated with c2chapel version 0.1.0

	// Header given to c2chapel:
	require "sqlite3.h";

	// Note: Generated with fake std headers

	// #define'd integer literals:
	// Note: some of these may have been defined with an ifdef
	extern const SQLITE_VERSION_NUMBER : int;
	SQLite
	Small. Fast. Reliable.
	Choose any three.
	Home
	About
	Documentation
	Download
	License
	Support
	Purchase
	-- When SQLite is compiled with the JSON1 extensions it provides builtin tools
	-- for manipulating JSON data stored in the database.
	-- This is a gist showing SQLite return query data as a JSON object.
	-- https://www.sqlite.org/json1.html

	-- An example table with some data
	CREATE TABLE users (
	id INTEGER PRIMARY KEY NOT NULL,
	full_name TEXT NOT NULL,
	email TEXT NOT NULL,
	(function(source, onScriptLoaded) {
	var s = document.createElement('script');
	s.type = 'text/javascript';
	s.src = source;

	if (s.addEventListener) {
	// on modern browsers, don't block the main thread while loading the library
	s.addEventListener('load', function() {
	setTimeout(onScriptLoaded, 0);
	}, false);
	<?php

	return array(

	// Send it mail via SMTP
	'driver' => 'smtp',

	// Whatever port you have MailCatcher's SMTP server running on (they suggest 1025)
	'port' => 1025,
	<?php namespace App\Http;

	use Illuminate\Foundation\Http\Kernel as HttpKernel;

	class Kernel extends HttpKernel {

	/**
	* The application's global HTTP middleware stack.
	*
	* @var array
	<?php
	Route::group(['module' => 'Admin', 'namespace' => 'App\Modules\Admin\Controllers', 'middleware' => 'CheckRole'], function() {
	Route::get('/admin/dashboard',
	[
	'as' => 'admin.dashboard',
	'uses' => 'IndexController@index'
	]
	);
	});