Phil callmephil

SQLite - Check Contraints

Prelude:

Rule 1. I do not trust the backend.
Rule 2. I do not trust the frontend.
Rule 3. I and only I decide what should I store or not.

When managing a database you want to remember the three rules above. As we do not know which silly magic is used to fill the data in our database we need to ensure the integrity of our data. defining a data type (text, integer, date) is not secure enough. So most database manager (MySql, SQLite, MariaDB) use CHECK Constraints. It is a simple process to verify that the inputs fits the requirements of your app before inserting any data in your tables.

Important: CHECK(...) behave like if constraints which means you can perfom any operations within the parenthesis.

	import 'package:flutter/material.dart';

	void main() {
	runApp(MyApp());
	}

	class MyApp extends StatelessWidget {
	@override
	Widget build(BuildContext context) {
	return MaterialApp(

	'use strict'

	/*
	This script can be used with nodejs to convert the larger json file into a smaller one

	ref*: https://gist.githubusercontent.com/callmephil/d9b8ac5dc03a325c01bfd5a5bf661816/raw/a1b0ad0565ce1d70c783e98187ebdf6b28942a71/countries.json
	*/

	const fs = require('fs');
	const jsonData = require('./countries.json');

	{
	"success": true,
	"result": [{
	"name": "Afghanistan",
	"topLevelDomain": [".af"],
	"alpha2Code": "AF",
	"alpha3Code": "AFG",
	"callingCodes": ["93"],
	"capital": "Kabul",
	"altSpellings": ["AF", "Afġānistān"],


	/*
	##Device = Desktops
	##Screen = 1281px to higher resolution desktops
	*/

	@media (min-width: 1281px) {

	//CSS

	class spell_gen_mount : public SpellScriptLoader
	{
	public:
	spell_gen_mount(char const* name, uint32 mount0 = 0, uint32 mount60 = 0, uint32 mount100 = 0, uint32 mount150 = 0, uint32 mount280 = 0, uint32 mount310 = 0) : SpellScriptLoader(name),
	_mount0(mount0), _mount60(mount60), _mount100(mount100), _mount150(mount150), _mount280(mount280), _mount310(mount310) { }

	class spell_gen_mount_SpellScript : public SpellScript
	{
	PrepareSpellScript(spell_gen_mount_SpellScript);

	"use strict";

	const EMOJI = [
	{
	sentiment: "joy",
	expression: {
	extreme: "😂",
	medium: "🙂",
	slightly: "😄",
	neutral: "🙂"

	const getDaysDiff = (start_date, end_date, date_format = 'YYYY-MM-DD') => {
	const getDateAsArray = (date) => {
	return moment(date.split(/\D+/), date_format);
	}
	return getDateAsArray(end_date).diff(getDateAsArray(start_date), 'days') + 1;
	}

	Phil 21/01/2019,
	Imad 22/01/2019,
	Mario 23/01/2019,
	Adel 24/01/2019,
	Patricia 25/01/2019,
	Mario 28/01/2019,
	Imad 29/01/2019,
	Ala'a 30/01/2019,
	Hussein.H 31/01/2019,
	Imad 01/02/2019,

	@import url(//netdna.bootstrapcdn.com/font-awesome/4.0.3/css/font-awesome.css);

	@import url(https://fonts.googleapis.com/css?family=Titillium+Web:300);

	.fa-2x {
	font-size: 2em;
	}

	.fa {
	position: relative;