b5463c41faa4 basic-example "java -jar app.jar" 6 seconds ago Up 2 seconds 0.0.0.0:8086->8085/tcp nifty_babbagec2cee2839f57 redis:5.0.5-alpine3.9 "docker-entrypoint.s…" 3 days ago Exited (255) 2 days ago 0.0.0.0:6379->6379/tcp redis-pdocker-compose.yml через ports:networks:IPADDRESS=$(docker inspect $ID | jq -cr '.[]|.NetworkSettings.Networks."basic-elk-cluster_elastic".IPAddress')
echo "IPADDRESS=$IPADDRESS"
INSERT INTO words (
baseWord,
serverVersion,
translatedList,
transcription,
partOfSpeech,
examples,
image,
synonims,
categoryId
)SELECT
baseWord,
serverVersion,
translatedList,
transcription,
partOfSpeech,
examples,
image,
synonims,
0
from ...date_end, time_enddate_start, time_start datetimeпотом в epochпотом castв long, вычесть и отформатироватьselect STRFTIME("%H:%M:%S", CAST( strftime('%s',datetime(date_end, time_end ) ) AS LONG ) - CAST( strftime('%s', datetime(date_start, time_start ) ) AS LONG) ) from _variables;drop table IF EXISTS _Variables;
CREATE TEMP TABLE _Variables(date_end date, time_end time, date_start date, time_start time) ;
INSERT INTO _Variables VALUES ('2022-01-21', '13:00:00', '2022-01-21', '01:00:00');Parseкласса JArrayвместо того же от JObject:string json = @"[
'Small',
'Medium',
'Large'
]";
JArray a = JArray.Parse(json);#!/usr/bin/env python
# -*- coding: utf-8 -*-
# based on: https://stackoverflow.com/questions/74793705/how-to-load-chrome-options-using-undetected-chrome
# uses CDP to override the user agent header
import time,os,sys
from selenium import webdriver
from selenium.webdriver.chrome.options import Options
import json, base64
def send_command_return_result(driver, cmd, params = {}, resultkey = 'windowId'):
post_url = driver.command_executor._url + '/session/{0:s}/chromium/send_command_and_get_result'.format( driver.session_id)
response = driver.command_executor._request('POST', post_url, json.dumps({'cmd': cmd, 'params': params}))
print('response: {}'.format(response))
if ('status' in response ) and response['status']:
raise Exception(response.get('value'))
return response.get('value').get(resultkey)
def send_command(driver, cmd, params = {}):
post_url = driver.command_executor._url + '/session/{0:s}/chromium/send_command_and_get_result'.format( driver.session_id)
response = driver.command_executor._request('POST', post_url, json.dumps({'cmd': cmd, 'params': params}))
if ('status' in response ) and response['status']:
raise Exception(response.get('value'))
global debug
debug = False
if __name__ == '__main__':
webdriver_options = Options()
# comment to see the browser window
webdriver_options.add_argument('--headless')
webdriver_options.add_argument('--disable-gpu')
# for annotated list of chrome headless flags, see
# https://peter.sh/experiments/chromium-command-line-switches/
# https://groups.google.com/forum/#!topic/selenium-users/SnxpvG8Erj4
if os.getenv('OS') != None :
homedir = os.getenv('USERPROFILE').replace('\\', '/')
is_windows = True
else:
homedir = os.getenv('HOME')
is_windows = False
chromedriver_path = homedir + os.sep + 'Downloads' + os.sep + ('chromedriver.exe' if is_windows else 'chromedriver')
driver = webdriver.Chrome(chromedriver_path, options = webdriver_options)
# https://chromedevtools.github.io/devtools-protocol/tot/Network/#method-setUserAgentOverride
send_command(driver,
'Network.setUserAgentOverride', {
'userAgent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:72.0) Gecko/20100101 Firefox/72.0',
}
)
url = 'https://www.whatismybrowser.com/detect/what-http-headers-is-my-browser-sending'
driver.get(url)
time.sleep(5)
xpath = '//*[@id="content-base"]//table//th[contains(text(),"USER-AGENT")]/../td'
element = driver.find_element_by_xpath(xpath)
print( element.get_attribute('innerHTML'))
driver.quit()
# PATH=%PATH%;c:\Python381;%USERPROFILE%\Downloadsself.options.add_experimental_option('excludeSwitches', ['disable-popup-blocking'])a.tar есть файлы d*и t* и еще какие нибуль тогда чтобы извлечь d*tar tvf a.tar | grep -E ' \bd' | awk '{print $NF}' | xargs -IX tar xvf a.tar X\b есть пробел: ' \bd'd - первая буква тех файлов что хотим извлечьtar tvf a.tar | grep -E '/\bd | ... - то есть вместо пробела поставить разделитель пути
driver.find_element(By.CSS_SELECTOR, ".calendar__day-cell")@перед именем атрибута в []driver.find_element(By.CSS_SELECTOR, "div[aria-label='Sat Dec 17 2022']")https://raw.githubusercontent.com/stn32/store-06/main/db/db.jsonLIKE CREATE TABLE contacts (
first_name text NOT NULL,
last_name text NOT NULL,
email text NOT NULL
);CREATE UNIQUE INDEX idx_contacts_emailEXPLAIN QUERY PLAN
SELECT
first_name,
last_name,
email
FROM
contacts
WHERE
email LIKE 'lisa.smith@sqlitetutorial.ne%';SEARCH TABLE contacts USING INDEX idx_contacts_email (email>? AND email<?)TABLE SCAN
docker-compose.yml:version: "3.7"
services:
app:
image: sample-java17-app
user: "${UID:-1000}:${GID:-1000}"
command: "java -jar /app/target/demo-2.7.5.jar"
volumes:
- .:/app
ports:
- "8585:8080"
environment:
UID: ${UID:-1000}
GID: ${GID:-1000}$(id -u) $(id -g) в вашей машине
func (h *HTMLElement) ChildTextgo(querySelector string) stringfunc (h *HTMLElement) ChildTexts(goquerySelector string) []stringresult := strings.Join(data, ",")
fmt.Println(result