Skip to content

Instantly share code, notes, and snippets.

View Gogetter's full-sized avatar

Etimbuk U Gogetter

2 followers · 4 following
View GitHub Profile
@Gogetter
Gogetter / adding_a_drawer.dart
Last active May 27, 2018 18:49
Using Flutter Drawer Widget
return new Scaffold(
appBar: new AppBar(
//App bar bit
),
drawer: new Drawer(
),
@Gogetter
Gogetter / add-user-accounts-drawer-header-to-drawer
Last active May 27, 2018 19:20
adding UserAccountsDrawerHeader to Drawer
return new Scaffold(
appBar: new AppBar(
)
),
drawer: new Drawer(
child: new ListView(
children: <Widget>[
@Gogetter
Gogetter / add-drawer-items-to-drawer
Created May 27, 2018 19:22
Flutter - Adding drawer items to Drawer
drawer: new Drawer(
child: new ListView(
children: <Widget>[
//display current user info
new UserAccountsDrawerHeader(
decoration: new BoxDecoration(color: Colors.white),
currentAccountPicture: new CircleAvatar(
backgroundImage: currentUser.photoUrl.isNotEmpty ?
new NetworkImage(currentUser.photoUrl) : currentUser.displayName.substring(0)),
@Gogetter
Gogetter / pull-mssql-server-image
Created February 6, 2019 19:28
docker pull mcr.microsoft.com/mssql/server:2017-latest
@Gogetter
Gogetter / docker-run-mssql-server-image
Created February 7, 2019 18:52
docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=MySoVery3tr045Pass3!o79" `
-p 1433:1433 --name dev-mssql-server `
-d mcr.microsoft.com/mssql/server:2017-latest
@Gogetter
Gogetter / docker-run-command-args-details.csv
Last active February 9, 2019 17:59
Argument Description
-e ACCEPT_EULA=Y A Y or N value expected. This confirms or rejects your acceptance of the [End-User Licensing Agreement](https://go.microsoft.com/fwlink/?LinkId=746388). This is required for setting up the MS-SQL Server image.
-e SA_PASSWORD=MySoVery3tr045Pass3!o79 Allows you specify our password. This should meet requirements stated [here](https://docs.microsoft.com/en-us/sql/relational-databases/security/password-policy?view=sql-server-linux-ver15).
-p 1433:1433 This is same as --publish. Allows you publish a container's port(s) to the host
--name dev-mssql-server Assign a name to the container. This enables you easily remember what a container is for.
-d This is same as --detach. Allows you run container in background and print container ID
mcr.microsoft.com/mssql/server:2017-latest The MS-SQL Server image to use.
@Gogetter
Gogetter / ConsumerComplaints.csv
Created February 9, 2019 20:36
We can't make this file beautiful and searchable because it's too large.
Date Received,Product Name,Sub Product,Issue,Sub Issue,Consumer Complaint Narrative,Company Public Response,Company,State Name,Zip Code,Tags,Consumer Consent Provided,Submitted via,Date Sent to Company,Company Response to Consumer,Timely Response,Consumer Disputed,Complaint ID
2013-07-29,Consumer Loan,Vehicle loan,Managing the loan or lease,,,,Wells Fargo & Company,VA,24540,,N/A,Phone,2013-07-30,Closed with explanation,Yes,No,468882
2013-07-29,Bank account or service,Checking account,Using a debit or ATM card,,,,Wells Fargo & Company,CA,95992,Older American,N/A,Web,2013-07-31,Closed with explanation,Yes,No,468889
2013-07-29,Bank account or service,Checking account,"Account opening, closing, or management",,,,Santander Bank US,NY,10065,,N/A,Fax,2013-07-31,Closed,Yes,No,468879
2013-07-29,Bank account or service,Checking account,Deposits and withdrawals,,,,Wells Fargo & Company,GA,30084,,N/A,Web,2013-07-30,Closed with explanation,Yes,No,468949
2013-07-29,Mortgage,Conventional fixed mortgage,"Loan servicing, paym
@Gogetter
Gogetter / connect-to-container-and-download-demo-data
Last active February 9, 2019 20:44
docker exec -it dev-mssql-server "bash"
mkdir -p /home/sql/dataset
cd /home/sql/dataset
wget "https://github.com/Gogetter/blog-posts-database/raw/dockerze-mssql/ConsumerComplaints.csv"
@Gogetter
Gogetter / explaining-connect-to-container-and-download-demo-data-commands.csv
Last active February 9, 2019 20:48
Command Description
docker exec -it dev-mssql-server 'bash' Connects to contains in interactive bash mode
mkdir -p /home/sql/dataset Create directories sql and dataset
cd /home/sql/dataset Change directory to just created directory
wget https://github.com/Gogetter/blog-posts-database/raw/dockerze-mssql/ConsumerComplaints.csv Download demo data
@Gogetter
Gogetter / setup-data.sql
Last active February 10, 2019 16:26
-- Delete database if already exists. This enables us to run without errors
drop database if exists ConsumerComplaint
go
-- create the ConsumerComplaint database
create database ConsumerComplaint
GO
-- use just created database
Use ConsumerComplaint;