Skip to content

Instantly share code, notes, and snippets.

View abbood's full-sized avatar
💭
Leading Village.do tech team

Abdullah Bakhach abbood

💭
Leading Village.do tech team
View GitHub Profile
@abbood
abbood / gist:80940e73b7df4e4373949458107fa521
Created October 13, 2020 08:10
find top SO users by location and language
select
distinct u.id as [User ID],
u.displayname as [User Name],
u.reputation as [User Rep]
from users u
join badges b
on u.id = b.userid
where upper(u.location) like upper('%' + ##YourLocation:string## + '%') -- uppercase location--
and UPPER(b.name) LIKE UPPER('%' + ##Tag:string## + '%')
@abbood
abbood / gist:12bdccf20ec2392ab67f9559d559b207
Created October 13, 2020 07:52
getting top lebanon ios devs from stackoverflow query builder
reference: https://42hire.com/how-to-find-developers-at-stackoverflow-aa0f64dcffd1
DECLARE @myUsers TABLE
(
Id int,
Reputation int,
CreationDate datetime,
DisplayName nvarchar(40),
LastAccessDate datetime,
WebsiteUrl nvarchar(200),
[items_info] => Wilgucki\Csv\CsvCollection Object
(
[items:protected] => Array
(
[0] => App\StoreItem Object
(
[dates:protected] => Array
(
[0] => deleted_at
[1] => unavailable_until
--recurse=yes
--exclude=.git
--exclude=vendor/*
--exclude=node_modules/*
--exclude=db/*
--exclude=log/*
--exclude="*/_*cache/*"
--exclude="*/_*logs{0,1}/*"
--exclude="*/_*data/*"
--fields=+laimS
syntax enable
set background=dark
set encoding=UTF-8
let g:spacegray_low_contrast = 1
colorscheme Spacegray
" colorscheme hybrid_material
syntax enable
set background=dark
let g:spacegray_low_contrast = 1
colorscheme Spacegray
" colorscheme hybrid_material
" https://stackoverflow.com/a/1764336/766570
9:[2019-02-25 00:39:01] production.DEBUG: JOB-VARS : {"phone_numbers":["+9660599291111"],"message":"Your verification code is: 74222","twilio":{},"objectKey":"job:class:App\\Jobs\\SmsJob:000000001328e347000000003113b4f8","connection":"sqs-high","queue":null,"delay":null,"job":{},"JOB-CLASS":"App\\Jobs\\SmsJob"} [] []
16:[2019-02-25 00:50:06] production.DEBUG: JOB-VARS : {"phone_numbers":["+9660533001112"],"message":"Your verification code is: 31231","twilio":{},"objectKey":"job:class:App\\Jobs\\SmsJob:00000000206561fd000000003fb01b05","connection":"sqs-high","queue":null,"delay":null,"job":{},"JOB-CLASS":"App\\Jobs\\SmsJob"} [] []
54:[2019-02-25 03:59:42] production.DEBUG: JOB-VARS : {"phone_numbers":["+9647707771113"],"message":"Your verification code is: 64628","twilio":{},"objectKey":"job:class:App\\Jobs\\SmsJob:0000000003baa9660000000022c0679c","connection":"sqs-high","queue":null,"delay":null,"job":{},"JOB-CLASS":"App\\Jobs\\SmsJob"} [] []
import AFDateHelper
import Foundation
import UIKit
protocol OrderReceiptTableViewCellDelegate: class {
func orderHistoryCellDidTouchTrack(_ cell: OrderHistoryTableViewCell)
}
final class OrderReceipt_Header_TableViewCell: UITableViewCell, CellViewPropertiesProviderProtocol {
# hello
[2018 - 06 - 21 09: 26: 10] staging.ERROR: ErrorException: Undefined property: Phaza\ LaravelPostgis\ Eloquent\ Builder::$id in /home/forge /
default / envoyer / releases / 20180620170543 / app / Repositories / Util / OpCityIP.php: 76 Stack trace: #0 /home/forge/default/envoyer/releases/20180620170543/vendor/sentry/sentry/lib/Raven/Breadcrumbs/ErrorHandler.php(34): Illuminate\Foundation\Bootstrap\HandleExceptions->handleError(8, 'Undefined prope...', '/home/forge/def...', 76, Array) # 1 / home / forge /
default / envoyer / releases / 20180620170543 / app / Repositories / Util / OpCityIP.php(76): Raven_Breadcrumbs_ErrorHandler - > handleError(8, 'Undefined prope...', '/home/forge/def...', 76, Array) #2 /home/forge/default/envoyer/releases/20180620170543/app/Traits/OpCityTrait.php(24): App\Repositories\Util\OpCityIP::get('85.112.74.194') # 3 / home / forge /
default / envoyer / releases / 20180620170543 / app / Http / Controllers / Accounts / ClientsRegistrationController.php(91): App\ Http\ Control