Skip to content

gauta-dev/python-assessment

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

python-assessment

The project was built using the latest Python 3.9.7 version

 Command Line 
-customUser
 mysql> show databases;
 
  # select db
 mysql> use python_assessment;
 
 # show all tables
 mysql> show tables;
 
 # show all users
 mysql> Select * from accounts_customuser
 
 # export users to excel
 mysql> Select * from accounts_customuser into outfile  "path\\to\\excel\\document\\file_name.csv" fields terminated by ', '  lines terminated by '\n '; 

-tasks
  mysql> show databases;
  mysql> use python_assessment;
  
  # show all tasks
  mysql> select * from tasks_task;
  
  # update task
  UPDATE tasks_task SET title = 'gym at 05:30' WHERE id = 2;
  
  # delete task
  mysql> DELETE FROM tasks_task  WHERE id = 14;
  
  # specific task
  SELECT  username,FROM tasks_task WHERE id = 1;
  
  # show complete tasks
  mysql> SELECT complete FROM tasks_task WHERE true;
  
  # show deleted tasks
  mysql> SELECT delete FROM tasks_task WHERE true;
  
  "I cant export to excel at the moment due to technical dificalties."

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published