{"id":32354,"date":"2025-10-20T20:41:34","date_gmt":"2025-10-20T17:41:34","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/?p=32354"},"modified":"2025-10-20T20:41:34","modified_gmt":"2025-10-20T17:41:34","slug":"sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/","title":{"rendered":"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber"},"content":{"rendered":"<p><body><\/p>\n<h2>Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber<\/h2>\n<p>Node.js, modern web uygulamalar\u0131 geli\u015ftirmek i\u00e7in pop\u00fcler bir sunucu taraf\u0131 JavaScript \u00e7al\u0131\u015fma zaman\u0131d\u0131r. Geli\u015ftiricilere h\u0131zl\u0131, \u00f6l\u00e7eklenebilir ve olay tabanl\u0131 uygulamalar olu\u015fturma imkan\u0131 sunar. Veritaban\u0131 etkile\u015fimi, hemen hemen her web uygulamas\u0131n\u0131n temel bir par\u00e7as\u0131d\u0131r ve bu etkile\u015fimleri y\u00f6netmek i\u00e7in genellikle bir Nesne \u0130li\u015fkisel E\u015fle\u015ftirici (ORM) kullan\u0131l\u0131r. Sequelize, Node.js ekosistemindeki en g\u00fc\u00e7l\u00fc ve yayg\u0131n olarak kullan\u0131lan ORM&#8217;lerden biridir. Bu makalede, Sequelize&#8217;nin Node.js ve MySQL ile nas\u0131l kullan\u0131laca\u011f\u0131n\u0131, kurulumdan ileri seviye konulara kadar detayl\u0131 bir \u015fekilde inceleyece\u011fiz.<\/p>\n<h3>Giri\u015f: Sequelize Nedir ve Neden Kullan\u0131l\u0131r?<\/h3>\n<p>Sequelize, Node.js i\u00e7in Promise tabanl\u0131 bir ORM&#8217;dir. MySQL, PostgreSQL, SQLite ve MSSQL gibi \u00e7e\u015fitli ili\u015fkisel veritabanlar\u0131n\u0131 destekler. Bir ORM, uygulama kodundaki nesneler ile veritaban\u0131ndaki tablolar aras\u0131nda bir k\u00f6pr\u00fc g\u00f6revi g\u00f6r\u00fcr. Bu sayede geli\u015ftiriciler, do\u011frudan SQL sorgular\u0131 yazmak yerine, JavaScript nesneleri ve metotlar\u0131 arac\u0131l\u0131\u011f\u0131yla veritaban\u0131 i\u015flemlerini ger\u00e7ekle\u015ftirebilirler.<\/p>\n<p>Sequelize kullanman\u0131n ba\u015fl\u0131ca avantajlar\u0131 \u015funlard\u0131r:<br \/>\n*   <strong>Soyutlama:<\/strong> SQL sorgular\u0131 yazma ihtiyac\u0131n\u0131 azalt\u0131r, veritaban\u0131 i\u015flemlerini daha anla\u015f\u0131l\u0131r ve y\u00f6netilebilir JavaScript kodu ile yapmay\u0131 sa\u011flar.<br \/>\n*   <strong>Veritaban\u0131 Ba\u011f\u0131ms\u0131zl\u0131\u011f\u0131:<\/strong> Uygulama kodu, temel veritaban\u0131 sisteminden (MySQL, PostgreSQL vb.) soyutlan\u0131r. Veritaban\u0131n\u0131 de\u011fi\u015ftirmek gerekti\u011finde, kodda minimal de\u011fi\u015fiklikler yeterli olur.<br \/>\n*   <strong>Geli\u015ftirme H\u0131z\u0131:<\/strong> Modelleri, ili\u015fkileri ve migrasyonlar\u0131 y\u00f6netmek i\u00e7in g\u00fc\u00e7l\u00fc ara\u00e7lar sunarak geli\u015ftirme s\u00fcrecini h\u0131zland\u0131r\u0131r.<br \/>\n*   <strong>G\u00fcvenlik:<\/strong> SQL enjeksiyonu gibi yayg\u0131n g\u00fcvenlik a\u00e7\u0131klar\u0131na kar\u015f\u0131 koruma sa\u011flar.<br \/>\n*   <strong>Bak\u0131m Kolayl\u0131\u011f\u0131:<\/strong> Kodun daha d\u00fczenli ve okunabilir olmas\u0131n\u0131 sa\u011flayarak uzun vadeli bak\u0131m\u0131 kolayla\u015ft\u0131r\u0131r.<br \/>\n*   <strong>Validasyon ve Hook&#8217;lar:<\/strong> Veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flamak i\u00e7in g\u00fc\u00e7l\u00fc validasyon mekanizmalar\u0131 ve ya\u015fam d\u00f6ng\u00fcs\u00fc hook&#8217;lar\u0131 sunar.<\/p>\n<p>Bu makalede, Node.js projesi i\u00e7inde Sequelize&#8217;yi MySQL veritaban\u0131 ile ad\u0131m ad\u0131m nas\u0131l kuraca\u011f\u0131m\u0131z\u0131, modelleri nas\u0131l tan\u0131mlayaca\u011f\u0131m\u0131z\u0131, CRUD i\u015flemlerini nas\u0131l yapaca\u011f\u0131m\u0131z\u0131, ili\u015fkileri nas\u0131l y\u00f6netece\u011fimizi ve ileri seviye baz\u0131 konular\u0131 ele alaca\u011f\u0131z.<\/p>\n<h3>Ortam Kurulumu ve Proje Ba\u015flatma<\/h3>\n<p>Sequelize ile \u00e7al\u0131\u015fmaya ba\u015flamadan \u00f6nce, sisteminizde Node.js, npm (Node.js ile birlikte gelir) ve MySQL&#8217;in kurulu oldu\u011fundan emin olmal\u0131s\u0131n\u0131z.<\/p>\n<h4>Node.js ve npm Kurulumu<\/h4>\n<p>E\u011fer kurulu de\u011filse, Node.js&#8217;in resmi web sitesinden (nodejs.org) indirip kurabilirsiniz. Kurulum tamamland\u0131ktan sonra, terminalinizde a\u015fa\u011f\u0131daki komutlar\u0131 \u00e7al\u0131\u015ft\u0131rarak kurulumu do\u011frulayabilirsiniz:<\/p>\n<pre><code class=\"language-bash\">node -v\nnpm -v<\/code><\/pre>\n<h4>MySQL Kurulumu<\/h4>\n<p>MySQL&#8217;i yerel makinenize kurmak i\u00e7in farkl\u0131 yollar vard\u0131r:<br \/>\n*   <strong>Do\u011frudan Kurulum:<\/strong> MySQL&#8217;in resmi web sitesinden (mysql.com) indirip i\u015fletim sisteminize uygun \u015fekilde kurabilirsiniz.<br \/>\n*   <strong>XAMPP\/WAMP\/MAMP:<\/strong> Bu paketler, MySQL&#8217;i Apache ve PHP ile birlikte kurarak h\u0131zl\u0131 bir geli\u015ftirme ortam\u0131 sa\u011flar.<br \/>\n*   <strong>Docker:<\/strong> Geli\u015ftirme ortam\u0131n\u0131z\u0131 izole etmek i\u00e7in Docker kullanabilirsiniz.<\/p>\n<p>Kurulumdan sonra, MySQL sunucunuzun \u00e7al\u0131\u015ft\u0131\u011f\u0131ndan ve bir kullan\u0131c\u0131 ad\u0131 (genellikle <code>root<\/code>) ile \u015fifreniz oldu\u011fundan emin olun. Ayr\u0131ca, Sequelize&#8217;nin ba\u011flanaca\u011f\u0131 bir veritaban\u0131 olu\u015fturman\u0131z gerekecektir. \u00d6rne\u011fin, <code>my_database<\/code> ad\u0131nda bir veritaban\u0131 olu\u015fturabilirsiniz.<\/p>\n<h4>Yeni Bir Node.js Projesi Olu\u015fturma<\/h4>\n<p>Bo\u015f bir dizin olu\u015fturun ve terminalde o dizine gidin:<\/p>\n<pre><code class=\"language-bash\">mkdir sequelize-mysql-app\ncd sequelize-mysql-app<\/code><\/pre>\n<p>\u015eimdi, <code>npm init<\/code> komutu ile yeni bir Node.js projesi ba\u015flat\u0131n. Bu komut, projeniz i\u00e7in <code>package.json<\/code> dosyas\u0131n\u0131 olu\u015fturacakt\u0131r. Varsay\u0131lan de\u011ferleri kabul etmek i\u00e7in bir\u00e7ok kez Enter tu\u015funa basabilirsiniz.<\/p>\n<pre><code class=\"language-bash\">npm init -y<\/code><\/pre>\n<h4>Gerekli Paketlerin Y\u00fcklenmesi<\/h4>\n<p>Sequelize&#8217;yi ve MySQL ile etkile\u015fim kurmak i\u00e7in gerekli s\u00fcr\u00fcc\u00fcy\u00fc y\u00fcklemeliyiz. Ayr\u0131ca, Sequelize CLI (komut sat\u0131r\u0131 aray\u00fcz\u00fc) ve ortam de\u011fi\u015fkenlerini y\u00f6netmek i\u00e7in <code>dotenv<\/code> paketlerini de y\u00fckleyece\u011fiz.<\/p>\n<pre><code class=\"language-bash\">npm install sequelize mysql2 sequelize-cli dotenv<\/code><\/pre>\n<p>*   <code>sequelize<\/code>: Sequelize ORM&#8217;nin ana paketi.<br \/>\n*   <code>mysql2<\/code>: MySQL veritaban\u0131 i\u00e7in Node.js s\u00fcr\u00fcc\u00fcs\u00fc. Sequelize, veritaban\u0131 ile ileti\u015fim kurmak i\u00e7in bu s\u00fcr\u00fcc\u00fcy\u00fc kullan\u0131r.<br \/>\n*   <code>sequelize-cli<\/code>: Sequelize komut sat\u0131r\u0131 aray\u00fcz\u00fc, migrasyonlar, modeller ve seed&#8217;ler olu\u015fturmak ve y\u00f6netmek i\u00e7in kullan\u0131l\u0131r.<br \/>\n*   <code>dotenv<\/code>: Ortam de\u011fi\u015fkenlerini <code>.env<\/code> dosyas\u0131ndan y\u00fcklemek i\u00e7in kullan\u0131l\u0131r. Hassas bilgileri (veritaban\u0131 kimlik bilgileri gibi) koddan ay\u0131rmak i\u00e7in \u00f6nemlidir.<\/p>\n<h3>Veritaban\u0131 Ba\u011flant\u0131s\u0131 ve Yap\u0131land\u0131rma<\/h3>\n<p>Veritaban\u0131 ba\u011flant\u0131s\u0131, bir Sequelize uygulamas\u0131n\u0131n ilk ve en \u00f6nemli ad\u0131m\u0131d\u0131r.<\/p>\n<h4>.env Dosyas\u0131n\u0131n Olu\u015fturulmas\u0131<\/h4>\n<p>Proje k\u00f6k dizininizde <code>.env<\/code> ad\u0131nda bir dosya olu\u015fturun ve veritaban\u0131 kimlik bilgilerinizi buraya ekleyin:<\/p>\n<pre><code class=\"language-env\">DB_DATABASE=my_database\nDB_USERNAME=root\nDB_PASSWORD=your_mysql_password\nDB_HOST=localhost\nDB_DIALECT=mysql<\/code><\/pre>\n<p><code>your_mysql_password<\/code> yerine kendi MySQL \u015fifrenizi yazmay\u0131 unutmay\u0131n.<\/p>\n<h4>Sequelize CLI Yap\u0131land\u0131rmas\u0131<\/h4>\n<p><code>sequelize-cli<\/code>&#8216;yi ba\u015flatmak i\u00e7in a\u015fa\u011f\u0131daki komutu kullan\u0131n:<\/p>\n<pre><code class=\"language-bash\">npx sequelize-cli init<\/code><\/pre>\n<p>Bu komut, projenizde <code>config<\/code>, <code>migrations<\/code>, <code>models<\/code> ve <code>seeders<\/code> ad\u0131nda dizinler olu\u015fturacakt\u0131r. <code>config\/config.json<\/code> dosyas\u0131, Sequelize CLI&#8217;nin veritaban\u0131 ba\u011flant\u0131 bilgilerini saklad\u0131\u011f\u0131 yerdir. <code>config\/config.json<\/code> dosyas\u0131n\u0131 <code>dotenv<\/code> ile entegre etmek i\u00e7in a\u015fa\u011f\u0131daki gibi d\u00fczenleyin:<\/p>\n<pre><code class=\"language-json\">\/\/ config\/config.json\n{\n  \"development\": {\n    \"username\": process.env.DB_USERNAME,\n    \"password\": process.env.DB_PASSWORD,\n    \"database\": process.env.DB_DATABASE,\n    \"host\": process.env.DB_HOST,\n    \"dialect\": process.env.DB_DIALECT\n  },\n  \"test\": {\n    \"username\": process.env.DB_USERNAME,\n    \"password\": process.env.DB_PASSWORD,\n    \"database\": process.env.DB_DATABASE + \"_test\",\n    \"host\": process.env.DB_HOST,\n    \"dialect\": process.env.DB_DIALECT\n  },\n  \"production\": {\n    \"username\": process.env.DB_USERNAME,\n    \"password\": process.env.DB_PASSWORD,\n    \"database\": process.env.DB_DATABASE + \"_production\",\n    \"host\": process.env.DB_HOST,\n    \"dialect\": process.env.DB_DIALECT\n  }\n}<\/code><\/pre>\n<p>Bu yap\u0131land\u0131rma, ortam de\u011fi\u015fkenlerini do\u011frudan kullan\u0131r. <code>process.env<\/code> de\u011fi\u015fkenlerine eri\u015febilmek i\u00e7in, sunucu taraf\u0131 kodunuzun ba\u015f\u0131nda <code>dotenv<\/code>&#8216;i y\u00fcklemeniz gerekecektir.<\/p>\n<h4>Sequelize \u00d6rne\u011finin Olu\u015fturulmas\u0131 ve Ba\u011flant\u0131n\u0131n Test Edilmesi<\/h4>\n<p>\u015eimdi, Sequelize ba\u011flant\u0131s\u0131n\u0131 kuracak bir dosya olu\u015ftural\u0131m. \u00d6rne\u011fin, <code>src\/models\/index.js<\/code> (veya <code>models\/index.js<\/code> e\u011fer <code>src<\/code> dizini kullanm\u0131yorsan\u0131z) ad\u0131nda bir dosya olu\u015fturun:<\/p>\n<pre><code class=\"language-javascript\">\/\/ models\/index.js\nrequire('dotenv').config(); \/\/ .env dosyas\u0131n\u0131 y\u00fckle\n\nconst { Sequelize } = require('sequelize');\nconst config = require(__dirname + '\/..\/config\/config.json').development; \/\/ Geli\u015ftirme ortam\u0131n\u0131 kullan\n\nconst sequelize = new Sequelize(config.database, config.username, config.password, {\n  host: config.host,\n  dialect: config.dialect,\n  logging: false \/\/ Konsola SQL sorgular\u0131n\u0131 yazd\u0131rmay\u0131 kapat\n});\n\n\/\/ Veritaban\u0131 ba\u011flant\u0131s\u0131n\u0131 test et\nasync function testConnection() {\n  try {\n    await sequelize.authenticate();\n    console.log('Veritaban\u0131 ba\u011flant\u0131s\u0131 ba\u015far\u0131yla kuruldu.');\n  } catch (error) {\n    console.error('Veritaban\u0131 ba\u011flant\u0131s\u0131 kurulamad\u0131:', error);\n  }\n}\n\ntestConnection();\n\n\/\/ Modelleri d\u0131\u015fa aktarmak i\u00e7in bir obje olu\u015fturaca\u011f\u0131z\nconst db = {};\ndb.sequelize = sequelize;\ndb.Sequelize = Sequelize;\n\n\/\/ Modelleri buraya ekleyece\u011fiz (bir sonraki b\u00f6l\u00fcmde)\n\/\/ db.User = require('.\/user')(sequelize, Sequelize);\n\nmodule.exports = db;<\/code><\/pre>\n<p>Bu dosya, Sequelize \u00f6rne\u011fini olu\u015fturur ve veritaban\u0131 ba\u011flant\u0131s\u0131n\u0131 test eder. <code>logging: false<\/code> se\u00e7ene\u011fi, Sequelize&#8217;nin her SQL sorgusunu konsola yazd\u0131rmas\u0131n\u0131 engeller, bu genellikle geli\u015ftirme a\u015famas\u0131nda faydal\u0131 olsa da \u00fcretimde kapat\u0131lmas\u0131 tercih edilir.<\/p>\n<h3>Modelleri Tan\u0131mlama<\/h3>\n<p>Modeller, veritaban\u0131 tablolar\u0131n\u0131z\u0131n JavaScript kar\u015f\u0131l\u0131\u011f\u0131d\u0131r. Her model, bir veritaban\u0131 tablosunu temsil eder ve o tablodaki her bir s\u00fctun, modelin bir niteli\u011fi (attribute) olur.<\/p>\n<h4><code>sequelize-cli<\/code> ile Model Olu\u015fturma<\/h4>\n<p>Yeni bir model olu\u015fturmak i\u00e7in <code>sequelize-cli<\/code> kullanmak en iyi yoldur. \u00d6rne\u011fin, <code>User<\/code> ad\u0131nda bir model olu\u015ftural\u0131m:<\/p>\n<pre><code class=\"language-bash\">npx sequelize-cli model:generate --name User --attributes firstName:string,lastName:string,email:string,password:string<\/code><\/pre>\n<p>Bu komut, <code>models\/user.js<\/code> ad\u0131nda bir model dosyas\u0131 ve <code>migrations\/<\/code> dizininde ilgili bir migrasyon dosyas\u0131 olu\u015fturacakt\u0131r.<\/p>\n<p><code>models\/user.js<\/code> dosyas\u0131 \u015f\u00f6yle g\u00f6r\u00fcnecektir:<\/p>\n<pre><code class=\"language-javascript\">\/\/ models\/user.js\n'use strict';\nconst {\n  Model\n} = require('sequelize');\nmodule.exports = (sequelize, DataTypes) => {\n  class User extends Model {\n    \/<em><\/em>\n     * Helper method for defining associations.\n     * This method is not a part of Sequelize lifecycle.\n     * The <code>models\/index<\/code> file will call this method automatically.\n     *\/\n    static associate(models) {\n      \/\/ define association here\n    }\n  }\n  User.init({\n    firstName: DataTypes.STRING,\n    lastName: DataTypes.STRING,\n    email: {\n      type: DataTypes.STRING,\n      unique: true, \/\/ E-posta adresinin benzersiz olmas\u0131n\u0131 sa\u011flar\n      allowNull: false, \/\/ E-posta adresinin bo\u015f olmamas\u0131n\u0131 sa\u011flar\n      validate: {\n        isEmail: true \/\/ E-posta format\u0131n\u0131 do\u011frular\n      }\n    },\n    password: {\n      type: DataTypes.STRING,\n      allowNull: false\n    }\n  }, {\n    sequelize,\n    modelName: 'User',\n    tableName: 'users', \/\/ Tablo ad\u0131n\u0131 a\u00e7\u0131k\u00e7a belirtmek iyi bir pratiktir\n    timestamps: true, \/\/ createdAt ve updatedAt s\u00fctunlar\u0131n\u0131 otomatik ekler\n    paranoid: true \/\/ deletedAt s\u00fctununu ekler ve \"soft delete\" sa\u011flar\n  });\n  return User;\n};<\/code><\/pre>\n<p>Model tan\u0131m\u0131nda dikkat edilmesi gerekenler:<br \/>\n*   <strong><code>User.init()<\/code>:<\/strong> Modelin niteliklerini (s\u00fctunlar\u0131) ve se\u00e7eneklerini tan\u0131mlad\u0131\u011f\u0131m\u0131z yerdir.<br \/>\n*   <strong><code>DataTypes<\/code>:<\/strong> Sequelize taraf\u0131ndan sa\u011flanan veri tipleri (STRING, INTEGER, BOOLEAN, DATE vb.).<br \/>\n*   <strong>Nitelik Se\u00e7enekleri:<\/strong><br \/>\n    *   <code>unique: true<\/code>: S\u00fctunun de\u011ferlerinin benzersiz olmas\u0131n\u0131 sa\u011flar.<br \/>\n    *   <code>allowNull: false<\/code>: S\u00fctunun bo\u015f (NULL) olmamas\u0131n\u0131 sa\u011flar.<br \/>\n    *   <code>validate: { isEmail: true }<\/code>: Veri giri\u015finde e-posta format\u0131 do\u011frulamas\u0131 yapar.<br \/>\n*   <strong>Model Se\u00e7enekleri:<\/strong><br \/>\n    *   <code>sequelize<\/code>: Ba\u011flant\u0131 \u00f6rne\u011fi.<br \/>\n    *   <code>modelName<\/code>: Modelin ad\u0131 (PascalCase).<br \/>\n    *   <code>tableName<\/code>: Veritaban\u0131ndaki tablonun ad\u0131 (kebab-case veya snake_case). Sequelize varsay\u0131lan olarak model ad\u0131n\u0131n \u00e7o\u011fulunu kullan\u0131r, ancak a\u00e7\u0131k\u00e7a belirtmek daha g\u00fcvenlidir.<br \/>\n    *   <code>timestamps: true<\/code>: <code>createdAt<\/code> ve <code>updatedAt<\/code> ad\u0131nda iki s\u00fctunu otomatik olarak ekler ve y\u00f6netir.<br \/>\n    *   <code>paranoid: true<\/code>: <code>deletedAt<\/code> ad\u0131nda bir s\u00fctun ekler. Bir kay\u0131t silindi\u011finde, asl\u0131nda veritaban\u0131ndan silinmez, sadece <code>deletedAt<\/code> s\u00fctunu doldurulur (soft delete).<\/p>\n<p>Son olarak, <code>models\/index.js<\/code> dosyas\u0131n\u0131 g\u00fcncelleyerek olu\u015fturdu\u011funuz modeli y\u00fcklemeniz gerekir:<\/p>\n<pre><code class=\"language-javascript\">\/\/ models\/index.js\n\/\/ ... (mevcut kodlar) ...\n\nconst db = {};\ndb.sequelize = sequelize;\ndb.Sequelize = Sequelize;\n\n\/\/ Modelleri dinamik olarak y\u00fckle\nfs.readdirSync(__dirname)\n  .filter(file => {\n    return (\n      file.indexOf('.') !== 0 &&\n      file !== basename &&\n      file.slice(-3) === '.js' &&\n      file.indexOf('.test.js') === -1\n    );\n  })\n  .forEach(file => {\n    const model = require(path.join(__dirname, file))(sequelize, Sequelize.DataTypes);\n    db[model.name] = model;\n  });\n\nObject.keys(db).forEach(modelName => {\n  if (db[modelName].associate) {\n    db[modelName].associate(db);\n  }\n});\n\nmodule.exports = db;<\/code><\/pre>\n<p>Bu kod par\u00e7as\u0131, <code>models<\/code> dizinindeki t\u00fcm model dosyalar\u0131n\u0131 otomatik olarak y\u00fckler ve ili\u015fkileri (associate metodu) tan\u0131mlar.<\/p>\n<h3>Veritaban\u0131 Migrasyonlar\u0131<\/h3>\n<p>Migrasyonlar, veritaban\u0131 \u015feman\u0131zdaki de\u011fi\u015fiklikleri (tablo olu\u015fturma, s\u00fctun ekleme\/\u00e7\u0131karma vb.) versiyon kontrol\u00fc alt\u0131nda tutman\u0131z\u0131 sa\u011flayan betiklerdir. Bu, tak\u0131m ortam\u0131nda \u00e7al\u0131\u015f\u0131rken veya \u00fcretim ortam\u0131na da\u011f\u0131t\u0131m yaparken \u00e7ok \u00f6nemlidir.<\/p>\n<h4>Migrasyon Olu\u015fturma ve \u00c7al\u0131\u015ft\u0131rma<\/h4>\n<p><code>sequelize-cli model:generate<\/code> komutu, modeli olu\u015ftururken ayn\u0131 zamanda bir migrasyon dosyas\u0131 da olu\u015fturmu\u015ftu. \u015eimdi bu migrasyon dosyas\u0131n\u0131 inceleyelim:<\/p>\n<pre><code class=\"language-javascript\">\/\/ migrations\/XXXXXXXXXXXXXX-create-user.js\n'use strict';\n\/<em><\/em> @type {import('sequelize-cli').Migration} *\/\nmodule.exports = {\n  async up(queryInterface, Sequelize) {\n    await queryInterface.createTable('Users', {\n      id: {\n        allowNull: false,\n        autoIncrement: true,\n        primaryKey: true,\n        type: Sequelize.INTEGER\n      },\n      firstName: {\n        type: Sequelize.STRING\n      },\n      lastName: {\n        type: Sequelize.STRING\n      },\n      email: {\n        type: Sequelize.STRING,\n        unique: true,\n        allowNull: false\n      },\n      password: {\n        type: Sequelize.STRING,\n        allowNull: false\n      },\n      createdAt: {\n        allowNull: false,\n        type: Sequelize.DATE\n      },\n      updatedAt: {\n        allowNull: false,\n        type: Sequelize.DATE\n      },\n      deletedAt: { \/\/ paranoid: true oldu\u011fu i\u00e7in bu s\u00fctunu ekledik\n        type: Sequelize.DATE\n      }\n    });\n  },\n  async down(queryInterface, Sequelize) {\n    await queryInterface.dropTable('Users');\n  }\n};<\/code><\/pre>\n<p>*   <strong><code>up<\/code> metodu:<\/strong> Migrasyonun uygulanmas\u0131 durumunda \u00e7al\u0131\u015facak kodlar\u0131 i\u00e7erir (\u00f6rne\u011fin, tablo olu\u015fturma).<br \/>\n*   <strong><code>down<\/code> metodu:<\/strong> Migrasyonun geri al\u0131nmas\u0131 durumunda \u00e7al\u0131\u015facak kodlar\u0131 i\u00e7erir (\u00f6rne\u011fin, tablo silme).<\/p>\n<p>Migrasyonu \u00e7al\u0131\u015ft\u0131rmak ve <code>Users<\/code> tablosunu veritaban\u0131nda olu\u015fturmak i\u00e7in:<\/p>\n<pre><code class=\"language-bash\">npx sequelize-cli db:migrate<\/code><\/pre>\n<p>Bu komut, veritaban\u0131n\u0131zda <code>SequelizeMeta<\/code> ad\u0131nda bir tablo olu\u015fturacak ve uygulanan migrasyonlar\u0131 kaydedecektir.<\/p>\n<h4>Migrasyonu Geri Alma<\/h4>\n<p>E\u011fer bir migrasyonu geri almak isterseniz:<\/p>\n<pre><code class=\"language-bash\">npx sequelize-cli db:migrate:undo # Son migrasyonu geri al\u0131r\nnpx sequelize-cli db:migrate:undo:all # T\u00fcm migrasyonlar\u0131 geri al\u0131r<\/code><\/pre>\n<h3>Temel CRUD \u0130\u015flemleri<\/h3>\n<p>CRUD (Create, Read, Update, Delete) i\u015flemleri, bir uygulaman\u0131n veritaban\u0131 ile etkile\u015fiminin temelini olu\u015fturur.<\/p>\n<h4>Veri Ekleme (Create)<\/h4>\n<p>Bir model \u00f6rne\u011fi olu\u015fturmak ve veritaban\u0131na kaydetmek i\u00e7in <code>create()<\/code> metodunu kullan\u0131r\u0131z:<\/p>\n<pre><code class=\"language-javascript\">\/\/ app.js veya bir controller dosyas\u0131\nconst db = require('.\/models'); \/\/ models\/index.js dosyas\u0131n\u0131 import et\n\nasync function createUser() {\n  try {\n    const newUser = await db.User.create({\n      firstName: 'John',\n      lastName: 'Doe',\n      email: 'john.doe@example.com',\n      password: 'hashedpassword123' \/\/ \u015eifre hashlenmelidir!\n    });\n    console.log('Yeni kullan\u0131c\u0131 olu\u015fturuldu:', newUser.toJSON());\n\n    \/\/ Birden fazla kay\u0131t ekleme\n    await db.User.bulkCreate([\n      { firstName: 'Jane', lastName: 'Doe', email: 'jane.doe@example.com', password: 'hashedpassword456' },\n      { firstName: 'Peter', lastName: 'Jones', email: 'peter.jones@example.com', password: 'hashedpassword789' }\n    ]);\n    console.log('Birden fazla kullan\u0131c\u0131 eklendi.');\n\n  } catch (error) {\n    console.error('Kullan\u0131c\u0131 olu\u015fturulurken hata olu\u015ftu:', error);\n  }\n}\n\ncreateUser();<\/code><\/pre>\n<p><code>bulkCreate()<\/code> metodu, tek seferde birden fazla kay\u0131t eklemek i\u00e7in kullan\u0131l\u0131r ve genellikle daha performansl\u0131d\u0131r.<\/p>\n<h4>Veri Okuma (Read)<\/h4>\n<p>Veritaban\u0131ndan veri okumak i\u00e7in \u00e7e\u015fitli metotlar mevcuttur:<\/p>\n<pre><code class=\"language-javascript\">async function readUsers() {\n  try {\n    \/\/ T\u00fcm kullan\u0131c\u0131lar\u0131 getir\n    const allUsers = await db.User.findAll();\n    console.log('T\u00fcm kullan\u0131c\u0131lar:', allUsers.map(user => user.toJSON()));\n\n    \/\/ Belirli ko\u015fullara g\u00f6re kullan\u0131c\u0131lar\u0131 getir (WHERE clause)\n    const john = await db.User.findOne({\n      where: {\n        firstName: 'John'\n      }\n    });\n    console.log('John ad\u0131nda kullan\u0131c\u0131:', john ? john.toJSON() : 'Bulunamad\u0131');\n\n    \/\/ ID'ye g\u00f6re kullan\u0131c\u0131y\u0131 getir\n    const userById = await db.User.findByPk(1);\n    console.log('ID 1 olan kullan\u0131c\u0131:', userById ? userById.toJSON() : 'Bulunamad\u0131');\n\n    \/\/ Sadece belirli s\u00fctunlar\u0131 se\u00e7 (attributes) ve s\u0131rala (order)\n    const limitedUsers = await db.User.findAll({\n      attributes: ['firstName', 'email'],\n      where: {\n        lastName: 'Doe'\n      },\n      order: [['firstName', 'ASC']],\n      limit: 1, \/\/ Sadece 1 kay\u0131t getir\n      offset: 0 \/\/ \u0130lk kay\u0131ttan ba\u015fla\n    });\n    console.log('S\u0131n\u0131rl\u0131 kullan\u0131c\u0131lar:', limitedUsers.map(user => user.toJSON()));\n\n  } catch (error) {\n    console.error('Kullan\u0131c\u0131lar okunurken hata olu\u015ftu:', error);\n  }\n}\n\nreadUsers();<\/code><\/pre>\n<p>*   <code>findAll()<\/code>: Belirtilen ko\u015fullara uyan t\u00fcm kay\u0131tlar\u0131 getirir.<br \/>\n*   <code>findOne()<\/code>: Belirtilen ko\u015fullara uyan ilk kayd\u0131 getirir.<br \/>\n*   <code>findByPk()<\/code>: Birincil anahtara (Primary Key) g\u00f6re kayd\u0131 getirir.<br \/>\n*   <strong>Se\u00e7enekler:<\/strong><br \/>\n    *   <code>where<\/code>: SQL <code>WHERE<\/code> ko\u015fulunu tan\u0131mlar.<br \/>\n    *   <code>attributes<\/code>: Sadece belirli s\u00fctunlar\u0131 se\u00e7menizi sa\u011flar.<br \/>\n    *   <code>order<\/code>: Sonu\u00e7lar\u0131 belirli bir s\u00fctuna g\u00f6re s\u0131ralar.<br \/>\n    *   <code>limit<\/code>: Getirilecek kay\u0131t say\u0131s\u0131n\u0131 s\u0131n\u0131rlar.<br \/>\n    *   <code>offset<\/code>: Belirtilen say\u0131daki kayd\u0131 atlayarak sonraki kay\u0131tlardan ba\u015flar (sayfalama i\u00e7in kullan\u0131l\u0131r).<\/p>\n<h4>Veri G\u00fcncelleme (Update)<\/h4>\n<p>Kay\u0131tlar\u0131 g\u00fcncellemek i\u00e7in <code>update()<\/code> metodunu veya bir model \u00f6rne\u011fi \u00fczerinde <code>save()<\/code> metodunu kullanabiliriz:<\/p>\n<pre><code class=\"language-javascript\">async function updateUser() {\n  try {\n    \/\/ Belirli ko\u015fullara g\u00f6re g\u00fcncelleme\n    const [affectedRows] = await db.User.update(\n      { lastName: 'Smith' },\n      {\n        where: {\n          firstName: 'John'\n        }\n      }\n    );\n    console.log(<code>${affectedRows} adet kullan\u0131c\u0131 g\u00fcncellendi.<\/code>);\n\n    \/\/ Bir model \u00f6rne\u011fini g\u00fcncelleyip kaydetme\n    const jane = await db.User.findOne({ where: { email: 'jane.doe@example.com' } });\n    if (jane) {\n      jane.email = 'jane.smith@example.com';\n      await jane.save(); \/\/ G\u00fcncellenen \u00f6rne\u011fi veritaban\u0131na kaydet\n      console.log('Jane kullan\u0131c\u0131s\u0131n\u0131n e-postas\u0131 g\u00fcncellendi:', jane.toJSON());\n    }\n\n  } catch (error) {\n    console.error('Kullan\u0131c\u0131 g\u00fcncellenirken hata olu\u015ftu:', error);\n  }\n}\n\nupdateUser();<\/code><\/pre>\n<p><code>update()<\/code> metodu, <code>where<\/code> ko\u015fulu ile birden fazla kayd\u0131 ayn\u0131 anda g\u00fcncelleyebilir. <code>save()<\/code> metodu ise, \u00f6nceden y\u00fcklenmi\u015f bir model \u00f6rne\u011finin niteliklerini de\u011fi\u015ftirdikten sonra veritaban\u0131na kaydeder.<\/p>\n<h4>Veri Silme (Delete)<\/h4>\n<p>Kay\u0131tlar\u0131 silmek i\u00e7in <code>destroy()<\/code> metodunu kullan\u0131r\u0131z:<\/p>\n<pre><code class=\"language-javascript\">async function deleteUser() {\n  try {\n    \/\/ Belirli ko\u015fullara g\u00f6re silme (soft delete e\u011fer paranoid: true ise)\n    const deletedRows = await db.User.destroy({\n      where: {\n        email: 'peter.jones@example.com'\n      }\n    });\n    console.log(<code>${deletedRows} adet kullan\u0131c\u0131 silindi (soft delete).<\/code>);\n\n    \/\/ E\u011fer ger\u00e7ekten silmek isterseniz (paranoid: true olsa bile)\n    const reallyDeletedRows = await db.User.destroy({\n      where: {\n        email: 'john.doe@example.com'\n      },\n      force: true \/\/ Ger\u00e7ekten siler, deletedAt s\u00fctununu kullanmaz\n    });\n    console.log(<code>${reallyDeletedRows} adet kullan\u0131c\u0131 kal\u0131c\u0131 olarak silindi.<\/code>);\n\n  } catch (error) {\n    console.error('Kullan\u0131c\u0131 silinirken hata olu\u015ftu:', error);\n  }\n}\n\ndeleteUser();<\/code><\/pre>\n<p>E\u011fer modelinizde <code>paranoid: true<\/code> ayar\u0131 varsa, <code>destroy()<\/code> metodu kayd\u0131 ger\u00e7ekten silmek yerine <code>deletedAt<\/code> s\u00fctununu doldurur. Kal\u0131c\u0131 silme i\u015flemi i\u00e7in <code>force: true<\/code> se\u00e7ene\u011fini kullanman\u0131z gerekir.<\/p>\n<h3>Modeller Aras\u0131 \u0130li\u015fkiler (Associations)<\/h3>\n<p>Ger\u00e7ek d\u00fcnya uygulamalar\u0131nda, veritaban\u0131 tablolar\u0131 genellikle birbiriyle ili\u015fkilidir. Sequelize, bu ili\u015fkileri tan\u0131mlamak ve y\u00f6netmek i\u00e7in g\u00fc\u00e7l\u00fc bir yap\u0131 sunar.<\/p>\n<h4>\u0130li\u015fki T\u00fcrleri<\/h4>\n<p>Sequelize d\u00f6rt ana ili\u015fki t\u00fcr\u00fcn\u00fc destekler:<\/p>\n<p>1.  <strong>Bire Bir (One-to-One):<\/strong> Bir modelin bir di\u011fer modelle sadece bir ili\u015fkisi vard\u0131r. \u00d6rne\u011fin, <code>User<\/code>&#8216;\u0131n bir <code>Profile<\/code>&#8216;\u0131 olabilir ve bir <code>Profile<\/code> sadece bir <code>User<\/code>&#8216;a ait olabilir.<br \/>\n    *   <code>hasOne()<\/code>: Kayna\u011f\u0131n hedefle birebir ili\u015fkisi oldu\u011funu belirtir.<br \/>\n    *   <code>belongsTo()<\/code>: Hedefin kaynakla birebir ili\u015fkisi oldu\u011funu belirtir.<\/p>\n<p>2.  <strong>Bire \u00c7ok (One-to-Many):<\/strong> Bir modelin birden \u00e7ok di\u011fer modelle ili\u015fkisi vard\u0131r, ancak di\u011fer modelin sadece bir ili\u015fkisi vard\u0131r. \u00d6rne\u011fin, bir <code>User<\/code>&#8216;\u0131n birden \u00e7ok <code>Post<\/code>&#8216;u olabilir, ancak bir <code>Post<\/code> sadece bir <code>User<\/code>&#8216;a aittir.<br \/>\n    *   <code>hasMany()<\/code>: Kayna\u011f\u0131n hedefle bire \u00e7ok ili\u015fkisi oldu\u011funu belirtir.<br \/>\n    *   <code>belongsTo()<\/code>: Hedefin kaynakla bire \u00e7ok ili\u015fkisi oldu\u011funu belirtir (kayna\u011f\u0131n birincil anahtar\u0131n\u0131 kendi tablosunda tutar).<\/p>\n<p>3.  <strong>\u00c7oka \u00c7ok (Many-to-Many):<\/strong> Her iki modelin de birden \u00e7ok di\u011fer modelle ili\u015fkisi vard\u0131r. \u00d6rne\u011fin, bir <code>Post<\/code>&#8216;un birden \u00e7ok <code>Tag<\/code>&#8216;i olabilir ve bir <code>Tag<\/code> birden \u00e7ok <code>Post<\/code>&#8216;ta bulunabilir. Bu t\u00fcr ili\u015fkiler i\u00e7in genellikle bir ara tablo (junction table) kullan\u0131l\u0131r.<br \/>\n    *   <code>belongsToMany()<\/code>: Her iki modelin de \u00e7oka \u00e7ok ili\u015fkisi oldu\u011funu belirtir.<\/p>\n<h4>\u0130li\u015fkileri Tan\u0131mlama<\/h4>\n<p>\u0130li\u015fkiler, modellerin <code>associate<\/code> metodunda tan\u0131mlan\u0131r.<\/p>\n<p>\u00d6rnek: <code>User<\/code> ve <code>Post<\/code> modelleri (Bire \u00c7ok \u0130li\u015fki)<\/p>\n<p>\u00d6nce <code>Post<\/code> modelini olu\u015ftural\u0131m:<\/p>\n<pre><code class=\"language-bash\">npx sequelize-cli model:generate --name Post --attributes title:string,content:text,userId:integer<\/code><\/pre>\n<p><code>models\/post.js<\/code> dosyas\u0131n\u0131 g\u00fcncelleyelim:<\/p>\n<pre><code class=\"language-javascript\">\/\/ models\/post.js\n'use strict';\nconst {\n  Model\n} = require('sequelize');\nmodule.exports = (sequelize, DataTypes) => {\n  class Post extends Model {\n    static associate(models) {\n      \/\/ Bir Post bir User'a aittir (belongsTo)\n      Post.belongsTo(models.User, {\n        foreignKey: 'userId', \/\/ Post tablosundaki foreign key\n        as: 'author' \/\/ \u0130li\u015fkinin takma ad\u0131\n      });\n    }\n  }\n  Post.init({\n    title: DataTypes.STRING,\n    content: DataTypes.TEXT,\n    userId: {\n      type: DataTypes.INTEGER,\n      allowNull: false \/\/ Bir post'un mutlaka bir yazar\u0131 olmal\u0131\n    }\n  }, {\n    sequelize,\n    modelName: 'Post',\n    tableName: 'posts',\n    timestamps: true,\n    paranoid: true\n  });\n  return Post;\n};<\/code><\/pre>\n<p>\u015eimdi <code>User<\/code> modeline <code>hasMany<\/code> ili\u015fkisini ekleyelim (<code>models\/user.js<\/code>):<\/p>\n<pre><code class=\"language-javascript\">\/\/ models\/user.js\n'use strict';\nconst {\n  Model\n} = require('sequelize');\nmodule.exports = (sequelize, DataTypes) => {\n  class User extends Model {\n    static associate(models) {\n      \/\/ Bir User'\u0131n birden \u00e7ok Post'u vard\u0131r (hasMany)\n      User.hasMany(models.Post, {\n        foreignKey: 'userId',\n        as: 'posts'\n      });\n    }\n  }\n  \/\/ ... (User.init k\u0131sm\u0131) ...\n  return User;\n};<\/code><\/pre>\n<p>Yeni <code>posts<\/code> tablosunu olu\u015fturmak i\u00e7in migrasyonu \u00e7al\u0131\u015ft\u0131r\u0131n:<\/p>\n<pre><code class=\"language-bash\">npx sequelize-cli db:migrate<\/code><\/pre>\n<h4>\u0130li\u015fkili Verileri Sorgulama (<code>include<\/code>)<\/h4>\n<p>\u0130li\u015fkili verileri sorgulamak i\u00e7in <code>include<\/code> se\u00e7ene\u011fini kullan\u0131r\u0131z:<\/p>\n<pre><code class=\"language-javascript\">async function queryAssociations() {\n  try {\n    \/\/ Bir kullan\u0131c\u0131 ve onun t\u00fcm g\u00f6nderilerini getir\n    const userWithPosts = await db.User.findByPk(1, {\n      include: [{\n        model: db.Post,\n        as: 'posts' \/\/ User modelindeki 'as' de\u011feri ile e\u015fle\u015fmeli\n      }]\n    });\n    console.log('Kullan\u0131c\u0131 ve g\u00f6nderileri:', userWithPosts ? userWithPosts.toJSON() : 'Bulunamad\u0131');\n\n    \/\/ Bir g\u00f6nderi ve onun yazar\u0131n\u0131 getir\n    const postWithAuthor = await db.Post.findOne({\n      where: { title: '\u0130lk G\u00f6nderim' },\n      include: [{\n        model: db.User,\n        as: 'author', \/\/ Post modelindeki 'as' de\u011feri ile e\u015fle\u015fmeli\n        attributes: ['firstName', 'lastName', 'email'] \/\/ Sadece belirli yazar bilgilerini getir\n      }]\n    });\n    console.log('G\u00f6nderi ve yazar\u0131:', postWithAuthor ? postWithAuthor.toJSON() : 'Bulunamad\u0131');\n\n    \/\/ \u0130\u00e7 i\u00e7e include (\u00f6rne\u011fin, User -> Post -> Tag)\n    \/\/ Bunun i\u00e7in Tag modelini ve Post-Tag Many-to-Many ili\u015fkisini tan\u0131mlamam\u0131z gerekir.\n  } catch (error) {\n    console.error('\u0130li\u015fkili veriler sorgulan\u0131rken hata olu\u015ftu:', error);\n  }\n}\n\n\/\/ \u00d6nce baz\u0131 \u00f6rnek veriler olu\u015ftural\u0131m\nasync function createSampleData() {\n  await db.User.create({ firstName: 'Alice', lastName: 'Wonder', email: 'alice@example.com', password: 'password1' });\n  await db.Post.create({ title: '\u0130lk G\u00f6nderim', content: 'Bu benim ilk g\u00f6nderim.', userId: 1 });\n  await db.Post.create({ title: '\u0130kinci G\u00f6nderim', content: 'Bu benim ikinci g\u00f6nderim.', userId: 1 });\n}\n\n\/\/ createSampleData().then(() => queryAssociations());<\/code><\/pre>\n<p><code>include<\/code> se\u00e7ene\u011fi, ili\u015fkili modelleri sorguya dahil etmenizi sa\u011flar. <code>as<\/code> anahtar\u0131, ili\u015fkili modelin nas\u0131l adland\u0131r\u0131laca\u011f\u0131n\u0131 belirtir. <code>attributes<\/code> ile sadece belirli s\u00fctunlar\u0131 se\u00e7ebilirsiniz.<\/p>\n<h3>Geli\u015fmi\u015f Konular<\/h3>\n<p>Sequelize, uygulaman\u0131z\u0131n daha sa\u011flam ve esnek olmas\u0131n\u0131 sa\u011flayacak bir\u00e7ok geli\u015fmi\u015f \u00f6zellik sunar.<\/p>\n<h4>Validasyonlar<\/h4>\n<p>Model seviyesinde validasyonlar, veritaban\u0131na kaydedilmeden \u00f6nce verinin ge\u00e7erlili\u011fini kontrol etmenizi sa\u011flar.<\/p>\n<pre><code class=\"language-javascript\">\/\/ models\/user.js (g\u00fcncellenmi\u015f)\n\/\/ ...\n  User.init({\n    firstName: {\n      type: DataTypes.STRING,\n      allowNull: false,\n      validate: {\n        notEmpty: { msg: 'Ad alan\u0131 bo\u015f b\u0131rak\u0131lamaz.' },\n        len: { args: [2, 50], msg: 'Ad en az 2, en fazla 50 karakter olmal\u0131d\u0131r.' }\n      }\n    },\n    email: {\n      type: DataTypes.STRING,\n      unique: { msg: 'Bu e-posta adresi zaten kullan\u0131mda.' },\n      allowNull: false,\n      validate: {\n        isEmail: { msg: 'Ge\u00e7erli bir e-posta adresi giriniz.' }\n      }\n    },\n    password: {\n      type: DataTypes.STRING,\n      allowNull: false,\n      validate: {\n        len: { args: [6, 255], msg: '\u015eifre en az 6 karakter olmal\u0131d\u0131r.' }\n      }\n    }\n  }, {\n    sequelize,\n    modelName: 'User',\n    tableName: 'users'\n  });\n\/\/ ...<\/code><\/pre>\n<p>Sequelize bir\u00e7ok yerle\u015fik validat\u00f6r sunar (<code>notEmpty<\/code>, <code>isEmail<\/code>, <code>len<\/code>, <code>isNumeric<\/code> vb.). Ayr\u0131ca kendi \u00f6zel validasyonlar\u0131n\u0131z\u0131 da yazabilirsiniz.<\/p>\n<h4>Hook&#8217;lar (Ya\u015fam D\u00f6ng\u00fcs\u00fc Olaylar\u0131)<\/h4>\n<p>Hook&#8217;lar, bir modelin ya\u015fam d\u00f6ng\u00fcs\u00fcndeki belirli olaylar (olu\u015fturma, g\u00fcncelleme, silme vb.) s\u0131ras\u0131nda kod \u00e7al\u0131\u015ft\u0131rman\u0131za olanak tan\u0131r. \u00d6rne\u011fin, \u015fifreleri veritaban\u0131na kaydetmeden \u00f6nce hashlemek i\u00e7in kullan\u0131labilir.<\/p>\n<pre><code class=\"language-javascript\">\/\/ models\/user.js (g\u00fcncellenmi\u015f)\nconst bcrypt = require('bcrypt'); \/\/ npm install bcrypt\n\n\/\/ ...\n  User.init({\n    \/\/ ... (nitelikler) ...\n  }, {\n    sequelize,\n    modelName: 'User',\n    tableName: 'users',\n    timestamps: true,\n    paranoid: true,\n    hooks: {\n      beforeCreate: async (user) => {\n        if (user.password) {\n          const salt = await bcrypt.genSalt(10);\n          user.password = await bcrypt.hash(user.password, salt);\n        }\n      },\n      beforeUpdate: async (user) => {\n        if (user.changed('password')) { \/\/ Sadece \u015fifre de\u011fi\u015ftiyse hashle\n          const salt = await bcrypt.genSalt(10);\n          user.password = await bcrypt.hash(user.password, salt);\n        }\n      }\n    }\n  });\n\/\/ ...<\/code><\/pre>\n<p>Bu \u00f6rnekte, <code>beforeCreate<\/code> ve <code>beforeUpdate<\/code> hook&#8217;lar\u0131 kullan\u0131larak, bir kullan\u0131c\u0131 olu\u015fturulmadan veya g\u00fcncellenmeden \u00f6nce \u015fifresi bcrypt ile hashlenir.<\/p>\n<h4>Scope&#8217;lar<\/h4>\n<p>Scope&#8217;lar, model \u00fczerinde tekrar kullan\u0131labilir sorgu tan\u0131mlamalar\u0131d\u0131r. Belirli ko\u015fullara g\u00f6re s\u0131k\u00e7a kullan\u0131lan sorgular\u0131 soyutlaman\u0131za yard\u0131mc\u0131 olur.<\/p>\n<pre><code class=\"language-javascript\">\/\/ models\/post.js (g\u00fcncellenmi\u015f)\n\/\/ ...\n  class Post extends Model {\n    \/\/ ... (associate metodu) ...\n  }\n  Post.init({\n    \/\/ ... (nitelikler) ...\n  }, {\n    sequelize,\n    modelName: 'Post',\n    tableName: 'posts',\n    timestamps: true,\n    paranoid: true,\n    scopes: {\n      published: {\n        where: {\n          publishedAt: {\n            [Sequelize.Op.ne]: null \/\/ publishedAt null olmayan g\u00f6nderiler\n          }\n        }\n      },\n      recent: {\n        order: [['createdAt', 'DESC']],\n        limit: 5\n      },\n      withAuthor: {\n        include: [{\n          model: sequelize.models.User,\n          as: 'author',\n          attributes: ['firstName', 'lastName']\n        }]\n      }\n    }\n  });\n\/\/ ...\n\n\/\/ Kullan\u0131m\u0131:\nasync function getScopedPosts() {\n  const publishedPosts = await db.Post.scope('published').findAll();\n  const recentPosts = await db.Post.scope('recent').findAll();\n  const recentPublishedPostsWithAuthor = await db.Post.scope('published', 'recent', 'withAuthor').findAll();\n}<\/code><\/pre>\n<h4>\u0130\u015flemler (Transactions)<\/h4>\n<p>\u0130\u015flemler, birden fazla veritaban\u0131 i\u015flemini tek bir atomik birim olarak y\u00fcr\u00fctmenizi sa\u011flar. T\u00fcm i\u015flemler ba\u015far\u0131l\u0131 olursa de\u011fi\u015fiklikler kal\u0131c\u0131 olur, aksi takdirde t\u00fcm de\u011fi\u015fiklikler geri al\u0131n\u0131r (rollback).<\/p>\n<pre><code class=\"language-javascript\">async function transferMoney(fromUserId, toUserId, amount) {\n  const t = await db.sequelize.transaction(); \/\/ Yeni bir i\u015flem ba\u015flat\n\n  try {\n    const fromUser = await db.User.findByPk(fromUserId, { transaction: t });\n    const toUser = await db.User.findByPk(toUserId, { transaction: t });\n\n    if (!fromUser || !toUser) {\n      throw new Error('Kullan\u0131c\u0131 bulunamad\u0131.');\n    }\n    if (fromUser.balance < amount) { \/\/ balance s\u00fctunu oldu\u011funu varsayal\u0131m\n      throw new Error('Yetersiz bakiye.');\n    }\n\n    await fromUser.update({ balance: fromUser.balance - amount }, { transaction: t });\n    await toUser.update({ balance: toUser.balance + amount }, { transaction: t });\n\n    await t.commit(); \/\/ \u0130\u015flemi onayla\n    console.log('Para transferi ba\u015far\u0131yla ger\u00e7ekle\u015fti.');\n  } catch (error) {\n    await t.rollback(); \/\/ Hata durumunda i\u015flemi geri al\n    console.error('Para transferi s\u0131ras\u0131nda hata olu\u015ftu:', error.message);\n  }\n}<\/code><\/pre>\n<h4>Raw Queries (Ham Sorgular)<\/h4>\n<p>Sequelize, \u00e7o\u011fu durumda ORM metodlar\u0131 ile yeterli olsa da, bazen \u00e7ok karma\u015f\u0131k veya performans kritik sorgular i\u00e7in ham SQL yazman\u0131z gerekebilir.<\/p>\n<pre><code class=\"language-javascript\">async function rawQueryExample() {\n  try {\n    const [results, metadata] = await db.sequelize.query(\"SELECT * FROM Users WHERE email LIKE '%example.com%'\");\n    console.log('Ham sorgu sonu\u00e7lar\u0131:', results);\n\n    \/\/ Bir INSERT sorgusu \u00e7al\u0131\u015ft\u0131rma\n    await db.sequelize.query(\"INSERT INTO Posts (title, content, userId, createdAt, updatedAt) VALUES (?, ?, ?, NOW(), NOW())\", {\n      replacements: ['Yeni Ba\u015fl\u0131k', 'Yeni \u0130\u00e7erik', 1],\n      type: db.sequelize.QueryTypes.INSERT\n    });\n    console.log('Ham INSERT sorgusu \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131.');\n\n  } catch (error) {\n    console.error('Ham sorgu \u00e7al\u0131\u015ft\u0131r\u0131l\u0131rken hata olu\u015ftu:', error);\n  }\n}<\/code><\/pre>\n<p><code>replacements<\/code> se\u00e7ene\u011fi, SQL enjeksiyonuna kar\u015f\u0131 koruma sa\u011flamak i\u00e7in kullan\u0131l\u0131r. <code>QueryTypes<\/code> ile sorgunun t\u00fcr\u00fcn\u00fc belirtebilirsiniz.<\/p>\n<h4>Seed'ler (Veri Tohumlama)<\/h4>\n<p>Seed'ler, veritaban\u0131n\u0131za ba\u015flang\u0131\u00e7 verileri (\u00f6rne\u011fin, test verileri veya varsay\u0131lan ayarlar) eklemek i\u00e7in kullan\u0131l\u0131r.<\/p>\n<pre><code class=\"language-bash\">npx sequelize-cli seed:generate --name demo-users<\/code><\/pre>\n<p><code>seeders\/XXXXXXXXXXXXXX-demo-users.js<\/code> dosyas\u0131n\u0131 d\u00fczenleyin:<\/p>\n<pre><code class=\"language-javascript\">\/\/ seeders\/XXXXXXXXXXXXXX-demo-users.js\n'use strict';\n\n\/<em><\/em> @type {import('sequelize-cli').Migration} *\/\nmodule.exports = {\n  async up (queryInterface, Sequelize) {\n    await queryInterface.bulkInsert('Users', [{\n      firstName: 'Demo',\n      lastName: 'User',\n      email: 'demo@example.com',\n      password: 'demopassword', \/\/ Ger\u00e7ek uygulamada hashlenmi\u015f \u015fifre olmal\u0131\n      createdAt: new Date(),\n      updatedAt: new Date()\n    }, {\n      firstName: 'Test',\n      lastName: 'User',\n      email: 'test@example.com',\n      password: 'testpassword',\n      createdAt: new Date(),\n      updatedAt: new Date()\n    }], {});\n  },\n\n  async down (queryInterface, Sequelize) {\n    await queryInterface.bulkDelete('Users', null, {});\n  }\n};<\/code><\/pre>\n<p>Seed'leri \u00e7al\u0131\u015ft\u0131rmak i\u00e7in:<\/p>\n<pre><code class=\"language-bash\">npx sequelize-cli db:seed:all<\/code><\/pre>\n<p>Seed'leri geri almak i\u00e7in:<\/p>\n<pre><code class=\"language-bash\">npx sequelize-cli db:seed:undo:all<\/code><\/pre>\n<h3>Hata Y\u00f6netimi ve Loglama<\/h3>\n<p>Hata y\u00f6netimi, sa\u011flam bir uygulaman\u0131n olmazsa olmaz\u0131d\u0131r. Sequelize, \u00e7e\u015fitli hata t\u00fcrleri f\u0131rlat\u0131r ve bunlar\u0131 <code>try-catch<\/code> bloklar\u0131 ile yakalamak \u00f6nemlidir.<\/p>\n<pre><code class=\"language-javascript\">async function handleErrors() {\n  try {\n    \/\/ Benzersiz e-posta k\u0131s\u0131tlamas\u0131n\u0131 ihlal eden bir kullan\u0131c\u0131 olu\u015fturmaya \u00e7al\u0131\u015fal\u0131m\n    await db.User.create({\n      firstName: 'John',\n      lastName: 'Doe',\n      email: 'john.doe@example.com', \/\/ Bu e-posta zaten var\n      password: 'password123'\n    });\n  } catch (error) {\n    if (error.name === 'SequelizeUniqueConstraintError') {\n      console.error('Hata: Bu e-posta adresi zaten kullan\u0131mda.');\n    } else if (error.name === 'SequelizeValidationError') {\n      console.error('Validasyon hatas\u0131:', error.errors.map(err => err.message));\n    } else {\n      console.error('Beklenmeyen bir hata olu\u015ftu:', error);\n    }\n  }\n}<\/code><\/pre>\n<p>Sequelize'nin <code>logging<\/code> se\u00e7ene\u011fi ile SQL sorgular\u0131n\u0131 ve di\u011fer bilgileri loglayabilirsiniz. Kendi \u00f6zel logger'\u0131n\u0131z\u0131 da tan\u0131mlayabilirsiniz.<\/p>\n<pre><code class=\"language-javascript\">\/\/ models\/index.js (g\u00fcncellenmi\u015f)\nconst sequelize = new Sequelize(config.database, config.username, config.password, {\n  host: config.host,\n  dialect: config.dialect,\n  logging: console.log \/\/ SQL sorgular\u0131n\u0131 konsola yazd\u0131r\n  \/\/ logging: (msg) => myCustomLogger.info(msg) \/\/ \u00d6zel bir logger kullan\n});<\/code><\/pre>\n<h3>En \u0130yi Uygulamalar ve \u0130pu\u00e7lar\u0131<\/h3>\n<p>*   <strong>Proje Yap\u0131s\u0131:<\/strong> Modelleri, migrasyonlar\u0131, konfig\u00fcrasyonlar\u0131 ve seed'leri ilgili dizinlerde tutmak projenizi d\u00fczenli tutar. Genellikle bir <code>src<\/code> dizini alt\u0131nda <code>controllers<\/code>, <code>services<\/code>, <code>routes<\/code>, <code>models<\/code> gibi ayr\u0131 dizinler olu\u015fturulur.<br \/>\n*   <strong>G\u00fcvenlik:<\/strong><br \/>\n    *   Hassas bilgileri (veritaban\u0131 \u015fifreleri) <code>.env<\/code> dosyalar\u0131nda tutun ve <code>.gitignore<\/code> dosyas\u0131na ekleyerek versiyon kontrol\u00fcne dahil etmeyin.<br \/>\n    *   Ham SQL sorgular\u0131 kullan\u0131rken <code>replacements<\/code> veya <code>bind<\/code> se\u00e7eneklerini kullanarak SQL enjeksiyonuna kar\u015f\u0131 koruma sa\u011flay\u0131n.<br \/>\n    *   \u015eifreleri her zaman hashleyerek saklay\u0131n.<br \/>\n*   <strong>Performans:<\/strong><br \/>\n    *   Gereksiz yere t\u00fcm verileri \u00e7ekmek yerine <code>attributes<\/code> ile sadece ihtiyac\u0131n\u0131z olan s\u00fctunlar\u0131 se\u00e7in.<br \/>\n    *   \u0130li\u015fkili verileri sorgularken <code>include<\/code> se\u00e7ene\u011fini dikkatli kullan\u0131n. \u00c7ok fazla i\u00e7 i\u00e7e <code>include<\/code> sorgu performans\u0131n\u0131 d\u00fc\u015f\u00fcrebilir (N+1 problemi). Gerekirse <code>eager loading<\/code> (include ile \u00f6nden y\u00fckleme) yerine <code>lazy loading<\/code> (ihtiya\u00e7 an\u0131nda y\u00fckleme) kullan\u0131n.<br \/>\n    *   S\u0131k sorgulanan s\u00fctunlara indeks ekleyin.<br \/>\n    *   B\u00fcy\u00fck veri k\u00fcmeleriyle \u00e7al\u0131\u015f\u0131rken <code>limit<\/code> ve <code>offset<\/code> ile sayfalama uygulay\u0131n.<br \/>\n*   <strong>Bak\u0131m:<\/strong><br \/>\n    *   Migrasyonlar\u0131 d\u00fczenli olarak kullan\u0131n ve her \u015fema de\u011fi\u015fikli\u011fi i\u00e7in yeni bir migrasyon olu\u015fturun.<br \/>\n    *   Model tan\u0131m\u0131nda <code>tableName<\/code> ve ili\u015fkilerde <code>as<\/code> se\u00e7eneklerini a\u00e7\u0131k\u00e7a belirtmek kodun okunabilirli\u011fini art\u0131r\u0131r.<br \/>\n    *   Validasyonlar\u0131 model seviyesinde uygulayarak veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flay\u0131n.<\/p>\n<h3>Sonu\u00e7<\/h3>\n<p>Sequelize, Node.js geli\u015ftiricileri i\u00e7in g\u00fc\u00e7l\u00fc, esnek ve kullan\u0131m\u0131 kolay bir ORM'dir. Bu makalede, Sequelize'nin Node.js ve MySQL ile nas\u0131l kurulaca\u011f\u0131n\u0131, modellerin, migrasyonlar\u0131n ve ili\u015fkilerin nas\u0131l tan\u0131mlanaca\u011f\u0131n\u0131, temel CRUD i\u015flemlerinin nas\u0131l yap\u0131laca\u011f\u0131n\u0131 ve validasyonlar, hook'lar, i\u015flemler, scope'lar gibi ileri seviye konular\u0131 detayl\u0131 bir \u015fekilde inceledik.<\/p>\n<p>Sequelize'yi kullanarak, veritaban\u0131 etkile\u015fimlerinizi daha soyut, g\u00fcvenli ve y\u00f6netilebilir bir \u015fekilde ger\u00e7ekle\u015ftirebilirsiniz. Bu da Node.js uygulamalar\u0131n\u0131z\u0131n geli\u015ftirme s\u00fcrecini h\u0131zland\u0131r\u0131r, kod kalitesini art\u0131r\u0131r ve uzun vadeli bak\u0131m\u0131 kolayla\u015ft\u0131r\u0131r. Umar\u0131m bu kapsaml\u0131 rehber, Sequelize ile Node.js ve MySQL kullanarak g\u00fc\u00e7l\u00fc uygulamalar geli\u015ftirmeniz i\u00e7in sa\u011flam bir temel olu\u015fturmu\u015ftur.<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber\nNode.js, modern web uygulamalar\u0131 geli\u015ftirmek i\u00e7in pop\u00fcler bir sunucu taraf\u0131 Jav","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[138],"tags":[],"class_list":{"0":"post-32354","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-mysql","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber\" \/>\n<meta property=\"og:description\" content=\"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber Node.js, modern web uygulamalar\u0131 geli\u015ftirmek i\u00e7in pop\u00fcler bir sunucu taraf\u0131 Jav\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-20T17:41:34+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"23 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber\",\"datePublished\":\"2025-10-20T17:41:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/\"},\"wordCount\":2559,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"MySQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/\",\"name\":\"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-10-20T17:41:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/","og_locale":"tr_TR","og_type":"article","og_title":"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber","og_description":"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber Node.js, modern web uygulamalar\u0131 geli\u015ftirmek i\u00e7in pop\u00fcler bir sunucu taraf\u0131 Jav","og_url":"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-10-20T17:41:34+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"23 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber","datePublished":"2025-10-20T17:41:34+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/"},"wordCount":2559,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["MySQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/","url":"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/","name":"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-10-20T17:41:34+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/sequelize-ile-node-js-ve-mysql-kullanimi-kapsamli-bir-rehber\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Sequelize ile Node.js ve MySQL Kullan\u0131m\u0131: Kapsaml\u0131 Bir Rehber"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/32354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=32354"}],"version-history":[{"count":1,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/32354\/revisions"}],"predecessor-version":[{"id":32355,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/32354\/revisions\/32355"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=32354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=32354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=32354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}