Example #1
0
def uploadUserAndPhoneInfo(item):
    if not 'phone' in item or not 'address' in item:
        return False
    #pause = raw_input("q2312")
    phone_list = item['phone'].split(";")
    uid = None
    for phone in phone_list:
        res2 = database_execution.queryOne(
            "SELECT uid FROM phone_info WHERE phone = %s", [phone])
        if res2:
            uid = int(res2['uid'])
            break
    if not uid:  #uid does not exists
        flag = False
        for phone in phone_list:
            res4 = database_execution.execute(
                "SELECT * FROM register_info WHERE phone = %s", [phone])
            if res4:
                flag = True
                break
        # if the user has registered, we do not need to add his or her phone number into phone_info
        res5 = database_execution.executeAndGetId(
            "INSERT INTO user_info VALUES ( NULL, %s, %s )",
            [str(item['address']), flag])
        uid = int(res5)  #new uid
        if flag:
            return True
    for phone in phone_list:
        if not database_execution.execute(
                "INSERT INTO phone_info VALUES (NULL, %s, %s, NULL)",
            [uid, phone]):
            #pause = raw_input("adsawd")
            return False
    return True
Example #2
0
def uploadUserAndPhoneInfo(item):
	if not 'phone' in item or not 'address' in item:
		return False
	#pause = raw_input("q2312")
	phone_list = item['phone'].split(";")
	uid = None
	for phone in phone_list:
		res2 = database_execution.queryOne("SELECT uid FROM phone_info WHERE phone = %s", [phone])
		if res2:
			uid = int(res2['uid'])
			break
	if not uid: #uid does not exists
		flag = False
		for phone in phone_list:
			res4 = database_execution.execute("SELECT * FROM register_info WHERE phone = %s", [phone])
			if res4:
				flag = True
				break
		# if the user has registered, we do not need to add his or her phone number into phone_info
		res5 = database_execution.executeAndGetId("INSERT INTO user_info VALUES ( NULL, %s, %s )", [str(item['address']), flag])
		uid = int(res5) #new uid
		if flag:
			return True
	for phone in phone_list:
		if not database_execution.execute("INSERT INTO phone_info VALUES (NULL, %s, %s, NULL)", [uid, phone]):
			#pause = raw_input("adsawd")
			return False
	return True
Example #3
0
def createRegisterInfoTable ():
	res = database_execution.queryOne("""
		SELECT count(*)
		FROM information_schema.TABLES
		WHERE table_name = 'register_info'
		AND TABLE_SCHEMA = 'movingen_lead_info'
		""")
#	print 'res:',res
	if not res['count(*)']:
		database_execution.execute ("""
			CREATE TABLE register_info (
				id INT NOT NULL auto_increment,
				phone CHAR(10) NOT NULL,
				PRIMARY KEY  (`id`)
			)
		""")
		print "a new table register_info is created!"
		return True
	else:
		print "table register_info exists"
		return False
Example #4
0
def createRegisterInfoTable():
    res = database_execution.queryOne("""
		SELECT count(*)
		FROM information_schema.TABLES
		WHERE table_name = 'register_info'
		AND TABLE_SCHEMA = 'movingen_lead_info'
		""")
    #	print 'res:',res
    if not res['count(*)']:
        database_execution.execute("""
			CREATE TABLE register_info (
				id INT NOT NULL auto_increment,
				phone CHAR(10) NOT NULL,
				PRIMARY KEY  (`id`)
			)
		""")
        print "a new table register_info is created!"
        return True
    else:
        print "table register_info exists"
        return False
Example #5
0
def createMessengerTable ():
	res = database_execution.queryOne("""
		SELECT count(*)
		FROM information_schema.TABLES
		WHERE table_name = 'messenger'
		AND TABLE_SCHEMA = 'movingen_lead_info'
		""")
#	print 'res:',res
	if not res['count(*)']:
		database_execution.execute ("""
			CREATE TABLE messenger (
				uid INT NOT NULL,
				date DATE NULL,
				PRIMARY KEY  (`uid`),
				FOREIGN KEY(`uid`) REFERENCES user_info(`uid`)
			)
		""")
		print "a new table messenger is created!"
		return True
	else:
		print "table messenger exists"
		return False
Example #6
0
def createUserInfoTable ():
	res = database_execution.queryOne("""
		SELECT count(*)
		FROM information_schema.TABLES
		WHERE table_name = 'user_info'
		AND TABLE_SCHEMA = 'movingen_lead_info'
		""")
#	print 'res=', res
	if not res['count(*)']:
		database_execution.execute ("""
			CREATE TABLE user_info (
				uid INT NOT NULL auto_increment,
				address VARCHAR(1000) NOT NULL,
				flag BOOL NOT NULL,
				PRIMARY KEY (`uid`)
			);
		""")
		print "a new table user_info is created!"
		return True
	else:
		print "table user_info exists"
		return False
Example #7
0
def createMessengerTable():
    res = database_execution.queryOne("""
		SELECT count(*)
		FROM information_schema.TABLES
		WHERE table_name = 'messenger'
		AND TABLE_SCHEMA = 'movingen_lead_info'
		""")
    #	print 'res:',res
    if not res['count(*)']:
        database_execution.execute("""
			CREATE TABLE messenger (
				uid INT NOT NULL,
				date DATE NULL,
				PRIMARY KEY  (`uid`),
				FOREIGN KEY(`uid`) REFERENCES user_info(`uid`)
			)
		""")
        print "a new table messenger is created!"
        return True
    else:
        print "table messenger exists"
        return False
Example #8
0
def createUserInfoTable():
    res = database_execution.queryOne("""
		SELECT count(*)
		FROM information_schema.TABLES
		WHERE table_name = 'user_info'
		AND TABLE_SCHEMA = 'movingen_lead_info'
		""")
    #	print 'res=', res
    if not res['count(*)']:
        database_execution.execute("""
			CREATE TABLE user_info (
				uid INT NOT NULL auto_increment,
				address VARCHAR(1000) NOT NULL,
				flag BOOL NOT NULL,
				PRIMARY KEY (`uid`)
			);
		""")
        print "a new table user_info is created!"
        return True
    else:
        print "table user_info exists"
        return False
Example #9
0
def createPhoneInfoTable ():
	res = database_execution.queryOne("""
		SELECT count(*)
		FROM information_schema.TABLES
		WHERE table_name = 'phone_info'
		AND TABLE_SCHEMA = 'movingen_lead_info'
		""")
#	print 'res=', res
	if not res['count(*)']:
		database_execution.execute ("""
			CREATE TABLE phone_info (
				id INT NOT NULL auto_increment,
				uid INT NOT NULL,
				phone CHAR(10) NOT NULL,
				carrier VARCHAR(20) NULL,
				PRIMARY KEY (`id`, `phone`),
				FOREIGN KEY(`uid`) REFERENCES user_info(`uid`)
			);
		""")
		print "a new table phone_info is created!"
		return True
	else:
		print "table phone_info exists"
		return False
Example #10
0
def createPhoneInfoTable():
    res = database_execution.queryOne("""
		SELECT count(*)
		FROM information_schema.TABLES
		WHERE table_name = 'phone_info'
		AND TABLE_SCHEMA = 'movingen_lead_info'
		""")
    #	print 'res=', res
    if not res['count(*)']:
        database_execution.execute("""
			CREATE TABLE phone_info (
				id INT NOT NULL auto_increment,
				uid INT NOT NULL,
				phone CHAR(10) NOT NULL,
				carrier VARCHAR(20) NULL,
				PRIMARY KEY (`id`, `phone`),
				FOREIGN KEY(`uid`) REFERENCES user_info(`uid`)
			);
		""")
        print "a new table phone_info is created!"
        return True
    else:
        print "table phone_info exists"
        return False