Skip to content

Instantly share code, notes, and snippets.

View medhatelmasry's full-sized avatar

Medhat Elmasry medhatelmasry

View GitHub Profile
void main() {
List<String> myList = [
'Angela',
'James',
'Katie',
'Jack',
];
}
ProductId,ProductName,UnitsInStock,UnitPrice
1,Aniseed Syrup,39,18
2,Chef Anton's Cajun Seasoning,17,19
3,Chef Anton's Gumbo Mix,13,10
4,Grandma's Boysenberry Spread,53,22
5,Uncle Bob's Organic Dried Pears,0,21.35
6,Northwoods Cranberry Sauce,120,25
7,Mishi Kobe Niku,15,30
8,Ikura,6,40
9,Queso Cabrales,29,97
@medhatelmasry
medhatelmasry / fifa-world-cup.csv
Last active October 29, 2024 19:48
List of men and women FIFA Soccer World Cups
GameId Year Gender City Country Continent Winner
1 1930 Men Montevideo Uruguay South America Uruguay
2 1934 Men Rome Italy Europe Italy
3 1938 Men Paris France Europe Italy
4 1950 Men Rio de Janeiro Brazil South America Uruguay
5 1954 Men Bern Switzerland Europe West Germany
6 1958 Men Stockholm Sweden Europe Brazil
7 1962 Men Santiago Chile South America Brazil
8 1966 Men London England Europe England
9 1970 Men Mexico City Mexico North America Brazil
@medhatelmasry
medhatelmasry / delete-bin-obj-mac.txt
Created November 19, 2024 21:16
Delete all bin & obj folder on a mac
find . -iname "bin" -o -iname "obj" | xargs rm -rf
@medhatelmasry
medhatelmasry / apply-migrations.txt
Created November 21, 2024 02:00
programatically apply migrations
using (var scope = app.Services.CreateScope()) {
var services = scope.ServiceProvider;
var context = services.GetRequiredService<HealthContext>();
context.Database.Migrate();
}
@medhatelmasry
medhatelmasry / fifa-games-sqlite.sql
Created February 10, 2025 22:58
Create FIFA database in SQLite
CREATE TABLE games (
GameId INTEGER PRIMARY KEY AUTOINCREMENT,
Year INTEGER NOT Null,
Gender TEXT CHECK(Gender IN ('Men', 'Women')) NOT NULL,
City TEXT NOT NULL,
Country TEXT NOT NULL,
Continent TEXT CHECK(Continent IN (
'South America',
'Europe',
'North America',
@medhatelmasry
medhatelmasry / fifa-games-sqlServer.sql
Last active February 12, 2025 16:00
Create FIFA games in SQL Server
CREATE TABLE [dbo].[games] (
[GameId] [int] IDENTITY(1,1) PRIMARY KEY,
[Year] [int] NOT NULL,
[Gender] [varchar](10) NOT NULL CHECK ([Gender] IN ('Men', 'Women')),
[City] [varchar](50) NOT NULL,
[Country] [varchar](50) NOT NULL,
[Continent] [varchar](50) CHECK ([Continent] IN (
'South America',
'Europe',
'North America',
@medhatelmasry
medhatelmasry / beverages.csv
Created March 21, 2025 03:29
facts about popular beverages
BeverageId Name Type MainIngredient Origin CaloriesPerServing
1 Coca-Cola Soft Drink Sugar United States 140
2 Pepsi Soft Drink Sugar United States 150
3 Green Tea Tea Green Tea Leaves China 0
4 Espresso Coffee Coffee Beans Italy 5
5 Smoothie Fruit Drink Fruit United States 250
6 Pina Colada Cocktail Coconut Cream Puerto Rico 245
7 Lemonade Soft Drink Lemon Ancient Egypt 120
8 Milkshake Dairy Drink Milk United States 350
9 Chai Tea Black Tea Leaves and Spices India 150
@medhatelmasry
medhatelmasry / create-students-table-sql-server.sql
Last active April 3, 2025 17:13
Create Students table in SQL Server
CREATE DATABASE SchoolDB;
GO
USE SchoolDB;
GO
CREATE TABLE Students
(
StudentId int IDENTITY(1,1) PRIMARY KEY,
LastName varchar(50) NOT NULL,
@medhatelmasry
medhatelmasry / students.csv
Last active May 5, 2025 17:37
students.csv
StudentId FirstName LastName School
1 Tom Max Nursing
2 Ann Fay Mining
3 Joe Sun Nursing
4 Sue Fox Computing
5 Ben Ray Mining
6 Zoe Cox Business
7 Sam Ray Mining
8 Dan Ash Medicine
9 Pat Lee Computing