U [Mhr@sdZddlZddlmZmZddlmZddlZddlm Z eddZ e dkre d e d e d Zed kre re d qe dne ddS)z= Script to fix the users table for the timesheet application N) create_enginetext) load_dotenv)Basec Cs&td}t|}z|}|}z*td|tdtd|WnJt k r}z,| td|WYW5QRWdSd}~XYnXW5QRXtdt j j |d td td td td tdWdSt k r }ztd|WYdSd}~XYnXdS)z.Rename existing users table and create our ownZ DATABASE_URLu5🔄 Renaming existing users table to users_backup...z(ALTER TABLE users RENAME TO users_backupu4✅ Existing users table backed up as 'users_backup'u❌ Error renaming table: FNu2🆕 Creating new users table for timesheet app...)Zbindu)✅ New users table created successfully!u 🎯 Next steps:z;1. Your original users data is safe in 'users_backup' tablez72. You can now register new users for the timesheet appz:3. If needed, you can migrate data from users_backup laterTu ❌ Error: )osgetenvrZconnectZbeginprintZexecuterZcommit ExceptionZrollbackrZmetadataZ create_all)Z database_urlZengineZconnZtranser ./fix_users_table.pyfix_users_table s2   .r __main__z)Users Table Fix for Timesheet Applicationz2==================================================z|This will rename your existing 'users' table to 'users_backup' and create a new one for the timesheet app. Continue? (y/N): yu% 🎉 Users table fixed successfully!u ❌ Failed to fix users tablezOperation cancelled.)__doc__rZ sqlalchemyrrZdotenvrZmodelsZdatabaserr __name__rinputZresponselowerr r r r s   (