Month: March 2022

sqlite3

# Create db, table, insert into table, select from table import sqlite3 sql_con = sqlite3.connect('db/test.db') # If db doesn't exist…

datetime

from datetime import datetime now = datetime.now() print(now.strftime("%a")) # Sun print(now.strftime("%A")) # Sunday print(now.strftime("%w")) # 0, 0=sunday, 1=Monday... print(now.strftime("%d")) #…

MySQL

import mysql.connector mydb = mysql.connector.connect( host='192.168.1.10', user='username', password='password', database='database name' ) mycursor = mydb.cursor() #sqlQuery=('SELECT * FROM boyName WHERE id…

*args **kwargs

''' *args return a tuple **kwargs return a dictionary ''' def foo(required, *args, **kwargs): print(required) if args: print(args) if kwargs:…

for loop

my_list = ["Niclas", "Anna", "Lisa", "Glenn", "Malin"] my_list_string = "Python" for n in my_list: print(n) print("") print("--------------") print("") for n…

random()

''' https://docs.python.org/3/library/random.html ''' import random print('') print('-------- Random number between 1 and 6 --------') print('') x = random.randint(1, 6) print(x)…