Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/env python
- import csv
- import sys
- import MySQLdb
- conn = MySQLdb.connect(host= "localhost",
- user="crushlb",
- passwd="password",
- db="crushlb")
- cursor = conn.cursor()
- user_args = []
- perm_args = []
- perms = '(read)(write)(view)(delete)(resume)(share)(slideshow)(rename)(makedir)(deletedir)'
- with open(sys.argv[1], 'rt') as f:
- for id, row in enumerate(csv.reader(f), start = 24):
- username, password, path = row
- user_args.append((id, username, password, 'MainUsers'))
- perm_args.append((id, path, perms))
- insert_users = '''
- INSERT IGNORE INTO `USERS`
- (`userid`, `username`, `password`, `server_group`)
- VALUES (%s, %s, %s, %s)
- '''
- insert_vfs_permissions = '''
- INSERT IGNORE INTO `VFS_PERMISSIONS`
- (`userid`, `path`, `privs`)
- VALUES (%s, %s, %s),
- '''
- cursor.executemany(insert_users,user_args)
- cursor.executemany(insert_vfs_permissions,perm_args)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement