Skip to content

This is the Python project.Mobile Device database engine implemented in python using in memory database.

Notifications You must be signed in to change notification settings

nvnvenki/1PI10CS-50-62-32

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

45 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Mobile Device database engine.

This is the Python project , done as a part of python elective course.

Begining stage of the project


commands:(for commandline with inmemory database)
  • save - to load the data to the database
  • query - to query the database
  • close - to close the connection with the server

Query format:


      <li> SELECT mobiles FROM 'company' WITH 'features' </li>
      <li>conditions: </li>
      	<li><ul>
         <li> Companies can be any company.To search in all the companies give company name as 'all'</li>
         <li> Features must be specified as follows \n \t feature operator value</li>
         <li> WITH clause is mandatory</li>
         <li>To get multiple the info of mobile with two or more features seperate each feature with an 'AND'</li>
         <li> Operators supported : '=', '&lt;', '&gt;'</li>
        <li>features list <ul>
    				<li> operatingsystem</li>
    				<li>price</li>
    				<li> frontcamera</li>
    				<li> rearcamera</li>
    				<li> model</li>
    				<li> thickness</li>
    				<li> talktime</li>
    				<li> GPS </li>
    				<li> type</li>
    				</ul></li>
    	</ul></li>			
    </ul>
    <p>To check for the existence give 00mp for camera specifications
    Example query:
    Say a user wants to get the info of samsung mobiles with windows os and price less than 
    	<br>10000Rs and with GPS and with rearcamera
     The query will be
    	
    	 SELECT mobiles FROM Samsung WITH operatingsystem = windows and cost &lt; 10000
    	<br>AND GPS = yes AND rearcamera &gt; 0 
    <p> 
    	<h4>Later stages of the project</h4>
    	<hr>
    	<ul>
    		
    		<li>The inmemory database is organised according to company names : each company directory contains <br>
    			the mobile data of that company - A kind of abstration which makes searching very easier.
    		</li>
    		<li> As a part of this project a sockect client and socket sever which<br> serves multiple clients are implemented</li>
    		<li> A simple web server is written in python which seves multiple <br>clients using rest API(JSON is used here).</li>
    		<li> The data is crawled from the website gsmarena.com using regex <br> and later regex is substitudes with beatiful soup libray for crawling </li>
    		<li> The database used to store the data is mongodb. In the earlier stages of this project <br>
    			an in memory databse is used. </li>
    		<li>The project is comepletly ported to google app engine cloud and <br>it uses google data store as database management system</li>
    	</ul>
    </p>
    <p> <a href="http://pymobileinfo.appspot.com">Site </a>
    	<img src="https://dl.dropboxusercontent.com/u/109288873/pymobile.png"></p></p>
    

    contributors:

About

This is the Python project.Mobile Device database engine implemented in python using in memory database.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published