Erkin Eren erkineren

## abdf.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                erkineren
                / abdf.md
            
            
              Last active
              January 25, 2022 08:44
            
              
                flutter adbf > build + install + stop + start + logcat 
              
          
    flutter adbf > build + install + stop + start + logcat

INFO

adbf.sh is adb-flutter command line script that composed with flutter and adb commands. Go to code
USAGE


Default behaviour (flutter build + stop app + install app + start app + show logcat of app)
adbf.sh


## emulator-install-using-avdmanager.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                erkineren
                / emulator-install-using-avdmanager.md
            
            
              Created
              September 10, 2021 15:34
                — forked from mrk-han/emulator-install-using-avdmanager.md
            
              
                Installing and creating Emulators with AVDMANAGER (For Continuous Integration Server or Local Use)
              
          
    Install and Create Emulators using AVDMANAGER and SDKMANAGER

TL;DR

For generic skin emulator with default apis (without google apis):


List All System Images Available for Download: sdkmanager --list | grep system-images


Download Image: sdkmanager --install "system-images;android-29;default;x86"


## media-query.css

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

@media (min-width: 1281px) {

  //CSS


## mailbird database location windows
%UserProfile%\AppData\Local\Mailbird\Store\Store.db

## certbot-wildcard.sh
certbot certonly --manual --preferred-challenges dns --server https://acme-v02.api.letsencrypt.org/directory --manual-public-ip-logging-ok -d '*.domain.tld' -d domain.tld && \
certbot --preferred-challenges dns --server https://acme-v02.api.letsencrypt.org/directory --manual-public-ip-logging-ok -d '*.domain.tld' -d domain.tld

## mysql.functions.sql
CREATE FUNCTION `random_datetime_in_range`(
	`min_date` TIMESTAMP,
	`max_date` TIMESTAMP
)
RETURNS TIMESTAMP
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT 'Returns new timestamp between %min_data% and %max_date%'

## db-change-character-set-quickly.sql
SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;')
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'db_name';

# Example Output - Örnek Çıktı:
# ALTER TABLE db_name.table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

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

	@media (min-width: 1281px) {

	//CSS
	certbot certonly --manual --preferred-challenges dns --server https://acme-v02.api.letsencrypt.org/directory --manual-public-ip-logging-ok -d '*.domain.tld' -d domain.tld && \
	certbot --preferred-challenges dns --server https://acme-v02.api.letsencrypt.org/directory --manual-public-ip-logging-ok -d '*.domain.tld' -d domain.tld
	CREATE FUNCTION `random_datetime_in_range`(
	`min_date` TIMESTAMP,
	`max_date` TIMESTAMP
	)
	RETURNS TIMESTAMP
	LANGUAGE SQL
	NOT DETERMINISTIC
	CONTAINS SQL
	SQL SECURITY DEFINER
	COMMENT 'Returns new timestamp between %min_data% and %max_date%'
	SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;')
	FROM information_schema.TABLES
	WHERE TABLE_SCHEMA = 'db_name';

	# Example Output - Örnek Çıktı:
	# ALTER TABLE db_name.table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;