Pytonik is a python framework built to enhance web development fast and easy, also help web developers to build more apps with less codes.
dependabot[bot] on pip
dependabot[bot] on pip
Bump pillow from 7.2.0 to 9.0.1… (compare)
dependabot[bot] on pip
dependabot[bot] on pip
Bump pillow from 7.2.0 to 9.0.0… (compare)
dependabot[bot] on pip
dependabot[bot] on pip
Bump pillow from 7.2.0 to 8.3.2… (compare)
from pytonik import Web
from pytonik.Core import File
from pytonik.Core import Helpers
from pytonik.Functions.validation import validation
m = Web.App()
validate = validation()
file = File
def multiple(Request):
msg = ""
if Request.method == "POST":
upload_dir = upload_dir = Helpers.mvc_dir('public/uploads/file/multiple')
multifileupload = Request.file('uploadfile')
for fileupload in multifileupload:
if fileupload.filename != "":
response = file.upload(fileupload, upload_dir)
if response == True:
msg = "File Upload Successfully "
else:
msg = "Unable to Upload file "
data = {
'title' : 'Upload Controller',
'text': 'Welcome to My pytonik Multiple Upload File Page',
'msg' : msg
}
m.views('multiple', data)
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>{{title}}</title>
</head>
<body>
<h1>{{title}}</h1>
<h2>{{text}}</h2>
<form method="POST" enctype="multipart/form-data" action="{% call url '/upload/multiple' %}">
{{msg}}
<br/>
<div>
<label>Upload File 1</label>
<input type="file" name="uploadfile" id="uploadfile">
</div>
<br/>
<div>
<label>Upload File 2</label>
<input type="file" name="uploadfile" id="uploadfile">
</div>
<br/>
<div>
<label>Upload File 3</label>
<input type="file" name="uploadfile" id="uploadfile">
</div>
<br/>
<div>
<label>Upload File 4</label>
<input type="file" name="uploadfile" id="uploadfile">
</div>
<br/>
<button type="submit" name="submit" id="submit">
Submit Now
</button>
</form>
</body>
</html>
from flatten_json import flatten
import pymysql, os, json
file = 'C:\Users\Optimistic Man\Desktop\Automation\test.json'
json_data=open(file).read()
sample_object2 = json.loads(json_data)
print(type(sample_object2))
flatten = flatten(sample_object2)
columns = ', '.join("" + str(x).replace('/', '_') + "
" for x in flatten.keys())
values = ', '.join("'" + str(x).replace('/', '_') + "'" for x in flatten.values())
sql = "INSERT INTO %s ( %s ) VALUES ( %s );" % ('mytable', columns, values)
print(sql)
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="root",
passwd="abcd+_4321",
database="python_db"
)
mycursor = mydb.cursor()
mycursor.execute("DROP TABLE IF EXISTS mytable")
mycursor.execute("""CREATE TABLE mytable(
device_id VARCHAR(12) NOT NULL PRIMARY KEY
,time VARCHAR(25) NOT NULL
,pm25 INTEGER NOT NULL
,pm10 INTEGER NOT NULL
,pm1 INTEGER NOT NULL
,t NUMERIC(5,2) NOT NULL
,h INTEGER NOT NULL
,co2 INTEGER NOT NULL
,co BIT NOT NULL
,hcho BIT NOT NULL
,tvoc INTEGER NOT NULL
,gps_lat NUMERIC(6,3) NOT NULL
,gps_lon NUMERIC(7,3) NOT NULL
);""")
mycursor.execute(sql, values)
mydb.commit()
print(mycursor.rowcount, "record inserted.")
4import bs4
import urllib.request
import re
import csv
from selenium import webdriver
from selenium.webdriver.common.keys import Keys
from selenium.webdriver.support.ui import WebDriverWait
import time
import os
#hakee sivun
def main():
browser = webdriver.Firefox()
browser.get('https://www.hs.fi/')
#scrollaa sivun hitaasti
y = 1750
for timer in range(0,30):
browser.execute_script("window.scrollTo(0, "+str(y)+")")
y += 1500
time.sleep(1)
time.sleep(5)
source = urllib.request.urlopen('https://www.hs.fi/').read()
soup = bs4.BeautifulSoup(source,'lxml')
artikkelit = soup.findAll('h2')
uutiset=[]