Computer/Python (6) 썸네일형 리스트형 Selenium #installation sudo pip3 install selenium sudo pip3 install xlrd sudo pip3 install pyvirtualdisplay sudo pip3 install selenium xlrd pyvirtualdisplay sudo apt install xvfb sudo apt install chromium-chromedriver sudo apt install xserver-xephyr sudo apt install chromium-chromedriver xvfb xserver-xephyr -y sudo pip3 install bs4 from selenium import webdriver from pyvirtualdisplay import Display from .. SQLite3 import sqlite3 dbpath = "test.db" conn = sqlite3.connect(dbpath) #File creation part try: cur = conn.cursor() cur.execute("CREATE TABLE info (name1 TEXT, name2 INTEGER)") conn.commit() except: print('File is Existing') #Input part cur = conn.cursor() cur.execute("INSERT INTO info (name1, name2) VALUES ('Hello', 57)") conn.commit() cur = conn.cursor() cur.execute("SELECT * FROM info") result = cu.. flask 플라스크 sudo pip3 install Flask sudo apt-get install apache2 sudo apt-get install libapache2-mod-wsgi-py3 sudo apt-get install php sudo nano /var/www/heeseop/run.wsgi import sys sys.path.append("/var/www/heeseop") from heeseop import app as application * from heeseop is CGI sudo nano /etc/apache2/sites-enabled/000-default.conf Options Indexes FollowSymLinks MultiViews AllowOverride None Order allow,deny allow from all Options +ExecCGI AddHandler cgi-script .cgi .py Sqlite3 sudo apt install sqlite3 sudo sqlite3 #without sudo file can not be createdcreate table dbname(textname text, intname int);.tables.databases.exit sudo sqlite3 .open test.db INTEGERINTINTEGERTINYINTSMALLINTMEDIUMINTBIGINTUNSIGNED BIG INTINT2INT8 TEXTCHARACTER(20)VARCHAR(255)VARYING CHARACTER(255)NCHAR(55)NATIVE CHARACTER(70)NVARCHAR(100)TEXTCLOB BLOBBLOB REALREALDOUBLEDOUBLE PRECISIONFLOAT NUMERI.. Python Outline https://docs.python.org/3.8/reference/index.html 이전 1 다음