t=0
tdb=sqlite3.connect("TemporaryDB.db")
tcur=tdb.cursor()
 
tcur.execute('''SELECT Fase FROM users''')
tfetch0=tcur.fetchall()
l_tfetch0=(tfetch0[t])
tfase_data=(l_tfetch0[0])
tfase_data=int(tfase_data)
 

>>>db=sqlite3.connect("TemporaryDB.db")
>>> cur=db.cursor()
>>> cur.execute("SELECT Fase FROM users")
<sqlite3.Cursor object at 0x632ea0>
>>> fetch=cur.fetchall()
>>> fetch
[(13,), (14,)]
>>> fetch[1]
(14,)
>>> v=fetch[1]
>>> v[0]
14
 

l=0
for l in range(-1, 0):
	try:
		handle=open(var, "r")
		red=handle.read()
		handleold.close()
                l=l+1
		asdf()
	except IOError:
		print("sdfghjkl")

>>> import getpass
>>> from ftplib import FTP
>>> ftp=FTP("nonamewebsite.zxq.net")
>>> getpass=getpass.getpass()
Password: 
>>> ftp.login("nonamewebsite_zxq", getpass)
'230-User nonamewebsite_zxq has group access to:  vhosts  \n230-OK. Current restricted directory is /\n230 0 Kbytes used (0%) - authorized: 6144000 Kb'
>>> ftp.getwelcome()
'220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------\n220-You are user number 45 of 500 allowed.\n220-Local time is now 21:02. Server port: 21.\n220-This is a private system - No anonymous login\n220-IPv6 connections are also welcome on this server.\n220 You will be disconnected after 2 minutes of inactivity.'
>>> ftp.retrlines("LIST")
drwxrwxrwx    2 876654   vhosts       4096 Sep 11 22:16 .
drwxrwxrwx    2 876654   vhosts       4096 Sep 11 22:16 ..
-rw-r--r--    1 876654   vhosts          6 Sep 11 22:16 .ftpquota
-rw-r--r--    1 876654   vhosts        776 Sep 11 22:16 index.html
'226-Options: -a -l \n226 4 matches total'
>>> ftp.delete("index.html")
'250-0 Kbytes used (0%) - authorized: 6144000 Kb\n250 Deleted index.html'
>>> upload_file=open("/index.html", "r")
>>> ftp.storbinary("STOR /index.html", upload_file)
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Library/Frameworks/Python.framework/Versions/3.2/lib/python3.2/ftplib.py", line 473, in storbinary
    conn.sendall(buf)
TypeError: 'str' does not support the buffer interface
>>> files=ftp.dir()
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/Library/Frameworks/Python.framework/Versions/3.2/lib/python3.2/ftplib.py", line 528, in dir
    self.retrlines(cmd, func)
  File "/Library/Frameworks/Python.framework/Versions/3.2/lib/python3.2/ftplib.py", line 439, in retrlines
    with self.transfercmd(cmd) as conn, \
  File "/Library/Frameworks/Python.framework/Versions/3.2/lib/python3.2/ftplib.py", line 379, in transfercmd
    return self.ntransfercmd(cmd, rest)[0]
  File "/Library/Frameworks/Python.framework/Versions/3.2/lib/python3.2/ftplib.py", line 337, in ntransfercmd
    host, port = self.makepasv()
  File "/Library/Frameworks/Python.framework/Versions/3.2/lib/python3.2/ftplib.py", line 315, in makepasv
    host, port = parse227(self.sendcmd('PASV'))
  File "/Library/Frameworks/Python.framework/Versions/3.2/lib/python3.2/ftplib.py", line 836, in parse227
    raise error_reply(resp)
ftplib.error_reply: 200 TYPE is now ASCII'
 

import socket, select
 
s=socket.socket()  
s.bind(("localhost", 9999))  
s.listen(3)  
input=[s]
print("0")
while True:
	inp, out, exc=select.select(input,[] ,[])
	for x in inp:
		if x is s:
			print("1")
			c, addr=s.accept()
			input.append(c)
		else:
			data=s.recv(1024)
			if data:
				dc=bytes.decode(data)
				print(s.getpeername(), " -  ", dc)
				x.send(data)
			else:
				s.close()

import socket
s=socket.socket()
try:
	s.connect(("localhost", 9999))
except socket.error:
	print("Socket error")
 
while True:
	data=input(" >>  ")
	encode=str.encode(data)
	if data=="quit":
		s.close()
		quit()
		print("bye")
	elif data=="get*":
		inp=s.recv(1024)
		dc=bytes.decode(inp)
		print(dc)
	else:
		s.send(encode)

#Cliente
import socket
s=socket.socket()
try:
	s.connect(("localhost", 9999))
except socket.error:
	print("Socket error")
 
while True:
	inp=input(" >>  ")
	encode=str.encode(inp)
	if inp=="quit":
		s.close()
		quit()
		print("bye")
	else:
		s.send(encode)

#Servidor
import socket  
 
s=socket.socket()  
s.bind(("localhost", 9999))  
s.listen(3)  
print("Waiting...")
sc, addr=s.accept()  
print("Socket established")    
while True:
	r=sc.recv(1024)
	dc=bytes.decode(r)
	print(" -  ", dc)
	if r=="quit":
		sc.close()
		s.close()
		quit()

import os
 
# En 'ficheros' se guarda una lista con todos los elementos del directorio
 
ficheros = os.listdir(r'C:\Python27')
 
# Recorremos la lista
# Eliminamos todo lo que NO sea un archivo
 
for i in ficheros:
  if not os.path.isfile(i):
    ficheros.remove(i)

l=[]
n=0
def vi():
	n=0
	while n<len(l):
		print(n, "-", l[n])
		n=n+1
 
ficheros=os.listdir("/Users/Arnau/desktop")
 
 
for i in ficheros:
	if not os.path.isfile(i):
		ficheros.remove(i)
	l.append(i)
	vi()