from sqlalchemy import Integer, ForeignKey, String, Column
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship

Base = declarative_base()

class User(Base):
    __tablename__ = 'user'
    id = Column(Integer, primary_key=True)
    name = Column(String)

    addresses = relationship("Address", backref="user", lazy='dynamic')

class Address(Base):
    __tablename__ = 'address'
    id = Column(Integer, primary_key=True)
    email = Column(String)
    user_id = Column(Integer, ForeignKey('user.id'))

from sqlalchemy import Integer, ForeignKey, String, Column
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relationship

Base = declarative_base()

class User(Base):
    __tablename__ = 'user'
    id = Column(Integer, primary_key=True)
    name = Column(String)

    addresses = relationship("Address", back_populates="user")

class Address(Base):
    __tablename__ = 'address'
    id = Column(Integer, primary_key=True)
    email = Column(String)
    user_id = Column(Integer, ForeignKey('user.id'))

    user = relationship("User", back_populates="addresses")

u1 = User()
a1 = Address()
u1.addresses.append(a1)

class Parent(Base):
    __tablename__ = 'parent'
    id = Column(Integer, primary_key=True)
    child = relationship("Child", uselist=False, back_populates="parent")

class Child(Base):
    __tablename__ = 'child'
    id = Column(Integer, primary_key=True)
    parent_id = Column(Integer, ForeignKey('parent.id'))
    parent = relationship("Parent", back_populates="child")

registrations = db.Table(
    'registrations',
    db.Column('student_id', db.Integer, db.ForeignKey('students.id')),
    db.Column('class_id', db.Integer, db.ForeignKey('classes.id'))
)


class Student(db.Model):
    __tablename__ = 'students'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(64))
    classes = db.relationship('Class',
                              secondary=registrations,
                              backref=db.backref('students', lazy='dynamic'),
                              lazy='dynamic')


class Class(db.Model):
    __tablename__ = 'classes'
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(64))

class Association(Base):
    __tablename__ = 'association'
    left_id = Column(Integer, ForeignKey('left.id'), primary_key=True)
    right_id = Column(Integer, ForeignKey('right.id'), primary_key=True)
    extra_data = Column(String(50))
    child = relationship("Child", back_populates="parents")
    parent = relationship("Parent", back_populates="children")

class Parent(Base):
    __tablename__ = 'left'
    id = Column(Integer, primary_key=True)
    children = relationship("Association", back_populates="parent")

class Child(Base):
    __tablename__ = 'right'
    id = Column(Integer, primary_key=True)
    parents = relationship("Association", back_populates="child")

sudo apt install postfix

sudo postconf mail_version

myhostname = mail.example.com

sudo /etc/init.d/postfix reload

#这一行为配置域名也就是 @ 后面的部分
mydomain = $mydomain
mydestination = $myhostname
# 默认为 all 表示接受来自所有网络的请求，改为 loopback-only http://www.postfix.org/postconf.5.html
inet_interfaces = loopback-only
# 配置哪些地址邮件能够被 Postfix 转发
relay_domains = $mydomain

sendmail name@gmail.com

To: my@domain.com
Subject: sendmail test two
From: me@domain.com

And here goes the e-mail body, test test test..

echo "Subject: sendmail test" | sendmail -v my@email.com

telnet localhost 25
Trying 127.0.0.1
Connected to localhost
Escape character is '^]'.
220 mail.example.com ESMTP Postfix (Ubuntu)
MAIL FROM: youremail@gmail.com
250 2.1.0 Ok
RCPT TO: root
250 2.1.5 Ok
DATA
354 End data with .
text
.
250 2.0.0 Ok: queued as 9A13A130FDA
QUIT
Connection closed by foreign host.

sudo tailf /var/mail/root

Delivered-To: root@yourhost
Received: from localhost (localhost [127.0.0.1])
        by yourhost (Postfix) with SMTP id 9A13A130FDA
        for <root>; Wed,  5 Sep 2018 16:56:14 +0800 (CST)
Message-Id: <20180905085622.9A13A130FDA@yourhost>
Date: Wed,  5 Sep 2018 16:56:14 +0800 (CST)
From: youremail@gmail.com

text

mail user@gmail.com

mail          A       123.45.6.7

mail          MX         mail.domain.com

dig example.com mx

From name@example.com Wed Feb 25 16:04:34 2018

sudo apt-get install dovecot-core dovecot-imapd
sudo dovecot --version

npm install -g appium

$ appium-doctor
info AppiumDoctor Appium Doctor v.1.4.3
info AppiumDoctor ### Diagnostic starting ###
info AppiumDoctor  ✔ The Node.js binary was found at: /usr/bin/node
info AppiumDoctor  ✔ Node version is 8.11.4
info AppiumDoctor  ✔ ANDROID_HOME is set to: /home/einverne/Android/Sdk
info AppiumDoctor  ✔ JAVA_HOME is set to: /usr/local/jdk1.8.0_131
info AppiumDoctor  ✔ adb exists at: /home/einverne/Android/Sdk/platform-tools/adb
info AppiumDoctor  ✔ android exists at: /home/einverne/Android/Sdk/tools/android
info AppiumDoctor  ✔ emulator exists at: /home/einverne/Android/Sdk/tools/emulator
info AppiumDoctor  ✔ Bin directory of $JAVA_HOME is set
info AppiumDoctor ### Diagnostic completed, no fix needed. ###
info AppiumDoctor
info AppiumDoctor Everything looks good, bye!
info AppiumDoctor

find_element_by_id('com.google.android.calculator:id/digit_1')                # 通过 resource-id 来查找

find_element_by_name()              # 通过名字查找

find_element_by_class_name('android.widget.TextView')   # 通过类名查找

e_minus = self.driver.find_element_by_accessibility_id('einvernenus')
e_minus.click()

e5 = self.driver.find_element_by_android_uiautomator("new UiSelector().text(\"5\")")
e5.click()

login_btn.click()

user_input.send_keys('1234')

driver.press_keycode(4)

KEYCODE_CALL 拨号键 5
KEYCODE_ENDCALL 挂机键 6
KEYCODE_HOME 按键 Home 3
KEYCODE_MENU 菜单键 82
KEYCODE_BACK 返回键 4
KEYCODE_SEARCH 搜索键 84
KEYCODE_CAMERA 拍照键 27
KEYCODE_FOCUS 拍照对焦键 80
KEYCODE_POWER 电源键 26
KEYCODE_NOTIFICATION 通知键 83
KEYCODE_MUTE 话筒静音键 91
KEYCODE_VOLUME_MUTE 扬声器静音键 164
KEYCODE_VOLUME_UP 音量增加键 24
KEYCODE_VOLUME_DOWN 音量减小键 25

KEYCODE_ENTER 回车键 66
KEYCODE_ESCAPE ESC 键 111
KEYCODE_DPAD_CENTER 导航键 确定键 23
KEYCODE_DPAD_UP 导航键 向上 19
KEYCODE_DPAD_DOWN 导航键 向下 20
KEYCODE_DPAD_LEFT 导航键 向左 21
KEYCODE_DPAD_RIGHT 导航键 向右 22
KEYCODE_MOVE_HOME 光标移动到开始键 122
KEYCODE_MOVE_END 光标移动到末尾键 123
KEYCODE_PAGE_UP 向上翻页键 92
KEYCODE_PAGE_DOWN 向下翻页键 93
KEYCODE_DEL 退格键 67
KEYCODE_FORWARD_DEL 删除键 112
KEYCODE_INSERT 插入键 124
KEYCODE_TAB Tab 键 61
KEYCODE_NUM_LOCK 小键盘锁 143
KEYCODE_CAPS_LOCK 大写锁定键 115
KEYCODE_BREAK Break/Pause 键 121
KEYCODE_SCROLL_LOCK 滚动锁定键 116
KEYCODE_ZOOM_IN 放大键 168
KEYCODE_ZOOM_OUT 缩小键 169

KEYCODE_ALT_LEFT Alt+Left
KEYCODE_ALT_RIGHT Alt+Right
KEYCODE_CTRL_LEFT Control+Left
KEYCODE_CTRL_RIGHT Control+Right
KEYCODE_SHIFT_LEFT Shift+Left
KEYCODE_SHIFT_RIGHT Shift+Right

KEYCODE_0 按键’0’ 7
KEYCODE_1 按键’1’ 8
KEYCODE_2 按键’2’ 9
KEYCODE_3 按键’3’ 10
KEYCODE_4 按键’4’ 11
KEYCODE_5 按键’5’ 12
KEYCODE_6 按键’6’ 13
KEYCODE_7 按键’7’ 14
KEYCODE_8 按键’8’ 15
KEYCODE_9 按键’9’ 16
KEYCODE_A 按键’A’ 29
KEYCODE_B 按键’B’ 30
KEYCODE_C 按键’C’ 31
KEYCODE_D 按键’D’ 32
KEYCODE_E 按键’E’ 33
KEYCODE_F 按键’F’ 34
KEYCODE_G 按键’G’ 35
KEYCODE_H 按键’H’ 36
KEYCODE_I 按键’I’ 37
KEYCODE_J 按键’J’ 38
KEYCODE_K 按键’K’ 39
KEYCODE_L 按键’L’ 40
KEYCODE_M 按键’M’ 41
KEYCODE_N 按键’N’ 42
KEYCODE_O 按键’O’ 43
KEYCODE_P 按键’P’ 44
KEYCODE_Q 按键’Q’ 45
KEYCODE_R 按键’R’ 46
KEYCODE_S 按键’S’ 47
KEYCODE_T 按键’T’ 48
KEYCODE_U 按键’U’ 49
KEYCODE_V 按键’V’ 50
KEYCODE_W 按键’W’ 51
KEYCODE_X 按键’X’ 52
KEYCODE_Y 按键’Y’ 53
KEYCODE_Z 按键’Z’ 54

lock()
unlock()

hide_keyboard()

pull_file()

push_file()

def start_activity(self, app_package, app_activity, **opts):
    """Opens an arbitrary activity during a test. If the activity belongs to
    another application, that application is started and the activity is opened.

    This is an Android-only method.

    :Args:
    - app_package - The package containing the activity to start.
    - app_activity - The activity to start.
    - app_wait_package - Begin automation after this package starts (optional).
    - app_wait_activity - Begin automation after this activity starts (optional).
    - intent_action - Intent to start (optional).
    - intent_category - Intent category to start (optional).
    - intent_flags - Flags to send to the intent (optional).
    - optional_intent_arguments - Optional arguments to the intent (optional).
    - dont_stop_app_on_reset - Should the app be stopped on reset (optional)?
    """

open_notifications()

shake()

import time
import unittest

from appium import webdriver


class AppAndroidTests(unittest.TestCase):

    def setUp(self):
        # 测试初始化
        desired_caps = {
            'platformName': 'Android',
            'platformVersion': '6.0.1',
            'deviceName': 'OnePlus3',
            'udid': '2dd11c6e',
            'automationName': 'Appium',
            'app': '/home/einverne/android/ApiDemos-debug.apk',
            'appPackage': 'io.appium.android.apis',
            'appActivity': '.ApiDemos'
        }
        self.driver = webdriver.Remote('http://localhost:4723/wd/hub',
                                       desired_caps)

        self.app_id = 'io.appium.android.apis'

    def tearDown(self):
        # 用例结束时调用
        time.sleep(5)
        self.driver.quit()

    def test_apk_install(self):
        if not self.driver.is_app_installed(self.app_id):
            self.driver.install_app("/home/einverne/android/ApiDemos-debug.apk")
        else:
            print("demo apis installed")
            self.driver.remove_app(self.app_id)

    def test_apk_close(self):
        self.driver.close_app()
        time.sleep(2)
        self.driver.launch_app()
        time.sleep(2)
        self.driver.background_app(2)
        time.sleep(4)
        self.driver.launch_app()
        time.sleep(2)
        self.driver.terminate_app(self.app_id)
        time.sleep(2)
        self.driver.reset()


if __name__ == '__main__':
    suite = unittest.TestLoader().loadTestsFromTestCase(AppAndroidTests)
    unittest.TextTestRunner(verbosity=2).run(suite)

import time
import unittest

from appium import webdriver
from appium.webdriver.common.touch_action import TouchAction


class PressAndroidTests(unittest.TestCase):
    # 主要演示点击，长按，移动等操作
    def setUp(self):
        # 测试初始化
        desired_caps = {
            'platformName': 'Android',
            'platformVersion': '6.0.1',
            'deviceName': 'OnePlus3',
            'udid': '2dd11c6e',
            'automationName': 'Appium',
            'appPackage': 'com.google.android.calculator',
            'appActivity': 'com.android.calculator2.Calculator'
        }
        self.driver = webdriver.Remote('http://localhost:4723/wd/hub',
                                       desired_caps)
        time.sleep(2)

    def tearDown(self):
        # 用例结束时调用
        time.sleep(5)
        self.driver.quit()

    def test_press(self):
        for i in range(5):
            touch_action = TouchAction(self.driver)

            # release() 取消屏幕指针
            # perform() 执行操作发送命令
            touch_action.press(x=300, y=1700).release()
            touch_action.perform()

        e_del = self.driver.find_element_by_accessibility_id('delete')
        # tap
        time.sleep(2)
        tap_action = TouchAction(self.driver)
        tap_action.tap(e_del).release().perform()

        time.sleep(2)
        # long press
        del_action = TouchAction(self.driver)
        del_action.long_press(e_del, 2)
        del_action.release().perform()

        time.sleep(2)
        arrow = self.driver.find_element_by_id(
            'com.google.android.calculator:id/arrow')
        # move
        move_action = TouchAction(self.driver)
        move_action.press(arrow)
        move_action.move_to(x=500, y=1310)
        move_action.release().perform()

        time.sleep(2)


if __name__ == '__main__':
    suite = unittest.TestLoader().loadTestsFromTestCase(PressAndroidTests)
    unittest.TextTestRunner(verbosity=2).run(suite)

cat /etc/centos-release

yum remove php* php-common

rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm

rpm -Uvh https://mirror.webtatic.com/yum/el6/latest.rpm

yum install php70w php70w-opcache

php70w
php70w-bcmath
php70w-cli
php70w-common
php70w-dba
php70w-devel
php70w-embedded
php70w-enchant
php70w-fpm
php70w-gd
php70w-imap
php70w-interbase
php70w-intl
php70w-ldap
php70w-mbstring
php70w-mcrypt
php70w-mysql
php70w-mysqlnd
php70w-odbc
php70w-opcache
php70w-pdo
php70w-pdo_dblib
php70w-pear
php70w-pecl-apcu
php70w-pecl-imagick
php70w-pecl-xdebug
php70w-pgsql
php70w-phpdbg
php70w-process
php70w-pspell
php70w-recode
php70w-snmp
php70w-soap
php70w-tidy
php70w-xml
php70w-xmlrpc

service httpd restart

第一行是关键字
第二行开始是正文，这里的正文应该包括关键字。可以使用 html 的标记（不要包含<html>) <body></body></html>, 这个程序会自动加上，另注意在转换时要指明源数据为 html).
如果需要显示音标的话，可以利用 html 指定字体就可以显示了。

Whole
<font size=5>whole</font>
<br>
<font face="Kingsoft Phonetic Plain, Tahoma">(hol,hJl; houl)</font>
</>

<a href="entry://key#section">key</a>

<img src="file://abc.gif"> 或者 <img src="/abc.gif"> 其中 src 指向的文件名大小写不敏感

@@@LINK= 关键字

colour
@@@LINK=color
</>

sudo apt install meld

sudo apt-get install clamav

sudo freshclam

clamscan OPTIONS file/folders

clamscan -r /

clamscan -r --bell -i /

clamscan -r -i / &

clamscan -r /home

clamscan -r --move=/home/USER/VIRUS /home/USER

clamscan -r --remove /home/USER

clamscan --help

sudo apt install clamtk

sudo apt-add-repository ppa:landronimirc/clamtk
sudo apt-get update && sudo apt-get install clamtk

sudo apt install thunar

thunar -B

sudo apt install nemo-dropbox

sudo apt install nextcloud-client-nemo

sudo apt install nemo-gtkhash

sudo apt-get install nemo-fileroller
nemo -q

sudo apt install nemo-share

sudo apt install nemo-compare

sudo apt install nemo-seahorse

sudo apt install nemo-terminal

[Nemo Action]
Name=Clam Scan
Comment=Clam Scan
Exec=gnome-terminal -x sh -c "clamscan -r %F | less"
Icon-Name=bug-buddy
Selection=Any
Extensions=dir;exe;dll;zip;gz;7z;rar;

[Nemo Action]
Active=true
Name=Check SHA256
Name[fr]=Vérifier le SHA256
Comment=Check the SHA256 signature of the file
Comment[fr]=Vérifier la signature SHA256 de ce fichier
Exec=mint-sha256sum '%F'
Icon-Name=gtk-execute
Selection=S
Mimetypes=application/x-iso9660-image;image/png;image/jpeg;

[Nemo Action]
Active=true
Name=Format filename %N
Comment=Replace filename space with - applied to %N
Exec=<format_filename.py %F>
Selection=any
Extensions=any;
EscapeSpaces=true

import sys
import os

command = sys.argv[0]
print("Running " + command)
print("With the following arguments:")
for arg in sys.argv:
    if command == arg:
        continue
    else:
        formated_path = arg.replace(' ', '_')
        os.rename(arg, formated_path)

Exec=gnome-terminal -x sh -c 'ffmpeg -i %F -f mp3 anyname.mp3'

xdg-mime query default inode/directory

xdg-mime default nemo.desktop inode/directory application/x-gnome-saved-search

xdg-mime default nautilus.desktop inode/directory application/x-gnome-saved-search

from greenlet import greenlet
from time import sleep

def consumer():
    last= ''
    while True:
        receival = pro.switch(last)
        if receival is not None:
            print(f'Consume {receival}')
            last = receival
            sleep(1)


def producer(n):
    con.switch()
    x = 0
    while x < n:
        x += 1
        print(f'Produce {x}')
        last = con.switch(x)

pro = greenlet(producer)
con = greenlet(consumer)
pro.switch(10)

import gevent

def foo():
    print('Running in foo')
    gevent.sleep(0)
    print('Explicit context switch to foo again')

def bar():
    print('Explicit context to bar')
    gevent.sleep(0)
    print('Implicit context switch back to bar')

gevent.joinall([
    gevent.spawn(foo),
    gevent.spawn(bar),
])