xbns

	-- MySQL dump 10.13  Distrib 5.1.51, for pc-linux-gnu (i686)
--
-- Host: 127.0.0.1    Database: world
-- ------------------------------------------------------
-- Server version	5.1.51-debug-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES latin1 */;

xbns

-- Sakila Sample Database Schema
-- Version 1.0

-- Copyright (c) 2006, 2015, Oracle and/or its affiliates. 
-- All rights reserved.

-- Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

--  * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
--  * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.

xbns

##
#  my_array = list (map (int, input().strip().split())) [:I]
#

## driver variables to test
n = 3
my_array = ' 1 6 8   '

# 1. input()  function - to get user input from STDIN

xbns

Simple Array Sum

Given an array of N integers, can you find the sum of its elements?

Input Format

The first line contains an integer,N ,denoting the size of the array. he second line contains N space-separated integers representing the array's elements.

Output Format

xbns

Problem: Leap Year

An extra day is added to the calendar almost every four years as February 29, and the day is a called a leap year.It corrects the calendar for the fact that our planet takes approximately 365.25 days to orbit the sun.A leap year contains a leap day.

In the Gregorian calendar,three conditions are used to identify leap year:

• The year can be evenly divided by 4, is a leap year unless:
• The year can be evenly divided by 100,it is NOT a leap year.
• The year is also evenly divisible by 400.Then it is a leap year.

This means that in the Gregorian calendar,the years 2000 and 2400 are leap years,while

xbns

Install pytest & requests

# pip install pytest requests

How to run

$  pytest data-driven-testing.py

xbns

Exercise 3 - Select Practise

Create SQL queries to accomplish the following tasks using the fly for less database

1. Select all the records from the price table.

2. Select just the names of all the cities

3. Select the IATA code and details of all the terminals

xbns

Learn SQL

Exercise 1 - Design an Address Book Database

Create a set of tables to store data for an address book(contact) application Bare in mind the following design criteria

1. The application will be used by multiple people so the database should also store a list of users

2. The people(contacts) in the database will be owned by only one user - 1 to 1 relationship

xbns

import requests
import unittest
from pytest_httpserver import HTTPServer
import json

class APITest(unittest.TestCase):
    def test_my_client(self):
        with HTTPServer() as httpserver:
            # set up the server to serve "/"  with the json
            httpserver.expect_request('/content').respond_with_json({'result': 30})

xbns

:: pandoc-docx-md.bat
::
:: Don't show these commands to the user
@ECHO off
:: Set the title of the window
TITLE Convert docx to markdown with Pandoc
:: Select file marker
:selectfile
:: Clear any preexisting filename variables
SET filename=