Skip to content

Instantly share code, notes, and snippets.

View cliftonlabrum's full-sized avatar

Clifton Labrum cliftonlabrum

View GitHub Profile
SELECT
date, year, month, day, duration, departure, departureName, destination, destinationName, departureTime, destinationTime, route, landingsDay, landingsNight, distance, remarks, signatureId,
flight.id AS id,
flight.aircraftId AS aircraftId,
flight.trashed AS trashed,
aircraft.registration AS aircraftRegistration,
aircraft.makeModel AS aircraftMakeModel,
aircraftCategory.name AS aircraftCategoryName,
field.name,
value.time,
SELECT
date, year, month, day, duration, departure, departureName, destination, destinationName, departureTime, destinationTime, route, landingsDay, landingsNight, distance, remarks, signatureId,
flight.id AS id,
flight.aircraftId AS aircraftId,
flight.trashed AS trashed,
aircraft.registration AS aircraftRegistration,
aircraft.makeModel AS aircraftMakeModel,
aircraftCategory.name AS aircraftCategoryName,
field.name,
value.time,
SELECT
IFNULL(SUM(duration), 0) AS duration,
IFNULL(SUM(landingsDay), 0) AS landingsDay,
IFNULL(SUM(landingsNight), 0) AS landingsNight
FROM (
SELECT
flight.id,
MAX(duration) AS duration,
MAX(landingsDay) AS landingsDay,
MAX(landingsNight) AS landingsNight
@cliftonlabrum
cliftonlabrum / main.dart
Created January 26, 2023 01:07
Flutter go_router Grandchild Navigation Example
import 'package:flutter/material.dart';
import 'package:go_router/go_router.dart';
void main() {
runApp(MaterialApp(home: Routes()));
}
final GlobalKey<NavigatorState> rootNavigatorKey = GlobalKey<NavigatorState>(debugLabel: 'root');
final GlobalKey<NavigatorState> firstNavigatorKey = GlobalKey<NavigatorState>(debugLabel: 'shell');
@cliftonlabrum
cliftonlabrum / main.dart
Last active October 12, 2022 17:50
Riverpod Example
import 'package:flutter/material.dart';
import 'package:flutter_riverpod/flutter_riverpod.dart';
import "dart:math";
void main() {
runApp(
const ProviderScope(
child: MyApp(),
),
);
@cliftonlabrum
cliftonlabrum / main.dart
Last active October 12, 2022 17:50
Provider Example
import 'package:flutter/material.dart';
import 'package:provider/provider.dart';
import "dart:math";
void main() {
runApp(
MultiProvider(
providers: [
ChangeNotifierProvider(create: (context) => Person()),
],
@cliftonlabrum
cliftonlabrum / test.svelte
Created May 15, 2022 03:56
SvelteKit Component Example with Schoology
<script>
async function sample(){
console.log('Hi!')
let res = await fetch('https://api.schoology.com/v1/messages/inbox', {
method: 'GET',
headers:{
'Authorization': '[OAuth header...]',
'Accept': 'text/xml;q=1.0,application/json;q=0.0',
'Host': 'api.schoology.com',
@cliftonlabrum
cliftonlabrum / keybase.md
Created April 24, 2014 17:16
Clifton Labrum's Keybase Verification

Keybase proof

I hereby claim:

  • I am cliftonlabrum on github.
  • I am clifton (https://keybase.io/clifton) on keybase.
  • I have a public key whose fingerprint is 79EE 3EB4 963A 8E85 F54D 730F 7834 822E 98A7 E495

To claim this, I am signing this object:

@cliftonlabrum
cliftonlabrum / redirect_requests.txt
Created September 23, 2013 16:46
Redirect All Requests with mod_rewrite
# add this if it's not already in your .htaccess file
RewriteEngine on
# the rule
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ http://brum.co/$1 [R=301,L]
@cliftonlabrum
cliftonlabrum / dataToFromWebViewTitanium.js
Created September 23, 2013 16:32
Passing Data to a webView and back in Titanium.
//Send data to webView in Titanium
var timeGraph = Ti.UI.createWebView({ url:'graphs/timeGraph.html', touchEnabled:true });
timeGraph.addEventListener('load', function(){
Ti.App.fireEvent('graphCareer', series);
});
<!-- Receive data in webView -->
<script type="text/javascript">