Archive

Posts Tagged ‘Code’

Python: Shares Speculation System – Part 7

August 18, 2020 Leave a comment


Learning : Python, DataBase, SQL, SQlite3
Subject: Plan, Design and Build a Shares Speculation System

Project Card:
Project Name: Shares Speculation System
By: Ali
Date: 2.7.2020
Version: V01-2.7.2020

In this Part we will write the Function to Delete a Transaction from the System, and will write the last part of show_all_Transaction function.
First we will write a Function to Delete a Transaction, we have two types of Transactions “Buying” and “Selling” so the user will select the Transaction Type to delete.
1. Buying Transaction: If the user select to Delete a Buying Transaction, we will call show_all function to display all the Buying Transactions and the ask the user to Enter the ID of the record to be Deleted. Here is the Code ..

Then we will print-out the Selected Transaction Details and ask the user to Confirm the Deleting action by Entering ‘Y’.
After Confirming we need to perform or to Aplay three parts of code:
1. Deleting the Buying Transaction from Buying Table (buy_t_table).
2. Deleting the Buying Record from the Budget Table.
3. Updating the Share Basket Table (s_basket).
For the “Update the Share Basket Table (s_basket).” we need to Subtract the amount of the shares from the Share Basket.
Here is the code for all three action..



The Same actions will be taken if the user select to Delete a Selling
transaction. So if the user select “2. Selling Transaction:” we will call show_all function to display all the Selling Transactions and the ask the user to Enter the ID of the record to be Deleted and will display the Transaction Details. Here is the Code ..



And will waite for the user to Confirm the Deleting action, then again three blocks of code will Delete and update records in our system, here are the code ..

Now we finish the def del_trans(): Function to Delete a Buying or Selling Transaction and will work on the last part of def show_all_trans (inside = ‘No’, show=’3′): to Show/Display both Buying and Selling Transactions in one table format. To do so First we will RUN two SQL commands to ‘fetchall’ Buying and Selling Transaction… Here is the code ..


# Get All Sell Transactions Order by id desc
c.execute (" select * from sell_t_table where st_id > 0 order by st_id desc") 
show_s_trans = c.fetchall()   
            
# Get All buy Transactions Order by id desc
c.execute (" select * from buy_t_table where bt_id > 0 order by bt_id desc") 
show_b_trans = c.fetchall()    

Then we print-out the Table header as the following line:
print(“\n”,” “*11,”{:<9}{:<13}{:<30}{:<16}{:<11}{:<15}{}".format('ID','Date','Share Name','SAmount','Price','Cost','Income'))
Then using a For loop we will print-out the transactions in same format of the table header .. Here is the full Code

Last thing we will print the Totals of Investment, Incomes and the Net Profit.


print(" "*73,'Total Investment is: {:,}'.format(total_inv)) 
print(" "*76,'Total Incomes is: {:,}'.format(total_inc))  
print(" "*75,"-"*30,"\n"," "*75,'   Net Profit is: {:,} '.format(total_inc - total_inv))




We Done with this Part ..

Coming Up: In the Next post we will write the Function to Edit a Transaction.

[NOTES]
1. Part-1 has no code file.
2. We are applying some basic Validations on some part of the code, and assuming that the user will not enter a messy data.
3. This Application Purpose for Saving Transactions and NOT for Desetion Making and Dose’t Have any type of AI or ML Model to Predict the Prices and/or Giving Sugestions on Buying or Selling Shares.


:: Shares Speculation System ::

Part 1 Part 2 Part 3 Part 4 Part 5
Part 6 Part 7 Part 8



All the code are available ..

To Download my Python code (.py) files Click-Here

 


Follow me on Twitter..

By: Ali Radwani

 

Python: Shares Speculation System – Part 6

August 12, 2020 1 comment


Learning : Python, DataBase, SQL, SQlite3
Subject: Plan, Design and Build a Shares Speculation System

Project Card:
Project Name: Shares Speculation System
By: Ali
Date: 2.7.2020
Version: V01-2.7.2020

In Part-5 we wrote the function to submit the Buying Transactions ..[Click to Read] also we wrote the section of showing/displaying the Buying records on the screen. In this part we will continu on same function to write the code to Save Selling Transaction and display them on the screen in Show all Transactions Function.

So First we will writing the code to Save/Submit Selling Transactions. Now let’s start coding ..

Before we start I want to focus on a one-line If statement that we will use to give the user the ability or the chance to Quit or Exit from the function in any time before saving the Transaction by just entering ‘Q’, here is the code: if s_s_id in [‘Q’,’q’] : return (s_s_id is the user input).

In def sell_share(): function we will display all the Shares Name (by calling show_share() function) on the screen and ask the user to select the ID for the share, then we will Run tow SQL statements to get some data about that share such as it Full Name and the amount of shares we have (from s_basket table), if the return value of the s_basket is None or we Don’t have any shares we can’t do any Sell process so we will Exit. Here is the code ..



If we have shares, then we will print on the screen to show total amount of shares we have and will ask the user to Enter the new selling share information like the Date, The Amount of Selling and the Price, here is the code ..


After that, we will ask the user to CONFIRM Saving by pressing ‘Y’, and will use the SQL Insert statement to submit the data to the Database, also to update the s_basket table…. Here is the code.


Now we finish the def sell_share(): function and will start to writing the corresponding part to show the Selling Transactions in def show_all_trans ():, in this section of the code as we did to show the Buying Transactions we will RUN an SQL statement to get all selling transaction in the table, we will use the formatting to output the data as a table format. Here is the code


Coming Up: In Next part we will Write the Function to Delete Transactions from the System, also will write a code to Show All Transactions Buying and Selling in one Table.


[NOTES]
1. Part-1 has no code file.
2. We are applying some basic Validations on some part of the code, and assuming that the user will not enter a messy data.
3. This Application Purpose for Saving Transactions and NOT for Desetion Making and Dose’t Have any type of AI or ML Model to Predict the Prices and/or Giving Sugestions on Buying or Selling Shares.


:: Shares Speculation System ::

Part 1 Part 2 Part 3 Part 4 Part 5
Part 6



To Download my Python code (.py) files Click-Here




Follow me on Twitter..




By: Ali Radwani




Python: Shares Speculation System – Part 5

August 9, 2020 2 comments


Learning : Python, DataBase, SQL, SQlite3
Subject: Plan, Design and Build a Shares Speculation System

Project Card:
Project Name: Shares Speculation System
By: Ali
Date: 2.7.2020
Version: V01-2.7.2020

In this part we will talk or say will work on two functions, Buying Transactions and Show All Transactions, both are fill in Transactions Managment. But first we will do some changes in our main codes as following:
1. Add New Table to the DataBase named s_basket using this code:
“CREATE TABLE if not exists s_basket (sb_id INTEGER PRIMARY KEY AUTOINCREMENT, sn_id integer, ts_amount float, min_p float, max_p float)”
also we will Insert the zero record as:
c.execute (“INSERT INTO s_basket (sb_id) VALUES(:sb_id)”,{“sb_id”:0})

2. Changing in Main Menu.



[Important Note]: This application Purpose for Saving Transactions and NOT for Desetion Making and dose’t have any type of AI or ML Model to Predict the Prices and/or Giving Sugestions on Buying or Selling Shares.


Transactions Managment: In our previous parts and codes we published, we used two options in the main menu (Buying Transaction, Selling Transaction) in this part we will change this to have one menu option called Transactions Managment this option will take the user to a sub-menu having some other options as shown:

The Main-Menu Code

Out-Put

Transaction Managment Menu


Out-put


Buying Transactions: we will start writing the functions to Insert a Buying Transactions, in this function first we will display a list of Shares we have and the user will select the ID of the share needed, here is the code ..



Now we will use the ID to get the selected share Full-Name and it’s Abbreviation also the amount of shares we have with the lowest and highest price we bought this share before and will display all this information on the screen. Next step is to collect the buying record information to be saved, so we will ask the user to Enter the Date, Share Amount and the Price. With each Data-Entry line we will give the user the ability to terminate the process by Entering ‘Q’, for the date we will use date_validation function. Here is the code for this section..


After that we are ready to Insert the data into the Database, and update other records. Here is the code..

Now we have saved one Buying record, before we continu with Selling Transactions we will write the Show All Transactions this function will display all the records of Buying Transactions and Selling Transactions. Now we will write the section to display the Buying Transaction records. We will call the function def show_all_trans () and we will ask the user to select “What type of Transaction to Show:”
1. Buying Transaction.
2. Selling Transaction.
3. All Transactions.
then we will display the transactions in a table format. In this part we will write the code for the Buying Transaction. Here is the code ..


We Done in this Part ..


Coming Up: In Next part we will write the Function Save Selling Transactions to our system, also updating the Show


[NOTES]
1. Part-1 has no code file.
2. We are applying some basic Validations on some part of the code, and assuming that the user will not enter a messy data.
3. This Application Purpose for Saving Transactions and NOT for Desetion Making and Dose’t Have any type of AI or ML Model to Predict the Prices and/or Giving Sugestions on Buying or Selling Shares.


:: Shares Speculation System ::

Part 1 Part 2 Part 3 Part 4
Part5




All the Codes in this Post Available here ..

To Download my Python code (.py) files Click-Here




Follow me on Twitter..




By: Ali Radwani




Python: Shares Speculation System – Part 4

July 19, 2020 3 comments


Learning : Python, DataBase, SQL, SQlite3
Subject: Plan, Design and Build a Shares Speculation System

Project Card:
Project Name: Shares Speculation System
By: Ali
Date: 2.7.2020
Version: V01-2.7.2020

Last time we worked on Budgets Managment for our system, now before we start Buying and Selling shares we need to create list of shares name so we can select from it, we have a table called shares_name this Table have the following fields :
s_id: as a PRIMARY KEY.
full_name: To hold the full name of the share.
abb_name: To hold the Abbreviation of a share name.
The Share Managment section will have four main Functions to Add, Edit, Delete and Show shares. .. Let’s start with it’s Main Menu ..



First Function we will work on will be to Add New Share to the system, we will call it def add_share(): , we will ask the user to input the Share Full Name and its Abbreviation. With Abbreviation we will apply the .upper() function to convert the user input to Upper-case, and for the Full Name we will will apply this code [“ “.join([word.capitalize() for word in user-input] to upper case each first character of the Name. The we will check if the Share Name exist in the DataBase If not we will add it.

 # Add New Share
def add_share() :
        
    os.system('clear')
    print('\n   ====== Add New Share ======\n\n')
    while True :
            
        abb_name = input("   Enter the Abbreviation Name of the Share.. > ").upper() 
        full_name = " ".join([word.capitalize() for word in input('     Enter the Full Name of the Share.. > ').split(" ")])

        c.execute ("select * from shares_name where full_name ='{}' or abb_name = '{}'".format(full_name, abb_name)) 
        share_exist = c.fetchone ()
        if share_exist[0] > 0 :
            print('\n   It seams that the Share Exist in the Database, Name or Abbreviation CAN NOT be Duplicated.')
            print('   Try another Name. ')
        else :      
            c.execute ("INSERT INTO shares_name (full_name , abb_name)  VALUES(:full_name , :abb_name)",{"full_name":full_name, "abb_name":abb_name}) 
            db_conn.commit()
            
        if input ('\n   Do you want to Enter another Share Name?.  [Y,N]. >  ')  not in ['Y','y']: 
            input ('\n    .... Press any key to  Exit.  ')
            return



After adding shares we want to see them and to make sure if every things are fine, so we will write the show_share function, and it will take one argument as inside with default value = ‘Yes’, if we call the function from inside another function the value will be Yes, otherwise it will be ‘No’. Here is the code ..


Next is Editing Share Name, in this function we will call the show_share (‘Yes’) so the user will select the ID of the Share Name to be Edit, then with each attribute we will ask the user ether to Enter the new Edit of the attribute or to press Enter to keep the exist variable. .. Here is a copy of the code ..


Last Function in this Artical is Delete def delete_share() : again we will call the Shoe function to display all the Shares Name on the screen and let the user to select the one to be Deleted by Entering it’s ID.

 # Delete Function.    
def delete_share() :
    os.system('clear')
    print('\n   ====== Delete a Share  ======\n\n')
    
    print('   Here is a list of Shares we have in the System .. \n')
    show_share('Yes')
    
    del_share = input('\n\n   Enter the ID for the Share Name you want to Delete. [Q to Exit] >  ') 

    if del_share in ['q', 'Q'] :
        input ('\n\n    .... Press any key to  Exit.')
        return    
    elif del_share.isnumeric() :
        if (input ('   Are you SURE you want to DELETE Share ID {} ? [Y,N] >  '.format(del_share))) in ['y','Y'] :   
            c.execute ("delete from shares_name where s_id ={}".format(int(del_share))) 
            db_conn.commit()
            input ('\n    ....One Record DELETED. Press any key to  Exit.')
            return
        else :
            input ('\n    ....Share will NOT be Deleted. Press any key to  Exit.')
            return
    else :
        input ('\n    ....Invalid Inpout. Press any key to  Exit.')
        return



Now we can create or Enter a Budget and Enter the Shares Name we have in our Stock Market and we are ready to write the functions to make the transactions.


Coming Up: In Next part we will write the Function to submit/Save Buying and Selling Transactions to our system.


[NOTES]
1. Part-1 has no code file.
2. We are applying some basic Validations on some part of the code, and assuming that the user will not enter a messy data.


:: Shares Speculation System ::

Part 1 Part 2 Part 3 Part 4
Part5



To Download my Python code (.py) files Click-Here




Follow me on Twitter..




By: Ali Radwani




Python: Shares Speculation System – Part 2

July 12, 2020 5 comments


Learning : Python, DataBase, SQL, SQlite3
Subject: Plan, Design and Build a Shares Speculation System

Project Card:
Project Name: Shares Speculation System
By: Ali
Date: 2.7.2020
Version: V01-2.7.2020

In this part we will set the database connection, create the Tables and Insert the Zero records. So first let’s do the Import and the database connection..

# Database connection

import sqlite3, os 

# Create the data-base and name it as Share_S_System. 
db_conn = sqlite3.connect ("Share_S_System.db") 

# Set the connection. 
c = db_conn.cursor() 


Now we will write the function to creates the Tables, we have five tables and this could be change during the project.

# Code to create the Tables

def create_tables_() :
    # to create tables. 
    sql_share_t =    "CREATE TABLE if not exists shares_name  (s_id INTEGER PRIMARY KEY AUTOINCREMENT, full_name text, abb_name text )" 
        
    sql_buy_t_t =   "CREATE TABLE if not exists buy_t_table (bt_id INTEGER PRIMARY KEY AUTOINCREMENT ,buy_date text, sn_id integer, buy_amount integer, buy_price float, cost float)" 
    
    sql_sell_t_t  = "CREATE TABLE if not exists sell_t_table (st_id INTEGER PRIMARY KEY AUTOINCREMENT, sell_date text, sn_id integer, sell_amount integer, sell_price float, profit float)" 
 
    sql_budget_t  = "CREATE TABLE if not exists budget_t (bud_id INTEGER PRIMARY KEY AUTOINCREMENT, bud_date text, bud_amount float, bud_note text )"  

    sql_year_roi =  "CREATE TABLE if not exists year_roi (y_id INTEGER PRIMARY KEY AUTOINCREMENT, bud_amount float, profits float, costs float, roi float, t_buy float, t_sell float )"

    c.execute(sql_share_t) 
    db_conn.commit() 
    c.execute(sql_buy_t_t) 
    db_conn.commit() 
    c.execute(sql_sell_t_t)
    db_conn.commit()        
    c.execute(sql_budget_t) 
    db_conn.commit() 
    c.execute(sql_year_roi) 
    db_conn.commit()  

    input('\n .. Shares Speculation System Tables created.. Press any key .. ') 


Next we will Insert a ‘Zero’ records in the Tables, this weill set the ID’s field in each table to ‘0’ so with next records the AUTOINCREMENT will work as it should. here is the code ..


Last function in this part will be the Main-Menu of the system. The system will have five Menus each one will have it’s own page and functions to manage it, we will write all the needed functions. Here is the Main-Menu.


Coming Up: In Next part we will write the menu and the functions for the Budget Managment.

[NOTES]
1. Part-1 has no code file.


:: Shares Speculation System ::

Part 1 Part 2 Part 3 Part 4



To Download my Python code (.py) files Click-Here




Follow me on Twitter..




By: Ali Radwani




Python: Library Managment System -P6



Learning : Python, DataBase, SQlite
Subject: Create Simple Library Managment System

This will be the last post of Library Managment System, and we will start another project. So in this last part, we will write a final function to get some statistics & summaries about our Library such as :

  • Number of book in the library
  • Books without classifications
  • Books without Author
  • Books without ISBN
  • Books under each classification
  • Statistics about Authors
  • Statistics about Classifications

so we will add the function name in the Main Menu (in this case will take number 5), here is a screen shot of the menu.



So we will write some SQL commands using (SQlite), we will start with Books statistics and will NOT cover all commands, but all will be in the course code file in the Download page.

#Total Books in the Library
    c.execute ("select count() from books where b_id > 0") 
    books_count = c.fetchone()

 # Books without classifications

    c.execute ("select b_id from b_class where b_class_id > 0") 
    books_no_class = [item[0] for item in c.fetchall()]    


 # Authors without emails

    c.execute ("select count() from authors where a_email='' and a_id > 0") 
    auth_no_email = c.fetchall()


 # Authors without Social Media Account
 
    c.execute ("select a_id from sma where sma_id > 0") 
    sma_aid = c.fetchall()       
    a_in_sma = lambda sma_aid: [sma_id for each in sma_aid for sma_id in each]
    a_with_sma = list(dict.fromkeys(a_in_sma(sma_aid)))
    print('     Total Authors without Social Media Accounts: ',(auth_count[0] - len(a_with_sma)))  



Here is the run-time for sample data ..




By this point I will stop working on the “Library Managment System“, the goal of this series of articles was to build a Fast, Simple, Personal system. We did NOT cover some important issues like Validations or Exporting the data.



Enhancment:
Here are some points we can incluod in Version 02 of the LMS Application.

  1. Validations: We need to make sure the user Entering in right and good format as we expect. [Date format, Emails, ISBN and So-On]

  2. User Deletign: This is very Important, so if the user Deletes a Classification or Books or Authors we MUST do some modifications on other tables in the DataBase. [Very High Priority]

  3. Capitalization: To make sure we capitalize all user inputs like first character in each Names [Books name, Authors .. So-On].

  4. Search: Although we have this option in our Main-Menu, but I will not cover it in this Version due to time consumption.

  5. Date Export: This is an extra option we may have to Export the Data as Excel or DB-Backup file.
  6. Multi Libraries: In family using of the system, we can insert Books of other family members (Father Home Library, Brother or Cousin). So in that case we need a Full set of Functions to manage this part.
  7. .


[ NOTE ]
1. I am using Galaxy Tab and QPython3 App.
2. All the above codes are available in the Download Section/Page under the project name.
3. The application codes, Functions, Menus and other parts of the Application are subject of changes. In case of changes I will mention that.
4. This is a simple personal Library application, so I did not use any validations on Data Entry.

:: Library Managment System ::

Part 1 Part 2 Part 3 Part 4
Part 5 Part 6


To Download my Python code (.py) files Click-Here




Follow me on Twitter..

By: Ali Radwani

Python: Library Managment System -P5

July 1, 2020 1 comment

Learning : Python, DataBase, SQlite
Subject: Create Simple Library Managment System

In this Part we will work on Books Managment Functions, New Book, Edit, Delete and Show Books. First, I want to mention that I did some modifications on:

  • Authors Functions:
    Update on show_Author, Edit_author, Delete_author and new_authors.
  • Classifications Functions:
    Update on Show_classification, Edit Classification, Delete Classification.

When I start writing the code for Adding New Book after that the code for Editing a Book, I notes that both are complex and going back or calling other functions such as show_authors, show_classification, I fond that we need to do some modifications on those functions, for all that I will not cover all codes in New and Edit functions. All the code IS available in the Download Page.

So lets start here with the easy functions, First we will see the show_book, in calling this function we will pass two parameters alone, list_type as def show_books(alone=’Yes’, list_type = “D”) both has default values.
alone: alone will be ‘No’ if we call the function within another function.
list_type: will have ‘D’ for Detail list of Book, list with Author data and Classifications. ‘T’ for Books list ID and Title only.
Here is the code ..

 # show books with two parameters

     
def show_books(alone='Yes', list_type = "D") : 
        
    c.execute ("select * from books where b_id > 0  order by b_name")     
    books_list = c.fetchall()           
    if list_type =="D":
        os.system('clear')
        print('\n   ====== Show Books ======')
        print('\n   The List of Books We Have, Sorted by Book Title\n') 
    
        for book in range (0,(len(books_list))):
           try: 
               print('\n             ID: {}'.format(books_list[book][0])) 
               print('     Name/Title: {}'.format(books_list[book][1]))
               print('      Book ISBN: {}'.format(books_list[book][3]))
               print('   Publish Date: {}'.format(books_list[book][4])) 
               print('   Book Edition: {}'.format(books_list[book][5]))
               
               # To get the Book Classification. 
               c.execute ("select class_name from classifi_list INNER JOIN b_class ON (classifi_list.class_l_id = b_class.class_id) AND (b_class.b_id ={})".format(books_list[book][0]))     
               b_class_list = c.fetchall()
               print('\n   Book Classification:')
               try:
                   for i in range(0,len(b_class_list),5) :
                       print(' '*15,b_class_list[i][0], end ="")
                       print(' | ',b_class_list[i+1][0], end ="")
                       print(' | ',b_class_list[i+2][0], end ="")
                       print(' | ',b_class_list[i+3][0])    
               except:
                   pass 
                                  
               auth_id = books_list[book][2]
               # To get the Author Data. 
               c.execute ("select * from authors where a_id = {}".format(int(auth_id)))     
               auth_list = c.fetchone()
           
               # To get the Author's Social Media Accounts. 
               c.execute ("select * from sma where a_id = {}".format(auth_id))  
               sma_list = c.fetchall()  
           
               # To print-out Author Data.
               print('\n\n   The Book Author:')
               print('           Name: {}'.format(auth_list[1]))
               print('          Email: {}'.format(auth_list[2]))
               print('          Social Media:')
               
               # Here we list the SMA for the Author.
               for each in sma_list :  
                  print('{:<14}{:<13} [ {} ]'.format('',each[2],each[3]))
               print('-'*50)           
           except:
               pass     
   
        input('\n\n         ... Press any Key ..') 
        return

    if list_type == "T" :
        print('\n')
        for book in range (0,(len(books_list)),4):
            try: 
                print('    {:<3}{:<27}'.format(books_list[book][0],books_list[book][1]),end="")
                print('{:<3}{:<27}'.format(books_list[book+1][0],books_list[book+1][1]),end="")
                print('{:<3}{:<27}'.format(books_list[book+2][0],books_list[book+2][1]),end="")
                print('{:<3}{:<27}'.format(books_list[book+3][0],books_list[book+3][1]))           
            
            #Exception for index out of range error.
            except:
                pass
        if alone =='Yes' :         
            input('\n\n         ... Press any Key ..')
            return 
        else : return    
    


Now the Delete Function, this is easy one, we just print print-out all the Book and the user will Select the one to be delete by Entaring it’s ID. To list the Books we will call the show_book function as here: show_books(‘No’,’T’) so parameter alone=’No’ and parameter list_type =’T’. Here is the code ..

 # Function to Delete a Book

def delete_book () :

    os.system('clear')
    print('\n   ====== Delete a Book ======')
    print('\n   The List of Books We Have, Sorted by Book Title\n') 
  
    # First we show all Bookd so the user can select the One to be Deleted.
    # we Call show_books function and pass 'T'. 
    show_books('No','T')  
          
    del_book = input('\n\n   Entert the Book ID that you want to Delete: [Q to Exit]  >  ') 
    if del_book not in ['q','Q'] :
        try: 
            c.execute ("select b_name from books where b_id = {}".format(int(del_book)))     
            d_b_name = c.fetchone() 
            
            if input('\n   Are you Sure you want to Delete Book "{}"? [Y,N].  >   '.format(d_b_name[0])) in ['Y','y'] :             
                c.execute ("delete from books where b_id = {} ".format(int(del_book)))
                db_conn.commit()
                input('\n   One Book has been Deleted... Press any Key > ')    
    
            else:
                print('\n   You Select NOT To Delete The Book "{}" . '.format(d_b_name[0]))
                input('\n   To Exit ... Press any key ..') 
        except:    
            input('\n   Not valid .. ')


Now lit’s start with Adding New Book to the Library System. In this process we will Enter New Book Name/Title, Book ISBN, Book Publish Date, Book Edition, and select an Author from the Authors List and if the Author is not exist we can Enter New Author, also to select a Classification and if we want we can Enter a new Classification.[If the one we want is not in the list]. As we can see in the Adding New Book we will call other functions to Show Authors then to Add new Author [If the one we have not on the list] also we will call the Show Classifications to select from and we may need to Add New classification.

The Editing the Books was really challenging, Showing all the the Books on the screen so the user will select the one to be edited, then once finished editing the Book attributes we will ask if the user want to edit the Author information if (YES) again will go through all Author attribute and ask if each one need to be Edit, IF the Author is not in the Authors list we will take the user to Add new Author to the system (if want to), after that we will ask if the user want to edit the classifications of the Book and if the classificatio is not in the list we will call the new_classification function.
Here are screen shot of the functions. ..

Part of Add New Book..
Part of Editing the Book.



What’s Next:
1. I will go through the code Run-Time tring to fix any errors.
2. I will write function for simple statistics on the Library.


[ NOTE ]
1. I am using Galaxy Tab and QPython3 App.
2. All the above codes are available in the Download Section/Page under the project name.
3. The application codes, Functions, Menus and other parts of the Application are subject of changes. In case of changes I will mention that.
4. This is a simple personal Library application, so i did not use any validations on Data Entry.

:: Library Managment System ::

Part 1 Part 2 Part 3 Part 4
Part 5


To Download my Python code (.py) files Click-Here




Follow me on Twitter..

By: Ali Radwani

Python: Library Managment System -P4

June 21, 2020 2 comments


Learning : Python, DataBase, SQlite
Subject: Create Simple Library Managment System

In this Part we will work on Functions to Manage the Authors of the Books. We can enter the Authors in two ways, Even with Entering the book; such as when we are entering a New Book we can Select an Author from the list or (if the Author is not exist) we can select to Enter New Author. Or from the Author menu we can Enter New Author.

Here we are working on the Author Managment, and we will write the codes to:
Add New Authors.
Edit an Author.
Delete an Author.
Show Authors.

Here is the Author Menu with Functions Names..


We will start with Add New Author: In this Function we will ask the user to enter the Author Name then if the Author has Email or any Social Media Account, then the informations will be saved. Here is the code ..

# Authors Menu

def new_authors() :
    while True  :
        os.system('clear')
        print('\n   ====== Add New Authors ======') 
    
        author_name = input('\n   Enter the Author Name .. >  ').capitalize()
        author_email = input('   Enter the Author Email [Enter to be Empty].. >  ')

        c.execute ("select * from authors where a_name='{}'".format(author_name)) 
        result = c.fetchone()     
                 
        if (result != None) : 
             print('\n   We already have [{}] in the Auther Database. '.format(class_name)) 
        else:    
                c.execute ("INSERT INTO authors (a_name, a_email) VALUES(:a_name,:a_email)",{"a_name":author_name,"a_email":author_email})
                db_conn.commit() 
                print('\n      One Author Added ... ') 
                
                while True :
                    if input('\n   Do you want to Add any Social Media Account to this Author? [Y,N] .. >  ') in ['Y','y']: 
                        c.execute ("select max(a_id) from authors") 
                        auth_id = c.fetchone() 
                        sma_name = input('\n   Enter the Social Media Name.. > ').capitalize()
                        sma_link = input('   Enter the Social Media Link.. > ')
                        c.execute ("INSERT INTO sma (sma_name,sma_link,a_id) VALUES(:sma_name,:sma_link,:a_id)",{"sma_name":sma_name,"sma_link":sma_link,"a_id":auth_id[0]}) 
                        db_conn.commit() 
                    else:
                        break 

        if input('\n\n   Do you want to Add Another Author? [Y,N].. >  ') in ['N','n'] :
             input('\n   To Exit ... Press any key ..') 
             return


Now the Next function, Edit an Author information, here we will list down all the Authors Names and ID and the user will Enter the ID of the one to be Edited, then we will display each attribute and ask the user to Edited or just press Enter (leave it Empty) to keep the exist one. Also we will give the user the ability to Enter a new Social Media Account for the user if needed.

# Edit Author Function


def edit_authors() :
   
    os.system('clear')
    print('\n   ====== Edit Authors ======') 
    print('   The List of Authors We Have, Sorted in Alphbatic\n') 
    c.execute ("select * from authors where a_id > 0  order by a_name")     
    auth_list = c.fetchall() 
    
    # First we show all Authors so the user can select the One to be Edited.
    for auth in range (0,(len(auth_list)-1),4):
       try: 
           print('{:<3}{:<20}'.format(auth_list[auth][0],auth_list[auth][1]),end="")
           print('{:<3}{:<20}'.format(auth_list[auth+1][0],auth_list[auth+1][1]),end="")
           print('{:<3}{:<20}'.format(auth_list[auth+2][0],auth_list[auth+2][1]),end="")
           print('{:<3}{:<20}'.format(auth_list[auth+3][0],auth_list[auth+3][1]))
           
       except:
           pass # Just to avoid Index out of range.    


    edit_auth = input('\n\n   Enter the ID of the Author to Edit. [Q to Exit]  >  ')
    if edit_auth not in ['q','Q'] :
        try:
            c.execute ("select * from authors where a_id = {} ".format(int(edit_auth)))     
            auth_edi = c.fetchall()  
            # Get the Author Social Media Accounts SMA. 
            c.execute ("select * from sma where a_id = {}".format(int(edit_auth)))  
            sma_list = c.fetchall()
            print('         ID:',auth_edi[0][0])
            print('       Name:',auth_edi[0][1])
            print('      Email:',auth_edi[0][2])
            print('     Social Media:')
            for each in sma_list :  
                print('{:<11}{:  ').capitalize()
            a_email = input('   Enter the Author Email.  >  ') 
            if a_name > "" :
                c.execute("update authors set a_name = '{}' where a_id = {}".format(a_name,int(edit_auth))) 
                db_conn.commit() 
            if a_email > "" :      
                c.execute("update authors set a_email = '{}' where a_id = {}".format(a_email,int(edit_auth))) 
                db_conn.commit()      
            
            if (sma_list) != "" :
                for each in sma_list :  
                    sma_l = input('   Enter the {} Account. [D to Delete the Account]  >  '.format(each[2])) 
                    if sma_l > "" and (sma_l not in ['d','D'] ):
                        c.execute("update sma set sma_link = '{}' where a_id = {} and sma_name = '{}'".format(sma_l,int(edit_auth),each[2])) 
                        db_conn.commit() 
                    # If the user select D to Delete the SMA account. 
                    elif sma_l > "" and (sma_l in ['d','D']) :
                        c.execute ("delete from sma where sma_id = '{}' ".format(each[0]))
                        db_conn.commit()
                        print('   {} Account Deleted... '.format(each[2]))

            while True :
                    # If the user want to Add more SMA to the Author.
                    if input('\n   Do you want to Add any Social Media Account to this Author? [Y,N] .. >  ') in ['Y','y']: 
                        sma_name = input('\n   Enter the Social Media Name.. >  ').capitalize()
                        sma_link = input('   Enter the Social Media Link.. >  ')
                        c.execute ("INSERT INTO sma (sma_name,sma_link,a_id) VALUES(:sma_name,:sma_link,:a_id)",{"sma_name":sma_name,"sma_link":sma_link,"a_id":int(edit_auth)}) 
                        db_conn.commit() 
                    else:
                        break
                  
        except:
            
           print('\n   Not valid .. ')
    input('\n   To Exit ... Press any key ..')
    return



When running the code, we need to go back and forth to Show_Author function to see the effect of the Adding, Editing or Deleting functions that we are working one. Now, we will write the Delete_author Function, and as the Edit one first we will list all the Authors on the screen with there ID’s and ask the user to Enter the ID for the one to be Deleted. .. Here is the code.

# Delete an Author


def delete_authors():
    os.system('clear')
    print('\n   ====== Delete Authors ======') 
    print('   The List of Authors We Have, Sorted in Alphbatic\n') 
    c.execute ("select * from authors where a_id > 0  order by a_name")     
    auth_list = c.fetchall() 
    
    # First we show all Authors so the user can select the One to be Deleted.
    for auth in range (0,(len(auth_list)-1),4):
       try: 
           print('{:<3}{:<20}'.format(auth_list[auth][0],auth_list[auth][1]),end="")
           print('{:<3}{:<20}'.format(auth_list[auth+1][0],auth_list[auth+1][1]),end="")
           print('{:<3}{:<20}'.format(auth_list[auth+2][0],auth_list[auth+2][1]),end="")
           print('{:<3}{:  '))
    if del_auth not in ['q','Q'] :
        try:
            c.execute ("select * from authors where a_id = {} ".format(int(del_auth)))     
            auth_det = c.fetchall() 

            print('         ID:',auth_det[0][0])
            print('       Name:',auth_det[0][1])
            print('      Email:',auth_det[0][2])

            if input('\n     Are you Sure you want to Delete this Author? [Y,N].  >   ') in ['Y','y'] :
        
                c.execute ("delete from authors where a_id = '{}' ".format(int(del_auth)))
                db_conn.commit()  
                # To delete any SMA linked to this Author.
                c.execute ("delete from sma where a_id = '{}' ".format(int(del_auth)))
                db_conn.commit()
                input('\n   One Author has been Deleted... Press any Key > ')    
             
            else:
                print('\n   You Select NOT To Delete Author "{}" . '.format(auth_det[0][1]))
                input('\n   To Exit ... Press any key ..') 
        except:
            input('\n   Not valid .. ')
    return



Last Function in this part is Show Authors information, this is easy and short code, we will list down on the screen all the Authors Name, Email, SMA sorted by the Authors Name. Here is the code..

# Function to Show All Authors

def show_authors() :
    os.system('clear')
    print('\n   ====== Show Authors ======')
    print('   The List of Authors We Have, Sorted in Alphbatic\n') 
    c.execute ("select * from authors where a_id > 0  order by a_name")     
    auth_list = c.fetchall()           
    for auth in range (0,(len(auth_list))):
       try: 
           # For each Author we fetch the Social Media Accounts. 
           c.execute ("select * from sma where a_id = {}".format(auth_list[auth][0]))  
           sma_list = c.fetchall()
           print('\n     ID: {}'.format(auth_list[auth][0])) 
           print('   Name: {}'.format(auth_list[auth][1]))
           print('  Email: {}'.format(auth_list[auth][2]))
           print('  Social Media:')
           # Here we print-out the SMA for the Author.
           for each in sma_list :  
              print('{:<11}{:<13} [ {} ]'.format('',each[2],each[3]))
           print('-'*50)           
       except:
           pass     
    
    input('\n\n         ... Press any Key ..')           



Next We will work on Book Managment Menu to Add, Edit, Delete and Show Books in our Library.

[ NOTE ]
1. I am using Galaxy Tab and QPython3 App.
2. All the above codes are available in the Download Section/Page under the project name.
3. The application codes, Functions, Menus and other parts of the Application are subject of changes. In case of changes I will mention that.


:: Library Managment System ::

Part 1 Part 2 Part 3 Part 4

To Download my Python code (.py) files Click-Here




Follow me on Twitter..




By: Ali Radwani




Python: Library Managment System -P3

June 18, 2020 4 comments


Learning : Python, DataBase, SQlite
Subject: Create Simple Library Managment System

In this Part we will work on Classification Managment. As we know each book can fall in one or more subject or say ‘Classification’ then we can search for a book by it’s class, example of this, we may have classifications like: cook, computer, Health, History; also a book can have more than one classifications such as one book we gave it cook and sweet .. and so-on.

To do this we add another table to the project to hold all the Classifications and manage them. Here is the code ..

# New Table to be added.

sql_class  = "CREATE TABLE if not exists classifi_list (class_id INTEGER PRIMARY KEY AUTOINCREMENT, class_name text )"  
c.execute(sql_class)
db_conn.commit()
        
c.execute ("INSERT INTO classifi_list (class_id) VALUES(:class_id)",{"class_id":0})
db_conn.commit()

[NOTE: This code been added to the source file.]

Classification Managment: In Classification Managment we will have four Functions, and will write the codes to perform each function, also we will write the Menu Function to let the user select a function. Functions are:

1. Add New Classification.
2. Edit a Classification information.
3. Delete a Classification.
4. Show Classifications.

First: Here is the class_menu() Function, the user will have the prompt and asked to select an action or (9) to Exit.

# Classification Managment Fumction    
def class_menu(): 

    while True : 
        os.system('clear')
        print('\n   ====== LMS - Classification Managment ======')
        print('    1. Add New Classification.')
        print('    2. Edit a Classification information.')
        print('    3. Delete a Classification.') 
        print('    4. Show Classifications')
        print('    9. Exit.')
            
        user_choice = input('\n   Select the Action you want from the Menu: ')
        
        if  user_choice == '1' :
            # Function to Add New Classification   
            new_classification()

        elif user_choice == '2' : 
            # Function to Edit a Classification information.
            edit_classification()
  
        elif user_choice == '3' : 
            # Function to Delete a Classification.
            delete_classification()  

        elif user_choice == '4' : 
            # Function to Show a Classification.
            show_classification()  

        elif user_choice == '9' : 
            return 



Now, let’s start with Add New Classification. Simply we will ask the user to write a classification to be added to the Database, then we will check if it is already available in our Database, If yes then we will till the user so, or (if not available) we will add it, and will give the user the chance to add another one. If the user enter (Q or q) then we exit (Quit) from the function and return to the previous Menu.

# Function to Add New Classification

def new_classification() :
    os.system('clear')
    print('\n   ====== Add New Classification ======')  
    while True  :
        class_name = input('\n   Enter the Classification and Press Enter. [ To Exit Enter Q ].. >  ').capitalize()
        
        c.execute ("select * from classifi_list where class_name='{}'".format(class_name)) 
        result = c.fetchone()     
        if class_name not in ['q','Q']:  
            if (result != None) : 
                print('\n   We already have [{}] in the Classification Database. '.format(class_name)) 
            else:    
                c.execute ("INSERT INTO classifi_list (class_name) VALUES(:class_name)",{"class_name":class_name})
                db_conn.commit() 
                print('\n      One Classification Added ... ')
        else:
            input('\n   To Exit ... Press any key ..') 
            return
The Code
Code, Run-Time


Another Function to work on is Edit a Classification information In this one we will print-out all the Classifications we have and the user will select the one to Edit and will asked to Enter the ID number next to it. Then to Enter the New One and we will save it. Here is the code and the Out-put screen shot. To display all classifications on the screen we will use this code..

# Code to display the classifications on the screen

# First we list down all classifications.
    c.execute ("select * from classifi_list where class_id > 0  order by class_name")     
    class_list = c.fetchall()           
    for cla in range (0,(len(class_list)-1),4):
       try: 
           print('{:<3}{:<20}'.format(class_list[cla][0],class_list[cla][1]),end="")
           print('{:<3}{:<20}'.format(class_list[cla+1][0],class_list[cla+1][1]),end="")
           print('{:<3}{:<20}'.format(class_list[cla+2][0],class_list[cla+2][1]),end="")
           print('{:<3}{:<20}'.format(class_list[cla+3][0],class_list[cla+3][1]))
           
       except:
           pass 

[NOTE: We use the try: except to avoid any (index out of range) errors.]

Code
Code, Run-time



Next we will work on the Delete a Classification, Deleting may effect on some Books that uses that classification, so we need to till the user to confirm Deleting. Also we will use the same code to list down all the classifications and ask the user to enter the ID of the one to-be Deleted. Here is a part of the code to Delete a classification..

# Part of the code .. 

del_class = input('\n\n   To Delete a Classification Enter it''s ID number [Q To Exit]  > ')

if del_class not in ['Q','q'] :
    c.execute ("select * from classifi_list where class_id = '{}' ".format(int(del_class))) 
    c_to_del =  c.fetchone()[1]     
    print('\n   Are you sure you want to Delete "{}" Classification? '.format(c_to_del))     
    print('   This action may effect on books has this Classification.') 
    user_approve = input('\n   If you are sure to Delete "{}" Press Y or N: > '.format(c_to_del))  
    if user_approve in ['y','Y'] : 
        c.execute ("delete from classifi_list where class_id = '{}' ".format(del_class))
        db_conn.commit() 
        input('\n   One Classification has been Deleted... Press any Key > ')    
    else: 
        input('\n\n   You Select NOT to Delete the "{}" Classification, Press any key to go back.. '.format(c_to_del))

    if input('\n   Do you Want to Delete Another Classification? [Y,N] > ') in ['n','N'] :
         return 
else:
    input('\n   You Select to Exit .. Press any Key > ')
    return   
    
The Code Code Run-Time



Last Function to work in this post is Show Classifications the function we will list down all the Classifications on the screen. Very easy one, here it is

# Show Classification Function

def show_classification():      
    os.system('clear')
    print('\n   ====== Show Classification ======')
    print('   The List of Classifications We Have, Sort in Alphbatic\n') 
    c.execute ("select * from classifi_list where class_id > 0  order by class_name")     
    class_list = c.fetchall()           
    for cla in range (0,(len(class_list)-1),4):
       try: 
           print('{:<3}{:<20}'.format(class_list[cla][0],class_list[cla][1]),end="")
           print('{:<3}{:<20}'.format(class_list[cla+1][0],class_list[cla+1][1]),end="")
           print('{:<3}{:<20}'.format(class_list[cla+2][0],class_list[cla+2][1]),end="")
           print('{:<3}{:<20}'.format(class_list[cla+3][0],class_list[cla+3][1]))
           
       except:
           # just in case error, pass and do nothing.
           pass        
    input('\n\n         ... Press any Key ..') 
Code
Code Run-time




What’s Coming In coming post, we will write the Functions to Manage the Authors.

[ NOTE ]
1. I am using Galaxy Tab and QPython3 App.
2. All the above codes are available in the Download Section/Page under the project name.
3. The application codes, Functions, Menus and other parts of the Application are subject of changes. In case of changes I will mention that.




:: Library Managment System ::

Part 1 Part 2 Part 3

To Download my Python code (.py) files Click-Here




Follow me on Twitter..




By: Ali Radwani




Python: Library Managment System -P2

June 16, 2020 5 comments


Learning : Python, DataBase, SQlite
Subject: Create Simple Library Managment System

The Data: In the Part-1 we Talk about the Entities that we will create and about the Data we will collect (Fields). So here we are writing them again and we will add classification for each book :
Books Entity: Book Name, Book Author, Date of publish, Edition Number, Book classification number.
Author Entity : Author name, Author Nationality, email, SMA (social media account).
From the Author information we can see that we need to define a new Entity to hold the SMA.
SMA Entity: SMA Name, SMA Link.
Class Entity: class Name.
Here is each entity and field :
book:

  • b_id integer PK
  • b_name text,
  • b_a_id integer,
  • b_isbn text,
  • b_dop text,
  • b_ed integer

author:

  • a_id integer PK
  • a_name text
  • a_email text

sma:

  • sma_id integer PK,
  • a_id integer,
  • sma_name text,
  • sma_link text

class:

  • class_id integer PK
  • class_name text
  • Now we will write the code to create the Database and set a connection

    # create the Database and set a connection

    import sqlite3, os

    # Create the data-base & name it as LMS.
    db_conn = sqlite3.connect ("LMS.db")

    # set the connection.
    c = db_conn.cursor()

    Now we will create the tables..

    # Function to create the tables

    def create_tables_() :
    # to create tables.
    sql_books = "CREATE TABLE if not exists books (b_id INTEGER PRIMARY KEY AUTOINCREMENT, b_name text, b_a_id integer,b_isbn text, b_dop text, b_ed integer)"

    sql_author = "CREATE TABLE if not exists author (a_id INTEGER PRIMARY KEY AUTOINCREMENT ,a_ name text, a_email text )"

    sql_class = "CREATE TABLE if not exists classifi_list (class_id INTEGER PRIMARY KEY AUTOINCREMENT, class_name text )"



    sql_b_class = "CREATE TABLE if not exists b_class (b_class_id INTEGER PRIMARY KEY AUTOINCREMENT, b_id integer, class_id integer )"

    sql_sma = "CREATE TABLE if not exists sma (sma_id INTEGER PRIMARY KEY AUTOINCREMENT, a_id integer,sma_name text, sma_link text)"


    c.execute(sql_books)
    db_conn.commit()

    c.execute(sql_author)
    db_conn.commit()

    c.execute(sql_class)
    db_conn.commit()


    c.execute(sql_b_class)
    db_conn.commit()

    c.execute(sql_sma)
    db_conn.commit()

    input('\n .. LMS Tables created.. Press any key .. ')

    After creating the tables, and to make sure that AUTOINCREMENT of Primary key will run we need to have a number in each PK field, to do that we will add a 0 (Zero) record to each table. Here is the code to do it ..

    #Function to Insert the Zero Record

    #Function to Insert the Zero Record.
    def insert_record_0():

    c.execute ("INSERT INTO books (b_id) VALUES(:b_id)",{"b_id":0})
    c.execute ("INSERT INTO authors (a_id) VALUES(:a_id)",{"a_id":0})
    c.execute ("INSERT INTO classifi_list (class_id) VALUES(:class_id)",{"class_id":0})

    c.execute ("INSERT INTO b_class (class_id) VALUES(:class_id)",{"class_id":0})
    c.execute ("INSERT INTO sma (sma_id) VALUES(:sma_id)",{"sma_id":0})

    db_conn.commit()

    input('\n ...Dummy records been Inserted .... Press any key .. ')

    The above functions create_tables_() and insert_record_0() will be run only one time to create the tables, and insert record number ZERO. During the programming and coding we may need to delete the DataBase and re-created again, in that case we run the both functions again.

    Create the Menus
    As we side, each Entities will have three Main Functions [Add, Edit, delete ad search]. Let’s start with Main Menu.

    Main Menu Code
    Main Menu Run-Time
    Book Menu, Code
    Book Menu, Run-Time
    Author Menu, Code
    Author Menu, Run-Time
    Classification Menu, Code
    Classification Menu, Run-Time
    Search Menu, Code Search Menu, Run-Time

    What’s Coming In coming post, we will write the Functions to Manage the Authors and Classifications.

    [ NOTE ]
    1. I am using Galaxy Tab and QPython3 App.
    2. All the above codes are available in the download section/page under the project name.
    3. During the progress of the project, we may need to Add, Edit or delete any Tables, Fields, Menus or Functions that we had already finished.

    :: Library Managment System ::


    Part 1 Part 2

    To Download my Python code (.py) files Click-Here


Follow me on Twitter..


By: Ali Radwani