Skip to content

Instantly share code, notes, and snippets.

View daxia07's full-sized avatar

Mingxia Li daxia07

View GitHub Profile
@daxia07
daxia07 / 00.install-android-sdk.sh
Created April 13, 2021 02:51 — forked from nhtua/00.install-android-sdk.sh
Run a Headless Android Device on Ubuntu server (no GUI)
#!/bin/bash -i
#using shebang with -i to enable interactive mode (auto load .bashrc)
set -e #stop immediately if any error happens
# Install Open SDK
apt update
apt install openjdk-8-jdk -y
update-java-alternatives --set java-1.8.0-openjdk-amd64
java -version
@daxia07
daxia07 / launch.js
Created October 13, 2019 10:06
vscode
{
"version": "0.2.0",
"configurations": [
{
"name": "Chrome",
"type": "chrome",
"request": "launch",
"url": "http://localhost:3000",
"webRoot": "${workspaceRoot}/src"
}
const React = require("react")
const StylesProvider = require("@material-ui/styles/StylesProvider").default
const jssPreset = require("@material-ui/styles/jssPreset").default
const jss = require("jss")
exports.wrapRootElement = ({ element }) => {
console.log(element)
return (
<StylesProvider jss={jss.create({
...jssPreset(),
import React from "react"
import { jss } from "react-jss"
import { StylesProvider, ThemeProvider, useTheme } from "@material-ui/styles"
class SessionCheck extends React.Component {
constructor(props) {
super(props)
this.state = {
loading: true,
}
# create
CREATE DATABASE yourdbname;
CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';
GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;
#duplicate
CREATE DATABASE newdb WITH TEMPLATE originaldb OWNER dbuser;
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'originaldb' AND pid <> pg_backend_pid();
@daxia07
daxia07 / settings.json
Created August 28, 2019 01:04
vscode settings
{
"workbench.colorTheme": "Material Theme Darker",
"editor.fontSize": 18,
"editor.tabSize": 2,
"editor.wordWrap": "on",
"terminal.integrated.fontSize": 18,
"emmet.includeLanguages": {
"edge": "html"
},
"css.remoteStyleSheets": [
@daxia07
daxia07 / ts.trade_cal.py
Created April 1, 2017 00:45
check trading day
aTradingInfo = ts.trade_cal()
entry = aTradingInfo[aTradingInfo['calendarDate']==('2017/03/31')]
status = entry['isOpen'].values[0]
print status
@daxia07
daxia07 / bsreadhtml.py
Created March 31, 2017 23:36
readhtml with bs4
url = 'http://www.sse.com.cn/market/othersdata/margin/detail/'
page = urlopen(url).read()
soup = BeautifulSoup(page, "html.parser")
mytest = soup.find_all("table", class_="table search_")
@daxia07
daxia07 / date_insert.py
Created March 31, 2017 18:28
Insert the latest trading date
FILE_A_TRADING_Day = 'A_Trading_Day.txt'
FILE_HK_TRADING_Day = 'HK_Trading_Day.txt'
FILE_US_TRADING_Day = 'US_Trading_Day.txt'
today = time.strftime("%Y%m%d", time.localtime())
yesterday = time.strftime("%Y%m%d", time.localtime(time.time() - 24 * 60 * 60))
#Insert the latest trading day; A stock market for test
conn = pymysql.connect(host='172.28.249.24', user='stock_reader', passwd='stock_reader@', db='fq_base', port=13360)
sql = "SELECT MAX(Date) FROM fq_base.ascore2; "
# find the max date in the database, if it equals today, the database is ready, and it is a trading day today
@daxia07
daxia07 / writetextontop.py
Last active April 3, 2017 12:02
This function inserts the newest trading date into the specified txt file
FILE_A_TRADING_Day = 'A_Trading_Day.txt'
FILE_HK_TRADING_Day = 'HK_Trading_Day.txt'
FILE_US_TRADING_Day = 'US_Trading_Day.txt'
today = time.strftime("%Y%m%d", time.localtime())
def line_prepender_without_verbose(filename, line):
with open(filename, 'r+') as f:
firstline = f.readline()
if firstline == line+'\n':