Skip to content

Instantly share code, notes, and snippets.

View loonix's full-sized avatar

Daniel Carneiro loonix

  • CADS UK
  • Vila Nova de Gaia, PT
View GitHub Profile
@loonix
loonix / comandos.sql
Last active May 8, 2020 19:27
[Bases de Dados II] #sql
--Insert files into dept from csv file
LOAD DATA LOCAL INFILE 'C:\\Users\\danie\\Desktop\\db2.csv' INTO TABLE dept
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
LOAD DATA LOCAL INFILE 'C:\\Users\\danie\\Desktop\\db21.csv' INTO TABLE emp
FIELDS TERMINATED BY ','
ENCLOSED BY ''
LINES TERMINATED BY '\r\n';
@loonix
loonix / snippets.dart
Created April 2, 2020 07:37
[Flutter] Snippets #flutter
///
/// Converting class objects to JSON string in Flutter
///
class Employee {
final String name;
final String email;
Employee(this.name, this.email);
Employee.fromJson(Map<String, dynamic> json)
@loonix
loonix / ano-bissexto.alg
Last active December 6, 2019 10:06
[Portugol] Ver se ano e bissexto #portugol
inicio
variavel inteiro ano
variavel inteiro resto4
variavel inteiro resto100
variavel inteiro resto400
escrever "Introduza um ano: "
ler ano
resto4 <- ano % 4
resto100 <- ano % 100
@loonix
loonix / soma-media-prod.alg
Created October 16, 2019 19:39
[Portugol] Soma, media e multiplicacao
inicio
inteiro num1
inteiro num2
inteiro sum
inteiro prod
inteiro media
num1 <- 0
num2 <- 0
escrever "Introduza o primeiro numero:"
ler num1
@loonix
loonix / converter-km-para-milhas-nauticas-pes.alg
Last active October 16, 2019 19:36
[Portugol] Converter km em milhas, milhas nauticas e pes #portugol
inicio
real numkm
inteiro km_m
inteiro mnauticas
inteiro milhas
inteiro pes
numKm <- 0.0
escrever "Introduza o número de KM:"
ler numkm
km_m <- numKm *1000
@loonix
loonix / par-ou-impar.alg
Last active October 21, 2021 22:00
[Portugol] Verificar se numero e par ou impar #portugol
// Ler um numero e escrever se o numero e par ou impar
inicio
variavel inteiro numero
variavel real quociente
variavel inteiro resto
variavel inteiro resto2
escrever "Introduza numero: "
ler numero
@loonix
loonix / find-match.service.spec.ts
Created April 18, 2019 11:52
Find Best Match Typescript
import { TestBed, inject } from '@angular/core/testing';
import { FindMatchService } from './find-match.service';
describe('FindMatchService', () => {
beforeEach(() => {
TestBed.configureTestingModule({
providers: [FindMatchService]
});
});
@loonix
loonix / highlight-and-flash-cell-slickgrid.ts
Created April 9, 2019 15:20
SlickGrid on cell change highlight and flash cell and apply class
/*
<angular-slickgrid gridId="importGrid" [columnDefinitions]="columnDefinitions" [gridOptions]="gridOptions"
[dataset]="dataset" (onAngularGridCreated)="angularGridReady($event)"
(sgOnCellChange)="onCellChanged($event.detail.eventData, $event.detail.args)" <----- required
>
</angular-slickgrid>
*/
@loonix
loonix / gist:a70ef802ef8906adb177c0d405f52e2f
Last active July 30, 2018 09:05
Failed to install 'cordova-plugin-crosswalk-webview': Error: Unhandled "error" event. (Parsing ...\platforms\android\res\xml\config.xml failed)
If the version is 8 then follow these steps.
$ cordova -v
8.0.0
Modify the line 33--34 in your_project/plugins/cordova-plugin-crosswalk-webview/hooks/update_config.js
// platformConfigurationFile = path.join(androidPlatformDir,
// 'res', 'xml', 'config.xml'),
platformConfigurationFile = path.join(androidPlatformDir,
'app', 'src', 'main', 'res', 'xml', 'config.xml'),
@loonix
loonix / date.xsl
Created October 26, 2017 09:41
This will format a xsl-fo date to "DD/MM/YYY HH:MM" from a format "YYYY-MM-DDTHH:MM:SS
<!--This will format a date to "DD/MM/YYY HH:MM" from a format "YYYY-MM-DDTHH:MM:SS"-->
<xsl:variable name="dt" select="./When"/>
<xsl:value-of select="concat(substring($dt, 9, 2),'/',substring($dt, 6, 2),'/',substring($dt, 1, 4),' ', substring($dt, 12, 2),':',substring($dt, 15, 2))"/>